Hello..
I'm having trouble getting connectivity to Oracle up and running. I know
the Oracle client install on the machine works (both sqlplus and PHP
work). I've downloaded the thin drivers from Oracle web site (and I
believe I've set them up correctly). The Oracle server is running on
another box. I previously had Tomcat working before I edited the
server.xml file. When I set all of my Oracle env vars correct
(ORACLE_HOME, ORACLE_SID, LD_LIBRARY_PATH, TWO_TASK) and then execute the
startup.sh script I receive the following error:
<cut>
[mhanulec@nwo1(7:13pm) bin]$ sudo ./startup.sh
Password:
Guessing TOMCAT_HOME from tomcat.sh to ./..
Setting TOMCAT_HOME to ./..
Using
classpath: ./../lib/ant.jar:./../lib/classes12.zip:./../lib/jasper.jar:./.
./lib/jaxp.jar:./../lib/nls_charset12.zip:./../lib/parser.jar:./../lib/servlet.j
ar:./../lib/test:./../lib/webserver.jar:/usr/local/jdk1.2.2/bin/../lib/tools.jar
[mhanulec@nwo1(7:13pm) bin]$ 2000-12-27 07:13:50 - ContextManager: Adding
contex
t Ctx( /examples )
2000-12-27 07:13:50 - ContextManager: Adding context Ctx( /admin )
2000-12-27 07:13:50 - ContextManager: Adding context Ctx( /mike )
Starting tomcat. Check logs/tomcat.log for error messages
2000-12-27 07:13:50 - ContextManager: Adding context Ctx( )
2000-12-27 07:13:50 - ContextManager: Adding context Ctx( /test )
FATAL:java.lang.RuntimeException: JDBCRealm.start.readXml: java.sql.SQLException
: Io exception: Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=134234112)(ERR=1250
5)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
java.lang.RuntimeException: JDBCRealm.start.readXml: java.sql.SQLException: Io
e
xception: Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=134234112)(ERR=12505)(ERR
OR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at org.apache.tomcat.request.JDBCRealm.contextInit(JDBCRealm.java,
Compiled Code)
at
org.apache.tomcat.core.ContextManager.initContext(ContextManager.java
, Compiled Code)
at org.apache.tomcat.core.ContextManager.init(ContextManager.java,
Compiled Code)
at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java, Compiled
Code)
at org.apache.tomcat.startup.Tomcat.main(Tomcat.java, Compiled
Code)
[mhanulec@nwo1(7:13pm) bin]$
</cut>
I'm running BlackDown's JDK 1.2.2 and Jakarta Tomcat 3.2.
My server.xml file looks as so (user names and passwds have been omitted).
<cut>
<RequestInterceptor
className="org.apache.tomcat.request.JDBCRealm"
debug="99"
driverName="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:@HOSTNAME.DOMAIN.COM:1521:ORCL"
connectionName="USERNAME"
connectionPassword="PASSWD"
userTable="tomcat_users"
userNameCol="user_name"
userCredCol="user_pass"
userRoleTable="tomcat_user_roles"
roleNameCol="role_name" />
</cut>
I'm probably just make some config mistake (like on the connectionURL
line).
Please help. Thank you.
-Mike
--
Mike Hanulec
Associate System Administrator B.S. Computer Engineering
Sesame Workshop Online University at Buffalo
[EMAIL PROTECTED] [EMAIL PROTECTED]
http://www.sesameworkshop.org http://www.hanulec.com
AOL IM: hanulec EFnet irc: hanulec
