You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-user@db.apache.org by ru...@berkeley.edu on 2007/04/24 08:16:25 UTC
what's wrong? can't connect to derby from ant
I'm doing this in eclipse but the derby is the network server flavor, not
the embedded one. The output from ant is:
Buildfile: C:\users\rusty\workspace\products\build-ddl.xml
init:
database-setup:
[ddlToDatabase] Read schema file
C:\users\rusty\workspace\products\src\main\resources\ddl\products.xml
BUILD FAILED
C:\users\rusty\workspace\products\build-ddl.xml:12: Could not get a
connection from the datasource
Total time: 1 second
Here's my build-ddl.xml:
<?xml version="1.0" encoding="UTF-8"?>
<project default="database-setup">
<target name="init">
<taskdef
name="ddlToDatabase"
classname="org.apache.ddlutils.task.DdlToDatabaseTask"
/>
</target>
<target name="database-setup" depends="init">
<ddlToDatabase>
<database
driverClassName="org.apache.derby.jdbc.ClientDriver"
url="jdbc:derby://localhost:1527/products"
/>
<fileset dir="src/main/resources/ddl">
<include name="products.xml" />
</fileset>
<writeSchemaToDatabase
failonerror="true"
alterdatabase="true"
/>
</ddlToDatabase>
</target>
</project>
I can connect to derby using the url above using the "ij" interactive
command line sql thing in eclipse.
When I start derby in eclipse its console says:
Apache Derby Network Server - 10.2.2.0 - (485682) started and ready to
accept connections on port 1527 at 2007-04-24 04:16:32.784 GMT
Here is my products.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE database PUBLIC "database"
"http://db.apache.org/torque/dtd/database.dtd">
<database name="products">
<table name="products">
<column
name="sku"
type="VARCHAR"
primaryKey="true"
required="true"
/>
<column
name="name"
type="VARCHAR"
required="true"
/>
</table>
</database>
Ant never seems to get a connection to derby; I can see that derby isn't
creating the directory and database like it does when I do the command at
the ij prompt.
Thanks for your help.