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]
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment