Re: Transaction Rollback not working with iBatis + Spring

2010-07-22 Thread Bruno Issenmann
Larry Meadors 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 ibatis projec

Re: Transaction Rollback not working with iBatis + Spring

2010-07-22 Thread Larry Meadors
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 ibatis project has moved and been renamed. It is no longer being

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: user-java-u

RE: Transaction Rollback not working with iBatis + Spring

2010-07-21 Thread Vinaya Tirikkovalluru
Does just the insert work on the table which is giving the issue without the insert into the history? -Original Message- From: Bruno Issenmann [mailto:b.issenm...@labsoft.fr] Sent: Wednesday, July 21, 2010 2:03 PM To: user-java@ibatis.apache.org Subject: Re: Transaction Rollback not

Re: Transaction Rollback not working with iBatis + Spring

2010-07-21 Thread Bruno Issenmann
Vinaya Tirikkovalluru converge.com> writes: > > Sorry!! I missed the thread. > Does it give you a runtime exception? Only if the code throws a runtime > exception the transaction will be rolled back > > Vinaya I have a runtime exception, transaction is rolled back. When i run the SQL manually

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: 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, e-

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
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: Dynamic table names in DELETE

2010-07-19 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: droidin.net [mailto:dr...@droidin.net] Sent: Sunday,

RE: Ibator 1.2.2

2010-07-12 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: Panciz [mailto:dav.pole...@gmail.com] Sent: Saturday,

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: M

Re: ibatis 3 and calling stored procedure

2010-06-28 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 L

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 O

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 L

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: 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: http://www.m

Re: SQLExecutor.addBatch() modified

2010-06-14 Thread Nathan Maves
Nathan > > On Sun, Jun 13, 2010 at 11:10 PM,   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 requir

Re: SQLExecutor.addBatch() modified

2010-06-14 Thread Nathan Maves
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 is des

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 t

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

2010-06-09 Thread mule_user
The View exists in DB2, but no table exists with that name. Yes, 42704 is throws if table is not found. I can run the SQL generated SQL by iBatis (that is spit out in Console) in DB2 control center and get successful results. Yes, while table does not exist, the view exist. The error code of 42

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 wrote: > > I am using iBatis (2.5) with DB2 version 8.x and Sp

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 L

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 List childIdList = new ArrayList(); > public Long getId() { > return id; > } > public voi

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 L

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 L

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, descr, description from mega_t id = #{id} Thank you in advance, Andreas Andreas Niemeyer schrieb:

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: http://old.nabble.com/committing-stored-procedu

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 que

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 L

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 : > > Hi, > > We're using iBatis 2.3 with Tomcat 6.0.26 (Java 1.6).  We have many queries > where we pas

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 L

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: http://groups.google.com/group/mybatis-us

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: ... and x.id = #{id} ... 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 `' tag and the user guide for 3.x only mention

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

2010-05-31 Thread Larry Meadors
I think you can just say , 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: http://groups.google.com/group/mybatis-user 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 wrote: > I don¹t mean to be a pain, but is there a way of

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: 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 fr

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 B

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 http://people.apa

RE: Need support for Dynamic procedure invocation

2010-05-26 Thread Nicky Jha
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: Need support for Dynamic procedure invocation

2010-05-25 Thread Jeff Butler
legally privileged > information that is intended only for the individual named in the e-mail > address. If you are not the intended recipient, you are hereby notified that > any disclosure, copying, distribution, or reliance upon the contents of this > e-mail message is strictly prohib

RE: Need support for Dynamic procedure invocation

2010-05-25 Thread Joe Gooch
end(","); sb.append("?"); } sb.append(")}"); PreparedStatement st = con.prepareStatement(sb.toString()); // You could now cache this prepared statement until/unless your dpp values change for(int i=0; i -Original Message- > From: Nicky Jha [mailto:nick

RE: Need support for Dynamic procedure invocation

2010-05-25 Thread Nicky Jha
: 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, Nick

Re: Need support for Dynamic procedure invocation

2010-05-25 Thread Jeff Butler
open="(" close=")" > conjunction=",">#params[]# } 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:1

RE: Need support for Dynamic procedure invocation

2010-05-25 Thread Nicky Jha
Hi Is there a way I can modify {call $procedureName$ #params[]# } 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: Ne

RE: Need support for Dynamic procedure invocation

2010-05-24 Thread Nicky Jha
Clinton Begin [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 JD

Re: Need support for Dynamic procedure invocation

2010-05-24 Thread Clinton Begin
n Begin [mailto:clinton.be...@gmail.com] > 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 > O

Re: Need support for Dynamic procedure invocation

2010-05-24 Thread Clinton Begin
ng, > 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 for Dyna

Re: Need support for Dynamic procedure invocation

2010-05-24 Thread Nicky Jha
ams = new ArrayList(); 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

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 def

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: list all databases in mysql server

2010-05-23 Thread Zhong Nanhai
Many thanks!!! It works. On 5/21/10, Martin Ellis wrote: > On 21 May 2010 08:17, Zhong Nanhai wrote: >> Is it possible to show all databases in a mysql server with iBatis? > > > SHOW DATABASES > > > System.out.println(session.selectList("your-namespace.showdatabases")); > > Martin > > --

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. Most

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 501(c)(

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: 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 Map a

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 Map 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) Generated sql in java

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

2010-05-21 Thread Jeff Butler
Yes - that works. iBATIS is using OGNL to interpret the parameters, so any valid OGNL expression works. Jeff Butler On Fri, May 21, 2010 at 10:04 AM, Alex Sherwin wrote: > 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 >> arg

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 i

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: [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: [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 Be

Re: list all databases in mysql server

2010-05-21 Thread Martin Ellis
On 21 May 2010 08:17, Zhong Nanhai wrote: > Is it possible to show all databases in a mysql server with iBatis? SHOW DATABASES System.out.println(session.selectList("your-namespace.showdatabases")); Martin - To unsubscribe

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 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, May 21, 2010 a

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 wrote: > Hi, > > Is it possible to show all databases

Re: Question about 'jdbcType='

2010-05-20 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 > Hi > > I remember seeing so

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 othe

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: 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 wrote: > > Hello > > I am having the weirdest problem with Ibatis 3. Here is my mapper XML: > >         >        

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 derive

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 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 clarified i

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 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 > reference to those

Re: Sql Map

2010-05-18 Thread kiran vuppla
nks, Kiran From: Clinton Begin 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 like any other parameter. It's hard to fully understand what you're trying

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 wrote: > Hi guys, > > > > I have an Ibator plugin that creates a spring config file per table, it > works fine but

Re: Sql Map

2010-05-18 Thread Clinton Begin
atis.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 > wrote: >

Re: Sql Map

2010-05-18 Thread kiran vuppla
: Clinton Begin 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 wrote: > >Hi, > > &

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 wrote: > Hi, > > I would like if we can do the following check in the Query inside > statement. I am reading the property from property f

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 includ

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 wrote: > Hi, > Is it possible to pass multiple parameters in iBatis3 without having to pass > a map or a bean ? > example : >

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 > 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 > app

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 a

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: Need support for Dynamic procedure invocation

2010-05-14 Thread Jeff Butler
. If you have received this e-mail > transmission in error, please reply to the sender, so that proper delivery > can be arranged, and please delete the message from your mail box. > >> -Original Message- >> From: Nicky Jha [mailto:nicky@jpmchase.com] >>

RE: Need support for Dynamic procedure invocation

2010-05-14 Thread Joe Gooch
t: Friday, May 14, 2010 7:38 AM > To: user-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

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 t

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 1

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 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 comes with a

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 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"; f

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 wrote: > 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 Larry Meadors
He wants to represent that in the xml config. Larry On Thu, May 13, 2010 at 2:35 PM, Jeff Butler wrote: > It took me a while to figure it out also! > > Create your SqlSessionFactory as normal, then add the interfaces manually: > >     sqlSessionFactory.getConfiguration().addMapper(SomeMapperInt

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 wrote: > Larry showed me his cool no xml con

Re: RE: xml persistence

2010-05-13 Thread Zhong Nanhai
bc.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 &

RE: xml persistence

2010-05-13 Thread OBender
Thursday, May 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 > wrote: > > Hi, > > > > Does iBatis support XML persistence, i.e. take an XML file as a > d

Re: xml persistence

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

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 wrote: > > Hi Clinton, > I have a table named TIMMAIN and I have successfull

Re: How to correct the time out problem?

2010-05-12 Thread François Schiettecatte
rience '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 > dea

Re: How to correct the time out problem?

2010-05-12 Thread 陈抒
> 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 stal

  1   2   3   4   5   6   7   8   9   10   >