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: 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
/group/mybatis-user On Mon, Jun 14, 2010 at 9:10 AM, Nathan Maves wrote: > This is all great stuff but if you could please great a ticket//issue > for this and attach the fix to it.  This way we can track it. > > Submission form - http://code.google.com/p/mybatis/issues/entry > >

Re: SQLExecutor.addBatch() modified

2010-06-14 Thread Nathan Maves
This is all great stuff but if you could please great a ticket//issue for this and attach the fix to it. This way we can track it. Submission form - http://code.google.com/p/mybatis/issues/entry Nathan On Sun, Jun 13, 2010 at 11:10 PM, wrote: > By default for batch inserts ibatis caches the p

Re: special characters in xml

2010-05-10 Thread Nathan Maves
The most common and safe(sql injection) method is to continue to use prepared statement parameters and create the value in Java. In Java construct the String with a StringBuilder and then pass the value into a normal iBatis parameter #{value}. Nathan On Mon, May 10, 2010 at 5:27 AM, masonka...@l

Re: date in where clause does not work.

2010-05-04 Thread Nathan Maves
Wel ALWAYS use java.util.Date send us your sqlmap On Tue, May 4, 2010 at 10:03 AM, Jeremy Jardin wrote: > > Ok, I'm doing something like that. > > TabChifExample criteria = new TabChifExample(); > criteria.createCriteria().andDatChifGreaterThan (new java.util.Date() ); > .. etc... > > I've seen

Re: Problem accessing List instance property via

2010-04-28 Thread Nathan Maves
Which version are you using? It looks to be IB2 and if that is true I would suggest to moving up to 3.x. On Mon, Apr 26, 2010 at 1:02 PM, devver wrote: > > Hi > > I'm new to iBatis and I'm struggling to access a property of instances > stor4ed in a list which, in turn are passed to ibatis in a H

Re: Migration and maven plugin

2010-04-22 Thread Nathan Maves
absolutely put in a jira and your patch and we will look at it On Thu, Apr 22, 2010 at 10:53 AM, Marco Speranza wrote: > Hi all, I'm working to develop a little maven plugin that integrates ibatis > migrate API with the maven build life cycle. Now I have to integrate the > system.out informati

Re: iBATIS 3 Live

2010-04-22 Thread Nathan Maves
I too have an application, which is not live just yet, but very solid. Clinton and I are looking to release the 3.0.1 GA as soon as we get a vote out to the community. Look for a vote email this weekend. We encourage every one from the community to vote on the GA version. Nathan On Thu, Apr 22

Re: how to pass two different types of values to query in IBATIS

2010-04-13 Thread Nathan Maves
ma separated string of numbers and pass that, so in the example below >>> I >>> would turn the array (90,89,93,45,67) into a string "90,89,93,45,67" and >>> pass that. Ugly but workable. >>> >>> Did I understand the question correctly? >>>

Re: ..\migrate and strored procedures

2010-04-13 Thread Nathan Maves
this was already fixed in the latest code http://people.apache.org/builds/ibatis/ibatis-3-core/ibatis-core-3.0.0-bundle.zip On Tue, Apr 13, 2010 at 12:14 AM, Dmitry Mamonov wrote: > Hi everyone! > > I'm trying to apply ibatis-migrations to manage our database schema and I > found a semantic prob

Re: return simple String[] or List

2010-04-12 Thread Nathan Maves
Tomas, I am assuming that you have not read the developers guide and I just giving things a go. You need to read the guide completely. In this case Guy was saying that if your query only returns a string then set the resultType to String. Then use the ibatis queryForList() to compile your resul

Re: how to pass two different types of values to query in IBATIS

2010-04-12 Thread Nathan Maves
I am not sure you are grasping the concept here. Both IB2 and IB3 can take any type of java.util.Map implementation as a parameter. Map parameters = new HashMap(); parameters.put("someNumber", Integer.valueOf(123)); parameters.put("someString", "hello"); Now use that parameter as the single para

Re: Dynamic table replacement possible in iBatis3 ?

2010-04-08 Thread Nathan Maves
You are only half correct. The format that you just used as an example is only for parameters. He is looking for the string substitution which also changed. #{foo} == jdbc set parameter ${foo} == string substitution before the prepared statement Nathan 2010/4/7 François Schiettecatte : > The f

Re: FW: object no longer exists

2010-04-07 Thread Nathan Maves
This is a sql exception from oracle. This does not look like it has anything to do with ibatis. On Wed, Apr 7, 2010 at 11:52 AM, Vinaya Tirikkovalluru wrote: > Just resending it, as I got a failure notice > > > > Thanks > Vinaya > > > > > > From: Vinaya Tirikkova

Re: Dynamic table replacement possible in iBatis3 ?

2010-04-07 Thread Nathan Maves
this still works in IB3. Give us more of your code to figure out where the issue really is. Show us the full sqlmap/annotation as well as the calling method. N On Wed, Apr 7, 2010 at 8:46 AM, Joram Barrez wrote: > Hi All, > > I was wondering if this is possible with iBatis 3: > > >    select c

Re: Need iBatis 3.0 User Guide Other Format..

2010-04-06 Thread Nathan Maves
You can find all of the documentation in SVN. The source is the Microsoft Word document. Once you are done with the translation feel free to contribute it back to the community and we will add it to the site. Nathan http://svn.apache.org/repos/asf/ibatis/java/ibatis-3/trunk/doc/en/ On Tue, Apr

Re: db2 -302 error

2010-03-23 Thread Nathan Maves
validate your data before you send it to IB. If you know that your column is set to a max length of 30 then check that before you try and send it. On Tue, Mar 23, 2010 at 12:28 AM, joson yu wrote: > ok. i have got it. thank you. > but i want ask one question more. > the root of the problem is

Re: Ibatis sql-maps

2010-03-18 Thread Nathan Maves
in the future please do not post to both email groups. keep these types of questions on the normal java interest list. On Thu, Mar 18, 2010 at 2:00 PM, kiran vuppla wrote: > Thanks. Is it freeware? > > From: shamim > To: user-java@ibatis.apache.org > Sent: Thu,

[IB3] method overloading in a mapper

2010-03-17 Thread Nathan Maves
I think I just ran into a small issue. I have the follow in my mapper interface. The second method has the sql defined in a XML file. @Select("select Clients.* from Clients, Accounts where Accounts.id = Clients.accountId and Accounts.id = #{accountId} order by name") public List listForAccount

Re: ibatis 3.0 - @Insert with Insert select fails

2010-03-10 Thread Nathan Maves
Sure do :) Great error message eh use ${trgUserId} in the select portion and leave #{trgUserId} in the where clause. # infers a true jdbc parameter which are not allowed in the select portion of a statement. Nahtan On Wed, Mar 10, 2010 at 4:28 PM, marksomaha wrote: > > I am trying to do

Re: How to do logging in iBatis + Spring

2010-03-07 Thread Nathan Maves
Yes use standard logging or a logging framework like log4j. just set the following You can define them at a more granular level if you want. On Sun, Mar 7, 2010 at 8:13 AM, Bhaarat Sharma wrote: > We use iBatis + Spring and make use of stored procedures t

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

2010-03-04 Thread Nathan Maves
Here is how IB3 does it *BaseTypeHandler* * * public Object getResult(ResultSet rs, String columnName) throws SQLException { Object result = getNullableResult(rs, columnName); if (rs.wasNull()) { return null; } else { return result; } } *IntegerTypeHandler*

Re: iBatis annotation related questions

2010-02-18 Thread Nathan Maves
I completely agree. I too have a project using IB3 and I am really loving mixing the two together. I would give it a try before trying to corner yourself into using just one approach. Nathan Maves nathan.ma...@gmail.com On Feb 18, 2010, at 4:09 PM, Clinton Begin wrote: > Just curi

Re: iBatis 3.0 minimal complete example

2010-02-10 Thread Nathan Maves
ime for Jpetstore 6. > > > And without leveraging Guice or Spring :) Nathan Maves nathan.ma...@gmail.com

Re: table name as parameter

2010-02-08 Thread Nathan Maves
ideas? > > Thanks, > > Tom > > > -- > View this message in context: > http://old.nabble.com/table-name-as-parameter-tp27505213p27505434.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > ---

Re: Migration schema windows script

2010-02-05 Thread Nathan Maves
gt; > I've also fix this problem, can I post the fixed script in this ML or I have > to open a Jiira bug? > > thanks > > > -- > Marco Speranza Nathan Maves nathan.ma...@gmail.com

Re: Little question about type check between resultMap and java return type

2010-01-28 Thread Nathan Maves
list of items filled with null object, the > number of elements was the one retrieved from database. > I will like to know if that is the right behaviour of ibatis. > > How can I catch the bugs derived from wrong mapping ? > > Thanks a lot. > > > > -- > Marco Speranza Nathan Maves nathan.ma...@gmail.com

Re: Writing subqueries

2010-01-27 Thread Nathan Maves
nsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > Nathan Maves nathan.ma...@gmail.com - To unsubscribe, e-mail: user-java-unsubscr.

Re: How would you - the experts - design this?

2010-01-26 Thread Nathan Maves
esign-this--tp27304322p27319887.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > - > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-

Re: is 3.0-beta-9 missing from central repo?

2010-01-24 Thread Nathan Maves
he 3.0-beta-9 is out, I switched in > my pom to the new version, but is not resolved from the central repository... > can anyone please tell me how I can get it using maven? > Many thanks in advance, best regards!!! > Simo > > > http://people.apache.org/~simonetripo

Re: Re-2: Logging in iBatis 3

2010-01-12 Thread Nathan Maves
There are times when you have an expected exception case. Now I know that statement contradicts itself but move on :) I have seen DB check constraints that throw unique exceptions. That being said you should know that the table/proc/function might throw these and you need to recover from them.

[Announcement] iBATIS 3.0 beta 8 released

2010-01-11 Thread Nathan Maves
Beta 8 is out. There were only 4 issues discovered during this beta period, but more importantly, they were quite minor and quite low level. Two could be classified as non-functional/performance related. So the kinds of issues we're finding now are in the "tweaks and tuning" classification. This gi

Re: 3.0-beta-8 to central maven repository?

2010-01-11 Thread Nathan Maves
my bad I spaced out the maven deployment. Just uploaded them to apache. Now we will wait :) I will send out a blast to the email list once I see it out there. Feel free to watch as well. http://repo2.maven.org/maven2/org/apache/ibatis/ibatis-sqlmap/ On Mon, Jan 11, 2010 at 10:53 AM, Tom Kuni

Re: stored procedure in iBatis 3

2010-01-07 Thread Nathan Maves
1) You might want to read the documentation one more time. 2) here is your map {call TEST_SP(?,?)} or with inline parameters {call TEST_SP(#{bar},#{bat})} On Thu, Jan 7, 2010 at 12:09 AM, vishalj wrote: > > This is the JDBC proc for the same > > > >CallableSt

Re: Mapping a Complex Object

2010-01-04 Thread Nathan Maves
Dan, In short I think the largest issue I have seen with your thought process is over design issues. You reference that you want to use Guice but the Guice team would disagree with your approach to use static factory methods instead of constructors. DI frameworks like Guice have almost removed a

[Announcement] ibatis addons project site

2010-01-03 Thread Nathan Maves
I have created a new hosting site for any addons that are not part of the core. This site will be used for components like IDE Support, Cache Support, DataSource Support, Plugins, Utilities etc... This allows us to avoid the need to get everyone signing CLAs and would gives us more freedom over

Re: How about a Netbeans integration plugin?

2010-01-02 Thread Nathan Maves
s. Of course, all would still have to be Apache 2.0 licensed. > > > Clinton > > On Sat, Jan 2, 2010 at 2:47 PM, Nathan Maves wrote: > >> So I have the first version of the Netbeans Plugin Module done. Simple >> yet functional. I have yet to put it into svn but let

Re: How about a Netbeans integration plugin?

2010-01-02 Thread Nathan Maves
Issues - How to link a mapper type to a typeAlias On Sun, Dec 27, 2009 at 11:57 AM, Nathan Maves wrote: > just a heads up I started working on a plugin this morning. I would > love some help so if you are interested let me know and we can > collaborate. > > Nathan > >

Re: How about a Netbeans integration plugin?

2009-12-27 Thread Nathan Maves
just a heads up I started working on a plugin this morning. I would love some help so if you are interested let me know and we can collaborate. Nathan On Sun, Dec 27, 2009 at 5:44 AM, Kai Grabfelder wrote: > Hi there, > > some while ago I directed a student projects leading to the creation of a

Re: How about a Netbeans integration plugin?

2009-12-26 Thread Nathan Maves
Being an avid NB user as well I would love to see this. I have even though about writing it myself once or twice. Not sure how much free time I have right now but I would do my best to help. Nathan On Sat, Dec 26, 2009 at 4:49 AM, stefcl wrote: > > Hello, > > I have been using Ibatis v3 for a

Re: IBATUS - Fetching a List of List of Strings from the XML Mapping - Help Needed

2009-12-18 Thread Nathan Maves
First off welcome to ibatis! Second please don't use this email list for help topics like this. You should use the user-java@ibatis.apache.org for normal question like this. This allows others in the community to help. I have included it in the reply to move this to the correct email list. You

Re: Should I use Ibatis 2 or 3 for a new project?

2009-12-09 Thread Nathan Maves
As a member of the team here I fully support version 3.0. I am working on a new project and chose to use 3.0. I also believe that Clinton is also using for a new production product. As we have said before on the list, it is up to the community to decide when 3.0 goes GA. As for a RC version I a

[Announcement] iBATIS 3.0 beta 6 released

2009-12-08 Thread Nathan Maves
Only a few minor issues were submitted over the last few weeks, and all have been addressed. It's been pretty quiet, and so I'm gaining more confidence in this release. Could Beta 6 be the one that goes GA? Only you can say for sure. Give it a try, and let us know! The java downloads can be found

Re: Ibatis using my own pool

2009-11-26 Thread Nathan Maves
1) what is a connectionUrl 2) show us some code 3) did you read the docs? On Thu, Nov 26, 2009 at 2:24 AM, Jeremy Jardin wrote: > > Hi, > > I'd like toconfigure ibatis with my own connection pool, so I set my pool > as > the connnectionUrl in the sqlMapConfig.xml file. > But, unfortunately, it se

Re: ibatis 3 petstore

2009-11-04 Thread Nathan Maves
I started on one but got pulled away with real life :) Guess I need a vacation to get some free time to code :) Man that sounds like hell. On Wed, Nov 4, 2009 at 11:45 AM, a b wrote: > Is there a sample application written in ibatis 3 and spring such as > petstore? > > thanks > > > > > ---

Re: ibatis 3 COUNT -> Boolean

2009-11-04 Thread Nathan Maves
here is the java doc for how the resultset implementation should handle this. As long as your query will only return 0/1 you should be okay. If not, then I would just wrap the count() in an if and return a 1 if count was more than 1. I would also set both the jdbc type and the return type. jdbc

[Announcement] iBATIS 3.0 beta 5 released

2009-11-01 Thread Nathan Maves
Only a few minor issues were submitted over the last few weeks, and all have been addressed. It's been pretty quiet, and so I'm gaining more confidence in this release. Could Beta 5 be the one that goes GA? Only you can say for sure. Give it a try, and let us know! The java downloads can be found

Re: locking the queries mysql ibatis

2009-10-25 Thread Nathan Maves
If they were trying to tell you that you have database locking issues you should start to read here http://en.wikipedia.org/wiki/Lock_(database). As Clinton states we can't debug your application for you. If you come to this community with a specific ibatis issue we will gladly help. Get some mo

Re: caching question

2009-10-22 Thread Nathan Maves
Lets make sure everyone is on the same page here. First the terms. IBATIS Cache == a collection of Resultsets Resultset == collection of rows from the executed query. Like is has been said a few times ibatis caches resultsets. So here are some examples. Lets start with a query for People that

Re: static SqlMapClient and transaction isolation problem

2009-10-22 Thread Nathan Maves
Ibatis 2.x does use ThreadLocal to handle the transactions. With ibatis 3 you need to handle this on your own right now but we have been playing with a few ways to use ThreadLocal with it as well. I actually have a pretty clean working webapp using it. On Thu, Oct 22, 2009 at 9:09 AM, Rick.Wellm

Re: queryForMap() ordering

2009-10-21 Thread Nathan Maves
Ah I overlooked that you were using queryForMap(). Maybe I can clear this up for you. If you need a list of ordered objects then use queryForList(). If you want a map based on a key for quick lookup then use queryForMap(). Without knowing what you are trying to query for I dont know which is be

Re: queryForMap() ordering

2009-10-21 Thread Nathan Maves
what is your result class for the sqlmap? Have you tried to use "java.lang.LinkedHashMap" ? Nathan On Wed, Oct 21, 2009 at 12:00 PM, George.Francis wrote: > > I've tried to find the doco for this, but havent so far. In iBatis, if I > use > queryForMap(), the resulting Map ordering (predictably)

Re: Not identifying missing parameter names

2009-10-21 Thread Nathan Maves
I dont think that this is possible from this direction. Remember that the sqlmap was just doing a map.get("cust_id") and getting null back which is the expected behavior. On the flip side you might be able to have a check on the @Param to see if there is actually a var in the sqlmap named that. W

Re: Manage a collection wrapped within another object

2009-10-17 Thread Nathan Maves
yes On Sat, Oct 17, 2009 at 6:42 AM, fadishei wrote: > > Hello > > Assume that you have collection property "actors" in a mapped class "Movie" > and your code works fine this way: > > Movie.java: > ... > protected List actors; > ... > > > But I need to declare this property as: > > Movie.java: >

[Announcement] iBATIS 3.0 beta 4 released

2009-10-12 Thread Nathan Maves
The java downloads can be found at the following link. http://ibatis.apache.org/java.cgi Both the beta 3 and beta 4 releases have also be posted to the maven2 repositories. http://repo2.maven.org/maven2/org/apache/ibatis/ibatis-sqlmap/ We welcome all feedback, and the sooner we get it the faster

Re: 3.0 Beta 3 is not in maven repository. Please add the beta to the repository.

2009-10-08 Thread Nathan Maves
Well I must have just squeaked in under the wire because look what I found! http://repo2.maven.org/maven2/org/apache/ibatis/ibatis-sqlmap/3.0-beta-3/ On Thu, Oct 8, 2009 at 12:38 AM, Nathan Maves wrote: > With all of that said I did push 3.0-beta-3 out to the apache maven sync > serve

Re: Problem when parsing dao.xml

2009-10-07 Thread Nathan Maves
yeah but how cool are unit tests that use mockito and guice! BAM! f'in slick! On Wed, Oct 7, 2009 at 12:13 PM, Larry Meadors wrote: > Nah, mockito is cooler than even guice. It's the shiz. > > If you can't test your code with mockito...go home or become a manager. ;-) > > Larry > >

Re: Performance retrieving list of strings.

2009-10-07 Thread Nathan Maves
The key here was the sheer number of rows being returned. Being that Diran is actually a close friend of mine we worked out a solution to use the fectchSize attribute on the select. This is a very important attribute for large selects. the default Oracle fetch size is actually 10 rows. So in the

Re: 3.0 Beta 3 is not in maven repository. Please add the beta to the repository.

2009-10-07 Thread Nathan Maves
for the > reason that Maven is technology specific as well... our .NET version isn't > in Maven either. > > Clinton > > > On Wed, Oct 7, 2009 at 4:15 PM, Nathan Maves wrote: > >> This is m bad. >> I will try and get to this tonight. I know clinton ju

Re: 3.0 Beta 3 is not in maven repository. Please add the beta to the repository.

2009-10-07 Thread Nathan Maves
This is m bad. I will try and get to this tonight. I know clinton just made a few more changes so there might be a beta 4. I might just wait for that one to go if we are close. Nathan On Wed, Oct 7, 2009 at 2:33 PM, Paul Spencer wrote: > Yes, I can upload the Beta to my local repository and t

Re: Query List limitation

2009-09-09 Thread Nathan Maves
Again you provide us with no data to help you. Post your java code including the mapper class and and xml mappings that you have.Also any errors that you are seeing. We cannot help you if you don't help us :) Nathan On Tue, Sep 8, 2009 at 11:23 PM, faresz wrote: > > I have no error messages

Re: IBatis + Stored Procedures

2009-09-08 Thread Nathan Maves
any chance you also have the logging output where the sql generated by ibatis? On Tue, Sep 8, 2009 at 8:36 AM, jimmymac wrote: > > It's choking on the lastname value being read off a magnetic strip. Here is > the relevant portion of the map > Here is the parameter map: > id="SwipedCreditCard_pr

Re: IBatis + Stored Procedures

2009-09-08 Thread Nathan Maves
Post your parameter map and the actual exception you are getting. On Tue, Sep 8, 2009 at 7:59 AM, jimmymac wrote: > > I seem to be having an issue with mapping and stored procedures. I'm > passing > in a value " O'Malley ". Shouldn't the use of a prepared statement handle > the apostrophe? The A

Re: Problem substituting inline parameter value in alter table statement

2009-08-25 Thread Nathan Maves
you need to use the string substitution option. $value$ nathan On Tue, Aug 25, 2009 at 4:15 PM, Evan McQuinn wrote: > Hello - > > I'm trying to run an alter table command to swap partitions in a large > Oracle table. I haven't found any documentation regarding alter table in > iBatis specifical

Re: Newbie question: Update table that has no key / id

2009-08-25 Thread Nathan Maves
Now is the time to turn on logging and see just what sql is being produced. set java.sql=DEBUG in your logging configuration. On Tue, Aug 25, 2009 at 12:29 PM, Anoop kumar V wrote: > Hi Rick, > > yes that was one of the typos in my earlier email, but I have corrected > that among other stuff (

Re: Newbie question: Update table that has no key / id

2009-08-25 Thread Nathan Maves
Anoop, What you are getting is a SQL exception. This means that ibatis has already done its job. I would guess that your issue is with the reuse of the word "set" before the region_name column. nathan On Tue, Aug 25, 2009 at 9:40 AM, Anoop kumar V wrote: > Hi Larry, > > Was wondering if you c

Re: Returning child class as base class

2009-08-19 Thread Nathan Maves
Check out the discriminator tag on page 38 of the new ibatis 3.0 user guide. On Wed, Aug 19, 2009 at 1:08 PM, wrote: > I am wondering if there is a way to use iBatis to perform a query that > will return multiple child classes as the base class. Here is a simplified > example of the situation:

Re: Request for input on porting iBatis XML from 2.x to 3.0

2009-08-18 Thread Nathan Maves
We actually already started the talks on how to automate this. We did this for the last major upgrade and it was a huge help. Thanks again for your notes. On Tue, Aug 18, 2009 at 3:49 PM, Larry Meadors wrote: > Thanks for sharing! > > You rock. > > Larry > > > On Tue, Aug 18, 2009 at 3:20 PM, Jo

Re: not known to the MapperRegistry with iBatis 3.0

2009-08-18 Thread Nathan Maves
Richard, I took a quick look at your example code. I also took a look at the source and I think I see your issue. You are trying to use a java only Mapper class. This works but right now the MapperRegistry getMapper method only looks though a collection of mappers. So for now you will need to r

[NEWS] iBATIS 3 for Java BETA *2* Released

2009-08-18 Thread Nathan Maves
I have posted the latest beta-2 release to the maven2 repositories. Let me know if anyone encounters any issues with them. Nathan On Mon, Aug 17, 2009 at 10:08 PM, Clinton Begin wrote: > Hi all, > > The mirrors have updated and iBATIS 3 Beta 2 is now ready to roll. > All known issues submitted i

Re: iBatis change to 1.5

2009-08-17 Thread Nathan Maves
Trenton, Thanks for the input. As a team we felt that given the fact that Java 5 came out in 2004 we gave the community ample time to upgrade :) The added features and performance gains were enough for us to jump. I think the right move for us was a minor release increment. In fact J2SE 5.

Re: updated iBatis In Action book?

2009-08-17 Thread Nathan Maves
you must be kidding. I have to work with those two everyday... jk love you guys! on a serious note I have some ibatis in action books for sale, get them before they get outdated On Wed, Aug 12, 2009 at 9:00 PM, Clinton Begin wrote: > LOL Nice Larry. :-) > > No, you can expect free docu

Re: Who wants to write JPetStore 6 (or any other example)?

2009-08-13 Thread Nathan Maves
gt;> spring and springmvc was the 'path of least resistance' for me to >>>> take care >>>> >> of this in the shortest amount of time. >>>> >> >>>> >> I contribute to a few other projects and would rather contribute to >>>>

Re: Who wants to write JPetStore 6 (or any other example)?

2009-08-13 Thread Nathan Maves
My vote is guice(DI) with stripes as the controller and jQuery UI for the front end. On Thu, Aug 13, 2009 at 2:25 PM, Steven A wrote: > I'm not really opposed to wicket, but springmvc is just what I have been > working with for the past 2 years when I've done web work, so obviously I'm > more c

iBATIS 3 for Java Released (BETA 1)

2009-08-08 Thread Nathan Maves
A month ago iBATIS turned 7 years old, and while we're celebrating a little late, today we're happy to announce iBATIS 3 for Java. iBATIS 3 is a complete rewrite from the ground up and thus represents the biggest change since the very first version of iBATIS released in 2002. There are a lot of mod

Re: any way to use wildcards in sqlMapConfig file?

2009-07-13 Thread Nathan Maves
This sounds like a reasonable request. I love more convention over configuration, even if it is just less configuration. Wonder if we can get it into IB 3. Might want to submit a ticket so it does not get lost. Nathan On Sat, Jul 11, 2009 at 6:09 AM, Marco Musu wrote: > Hi everyone, > it is po

Re: SimpleDataSource type a house-of-cards?

2009-06-14 Thread Nathan Maves
DBCP from apache is perfectly fine for a DB connection pool. In fact any production pool will work with ibatis. I cannot think of an application server which does not have its own connection pool implementation. Most are very configurable and will work for you. Nathan On Sun, Jun 14, 2009 at 4:

Re: error handling in iBatis?

2009-05-11 Thread Nathan Maves
You can see from the java docs that each method does infact throw a SqlException. http://ibatis.apache.org/docs/java/user/com/ibatis/sqlmap/client/SqlMapExecutor.html You need to be prepared to catch them if you care to do anything with them. Nathan On Mon, May 11, 2009 at 9:26 AM, Bhaarat Sharm

Re: How to test Pool.PingQuery with Simple Datasource

2009-05-06 Thread Nathan Maves
based on the source located here http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-2/ibatis-2-core/src/com/ibatis/common/jdbc/SimpleDataSource.java private boolean pingConnection(SimplePooledConnection conn) { boolean result = true; try { result = !conn.getRealConnection(

Re: Oracle v$session and iBatis

2009-04-29 Thread Nathan Maves
wow I could take this places, but this is a public list :) On Wed, Apr 29, 2009 at 10:34 AM, Larry Meadors wrote: > On Wed, Apr 29, 2009 at 9:20 AM, Clinton Begin > wrote: > > Larry's cheaper though, if you want to hire him. ;-) > > Not much, but I am more fun to be around. :-D > > Larry >

Re: newbie trouble grokking error message

2009-04-29 Thread Nathan Maves
This really does look like a mapping issue. Please include the source code of the bean and the map that you are using. On Wed, Apr 29, 2009 at 7:31 AM, Sean Mitchell wrote: > On Tue, Apr 28, 2009 at 5:52 PM, Nathan Maves > wrote: > > > Welcome to ibatis! > > Thanks... it

Re: Custom vendor specific Queries

2009-04-28 Thread Nathan Maves
There is nothing in ibatis that will do this. this people can usually be solved at build time by including the sqlmaps that you need to bundle with your app. On Sun, Apr 19, 2009 at 2:41 PM, Saloucious wrote: > > Hello, > > i would like to know if it is possible to create custom workaround quer

Re: Using #PARAM# constructions within $DYNAMICSQL$

2009-04-28 Thread Nathan Maves
I have not tried this but I don't see why it would not work. SELECT * FROM person WHERE person.lastname LIKE '%'||#lastname#||'%' the || is the concat operator for oracle. it might be something else in another vendor On Tue, Apr 28, 2009 at 4:24 PM, DelGurth wrote: > Hi, > > I was wondering

Re: What am I doing wrong: Ibatis vs JDBC insert

2009-04-28 Thread Nathan Maves
I love apples to oranges comparisons :) First off you are not using a connection pool in your jdbc example. Even though your ibatis code will be run synchronously you will still incur that overhead. I am guessing that you are trying to prove to someone that ibatis is just as fast as jdbc. If tha

Re: Looks like iBatis is processing data slowly...

2009-04-28 Thread Nathan Maves
Are the queries being run against the same database? Are the connection pools set up the same on both servers? Is your test(slower) server located somewhere else geographically? Maybe just provide us with a bit more data. On Mon, Apr 27, 2009 at 1:26 PM, Chris O'Connell < oconn...@gorillachicago

Re: newbie trouble grokking error message

2009-04-28 Thread Nathan Maves
Welcome to ibatis! Could you give us a little more information like what DB you are using? what driver? what does the sql look like? I can't say that I have seen your error before but I am sure we can figure out what this issue is. Nathan On Tue, Apr 28, 2009 at 1:45 PM, Sean Mitchell wrote:

Re: SubQuery

2009-04-16 Thread Nathan Maves
Start at the bottom of page 38 of the developers guide. You might even want to read the whole thing because it might show you a better way to achieve what you are looking for. Right now you have the makings of a n+1 problem. Nathan On Thu, Apr 16, 2009 at 2:35 PM, Aleksandr Elbakyan wrote: > He

Re: Some one can help me?

2009-04-14 Thread Nathan Maves
Look up ping query in the developers manual. It will validate the query before it uses it. On Apr 14, 2009, at 8:27 PM, "yhliu" wrote: I got a problem that the program will throw close connection exception when the DB server(oracle 10G) shut down and it is unforeseeable, the worse is i

Re:

2009-04-13 Thread Nathan Maves
oh right this "feature" was made for the times when you have a nullable column in a DB, and for some strange reason, you only have a non-nullable java type like a primitive int. On Mon, Apr 13, 2009 at 7:59 PM, Larry Meadors wrote: > Null value replacement makes my head hurt. > > It bit me, beca

Re:

2009-04-13 Thread Nathan Maves
can you turn on logging to see what values ibatis is sending to the insert? On Mon, Apr 13, 2009 at 5:49 PM, Gavin McLeod wrote: > I have the following: > > > insert into thing (thing_id, animal, mineral, vegetable) > values ( > #thingId#, > #animal:BOOLEAN:False#, > #miner

Re: nested ArrayLists

2009-04-07 Thread Nathan Maves
You will have to do this programatically and it is a classic n+1 problem. I would suggest that you write a 3rd stored proc or query that returns the people + there address. Once that is done you can use the group by feature of ibatis to fill the nested properties. On Tue, Apr 7, 2009 at 4:10 PM,

Re: Can I use Set instead of List?

2009-04-07 Thread Nathan Maves
I took this one step further ArrayList list = new ArrayList(); list.add(1); list.add(1); list.add(2); list.add(3); HashSet set = new HashSet(); set.addAll(list); System.out.println(list.size()); System.out.println(set.size()); output: 4 3 So java will remove all duplicates that it finds. On

Re: Can I use Set instead of List?

2009-04-06 Thread Nathan Maves
This is a fundamental java issue. You will never be able to cast a list to a set because a list allows duplicates whereas a set dose not. There is no way for java to know which of the duplicate elements it should use. If you guarantee that you have unique result from your DB(i.e. use the unique

Re: Idle Threads - Glassfish/DB2

2009-04-03 Thread Nathan Maves
Jeff, Not to state the obvious but it does not seem like an ibatis issue. It sounds more like the connection pool implementation of Glassfish. As a test you might try creating your own connection pool using the SIMPLE datasource type in ibatis just to ensure that it is an issue with Glassfish. N

Re: DB connection Config in SqlMapConfig

2009-03-30 Thread Nathan Maves
The only way to get access to the pool that Vignette creates would be if they expose it as JNDI. I guess you could also extend ibatis to get a connection for the Vignette pool if you were in the same JVM. On Mon, Mar 30, 2009 at 1:17 PM, ramang wrote: > > Hi all, > Not sure if anyone have been a

Re: KeyProperty attribute in Selectkey Tag

2009-02-12 Thread Nathan Maves
ined in this e-mail is private & confidential and may also be legally privileged. If you are not the intended recipient, please notify us, preferably by e-mail, and do not read, copy or disclose the contents of this message to anyone. Nathan Maves nathan.ma...@gmail.com

Re: Multiple compareValue in isEqual?

2009-02-10 Thread Nathan Maves
"B". How do I do this? -- View this message in context: http://www.nabble.com/Multiple-compareValue-in-isEqual--tp8525246p21908490.html Sent from the iBATIS - Dev mailing list archive at Nabble.com. Nathan Maves nathan.ma...@gmail.com

Re: SQL-Map / CDATA Performance Issue

2009-02-01 Thread Nathan Maves
Please ensure you turn off all logging while running your tests. On Sun, Feb 1, 2009 at 6:56 AM, Kai Grabfelder wrote: > Hi, > > looks like the pdf in svn is outdated. Please use the open office source > instead > ( > http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-2/ibatis-2-docs/en/iBA

Re: Problem ORACLE 10G Select ?

2009-01-30 Thread Nathan Maves
you also should turn on logging and grab the sql that ib is generating and trying to run it from sqlplus On Fri, Jan 30, 2009 at 7:30 AM, Nathan Maves wrote: > can I assume that you are wanting to have more then one value submitted at > a later point? or will it always be 'ALL'

  1   2   3   4   5   >