Re: java.sql.SQLException: You cannot commit during a managed transaction

The differences between JDBC and EXTERNAL are simply that EXTERNAL does NOTHING when commit and rollback are called (which works for 99% of managed transaction containers). http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-2/ibatis-2-core/src/com/ibatis/sqlmap/engine/transaction/external/Ex

Re: java.sql.SQLException: You cannot commit during a managed transaction

OK, I'll try it. But I've got a doubt. There is code into my application that runs over JBoss but it doesn't have transactions managed by application server. For example, all classes stored in a deployed WAR file. In this case, I wouldn't like to delegate to an EXTERNAL tx manager, would commitTr

Re: java.sql.SQLException: You cannot commit during a managed transaction

I'll try one more time - it IS possible if you use the EXTERNAL transaction manager. Give it a try - surely it wouldn't take more than 5 minutes of your time to try it??? Jeff Butler On Fri, Oct 3, 2008 at 4:03 PM, Chema <[EMAIL PROTECTED]> wrote: > I guess it's not possible. > I 'm going to use

linked server with list parameter

Hi, I am trying to join two tables across a linked server while iterating through a list parameter . I haven't been able to find the right syntax for this to work. The below statement is not working: select * from openquery(LINKED_SERVER, 'select

Re: java.sql.SQLException: You cannot commit during a managed transaction

I guess it's not possible. I 'm going to use JDBC API, I guess Thank you very much !! 2008/10/3 Kai Grabfelder <[EMAIL PROTECTED]>: > Jeff is totaly right, with this configuration iBATIS will never take part in > the container managed transactions... > > > --- Original Nachricht --- > Absender:

Re: how do I get the handle to my CacheModel...

I don't know how to do that with properties but you can do it programmatically by adding a flushstatement: daoObject.getSqlMapExecutorDelegate().getCacheModel(modelName).addFlushTriggerStatement("Foo.insertFoo"); Never tried it actually but it should work. Shantanu Upadhyaya wrote: Either my

Re: java.sql.SQLException: You cannot commit during a managed transaction

Jeff is totaly right, with this configuration iBATIS will never take part in the container managed transactions... --- Original Nachricht --- Absender: Jeff Butler Datum: 03.10.2008 21:14 > I think you should use EXTERNAL transaction manager - this is EXACTLY > why it exists. JBOSS, not iBATIS,

how do I get the handle to my CacheModel...

Either my search skills are getting bad or the iBatis documentation is not adequate. 1. I'd like to call setFlushInterval(..) using a configurable parameter which can change while the application is running. How do I get the handle to my already defined Cache model ? 2. How do I add a parameter

Re: java.sql.SQLException: You cannot commit during a managed transaction

I think you should use EXTERNAL transaction manager - this is EXACTLY why it exists. JBOSS, not iBATIS, is your transaction manager in this case. Jeff Butler On Fri, Oct 3, 2008 at 2:05 PM, Chema <[EMAIL PROTECTED]> wrote: > I don't want to keep the secret :-D > > > cacheModelsEnabled="true"

Re: java.sql.SQLException: You cannot commit during a managed transaction

I don't want to keep the secret :-D No more. And like you said, I don't use an EXTERNAL tx manager, but JDBC type I think that the only solution is perform "delete" sentences by JDBC API , so don't commit current transaction (managed by application server). What do you t

Re: java.sql.SQLException: You cannot commit during a managed transaction

iBATIS will not call commit() if you have ... I'm guessing this is NOT what you have configured - but it would be nice to see your configuration. Jeff Butler On Fri, Oct 3, 2008 at 1:44 PM, Chema <[EMAIL PROTECTED]> wrote: > I can't upgrade because my application runs over JVM 1.4 and iBat

Re: java.sql.SQLException: You cannot commit during a managed transaction

I can't upgrade because my application runs over JVM 1.4 and iBatis 2.3.0 is the last release compatible with JVM 1.4 About your question, from documentation: "The element also allows an optional attribute commitRequired that can be true or false. Normally iBATIS will not commit transactions unl

Re: How do you pass arguemtns when you use "in" a statement?

Read up on the iterator element. On Fri, Oct 3, 2008 at 10:08 AM, <[EMAIL PROTECTED]> wrote: > Are there elegant way to do this? Thanks in advance! >

How do you pass arguemtns when you use "in" a statement?

Are there elegant way to do this? Thanks in advance!

Re: Spring, Ibatis & Oracle 10G

You are querying for list - Ibatis tries to map resultset obtained after the call, which is absent, so you get no data. You should use sqlMapTemplate().update("procedure", params) and check for the out parameter in the 'params', under the key specified in the sqlmap.xml parameterMap (aParameterMap

Re: java.sql.SQLException: You cannot commit during a managed transaction

sqlMap.delete() performs a commit? That should not be the case if the tx manager is configured correctly. Whats your configuration? Could you please also try updating ibatis to 2.3.4, 2.3.0 is really old... Regards Kai --- Original Nachricht --- Absender: Chema Datum: 03.10.2008 15:01 > That d

Re: java.sql.SQLException: You cannot commit during a managed transaction

That doesn't work because sqlMap.delete() performs commit automatically. I'm using the transaction manager of JBoss , with JNDI/JDBC. Can I disabled this ? By code is not possible because Jboss TX manager throws a SQLExeception. Another w/a ? Thanls ! 2008/10/3 Kai Grabfelder <[EMAIL PROTE

Re: java.sql.SQLException: You cannot commit during a managed transaction

if you are using CTM (container managed transactions), like in your case, you can't start, commit or end transactions manually. The container is doing this for you. The following should work > sqlMap.delete("deleteRecords", param); If it does not I think your sqlmap configuration is not correct.

Spring, Ibatis & Oracle 10G

Hi, I'm using spring & ibatis sql maps to call an Oracle (10G) stored procedure. I can successfully call the stored proc from sql plus however when I use my code I get no data returned and no error thrown. The stored procedure takes in 7 parameters - 6 input and 1 output, the output being a of

java.sql.SQLException: You cannot commit during a managed transaction

Hello: I'm using JBoss 3.2 and EJB 2.0 with iBatis 2.3.0 I've got configured a external transaction manager in SQLMap configuration file. When an EJB component ( session bean ) tries to delete record using by iBatis sqlMap client, JBoss retrieve this error: 11:02:09,406 ERROR [Connection] Error