MS Access selectKey question

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

Reusing sqlmap definitions

Hello and thanks in advice I've defined 2 sqlmap A and B i need to make a query in sqlmap A that return one or more item defined with a resultmap in sqlmap B Could someone point me to any doc, example about that? Fabio

Re: Reusing sqlmap definitions

Thanks James i think it's not necessary to enable namespaces in sqlMapConfig, the most import thing is the sqlmap import order in sqlMapConfig, it's relevant (jira: ibatis-135) My error was there, reordered the sqlmap files in sqlMapConfig all works fine. Fabio James, Steven wrote:

Re: MS Access selectKey question

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

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

Re: Quetion about documents

I personally like the PDF documentation. I think the wiki is good for one off examples or learning about a specific part of iBATIS. The PDF seems to flow together more like a good book. After I'm done reading a section I usually continue reading the next section. After 15min or so I find that I've

Re: Passing logged in Username and password to iBATIS

Hi, I have even tried supyling sqlMapClient.endTransaction() and sqlMapClient.commit() after the sqlMapClient.setUserConnection(conTemp) statement. But evenI got aerror which goes like "commit() cannot be given when you use container-managed transactions". Vijai - Original Message

Re: N+ 1 selects

Give us a stack trace, too, please. Larry On 9/28/05, John Chien [EMAIL PROTECTED] wrote: Dear Sir: I follow the FAQ to fix the N+1 selects, However, I continue get the compilation error. My xml looks like: ?xml version=1.0 encoding=UTF-8 standalone=no? !DOCTYPE sqlMap PUBLIC