Re: Javolution support?

Gary, I saw your post on the ibatis list and was wondering if I could talk to you a little about ZK.

Re: iBATIS v2.2.0 Beta

I'm in the same boat. While I'm waiting for them to release the final version into ibiblio however, I just installed the iBatis 2.2.0.xxx jars into my local repository. On 8/24/06, Carlos Cajina <[EMAIL PROTECTED]> wrote: Hi, good morning! Regarding the iBATIS release process discussed in th

Re: dynamic script's

Does this not depend on how Prepared Statements are implemented? As I recall, one of the big db's does them as a stored proc. In that light, multiple statements seems reasonable, but this sort of behavior (like most things) might not valid across all the dbs that one might consider. I guess the

Re: Unsubscribe?

Your question's been answered already on the list, but just as a point of reference, *IN GENRAL*, mailing lists provide a header in every mail about various administrative functions. Headers in these ibatis mails include: List-Help: List-Unsubscribe:

Re: java 1.5

ly cool stuff in your DAOs like: List getEmployees(); Larry On 8/20/06, Jeff Butler <[EMAIL PROTECTED]> wrote: > > No gotchas - it works fine. > > > Jeff Butler > > > > On 8/20/06, Michael Campbell <[EMAIL PROTECTED]> wrote: > > Are there any "

java 1.5

Are there any "gotchas" or anything special I need to do in order to having an app written in java 5 using the iBatis 2.1.7 jars from maven2/ibiblio?

Re: iBatis Subquery and Date error

Nathan Maves <[EMAIL PROTECTED]> writes: > Stick with java.sql.Date. Try never to use java.util.Date. Why? The Ibatis datamapper doc (2.0, page 31) says: "The use of java.sql.date types is discouraged. It is a best practice to use java.util.Date instead." I'm tending to go with the author o

Re: Cacheing rowless queries?

see them get cached yet (stay tuned). > > > Is this true? Parameterless queries like SELECT * FROM foo ORDER BY > bar can not be cached via cacheModel ? true. I think there is a jira issue already opened for this. -- Michael Campbell

Re: how can i get attribute from inbed object?

On 11/23/05, Alex Chew <[EMAIL PROTECTED]> wrote: > > > Do you mean there should have such a field like > private Long handlebyId; > and i should prepare the data? > It seems some strange. Yes, I misunderstood your initial question. My apologies. See below. > > > > > insert into ACCOUNT

Re: how can i get attribute from inbed object?

If "id" in your POJO isn't populated, you either need to let the database generate one for you or you provide a value. If you're letting the db do it for you, you don't include the id in your insert sql at all, but rather use the clause of the statement to get the db-generated id back to your PO

Re: Inserting Default values if object member is null

On 11/14/05, Larry Meadors <[EMAIL PROTECTED]> wrote: > Uhm, use a database default? Maybe. Don't all databases error on setting a non-nullable, defaulted column to null? (as opposed to not setting it at all).

Re: Reload SqlMap xml file

On 11/9/05, Paul Benedict <[EMAIL PROTECTED]> wrote: > I have the same problem. I've seen this requested before but I don't think > there is a solution. > > --- Ming Xue <[EMAIL PROTECTED]> wrote: > > > Hi > > > > I am using Spring with SqlMap, the sqlMapClient is configured as a Spring > > bean,

Re: Caching (please help)

On 11/5/05, Clinton Begin <[EMAIL PROTECTED]> wrote: > Yes, the cache should work for nested selects. But have you tried just > calling them directly to see if it might be a bug? > > Also, just for fun, try the LRU cache, instead of MEMORY. For more fun, try qualifying the cache name with any n

Re: Caching resultMap sub-selects

> too. I consider this a must have feature of iBATIS. > Better developer tools encourages greater use of the > product. > > Paul > > --- Michael Campbell <[EMAIL PROTECTED]> > wrote: > > > On 11/5/05, Paul Benedict <[EMAIL PROTECTED]> > > wrote: &

Re: Caching resultMap sub-selects

On 11/5/05, Paul Benedict <[EMAIL PROTECTED]> wrote: > While it is not clear, I think it is recommending to > add a cache to the getProductsByCatId method (not the > parent getCategoryResult). Is that correct? I have > many sub-selects and it makes sense to put the cache > there, the only problem

Re: paginated list

On 11/3/05, Zarar Siddiqi <[EMAIL PROTECTED]> wrote: > Woah. I was under the impression that internally it's doing what's optimal > by considering what database is being used. I noticed the "i believe" in > your post. Can you please confirm this? If so, do future releases of IBatis > plan on cons

Re: Bulk inserts

On 11/3/05, Paul Benedict <[EMAIL PROTECTED]> wrote: > Yes, > > SQL has a notation to INSERT multiple entries at once. > What you want to do is build a statement like the > following: > > INSERT INTO fruit (id, name) VALUES (0, 'Pear'), (1, > 'Apple'), (2, 'Peach') Is that standard ANSI SQL? I k

Re: Cache w/ Hierarchical ResultMaps

Just a general note here... not every tool is suitable for every project. iBatis solves a very LARGE set of needs, but it might be that it just doesn't solve THIS one (it might, but it's sounding like not...) Good luck in any case, and I wish I had a nifty solution for you. Out of curiosity, are

Re: Dynamic tables.

On 11/2/05, Larry Meadors <[EMAIL PROTECTED]> wrote: > On 11/2/05, Ben Munat <[EMAIL PROTECTED]> wrote: > > Larry Meadors wrote: > > > DDL != SQL :) > > > > > There may be other ways of defining a DDL, but to most people it means > > "create", "drop" > > and "alter", which are ANSI SQL. > > > > It

Re: enums & Ibatis

On 10/28/05, Nathan Maves <[EMAIL PROTECTED]> wrote: > I think this is just what you are looking for. > > http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do > +I+use+a+Custom+Type+Handler+with+complex+property+or+Type+Safe > +Enumeration Whew, for those not wanting to cut/paste

Re: best method to get SqlMapClient in web application

I'm using Spring's iBatis support for this. Fairly easy to set up and works very well. On 10/24/05, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: > Hello > What is the best way to get SqlMapClient in a web > application > 1 , Define a singleton pattern class, and create a > instance of SqlMapClient

Re: Cache keys...

Sorry, what I meant in my last mail is that I *SEE* a lot of gets, but they always return null. My logging shows the following sequence: get from cache, return null. get from db put to cache with key "X" ... time passes get from cache with key "Y" where, based on my usage, it should be using ke

Cache keys...

What does Ibatis use, and/or how does it construct a cache key?  I've put some logging into the cache layer, and I see all sorts of puts, but nary a get.  Not 1.  I'm wondering if there's something about my objects themselves that make them not-cacheable.-- I tend to view "truly flexible" by anothe

Re: No operations allowed after connection closed.

On 10/16/05, Sven Boden <[EMAIL PROTECTED]> wrote:> > If you're not yet using autoReconnect in the URL of your pool, can you> try using that. As in the following way: > >  jdbc:mysql://host/db_hame?autoReconnect=true> > Note the upper case R in autoReconnect (it's case sensitive).Your suggestion he

Cache models

Are cache-models namespaced? That is, if I define one in a namespaced SqlMap do I need to refer to it as ...cache-model="Namespace.modelname" ? Even from within the same config file? With no logging in the cache layer it's hard to see what's going on. =\ -- I tend to view "truly flexible" by a

Re: Getting connection from ibatis

I use a different context for unit tests and production. To do this, I'm using spring to configure the SqlMapClient, and just use a different spring config for each environment. While MINE isn't determined at runtime, it would be trivial to make it so. On 10/6/05, Agilan Palani <[EMAIL PROTECTED

Re: MS Access selectKey question

On 9/28/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Thanks for the replies guys. Sorry for the late response.. > The id property doesnt exist in the object im inserting, ... If this is the case, then your sql with " ... values (#id#, ..." won't work since by using "#id#", you're telling i

Re: MS Access selectKey question

On 9/28/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hey, > Im having some difficulties inserting rows into ms access. The error i get > is: > > ... > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in org/hisp/dhis/hmis/RoutineData.ibatis.xml. --- > T

Re: iBatis in a standalone (JUnit) application - NoInitialContext err or

On 9/27/05, Yee, Richard K, CTR,, DMDCWEST <[EMAIL PROTECTED]> wrote: > Hi, > I'm trying to use iBatis DAO in a standalone Java class but am getting a > JNDI NoInitialContext error when I try to configure the DaoManager. I am > using a SIMPLE datasource and am specifying the username, driver, etc.

Re: Passing logged in Username and password to iBATIS

On 9/27/05, Niels Beekman <[EMAIL PROTECTED]> wrote: > > You could try Proxool: > http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do+I+connect+using+a+user%27s+credentials > > > > I have never used it and it seems an inactive project, but you could try it… proxool is active, it

Re: BulkBean exception? SOLVED

With Clinton's help did some digging around, and found out I had some nulls in an integer column. iBATIS/CGLIB didn't like that so much. Lesson learned. On 9/26/05, Michael Campbell <[EMAIL PROTECTED]> wrote: > This look

BulkBean exception?

This look familiar to anyone? com.orange_blossom.common.exceptions.PersistenceException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in ibatis/Customer.xml. --- The error occurred while applying a result map. --- Check the Customer.customer-result. --- The error hap

Re: Problem upgrading 2.0.4 to 2.1.5

Guessing here, but it almost smells like a transaction timing issue. Are the sybase drivers the same for both iBATIS versions? (Or, I wonder if some code in 2.0.4 is synchronized and 2.1.5 is not?) As an aside, is there a reason you're not just doing an update vs. select/delete/insert? On 9/26/

Re: Caching; how do I know it's working?

> User.GetOneById: 20% > User.GetManyById: No cache. > ... > > Maybe this is a feature that the Java people would find useful. > > --- Michael Campbell <[EMAIL PROTECTED]> wrote: > > > Is a cache hit/miss logged? I've run a test of running the same > > select in

Caching; how do I know it's working?

Is a cache hit/miss logged? I've run a test of running the same select in a loop, and my ibatis log4j output shows n copies of the prepared statement, result set operations happening. Is the logging supposed to distinguish between a cache hit and a real db call? -- I tend to view "truly flexible

caching... per "select"?

Setting up caching in iBATIS seems frighteningly easy, so I'm anxious to try it. Can anyone give me any idea of what GETS cached; it seems to be per statement/select. Can I assume that when some class is listed in the parameterClass, that's part of the key? Is it the entire thing, or just the att

Single Table inheritance?

I've looked at the docs a bit and couldn't find anything like this so I suspect the answer is "no", but does ibatis have any facility for single table inheritance[1]? I'm putzing around a bit with Ruby on Rails and learned about this in its ActiveRecord persistence layer[2]. I've actually had a n

Hibernate integration

I've just started using ibatis and like it quite a lot. I've seen references here and there to hibernate integration and wondered exactly what that was. When using it, what of hibernate and what of ibatis do you actually use? -- I tend to view "truly flexible" by another term: "Make everything