Re: Inheritanc

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

Re: 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, nitin.du...@sungard.com wrote: By default for batch

Re: SQLExecutor.addBatch() modified

2010-06-14 Thread Nathan Maves
/group/mybatis-user On Mon, Jun 14, 2010 at 9:10 AM, Nathan Maves nathan.ma...@gmail.com 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: Getting RunTime Exception

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

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

Re: Problem accessing List instance property via isnull

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 kmg...@googlemail.com 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

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

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 dmitry.s.mamo...@gmail.com wrote: Hi everyone! I'm trying to apply ibatis-migrations to manage our database schema and I

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

2010-04-13 Thread Nathan Maves
François On Apr 12, 2010, at 10:41 AM, Nathan Maves wrote: 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. MapString, Object  parameters = new HashMapString, Object(); parameters.put(someNumber

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. MapString, Object parameters = new HashMapString, Object(); parameters.put(someNumber, Integer.valueOf(123)); parameters.put(someString, hello); Now use that

Re: return simple String[] or ListString

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

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

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 joram.bar...@gmail.com wrote: Hi All, I was wondering if this is possible with iBatis

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 vinaya.tirikkovall...@converge.com wrote: Just resending it, as I got a failure notice Thanks Vinaya

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,

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 yuqian...@gmail.com wrote: ok. i have got it. thank you. but i want ask one question more. the root

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 kirankumar_vup...@yahoo.com wrote: Thanks. Is it freeware? From: shamim sre...@yandex.ru To:

[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 ListClient

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 mark.stev...@dtn.com wrote:

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 category name=java.sql priority value=debug / /category category name=org.ibatis priority value=debug / /category You can define them at a more granular level if you want. On Sun,

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 curious, why

Re: iBatis 3.0 minimal complete example

2010-02-10 Thread Nathan Maves
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
at Nabble.com. - To unsubscribe, 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

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

2010-01-28 Thread Nathan Maves
...@gmail.com Nathan Maves nathan.ma...@gmail.com

Re: Writing subqueries

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

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

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

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.

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

[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

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 insert id=myProc statementType=CALLABLE paramaterMap=someParameterMap {call TEST_SP(?,?)} /insert or with inline parameters insert id=myProc statementType=CALLABLE paramaterType=com.acme.Foo {call

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

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 nathan.ma...@gmail.com 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 On Sun

Re: How about a Netbeans integration plugin?

2010-01-02 Thread Nathan Maves
would still have to be Apache 2.0 licensed. Clinton On Sat, Jan 2, 2010 at 2:47 PM, Nathan Maves nathan.ma...@gmail.comwrote: 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 me know if you want to try it out

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 nos...@kaigrabfelder.de wrote: Hi there, some while ago I directed a student projects leading

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 stefatw...@gmail.com wrote: Hello, I have been using

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.

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

[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 jeremy.jar...@gmail.comwrote: 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,

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.

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 eodn...@yahoo.com wrote: Is there a sample application written in ibatis 3 and spring such as petstore? thanks

[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

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: 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 gfranc...@gmail.comwrote: I've tried to find the doco for this, but havent so far. In iBatis, if I use queryForMap(), the resulting Map ordering

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

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 fadis...@yahoo.com wrote: Hello Assume that you have collection property actors in a mapped class Movie and your code works fine this way: Movie.java: ... protected ListArtist actors; ... But I need to declare this property as:

[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

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

2009-10-08 Thread Nathan Maves
isn't in Maven either. Clinton On Wed, Oct 7, 2009 at 4:15 PM, Nathan Maves nathan.ma...@gmail.comwrote: 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

Re: Performance retrieving list of strings.

2009-10-08 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

Re: Problem when parsing dao.xml

2009-10-08 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 larry.mead...@gmail.comwrote: 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. ;-)

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 pau...@apache.org wrote: Yes, I can upload the Beta to my local

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 anoopkum...@gmail.comwrote: Hi Larry, Was

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 anoopkum...@gmail.comwrote: Hi Rick, yes that was one of the typos in my earlier email, but I have corrected that

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 evan.mcqu...@noaa.gov 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

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, scott.smi...@l-3com.com 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

[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 clinton.be...@gmail.comwrote: Hi all, The mirrors have updated and iBATIS 3 Beta 2 is now ready to roll. All

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

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 larry.mead...@gmail.comwrote: Thanks for sharing! You rock. Larry On Tue, Aug 18,

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 clinton.be...@gmail.comwrote: LOL Nice Larry. :-) No, you

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

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

2009-08-13 Thread Nathan Maves
, Aug 13, 2009 at 2:24 PM, Warren Bell warrenbe...@gmail.com wrote: Stripes? Is it popularity or simplicity? Warren Kai Grabfelder wrote: I would rather go for Stripes + Spring ;-) --- Original Nachricht --- Absender: Nathan Maves Datum: 13.08.2009 22:54 My vote

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

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 musm...@gmail.com wrote: Hi

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

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

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 =

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 select map that you are using. On Wed, Apr 29, 2009 at 7:31 AM, Sean Mitchell s...@mitchwood.com wrote: On Tue, Apr 28, 2009 at 5:52 PM, Nathan Maves nathan.ma...@gmail.com wrote: Welcome

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

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

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

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 delgu...@gmail.com wrote: Hi,

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 salouci...@gmail.com wrote: Hello, i would like to know if it is possible to create

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

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 yh...@cn.ufinity.com wrote: I got a problem that the program will throw close connection exception when the DB server(oracle 10G) shut down and it is

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 mister.mccl...@gmail.comwrote: I have the following: insert id=insert parameterClass=domain.Thing insert into thing (thing_id, animal, mineral, vegetable) values (

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 larry.mead...@gmail.comwrote: Null value replacement makes my head

Re: Can I use Set instead of List?

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

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

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 raman.gudime...@sdgc.com wrote: Hi all, Not sure

Re: KeyProperty attribute in Selectkey Tag

2009-02-12 Thread Nathan Maves
, 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
for both A and 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 nos...@kaigrabfelder.dewrote: Hi, looks like the pdf in svn is outdated. Please use the open office source instead (

Re: Using iBatis outside servlet container

2009-01-30 Thread Nathan Maves
There is nothing in the IB library that is tied to a servlet container. You can use any of the various datasources from IB. c3p0 is just another DB connection pool so use it just as you would dbcp or the built in SIMPLE db connection pool. Nathan On Fri, Jan 30, 2009 at 5:14 AM, charlie bird

Re: Problem ORACLE 10G Select ?

2009-01-30 Thread Nathan Maves
Along larry's point I would expect that your value for $types$ looks something like 'test','me','out' make sure you have your single quotes around your data and no extra commas :) or post your code! nathan On Fri, Jan 30, 2009 at 7:24 AM, Larry Meadors larry.mead...@gmail.comwrote: What's

Re: Problem ORACLE 10G Select ?

2009-01-30 Thread Nathan Maves
can I assume that you are wanting to have more then one value submitted at a later point? or will it always be 'ALL' On Fri, Jan 30, 2009 at 7:26 AM, lucy.x.came...@jpmorgan.com wrote: Thankyou :) ..the string 'ALL' Larry Meadors larry.mead...@gm

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 nathan.ma...@gmail.comwrote: can I assume that you are wanting to have more then one value submitted at a later point? or will it always

Re: Adding Tables To From Clause and Corresponding Entries To Where Clause

2009-01-27 Thread Nathan Maves
Try reading the developer's guide pdf. It will put you on the right track when you get to the dynamic sql section. Nathan On Mon, Jan 26, 2009 at 5:26 PM, John Bz john1...@inbox.com wrote: Hi, I'm new to iBatis and am trying to figure out the best way to dynamically build a query that

Re: SimplePooledConnection Exception

2009-01-26 Thread Nathan Maves
Sounds like you need to use a validation query to ensure your connections are not stale. On Sun, Jan 25, 2009 at 10:06 AM, Zsolt Koppany zkoppanyl...@intland.comwrote: Hi, after getting the Exception below I get lot of database related Exceptions. What happens if ibatis finds an invalid

Re: [SURVEY] How many connections are in your pool?

2009-01-20 Thread Nathan Maves
I am no expert in this either but a default setup for oracle allows for 200 connections. At least this was the case a few version back. In my mind I think you can an maybe should have more connections than processors. Depending on the length of time the connection is open and idle. Again I

Re: ibatis db pool or dbcp

2009-01-19 Thread Nathan Maves
both are production quality dbcp is a more configurable but requires a 3rd party lib On Mon, Jan 19, 2009 at 8:45 AM, Rick ric...@gmail.com wrote: On Sun, Jan 18, 2009 at 2:22 PM, Zsolt Koppany zkoppanyl...@intland.com wrote: Hi, which database pool is recommended for production usage?

Re: Problem having persistence code with ibatis as a complete stand-alone jar with Spring and still use spring in web tier

2009-01-08 Thread Nathan Maves
I have done something like this before. I ended up having a spring config bundled in the jar file. In your webapp/ear that you are including the jar in I configured spring to use multiple config files. have you tried that? On Thu, Jan 8, 2009 at 10:26 PM, Rick ric...@gmail.com wrote: This is

Re: Using ibatis in a standalone jar with Spring, and also using spring in web tier

2009-01-08 Thread Nathan Maves
If all you need is DI check out guice. On Thu, Jan 8, 2009 at 10:49 PM, Rick ric...@gmail.com wrote: Sheesh look at this article... http://springtips.blogspot.com/2007/09/using-shared-context-from-ejbs.html it gives me a headache. How the heck can anyone justify using Spring if you need to

Re: R: insert statement

2008-12-24 Thread Nathan Maves
I am not sure why people continue to do this why not insert into some_table ( id, state, date ) values ( #id:NUMERIC#, #state:VARCHAR#, #date:DATE# ) This way it will insert the right data every time. If the value is null you get a null in the DB. I think you are only going to

Re: Wrong sorting when using orderBy clause

2008-12-15 Thread Nathan Maves
you have yet to give us your complete SQL for this select. That might really help us to help you :) On Dec 15, 2008, at 12:40 PM, Corrado Alesso wrote: In data 15 dicembre 2008 alle ore 20:29:29, Larry Meadors larry.mead...@gmail.com ha scritto: You may have said this already, I took a

Re: Wrong sorting when using orderBy clause

2008-12-14 Thread Nathan Maves
What is the result class? I have a feeling that you might be trying to user a map which by default insertion order it not retained. On Sun, Dec 14, 2008 at 7:33 AM, Corrado Alesso co.ale...@fastwebnet.it wrote: Hello everyone, I'm facing a problem with iBatis. I guess this is a known problem,

Cache no flushing on execute

2008-11-26 Thread Nathan Maves
Given the following cache model : cacheModel id=ProductsCache type=MEMORY flushInterval minutes=30/ .. flushOnExecute statement=Products.saveOclcNeedsUpdate/ property name=reference-type value=WEAK/ /cacheModel

  1   2   3   4   >