Wednesday, May 25, 2011

Java sql connections

Driver
Version
Example URL
JavaDB Derby 10.3.1.4 jdbc:derby://localhost:1527/sample (Network)
Oracle Oracle Database 11g (11.1.0.7) jdbc:oracle:thin:@//localhost:1521:ora11i
Other Drivers The following drivers and databases have not been formally tested, but should work based on experience.
Driver
Version
Example URL
PostgreSQL 8.x jdbc:postgresql://jsmith.mycompany.com:5432/postgres
MySQL MySQL Connector/J 6.0 jdbc:mysql://localhost:3306/sample
Microsoft Microsoft SQL Server 2005 JDBC Driver 1.2.2828.100 jdbc:sqlserver://localhost:1433;databaseName=travel;selectMethod=cursor
IBM Redistributable DB2 JDBC Type 4 driver v8 fixpack 13 jdbc:db2://localhost:50002/sample
jTDS jTDS 1.2.1 jdbc:jtds:sqlserver://test-mycompany.com:1433/travel
DataDirect DataDirect Connect for JDBC - 3.6 DataDirect Connect for JDBC - 3.6.07 jdbc:datadirect:oracle://localhost;SID=ora11i jdbc:datadirect:sqlserver://localhost:1433;DatabaseName=travel;SelectMethod=cursor jdbc:datadirect:db2://localhost:50002;databaseName=sample

No comments: