Hello all,
I have a table looks like this:
CREATE TABLE TimesheetASOrder (
TimesheetId int NOT NULL,
ActivityGroupId int NOT NULL,
DisplayOrder int NOT NULL
)
And this sql map:
<insert id="insertOrderGroup" parameterClass="java.util.Map">
insert into TimesheetASOrder (ActivityGroupId, DisplayOrder,
TimesheetId)
values (#activityGroupId#, #displayOrder#, #timesheetId#)
</insert>
And I am definitely passing in a map with three Integers with those three keys. Checked a million times, and here's the
log output:
2006-04-24 21:09:18,354 DEBUG java.sql.PreparedStatement - {pstm-100027} PreparedStatement: insert into
TimesheetASOrder (ActivityGroupId, DisplayOrder, TimesheetId) values (?, ?, ?)
2006-04-24 21:09:18,354 DEBUG java.sql.PreparedStatement - {pstm-100027}
Parameters: [144, 1, 54]
2006-04-24 21:09:18,354 DEBUG java.sql.PreparedStatement - {pstm-100027} Types: [java.lang.Integer, java.lang.Integer,
java.lang.Integer]
However, every time I try to run this, I get this back from sql server:
--- The error occurred in gov/wa/esd/totaltime/dao/ibatis/maps/Timesheet.xml.
--- The error occurred while applying a parameter map.
--- Check the insertTimesheetEntry-InlineParameterMap.
--- Check the parameter mapping for the 'activityGroupId' property.
--- Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by
this driver.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
And I have run it in a db tool using the same driver, and copy the insert
statement out of the log file.
I've been spinning around this for hours to no avail... anyone have any ideas?
b
