Derby support

[Neal Dewing]

I am unable to generate classes using the Apache Derby driver. I am running JDK 1.5 and Derby with JDBC 3.0. I have the derby.jar included in the sql2java path.

What should the configuration be for:

- generatedkey.retrieve
- generatedkey.statement

JDBC properties:

jdbc.driver=org.apache.derby.jdbc.EmbeddedDriver
jdbc.url=jdbc:derby:/work/db/sql2java/
jdbc.username=user
jdbc.password=user
jdbc.schema=SQL2JAVA

Result of 'ant generate':
-----------------------------------------------
generate:
     [java] DATABASE: Apache Derby
     [java] Database::loadTables - %
     [java] Database::loadColumns
     [java] Database::loadPrimaryKeys
     [java] Database::loadImportedKeys
     [java] Database::loadManyToMany
     [java] Generating src/java/sql2java/sample/database/Manager.java
-----------------------------------------------

No classes are generated. Any ideas?

Thanks,
Neal

[Alp Sehic]

Hi,

are you sure that the jdbc.url is correct ?...

I think the connection pattern is like

jdbc:derby:databaseName;URLAttributes

...

[Neal Dewing]

Hi Alp,

I have double checked the url paramaters.

This is what I replaced the url with:

jdbc.url=jdbc:derby:/work/db/sql2java/;create=true

- With no luck. Do you require more information?

[Neal Dewing]

Quick question:

What pattern does Derby use to match all tables:

[java] Database::loadTables - %

Could this be the problem?