db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Laurent ROCHE <laurent_ro...@yahoo.com>
Subject Re : what's wrong? can't connect to derby from ant
Date Tue, 24 Apr 2007 09:40:17 GMT
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

Mime
View raw message