I’m trying connect Database using JDBC adapter. But getting following error. Please tell me why we are getting this error
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource AdvxDB:AdvxDBConnection.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection AdvxDB:AdvxDBConnection: after 1 attempt(s).
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
Invalid Oracle URL specified: OracleDataSource.makeURL.
My Connection Parameters are:
Transaction Type :NO_TRANSACTION
DataSource Class :oracle.jdbc.pool.OracleDataSource
serverName :XXXX
user :*****
password :******
databaseName :HDBPP
portNumber :1521
networkProtocol :TCP
Other Properties
Minimum Pool Size :0
Maximum Pool Size :20
Pool Increment Size :5
Block Timeout (msec) :1000
Expire Timeout (msec):1000
Startup Retry Count :0
Startup Backoff Timeout (sec) :10
install a JDBC driver
1 Place the Java classes for the JDBC driver in a location that Integration Server can
access, typically the server’s classpath.
To place the classes in the server’s classpath, place the .zip or .jar file containing the
classes in the
Integration Server_directory\instances\instance_name\packages\WmJDBCAdapter\co
de\jars directory.
2 Restart Integration Server.
The server automatically adds the .zip or .jar libraries to its classpath after the restart.
we already installed jdbc driver and the environment which we are using already have 4 jdbc connections.
But, when i’m trying to add new one, i’m getting error.
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource AdvxDB:AdvxDBConnection.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection AdvxDB:AdvxDBConnection: after 1 attempt(s).
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
Invalid Oracle URL specified: OracleDataSource.makeURL.
It worked.But, getting different error this time. I think this error is coming due to Network problem. Let me check with Network team for firewall rules.
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource AdvxDB:AdvxDBConnection1.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection AdvxDB:AdvxDBConnection1: after 1 attempt(s).
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
IO Error: The Network Adapter could not establish the connection