Re: Transaction Rollback not working with iBatis + Spring

2010-07-22 Thread Bruno Issenmann
Both tables are linked by constraints on primary keys, so i can't make only one insert. I must have missed something with the ibatis config or the doa manager. Thanks for your time. Bruno - To unsubscribe, e-mail:

Re: Transaction Rollback not working with iBatis + Spring

2010-07-22 Thread Bruno Issenmann
Larry Meadors larry.meadors at gmail.com writes: Wait - I'm REALLY confused. Can you post a stack trace? Doh, I just noticed - this conversation should be on the new list. Maybe it's time to start this as a new thread and give us the stack trace and the relevant code anew. :) The

Re: Transaction Rollback not working with iBatis + Spring

2010-07-21 Thread Bruno Issenmann
Hi, I'm facing the same problem. Did you solved it ? Thanks - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org

Re: Transaction Rollback not working with iBatis + Spring

2010-07-21 Thread Larry Meadors
You don't need the batch, and I'm pretty sure it won't ever work with the batch because the inserts don't happen when you call them (they happen when you call executeBatch()) so your ids don't get set when you expect them to. Remove the lines related to the batch, and I think it'll work. Larry

Re: Transaction Rollback not working with iBatis + Spring

2010-07-21 Thread Bruno Issenmann
Thanks for ansering. I do not use the batch. I'm just doing two inserts then i commit. I still have an integrity contraint violation. - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands,

RE: Transaction Rollback not working with iBatis + Spring

2010-07-21 Thread Vinaya Tirikkovalluru
@ibatis.apache.org Subject: Re: Transaction Rollback not working with iBatis + Spring Thanks for ansering. I do not use the batch. I'm just doing two inserts then i commit. I still have an integrity contraint violation

RE: Ibatis 3 and null values

2010-07-05 Thread Poitras Christian
Ibatis project moved to Google. If I am not mistaking, the developers of iBATIS are not registered to this list anymore. Please, post your questions to the new list at mybatis-u...@googlegroups.com Christian -Original Message- From: Laurent MANNS [mailto:laurent.ma...@gmail.com] Sent:

Re: Inheritanc

2010-06-24 Thread Nathan Maves
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user

Re: Passing Oracle Table Types (Is it possible?)

2010-06-19 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user

Re: Lazy Loading per ResultMap

2010-06-17 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user

Re: SQLMap Question - Select Statement

2010-06-15 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user

Re: SQLExecutor.addBatch() modified

2010-06-14 Thread Nathan Maves
inserts ibatis caches the prepared statements in list and always re-uses the last statement for table inserts.  This model works for batch inserts for a single table.  However, we have a requirement where we need to do batch inserts into several tables in a single transaction. Since ibatis

Re: SQLExecutor.addBatch() modified

2010-06-14 Thread Nathan Maves
Nathan On Sun, Jun 13, 2010 at 11:10 PM,  nitin.du...@sungard.com wrote: By default for batch inserts ibatis caches the prepared statements in list and always re-uses the last statement for table inserts.  This model works for batch inserts for a single table.  However, we have a requirement where

Re: Getting RunTime Exception

2010-06-14 Thread Nathan Maves
Looks like a simple issue with your data source configuration. Please post your configuration to the new project listed below. The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here:

Re: Select from View (as opposed to table) using iBatis

2010-06-10 Thread Larry Meadors
Are you connecting as the same use that your code is connecting as? The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining

Re: Select from View (as opposed to table) using iBatis

2010-06-09 Thread Jeff Butler
Please join us at the new project site: www.mybatis.org Select from view is support. The error message is Undefined Name. DB2 cannot find the view called MY_SCHEMA.V_MY_VIEW. Jeff Butler On Wed, Jun 9, 2010 at 4:11 PM, mule_user s...@aol.com wrote: I am using iBatis (2.5) with DB2 version

Re: iBATIS 3 dynamic sql 'foreach' list got problem.

2010-06-08 Thread bruce666
and how to foreach a enum list when using sqlmap? bruce666 wrote: I am used ibatis 3.0 GA; those are my JavaBean classes, public class SearchObject { private Long id; private ListLong childIdList = new ArrayListLong(); public Long getId() { return id; } public void

Re: iBATIS 3 dynamic sql 'foreach' list got problem.

2010-06-08 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user

Re: iBatis 3: dynamic sql and numeric property type problem

2010-06-07 Thread Andreas Niemeyer
Hi, I've another use case for a possible if check: - if the parameterType long it fails for the if check: select id=getMegaList resultType=Mega parameterType=long Select id, descr, description from mega_t where if test=id != -1 id = #{id}

Re: iBatis 3: dynamic sql and numeric property type problem

2010-06-07 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user

Re: Cause: java.sql.SQLException: Closed Connection

2010-06-07 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user

Re: committing stored procedure

2010-06-04 Thread Clinton Begin
Because you're calling a query, iBATIS doesn't realize you're actually updating, so it won't commit by default. Set your transactionManager config in your configuration XML file to commitRequired=true. Check the user guide for more. And make sure to switch to the MyBatis lists for future

Re: committing stored procedure

2010-06-04 Thread Mr.Squirrel
ok thank you Clinton ! I have solved the probleme by adding a fake update before the call of my procedure. then, iBATIS understand that it's an update transaction. I will also try your solution as soon as possible -- View this message in context:

Re: JPetstore5.0+mysql error:XXXX in field list is ambiguous

2010-06-03 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user

Re: Possible to get ibatis to throw an exception if not all params are filled in?

2010-06-03 Thread Chema
Why dont you perform the parameter checking in you Java method ? I guess that the definition of the query is not the right place to manage when throwing Java exceptions 2010/6/3 laredotornado laredotorn...@gmail.com: Hi, We're using iBatis 2.3 with Tomcat 6.0.26 (Java 1.6).  We have many

Re: Possible to get ibatis to throw an exception if not all params are filled in?

2010-06-03 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user

Re: Mapping an Array of String

2010-06-01 Thread Larry Meadors
FYI: The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here:

Re: iBatis 3: dynamic sql and numeric property type problem

2010-05-31 Thread Larry Meadors
I think you can just say if test=id != -1, but I haven't done this exact thing yet. Since we're using ognl for expressions, here's where I'd look: http://www.opensymphony.com/ognl/html/LanguageGuide/index.html Also, you should join and post to the new list at google:

Re: iBatis 3: dynamic sql and numeric property type problem

2010-05-31 Thread Andreas Niemeyer
Sorry, I had a missunderstanding, it works this way: ... if test=id != -1 and x.id = #{id} /if ... Andreas Niemeyer schrieb: Hi, how can I deal with numeric class properties for dynamic sql in iBatis 3.x? In the older 2.x release there exist a `isGreaterThan' tag and

Re: [ANNOUNCEMENT] iBATIS Project Team Moving to Google Code

2010-05-30 Thread Zoran Avtarovski
I don¹t mean to be a pain, but is there a way of subscribing to the new list without having to join google? I really don¹t want to have another account to manage, especially with them. I¹m happy to do it through nabble as I already use them. Z. ANNOUNCEMENT Eight years ago in 2002, I

Re: [ANNOUNCEMENT] iBATIS Project Team Moving to Google Code

2010-05-30 Thread Clinton Begin
Unfortunately no. You would have had to join something -- or others would have. Many people have google accounts, so in addition to all of the othe benefits of Google Code, we leveraged that too. Clinton On 2010-05-30, Zoran Avtarovski zo...@sparecreative.com wrote: I don¹t mean to be a pain,

Re: Mapping a Complex Object

2010-05-27 Thread Niko Ustinov
Well, not so unique design practice now, i think. I'm trying now to implement solution based on scala iBatis and want to use scala's case classes for domain model. But common way to initialize such objects is parametrizing through constructor. so, i have (for example) such definitions: trait

Re: FileNotFoundException: http://www.mybatis.org/dtd/sql-map-config-2.dtd

2010-05-27 Thread Clinton Begin
The ibatis.com doctypes were deprecated about 4 years ago... they should be changed to ibatis.apache.org... The reason they would suddenly stop working is that the ibatis.com/net/orgredirects have just changed recently. But again, those doctypes were deprecated ages ago. See the news release

RE: Need support for Dynamic procedure invocation

2010-05-26 Thread Nicky Jha
be this needs discussion with you :-) Nicky -Original Message- From: Jeff Butler [mailto:jeffgbut...@gmail.com] Sent: Tuesday, May 25, 2010 8:39 PM To: user-java@ibatis.apache.org Subject: Re: Need support for Dynamic procedure invocation Joe - this is exactly what I was going to write next - good

Re: [ANNOUNCEMENT] iBATIS Project Team Moving to Google Code

2010-05-26 Thread Simone Tripodi
Hi Clinton, I'm sure you all had more than one good reason to leave the ASF home and starting a new adventure. I hope this will be the time to encourage people to submit MyBatis subprojects (3rd parts integrations, caches integrations etc etc) and join the team. Good luck!!! Simo

RE: Need support for Dynamic procedure invocation

2010-05-25 Thread Nicky Jha
To: 'user-java@ibatis.apache.org' Subject: RE: Need support for Dynamic procedure invocation Joe/Jeff Please help. this class is not part of framework, this is approach, we have used in case our procedure changes at runtime, so will its parameter.For that we using public class

Re: Need support for Dynamic procedure invocation

2010-05-25 Thread Jeff Butler
$ iterate property=params open=( close=) conjunction=,#params[]#/iterate } to include jdbc types also, so that I can pass null value to database? Thanks Nicky -Original Message- From: Nicky Jha Sent: Tuesday, May 25, 2010 11:12 AM To: 'user-java@ibatis.apache.org' Subject: RE

RE: Need support for Dynamic procedure invocation

2010-05-25 Thread Nicky Jha
To: user-java@ibatis.apache.org Subject: Re: Need support for Dynamic procedure invocation This would be a great time to switch to mybatis and usa a @SelectProvider to write the query exactly as you need it. I think that the dynamic SQL tags won't work in this case. Jeff Butler On 5/25/10, Nicky Jha

RE: Need support for Dynamic procedure invocation

2010-05-25 Thread Joe Gooch
To: user-java@ibatis.apache.org Subject: RE: Need support for Dynamic procedure invocation Hi Is there a way I can modify {call $procedureName$ iterate property=params open=( close=) conjunction=,#params[]#/iterate } to include jdbc types also, so that I can pass null value to database

Re: Need support for Dynamic procedure invocation

2010-05-25 Thread Jeff Butler
Subject: RE: Need support for Dynamic procedure invocation Hi Is there a way I can modify {call $procedureName$ iterate property=params open=( close=)  conjunction=,#params[]#/iterate } to include jdbc types also, so that I can pass null value to database? Thanks Nicky -Original

Re: iBATIS with Java, SQL Server 2008

2010-05-24 Thread Larry Meadors
It's super easy - I use the freetds jdbc driver and it just works. However, use mybatis instead: http://www.mybatis.org/ The entire ibatis development team has moved there instead of remaining with the ASF due to technological issues and philosophical differences. :) Larry

Re: Still see SQL in log for cached statements

2010-05-24 Thread Clinton Begin
With a read/write cache that is NOT serializable, it sort of eliminates any benefit of caching. This was a little confusing in iBATIS 2... but the only settings that really make sense together are: readOnly=true serializable=false readOnly=false serializable=true The first one is the default,

Re: Need support for Dynamic procedure invocation

2010-05-24 Thread Nicky Jha
params = new ArrayListObject(); params.add()), Types become java.lang.String, but then I think it no more considers it as null. Please help Thanks Nicky -Original Message- From: Nicky Jha Sent: Friday, May 14, 2010 8:46 PM To: 'user-java@ibatis.apache.org' Subject: RE: Need support

Re: Need support for Dynamic procedure invocation

2010-05-24 Thread Clinton Begin
. Please help Thanks Nicky -Original Message- From: Nicky Jha Sent: Friday, May 14, 2010 8:46 PM To: 'user-java@ibatis.apache.org' Subject: RE: Need support for Dynamic procedure invocation Joe/Jeff This worked with your suggestion.Thank you so much!!! Nicky -Original

Re: Need support for Dynamic procedure invocation

2010-05-24 Thread Clinton Begin
] Sent: Tuesday, May 25, 2010 10:39 AM To: user-java@ibatis.apache.org Subject: Re: Need support for Dynamic procedure invocation Are you setting the jdbcType in your parameter map for all nullable columns? Clinton On Mon, May 24, 2010 at 11:03 PM, Nicky Jha nicky

RE: Need support for Dynamic procedure invocation

2010-05-24 Thread Nicky Jha
[mailto:clinton.be...@gmail.com] Sent: Tuesday, May 25, 2010 11:07 AM To: user-java@ibatis.apache.org Subject: Re: Need support for Dynamic procedure invocation I'm not familiar with that class, as it's not part of the framework (maybe post it here). Short story is that JDBC requires nullable column types

Re: list all databases in mysql server

2010-05-23 Thread Zhong Nanhai
Many thanks!!! It works. On 5/21/10, Martin Ellis mar...@ellis.name wrote: On 21 May 2010 08:17, Zhong Nanhai higerinbeij...@gmail.com wrote: Is it possible to show all databases in a mysql server with iBatis? select id=showdatabases resultType=map SHOW DATABASES /select

Re: Question about 'jdbcType='

2010-05-21 Thread Clinton Begin
That is the case for most situations, but make sure to grab the latest release. It's still a best practice and a JDBC requirement. All iBATIS will do is fill it in with Types.OBJECT or Types.Other to try to force the null. Clinton 2010/5/20 François Schiettecatte fschietteca...@gmail.com Hi

Re: list all databases in mysql server

2010-05-21 Thread Josh Kamau
IMHO opinion, its not possible because each connection is to one Database. So your ibatis, JDBC or whatever code only knows the objects under the database for which connection was made. Regards. On Fri, May 21, 2010 at 10:17 AM, Zhong Nanhai higerinbeij...@gmail.comwrote: Hi, Is it possible

Re: list all databases in mysql server

2010-05-21 Thread Zhong Nanhai
Hi, Then, is there any other way? On 5/21/10, Josh Kamau joshnet2...@gmail.com wrote: IMHO opinion, its not possible because each connection is to one Database. So your ibatis, JDBC or whatever code only knows the objects under the database for which connection was made. Regards. On Fri,

Re: list all databases in mysql server

2010-05-21 Thread Martin Ellis
On 21 May 2010 08:17, Zhong Nanhai higerinbeij...@gmail.com wrote: Is it possible to show all databases in a mysql server with iBatis? select id=showdatabases resultType=map SHOW DATABASES /select System.out.println(session.selectList(your-namespace.showdatabases)); Martin

Re: [ANNOUNCEMENT] iBATIS Project Team Moving to Google Code

2010-05-21 Thread cowwoc
Two questions: 1) Why the name change? Couldn't you keep the iBatis name even under Google Code? 2) Will you apply for an open-source license from JIRA or will you use Google Code's bug tracker? (I prefer the former from a usability point of view) Gili On 21/05/2010 3:54 AM, Clinton

Re: [ANNOUNCEMENT] iBATIS Project Team Moving to Google Code

2010-05-21 Thread Clinton Begin
Thanks for the questions Gili. 1) Why the name change? Couldn't you keep the iBatis name even under Google Code? When I donated iBATIS to the ASF, it was unfortunately irreversible. This is due to the fact that Apache is a 501(c)(3) nonprofit organization. They cannot turn over what might be

Re: iBATIS 3 @InsertProvider (and other @*Provider) annotation question

2010-05-21 Thread Jeff Butler
Not right - the parameter object on the interface method is passed to the *Provider method: // interface... @InsertProvider(type=MyProvider.class, method=myInsert) int insertFoo(Foo foo); // provider method... public String myInsert(Foo foo) { } Works like a charm. BTW - join us at the

Re: iBATIS 3 @InsertProvider (and other @*Provider) annotation question

2010-05-21 Thread Alex Sherwin
On 5/21/2010 10:23 AM, Alex Sherwin wrote: I just want to make sure, but there is there simply no way to pass arguments to the sql provider method defined in the annotations such as @InsertProvider? It would be very beneficial to be able to do so in terms of building dynamic sql, such as an

Re: iBATIS 3 @InsertProvider (and other @*Provider) annotation question

2010-05-21 Thread Alex Sherwin
Method is annotated with @InsertProvider, my implementation method takes a MapString, Object and can see the array passed in keyed with array (I also explicitly set its name with @Param to be sure it was consitent in my sql provider and where it creates the prepared statement values)

Re: iBATIS 3 @InsertProvider (and other @*Provider) annotation question

2010-05-21 Thread Alex Sherwin
Alright.. don't waste your time, it works fine as one would expect when given proper input. Sorry about that, I'm usually more thorough before resorting to mailing lists On 5/21/2010 11:33 AM, Alex Sherwin wrote: Method is annotated with @InsertProvider, my implementation method takes a

Re: ibator download

2010-05-21 Thread Roy Bailey
Thanks Jeff, I like the fact that Ibator will give me compile time errors for data-model changes, especially as Ibatis is great for legacy databases and I use it to help any re-design evolutions. I actually have my build process include full Ibator regeneration and search/replace

Re: [ANNOUNCEMENT] iBATIS Project Team Moving to Google Code

2010-05-21 Thread cowwoc
Hi Clinton, On 21/05/2010 10:04 AM, Clinton Begin wrote: Thanks for the questions Gili. 1) Why the name change? Couldn't you keep the iBatis name even under Google Code? When I donated iBATIS to the ASF, it was unfortunately irreversible. This is due to the fact that Apache is a

Re: [ANNOUNCEMENT] iBATIS Project Team Moving to Google Code

2010-05-21 Thread Clinton Begin
Anyone can fork the code. But you cannot call it iBATIS. As for the issues, we have no intention of migrating all of the issues from Jira to Google Code. We've moved the iBATIS 3 open tickets, only because there were only 20 and it was easy to do. The Jira system will be frozen by Sunday.

Re: resultType=list contains null values

2010-05-20 Thread Larry Meadors
You want resultType to be a bean or map or maybe even integer - list will give you a list of lists, which is *not* what you want. :) Larry On Thu, May 20, 2010 at 4:57 AM, JohannesK johannes.kuus...@eficode.fi wrote: Hello I am having the weirdest problem with Ibatis 3. Here is my mapper

Re: ibator download

2010-05-20 Thread Jeff Butler
I usually add these types of methods directly to the generated classes. In my experience, it's pretty rare to have to regenerate classes. If you use Ibator through the eclipse plugin, then the added methods will even survive a regeneration. Here's documentation for building a new version of the

RE: Question about 'jdbcType='

2010-05-20 Thread Bekkum Odd-Rune
Could it be this? orb - Hi. To get it to work I've added :OTHER on all INSERT and UPDATE statements. I can do check out and build and test it tomorrow. I've created Jira ticket IBATIS-762. Thanks, Odd-Rune. Thanks. A few

Re: API for runtime assembling of ibatis configuration elements

2010-05-19 Thread Clinton Begin
Version 3, yes. Version 2, no. Cheers, Clinton On Wed, May 19, 2010 at 5:14 AM, alebu ale...@gmail.com wrote: Hi, I have some ibatis API question: Is it possible to assemble configuration elements like resultMap's or queries in runtime using API only? Can these API generated elements

Re: Advanced Result Mapping documentation error or misunderstanding of concept

2010-05-19 Thread Clinton Begin
Yep, just a typo. I'll take care of it in the docs. Cheers, Clinton On Wed, May 19, 2010 at 5:12 AM, alebu ale...@gmail.com wrote: Hi, at this moment I am reading documentation Advanced Result Mapping section and one think I can't understand in the example with blogs (further reading didn't

Re: ibator download

2010-05-19 Thread Roy Bailey
Thanks Jeff, I've been able to follow the instructions and generate Ibatis 3 mappers from Ibator 1.2.2 build. Great job. I've also been looking around the Ibator code because I want to use extended classes for result-sets (e.g. classes that extend the Ibator generated classes and add

Re: Sql Map

2010-05-18 Thread kiran vuppla
: Clinton Begin clinton.be...@gmail.com To: user-java@ibatis.apache.org Sent: Mon, May 17, 2010 6:17:39 PM Subject: Re: Sql Map If it's in a property file, can you just do this at the build stage? It will be faster to do so too. Clinton On Mon, May 17, 2010 at 2:42 PM, kiran vuppla kirankumar_vup

Re: Sql Map

2010-05-18 Thread Clinton Begin
@ibatis.apache.org *Sent:* Mon, May 17, 2010 6:17:39 PM *Subject:* Re: Sql Map If it's in a property file, can you just do this at the build stage? It will be faster to do so too. Clinton On Mon, May 17, 2010 at 2:42 PM, kiran vuppla kirankumar_vup...@yahoo.com wrote: Hi, I would like

Re: contextGenerateAdditionalXmlFiles to create single file

2010-05-18 Thread Jeff Butler
Take a look at the source for SqlMapConfigPlugin - it does something very similar to what you are trying to accomplish. Jeff Butler On Mon, May 17, 2010 at 4:08 AM, Amar X Hussain amar.huss...@jpmorgan.com wrote: Hi guys, I have an Ibator plugin that creates a spring config file per table,

Re: Sql Map

2010-05-18 Thread kiran vuppla
) and do not want to pass as // parameter from code /select Thanks, Kiran From: Clinton Begin clinton.be...@gmail.com To: user-java@ibatis.apache.org Sent: Tue, May 18, 2010 9:53:25 AM Subject: Re: Sql Map You can read it in from the file and try to pass it in just

Re: ibatis3 : multiple parameters in statement without map or bean

2010-05-17 Thread Larry Meadors
Yes, you have to annotate the parameters (because java reflection is kinda weak). It's in the user guide. Larry On Mon, May 17, 2010 at 4:15 AM, Nicolas ANTONIAZZI nicolas.antonia...@gmail.com wrote: Hi, Is it possible to pass multiple parameters in iBatis3 without having to pass a map or a

Re: ibatis3 : multiple parameters in statement without map or bean

2010-05-17 Thread Nicolas ANTONIAZZI
Thank you Larry, I did not read correctly the User Guide. Indeed, it says : *If your mapper method takes multiple parameters, this annotation can be applied to a mapper method parameter to give each of them a name. Otherwise, multiple parameters will be named by their ordinal position (not

Re: Sql Map

2010-05-17 Thread Clinton Begin
If it's in a property file, can you just do this at the build stage? It will be faster to do so too. Clinton On Mon, May 17, 2010 at 2:42 PM, kiran vuppla kirankumar_vup...@yahoo.comwrote: Hi, I would like if we can do the following check in the Query inside select statement. I am

Re: Need support for Dynamic procedure invocation

2010-05-14 Thread Jeff Butler
This won't work (as you've discovered). iBATIS 2.x does not reparse the string for variables after string substitution. You'll need to do this with the dynamic tags, or you'll need to compose the entire string (including parameter values - like {call myproc('fred')}). Jeff Butler On Fri, May

RE: Need support for Dynamic procedure invocation

2010-05-14 Thread Nicky Jha
To: user-java@ibatis.apache.org Subject: Re: Need support for Dynamic procedure invocation This won't work (as you've discovered). iBATIS 2.x does not reparse the string for variables after string substitution. You'll need to do this with the dynamic tags, or you'll need to compose the entire

RE: Need support for Dynamic procedure invocation

2010-05-14 Thread Joe Gooch
be arranged, and please delete the message from your mail box. -Original Message- From: Nicky Jha [mailto:nicky@jpmchase.com] Sent: Friday, May 14, 2010 7:38 AM To: user-java@ibatis.apache.org Subject: RE: Need support for Dynamic procedure invocation Hi Jeff, Thanks

Re: Need support for Dynamic procedure invocation

2010-05-14 Thread Jeff Butler
-java@ibatis.apache.org Subject: RE: Need support for Dynamic procedure invocation Hi Jeff, Thanks for this, if I was to do as suggested and compose the entire string with parameter values, how will the parameter types (e.g. date, smallint etc) be handled? Nicky! -Original Message

RE: Need support for Dynamic procedure invocation

2010-05-14 Thread Nicky Jha
Joe/Jeff This worked with your suggestion.Thank you so much!!! Nicky -Original Message- From: Jeff Butler [mailto:jeffgbut...@gmail.com] Sent: Friday, May 14, 2010 6:31 PM To: user-java@ibatis.apache.org Subject: Re: Need support for Dynamic procedure invocation Yes - this the best

Re: interesting exception in 3.0

2010-05-14 Thread François Schiettecatte
Clinton Ok this is interesting, I was able to reliably replicate the problem, I even grabbed the source code and included in the source code tree of my application and still got the issue, but... the server I am running this one was rebooted due to a power failure and now the problem has gone

Re: interesting exception in 3.0

2010-05-14 Thread Clinton Begin
Thanks so much Francois, I appreciate the effort you applied to validating this. Cheers, Clinton 2010/5/14 François Schiettecatte fschietteca...@gmail.com Clinton Ok this is interesting, I was able to reliably replicate the problem, I even grabbed the source code and included in the source

Re: xml persistence

2010-05-13 Thread Larry Meadors
No. On Thu, May 13, 2010 at 4:30 AM, Zhong Nanhai higerinbeij...@gmail.com wrote: Hi, Does iBatis support XML persistence, i.e. take an XML file as a database? Best Regards, Zhong Nanhai - To unsubscribe, e-mail:

RE: xml persistence

2010-05-13 Thread OBender
13, 2010 7:32 AM To: user-java@ibatis.apache.org Subject: Re: xml persistence No. On Thu, May 13, 2010 at 4:30 AM, Zhong Nanhai higerinbeij...@gmail.com wrote: Hi, Does iBatis support XML persistence, i.e. take an XML file as a database? Best Regards, Zhong Nanhai

Re: RE: xml persistence

2010-05-13 Thread Zhong Nanhai
://www.csv-jdbc.com/stels_xml_jdbc.htm This way you could use iBatis (as almost any ORM and ORM like tools). -Original Message- From: Larry Meadors [mailto:larry.mead...@gmail.com] Sent: Thursday, May 13, 2010 7:32 AM To: user-java@ibatis.apache.org Subject: Re: xml persistence

Re: Way to use sql in mapper interface, without having to create a corresponding xml mapping file?

2010-05-13 Thread Jeff Butler
It took me a while to figure it out also! Create your SqlSessionFactory as normal, then add the interfaces manually: sqlSessionFactory.getConfiguration().addMapper(SomeMapperInterface.class); Jeff Butler On Wed, May 12, 2010 at 4:16 PM, Rick R ric...@gmail.com wrote: Larry showed me his

Re: Way to use sql in mapper interface, without having to create a corresponding xml mapping file?

2010-05-13 Thread Larry Meadors
He wants to represent that in the xml config. Larry On Thu, May 13, 2010 at 2:35 PM, Jeff Butler jeffgbut...@gmail.com wrote: It took me a while to figure it out also! Create your SqlSessionFactory as normal, then add the interfaces manually:    

Re: Way to use sql in mapper interface, without having to create a corresponding xml mapping file?

2010-05-13 Thread Rick R
On Thu, May 13, 2010 at 4:50 PM, Larry Meadors larry.mead...@gmail.comwrote: He wants to represent that in the xml config. Right. It seems odd that you can manually add the Mapper through Java (as Jeff has shown), but not through the xml config.

Re: Way to use sql in mapper interface, without having to create a corresponding xml mapping file?

2010-05-13 Thread Clinton Begin
That would be a really simple change. What I've been really getting used to though is configuring the datasource in XML, and then using Java for most everything else. For example, I have this in a class called IbatisConfig: final String resource = com/myapp/data/IbatisConfig.xml;

Re: Way to use sql in mapper interface, without having to create a corresponding xml mapping file?

2010-05-13 Thread Rick R
Ok, cool maybe ill just change to this. (By the way, I'm searching the archives for this, and it's sort of off-topic but since you mentioned you create your datasource in XML - I'm curious how do you declare the pool implementation that you want to use? I know ibatis comes with a default one (not

Re: Way to use sql in mapper interface, without having to create a corresponding xml mapping file?

2010-05-13 Thread Rick R
On Thu, May 13, 2010 at 9:21 PM, Rick R ric...@gmail.com wrote: (By the way, I'm searching the archives for this, and it's sort of off-topic but since you mentioned you create your datasource in XML - I'm curious how do you declare the pool implementation that you want to use? I know ibatis

Re: How to correct the time out problem?

2010-05-12 Thread Martin Ellis
On 12 May 2010 02:31, 陈抒 csfreeb...@gmail.com wrote: Caused by: java.lang.NullPointerException     at freebird.business.Email.getReceiverList(Email.java:105) What caused this NullPointerException? Is it really related to the connection option? Martin

Re: How to correct the time out problem?

2010-05-12 Thread 陈抒
I don't know. But I took one hour to test my application again,it works fine if the 'time out' problem doesn't occurs. Now I add two properties,let's wait and see if it can solve this or not. property name=poolPingQuery value=select * from jobstatus/ property name=poolPingEnabled value=true/ 陈抒

Re: How to correct the time out problem?

2010-05-12 Thread François Schiettecatte
. From my limited experience 'autoReconnect=true' is not recommended, here is an excerpt from the MySQL documentation: Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for a queries issued on a stale or dead connection, which

Re: How to correct the time out problem?

2010-05-12 Thread 陈抒
experience 'autoReconnect=true' is not recommended, here is an excerpt from the MySQL documentation: Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for a queries issued on a stale or dead connection, which belong to the current

Re: How to correct the time out problem?

2010-05-12 Thread François Schiettecatte
the MySQL documentation: Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for a queries issued on a stale or dead connection, which belong to the current transaction, but will attempt reconnect before the next query issued

Re: New to Ibatis / Ibator / Eclipse

2010-05-12 Thread Jeff Butler
Dude - please stop sending the same email over and over again! Read the iBATIS documentation, do a google search for ibatis tutorial, etc. Jeff Butler On Wed, May 12, 2010 at 10:36 AM, SMe Software - Rocky Castaneda rcastan...@smartermanager.com wrote: Hi Clinton, I have a table named

Re: special characters in xml

2010-05-11 Thread Andrea Selva
Hi, in this case i would try to use the xml substitution for the % character, so becomes like '#37;value #37;' I hope this could help Andrea On Mon, May 10, 2010 at 8:26 PM, Juan Chung jiayanch...@gmail.com wrote: when you prepare the parameters before calling ibatis, you could change the

Re: Help with iBatis nested iterate syntax

2010-05-11 Thread devver
Apologies once again for the late acknowledgement of your post. Things have moved on apace. I believe the version the applciation is precedes the 2.2.0 release which probably explains why my nested iterates are failing. I added the ibtatis-2.0.3.677.jar onto the classpath for no other reason

Re: A problem with iBatis3

2010-05-11 Thread Clinton Begin
What kind of constructor does lombok result in? It looks to me like the constructor is either generated as private or with parameters. Clinton 2010/5/11 José María Ruiz josema...@simpleoption.com: Hi. First, thanks for you effort with iBatis. I think it's a wonderful orm for all of us who

Re: A problem with iBatis3

2010-05-11 Thread José María Ruiz
I've my own constructor (it doesn't appear in the code I pasted sorry): public Marca() { InjectorHolder.getInjector().inject(this); } InjectorHolder is part of Wicket, it worked well with iBatis2 :-m Cheers. Clinton Begin wrote: What kind of constructor does lombok result in?

Re: A problem with iBatis3

2010-05-11 Thread José María Ruiz
Yes, it's the constructor. If I comment it all goes fine. But I need this constructor to inject dependencies... what can I do? José María Ruiz wrote: I've my own constructor (it doesn't appear in the code I pasted sorry): public Marca() {

  1   2   3   4   5   6   7   8   9   10   >