I've been spinning my wheels this weekend over something I just know is
stupid.
I have a simple table that I'm trying to do an insert into. The insert
succeeds (I see the row in the database), but my app keeps throwing a
java.lang.ClassCastException: java.lang.Integer
in the method where I call SqlMapClient.insert(). My database is postgreSQL
and my table has a serial id. Also note that I can load the table just fine.
My config looks like this:
<resultMap id="WebUserResultMap"
class="com.autorevenue.commands.WebUser">
<result property="id" column="id"
jdbcType="INTEGER"/>
<result property="reasonId" column="reason_id"
jdbcType="INTEGER"/>
<result property="logonLimit" column="login_limit"
jdbcType="INTEGER"/>
<result property="logonCount" column="login_count"
jdbcType="INTEGER"/>
<result property="email" column="email"
jdbcType="VARCHAR"/>
<result property="firstName" column="fname"
jdbcType="VARCHAR"/>
<result property="password" column="password"
jdbcType="VARCHAR"/>
<result property="lastName" column="lname"
jdbcType="VARCHAR"/>
<result property="companyName" column="company_name"
jdbcType="VARCHAR"/>
<result property="phone" column="phone"
jdbcType="VARCHAR"/>
<result property="phoneExt" column="phone_ext"
jdbcType="VARCHAR"/>
<result property="approved" column="approved"
jdbcType="BOOLEAN"/>
<result property="removed" column="removed"
jdbcType="BOOLEAN"/>
<result property="created" column="create_stamp"
jdbcType="TIMESTAMP"/>
</resultMap>
The insert config looks like this:
<!-- SQL statments -->
<insert id = "InsertWebUser" parameterClass =
"com.mydomain.commands.WebUser">
<selectKey keyProperty="id" resultClass="int" type="pre">
SELECT nextVal('web_user_id_seq') as id
</selectKey>
insert into web_user (id, email, reason_id, fname, lname,
company_name, phone, phone_ext, fax) VALUES
(#id#, #email#, #reasonId#, #firstName#,
#lastName#, #companyName#, #phone#, #phoneExt#, #fax#)
</insert>
The WebUser bean is backed by Integer objects instead of int. The last line
my stack trace is (where it says the error is occurring) is as follows:
return (WebUser) _sqlMap.insert ("InsertWebUser", wu);
The last lines in my debug output look fine, and as I said before the insert
works.
11-02-07 16:22:34 DEBUG [http-8080-Processor23]: {pstm-100006} Parameters:
[1663, [EMAIL PROTECTED], 9, Rich, Doe, MyCompany, 9999999999, 123,
1131234567]
11-02-07 16:22:34 DEBUG [http-8080-Processor23]: {pstm-100006} Types:
[java.lang.Integer, java.lang.String, java.lang.Integer, java.lang.String,
java.lang.String, java.lang.String, java.lang.String, java.lang.String,
java.lang.String]
Pretty frustrated . thanks in advance for any advice.
