Stefan Kaintoch - KnowHow - Java

Code-Snippets

Links zu Code-Snippets

APIs, Technologies

JDBC

DriverTypeURL
Interbase:
interbase.interclient.Driver
4 jdbc:interbase://<host>[:<port>]/<path to DB file>
Firebird:
org.firebirdsql.jdbc.FBDriver
4 jdbc:firebirdsql://<host>[:<port>]/<path to DB file>
MySQL:
com.mysql.jdbc.Driver
4 jdbc:mysql://[<host>][:<port>]/[<database>][?<option>[&<option>...]]
PostgreSQL:
org.postgresql.Driver
4 jdbc:postgresql:[//<host>[:<port>/]]<database>[?<option>[&<option>...]]
Oracle:
oracle.jdbc.driver.OracleDriver
4 jdbc:oracle:<driver>:@<db connection string>
where <driver> can be thin or oci8.
example for <db connection string>:
<host>:1521:<SID> with thin
<name> with oci8
DB2:
COM.ibm.db2.jdbc.app.DB2Driver
? jdbc:db2:<client-name>
SQL-Server (6.5, 7.x and 2000):
net.sourceforge.jtds.jdbc.Driver
4 jdbc:jtds:<type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]
where <type> can be sqlserver or sybase.
SQL-Server, Access:
org.objectweb.rmijdbc.Driver
3 jdbc:rmi://<rmihostname>[:<port>]/<jdbc-url>
ODBC:
sun.jdbc.odbc.JdbcOdbcDriver
4 jdbc:odbc:<ODBC-DB>
where <ODBC-DB> can be a DSN
or
Driver={Microsoft Excel Driver (*.xls)};DBQ=c:/data/month.xls;DriverID=22;READONLY=false
or
Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/data/month.MDB
JDBC-LDAP Bridge:
com.octetstring.jdbcLdap.sql.JdbcLdapDriver
4 jdbc:ldap://<host>[:<port>]/<basedn>[?<prop>:=<val>[&<prop>:=<val>...]]

Misc

Online Bücher

Links

Tools


[Top] [Home]

[Created with vim] [Viewable with any browser] [100% hand coded HTML] [Valid XHTML 1.0 Strict!] [Valid CSS!] [Level A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0] Last changed: $Date: 2013/02/27 15:25:40 $