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
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.
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
Thanx for the help.
But problem still persists.
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.