ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ben Munat <b...@munat.com>
Subject weird sql server error: The specified SQL type is not supported by this driver
Date Tue, 25 Apr 2006 04:22:26 GMT
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#)

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,

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?


View raw message