Re: Does iBatis support Oracle object types as IN/OUT params

It does support in/out params, simply set the mode="IN|OUT|INOUT" It also supports custom type handlers so you can deal with Object types. Unfortunately I can't provide an example, but perhaps another Oracle user here can. Regards, Clinton On 5/29/07, mini <[EMAIL PROTECTED]> wrote: Does i

Re: Nested transactions?

The DAO framework is smart enough to deal with that. But yeah, you need to move your transaction management out of those methods. I understand the challenge there. There are at least 3 possible solutions: 1) Move the transaction control up to the web tier or at least higher than the service la

RE: Nested transactions?

Thanks, The only issue that you run into quite often is that you need both composite services as well as more fine grained services and both these kinds of services need to be "transaction aware". So you end of creating "layers on top of the service layer" to delegate and allow for transactions. N

Re: Nested transactions?

Nested transactions are evil*. iBATIS has a strict policy to use its powers only for good. So unfortunately no. :-) Clinton * Why? See the 'A' in ACID. http://en.wikipedia.org/wiki/ACID On 5/30/07, Sudhir, Sudhir (Contractor) <[EMAIL PROTECTED]> wrote: Does iBatis support nested transacti

Nested transactions?

Does iBatis support nested transactions? -Sudhir - This message may contain confidential information. If you are not the intended recipient, please notify the sender immediately and delete this email from your system.

executing batch file

Hi, what ist he best way to execute a batch file? Does ibatis support it? If not, could spring help me? Zsolt

RE: Sybase stored proc

Thanks for getting back. I should have pointed out in my previous mail that changes to the stored proc is not a runner unfortunately. The solution proposed on the wiki I have been trying to follow: . Use your own Connection and .setAutoCommit(true). Pass this connection into the SqlMapClient.se

RE: Sybase stored proc

Title: Sybase stored proc There are a few solutions to your problem. One it to ensure that you have a transaction started before you invoke the sp. All sp's have a default mode. The default is usually Unchained. If it is then it is required that the sp be executed within a transaction. You ca

Sybase stored proc

Hi I am calling a sybase stored proc and am getting the following error: Stored procedure may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode. I have seen the issue documented while going through the archiv

Re: selectkey in sybase

Emiliano Armellin ha scritto: thanks for the answer, I've just tried with no success the error is the same! I'm using jconnect6, asa 9 and ibatis 2.3 where is the error? ok I've found the error: it's a problem of jConnect 6 vs ASA 9 jConnect 6.x is not officially supported by ASA at

Re: selectkey in sybase

thanks for the answer, I've just tried with no success the error is the same! I'm using jconnect6, asa 9 and ibatis 2.3 where is the error? -- Emiliano Armellin W_ www.ateikon.com @_ [EMAIL PROTECTED] T_ +39 0422 452101 [EMAIL PROTECTED] ha scr