Java Database Connectivity (JDBC)

Hi. I'm trying to connect to Oracle from my Java app running under Tomcat. I can successfully do this using the thin driver, but I would like use the OracleOCIConnectionPool class so want to use the OCI driver. However, when I switch to this driver it makes the JVM (Tomcat) crash.

Any ideas why? Is there a way of doing connection pooling with the thin driver? Any help gratefully received.

Thanks

Chris

My setup is:
- Java 1.5/Tomcat 5
- Oracle 10.2.0
- using ojdbc14.jar
- Solaris 10

The dump file is as follows:

#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGSEGV (0xb) at pc=0xfecfb7fc, pid=4699, tid=38
#
# Java VM: Java HotSpot(TM) Client VM (1.5.0_15-b04 mixed mode, sharing)
# Problematic frame:
# V [libjvm.so+0xfb7fc]
#

--------------- T H R E A D ---------------

Current thread (0x0072af28): JavaThread "TP-Processor3" daemon [_thread_in_vm, id=38]

siginfo:si_signo=11, si_errno=0, si_code=1, si_addr=0x00000008

Registers:
O0=0x00000000 O1=0xff16c000 O2=0x00000008 O3=0xfecfb798
O4=0x00488dd8 O5=0x00006cac O6=0xf60fe018 O7=0xfecfb798
G1=0xd5340fb1 G2=0x0072b514 G3=0x00000008 G4=0xff1a0918
G5=0x00000000 G6=0x00000000 G7=0xfe768c00 Y=0x00000000
PC=0xfecfb7fc nPC=0xfecfb800


Top of Stack: (sp=0xf60fe018)
0xf60fe018: 00000000 ff1869dc ff1889c8 d5340fa8
0xf60fe028: ff16c000 00004f48 00470a94 0072b50c
0xf60fe038: 00000000 00000000 f7d61c38 0072b510
0xf60fe048: ff17f808 0072af28 f60fe098 f7d52f50
0xf60fe058: 00000000 00000000 00000000 f56cd7a0
0xf60fe068: 00012360 00012000 0001235c 00012000
0xf60fe078: 00012358 00012000 f5705b10 f60fe314
0xf60fe088: f5705b14 00000000 00000000 0000070c

Instructions: (pc=0xfecfb7fc)
0xfecfb7ec: f2 26 20 00 80 a6 20 00 12 80 00 0f 94 10 20 08
0xfecfb7fc: c8 02 a0 00 90 10 20 08 c6 01 20 34 9f c0 c0 00

Stack: [0xf6080000,0xf6100000), sp=0xf60fe018, free space=504k
Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code)
V [libjvm.so+0xfb7fc]
C [libocijdbc10.so+0x2f58]
C [libocijdbc10.so+0x4850] Java_oracle_jdbc_driver_T2CConnection_t2cCreateState+0x98
j oracle.jdbc.driver.T2CConnection.t2cCreateState([BI[BI[BI[BISI[S[B[B)I+0
j oracle.jdbc.driver.T2CConnection.t2cCreateState([BI[BI[BI[BISI[S[B[B)I+0
j oracle.jdbc.driver.T2CConnection.logon()V+551
j oracle.jdbc.driver.PhysicalConnection.<init>(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/util/Properties;Loracle/jdbc/driver/OracleDriverExtensi
on;)V+515
j oracle.jdbc.driver.T2CConnection.<init>(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/util/Properties;Loracle/jdbc/driver/OracleDriverExtension;)V
+10
j oracle.jdbc.driver.T2CDriverExtension.getConnection(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection;+150
j oracle.jdbc.driver.OracleDriver.connect(Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection;+1074
j oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(Ljava/util/Properties;)Ljava/sql/Connection;+374
j oracle.jdbc.pool.OracleDataSource.getConnection(Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;+312
j oracle.jdbc.pool.OracleDataSource.getConnection()Ljava/sql/Connection;+65
j com.clsservices.clss.DbBroker.getConnection()Ljava/sql/Connection;+3
j com.clsservices.clss.CLSSServlet.doGet(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V+168
j javax.servlet.http.HttpServlet.service(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V+35
j javax.servlet.http.HttpServlet.service(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+30
j org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+362
j org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+101
j org.apache.catalina.core.StandardWrapperValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+699
j org.apache.catalina.core.StandardContextValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+285
j org.apache.catalina.core.StandardHostValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+64
j org.apache.catalina.valves.ErrorReportValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+6
j org.apache.catalina.core.StandardEngineValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+42
j org.apache.catalina.connector.CoyoteAdapter.service(Lorg/apache/coyote/Request;Lorg/apache/coyote/Response;)V+154
j org.apache.jk.server.JkCoyoteHandler.invoke(Lorg/apache/jk/core/Msg;Lorg/apache/jk/core/MsgContext;)I+123
j org.apache.jk.common.HandlerRequest.invoke(Lorg/apache/jk/core/Msg;Lorg/apache/jk/core/MsgContext;)I+327
j org.apache.jk.common.ChannelSocket.invoke(Lorg/apache/jk/core/Msg;Lorg/apache/jk/core/MsgContext;)I+191
j org.apache.jk.common.ChannelSocket.processConnection(Lorg/apache/jk/core/MsgContext;)V+105
j org.apache.jk.common.ChannelSocket$SocketConnection.runIt([Ljava/lang/Object;)V+8
j org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run()V+167
j java.lang.Thread.run()V+11
v ~StubRoutines::call_stub
V [libjvm.so+0xdd4e0]
V [libjvm.so+0xf4f20]
V [libjvm.so+0xf4d7c]
V [libjvm.so+0xf4c00]
V [libjvm.so+0x43cd00]

Java frames: (J=compiled Java code, j=interpreted, Vv=VM code)
j oracle.jdbc.driver.T2CConnection.t2cCreateState([BI[BI[BI[BISI[S[B[B)I+0
j oracle.jdbc.driver.T2CConnection.logon()V+551
j oracle.jdbc.driver.PhysicalConnection.<init>(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/util/Properties;Loracle/jdbc/driver/OracleDriverExtensi
on;)V+515
j oracle.jdbc.driver.T2CConnection.<init>(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/util/Properties;Loracle/jdbc/driver/OracleDriverExtension;)V
+10
j oracle.jdbc.driver.T2CDriverExtension.getConnection(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection;+150
j oracle.jdbc.driver.OracleDriver.connect(Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection;+1074
j oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(Ljava/util/Properties;)Ljava/sql/Connection;+374
j oracle.jdbc.pool.OracleDataSource.getConnection(Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;+312
j oracle.jdbc.pool.OracleDataSource.getConnection()Ljava/sql/Connection;+65
j com.clsservices.clss.DbBroker.getConnection()Ljava/sql/Connection;+3
j com.clsservices.clss.CLSSServlet.doGet(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V+168
j javax.servlet.http.HttpServlet.service(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V+35
j javax.servlet.http.HttpServlet.service(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+30
j org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+362
j org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+101
j org.apache.catalina.core.StandardWrapperValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+699
j org.apache.catalina.core.StandardContextValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+285
j org.apache.catalina.core.StandardHostValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+64
j org.apache.catalina.valves.ErrorReportValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+6
j org.apache.catalina.core.StandardEngineValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+42
j org.apache.catalina.connector.CoyoteAdapter.service(Lorg/apache/coyote/Request;Lorg/apache/coyote/Response;)V+154
j org.apache.jk.server.JkCoyoteHandler.invoke(Lorg/apache/jk/core/Msg;Lorg/apache/jk/core/MsgContext;)I+123
j org.apache.jk.common.HandlerRequest.invoke(Lorg/apache/jk/core/Msg;Lorg/apache/jk/core/MsgContext;)I+327
j org.apache.jk.common.ChannelSocket.invoke(Lorg/apache/jk/core/Msg;Lorg/apache/jk/core/MsgContext;)I+191
j org.apache.jk.common.ChannelSocket.processConnection(Lorg/apache/jk/core/MsgContext;)V+105
j org.apache.jk.common.ChannelSocket$SocketConnection.runIt([Ljava/lang/Object;)V+8
j org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run()V+167
j java.lang.Thread.run()V+11
v ~StubRoutines::call_stub

--------------- P R O C E S S ---------------

Java Threads: ( => current thread )
0x0077adc8 JavaThread "Thread-34" daemon [_thread_blocked, id=42]
0x00774d60 JavaThread "Thread-33" daemon [_thread_in_native, id=41]
0x0072c5b8 JavaThread "TP-Monitor" daemon [_thread_blocked, id=40]
0x0072b9f0 JavaThread "TP-Processor4" daemon [_thread_in_native, id=39]
=>0x0072af28 JavaThread "TP-Processor3" daemon [_thread_in_vm, id=38]
0x0072a560 JavaThread "TP-Processor2" daemon [_thread_blocked, id=37]
0x0072a398 JavaThread "TP-Processor1" daemon [_thread_blocked, id=36]
0x006fd250 JavaThread "http-8080-Monitor" [_thread_blocked, id=35]
0x006fbe80 JavaThread "http-8080-Processor25" daemon [_thread_in_native, id=34]
0x006fb2a0 JavaThread "http-8080-Processor24" daemon [_thread_blocked, id=33]
0x006fa6d8 JavaThread "http-8080-Processor23" daemon [_thread_blocked, id=32]
0x006f9b10 JavaThread "http-8080-Processor22" daemon [_thread_blocked, id=31]
0x006f8f48 JavaThread "http-8080-Processor21" daemon [_thread_blocked, id=30]
0x006f8380 JavaThread "http-8080-Processor20" daemon [_thread_blocked, id=29]
0x006f77b8 JavaThread "http-8080-Processor19" daemon [_thread_blocked, id=28]
0x006f6bf0 JavaThread "http-8080-Processor18" daemon [_thread_blocked, id=27]
0x006f6028 JavaThread "http-8080-Processor17" daemon [_thread_blocked, id=26]
0x006f5460 JavaThread "http-8080-Processor16" daemon [_thread_blocked, id=25]
0x006f4898 JavaThread "http-8080-Processor15" daemon [_thread_blocked, id=24]
0x006f3cd0 JavaThread "http-8080-Processor14" daemon [_thread_blocked, id=23]
0x006f3108 JavaThread "http-8080-Processor13" daemon [_thread_blocked, id=22]
0x006f2540 JavaThread "http-8080-Processor12" daemon [_thread_blocked, id=21]
0x006f1978 JavaThread "http-8080-Processor11" daemon [_thread_blocked, id=20]
0x006f0db0 JavaThread "http-8080-Processor10" daemon [_thread_blocked, id=19]
0x006f0388 JavaThread "http-8080-Processor9" daemon [_thread_blocked, id=18]
0x0046e6a8 JavaThread "http-8080-Processor8" daemon [_thread_blocked, id=17]
0x0046db10 JavaThread "http-8080-Processor7" daemon [_thread_blocked, id=16]
0x0046cfa8 JavaThread "http-8080-Processor6" daemon [_thread_blocked, id=15]
0x0046c440 JavaThread "http-8080-Processor5" daemon [_thread_blocked, id=14]
0x0046b8d8 JavaThread "http-8080-Processor4" daemon [_thread_blocked, id=13]
0x0046adb0 JavaThread "http-8080-Processor3" daemon [_thread_blocked, id=12]
0x006efa90 JavaThread "http-8080-Processor2" daemon [_thread_blocked, id=11]
0x006f01c0 JavaThread "http-8080-Processor1" daemon [_thread_blocked, id=10]
0x006da168 JavaThread "ContainerBackgroundProcessor[StandardEngine[Catalina]]" daemon [_thread_blocked, id=9]
0x000e9a80 JavaThread "Low Memory Detector" daemon [_thread_blocked, id=7]
0x000e74f0 JavaThread "CompilerThread0" daemon [_thread_blocked, id=6]
0x000e6778 JavaThread "Signal Dispatcher" daemon [_thread_blocked, id=5]
0x000deb50 JavaThread "Finalizer" daemon [_thread_blocked, id=4]
0x000ddf88 JavaThread "Reference Handler" daemon [_thread_blocked, id=3]
0x00036ef0 JavaThread "main" [_thread_in_native, id=1]

Other Threads:
0x000dcef8 VMThread [id=2]
0x000eabe8 WatcherThread [id=8]

VM state:not at safepoint (normal execution)

VM Mutex/Monitor currently owned by a thread: None

Heap
def new generation total 2112K, used 2111K [0xcd000000, 0xcd220000, 0xcd710000)
eden space 2048K, 100% used [0xcd000000, 0xcd200000, 0xcd200000)
from space 64K, 99% used [0xcd210000, 0xcd21fff8, 0xcd220000)
to space 64K, 0% used [0xcd200000, 0xcd200000, 0xcd210000)
tenured generation total 8208K, used 5051K [0xcd710000, 0xcdf14000, 0xd1000000)
the space 8208K, 61% used [0xcd710000, 0xcdbfee40, 0xcdbff000, 0xcdf14000)
compacting perm gen total 8192K, used 6691K [0xd1000000, 0xd1800000, 0xd5000000)
the space 8192K, 81% used [0xd1000000, 0xd1688e40, 0xd1689000, 0xd1800000)
ro space 8192K, 64% used [0xd5000000, 0xd552a458, 0xd552a600, 0xd5800000)
rw space 12288K, 45% used [0xd5800000, 0xd5d6dc00, 0xd5d6dc00, 0xd6400000)

Dynamic libraries:
0x00010000 /u01/app/jdk1.5.0_15/bin/java
0xff3ec000 /lib/libthread.so.1
0xff380000 /lib/libdl.so.1
0xff280000 /lib/libc.so.1
0xff260000 /platform/SUNW,Sun-Fire-V245/lib/libc_psr.so.1
0xfec00000 /u01/app/jdk1.5.0_15/jre/lib/sparc/client/libjvm.so
0xff220000 /lib/libsocket.so.1
0xff250000 /usr/lib/libsched.so.1
0xff1e0000 /usr/lib/libCrun.so.1
0xff1c0000 /lib/libm.so.1
0xfeb00000 /lib/libnsl.so.1
0xfea00000 /lib/libm.so.2
0xfebd0000 /lib/libscf.so.1
0xfeae0000 /lib/libdoor.so.1
0xfe9e0000 /lib/libuutil.so.1
0xfe9c0000 /lib/libgen.so.1
0xfe980000 /lib/libmd.so.1
0xfe960000 /platform/SUNW,Sun-Fire-V245/lib/libmd_psr.so.1
0xfe940000 /lib/libmp.so.2
0xfe920000 /u01/app/jdk1.5.0_15/jre/lib/sparc/native_threads/libhpi.so
0xfe8a0000 /u01/app/jdk1.5.0_15/jre/lib/sparc/libverify.so
0xfe850000 /u01/app/jdk1.5.0_15/jre/lib/sparc/libjava.so
0xfe830000 /u01/app/jdk1.5.0_15/jre/lib/sparc/libzip.so
0xf8dd0000 /u01/app/jdk1.5.0_15/jre/lib/sparc/libnet.so
0xf8cd0000 /u01/app/jdk1.5.0_15/jre/lib/sparc/libj2pkcs11.so
0xf8ac0000 /usr/lib/libpkcs11.so
0xf8ca0000 /usr/lib/libcryptoutil.so.1
0xf7e10000 /usr/lib/security/pkcs11_softtoken_extra.so
0xf7d50000 /u01/app/oracle/oracle/product/10.2.0/db_1/lib32/libocijdbc10.so
0xf4800000 /u01/app/oracle/oracle/product/10.2.0/db_1/lib32//libclntsh.so.10.1
0xf5900000 /u01/app/oracle/oracle/product/10.2.0/db_1/lib32//libnnz10.so
0xf8a90000 /lib/libkstat.so.1
0xf7d30000 /lib/libaio.so.1
0xf7d10000 /lib/librt.so.1

VM Arguments:
jvm_args: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=/u01/app/tomcat/conf/logging.properties -Djava.endorsed.dirs=/u01/app/tom
cat/common/endorsed -Dcatalina.base=/u01/app/tomcat -Dcatalina.home=/u01/app/tomcat -Djava.io.tmpdir=/u01/app/tomcat/temp
java_command: org.apache.catalina.startup.Bootstrap start
Launcher Type: SUN_STANDARD

Environment Variables:
JAVA_HOME=/u01/app/java
CLASSPATH=/u01/app/oracle/oracle/product/10.2.0/db_1/jlib/orai18n.jar:/u01/app/oracle/oracle/product/10.2.0/db_1/jdbc/lib/ojdbc14_g.jar::/u01/app/tomcat/bin/bootstrap.jar:/u01/app/t
omcat/bin/commons-logging-api.jar
PATH=/usr/sbin:/usr/bin
LD_LIBRARY_PATH=/u01/app/jdk1.5.0_15/jre/lib/sparc/client:/u01/app/jdk1.5.0_15/jre/lib/sparc:/u01/app/jdk1.5.0_15/jre/../lib/sparc:/u01/app/oracle/oracle/product/10.2.0/db_1/lib32/
SHELL=/bin/bash

Signal Handlers:
SIGSEGV: [libjvm.so+0x4d1970], sa_mask[0]=0xffbffeff, sa_flags=0x00000004
SIGBUS: [libjvm.so+0x4d1970], sa_mask[0]=0xffbffeff, sa_flags=0x00000004
SIGFPE: [libjvm.so+0x2126f4], sa_mask[0]=0xffbffeff, sa_flags=0x0000000c
SIGPIPE: [libjvm.so+0x2126f4], sa_mask[0]=0xffbffeff, sa_flags=0x0000000c
SIGILL: [libjvm.so+0x2126f4], sa_mask[0]=0xffbffeff, sa_flags=0x0000000c
SIGUSR1: SIG_DFL, sa_mask[0]=0x00000000, sa_flags=0x00000000
SIGUSR2: SIG_DFL, sa_mask[0]=0x00000000, sa_flags=0x00000000
SIGHUP: [libjvm.so+0x43e058], sa_mask[0]=0xffbffeff, sa_flags=0x00000004
SIGINT: SIG_IGN, sa_mask[0]=0x00000000, sa_flags=0x00000000
SIGQUIT: [libjvm.so+0x43e058], sa_mask[0]=0xffbffeff, sa_flags=0x00000004
SIGTERM: [libjvm.so+0x43e058], sa_mask[0]=0xffbffeff, sa_flags=0x00000004


--------------- S Y S T E M ---------------

OS: Solaris 10 8/07 s10s_u4wos_12b SPARC
Copyright 2007 Sun Microsystems, Inc. All Rights Reserved.
Use is subject to license terms.
Assembled 16 August 2007

uname:SunOS 5.10 Generic_120011-14 sun4u (T2 libthread)
rlimit: STACK 8192k, CORE infinity, NOFILE 65536, AS infinity
load average:0.27 0.12 0.07

CPU:total 1 has_v8, has_v9, has_vis1, has_vis2, is_ultra3

Memory: 8k page, physical 1048576k(103088k free)

vm_info: Java HotSpot(TM) Client VM (1.5.0_15-b04) for solaris-sparc, built on Feb 9 2008 02:45:40 by unknown with unknown Workshop:0x550