Unable to load a ResultSet column into a variable of type 'int'OK,
you are probably not getting as far as being able to call the getHeadline()
method of your CMP-bean, because the container needs to instantiate (load)
the bean beforehand. During this loading I guess one of the columns which is
assigned to be an int-type (INTEGER as JDBC-type, NUMBER as SQL-type) is
empty (= NULL) which causes the Exception. Change the type to
java.lang.Integer which can handle NULL-values.
B.Vogel
----- Original Message -----
From: Ernest Chen
To: '[EMAIL PROTECTED]'
Sent: Wednesday, March 21, 2001 5:03 PM
Subject: RE: [JBoss-user] Unable to load a ResultSet column into a variable
of type 'int'
Mmm, which column/file are you talking about? My client code is just
calling getHeadline() method that returns a String. Thanks!
-----Original Message-----
From: Burkhard Vogel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 4:25 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Unable to load a ResultSet column into a variable
of type 'int'
Hi,
You are trying to load a NULL value into an int, which fails. try changing
the column from int to Integer, which should work.
B.Vogel
----- Original Message -----
From: Ernest Chen
To: '[EMAIL PROTECTED]'
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(JDBCLoadE
ntityCommand.java:115)
[ArticleBean] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleRe
sult(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(JDBCLoadEntity
Command.java:78)
[ArticleBean] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadEntity(JAWSPersistence
Manager.java:150)
[ArticleBean] at
org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager
.java:341)
[ArticleBean] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchron
izationInterceptor.java:192)
[ArticleBean] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterce
ptor.java:186)
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
