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 -
<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
<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'
Shaun
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3867930#3867930
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3867930
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
