bplummer Posted February 19, 2015 Share Posted February 19, 2015 When I try to create a JNDI data source to my SQL Server database I get this error:Invalid JNDI name: jdbc/AbtgSplitterThe 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.createConnectionFactoryThe 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! Link to comment Share on other sites More sharing options...
htshozawa Posted February 19, 2015 Share Posted February 19, 2015 >jdbc:tibcosoftware:sqlserver://10.212.35.229:1433;databaseName=AbtgSplitteIt'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. Link to comment Share on other sites More sharing options...
elizam Posted February 19, 2015 Share Posted February 19, 2015 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 Link to comment Share on other sites More sharing options...
bplummer Posted February 20, 2015 Author Share Posted February 20, 2015 Thank you both for your suggestions. I changed the driverClassName to tibcosoftware.jdbc.sqlserver.SQLServerDriver and it connects. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now