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#)
</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


Mime
View raw message