Title: Unable to load a ResultSet column into a variable of type 'int'

Not sure why I get this exception, below is my table definition, jaws mapping and exception I received from my CMP entityBean, thanks for helping out.  E

SQL> desc star.articles;
 Name                            Null?    Type
 ------------------------------- -------- ----
 ARTICLE_ID                      NOT NULL NUMBER
 LANG                            NOT NULL VARCHAR2(3)
 STATUS                          NOT NULL VARCHAR2(4)
 IMAGE_IND                       NOT NULL NUMBER
 TRANSLATION_IND                 NOT NULL NUMBER
 ZDNET_IND                       NOT NULL NUMBER
 REVIEW_IND                      NOT NULL NUMBER
 MM_IND                          NOT NULL NUMBER
 FEED_NAME                       NOT NULL VARCHAR2(16)
 CREATE_DATE                     NOT NULL DATE
 MODIFIED_DATE                   NOT NULL DATE
 FEED_ID                                  VARCHAR2(30)
 INDICATOR1                               NUMBER
 INDICATOR2                               NUMBER
 PUB_DATE                                 DATE
 SECTION                                  VARCHAR2(32)
 HEADLINE                                 VARCHAR2(200)
 AUTHOR                                   VARCHAR2(200)
 KEYWORDS                                 VARCHAR2(512)






       <entity>
         <ejb-name>ArticleBean</ejb-name>
         <table-name>star.articles</table-name>
         <create-table>false</create-table>
         <remove-table>false</remove-table>
         <tuned-updates>true</tuned-updates>
         <read-only>false</read-only>
         <time-out>300</time-out>
         <cmp-field>
           <field-name>id</field-name>
           <column-name>article_id</column-name>
           <sql-type>NUMBER</sql-type>
           <jdbc-type>INTEGER</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>lang</field-name>
           <column-name>lang</column-name>
           <sql-type>VARCHAR(3)</sql-type>
           <jdbc-type>VARCHAR</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>status</field-name>
           <column-name>status</column-name>
           <sql-type>VARCHAR(4)</sql-type>
           <jdbc-type>VARCHAR</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>imageInd</field-name>
           <column-name>image_ind</column-name>
           <sql-type>NUMBER</sql-type>
           <jdbc-type>INTEGER</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>transInd</field-name>
           <column-name>translation_ind</column-name>
           <sql-type>NUMBER</sql-type>
           <jdbc-type>INTEGER</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>zdnetInd</field-name>
           <column-name>zdnet_ind</column-name>
           <sql-type>NUMBER</sql-type>
           <jdbc-type>INTEGER</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>reviewInd</field-name>
           <column-name>review_ind</column-name>
           <sql-type>NUMBER</sql-type>
           <jdbc-type>INTEGER</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>mmInd</field-name>
           <column-name>mm_ind</column-name>
           <sql-type>NUMBER</sql-type>
           <jdbc-type>INTEGER</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>feedName</field-name>
           <column-name>feed_name</column-name>
           <sql-type>VARCHAR(16)</sql-type>
           <jdbc-type>VARCHAR</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>createDate</field-name>
           <column-name>create_date</column-name>
           <sql-type>DATE</sql-type>
           <jdbc-type>DATE</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>modifiedDate</field-name>
           <column-name>modified_date</column-name>
           <sql-type>DATE</sql-type>
           <jdbc-type>DATE</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>feedId</field-name>
           <column-name>feed_id</column-name>
           <sql-type>NUMBER</sql-type>
           <jdbc-type>INTEGER</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>indicator1</field-name>
           <column-name>indicator1</column-name>
           <sql-type>NUMBER</sql-type>
           <jdbc-type>INTEGER</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>indicator2</field-name>
           <column-name>indicator2</column-name>
           <sql-type>NUMBER</sql-type>
           <jdbc-type>INTEGER</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>pubDate</field-name>
           <column-name>pub_date</column-name>
           <sql-type>DATE</sql-type>
           <jdbc-type>DATE</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>section</field-name>
           <column-name>section</column-name>
           <sql-type>VARCHAR(32)</sql-type>
           <jdbc-type>VARCHAR</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>headline</field-name>
           <column-name>headline</column-name>
           <sql-type>VARCHAR(200)</sql-type>
           <jdbc-type>VARCHAR</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>author</field-name>
           <column-name>author</column-name>
           <sql-type>VARCHAR(200)</sql-type>
           <jdbc-type>VARCHAR</jdbc-type>
         </cmp-field>
         <cmp-field>
           <field-name>keywords</field-name>
           <column-name>keywords</column-name>
           <sql-type>VARCHAR(512)</sql-type>
           <jdbc-type>VARCHAR</jdbc-type>
         </cmp-field>
       </entity>





[ArticleBean] findByPrimaryKey(com.starmedia.helix.ArticlePK@a6f3a)
[ArticleBean] [com.starmedia.helix.ArticlePK@a6f3a] getHeadline()
[ArticleBean] TRANSACTION ROLLBACK EXCEPTION:Load failed; nested exception is:
        java.sql.SQLException: Unable to load a ResultSet column into a variable of type 'int': java.io.StreamCorruptedException: InputStream does not contain a serialized object; nested exception is:

        java.rmi.ServerException: Load failed; nested exception is:
        java.sql.SQLException: Unable to load a ResultSet column into a variable of type 'int': java.io.StreamCorruptedException: InputStream does not contain a serialized object

[ArticleBean] java.rmi.ServerException: Load failed; nested exception is:
[ArticleBean]   java.sql.SQLException: Unable to load a ResultSet column into a variable of type 'int': java.io.StreamCorruptedException: InputStream does not contain a serialized object

[ArticleBean] java.sql.SQLException: Unable to load a ResultSet column into a variable of type 'int': java.io.StreamCorruptedException: InputStream does not contain a serialized object

[ArticleBean]   at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultObject(JDBCCommand.java:482)
[ArticleBean]   at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultObject(JDBCCommand.java:498)
[ArticleBean]   at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.handleResult(JDBCLoadEntityCommand.java:115)
[ArticleBean]   at org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:59)

[ArticleBean]   at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:159)
[ArticleBean]   at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:78)
[ArticleBean]   at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadEntity(JAWSPersistenceManager.java:150)
[ArticleBean]   at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:341)
[ArticleBean]   at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:192)

[ArticleBean]   at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:186)

Reply via email to