"java.sql.SQLException: [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications" received with Connect JDBC driver in WebSphere Application Server 5.0
 Technote (troubleshooting)
 
Problem(Abstract)
In WebSphere Application Server 5.0.x, with a WebSphere 5.0 data source, using the WebSphere embedded Connect JDBC Driver 3.1 for MS SQLServer, an application fails with the following error when it tries to get a connection:

java.sql.SQLException: [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications
 
Cause
An incorrect DataStoreHelper class is being used or the embedded Connect JDBC driver is not being used with a WebSphere DataSource.
 
Resolving the problem
Verify the following:
  1. In the Admin Console data source configuration, ensure that the com.ibm.websphere.rsadapter.WSConnectJDBCDataStoreHelper is used as the Datasource Helper Classname.
  2. The application must use a WebSphere Data Source to access the WebSphere embedded Connect JDBC driver. Any other use of this driver is not permitted.
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Java 2 Connectivity (J2C)
Operating system(s): Windows
Software version: 5.0
Software edition:
Reference #: 1110669
IBM Group: Software Group
Modified date: May 22, 2003