https://wiki.openoffice.org/w/api.php?action=feedcontributions&feedformat=atom&user=FrankT 2026-10-24T15:57:10Z User contributions MediaWiki 1.35.14 https://wiki.openoffice.org/w/index.php?title=Base/connectivity/Derby&diff=157675 2010-02-20T22:25:50Z

<p>FrankT: /* Connecting via JDBC */</p> <hr /> <div>== Connecting via JDBC ==<br /> <br /> Derby has two JDBC-Driver. The Embedded Driver called &quot;org.apache.derby.jdbc.EmbeddedDriver&quot; and the &quot;org.apache.derby.jdbc.ClientDriver&quot;. The first Driver embedded the Derby Database Driver into Java Code. The second Driver connect the Derby Database via network.<br /> <br /> &#039;&#039;&#039;1.) Embedded&#039;&#039;&#039;<br /> DataBase URL: jdbc:derby:C:\Dokumente und Einstellungen\db-derby-10.5.3.0\bin\DB-TABLE;<br /> JDBC Driver Class: org.apache.derby.jdbc.EmbeddedDriver<br /> <br /> &#039;&#039;&#039;2.) Network&#039;&#039;&#039;<br /> Start the Networkserver of Derby. The Default connection is localhost at port 1527<br /> DataBase URL:derby: jdbc:derby://127.0.0.1:1527/Firsttable;create=true<br /> JDBC Driver Class: org.apache.derby.jdbc.ClientDriver<br /> <br /> <br /> Importend, if you want to use the Derby Tool ij, name of tables only in upper cases 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.</div>

FrankT https://wiki.openoffice.org/w/index.php?title=Base/connectivity/Derby&diff=157672 2010-02-20T22:22:54Z

<p>FrankT: /* Connecting via JDBC */</p> <hr /> <div>== Connecting via JDBC ==<br /> <br /> Derby has two JDBC-Driver. The Embedded Driver called &quot;org.apache.derby.jdbc.EmbeddedDriver&quot; and the &quot;org.apache.derby.jdbc.ClientDriver&quot;. The first Driver embedded the Derby Database Driver into Java Code. The second Driver connect the Derby Database via network.<br /> <br /> &#039;&#039;&#039;1.) Embedded&#039;&#039;&#039;<br /> DataBase URL: jdbc:derby:C:\Dokumente und Einstellungen\db-derby-10.5.3.0\bin\DB-TABLE;<br /> JDBC Driver Class: org.apache.derby.jdbc.EmbeddedDriver<br /> <br /> &#039;&#039;&#039;2.) Network&#039;&#039;&#039;<br /> Start the Networkserver of Derby. The Default connection is localhost at port 1527<br /> DataBase URL:derby: jdbc:derby://127.0.0.1:1527/Firsttable;create=true<br /> JDBC Driver Class: org.apache.derby.jdbc.ClientDriver<br /> <br /> <br /> Importend, if you want to use the Derby Tool ij, name of tables only in upper cases accepted. 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 into tables.</div>

FrankT https://wiki.openoffice.org/w/index.php?title=Base/connectivity/Derby&diff=157671 2010-02-20T22:21:35Z

<p>FrankT: </p> <hr /> <div>== Connecting via JDBC ==<br /> <br /> Derby has to JDBC-Driver. The Embedded Driver called &quot;org.apache.derby.jdbc.EmbeddedDriver&quot; and the &quot;org.apache.derby.jdbc.ClientDriver&quot;. The first Driver embedded the Derby Database Driver into Java Code. The second Driver connect the Derby Database via network.<br /> <br /> &#039;&#039;&#039;1.) Embedded&#039;&#039;&#039;<br /> DataBase URL: jdbc:derby:C:\Dokumente und Einstellungen\db-derby-10.5.3.0\bin\DB-TABLE;<br /> JDBC Driver Class: org.apache.derby.jdbc.EmbeddedDriver<br /> <br /> &#039;&#039;&#039;2.) Network&#039;&#039;&#039;<br /> Start the Networkserver of Derby. The Default connection is localhost at port 1527<br /> DataBase URL:derby: jdbc:derby://127.0.0.1:1527/Firsttable;create=true<br /> JDBC Driver Class: org.apache.derby.jdbc.ClientDriver<br /> <br /> <br /> 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.</div>

FrankT https://wiki.openoffice.org/w/index.php?title=Base/connectivity/Derby&diff=157670 2010-02-20T22:20:55Z

<p>FrankT: </p> <hr /> <div><br /> == Connecting via JDBC<br /> ==<br /> <br /> Derby has to JDBC-Driver. The Embedded Driver called &quot;org.apache.derby.jdbc.EmbeddedDriver&quot; and the &quot;org.apache.derby.jdbc.ClientDriver&quot;. The first Driver embedded the Derby Database Driver into Java Code. The second Driver connect the Derby Database via network.<br /> <br /> &#039;&#039;&#039;1.) Embedded&#039;&#039;&#039;<br /> DataBase URL: jdbc:derby:C:\Dokumente und Einstellungen\db-derby-10.5.3.0\bin\DB-TABLE;<br /> JDBC Driver Class: org.apache.derby.jdbc.EmbeddedDriver<br /> <br /> &#039;&#039;&#039;2.) Network&#039;&#039;&#039;<br /> Start the Networkserver of Derby. The Default connection is localhost at port 1527<br /> DataBase URL:derby: jdbc:derby://127.0.0.1:1527/Firsttable;create=true<br /> JDBC Driver Class: org.apache.derby.jdbc.ClientDriver<br /> <br /> <br /> 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.</div>

FrankT https://wiki.openoffice.org/w/index.php?title=Base/connectivity/Derby&diff=157668 2010-02-20T22:09:26Z

<p>FrankT: Created page with &#039;Connecting via JDBC Derby has to JDBC-Driver. The Embedded Driver called &quot;org.apache.derby.jdbc.EmbeddedDriver&quot; and the &quot;org.apache.derby.jdbc.ClientDriver&quot;. The first Driver em…&#039;</p> <hr /> <div>Connecting via JDBC<br /> <br /> Derby has to JDBC-Driver. The Embedded Driver called &quot;org.apache.derby.jdbc.EmbeddedDriver&quot; and the &quot;org.apache.derby.jdbc.ClientDriver&quot;. The first Driver embedded the Derby Database Driver into Java Code. The second Driver connect the Derby Database via network.<br /> <br /> 1.) Embedded<br /> DataBase URL:derby:C:\Dokumente und Einstellungen\db-derby-10.5.3.0\bin\DB-TABLE;<br /> JDBC Driver Class:</div>

FrankT