I have the problem to create the database with an sql cript.
am acquanted to using Cloudscape_3.6 where i could create the
database by using command line:
The database was being created automatically by ij.
Then i could access the database with java application by specifying
the classpath to clouscape.jar and RmiJdbc.jar and including these files
in the bin classpath of the jdk.
please help how i can go through this.
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
2 replies Latest Post - 2007-04-16T18:14:41Z by Stan
Pinned topic i'm having problems to create a database with an sql script
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2007-04-16T18:14:41Z at 2007-04-16T18:14:41Z by Stan
Jean_Anderson 120000E4UY179 PostsACCEPTED ANSWER
Re: i'm having problems to create a database with an sql script2007-04-12T16:24:33Z in response to SystemAdminHi, Lameck,
With Cloudscape 10 (i.e. Derby) the database gets created in the connection URL with the 'create=true' attribute. Here are a couple resources that might help you:
I hope this helps!
Stan 120000HAGM267 PostsACCEPTED ANSWER
Re: i'm having problems to create a database with an sql script2007-04-16T18:14:41Z in response to SystemAdminI notice you were using CloudConnector which has been replaced by the Derby Network Server. Refer to the Server guide for more information. The scripts related to Network Server (CP-Classpath setting and Start/Stop Server) can be found in the folder:
I'm not sure what this command is:
but you can use:
To execute a connection command and SQL commands stored in the file databaseName.sql