----- Original Message -----
Sent: Wednesday, March 21, 2001 1:18
AM
Subject: [JBoss-user] 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)
