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:31:49 GMT
In case it's not clear, this Derby is running standalone, not embedded.  
The eclipse module gives you stuff so that you can start and stop it 
from within eclipse, and perhaps more.

 From outside of eclipse I can telnet to derby on port 1527 (of course I 
can't type anything meaningful at it but I can see its errors from my 
typing what it considers garbage).

Rusty Wright wrote:
> 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