On 9/28/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hey, > Im having some difficulties inserting rows into ms access. The error i get > is: > > ... > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in org/hisp/dhis/hmis/RoutineData.ibatis.xml. --- > The error occurred while applying a parameter map. > --- Check the addRoutineDataValue-InlineParameterMap. > --- Check the parameter mapping for the 'id' property. > --- Cause: java.sql.SQLException: [Microsoft][ODBC Microsoft Access > Driver]Invalid SQL-datatype
You have id both in your select key and the inserted value, and the error said "while applying the *parameter* map"... What datatype is your "id" property of the object you're inserting? -- I tend to view "truly flexible" by another term: "Make everything equally hard". -- DHH
