tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael R Hanulec <hanu...@hanulec.com>
Subject Tomcat and Oracle 8.x
Date Thu, 28 Dec 2000 00:23:58 GMT
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
michael.hanulec@sesameworkshop.org                   hanulec@hanulec.com
http://www.sesameworkshop.org			  http://www.hanulec.com
AOL IM: hanulec					      EFnet irc: hanulec



Mime
View raw message