Difference between revisions of "Base/connectivity/Derby"
| Line 1: | Line 1: | ||
| − | + | == Connecting via JDBC == | |
| − | == 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. | 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. | ||
Revision as of 22:21, 20 February 2010
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.
