ARRRRRGHHH.... nevermind! The log output was a red-herring... it wasn't blowing up on that sql call at all, but on the
next call it was making, which was also using that same activityGroupId... but it was being left out of the parameter
map in that case.... sigh... what a day.
b
Larry Meadors wrote:
Have you tried straight JDBC?
Larry
On 4/24/06, Ben Munat <[EMAIL PROTECTED]> wrote:
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
