Hi, I am hoping someone can help me. I am using jboss 2.4.4 and oracle 8i to store a CLOB field in an entity bean. When it comes to storing the beans data i would like to get a reference to the LOB to write into it. I have written a piece of code shown below in which i believe i should be able to obtain the reference. Unfortunately i get a null back. When i do get the result set back i grab its meta data which shows that there is a column called model which is of Oracle type 2005( clob presumably ). As you can see i have some debug code in there and i have placed that at the bottom the mail.
I have a CLOB in the database and i have double checked that a good few times. i have also changed the mapping in standardjaws <mapping> <java-type>java.lang.Object</java-type> <jdbc-type>JAVA_OBJECT</jdbc-type> <sql-type>CLOB</sql-type> </mapping> Any help or advice into why this does not seem to work for me would be greatly recieved. /////////////////////////////////////////////////////////// code /////////////////////////////////////////////////////////// // oracle CLOB CLOB modelClob = null; ResultSet rs = null ; try{ sl.info( " - query: " + query ) ; PreparedStatement ps = conn.prepareStatement( query ) ; rs = (ResultSetInPool)ps.executeQuery(); // debug out java.sql.ResultSetMetaData rsm = rs.getMetaData() ; for( int i = 1 ; i <= rsm.getColumnCount() ; i++ ){ sl.info( " - column name: " + rsm.getColumnName( i ) ) ; sl.info( " - column type: " + rsm.getColumnType( i ) ) ; } while( rs.next() ){ modelClob = ( CLOB ) rs.getClob( "MODEL" ) ; sl.info( " - we get: " + modelClob ) ; if ( ( modelClob != null ) && ( clobAsString != null) ){ this.writeTextToCLOB( clobAsString , modelClob ) ; } } } ............... /////////////////////////////////////////////////////////// debug /////////////////////////////////////////////////////////// [INFO,Default] BlueSky: - query: SELECT model FROM ORDERS where id = 6944 for update [INFO,Default] BlueSky: - column name: MODEL [INFO,Default] BlueSky: - column type: 2005 [INFO,Default] BlueSky: - we get: null Many thanks David Rocks Technical Lead Elevation Networks www.elevation-networks.com ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user