前面的一个问题解决了,是我的oracle的问题,没有安装好! 可是后一个还是有异常 java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1403) at java.lang.Runtime.loadLibrary0(Runtime.java:788) at java.lang.System.loadLibrary(System.java:832) at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:294) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:287) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:442) 奇怪! at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:321) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at jdbc3.DataAccessBean.main(DataAccessBean.java:70)Exception in thread "main"
我现在把url改成如下: String url = "jdbc:oracle:oci9:@mysid";//mysid是我的service name,不包括ip和port 异常如下 java.sql.SQLException: Invalid Oracle URL specified at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:203) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at jdbc3.DataAccessBean.main(DataAccessBean.java:70) 是不是还需要设定什么本地连接?我现在没有改动任何设置!
所有的配置我都没有改动过。
什么地方可以查SID,我忘记安装的时候是否改动过了!
我的oracle版本9.0.1.1.1。
sqlplus能起来说明数据库已经在运行。不过对于你的问题,还没想明白为什么
服务只有
OracleOraHome90ClientCache
OracleOraHome90SNMPPeerEncapsulator
OracleOraHome90SNMPPeerMasterAgent
OracleServiceORCL
select name from v$database;
也可以直接查看 init.ora文件
其实也可以说是数据库名<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@lynx:1521:netmarch";
String user="lynx";
String password="lynx";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
您的第3 个字段内容为:<%=rs.getString(3)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
他的权限大点
可是后一个还是有异常
java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1403)
at java.lang.Runtime.loadLibrary0(Runtime.java:788)
at java.lang.System.loadLibrary(System.java:832)
at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:294)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:287)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:442)
奇怪!
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:321) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at jdbc3.DataAccessBean.main(DataAccessBean.java:70)Exception in thread "main"
String url = "jdbc:oracle:oci9:@mysid";//mysid是我的service name,不包括ip和port
异常如下
java.sql.SQLException: Invalid Oracle URL specified
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:203)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at jdbc3.DataAccessBean.main(DataAccessBean.java:70)
是不是还需要设定什么本地连接?我现在没有改动任何设置!