Re: [VOTE] Should iBATIS support SQLJ?

-1 On Fri, Jan 23, 2009 at 2:05 PM, Clinton Begin wrote: > Hi everyone, > > A group of developers have approached us with a contribution of code > to patch iBATIS so that it supports SQLJ. > > If you've never heard of SQLJ, here are two links... > > http://en.wikipedia.org/wiki/SQLJ > http://www.

Re: GroupBy issues (multiple child lists, Postgres limit/offset)

y that ORMs do this is with two queries... > >> > >> select distinct P.ID from PERSON P, DEPARTMENT D LIMIT 100 > >> > >> select * from PERSON P, DEPARTMENT D . and P.ID in (23, 45, 63, > > >> 104) > >> > >> iBATIS canno

Fwd: GroupBy issues (multiple child lists, Postgres limit/offset)

Anybody have any feedback on this? Thanks Reuben -- Forwarded message -- From: Reuben Firmin <[EMAIL PROTECTED]> Date: Tue, Sep 2, 2008 at 11:26 AM Subject: GroupBy issues (multiple child lists, Postgres limit/offset) To: user-java@ibatis.apache.org We are trying to r

GroupBy issues (multiple child lists, Postgres limit/offset)

entity meaning if we do cross product queries with groupBy. Is there any way that people have found around this? Thanks for any advice, Reuben

Manual for Ibatis

I'm looking for the Ibatis Manual, the PDF which used to be linked to from the site. The documentation section on the site is broken: http://ibatis.apache.org/javadownloads.html -- I assume that's where it should be? Thanks Reuben

"Connection already closed"

I'm using Ibatis 2.3.1. I've recently started getting this error; any ideas on how to debug? java.sql.SQLException: Already closed. org.apache.commons.dbcp.PoolableConnection:84 close org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper:181 close org.springframework.jdbc.datasource

Enum handling problem with subquery / list

didn't result in the TypeHandler's methods being called either, which leads me to suspect that the issue is something to do with there being a list of results. Any ideas on further debugging that I can do, and/or a solution? (I realize that 2.3.1 may solve this, but I can't use it until it's non-beta.) Thanks! Reuben

cannot write to property without a setter

Let's say I have a class structure as per below. Ibatis doesl not seem to let me address the path foo.bah.someProperty, because there is no setter (Foo#setBah). Specifically, I get "com.ibatis.common.beans.ProbeException: There is no WRITEABLE property". Spring, on the other hand, is fine with t

RE: Problem addressing list index in a parameter declaration

iness design changes in using a list. Thanks Reuben -Original Message- From: Daniel Pitts [mailto:[EMAIL PROTECTED] Sent: Monday, October 30, 2006 1:25 PM To: user-java@ibatis.apache.org Subject: RE: Problem addressing list index in a parameter declaration Looks like a problem with

Problem addressing list index in a parameter declaration

ser.java:63) [15:36:42.468] at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:51) What's wrong with my code? Thanks! Reuben

non-code way to read properties from jndi?

The sqlmap config has a attribute, which can be used to load common properties. Is there a way I can configure this to point at a jndi key?   Alternatively, where does the properties object get built out in the sqlmap object tree, so that I can push values in from jndi?   Thanks Reuben

modal typehandler?

Is there a way I can construct a type handler in different modes?   My specific need is this:   The iSeries folks like to give me back dates as integers, e.g. 20061004. They also give me back times as integers, e.g. 1203. Writing a type handler that copes with this is no big deal, but it w

RE: sproc call / long / empty value

PROTECTED]> wrote: Those crazy iSeries nuts...don't they curse at you for calling it an AS/400?Anyway, I guess I'd try 0, but if that's a valid value (i.e., not the same as "empty" or "null"), then I'd try it as a String. Larry

RE: sproc call / long / empty value

f Of Larry MeadorsSent: Monday, August 14, 2006 11:51 AMTo: user-java@ibatis.apache.orgSubject: Re: sproc call / long / empty valueI am confused..what is an "empty" number?Larry On 8/14/06, Reuben Firmin <[EMAIL PROTECTED] > wrote: How do I

sproc call / long / empty value

stParams" class="map">     />       javaType="java.lang.Long" mode="IN"/> ...     If I call the sproc directly in the IBM query tool, I can do:   call TEST3SQL(4, "", ?, ?)   Should I just tell Ibatis that it is a string field, and pass "", or is there a better way?   Thanks Reuben

checking that a statement exists

; for (StatementName statement: StatementName.values()) { if (!sqlMap.statementExists(statement)) { throw ProgrammerErrorException()  } }   ...   sqlMap.queryForList(StatementName.GET_FOO, ...)   Thanks Reuben

Re: Problem with dynamic query.

http://issues.apache.org/jira/browse/IBATIS-238, in case anybody else wishes to vote on it. :) Niels Beekman wrote: You cannot use an iterated property in the decision tags. I believe there is a JIRA issue for this. --> not allowed Niels -Original Message- From: Daniel Pitts [mailt

Transactions across multiple datasources / Resin

p, though, I'd appreciate it. Thanks Reuben

Re: Flushing caches

f you look at the caching code, caching is on the "level of the query/ResultSet", if you have iBATIS e.g. return 2 lists of objects, it may be well be that what for you is 1 and the same object may be cached twice (once in every list). Object identity is a concept that doesn't mix

Re: Flushing caches

I've been wondering about a related question -- is there any way to flush a cache for only one particular object? I'd like to be able to say "I've only modified this Foo bean, so flush it, but keep the other Foo beans that are in the cache". Are there problems associated with this that I'm mis

Re: Resources

If you use this Spring class, you can get resources from jars... * @param resource e.g. "classpath:your/package/here/Blah.xml"     public static Resource getClasspathResource(String resource) {     PathMatchingResourcePatternResolver res = new PathMatchingResourcePatternResolver();

Numeric overflow

Hello, I'm getting a numeric overflow from a create statement, when it attempts to map the auto-generated identity key to a bean value. The bean value is an integer, which I will certainly change to long, but I'm curious as to how this could happen. We've been testing the application for approx

Re: How to define not equal (<>) in SQL statement

Use the CDATA construct, e.g.: Ashish Kulkarni wrote: Hi I have a SQL statement as below, how do i define it in xml select * from mytable where mytest <> ' ' When i define it in xml file i get following error The content beginning "<>" is not legal markup. Perhaps the ">" (e;) cha

Re: (tangent) Cache w/ Hierarchical ResultMaps

Paul Benedict wrote: I am in the same situation (see my posts about my Fruit object). I am curious about how you feel about needing to list out, if you do, all your columns for those 4 objects to retrieve a Vendor. This assumes you're not doing 4 selects, but one select using joins. Hi Paul,

Re: Lazy loader throwing NPE

ling: SqlMapClient smc = SqlMapClientBuilder.buildSqlMapClient(new InputStreamReader( leads to a txManager never being initted on SQLMapExecutorDelegate. Is there another call that I'm supposed to be making? Thanks Reuben Geoff Chiang wrote: Can you post your Spring configuration for the rel

Re: multiple selectKeys in same transaction; wrong value coming out

Sybase, unfortunately, not MSSQL. I took out the batch from the transaction, and everything now works. I don't understand why it made a difference (the selectKeys were *not* in the same batch, just in the same transaction) but oh well. Larry Meadors wrote: Can you try this using scope_id