ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kim Goings <kim.goi...@levelfivesolutions.com>
Subject mystery table name
Date Mon, 20 Jun 2005 16:08:18 GMT
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







Mime
View raw message