the <USER> and <USER_PASS> must be set to can log into the database (see the 'derbydev' documentation to set it).
the APP is necesary to can get the tables defined/created by you. if you let the 'jdbc.schema' propery blank you would not get any class generated.
have fun with derby ...
robee
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hi
i successfully used the sql2java v2.6.1 to generate java classes for my derby (Apache Derby 10.1.3.1) database.
jars needed: derby.jar, derbyclient.jar, derbytools.jar, derbynet.jar (the requirements may be deffrent for network or embedded use)
the changes to make it work in a network use is:
-----------------------------------------------------
jdbc.driver=org.apache.derby.jdbc.ClientDriver
jdbc.url=jdbc:derby://<HOST>:<PORT>/<DATABASE_NAME>
jdbc.username=<USER>
jdbc.password=<USER_PASS>
jdbc.schema=APP
generatedkey.retrieve=after
generatedkey.statement=VALUES IDENTITY_VAL_LOCAL()
-----------------------------------------------------
the <USER> and <USER_PASS> must be set to can log into the database (see the 'derbydev' documentation to set it).
the APP is necesary to can get the tables defined/created by you. if you let the 'jdbc.schema' propery blank you would not get any class generated.
have fun with derby ...
robee