[jboss-jira] [JBoss JIRA] Closed: (JBAS-1533) oracle jdbc driver

[Shaun Appleton (JIRA)]

     [ https://jira.jboss.org/jira/browse/JBAS-1533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shaun Appleton closed JBAS-1533.
--------------------------------

    Resolution: Done


Closed as not required by reporter anymore.

> 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'

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira