asked on

SQL Server JDBC Issue

I am trying to get an application, JIRA to work with my SQL Server 2005 database. I am getting a lot of errors regarding database access even when I am using the sa account. I think the problem is related to the JTDS driver I am using. I am using the following connetion string:

driverClassName="net.sourceforge.net.jtds.jdbc.driver"
url="jdbc:jtds:sqlserver://localhost:1433/jiradb"

I have also placed the JTDS jar file in the c:\program files\apache software foundation\tomcat 5.5\commom\lib folder

Any Thoughts? Is there another driver I should try? Any other configuration considerations?

Please let me know!

nmcdermaid

From the SQL Server perspective, I can really only suggest that you ensure the service is running and the host is contactable on port 1433.
Also ensure in the surface area configuration that the appropriate library is enabled.

From a JDBC perspective I have no idea!

What you could do is

-post some of the errors
-test a different driver in parallel if possible to work out whether the issue is with this driver in particular.

superfly18

ASKER

Here is what I have as my configuration. Any thoughts?

Please help!

<Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
username="sa"
password="sa"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost:1433;databaseName=JiraDB;integratedSecurity=true"/>

nmcdermaid

Whats the actual error that comes up?

Can you actually connect?

ASKER CERTIFIED SOLUTION

nmcdermaid

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial