One of our beans has a byte[] field, stored in a LONG RAW column on oracle. We never had issues with jboss 3.2.3 and earlier releases. We just switched to 3.2.4 and we start having some issues. We get an SqlException "invalid column type". I wrote a very simple bsh script to narrow my problem's cause: what it does is create an entity, then use the findByPrimaryKey finder to retrieve it, and try to get the byte[] field. All of that works just fine in 3.2.3 but i get the sqlException when calling the getter of the byte[] field with 3.2.4

The same also happens when calling the setter of that field.

Please find the stacktrace below.

Has this been reported already? If so I'm sorry for duplicating the info... couldn't find it on sf.net nor this forum...Haven't had the chance to try this in 3.2.5 or one of the 3.2.6RC's.

Any suggestion or info will be more than welcome!

Cheers,

greg

--------------Here's the stacktrace i get: ($Proxy789 is the proxy to my cmp bean and poddata is the byte[] field in question)java.sql.SQLException: Invalid column type at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:274) at oracle.jdbc.driver.OracleStatement.getBLOBValue(OracleStatement.java:3151) at oracle.jdbc.driver.OracleResultSetImpl.getBLOB(OracleResultSetImpl.java:480) at oracle.jdbc.driver.OracleResultSetImpl.getBlob(OracleResultSetImpl.java:533) at org.jboss.resource.adapter.jdbc.WrappedResultSet.getBlob(WrappedResultSet.java:203) at org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil$6.readResult(JDBCUtil.java:591) at org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil$AbstractResultSetReader.get(JDBCUtil.java:402) at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.loadArgumentResults(JDBCAbstractCMPFieldBridge.java:430) at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.loadInstanceResults(JDBCAbstractCMPFieldBridge.java:379) at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:188) at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:72) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:620) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:602) at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:355) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEntity(CachedConnectionInterceptor.java:352) at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:261) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185) at org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:118) at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:175) at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:89) at org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:54) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:120) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) at org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:484) at org.jboss.ejb.Container.invoke(Container.java:723) at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:359) at org.jboss.ejb.plugins.local.EntityProxy.invoke(EntityProxy.java:44) at $Proxy789.setPoddata(Unknown Source)

(btw is it "normal" that i can only see the 1st page of a search result on this forum? when i try to get to the next one i get a "no results found" message..?)

Would it be the addition of "Blob blob = rs.getBlob(index);" since jboss-3.2.4 in JDBCUtil that would be not appreciated by the oracle driver? In previous version it was doing a getBinaryStream(index) on the resultset, while now it's trying to it through a jdbc blob object !?

Will try these drivers when we get a chance (we have a workaround for now, and other priorities have shown up). Our oracle db is still version 8i, so I think our drivers are of the same generation. It appears 10g drivers might be working with oracle 8i, which I did not know.