<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
        <table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                <tbody>
                        <tr>
                                <td>
                                        <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                                                <tbody>
                                                        <tr>
                                                                <td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
                                                                        <h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
                                                                        <!-- To have a header image/logo replace the name below with your img tag -->
                                                                        <!-- Email clients will render the images when the message is read so any image -->
                                                                        <!-- must be made available on a public server, so that all recipients can load the image. -->
                                                                        <a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
                                                                </td>
                                                        </tr>
                                                        <tr>
                                                                <td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Oracle User Type Mappings
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/ThisRegistrationSucks">Bob Frapples</a> in <i>Datasource Configuration</i> - <a href="http://community.jboss.org/message/552379#552379">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>I have inherited an application system where all of the business logic takes place in the database.  All of the application calls to the database interface with Functions and Stored Procedures and use Oracle User Data Types as both IN and OUT parameters.  I'm working on converting the front end to use Spring w/ Hibernate and I am extending the o<span style="font-size: 10pt;">rg.springframework.jdbc.object.StoredProcedure class to interact with the database.</span> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>If I define the datasource in the Spring configuration file I am able to call getConnection().setTypeMap(Map<String, Class<?>> on the datasource and everything works fine. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>However I would like to configure the datasource in JBoss and use a JNDI lookup to get a connection from the pool.  When I do this, the .setTypeMap(Map<String, Class<?>> method no longer seems to work.  I keep getting the exception:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>java.lang.ClassCastException: oracle.sql.STRUCT cannot be cast to ............</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I tried editing the standardjbosscmp-jdbc.xml file and adding the mappings there but that did not work.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>So how can I set the Type Map for the JBoss DataSource?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>JBoss 5.1</p><p>Spring 3.0</p><p>Hibernate 3.3</p><p>JDK 6</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanks</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000080; font-size: 10pt; "><p><span style="color: #000080;"><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p></span></p></span></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/552379#552379">going to Community</a></p>
        <p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>