• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: No suitable driver

 
Sumon Mukherjee
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All,

I was trying to create a type 4 XA driver JDBC connection pool in Weblogic 8.1 SP5. My database server is SQL Server 2005. I was unable to create the connection and was getting an error [BEA][SQLServer JDBC Driver][SQLServer]Could not find stored procedure 'master..xp_jdbc_open2'. I searched the net and found that I need to install the Weblogic 8.1 SP6.It has a file sqljdbc.dll in it which provided the necessary drivers for creating the Type 4 XA driver connection pool with SQL Server 2005. My connection pools were successful.

Now I am working with an Out-Of-Box application which has a Security Related Module. I created a new Realm in Weblogic and also its corresponding Authenticator,Adjudicator,Role Mapper etc. As per the instructions of the application, it asks me to make the New Realm as the default Realm. After doing all this when I am tring to start my Weblogic server it is throwing an error saying -
Failed to create connection for url=jdbc:bea:sqlserver://TST101:1433;databaseName=CRM7 and dbUser=sa
Nested Exception/Error:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at amdocs.uamsimpl.shared.utils.JDBCConnectionPool.createResource(JDBCConnectionPool.java:164)
at amdocs.uamsimpl.shared.utils.ResourcePool.createResources(ResourcePool.java:935)
at amdocs.uamsimpl.shared.utils.ResourcePool.createConnections(ResourcePool.java:355)
at amdocs.uamsimpl.server.obj.storage.rdbms.JDBCObjectPoolModule.init(JDBCObjectPoolModule.java:104)
at amdocs.uamsimpl.shared.module.UamsModuleManagmentServiceImpl.init(UamsModuleManagmentServiceImpl.java:435)
at amdocs.uamsimpl.shared.module.UamsModuleManagmentServiceImpl.start(UamsModuleManagmentServiceImpl.java:169)
at amdocs.uams.UamsSystem.start(UamsSystem.java:441)
at amdocs.uams.UamsSystem.<clinit>(UamsSystem.java:596)

Can anybody help me out. Any help in this regard will be much appreciated.

Thanks in advance,

Sumon
 
Jesper de Jong
Java Cowboy
Saloon Keeper
Posts: 15354
39
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The error message most likely means that either there is something wrong with the connection string (it is not in the right format), or the JDBC driver cannot be found.

Check the documentation to see if the connection string is correct, and check if the appropriate JDBC driver is available to Weblogic.
 
Bougnon Kipre
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Id looks like the JDBC driver in sqljdbc.dll file is not in the classpath where weblogic looks.
Why don't you check the sqljdbc.dll installation directory
 
Sumon Mukherjee
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you gentlemen for your replies. I have found the error. I was using the BEA Weblogic drivers for type 4 XA connections. Instead I had to use Microsoft provided drivers for SQL Server 2005 which can be found in sljdbc.jar. The application that i am working on could identify the Microsoft provided derivers only and not the Bea Weblogic drivers.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic