Hi All,

 I have configured my application recently in WAS 8.5.5.2. I am getting below error when i tried click on my link in my application. I am using datadirect jar VOracle.jar. Could any please let me know what could be the problem. I didnt see any errors realted to application. Revert me if you need more information.


WAS Version: Websphere 8.5.5.2

DB Details:
0000006b DSConfigurati I DSRA8203I: Database product name : Oracle
0000006b DSConfigurati I DSRA8204I: Database product version : 11.2.0.1.0
0000006b DSConfigurati I DSRA8205I: JDBC driver name : Oracle
0000006b DSConfigurati I DSRA8206I: JDBC driver version : 5.1.3.000142 (F000153.U000068)
0000006b DSConfigurati I DSRA8025I: Successfully connected to DataSource.

Error :

000006a AppSupportIm E Unable to perform operation on method 'getDetails' of webservice 'AppSupport' due to the following reason: A database error has occured[00010040013] Details: java.sql.SQLException: [MyProduct][Oracle JDBC Driver]This driver is locked for use with embedded applications..

Few more info like,

My database is located in other server and using the Data sources > OracleDS > Custom properties (SID, password, portname, serverName, user)i have configured the related stuff. From the WAS end , i got the success message of Test connection. 

But, when i click on any link from my applciation, i am getting the error mentioned in previous post. How to understand the above problem. Is it related to WAS or my application code issues. I am just lookup the datasource created in my WAS in code as 

          (DataSource)context.lookup(aRepository.getDataSrcName());

Hi Naresh,

  Seems a problem with used driver.
 
  [Oracle JDBC Driver]This driver is locked for use with embedded application
  community.oracle.com/thread/2026614
 
  To summarize - the DataDirectDriver that is shipped with the IDE seems to be locked to be used inside the IDE only because of some licensing issues etc..

  ...

  The solution would be to use Oracle's own driver, that is distributed at no charge from their web site - www.oracle.com/technology/software/tech/...
 
  Hope this helps. Tell us if you need more support
 
Regards

Hi,

 If i use the direct jar of Oracle, my application will throw error while fetching the information from DB. So, i have to use the dedicated jar of my application like VOracle.jar. Initially i have used ojdbc6.jar but few links didnt work and got exception. Then, i came to know that i have to use data-direct jar which is dedicated to my application. 

Naresh,
 
   but following with the issue if you need to use specific driver maybe you need to go compatibility matrix because maybe is not supported to use outside the original environment. The message is clear "This driver is locked for use with embedded applications"
   
   I suppose that you have configure the driver pointing directly to the jar file. In the next link talks about to "install" the driver I don't know if you can "install" VOracle.jar
   
   java -jar VOracle.jar
   
   knowledgebase.progress.com/articles/Arti...
   
   Hope this helps.
   
Regards