I have no way of changing anyhing about the application, sadly. I will try your second soulution., and tell you how it went.. thanks in advance ;)
> If you can change the "Number" id to "AutoNumber" you won't have to do the > combined > select/insert thing... if you can't, well, I'm not an iBatis expert but it > sounds like > you'll have to do the selecting of the next id separate from the insert. > Of course then > you might have to worry about multiple threads getting the same "next" > id... > > b > > [EMAIL PROTECTED] wrote: >> 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 >>> >> >> >> >
