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: [ANNOUNCEMENT] iBATIS Project Team Moving to Google Code

2010-05-30 Thread Clinton Begin
ses.  But we believe we can make it >> even better. >> >> Therefore, the entire core development team of iBATIS has decided to >> continue >> the development of the framework at a new home and with a new name. >> >> This includes all of the iBATIS for

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

2010-05-24 Thread Clinton Begin
heers, Clinton On 2010-05-24, Nicky Jha wrote: > Hi > > I am using parameter class DynamicProcedureParams(as sugessted by Joe Gooch > ), as my requirement was to build paramaters at run time, so with this > approach where can I set jdbcType? > > Nicky > > From: Clinto

Re: Need support for Dynamic procedure invocation

2010-05-24 Thread Clinton Begin
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 wrote: > > Hi > > with approach mentioned below(DynamicProcedureParams) , I want to also pass > some of parameter as null((private List params = new > ArrayList(); pa

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: [ANNOUNCEMENT] iBATIS Project Team Moving to Google Code

2010-05-21 Thread Clinton Begin
t might be time to look into an iBATIS 2 > 3 converter... it's probably faster and easier to create that than to try to support 2 versions of the framework in the long term. Cheers, Clinton On Fri, May 21, 2010 at 6:11 PM, cowwoc wrote: > Hi Clinton, > > > On 21/05/2010

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

2010-05-21 Thread Clinton Begin
ker? (I prefer the former from a usability point of > view) > > Gili > > > On 21/05/2010 3:54 AM, Clinton Begin wrote: > > *ANNOUNCEMENT* > > Eight years ago in 2002, I created the iBATIS Data Mapper and introduced > SQL Mapping as an approach to persistence layer deve

[ANNOUNCEMENT] iBATIS Project Team Moving to Google Code

2010-05-21 Thread Clinton Begin
e the development of the framework at a new home and with a new name. This includes all of the iBATIS for Java committers: * Clinton Begin * Brandon Goodin * Jeff Butler * Larry Meadors * Nathan Maves * Kai Grabfelder And all of the iBATIS.NET committers: * Michael McCurrey * Ron Grab

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: 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 Clinton Begin
and we > will provide the war file to the customer and the client must be able to add > it and we need to pick it during runtime or server startup. Is there any > other way? > > Thanks, > Kiran > > ------ > *From:* Clinton Begin > *To:* user-java@ib

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: interesting exception in 3.0

2010-05-14 Thread Clinton Begin
e 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 away... I > blame cosmic rays at this point... > > So this is not an issue. > > Cheers > > François > > >

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: A problem with iBatis3

2010-05-11 Thread Clinton Begin
lder.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? It looks to

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 : > > Hi. > > First, thanks for you effort with iBatis. I think it's a wonderful "orm" for > all of us who don't hate sql ;). >

Re: interesting exception in 3.0

2010-05-08 Thread Clinton Begin
gt; I have not had a chance to look at it, and it is still an issue, before > rushing out and creating a jira ticket for it I wanted to look at the code > diffs between the two releases, I will try to get to it later today or this > WE. > > François > > On May 7, 2010, at 10:33 AM

Re: interesting exception in 3.0

2010-05-07 Thread Clinton Begin
Let me know if this is still a problem, and create a JIRA ticket if it is. I should have some time this weekend to look into it. Clinton On Wed, May 5, 2010 at 9:16 PM, Clinton Begin wrote: > Two things to do: > > * Create a JIRA ticket for this. We'll continue conversation and &

Re: interesting exception in 3.0

2010-05-05 Thread Clinton Begin
What it feels like is that iBatis is hanging onto the connection and reusing > it at a later time. > > What do you need from me to track this down? > > Cheers > > François > > > > On May 1, 2010, at 4:28 PM, Clinton Begin wrote: > >> Then no, I don't bel

Re: Does anyone have any example of "foreach" with annotation

2010-05-05 Thread Clinton Begin
Perhaps with the shiny new SqlBuilder... :-) On 2010-05-05, Jeff Butler wrote: > IIRC, iBATIS doesn't support dynamic SQL in annotations. You'll need > to use an @UpdateProvider and generate the dynamic SQL yourself. > > Jeff > > On Wed, May 5, 2010 at 2:18 AM, shamim wrote: >> >> Hi All, >>  

Re: Ibatis 3 - Lazy Loading and Serializable Sessions

2010-05-04 Thread Clinton Begin
p11.Http11Processor.process(Http11Processor.java:852) >        at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) >        at > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) >        at java.lang.Thread.ru

Re: IBatis version in the code?

2010-05-04 Thread Clinton Begin
It's in the file name in the old Ant based builds... the 240 in your example below is the build number. In the new Maven builds, unfortunately there is no build number anymore. Clinton 2010/5/4 François Schiettecatte : > Hi > > I am trying to track down an issue which appeared when I updated to

Re: Ibatis 3 - Lazy Loading and Serializable Sessions

2010-05-03 Thread Clinton Begin
iBATIS 3 enhanced objects should be serializable. Can you post the exception you're getting? Clinton On Mon, May 3, 2010 at 7:25 PM, moffit wrote: > > Hi, > >  I noticed that this question was asked a few years ago with Ibatis 2.X > without any resolution. > >  Basically, lazy loaded objects ar

Re: interesting exception in 3.0

2010-05-01 Thread Clinton Begin
n 2010/5/1 François Schiettecatte : > I am using JDBC, with C3P0 as my data source. > > Cheers > François > > On May 1, 2010, at 4:14 PM, Clinton Begin wrote: > >> The only code changes related to that were with managed transactions. >> Which transacion manager are y

Re: interesting exception in 3.0

2010-05-01 Thread Clinton Begin
The only code changes related to that were with managed transactions. Which transacion manager are you using? (JDBC or MANAGED)? Cheers, Clinton 2010/5/1 François Schiettecatte : > Hi > > I grabbed the latest, greatest release of 3.0 from : > >         > http://people.apache.org/builds/ibatis/ib

[ANNOUNCEMENT] iBATIS Wiki Moved

2010-04-30 Thread Clinton Begin
The iBATIS Wiki has moved. It was not moved by us, or with our knowledge, but we apologize for the inconvenience anyway. The new link is: http://www.apachebookstore.com/confluence/oss/display/IBATIS/Home I will update the links on the website ASAP, but people.apache.org was also unreachable la

Re: iBatis Wiki page down?

2010-04-30 Thread Clinton Begin
It was moved to http://www.apachebookstore.com/confluence/oss/display/IBATIS/Home without our knowledge. I tried to update the website last night, but people.apache.org was also having routing issues. I'll try to get the new links up tonight. In the mean time, I'll send this out as a broadcast a

Re: Extended support for primitive type mapping

2010-04-25 Thread Clinton Begin
Done. I've also added type aliases for array versions of all of the built in types (using the same naming convention for primitives), for example: "byte[]" ==> Byte[].class "_byte[]" ==> byte[].class etc. Cheers, Clinton On Sun, Apr 25, 2010 at 2:56 PM, Geek Cracovian wrote: > Hi All, > > I'

Re: How to get a result from output parameter(SYS_REFCURSOR) in iBATIS 3(by using annotation)

2010-04-23 Thread Clinton Begin
Unfortunately I don't use Oracle and haven't used OUT params or ref cursors for 10 years. So someone else will have to help you out with an example. Clinton On Fri, Apr 23, 2010 at 10:43 AM, Alex Park wrote: > Thank you Clinton, your answer was very helpful. > I tried to fix my code but I could

Re: How to get a result from output parameter(SYS_REFCURSOR) in iBATIS 3(by using annotation)

2010-04-23 Thread Clinton Begin
To do what you're trying to do, you'll need to write a TypeHandler. iBATIS doesn't allow ResultSets to leave the execution scope. Clinton On Fri, Apr 23, 2010 at 6:20 AM, Alex Park wrote: > Alex Park paran.com> writes: > > > > > Hi there, > > > > How to get a result from output parameter(orac

Re: Transaction management in iBATIS 3 inside an EJB (3.1) container

2010-04-22 Thread Clinton Begin
e, Apr 20, 2010 at 7:48 PM, Clinton Begin wrote: > >> Okay, I've looked around. It is really hard to find the way it's >> "supposed" to work, but I don't think it matters. There's more than enough >> empirical evidence (both in iBATIS 2 and Adinath

Re: iBATIS 3 Live

2010-04-22 Thread Clinton Begin
Do either of you use ManagedTransaction? Clinton On Thu, Apr 22, 2010 at 12:38 PM, Guy Rouillier wrote: > We've had our production customer portal running with iBATIS beta 7 for 3 > months now ;) Working great, but obviously would like to upgrade to a GA > version for our next point release. >

Re: cache question

2010-04-22 Thread Clinton Begin
Yes, but not for output params or ref cursors. On 2010-04-22, Sergey Livanov wrote: > I use iBatis 2.6. v. Does the cache work, when I call the sql statement by > stored procedure ? > -- Sent from my mobile device - To unsubs

Re: Problem with id mapping to IDENTITY in HSQLDB

2010-04-22 Thread Clinton Begin
There's currently no way to use an xml result map from an annotation. Remember, ibatis is not an ORM, so you have to pair result maps with statements each time, and currently the entire pair must be xml or annotations. On 2010-04-22, Andrea Selva wrote: > Hi list, > i've a trouble with IDENTITY i

Re: iBatis 3 - issue using annotations during Maven compile process

2010-04-22 Thread Clinton Begin
Are you sure you're compiling with jdk 5 or above? On 2010-04-22, Davide Rossoni wrote: > I'm using iBatis 3.0 GA and I'm trying to compile my project using Maven. > > Eclipse compiles the project well, without errors, but Maven generates a > COMPILATION ERROR like this: > > MyTableMapper.java:[1

Re: iBATIS 3.0 with Spring and iBatisWorkShop AUTO-COMMIT and session close

2010-04-21 Thread Clinton Begin
It's highly unlikely that these are bugs in iBATIS. We have lots of unit tests that validate this functionality. We've also had 10 straight months of beta testing that have not yielded any problems. One known issue is that ManagedTransactions are not being closed on some app servers, but even th

Re: Transaction management in iBATIS 3 inside an EJB (3.1) container

2010-04-20 Thread Clinton Begin
Okay, I've looked around. It is really hard to find the way it's "supposed" to work, but I don't think it matters. There's more than enough empirical evidence (both in iBATIS 2 and Adinath's custom implementation). So I've added the close to the ManagedTransaction. It will log but otherwise ign

Re: Transaction management in iBATIS 3 inside an EJB (3.1) container

2010-04-19 Thread Clinton Begin
w at the latest. Cheers, Clinton On Mon, Apr 19, 2010 at 1:26 AM, Adinath wrote: > Clinton, > > On Sun, Apr 18, 2010 at 2:45 PM, Clinton Begin wrote: > >> You did the right thing... iBATIS transaction managers are meant to be >> easy to implement yourself. >> &g

Re: Transaction management in iBATIS 3 inside an EJB (3.1) container

2010-04-18 Thread Clinton Begin
You did the right thing... iBATIS transaction managers are meant to be easy to implement yourself. That said, this was a matter of constant debate back in the good old days when none of the standards were implemented consistently. I'm still not sure if they are. Some app servers would complain i

Re: Locks

2010-04-14 Thread Clinton Begin
Not in iBATIS 2... unless you override the entire transaction API. On Wed, Apr 14, 2010 at 10:43 AM, Ejaz X Mohammed < ejaz.moham...@jpmorgan.com> wrote: > I changed the code to use plain jdbc instead of ibatis ... as I said I'm > doing just SELECT ... I started no tranasaction .. now I don't see

Re: DefaultSqlSession.selectOne()

2010-04-13 Thread Clinton Begin
The definition of null is the absence of value and meaning. So regardless of whether it's a null column or no rows, no meaning should be applied to it. Thus these cases are the same. If you want meaning to come from the row, return a value, perhaps the row number. Clinton On 2010-04-13, cowwoc

Re: Unable to get caching to work with IBatis - 3 (Build 242)

2010-04-12 Thread Clinton Begin
Known issue, fixed in trunk ant the next release. Here's the release files, although not officially released yet. :-) http://people.apache.org/builds/ibatis/ibatis-3-core/ibatis-core-3.0.0- bundle.zip Cheers, Clinton On Mon, Apr 12, 2010 at 4:22 PM, IceMan81 wrote: > > Hi, > I am using IBa

Re: Ibatis 3 - special method in model class which Ibatis can't use

2010-04-12 Thread Clinton Begin
Example? 2010/4/12 Tomáš Procházka > Hi. > > I found some problem. I need have special method in model class which do > some lazy initialization which can't be called from iBatis mapper. But > problem is, that iBatis call all getXyz methods during insert or updated, > also if I don't specify thi

Re: Auto-provision of jdbcType for "nullable parameters" case

2010-04-09 Thread Clinton Begin
I've improved this in the next release. While it's not officially released yet, try this: http://people.apache.org/builds/ibatis/ibatis-3-core/ibatis-core-3.0.0-bundle.zip Clinton On Fri, Apr 9, 2010 at 6:18 PM, Nate Weiss wrote: > Hi-- > > First, really enjoying iBatis 3. Thanks to all who

Re: [IBatis3-beta10] nested results for collection

2010-04-07 Thread Clinton Begin
; > List dPartList = d.getCarParts(); > if (dPartList!=null) { > logger.debug(" car Part iterator is not null " + dPartList.size()); > } else { > logger.debug(" car Part List is null " ); > } > > } > assertNotNull("At least one device must e

Re: SqlSession.close() without committing

2010-04-07 Thread Clinton Begin
3, cowwoc wrote: > >> Clinton, > >> > >> I'm not looking for a specification in that sense of the word :) I > meant > >> something along the lines of Design by Contract: > >> http://en.wikipedia.org/wiki/Design_by_contract > >> > >

Re: SqlSession.close() without committing

2010-04-07 Thread Clinton Begin
I agree, EJB 3 looks very good. But my point was that the first two iterations of the spec didn't help. And if anything, the non-spec driven Spring framework drove EJB 3 to be what it is today. Clinton On Wed, Apr 7, 2010 at 11:06 AM, Guy Rouillier wrote: > On 4/7/2010 9:50 AM, Clint

Re: SqlSession.close() without committing

2010-04-07 Thread Clinton Begin
e lines of Design by Contract: > > http://en.wikipedia.org/wiki/Design_by_contract > > > > If my code depends on iBatis and upgrading to a newer version breaks > my > > code then how do we establish whether the problem is: > > > > 1. The iBatis implement

Re: SqlSession.close() without committing

2010-04-07 Thread Clinton Begin
guaranteed > by the specification (i.e. a bug in my application) > > Thanks, > Gili > > > On 07/04/2010 9:50 AM, Clinton Begin wrote: > > Then you might be happier with a spec like JPA. Although I'd warn that > such specs are rarely implemented consistently.

Re: "JDBC requires that the JdbcType must be specified for all nullable parameters"

2010-04-07 Thread Clinton Begin
Null parameters are allowed, so we can't fail upon them. To maintain compatibility with string based calls against map parameters, we don't distinguish between a null keyed entry in the map and no keyed entry at all. I'd be willing to consider this change, but it's one of those things that has al

Re: "JDBC requires that the JdbcType must be specified for all nullable parameters"

2010-04-07 Thread Clinton Begin
Yes, that can be reworded and more information is likely possible. Can you file a Jira ticket for this? Clinton On Tue, Apr 6, 2010 at 10:09 PM, cowwoc wrote: > Hi, > >I am getting an error message: > >"JDBC requires that the JdbcType must be specified for all nullable > parameters [..

Re: SqlSession.close() without committing

2010-04-07 Thread Clinton Begin
Then you might be happier with a spec like JPA. Although I'd warn that such specs are rarely implemented consistently. This is what has killed J2EE vs. the alternatives. Look at the history: * CMP - Spec. Dead, along with all implementations. * EJB - Spec. Dead. Spring killed it -- not a sp

Re: [IBatis3-beta10] nested results for collection

2010-04-06 Thread Clinton Begin
gt; Class X { > String id > String desc > List b > } > If index is null the desc is applicable for X and when its not null it > should be applicable to X. > > --V > > On Apr 6, 2010, at 7:21 PM, Clinton Begin wrote: > > If iBATIS finds ANY values for the mapped propertie

Re: [IBatis3-beta10] nested results for collection

2010-04-06 Thread Clinton Begin
If iBATIS finds ANY values for the mapped properties, it will create the object. Is it possible that the desc column is populated even when the index is null? On Tue, Apr 6, 2010 at 7:52 PM, Viv Kapadekar wrote: > Hi > I have a Class X containing a List of Class Y > > Class X { > String a > List

Re: SqlSession.close() without committing

2010-04-05 Thread Clinton Begin
Yes, iBATIS will rollback the connection if it deems it necessary. The only time you might need to call rollback explicitly is if you have a "select" that actually updates data in the database. Such is sometimes the case with stored procedures. Clinton 2010/4/5 François Schiettecatte > If you

Re: iBatis 3.0 Javadoc?

2010-04-05 Thread Clinton Begin
in the exception chain, but you'll have to catch Exception and follow the nested exception chain. Clinton On Mon, Apr 5, 2010 at 2:50 PM, Clinton Begin wrote: > I don't, because I don't consider it a problem. It's a personal opinion of > mine that I much prefer pro

Re: iBatis 3.0 Javadoc?

2010-04-05 Thread Clinton Begin
I don't, because I don't consider it a problem. It's a personal opinion of mine that I much prefer proper documentation like the User Guide to source generated docs. I've never read a decent JavaDoc outside of the JDK itself, and therefore I don't depend on them. That's just me though. In the p

Re: New Data Type - Date in Sql Server 2008

2010-04-04 Thread Clinton Begin
iBATIS returns whatever type you tell it to based on your result maps or just the bean property type. Based on this it calls rs.getXxxx() where X() is the type. iBATIS performs no conversions. So in a sense, as long as the new SQL Server driver is JDBC compliant, it should work fine. Clin

Re: Migrations: GMT question

2010-04-03 Thread Clinton Begin
Fixed in trunk. Will be released within a day or two as 3.0 GA candidate. Cheers, Clinton On Sat, Apr 3, 2010 at 10:21 AM, Dzmitry Lazerka wrote: > up > > > On Wed, Mar 17, 2010 at 16:50, Dzmitry Lazerka wrote: > > Hi! > > > > I have default configuration "time_zone=GMT+0:00" > > and I'm now

Re: ClassInfo.CLASS_INFO_MAP

2010-04-02 Thread Clinton Begin
I the performance penalty would be quite a bit, so I wouldn't use it in production. But it's fine for development. Hopefully you're not reloading your app in production regularly. Clinton On Thu, Apr 1, 2010 at 11:26 PM, Derek Scherger wrote: > On Thu, Apr 1, 2010 at 10:55

Re: ClassInfo.CLASS_INFO_MAP

2010-04-01 Thread Clinton Begin
This is a known issue. I agree that it would be nice to do something with it. Ideas are welcome. The only one I have at the moment is to make ClassInfo an instance and inject it into the SQL mapper configuration. I've done similar things to eliminate static classes in the framework. You can ca

Re: Preferred tool for database modeling and generating SQL / DDL

2010-04-01 Thread Clinton Begin
+1 for Aqua! On Thu, Apr 1, 2010 at 1:12 PM, Larry Meadors wrote: > I use Aqua Data Studio, it's a java app. > > François: SQL Editor looks pretty nice, I may have to try it. :) > > Larry > > > 2010/4/1 François Schiettecatte : > > Josh > > > > On the Mac I used an application called SQLEditor wh

Re: MSSQL, schema migrations format issue

2010-03-28 Thread Clinton Begin
1 minute and 21 seconds later you'll have a snapshot build of the migrations in: /target/ibatis-core-3.0-SNAPSHOT-migrations.zip Unzip it and you'll recognize the contents to replace your existing Migrations implementation. Clinton On Sun, Mar 28, 2010 at 4:10 PM, Clinton Begin wrot

Re: MSSQL, schema migrations format issue

2010-03-28 Thread Clinton Begin
x27;t sure if there was maybe a JDBC > driver issue or if it was something that schema migrations was doing. > > I've tried saving the scripts in both windows and un*x line ending format > and that didn't seem to have any effect. > > > Thanks! > > > On Fri, M

Re: Question about how to use rollback

2010-03-28 Thread Clinton Begin
You don't even have to really... it will be called automatically if you don't call commit in most cases. Write a unit test for yourself to confirm this in your environment. But yes, what you wrote looks fine. My only recommendation would be to roll back regardless of the exception type (e.g. cat

Re: MSSQL, schema migrations format issue

2010-03-26 Thread Clinton Begin
What do you mean view in your console? Clinton On Thu, Mar 25, 2010 at 10:03 AM, chris oberle wrote: > Hello, > > I have a keen interest in using Ibatis Schema MIgrations but am having an > issue and am hoping someone can tell me if there is anything I can do about > it. > > For some reason, whe

Re: IBatis 3.0 beta 10 + annotations + stored procedures

2010-03-24 Thread Clinton Begin
24, 2010 at 9:15 PM, Clinton Begin wrote: > You have to tell iBATIS that it's a proc, and set the statement type to > CALLABLE and set the parameter to an output parameter, as follows: > > @Select(" ibatis3select(#{Currency*,mode=OUT*}) ") > *...@options(

Re: IBatis 3.0 beta 10 + annotations + stored procedures

2010-03-24 Thread Clinton Begin
You have to tell iBATIS that it's a proc, and set the statement type to CALLABLE and set the parameter to an output parameter, as follows: @Select(" ibatis3select(#{Currency*,mode=OUT*}) ") *...@options(statementType = StatementType.CALLABLE)* Integer selectACurrencyBatis3(String sCurrency ); Mos

Re: Test iBATIS 3.0 trunk ...before GA!

2010-03-23 Thread Clinton Begin
Thanks Martin. Core is the only module. The compat module is for testing only. Cheers, Clinton On Tue, Mar 23, 2010 at 8:20 AM, Martin Ellis wrote: > On 23 March 2010 03:05, Clinton Begin wrote: > > I plan on cutting a release this week for iBATIS 3.0. Officially it will > be

Test iBATIS 3.0 trunk ...before GA!

2010-03-22 Thread Clinton Begin
Hi all, I plan on cutting a release this week for iBATIS 3.0. Officially it will be Beta 11, but I will cast the vote for it to become the GA release. If you can, please check out from the trunk and build it from source to try it out. Let us know if there are any last minute challenges. This i

Re: Fluent SelectBuilder

2010-03-22 Thread Clinton Begin
Criticism is welcome here, especially in this somewhat "risky" feature. To begin though, SelectBuilder is more of a utility than anything. You could easily create your own builder and use it with no consequence. There is no dependency on SelectBuilder nor any requirement to use it. My story is

Re: what happened to queryForMap?

2010-03-19 Thread Clinton Begin
It was liquidated. Honestly I thought it was messy... but maybe I underestimated its usefulness... Clinton On Fri, Mar 19, 2010 at 3:19 PM, Rick R wrote: > I really though queryForMap was cool. I'm looking for how to do it in > ibatis3 but don't see a way. Doesn't seem to exist as a select type

Re: Novice problem with circular dependencies

2010-03-19 Thread Clinton Begin
Unfortunately you can't do that with nested result maps that way. The problem is that the iBATIS sql map syntax doesn't allow for a way to express the shift of IDs. To build a hierarchy of nodes for example, the parent node id has to use the same column as the child node id. Because of this, iBA

Re: iBatis 2.x vs. iBatis 3.x performance

2010-03-18 Thread Clinton Begin
p and properties step in this process: > >sqlSessionFactoryBuilder.build(reader, properties); > > make sense? Not sure how feasible or desirable this is given that I can > keep SqlSessionFactory(ies) resident. > > Thanks again > > François > > On Mar 18, 2010,

Re: iBatis 2.x vs. iBatis 3.x performance

2010-03-18 Thread Clinton Begin
Factory().build(reader, > properties) for each host name/database name/user name you access. Or did I > miss something here ? > > Cheers > > François > > > On Mar 17, 2010, at 11:21 PM, Clinton Begin wrote: > > > I'm not sure what to say... this is not really

Re: iBatis 2.x vs. iBatis 3.x performance

2010-03-17 Thread Clinton Begin
I'm not sure what to say... this is not really an iBATIS issue. * First, you're purposefully going directly against a key part of the SqlSession contract. There's an entire section in the user guide about SqlSession lifecycle (Page 9) and you're completely ignoring it. This makes it very diffi

Re: ibatis 3 basis

2010-03-17 Thread Clinton Begin
/Contribute+Documentation Clinton On Wed, Mar 17, 2010 at 9:49 AM, Clinton Begin wrote: > If there's documentation lacking, please contribute it as per the note > within the first couple of pages of the user guide. > > > > On 2010-03-17, Jon Finanger wrote: > > Thanks, &

Re: ibatis 3 basis

2010-03-17 Thread Clinton Begin
If there's documentation lacking, please contribute it as per the note within the first couple of pages of the user guide. On 2010-03-17, Jon Finanger wrote: > Thanks, > Hmm...missing some letters there I see... > Got a step furtherthe 3 version differs a bit from the 2 version I > realize.

Re: setNull and default jdbcType

2010-03-16 Thread Clinton Begin
Fixed. Give it a try. Clinton On Tue, Mar 16, 2010 at 12:28 PM, Bekkum Odd-Rune wrote: > 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. > > Thank

Re: Datasource JNDI

2010-03-16 Thread Clinton Begin
Did you try writing a quick pure java test to see if it's the jndi config or something else? On 2010-03-16, phasor wrote: > > Hi, > > I´m facing a problem when deploying an extjs app(using ibatis plugin) to > oracle application server 10. > In sqlmapconfig.xml i´m referencing a jndi datasource th

Re: setNull and default jdbcType

2010-03-16 Thread Clinton Begin
Thanks. A few others have reported this, but until now I didn't understand what was happening. It's unusual for Postgres to allow Types.OTHER for setNull. Indeed I did remove that code. I don't think it should be a problem to put it back. I'll try to commit something tonight, and if you're wil

Re: ibatis 3.0 - @Insert with Insert select fails

2010-03-11 Thread Clinton Begin
pecify parameter names, they default to #{0}, #{1}, #{2} etc... On Wed, Mar 10, 2010 at 10:11 PM, marksomaha wrote: > > Clinton, > > No, I am not using @Param. I've read the User Guide, but I don't know what > the exact syntax to use. > As I am a newbie to I

Re: ibatis 3.0 - @Insert with Insert select fails

2010-03-10 Thread Clinton Begin
Are you naming the parameters in your method using @Param? Clinton On Wed, Mar 10, 2010 at 6:14 PM, marksomaha wrote: > > Follow-up: Embarrassed to say the "Invalid table name" was my own typo. > "Insert into USER..." should have been "Insert into USERS..." > > Now, it runs, but it is still no

Re: SqlSession question

2010-03-08 Thread Clinton Begin
The only rationale there is to allow for you to commit more than once within a session scope. In previous versions of iBATIS this was possible, but was messy because Session, Transaction and Batches were all managed separately. Because we've now merged all three into this one concept, we didn't w

Re: Mapping associations for resultsets obtained from cursors (iBatis 3beta10)

2010-03-08 Thread Clinton Begin
Hmmm... RefCursors might be defaulting to the FastResultSetHandler, which doesnt' load relationships. Should be a simple fix. Unfortunately I'm without my computer (no way!) right now. If anyone's interested in why you should never buy Lenovo, let me know. ;-) Clinton On Mon, Mar 8, 2010 at 4

Re: Should IntegerTypeHandler use Integer.valueOf instead of new Integer()

2010-03-05 Thread Clinton Begin
Yes, that's correct. Cheers, Clinton On Fri, Mar 5, 2010 at 1:13 PM, Michael Schall wrote: > In looking at this further... Resultset.getInt returns an int... > http://java.sun.com/j2se/1.5.0/docs/api/java/sql/ResultSet.html#getInt(int) > > However the autoboxing feature of Java 1.5 converts it t

Re: ResultHandler

2010-03-05 Thread Clinton Begin
That's a good observation. Can you throw a feature request in jira? Cheers, Clinton On 2010-03-05, François Schiettecatte wrote: > Hi > > Any reason why there are only two select() methods in > org.apache.ibatis.session: > > void select(String statement, Object parameter, ResultHandler handle

Re: Migrating from ibatis 2 to 3

2010-03-04 Thread Clinton Begin
now and it makes my code simpler. I > know I *could* modify the iBATIS 3 code but I am loath to do that because it > would introduce variability. > > FWIW iBATIS 2 was completely stable sharing SqlMapClient, I had no issues > for 18 months. > > Cheers > > François > &g

Re: Migrating from ibatis 2 to 3

2010-03-04 Thread Clinton Begin
>> Session Level Cache ... does not work if the data has been changed by >> another process The session level cache is exactly that... session level. It only clears things local to your session. If another process changes data, you should have cache flushing rules in place to cause the cache to

Re: ibatis beta 10 (accidentally?) compiled with JDK 6?

2010-03-01 Thread Clinton Begin
I've recompiled Beta 10 with JDK 5. The website should be updated in a few hours (mirroring). The builds to look for are 242 (for core framework) and 243 (for migrations). Cheers, Clinton On Mon, Mar 1, 2010 at 7:53 AM, Clinton Begin wrote: > Indeed. This was accidental. > >

Re: ibatis beta 10 (accidentally?) compiled with JDK 6?

2010-03-01 Thread Clinton Begin
Indeed. This was accidental. Clinton On 2010-03-01, Stephen Friedrich wrote: > That works fine, indeed. > > So it seems it's only the download linked from the main java page is > broken: > http://people.apache.org/builds/ibatis/ibatis-3-core/ibatis-3-core-3.0.0.240.zip > > Thanks for your help!

Re: read large result set in Ibatis3

2010-02-25 Thread Clinton Begin
A REALLY good example of a paginated web service is amazon's merchant apis. I can't recall the exact name (AWS?), but I remember really liking how they implemented a usable web service on top of what is probably the largest product database on the web. Clinton On 2010-02-25, zkn wrote: > My bad

Re: read large result set in Ibatis3

2010-02-24 Thread Clinton Begin
Ibatis shouldn't block that way. Can you confirm that it's not a table lock? On 2010-02-24, Tomáš Procházka wrote: > > I don't need expose JDBC. I only continuously read large table as queue and > process every item. > > I already used ResultHandler and ArrayBlockingQueue in handleResult(). If >

Re: why is ibatis rolling up for an association, not sure why this isn't flat, or what its rolling up on?

2010-02-21 Thread Clinton Begin
The reason is that the rows aren't uniquely identified. Upon a second look, I see that the column I recommended isn't unique. Which columns uniquely identify each parent row? On Sun, Feb 21, 2010 at 9:50 PM, Rick R wrote: > And those static methods will be moved to a Helper file:) it's not my

Re: why is ibatis rolling up for an association, not sure why this isn't flat, or what its rolling up on?

2010-02-21 Thread Clinton Begin
Oh... also put an element on the parent (likee parentValueID?). Also, be careful with automapping and nested results. In Beta 9 I added configuration to disable automapping for nested results, only because it was confusing where the results would end up. But that doesn't look like a problem her

Re: why is ibatis rolling up for an association, not sure why this isn't flat, or what its rolling up on?

2010-02-21 Thread Clinton Begin
It rolls up by elements, or if none exist, it rolls up by all columns (which is why specifying an id is important). Clinton On Sun, Feb 21, 2010 at 5:55 PM, Rick R wrote: > I'm now starting to get into using ibatis3 more and I'm curious about why a > 'roll up' is happening (based on a column I

Re: iBatis annotation related questions

2010-02-19 Thread Clinton Begin
this matter? > > Jan > > > 2010/2/19 Clinton Begin > >> There will be a new release by then, probably this weekend. >> >> On 2010-02-19, Ing. Jan Novotný wrote: >> > 3rd March. >> > >> > 2010/2/19 Clinton Begin >> > >> >&

Re: iBatis annotation related questions

2010-02-19 Thread Clinton Begin
There will be a new release by then, probably this weekend. On 2010-02-19, Ing. Jan Novotný wrote: > 3rd March. > > 2010/2/19 Clinton Begin > >> When is your workshop? >> >> On 2010-02-18, Ing. Jan Novotný wrote: >> > Thank you guys for sharing yo

  1   2   3   4   5   6   7   8   9   10   >