Win a copy of The Journey To Enterprise Agility this week in the Agile and Other Processes forum! And see the welcome thread for 20% off.

Saravanan Alagu

Greenhorn
+ Follow
since Oct 08, 2005
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Saravanan Alagu

Guys,

Am also facing the same problem. I set all path and classpath as specified above, still am getting following exception,


Error encountered:

java.sql.SQLException: System.loadLibrary(weblogicoci37) threw java.lang.Unsatis
fiedLinkError: no weblogicoci37 in java.library.path
at weblogic.jdbc.oci.Driver.loadLibraryIfNeeded(Driver.java:243)
at weblogic.jdbc.oci.Driver.connect(Driver.java:79)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:146)
at utils.dbping.main(dbping.java:167)

Is oci.ddl is required? I'm not able to find either in oracle or weblogic install path. Weblogic 6.1 is installed in solaris and oracle 9.2 is used as database. Appreciate your quick response. Also i would like to know, whether i can use unicode inserts by using oci driver. If not could you pls. suggest me a right driver for multilingual support.

Thanks,
Saran
12 years ago
David

Do you know how this will work? If i use JDriver in weblogic, will it solve the problem.

Thanks
Saran
Hi

Looks like no issue in classpath. Probably choice of driver could be different for oracle extension classes. I put mmy question this way, how do i use oracle extension classes in weblogic6.1 to insert unicode characters. Your suggestion is very much valuable and appreciated.

Thanks
Saran
Your code looks fine. There is no problem in prepared statement as this is not precompiled. If you would like to see the actual query you need to customize prepared statement to handle this. You can get from the net search for Loggablestatement.
Group,

Am facing typical problem in casting prepared statement to oracleprepared statement. Inorder to provide multilingual support in one of our project, we followed the database type conversion for unicode support (changing varchar2 to nvarchar2). I guess setFormOfUse() in oracle prepared statement have to be used for any inserts in column of type NVARCHAR2. My application is running in weblogic6.1 and uses oracle thin driver. In code, when prepared statement is casted to oraclepreparedstatement classcastexception is thrown. Looks like weblogic8.1 supports this conversion. Any idea how to eliinate this issue in weblogic6.1.

Thanks in advance