Announcement Announcement Module
No announcement yet.
Spring JDBC/C3P0 SQL Server Woes Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Spring JDBC/C3P0 SQL Server Woes

    I am having a problem getting C3P0 (or Apache Basic Datasource) configured to work with SQL server. Does anyone have an example? I am interested in how the URL needs structured. I expected it to be: jdbc:sqlserver://[host]:[port]/[database] is this correct? Does the instance need in there somewhere? Example: jdbc:sqlserver://localhost:1433/Northwind.

  • #2
    Figured it out. C3P0 was not giving a very descriptive error message. Switched to Apache Basic Data Source and discovered my driver class was wrong. I had flipped a folder in the package. The proper URL is jdbc:sqlserver://[server]:[port].


    • #3
      Need help

      Can you please explain steps connecting with MS SQL Server. Please specify jar name, auth dll path, driver class name, url and other property in url. I am stuck there.