Using Derby with Java Studio Creator
A few pointers in using the bundled DerbyDB with Java Studio Creator 2 update 1
The Derby database that is bundled with Java Studio Creator lives here
%Creator_Home%/SunAppServer8/derby
User: APP
Password: APP
Port: 21547 (as specified in '%DERBY_HOME%/databases/derby.properties')
The
ij script is the admin interface.
In the ij script set:
set user\password as above
java -Dij.protocol=jdbc:derby: ...
Be sure to check SQL type availability here http://wiki.apache.org/db-derby/SQLvsDerbyFeatures
ij> connect 'mydatabase;create=true';
ij> exit;
ij> connect 'mydatabase';
ij> run 'thesql.txt';
Further Derby documentation here http://db.apache.org/derby/manuals/
Posted at
04:46PM Oct 09, 2006
by Matt Hosanee in Archive |
Facebook
