Uhm, I do not think you can execute two statements with the same connection using the jdbc-odbc bridge.
Is using Access a hard requirement for you? If it is, you need to find a real JDBC driver, which may mean you need to buy a commercial driver for it. Larry On 9/28/05, Michael Campbell <[EMAIL PROTECTED]> wrote: > 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 >