aspose file tools*
The moose likes JDBC and the fly likes [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "[IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications" Watch "[IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications" New topic
Author

[IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications

Shanmugam Muthukumarasamy
Ranch Hand

Joined: Jan 11, 2003
Posts: 83
Hi All,
I am getting one problem, while starting my application in WSAD environment with the DataDirectConnect SQL Server driver.
I have set the following details in the WebSphere Test Environment 4.0:
Implementation class Name : com.ibm.websphere.jdbcx.sqlserver.SQLServerDataSource
Class Path :
C:\DataConnect\sqlserver.jar;C:\DataConnect\base.jar;C:\DataConnect\util.jar;C:\DataConnect\spy.jar;
I am getting the following exception:
java.sql.SQLException: [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications.
at com.ibm.websphere.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ibm.websphere.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ibm.websphere.jdbc.base.BaseConnection.validatedUnlocked(Unknown Source)
at com.ibm.websphere.jdbc.base.BaseConnection.createStatement(Unknown Source)
at com.ibm.websphere.jdbc.base.BaseConnection.createStatement(Unknown Source)
at com.ibm.websphere.jdbcx.base.BasePooledConnection.createStatement(Unknown Source)
at com.ibm.websphere.jdbcx.base.BaseConnectionWrapper.createStatement(Unknown Source)
at com.ibm.ejs.cm.pool.ConnectO.createStatement(ConnectO.java:2057)
at com.ibm.ejs.cm.proxy.ConnectionProxy.createStatement(ConnectionProxy.java:482)
at com.pru.gulgvul.dao.WebDB.getConnection(WebDB.java:54)
Anybody having any idea about this, why I have encountered with this problem.
Thanks in advance,
Shanmugam.


SJCP 1.4<br />SCWCD 1.4<br />SCEA
acton wang
Greenhorn

Joined: Feb 12, 2003
Posts: 11
It is a long time ago's question and i just came cross.

Actually if you still can look up your setttings, I believe that you can find two jdbc sets: one is microsoft's and the other is something else for mssql jdbc. Try to get rid of one of them, you would be fine.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29244
    
139

It's good you noticed the timestamp that you were replying to an old question. Note that after a year, people don't need the answer and are unlikely to check back for replies.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Bonaponta Pirepare
Greenhorn

Joined: Nov 01, 2005
Posts: 1
You can ulock following coding.

import java.sql.Connection;
import com.ibm.websphere.jdbc.base.BaseConnection;

java.sql.Connection con = java.sql.DriverManager.getConnection(url,userName,password);
BaseConnection bcon = (BaseConnection) con;
BaseConnection bcon.unlock("WebSphereDataDirectOemId");

Rajesh MadhanGopal
Ranch Hand

Joined: Jan 19, 2006
Posts: 69
Hi,

Am facing the same issue and have been trying to unlock using the code mentioned above.

Could soemone let me know whats the STring i need to pass in the unlock method as i use Was embedded Connect JDBc and not Data Direct.

bcon = (BaseConnection) con;
bcon.unlock("WebSphereDataDirectOemId");

Guess, this is to unlock if you use Data Direct driver. What should i pass to unlock my ConenctJDBC driver.

bcon.unlock("What would go here?");

P.S: I can see this is a very old thread, but would be great if some one can help me oout on this.


Thanks<br />Rajesh
 
wood burning stoves
 
subject: [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications
 
Similar Threads
Can't start IBM WS AdminServer v4.0
This driver is locked for use with embedded applications
SQL Server 2000 and WSAD 5.1 issues
RAD 7.5.0 - Data Perspective - This driver is locked for use with embedded applications
Issue Connecting to MS SQL Server using WAS Embedded connectjdbc Driver