File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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 126.96.36.199
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
RAD 7.5.0 - Data Perspective - This driver is locked for use with embedded applications
jdbc:odbc password definition
Issue Connecting to MS SQL Server using WAS Embedded connectjdbc Driver
Request cannot be submitted due to wire contention.
Broken Pipe - SQL Server
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015