Hi folks, I've been having some issues anyway with Oracle in my Java app the
last week or so.
Originally, I thought it was due to some references where I was using the old
sun.jdbc.odbc.JdbcOdbcDriver rather than the thin Oracle driver.
So in any reference I had this, I've switched it to the Oracle thin like so:
Class.forName("oracle.jdbc.driver.OracleDriver");
String dbURL = "jdbc:oracle:thin:@192.xxx.xx.xxx:1521:SID";
My error is listed below. I guess my question is, do any of you think this is
mainly with Oracle, or perhaps the driver in the Tomcat lib directory got
corrupt? Or is this a Tomcat issue at all even? I'm inclined to think the
driver (jar file) might have gotten corrupt possibly, but that would be
unlikely and that it's more of an issue with Oracle.
I welcome any feedback.
Thanks,
Barry
Catalina.start: LifecycleException: Exception opening database connection: jav
a.sql.SQLException: Io exception: The Network Adapter could not establish the co
nnection
LifecycleException: Exception opening database connection: java.sql.SQLExcepti
on: Io exception: The Network Adapter could not establish the connection
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307
)
at org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:505
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:776)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
----- Root Cause -----
java.sql.SQLException: Io exception: The Network Adapter could not establish the
connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:418)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
va:521)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
