Re: fetch out of sequence

ok, thanks... i have been replaced older ibatis jars now, i get this error... com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in es/xx/dao/rdb/usuario.xml. --- The error occurred while applying a parameter map. --- Check the Usuario.getUsuariosRefPM. ---

Re: DAO catch SQLexceptions

Thank you for the prompt answer. You are right. The specific situation I described will return null. That still leaves the question, in my mind, about catching SQLExceptions in general. There may be other situations that cause an SQLException, such as an invalid SELECT statement. Is

Re: iBatis, Spring and postgres stored procedure

Thanks Volker, I receive the same error even when using {? = call insert_country(?, ?, ?, ?)} Danke im Voraus! On 12/3/05, Volker Reichel [EMAIL PROTECTED] wrote: lunohodo, your stored procedure returns a value to the caller (the insert_id) but your SQLMap does not provide an OUT

Re: DAO catch SQLexceptions

OK. I had a closer look and found it. It seems that there is an exception thrown, DaoException, that can be caught and acted upon. This is what I'll use. Thnaks, again, for the response. Edwin - Original Message - From: Edwin S Lukaweski [EMAIL PROTECTED] To:

Re: fetch out of sequence

Juan, Sorry I missed the change for namespaces. If you download the source from the wiki it should work fine for you. (I even tested with your sample code) Regards, Mike Fagan Juan Cañadas wrote: ok, thanks... i have been replaced older ibatis jars now, i get this error...

how to commit a connection?

I have an application that uses ibatis and an older legacy database schema, both in the same mysql database. I would like to share the same connection to ibatis methods and the legacy code, so I could use transactions to control both applications I have a snippet as follows SqlMapClient

How to use multiple groupBy in resultMap?

Hi, How can I use groupBy in resultMap more than once? Zsolt

Re: DAO catch SQLexceptions

Some database drivers might even return an error code as part of the Exception. You can examine that and find out exactly what went wrong. For example, IBM's DB2 has a mapping of error code = what went wrong.

Problem with iterate to form an IN clause

I can't seem to get this to work in my Oracle database: sg.saved_graph_id IN #paramSavedGraphIdList[]# paramSavedGraphIdList is an ArrayList filled with Integer objects. Here is the error I'm getting:Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while

Default transaction isolation level

Is there a way to set the isolation level on all connections? I want all my reads to be dirty reads. Easily done via the xml config. Does an xml attribute exist where i can define the isolation level? I know that this can be done via DaoManager.startTransaction(int isolationLevel), but I would