File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes BEA/Weblogic and the fly likes MS SQL Server Datasource in Weblogic Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "MS SQL Server Datasource in Weblogic" Watch "MS SQL Server Datasource in Weblogic" New topic

MS SQL Server Datasource in Weblogic

Ganesh Kumar C V

Joined: May 12, 2011
Posts: 5
Hi - I have to create a datasource in Weblogic for MS SQL Server database. But I am NOT sure on which driver to choose in the drop down list. Are there any criteria in selecting a particular driver. But I tried each driver one by one and each one is throwing different errors during test connection. Errors are like driver class not found or some dll is missing. Do I require any jar? Please help.

Mohamed Nahfees

Joined: Mar 23, 2010
Posts: 4
This is the standard drivers provided by Weblogic. If you using transaction, use (1) otherwise use (2)

(1) XA: weblogic.jdbcx.sqlserver.SQLServerDataSource
(2) Non-XA: weblogic.jdbc.sqlserver.SQLServerDriver

Click for more information
JDCB SQL Driver information
I agree. Here's the link:
subject: MS SQL Server Datasource in Weblogic
It's not a secret anymore!