A: Oracle JDBC driver comes with Oracle, the file is classes12.zip for Oracle 8i and ojdbc14.jar for Oracle 9i (and JDK 1.4). You can also download the drivers from oracle.com (On Oracle's Download page, click on the Oracle JDBC Drivers link and select the proper version to download). Please note that, for oracle 8.16 or ealier, you must download a updated version of classes12.zip; and the ojdbc14.jar driver works only for JDK1.4 or later. Here is a possible Exception by using an out-dated clases12.zip dirver: java.sql.SQLException: ORA-01009: missing mandatory parameter If you use classes12.zip on Oracle 8i databases and Tomcat, you might need rename classes12.zip to classes12.jar, since Tomcat may not classload a zip file.
ResultSet rs = conn1.rssql("select * from table1") 这样试试
and ojdbc14.jar for Oracle 9i (and JDK 1.4). You can also download the drivers
from oracle.com (On Oracle's Download page, click on the Oracle JDBC Drivers link
and select the proper version to download). Please note that, for oracle 8.16 or ealier, you must download a updated version
of classes12.zip; and the ojdbc14.jar driver works only for JDK1.4 or later.
Here is a possible Exception by using an out-dated clases12.zip dirver: java.sql.SQLException: ORA-01009: missing mandatory parameter If you use classes12.zip on Oracle 8i databases and Tomcat, you might need rename
classes12.zip to classes12.jar, since Tomcat may not classload a zip file.
这样试试
我新建了一个odbc连接到oracle,然后在bean中把连接方式改为jdbc-odbc连接,就没问题了
就当权宜之计吧,真是郁闷
原因果然是:select*from 要改为select * from 才行!!!
谢谢tom2005