db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rusty Wright <ru...@berkeley.edu>
Subject Re: Re : what's wrong? can't connect to derby from ant
Date Tue, 24 Apr 2007 17:19:08 GMT
Ok, thanks.

As to why, it's my first time using Derby so I'm using the Eclipse Derby 
plugin/module.  I suppose it's slightly easier since I don't have to 
start Derby before I start Eclipse and can manage it from within Eclipse.


Laurent ROCHE wrote:
> Hi,
>
> Have you tried to run ij to connect to Derby leave the connection opened and run the
ant task ?
>
> It's not a long term solution but that could for debug / testing the problem.
> Just a thought.
>
> Still I am a bit confused what do you mean by "I'm doing this in eclipse" and "When I
start derby in eclipse its console says " ?
> Do you mean you are running derby from Eclipse by lauching the command in Eclipse ?
> What's the point ?
>
> I am using Eclipse and running Derby standalone or embeded in Tomcat ... but never from
Eclipse ? ! ?
>
>  
> Cheers,
> L@u
> The Computing Froggy
>
> ----- Message d'origine ----
> De : "rusty@berkeley.edu" <rusty@berkeley.edu>
> À : ddlutils-user@db.apache.org
> Envoyé le : Mardi, 24 Avril 2007, 8h16mn 25s
> Objet : 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.
>
>
>
>
>
>
>
>
>       
> ___________________________________________________________________________ 
> Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! 
> Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo!
Questions/Réponses 
> http://fr.answers.yahoo.com
>   

-- 
Rusty Wright
UC Berkeley
IS&T Web Applications
510-643-9097  office
925-212-3774  cell


Mime
View raw message