You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Kim Goings <ki...@levelfivesolutions.com> on 2005/06/20 18:08:18 UTC
mystery table name
As this is my first post, let me say that I think iBatis is FANTASTIC!
Now, on to business.
I'm getting an exception back from an update statement which indicates
that the SQL contains an invalid table name, yet the debug output from
iBatis shows a different (correct) table name in the statement. It
seems the exception doesn't match up with what should be going over the
wire. Could there be some kind of caching going on with the statements
somewhere? I don't doubt that I had the name misspelled at some point.
Can anyone provide any more insight on where I should look? I've been
chasing this for a while, so it may be something obvious I'm just not
seeing. Trace below.
|aef|09:43:00.033|DEBUG|{pstm-100078} PreparedStatement: UPDATE
FREQUENT_MEMBER_CLUB SET ATTENDEE_ID = ?, TYPE = ?,
COMPANY = ?, MEMBER_ID = ?, MODIFIED_BY = ? WHERE ID = ?
[http-8080-Processor25|java.sql.PreparedStatement]
|aef|09:43:00.041|DEBUG|{pstm-100078} Parameters: [2, 0, fdasfd,
ffdsafa, user, 3] [http-8080-Processor25|java.sql.PreparedStatement]
|aef|09:43:00.063|DEBUG|{pstm-100078} Types: [java.lang.Integer,
java.lang.Integer, java.lang.String, java.lang.String,
java.lang.String, java.lang.Integer]
[http-8080-Processor25|java.sql.PreparedStatement]
|aef|09:43:53.471|ERROR|<?xml version="1.0" encoding="UTF-8"?>
<message>Could not save travel profile:
com.levelfivesolutions.eventmgr.dao.AttendeeTravelProfile@9</
message><throwable>com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in config/FrequentMemberClub.xml.
--- The error occurred while applying a parameter map.
--- Check the
com.levelfivesolutions.eventmgr.dao.AttendeeFrequentMemberClub.update-
InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]Invalid object name 'FREQUENCT_MEMBER_CLUB'.
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]Invalid object name 'FREQUENCT_MEMBER_CLUB'.
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdat
e(GeneralStatement.java:87)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecut
orDelegate.java:500)
at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl
.java:89)
at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.update(SqlMapClientImpl.j
ava:61)
<snip/>
Thanks,
Kim