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