RE: Tomcat load up error, w/ Oracle

[Jason Pyeron <jp...@pdinc.us>]

Are you able to connect to the Oracle box using sqlplus from the tomcat box?



-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-                                                               -
- Jason Pyeron                      PD Inc. http://www.pdinc.us -
- Sr. Consultant                    10 West 24th Street #100    -
- +1 (443) 269-1555 x333            Baltimore, Maryland 21218   -
-                                                               -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you
have received it in error, purge the message from your system and
notify the sender immediately.  Any other use of the email by you
is prohibited. 


-----Original Message-----
From: Propes, Barry L [GCG-NAOT] [mailto:barry.l.propes@citigroup.com] 
Sent: Tuesday, February 13, 2007 11:43
To: Tomcat Users List
Subject: Tomcat load up error, w/ Oracle

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: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org