Databases, JDBC drivers and connection URLs

I've used the combinations shown in the table below:

RDBMS Driver Typical JAR name Typical Connection URL

PostgreSQL 9.x org.postgresql.Driver postgresql-9.1-901-1.jdbc4.jar jdbc:postgresql://localhost:5432/RegTAP

Sybase ASE 15.7 net.sourceforge.jtds.jdbc.Driver jtds-1.3.1.jar jdbc:jtds:sybase://138.143.107.50:2545/axafusers

Sybase ASE 15.7 com.sybase.jdbc4.jdbc.SybDriver jconn4.jar jdbc:sybase:Tds:131.142.197.150:2545/axafusers

RDBMS	Driver	Typical JAR name	Typical Connection URL
PostgreSQL 9.x	org.postgresql.Driver	postgresql-9.1-901-1.jdbc4.jar	jdbc:postgresql://localhost:5432/RegTAP
Sybase ASE 15.7	net.sourceforge.jtds.jdbc.Driver	jtds-1.3.1.jar	jdbc:jtds:sybase://138.143.107.50:2545/axafusers
Sybase ASE 15.7	com.sybase.jdbc4.jdbc.SybDriver	jconn4.jar	jdbc:sybase:Tds:131.142.197.150:2545/axafusers

As far as Sybase is concerned:

the net.sourceforge.jtds.jdbc.Driver driver is open-source, is know as jTDS and is available from here.
the com.sybase.jdbc4.jdbc.SybDriver driver is closed-source, is known as jConnect4 and only available through Sybase (e.g. see here)

Regarding the possibility of using two different drivers for Sybase you may also refer to my axafusers-connectivity project for some performance tests. According to these tests it appears that the jTDS driver is more performant than the jConnect4.