Re: Please help me.

2007-05-31 Thread Zoran Avtarovski
I'm not sure I'm clear on this. Have you set up your connection pool in Weblogic via JNDI if so it's a simple matter matter of using the JNDI name in your transaction manager Z. > Thank you, > > That problem is solved. > Butt how do you think I must solve the problem w

Re: Please help me.

2007-05-31 Thread davypulinckx
Thank you, That problem is solved. Butt how do you think I must solve the problem with weblogic is it possible to get the configuration out of weblogic and in to sqlmapconfig. In my connectionpool of weblogic I have configured the driverclass name, url, password, etc…. Greetz Davy >- Oo

RE: executing batch file

2007-05-31 Thread Zsolt Koppany
Nathan, I mean an external file. INSERT ..; INSERT ..; DELETE .; Zsolt _ From: Nathan Maves [mailto:[EMAIL PROTECTED] Sent: Thursday, May 31, 2007 11:31 PM To: user-java@ibatis.apache.org Subject: Re: executing batch file Not quite sure what you are asking? Do you have a

Re: Please help me.

2007-05-31 Thread Nathan Maves
Pretty simple actually, you can pass a string (non binding) variable into a sqlmap example select * from $schema$.person where id = #id# Note the use of $$ and ##. The $$ uses a string substitution and not a jdbc parameter. On 5/31/07, Davy Pulinckx <[EMAIL PROTECTED]> wrote: Hellow

Re: executing batch file

2007-05-31 Thread Nathan Maves
Not quite sure what you are asking? Do you have an external file with statements in it that need to be executed? Or are you asking if ibatis can do batch inserts/updates ? Nathan On 5/30/07, Zsolt Koppany <[EMAIL PROTECTED]> wrote: Hi, what ist he best way to execute a batch file? Does ibati

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

2007-05-31 Thread Clinton Begin
depends on your driver, but I'd guess OBJECT or nothing clinton On 5/31/07, mini <[EMAIL PROTECTED]> wrote: So what should the jdbcType be set to in case of Object Types in the mapping file. Clinton Begin wrote: > > It does support in/out params, simply set the mode="IN|OUT|INOUT" > > It al

Please help me.

2007-05-31 Thread Davy Pulinckx
Hellow I have a question on how I would change my application in the best possible way. I will first explain the situation. There is a web-application build with JBuiler, I use weblogic to deploy te application and I uses .xml properties files each different for each environment (integration,

RE: "No operations allowed after connection closed" occasionally when using queryForList

2007-05-31 Thread Meindert
I had that problem with 'stale' connections, and added the ping To sqlMapConfig -Original Message- From: James, Steven [mailto:[EMAIL PROTECTED] Sent: 31 May 2007 05:03 PM To: user-java@ibatis.apache.org Subject: RE: "No operations allowed after connection clos

RE: Nested transactions?

2007-05-31 Thread Chris Lamey
You could look at how Spring implements their declarative transaction handling. On Thu, 2007-05-31 at 08:14 -0500, Sudhir, Sudhir (Contractor) wrote: > Thanks Clinton, > > I am curious about the second approach, I don’t think I quite got what > you are saying there…is there an example that you ca

RE: "No operations allowed after connection closed" occasionally when using queryForList

2007-05-31 Thread James, Steven
I have had this error with mysql, check to see that you are not creating more than one Sqlclient. Secondly you have lazy loading on so ensure you are not calling a get on mapped object outside of the transaction. -Original Message- From: CppPlease [mailto:[EMAIL PROTECTED] Sent: Donnerst

"No operations allowed after connection closed" occasionally when using queryForList

2007-05-31 Thread CppPlease
Hi there, I'm using the code mentioned below (with try catches and such) and it seems to work fine 90% of the time. However, occassionlly I get a "No operations allowed after connection closed" error. A few more details are below. --- Check the SQL Statement (preparation failed). --- Cause:

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

2007-05-31 Thread mini
So what should the jdbcType be set to in case of Object Types in the mapping file. Clinton Begin wrote: > > 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 examp

RE: Nested transactions?

2007-05-31 Thread Sudhir, Sudhir (Contractor)
Thanks Clinton, I am curious about the second approach, I don't think I quite got what you are saying there...is there an example that you can illustrate or point to? Thanks, Sudhir From: Clinton Begin [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 30, 2007 8:31 PM To: user-java@ibatis.a

RE: Sybase stored proc

2007-05-31 Thread O'Toole, Joe
Hi Sorry for forwarding on same mail again, but its just under a lot of pressure to get solution out. Would really appreciate if someone could take another look at mail below. As i said earlier, i know people spoke of a solution but would really appreciate a litrle more help understanding how to

Re: No Statement...

2007-05-31 Thread Graeme J Sweeney
On Thu, 31 May 2007, Giovanni D'Addabbo wrote: Ok it work very well but i've read in the book that i can use dot notation, for example Account.gettAllUsers ok now is the problem...how can i use this dot notation? :D IIUC, you need to enable namespaces: ... ... ... sele

RE: No Statement...

2007-05-31 Thread Meindert
Let me start by saying that I don't have the book, and I don't understand your question.. Anyway I like the 'feature' of IBATIS that I can map a join query to objects and child objects using 'dot notation' Example; I've got a domain class called Declaration, in it is a other domain class w

Tim Hammar is out of the office.

2007-05-31 Thread Tim . Hammar
I will be out of the office starting 05/31/2007 and will not return until 06/08/2007. I will respond to your message when I return.

No Statement...

2007-05-31 Thread Giovanni D'Addabbo
Hi all i'm new to Ibatis and i'm reading "Ibatis in action" Book but i've a No statetement problem... so i've these files: sqlMapConfig.xml --- http://ibatis.apache.org/dtd/sql-map-config-2.dtd "> -