Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / Databases / October 2004

Tip: Looking for answers? Try searching our database.

OCI jdbc connection with Tru64

Thread view: 
Martina - 18 Oct 2004 17:12 GMT
Hi,
I'm trying to connect to a Oracle 8i database on a Tru64 OS with
jdbc:oracle:oci8 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 = jdbc:oracle:oci8:@" + 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/Properties;)Loracle/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/Properties;)V
   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/Properties;)Ljava/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/Properties;)Ljava/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/ClassLoader;)Ljava/sql/Connection;
   pc 0x03ffbff9d118 sp 0x11fff8ad0          unpack_and_call
   pc 0x03ffbff955f0 sp 0x11fff8ae0          make_native_call
   pc 0x03ffbff35380 sp 0x11fff8b90          interpret
.....
Shanmuhanathan T - 25 Oct 2004 15:10 GMT
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
[quoted text clipped - 10 lines]
> 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,
Signature

Shanmu.



Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.