Q: Where to get the Oracle JDBC driver?
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:
(make sure old driver is not in your classpath)
java.sql.SQLException: ORA-01009: missing mandatory parameter
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:797)
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:221)
at com.websina.persistence.PersonEntity.load(PersonEntity.java)
at com.websina.bean.Person.login(Person.java)
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.
* Reference brought to you by
Bugzero, it's more than just issue tracking software!
|
Home -
FAQs
|
|