Difference between revisions of "Base/connectivity/Derby"
From Apache OpenOffice Wiki
< Base | connectivity
Line 4: | Line 4: | ||
'''1.) Embedded''' | '''1.) Embedded''' | ||
− | DataBase URL: '''jdbc:derby:C:\Dokumente und Einstellungen\db-derby-10.5.3.0\bin\DB-TABLE''' | + | *DataBase URL: '''jdbc:derby:C:\Dokumente und Einstellungen\db-derby-10.5.3.0\bin\DB-TABLE''' |
− | JDBC Driver Class: '''org.apache.derby.jdbc.EmbeddedDriver''' | + | *JDBC Driver Class: '''org.apache.derby.jdbc.EmbeddedDriver''' |
'''2.) Network''' | '''2.) Network''' | ||
− | Start the | + | *Start the Network server of Derby. The Default connection is localhost at port 1527 |
− | DataBase URL:derby: '''jdbc:derby://127.0.0.1:1527/Firsttable;create=true''' | + | *DataBase URL:derby: '''jdbc:derby://127.0.0.1:1527/Firsttable;create=true''' |
− | JDBC Driver Class: '''org.apache.derby.jdbc.ClientDriver''' | + | *JDBC Driver Class: '''org.apache.derby.jdbc.ClientDriver''' |
Latest revision as of 01:47, 31 January 2013
Connecting via JDBC
Derby has two JDBC drivers. The Embedded Driver called "org.apache.derby.jdbc.EmbeddedDriver" and the Client-side driver called "org.apache.derby.jdbc.ClientDriver". The first Driver embeds the Derby Database Driver into Java Code. The second Driver connects the Derby Database via network.
1.) Embedded
- DataBase URL: jdbc:derby:C:\Dokumente und Einstellungen\db-derby-10.5.3.0\bin\DB-TABLE
- JDBC Driver Class: org.apache.derby.jdbc.EmbeddedDriver
2.) Network
- Start the Network server of Derby. The Default connection is localhost at port 1527
- DataBase URL:derby: jdbc:derby://127.0.0.1:1527/Firsttable;create=true
- JDBC Driver Class: org.apache.derby.jdbc.ClientDriver
Important: if you want to use the Derby Tool ij, only upper case table names are accepted. It is possible to create tables. It is not possible to insert new records via forms and table data views. But you can use SQL-Statements to insert values into tables.