hi,

please help me in creating the jdbc connection using oracle 10g XE in windows 7. i need the values to be configured like path,datasource name,server,… etc.

Refer JDBC Adapter’s guide…

Typically, Connection properties values will be like this for example… Value of data source class depends on what kind of jar file you are using… It varies for different databases… Refer the guide for more information…

[TABLE=“width: 100%”]
[TR]
[TD=“class: evenrow”]Transaction Type[/TD]
[TD=“class: evenrowdata-l”] LOCAL_TRANSACTION [/TD]
[/TR]
[TR]
[TD=“class: oddrow”]DataSource Class[/TD]
[TD=“class: oddrowdata-l”] oracle.jdbc.pool.OracleDataSource [/TD]
[/TR]
[TR]
[TD=“class: evenrow”]serverName[/TD]
[TD=“class: evenrowdata-l”] localhost [/TD]
[/TR]
[TR]
[TD=“class: oddrow”]user[/TD]
[TD=“class: oddrowdata-l”] Administrator [/TD]
[/TR]
[TR]
[TD=“class: evenrow”]password[/TD]
[TD=“class: evenrowdata-l”] ****** [/TD]
[/TR]
[TR]
[TD=“class: oddrow”]databaseName[/TD]
[TD=“class: oddrowdata-l”] XE [/TD]
[/TR]
[TR]
[TD=“class: evenrow”]portNumber[/TD]
[TD=“class: evenrowdata-l”] 1521 [/TD]
[/TR]
[/TABLE]

HTH
Senthil

hi senthil,
thanx for ur responce…
i configure as u said… but still i facing the error like…

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource adapter:jbcadap. [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager. [ADA.1.200] The JDBC DataSource class “oracle.jdbc.pool.OracleDataSource” cannot be located. oracle.jdbc.pool.OracleDataSource

hi senthil,
you are saying that data source class depends on the jar fie… can you give more detail about the jar files…

regards
hima

If you are using Oracle, you would required jars like ojdbc14.jar or something. If it is sql server, jar file is different. You can check with your Oracle team and get those jar files.

Moreover, search with this error in this forum, you should find lots of similar posts that were discussed before.

HTH
Senthil

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource adap:jadap.[ART.118.5063] Adapter Runtime (Connection): Unable to start connection adap:jadap: after 1 attempt(s).[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleConnectionPoolDataSource”.Io exception: Got minus one from a read call

hi ,

can any one please share me how to set the class path…

thanks
him

[INDENT]Hi Jhima,

Can you cross check the Ojdbc jar file is present on Integration server as per the below mentioned path :IntegrationServer\lib\jars\ojdbc14.jar

verify each and every parameter of the JDBC adapter service does contains any Spaces.
especially Data source class parameter.

Regards,
Jeevan_mjk [/INDENT]

Place the ojdbc14.jar file in the server pat: IntegrationServer/Packages/WmJDBCAdapter/code/jars and then restart the integration server. configure the connection as told by senthil and then enable it.

You can also just reload the package as the jar file is placed under the specific package.

Senthil

Hi Jeevan_mjk,

I did a fresh installation of IS 8.2, but i don’t see ojdbc jar file any where. How to get it and from where to get it. Which is the latest one.

Regards,
Mona

Hi Mona,

ojdbc14 Jar file is required.

Regards,
Jeevan

Thanks Jeevan,

Can i put it manually. will it work with 8.2 IS.

in jdbc connection error

Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”. Io exception: The Network Adapter could not establish the connection

jdbc adapter connection

Error encountered
[ART.118.5010] Adapter Runtime (Connection): Invalid connection name. The connection name must have a valid folder n

Create a folder first using Developer or Designer and then use this while creating a DB Connection.

Hi Mona,
First of all ojdbc jar file does not come with the webMethods installation, you need to download it separately from oracle’s website. Second thing which version of jar file you have to use is depends upon the JVM version. If you are using java version 2 then use classes12.jar, if java version is 4 then use ojdbc14.jar if java version is 5 or 6 then use ojdbc5.jar or ojdbc6.jar respectively. But it is in the case if you are connecting to oracle database if it database is other than oracle then search for appropriate jar file one that vendor’s website.

Regards,
vikas

I am trying to configure adapter service in webMethods. I have created a connection in the Integration Server admin (JDBC Adapter/Connections) for an Oracle database using jdk 6. I place the odbc6.jar file in the file specified in the documentation (C:\SoftwareAG\IntegrationServer\packages\WmJDBCAdapter\code\jars).

When I try to enable the connection, I get the following error. Please can you help :

[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
Invalid Oracle URL specified: OracleDataSource.makeURL

Make sure that the Database URL is in the below format

jdbc:wm: oracle://:

Hi Sreenivas,

Thanks for your suggesstion. Today I am getting an error with the time-zone. How can I set the timezone? The error looks like this:

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource chris.adapters.jdbs.connection:chris_local_connection.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
ORA-00604: error occurred at recursive SQL level 1
ORA-01882:timezone region not found

check the below link this will solve your problem

for
ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
ORA-00604: error occurred at recursive SQL level 1
ORA-01882:timezone region not found

-its probably due to Oracle version not supported
please check below link for system requirement
http://techcommunity.softwareag.com/ecosystem/documentation/webmethods/adapters_estandards/Adapters/webMethods_Adapters_System_Requirements.htm

for
Invalid connection name. The connection name must have a valid folder n
-have you use the wrong connection name?

Hi All,

Can any one please help me to come out from below issue.

I am trying to configure adapter service in webMethods 9.5. I have created a connection in the Integration Server admin (JDBC Adapter/Connections) for an Oracle 11g database using jdk 6. I place the odbc6.jar file in the file specified in the documentation (C:\SoftwareAG\IntegrationServer\lib\jars).

When I try to enable the connection, I get the following error. Please can you help :

[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
Invalid Oracle URL specified: OracleDataSource.makeURL

Also make sure you have place the classes12.jar in the path below and restart IS

/IntegrationServer/packages/WmJDBCAdapter/code/jars

HTH,
RMG

@ Narasimha,

Can you share the screen shot of your JDBC adapter connection showing all the details.

Hi Mahesh,

Please find the attached file for JDBC Adapter configuration screen shot. [Filename- JDBCAdapterConfiguration.png]

I have gone through some forums and found that need to mention database URL. But i didnt find any Database URL option in JDBC Adapter connection section.

And below error getting when i trying configure the Adapters->WmDB.

Could not connect: Couldn’t load driver oracle.jdbc.pool.OracleDataSource
Please find the screent shot for WmDB configuration [Filename- WmDBConfiguration.png]

I have sucessfully configured the JDBC Pool section, here i found the Database URL option. [JDBCPoolAliasConfiguration]

Could you please help me in resolving this issue.  

Thanks in advance.

Regards,
Narasimha.

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/6b7edcc24baf54ac06afe79bc0ed3aad37870c9b_2_1035x580.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/6b7edcc24baf54ac06afe79bc0ed3aad37870c9b.png 2x" data-dominant-color="D9DBDD">

JDBCPoolAliasConfiguration.png1366×768 277 KB

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/05994dc72b266590e83965ab99965b4b9186fbc9_2_1035x580.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/05994dc72b266590e83965ab99965b4b9186fbc9.png 2x" data-dominant-color="CCD1CC">

JDBCAdapterConfiguration.png1366×768 262 KB

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

WmDBConfiguration.png1366×768 255 KB

Looks good… but you have to mention driverType=thin in Other Properties

Can you download and go through 6-5_JDBC_Adapter_Install_and_Users_Guide.pdf

Really worth going through this as your are setting this up for the first time (I guess :))

Let me know if you still face issues. I hope you have the respective jars file accordingly.

If you are using webMethods 9+ I hope you have JVM 1.7 as well. Did you try ojdbc7.jar?
The ojdbc6.jar is for jvm 1.6, it might not be compatibale with Java 1.7.
Though Oracle lists ojdbc7.jar only for Oracle 12+, it should be backward compatible with Oracle 11.

@ Narasimha,

Are we good with the issue now

Any updates?

Please check the connection params for leading or trailing spaces (and remove them).

This is a common point of failure when setting up JDBC-AdapterConnections.

Regards,
Holger

I agree with Holger

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource JDBCAdapters:JDBCAdapters.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection JDBCAdapters:JDBCAdapters: after 1 attempt(s).
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
IO Error: Got minus one from a read call

what should i do ? i am using oracle 11g …downloaded class12.jar and plced it in the lib\jar …is there anything else i am missing

Place ojdbc5.jar…it should work

Make sure while configuring the jdbc connection there are no white spaces at the leading and trailing edge. Also after placing the JARs in \IntegrationServer\lib\jars restart the server if you are unable to enable the connection.

You can get the JAR from oracle 11g installation folder (the path where you have installed)

why we should dive other properties in jdbc connection?
and what is meant by minimum pool size, maximum pool size, pool increment and blocked time out?

Hi Krushna,

if and what properties need to be mentioned in other properties depends on the driver being used.
For Oracle this controls the mode of the connection (oci8 or thin).
When using certain security settings for i.e. authentication, these settings will be placed in other properties too.

For the Settings please refer to the JDBC Adapter Users guide.

Regards,
Holger

Hi,

Here are some details of my setup. I too struggled but then was able to get it.

1. I am using 10.5 trial version

2. I have installed Oracle 11g and SQL server in my system.

3. As mentioned above, you have to place the ojdbc jar file in the C:\SoftwareAG\IntegrationServer\packages\WmJDBCAdapter\code\jars and C:\SoftwareAG\IntegrationServer\instances\default\packages\WmJDBCAdapter\code\jars

Note : I have placed Ojdbc5.jar file.

If you are not able to create a JDBC connection, try creating a new one after placing the jar file and reloading the package.

And do not place multiple jar files in the directory, it may not work.

JDBC connection details

Transaction Type LOCAL_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
Server Name localhost
User system
Password ******
Database Name orcl
Port Number 1521
Network Protocol tcp
Other Properties driverType=thin

Thanks
Suraj

Hi,

for wM 10.5 you should use an ojdbc8.jar for Oracle 12.2.
You can get this for free from Oracle Download section.

This will also enable the latest JDBC features in the JDBC Adapter 9.10.

Regards,
Holger

You can still place multiple jar (ojdbc and sqljdbc) version files in this location and under static (create this sub folder if not exist already)

C:\SoftwareAG\IntegrationServer\instances\default\packages\WmJDBCAdapter\code\jars\static\

Finally bounce the IS (best practice) for any configuration changes take place to avoid any adapter hiccups:

HTH,
RMG

Hi,

I partially agree with RMG.

as long as the driver(s) do not relying on a native lib, it is fine to have them under code/jars and just reload the package.
Remember to define a dependency in those packages relying on the WmJDBCAdapter package to get them reloaded and the connections restarted properly when the JDBC-Adapter reloads.

For those with native lib part the jar needs to go under code/jars/static and the native lib in the IntegrationServer/instances/default/lib directory. In this case shutting down and restarting the IS is required to get the native lib loaded properly.

It is fine having one jar (hopefully the latest) for each database type being used in the code/jars directory.
What you should avoid is having multiple versions for one database type in parallel as ths might be causing ClassLoading issues or the wrong version gets picked first.

Regards,
Holger