Can't create SQL Server JNDI data source in jasperserver 6.0.1

[bplummer]

When I try to create a JNDI data source to my SQL Server database I get this error:

Invalid JNDI name: jdbc/AbtgSplitter

The details start with:

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL 'jdbc:tibcosoftware:sqlserver://10.212.35.229:1433;databaseName=AbtgSplitter' at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory

The context.xml entry is:

    <Resource name="jdbc/AbtgSplitter" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
        username="sa" password="password"
        driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
        url="jdbc:tibcosoftware:sqlserver://10.212.35.229:1433;databaseName=AbtgSplitter"
        factory="com.jaspersoft.jasperserver.tomcat.jndi.JSBasicDataSourceFactory"/>

The web.xml entry is:

  <resource-ref>
    <description>340B AbtgSplitter</description>
    <res-ref-name>jdbc/AbtgSplitter</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>

I'm confident about my URL string - it worked in a JDBC connection to the AbtgSplitter database.  Any ideas - what am I missing?

Thanks in advance!

[htshozawa]

>jdbc:tibcosoftware:sqlserver://10.212.35.229:1433;databaseName=AbtgSplitte

It's because you're trying to connect using Tibco Jaspersoft's JDBC driver instead of MS's JDBC driver. You probably didn't install MS's jdbc driver on your application server lib.

 

 

 

[elizam]

See this page for information about using the standard SQL Server driver

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-installation-guide/v60/working-jdbc-drivers

 

[bplummer]

Thank you both for your suggestions. I changed the driverClassName to tibcosoftware.jdbc.sqlserver.SQLServerDriver and it connects.