OCI jdbc connection with Tru64

Hi,
I'm trying to connect to a Oracle 8i database on a Tru64 OS with
jdbcracleci8 driver. It doesn't work, because I get a segmentation
violation (see below). It works fine with thin driver, but I need a
connection with the tns_alias, so I want to use the oci driver.

Thanks
Martina

<snip>
String url = jdbcracleci8:@" + tnsAlias;
Class.forName(conf.getProperty("iopt.jdbc.driver") );
theDbc = DriverManager.getConnection(url, user, pwd );
</snip>


segmentation violation at 0x3ffbff46ea0
r00 = 0x000000014288f818 r16 = 0x000000014288f818
r01 = 0x000003fffff02570 r17 = 0x0000000000000004
r02 = 0x000000014288f800 r18 = 0x0000000000000010
r03 = 0x0000000000000000 r19 = 0x00000000401c7eb0
r04 = 0x0000000000000000 r20 = 0x000000014288f818
r05 = 0x0000000000000010 r21 = 0x00000000401c7ee0
r06 = 0x00000000401c7eb0 r22 = 0x0000000000000000
r07 = 0x0000000000000010 r23 = 0x000000014288f7f8
r08 = 0x00000001427a0d00 r24 = 0x0000000000000000
r09 = 0x0000000020000230 r25 = 0x000003ffc0099770
r10 = 0x00000001427a0d00 r26 = 0x000003000290b1f8
r11 = 0x00000000401c7eb0 r27 = 0x000003ffbff46e60
r12 = 0x000000014288f818 r28 = 0xffffffffffffffff
r13 = 0x000000011fff7400 r29 = 0x000003fffff25100
r14 = 0x000000000000000a r30 = 0x000000011fff6720
r15 = 0x000000011fff68b0 r31 = 0x0000000000000000
Stack trace:
pc 0x03ffbff8f360 sp 0x140033260 debug_full_trace
pc 0x03ffbff8e1a4 sp 0x1400334f0 einfo_segv_handler
pc 0x03ff800d0b9c sp 0x140033560 __sigtramp
pc 0x03ffbff46ea0 sp 0x11fff6720 jni_GetByteArrayRegion
pc 0x03000290b1f4 sp 0x11fff6730
pc 0x00003e8764c8 sp 0x11fff67a0 -1:
oracle/jdbc/oci8/OCIDBAccess.do_open([BI[BI[BI[BII)I
pc 0x03ffbff9d188 sp 0x11fff6890 unpack_to_stack_and_call
pc 0x03ffbff9d12c sp 0x11fff68c0 unpack_and_call
pc 0x03ffbff955f0 sp 0x11fff68d0 make_native_call
pc 0x03ffbff35380 sp 0x11fff69a0 interpret
pc 0x03ffbff35380 sp 0x11fff69a0 434:
oracle/jdbc/oci8/OCIDBAccess.logon(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/util/PropertiesLoracle/jdbc/dbaccess/DBConversion;
pc 0x03ffbff35380 sp 0x11fff69a0 175:
oracle/jdbc/driver/OracleConnection.<init>(Loracle/jdbc/dbaccess/DBAccess;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/util/PropertiesV
pc 0x03ffbff35528 sp 0x11fff7280 interpret
pc 0x03ffbff951b4 sp 0x11fff7d60 exec_vararg
pc 0x03ffbff94c38 sp 0x11fff7e10 interp_wrapper
pc 0x03ffbff9ce34 sp 0x11fff7e40 comp_interp_stub
pc 0x00003e861848 sp 0x11fff7ec0 234:
oracle/jdbc/driver/OracleDriver.getConnectionInstance(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/util/PropertiesLjava/sql/Connection;
pc 0x03ffbff9d188 sp 0x11fff7f50 unpack_to_stack_and_call
pc 0x03ffbff9d12c sp 0x11fff7f70 unpack_and_call
pc 0x03ffbff955f0 sp 0x11fff7f80 make_native_call
pc 0x03ffbff35380 sp 0x11fff8040 interpret
pc 0x03ffbff35380 sp 0x11fff8040 540:
oracle/jdbc/driver/OracleDriver.connect(Ljava/lang/String;Ljava/util/PropertiesLjava/sql/Connection;
pc 0x03ffbff951b4 sp 0x11fff8920 exec_vararg
pc 0x03ffbff94c38 sp 0x11fff89d0 interp_wrapper
pc 0x03ffbff9ce34 sp 0x11fff8a00 comp_interp_stub
pc 0x00003e85df80 sp 0x11fff8a80 154:
java/sql/DriverManager.getConnection(Ljava/lang/String;Ljava/util/Properties;Ljava/lang/ClassLoaderLjava/sql/Connection;
pc 0x03ffbff9d118 sp 0x11fff8ad0 unpack_and_call
pc 0x03ffbff955f0 sp 0x11fff8ae0 make_native_call
pc 0x03ffbff35380 sp 0x11fff8b90 interpret
......

on 10/18/2004 9:42 PM Martina Wrote:
> Hi,
> I'm trying to connect to a Oracle 8i database on a Tru64 OS with
> jdbcracleci8 driver. It doesn't work, because I get a segmentation
> violation (see below). It works fine with thin driver, but I need a
> connection with the tns_alias, so I want to use the oci driver.
>
> Thanks
> Martina
>
> <snip>
> String url = jdbcracleci8:@" + tnsAlias;
> Class.forName(conf.getProperty("iopt.jdbc.driver") );
> theDbc = DriverManager.getConnection(url, user, pwd );
> </snip>
[snip]

A segmentation fault most probably indicates that there is a mismatch
betwee the java driver version and the oci library version.
I had a similar problem with a oracle9i home(oci from 9i) and
the java drivers were from Jdeveloper 10g on linux. Once I used the
9i java driviers(from 9i home) instead of the ones supplied with
jdeveloper, the issue was resolved.

Regards,
--
Shanmu.