using system properties to configure sql-map-config.xml

2009-01-28 Thread loctorp
hello everybody; We have a situation where we need a map as follows: select id=getTableNames parameterClass=dataspace resultClass=java.lang.String show tables from ${DATABASE}$ LIKE %$tableName$%; /select right now we set the property {DATABASE} in a property file that is

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

2009-01-28 Thread John Bz
Hi, I have read the section on dynamic sql, but can't see how to do what I'm trying to do exactly. It looks like I will need 2 separate iterator tags (one for the from clause and one for the to clause) so I assume that means iBatis would be iterating my list twice to build the query. The

Mutiple resultset in select - how to

2009-01-28 Thread Jasmin Mehta
Hi, I have two tables for which I would like to run one select query by joining them thru primary keys but would like to use two separate Value Objects to store them. That requires to have more than one 'resultMap' attribute in select tag. Is it possible? I am using iBATIS 2.3.0. Here is code

XSL transformation

2009-01-28 Thread Trenton D. Adams
Hi Everyone, I'm not sure if this is useful for you or not. But, I created an XSL file to transform iBatis configurations into beans and SQL fragments into full SQL output. I have attached an example. It is helpful to open the xml file in your browser, as the XSL file will automatically

Sybase. Another interesting date issue using jconnect vs jtds

2009-01-28 Thread Rick
Maybe I'm setting things up wrong, but when I try to insert or update using java.util.Date the very last digit on the long of this datetime (date.getTime()) will be 1 fraction of second greater after either it's entered into the db or on the way out (I haven't investigated if it's on the way or n

Re: XSL transformation

2009-01-28 Thread Jeff Stahl
Doesn't matter if it's actually useful for anybody or not. Nice!! Jeff Stahl Trenton D. Adams wrote: Hi Everyone, I'm not sure if this is useful for you or not. But, I created an XSL file to transform iBatis configurations into beans and SQL fragments into full SQL output. I have

Re: Sybase. Another interesting date issue using jconnect vs jtds

2009-01-28 Thread Rick
Crap, now I seem to be having the issue with the jtds driver also. Maybe I just get lucky sometimes and the dates just work. Most of the time the time is off by a fraction of a second: These two times should match 01/28/09 03:29:16 PM INFO

Re: Sybase. Another interesting date issue using jconnect vs jtds

2009-01-28 Thread Rick
OMG please DELETE THREAD DELETE THREAD RICK IS A MORON. RICK IS A MORON. IGNORE IGNORE IGNORE:) On Wed, Jan 28, 2009 at 3:38 PM, Rick ric...@gmail.com wrote: Crap, now I seem to be having the issue with the jtds driver also. Maybe I just get lucky sometimes and the dates just work. Most of

Re: Sybase. Another interesting date issue using jconnect vs jtds

2009-01-28 Thread Rick
Ok, although I was a moron since I wasn't passing the date to my DAO and instead was having it create a date to pass in, even when fixed I'm still having a fraction of a second off: Date today = new Date(); log.info(Today time: + today.getTime() );

Re: XSL transformation

2009-01-28 Thread Trenton D. Adams
I figured at least someone might find it useful. I know I HATE putting SQL into Java strings, and trying to copy/paste that out into an SQL tool. And, iBatis isn't any better (for the copy/paste problem) if you do use fragments. And, I can't do without fragments (LOL), so I figured it's nice

Re: Sybase. Another interesting date issue using jconnect vs jtds

2009-01-28 Thread Larry Meadors
On Wed, Jan 28, 2009 at 1:43 PM, Rick ric...@gmail.com wrote: RICK IS A MORON. RICK IS A MORON. We've been aware of this issue for some time now Rick. The first step is admitting you have a problem. :-) Larry

looking for two ibator plugins

2009-01-28 Thread Jeya Balaji
hi , Are these plugins available : * table relationship Ibator to generate additional code to address foreign key relationship * gwt rpc code Had anyone attempted to generate extra client code for gwt projects? I am new to ibatis world and thinking about writing these plugins; just wanted to

iBATIS 2.3.4 (latest version)

2009-01-28 Thread Avitzur Alon
Hi, I am thinking of using iBATIS in my application in order to access the DB. I have two questions: 1. Does this version support JDK 1.6? 2. Does iBATIS can work with TimesTen in memory DB? Thanks in advance, Alon

Re: iBATIS 2.3.4 (latest version)

2009-01-28 Thread Jan Kriesten
Hi, 1. Does this version support JDK 1.6? it runs without problems under 1.6. 2. Does iBATIS can work with TimesTen in memory DB? If there's a JDBC driver for TimesTen then yes. Regards, --- Jan.

Re: iBATIS 2.3.4 (latest version)

2009-01-28 Thread Nicholoz Koka Kiknadze
I have used it with TimesTen 6 / 7 with JDK6. Had no iBatis related problems. On Thu, Jan 29, 2009 at 1:39 AM, Avitzur Alon alon.avit...@comverse.comwrote: Hi, I am thinking of using iBATIS in my application in order to access the DB. I have two questions: 1. Does this version support