A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
EJB 3 in Action
this week in the
EJB and other Java EE Technologies
Issue Connecting to MS SQl Server using WAS Embedded Connect JDBC Driver
Joined: Jan 19, 2006
Aug 06, 2007 21:57:00
We are trying to establish Database (DB Server -> MS SQL Server)connections from our application which runs in WAS 220.127.116.11
I now use WAS Embedded ConnectJDBC driver.
Driver name i use:
We use both Datasource and Driver manager for connection, all the Datasources when tested work fine but when we connect using Driver manager through the application it throws the following error:
: [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications.
Also, when i
the Driver Manager Connection using the Wizard (Database Explorer) in RAD, all connections through the driver manager work fine.
I can see that this a known issue, but am unable to find a solution to the same.
Any pointers would be of great help.
Joined: Feb 15, 2005
Aug 06, 2007 22:22:00
My advice would be to just convert your code so that it always uses a Data Source.
just isn't made for use in a managed environment like WebSphere.
Joined: Jan 19, 2006
Aug 12, 2007 01:57:00
Tried to convert the code to use Datasource...but am not able to do a JNDI Lookup from my Custom Service in my application.
it Throws a naming exception...tried many settings..but doesnt work...
is it that a JNDI lookup cannot be performed from a Custom Service in WAS?
Please throw some light on this..i seem to be lost on this..
I agree. Here's the link:
subject: Issue Connecting to MS SQl Server using WAS Embedded Connect JDBC Driver
Request cannot be submitted due to wire contention.
Issue Connecting to MS SQL Server using WAS Embedded connectjdbc Driver
jdbc:odbc password definition
Broken Pipe - SQL Server
RAD 7.5.0 - Data Perspective - This driver is locked for use with embedded applications
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014