ibatis-user-java mailing list archives

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


Mime
View raw message