在JSP中能用ORACLE的OCI8驱动吗？

[cg4112]

请给个例子，如果不能运行是不是和WEB SERVER服务器配置有关？我的服务器是iplanet web server4.1

[gdsean]

你安装oracle的客户端了没有？？
没有的话你是不能使用OCI8的

[cg4112]

装了，而且就在本地运行。

[chenxk]

同意gdsean(摇滚java)的意见，JSP所在机器上装了Oracle客户，就可以用OCI8了，因为JSP是服务器端脚本,所以与Applet不同，Applet必须使用thin。

[hem]

import java.net.*;
import java.io.*;
import java.sql.*;

public class oci{
public static void main(String argv[]){
try{
String driv="oracle.jdbc.driver.OracleDriver";
Class.forName(driv);
String Url_="jdbc:oracle:oci8:@gwdb01";
Connection con = DriverManager.getConnection(Url_);
}catch(Exception ex){
System.out.println(ex.toString());
}
}
}



[root@denet7 csdn]# javac oci.java
[root@denet7 csdn]# java oci
method unknown (eip = 4453ce6a)
SIGSEGV 11* segmentation violation
si_signo [11]: SIGSEGV 11* segmentation violation
si_errno [0]: Success
si_code [0]: SI_USER [pid: 0, uid: 0]
stackpointer=0xbfffd334

Full thread dump Classic VM (1.2.2-I, green threads):
"Finalizer" (TID:0x40ea2320, sys_thread_t:0x8108b50, state:CW) prio=8
at java.lang.Object.wait(Native Method)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:112)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:127)
at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:174)
"Reference Handler" (TID:0x40ea23b0, sys_thread_t:0x8103e00, state:CW) prio=
10
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Object.java:424)
at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:114)
"Signal dispatcher" (TID:0x40ea23e0, sys_thread_t:0x8101f48, state:CW) prio=
5
"main" (TID:0x40ea21e0, sys_thread_t:0x804cea8, state:R) prio=5
ode)
at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:159)
at oci.main(oci.java:11)
Monitor Cache Dump:
java.lang.Class@40E142A8/41257278: owner "main" (0x804cea8) 2 entries
java.lang.ref.Reference$Lock@40EA23C0/40ED78A8: <unowned>
Waiting to be notified:
"Reference Handler" (0x8103e00)
java.lang.ref.ReferenceQueue$Lock@40EA2338/40ED7D78: <unowned>
Waiting to be notified:
"Finalizer" (0x8108b50)
oracle.jdbc.oci8.OCIDBAccess@40E15590/4126A920: owner "main" (0x804cea8) 1 entry
Registered Monitor Dump:
Invoker change lock: <unowned>
utf8 hash table: <unowned>
JNI pinning lock: <unowned>
JNI global reference lock: <unowned>
BinClass lock: <unowned>
Class linking lock: <unowned>
System class loader lock: <unowned>
Code rewrite lock: <unowned>
Heap lock: <unowned>
Monitor cache lock: owner "main" (0x804cea8) 1 entry
Dynamic loading lock: <unowned>
Monitor IO lock: <unowned>
User signal monitor: <unowned>
Waiting to be notified:
"Signal dispatcher" (0x8101f48)
Child death monitor: <unowned>
I/O monitor: <unowned>
Alarm monitor: <unowned>
Waiting to be notified:
<unknown thread> (0x8058310)
Thread queue lock: owner "main" (0x804cea8) 1 entry
Monitor registry: owner "main" (0x804cea8) 1 entry

[root@denet7 csdn]#


请指教。

[backlove]

设的口令和用户名是空
你的oracle服务器没设口令和用户名？不可能吧

[hawaii]

1、在Net assistant中配置服务xxxx，指定ip, port, sid。
2、url = "jdbc:oracle:oci8:@xxxx"即可。