MS Access selectKey question

2005-09-28 Thread chriskle
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

Re: MS Access selectKey question

2005-09-28 Thread Michael Campbell
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

Re: MS Access selectKey question

2005-09-28 Thread Larry Meadors
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