Re: fetch out of sequence

2005-12-05 Thread Juan Cañadas
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. --- Chec

Re: DAO catch SQLexceptions

2005-12-05 Thread Edwin S Lukaweski
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 ther

Re: iBatis, Spring and postgres stored procedure

2005-12-05 Thread Lunohodov
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 p

Re: DAO catch SQLexceptions

2005-12-05 Thread Edwin S Lukaweski
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: ; <[EMAIL PROTECT

Re: [Fwd: How to pass a parameter to collection property?]

2005-12-05 Thread Jeff Butler
Ahh - I see.  This is a classic example of the N+1 selects problem.  iBATIS has a good solution: use an SQL join and the iBATIS groupBy feature.  This link should help:   http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+around+the+N+Plus+1+selects+problem   Jeff Butler  

Re: [Fwd: How to pass a parameter to collection property?]

2005-12-05 Thread Jozef Hribik
Once again 'Thank you', I have tried it too, but i have problems like those described in JIRA: <>(N + 1) solution does not yield same results as lazy loading solution http://issues.apache.org/jira/browse/IBATIS-69   I have no more time to experiment what is wrong in my mapping. I will stay by u

Re: fetch out of sequence

2005-12-05 Thread Ben Munat
I'm not sure about the output parameter stuff, but the "there is no result map named..." I just saw recently... Make sure your resultMap element comes *before* the select element that uses it in your sqlMap file... hope that helps. b Juan Cañadas wrote: ok, thanks... i have been replaced old

Re: fetch out of sequence

2005-12-05 Thread Mike Fagan
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... com.ibatis.

how to commit a connection?

2005-12-05 Thread Leonardo Kenji Shikida
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 dbclient

How to use multiple "groupBy" in resultMap?

2005-12-05 Thread Zsolt
Hi, How can I use "groupBy" in resultMap more than once? Zsolt

Re: DAO catch SQLexceptions

2005-12-05 Thread Zarar Siddiqi
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". http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.u

Re: How to use multiple "groupBy" in resultMap?

2005-12-05 Thread Paul Benedict
Can't you do this? groupBy="{prop1,prop2}" or try without the braces too. __ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs

Problem with to form an IN clause

2005-12-05 Thread ooper
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 a

Default transaction isolation level

2005-12-05 Thread dasd asda
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 li