Base/connectivity/Derby

From Apache OpenOffice Wiki
< Base‎ | connectivity
Revision as of 22:20, 20 February 2010 by FrankT (Talk | contribs)

Jump to: navigation, search

== Connecting via JDBC 

==

Derby has to JDBC-Driver. The Embedded Driver called "org.apache.derby.jdbc.EmbeddedDriver" and the "org.apache.derby.jdbc.ClientDriver". The first Driver embedded the Derby Database Driver into Java Code. The second Driver connect 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 Networkserver 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


Importend, if you want to use the Derby Tool ij, name of tables only in upper cases. It is possible to create tables. It is not possible to insert new records via formulars and table data views. But you can use SQL-Statements to insert values.

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Base/connectivity/Derby&oldid=157670"
Personal tools