Difference between revisions of "Documentation/DevGuide/Database/The SDBC Driver for JDBC"
From Apache OpenOffice Wiki
< Documentation | DevGuide
m (1 revision(s)) |
|||
(4 intermediate revisions by 2 users not shown) | |||
Line 7: | Line 7: | ||
|NextPage=Documentation/DevGuide/Database/The SDBC Driver for ODBC | |NextPage=Documentation/DevGuide/Database/The SDBC Driver for ODBC | ||
}} | }} | ||
− | {{DISPLAYTITLE:The SDBC Driver for JDBC}} | + | {{Documentation/DevGuideLanguages|Documentation/DevGuide/Database/{{SUBPAGENAME}}}} |
+ | {{DISPLAYTITLE:The SDBC Driver for JDBC}} | ||
The SDBC driver for JDBC is a mapping from SDBC API calls to the JDBC API, and vice versa. Basically, this driver is a direct bridge to JDBC. The SDBC driver for JDBC requires a special property called <code>JavaDriverClass</code> to know which JDBC driver should be used. The expected value of this property should be the complete class name of the JDBC driver. The following code snippet uses a MySQL JDBC driver to connect. | The SDBC driver for JDBC is a mapping from SDBC API calls to the JDBC API, and vice versa. Basically, this driver is a direct bridge to JDBC. The SDBC driver for JDBC requires a special property called <code>JavaDriverClass</code> to know which JDBC driver should be used. The expected value of this property should be the complete class name of the JDBC driver. The following code snippet uses a MySQL JDBC driver to connect. | ||
− | + | <syntaxhighlight lang="java"> | |
// first create the needed url | // first create the needed url | ||
String url = "jdbc:mysql://localhost:3306/TestTables"; | String url = "jdbc:mysql://localhost:3306/TestTables"; | ||
Line 25: | Line 26: | ||
// now create a connection to adabas | // now create a connection to adabas | ||
xConnection = xDriverManager.getConnectionWithInfo(url, props); | xConnection = xDriverManager.getConnectionWithInfo(url, props); | ||
− | + | </syntaxhighlight> | |
Other properties that require setting during the connect process depend on the JDBC driver that is used. | Other properties that require setting during the connect process depend on the JDBC driver that is used. | ||
{{PDL1}} | {{PDL1}} | ||
− | [[Category: Database Access]] | + | |
+ | [[Category:Documentation/Developer's Guide/Database Access]] |
Latest revision as of 14:09, 21 December 2020
The SDBC driver for JDBC is a mapping from SDBC API calls to the JDBC API, and vice versa. Basically, this driver is a direct bridge to JDBC. The SDBC driver for JDBC requires a special property called JavaDriverClass
to know which JDBC driver should be used. The expected value of this property should be the complete class name of the JDBC driver. The following code snippet uses a MySQL JDBC driver to connect.
// first create the needed url String url = "jdbc:mysql://localhost:3306/TestTables"; // second create the necessary properties com.sun.star.beans.PropertyValue [] props = new com.sun.star.beans.PropertyValue[] { new [ com.sun.star.beans.PropertyValue]("user", 0, "test1", com.sun.star.beans.PropertyState.DIRECT_VALUE), new com.sun.star.beans.PropertyValue("password", 0, "test1", com.sun.star.beans.PropertyState.DIRECT_VALUE), new com.sun.star.beans.PropertyValue("JavaDriverClass", 0, "org.gjt.mm.mysql.Driver", com.sun.star.beans.PropertyState.DIRECT_VALUE) }; // now create a connection to adabas xConnection = xDriverManager.getConnectionWithInfo(url, props);
Other properties that require setting during the connect process depend on the JDBC driver that is used.
Content on this page is licensed under the Public Documentation License (PDL). |