ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: weird sql server error: The specified SQL type is not supported by this driver
Date Tue, 25 Apr 2006 04:32:49 GMT
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