Pages

Tuesday, June 19, 2012

Java DB and ij

1, Java DB, aka Derby, is shipped with Java 6+.
2, ij is the Interactive Scription Tool of Derby.

Common Commands of ij:

ij>connect 'jdbc:derby:/www/jvdb';
ij>show connections;
ij>show tables;
ij>run 'my.sql';
ij>set schema user1;
...CRUD...
ij>help;
ij>describe user1.TABLE1;
ij>disconnect;
ij>exit;

No comments:

Post a Comment