Thanks for the replies guys. Sorry for the late response.. The id property doesnt exist in the object im inserting, its only an internal identifier in the access database. In the database this is defined as Number.
And i am stuck with access, as this system is already deployed and widely used.. Any help on how to solve this would ensure you a place in heaven ;) > 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 >
