hi Experts,

I want to use the wmDB Alias to connect Oracle database, but when I try to submit the service of the wmDB ,I get the follow errors:

Could not connect: [wm-cjdbc33-0009][Oracle JDBC Driver]This driver is locked for use with embedded applications.

How can I fix it,

Thanks in advance.

xisheng.

You can’t fix this, the Connect JDBC Driver can only be used for internal webMethods apps and not for WmDB. You will need to use the classes12.zip from Oracle.

-Jordy

More specifically, copy the classes12.zip to the <is_install_dir>\lib\jars folder and restart the server.

Set the “DB Driver” parameter in the WmDb alias to “oracle.jdbc.driver.OracleDriver”.

HTH,

Mark

Experts,

the follows are my wmDB alias information:

Alias CustomErrDB
DB URL jdbc:wm:oracle://localhost:1521;SID=orchid
DB Username userid
DB Password *******
DB Driver oracle.jdbc.driver.OracleDriver
Minimum Connections 1
Maximum Connections 5
Expiration Time (ms) 1000
Loaded Drivers <none>

and the classes12.zip have been add into the <is_install_dir>\lib\jars folder, but it still not work and same error display.

Xisheng.

try changing your DB URL to jdbc:oracle:thin://localhost:1521:orchid

Jordy is correct.
The JDBC drivers supplied are licensed to only work with the wm internal apps. I ran into the same problem with SQL server driver and Tech support told me the same thing. I had to download the driver from Microsoft.

Try using:

Alias CustomErrDB
DB URL jdbc:oracle:thin:@localhost:1521:orchid
DB Username userid
DB Password *******
DB Driver oracle.jdbc.driver.OracleDriver
Minimum Connections 1
Maximum Connections 5
Expiration Time (ms) 1000
Loaded Drivers <none>

-Jordy