The problem on using the wmDB Alias

, ,
1

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.

2

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

3

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

4

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.

5

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

6

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.

7

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