View source for Base/connectivity/Derby

From Apache OpenOffice Wiki

← Base/connectivity/Derby

You do not have permission to edit this page, for the following reasons:

• The action you have requested is limited to users in the group: Users.
• You must confirm your email address before editing pages. Please set and validate your email address through your user preferences.

---

You can view and copy the source of this page:

== 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. [[Category:Database]]

Return to Base/connectivity/Derby.