oracle jdbc driver
------------------
Key: JBAS-1533
URL: http://jira.jboss.com/jira/browse/JBAS-1533
Project: JBoss Application Server
Type: Feature Request
Components: CMP service
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'
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
-------------------------------------------------------
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-Development mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-development
