oracle jdbc driver ------------------ Key: JBAS-1533 URL: https://jira.jboss.org/jira/browse/JBAS-1533 Project: JBoss Application Server Issue Type: Feature Request Security Level: Public(Everyone can see) Components: CMP service Affects Versions: JBossAS-3.2.7 Final Environment: any Reporter: Shaun Appleton Priority: Minor Whilst looking into a problem I have tried using the latest Oracle 9.2 driver (the 9.2.0.5 version of ojdbc14.jar). When running this it gave a java.sql.SQLException : invalid conversion. Doing a trace showed that a numeric type was being used instead of an integer. The solution to this was to re-instate the SMALLINT jdbc type in the standardjbosscmp-jdbc.xml i.e. change - Code: <mapping> <java-type>java.lang.Short</java-type> <jdbc-type>NUMERIC</jdbc-type> <!-- <jdbc-type>SMALLINT</jdbc-type> this resulted in a ClassCastException --> <sql-type>NUMBER(5)</sql-type> </mapping> to Code: <mapping> <java-type>java.lang.Short</java-type> <jdbc-type>SMALLINT</jdbc-type> <sql-type>NUMBER(5)</sql-type> </mapping> It appears that Oracle have improved the driver so that the ClassCastException no longer occur. Should the next version of JBoss include the above change and reccomend that ojdbc14.jar (written 1.4 jvms) is used instead of classes12.jar (wriiten for 1.2 and 1.3 jvms)? The current (3.2.7) standardjbosscmp-jdbc.xml states to use classes12.jar 'or you will suffer'