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
>
>
