Problem in creating JDBC Adapte with WebMethods 6.0.1

, ,
1

Hi,
While creating JDBC conenction with wemebtods6.0.1 I am geting following error.

Can anybody help me on the same.

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource bmcConnection:ora90.
[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

DatabaseName Provided is : jdbc:oracle:thin:@137.72.248.220:1521:ora90

2

Try using this URL:
jdbc:oracle://137.72.248.220:1521;SID=ora90.
Also verify your username and password. We ran into issues where we had a wrong password and got an invalid url error message back.

3

hi,
try using the following settings on the JDBC Adapter connection page:

Transaction Type = LOCAL_TRANSACTION
DataSource Class = oracle.jdbc.pool.OracleDataSource
serverName = 137.72.248.220
user
password
databaseName ora90
portNumber 1521
networkProtocol
Other Properties driverType=thin

every time you change a setting also the password has to be retyped.
uli

4

Thanx for the help.

But problem still persists.

5

try to put the fully qualified BOX name instead of the IPAddress or put IPaddress with fully qualified name,like I have a box named USNBKA035, if i use this it gives the same error you have, I used USNBKA035.us.ul.com, this works fine.