I am facing problem of connecting oracle with webMethods using jdbc, but I am facing this error:

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/1b5550be766efa4d261efa3d43746dbdc8b030c8_2_1035x580.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/1b5550be766efa4d261efa3d43746dbdc8b030c8.png 2x" data-dominant-color="C1CED1">

jdbcconnerror1366×768 85.5 KB

I have a successful connection of jdbc pool.

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/6790b57b19a72fcc155d5247a3ca244c71aef45a_2_1035x580.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/6790b57b19a72fcc155d5247a3ca244c71aef45a.png 2x" data-dominant-color="BFCCCF">

jdbcpool1366×768 112 KB

i am using this settings to configure but getting the above error, I have copied ojdbc drivers and class12.jar at required places already,

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/8b6c769c2ce27e7c614e9c37f91a25e7fe733e87_2_1035x580.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/8b6c769c2ce27e7c614e9c37f91a25e7fe733e87.png 2x" data-dominant-color="C3CECF">

jdbcsetting1366×768 88.7 KB

I will be very thankful for your precious time.
Regards
hmafzal

@hmafzal Did you try copying the required jars to packages\WmJDBCAdapter\code\jars\static as well into WmJDBCAdapter\lib? Seems like the error is because of not able to find the required jar/driver. Give it a try. Restart the server after copying the jars.

Thanks,
Sree

Hi,

there should be no need to copy the ojdbc-jar anywhere else than packages\WmJDBCAdapter\code\jars and to reload the package WmJDBCAdapter.
More likely there is a typo in the configuration parameters:
“Other Properties” should be “driverType=thin” instead of just “thin”.
“Network Protocol” can be omitted as only “tcp” is supported.
Please check all fields carefully for leading and trailing blanks and remove these as these are well-known to cause issues during makeUrl-initialization.

Remember that the IS internal DB Pools are using a different driver (DataDirect vs. plain Oracle) with a different protocol prefix. That is the reason why these are working (preconfigured during installation).

For further checking I would like to ask you to share a screen shot of pool “Intigria” as well as to confirm that you really want to connect with User/Schema “Administrator” to your Oracle instance.

If there are still issues please check if replacing “localhost” with a real pc name or ip adress resolves them.

Please keep us updates with the outcome of the above hints.

Regards,
Holger

hi
i’m still waiting for your precious advice.
Thanks
Regards
hmafzal

hi Holger von Thomsen
how are you? here is the picture of jdbc pool Intigria.

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/2f748feb7135b8fdb41e38a5c87dd45c61b44ffc_2_1035x580.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/2f748feb7135b8fdb41e38a5c87dd45c61b44ffc.png 2x" data-dominant-color="C1CDCE">

jdbcpoolintigria1366×768 92.7 KB

i will really appreciate your help. I’m just going to apply your suggested setting then i’ll let you know.
Regards
hmafza

Hi,

in this case it seems to be an issue with the fields in the connection config in JDBC Adapter containing any blanks where you do not expect them.

Can you provide an updated screenshot of your jdbc connection config throwing the makeURL error?

Regards,
Holger

Hi
I will really appreciate your precious guide to solve this matter, here is my config screen and config error screen:

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/bc02fee2447e6c140970effc15d7d5e845404db9_2_1035x580.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/bc02fee2447e6c140970effc15d7d5e845404db9.png 2x" data-dominant-color="E6E7E7">

jdbcconfig1366×768 63.2 KB

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/4c7c5228bcf86d81ac77a0d4a7aa6c63197ed89c_2_1035x580.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/4c7c5228bcf86d81ac77a0d4a7aa6c63197ed89c.png 2x" data-dominant-color="E0E4E7">

jdbcconfigerror1366×768 71.8 KB

Regards
hmafzal

Hi,

now we are encountering another error message (no matching auth protocol; this one is sent from the DB) than before (makeUrl; this one was inside the adapter).

Can you check the logs for the ORCL instance of the DB?
Please provide the exact DB version additionally for checking.

As I have never encountered such an error this is getting difficult for me to assist further.

Regards,
Holger

thanks Holger von Thomsen

hi Holger von Thomsen
how are you? here is the picture of jdbc pool Intigria.

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/2f748feb7135b8fdb41e38a5c87dd45c61b44ffc_2_1035x580.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/2f748feb7135b8fdb41e38a5c87dd45c61b44ffc.png 2x" data-dominant-color="C1CDCE">

jdbcpoolintigria1366×768 92.7 KB

i will really appreciate your help. I’m just going to apply your suggested setting then i’ll let you know.
Regards
hmafzal