2 Responses to Connecting to SQL Server using jTDS

  1. Pingback: Connecting to SQL Server from Java | Thusitha Mabotuwana's Blog

  2. Anonymous says:

    I spent 8 hours trying to get a particular TOMCAT war to connect. Your post gave me the proper syntax of the jdbcUrl🙂
    Tomcat itself put in the escape backslashes and will obscure the password.
    I don’t recommend using sa but this was a burn down build.

    <<>>

    jdbcUrl=jdbc\:jtds\:sqlserver\://MYSERVER/mydb;instance\=SQLEXPRESS
    datasource=percDataSource
    hibernate.dialect=com.percussion.delivery.rdbms.PSUnicodeSQLServerDialect
    db.username=sa.quick.n.dirty.for.permissions
    db.password=put.your.password.here
    hibernate.query.substitutions=
    db.schema=DBO
    hibernateProperties=percHibernateProperties
    jdbcDriver=net.sourceforge.jtds.jdbc.Driver

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s