This is Argyn's blog. I comment on topics of my interests such as software, math, finance, and music. Also, I write about local events in Northern Virginia, USA and all things related to Kazakhstan

Wednesday, March 10, 2004

ONJava.com: Configuring JBoss 4.0 JDBC Connectivity [Feb. 25, 2004]

ONJava.com: Configuring JBoss 4.0 JDBC Connectivity [Feb. 25, 2004] - I was looking for JDBC URL configuration for Sybase jConnect driver. Sybase's documentation sucks big time. Basically, all you need is to add jconn2.jar to a classpath, then connection URL:
jdbc:sybase:Tds:_host_:_port_/_database_?user=_username_?password=_password_

Driver class is: com.sybase.jdbc2.jdbc.SybDriver

On my server, a port is 5001, but it can be anything.

Connecting to SQL Anywhere 5.x.xx from a Java application using jConnect - this link also have some useful info, including Sybase URL formats:

dbc:sybase:Tds:host:port
jdbc:sybase:Tds:host:port/
jdbc:sybase:Tds:host:port/database
jdbc:sybase:Tds:host:port/database?property=value[?property=value]
jdbc:sybase:Tds:host:port?property=value[?property=value]

No comments: