If you are OK with using a map, using a rowhandler to generate the xml
will be very simple, and not measurably slower than the current
implementation.
Again, I think this is truly a better approach. Why?
It's fast, because it only goes through the returned results once.
It's very light weight b
Subject: Using non-default timezones
Hi!
I'm using iBatis to store and fetch dates and hourly timestamps in and
from an Oracle database.
An sql-map fragment is given below as example.
I need these dates and timestamps to be stored as their UTC values, but
when I insert a date using an iBatis ins
Hi ,
This mail is w.r.t multiple result sets returned from stored proc.
I am using ibatis in my persistence layer extensively, because of ibatis
doesn’t support multiple resultsets wherever my procedure returns one
resultsets I am using Ibatis but if my procedure returns multiple then I
am usi
On Mon, 5 Jun 2006, Mayeul MARGUET wrote:
Is there an official way to do it, which would save me the hassle of
modifying my default timezone or storing my dates and timestamps as
text?
Create a TimeZone for GMT and use that to create a Calendar instance.
That should help with the insertions.
iBATIS does not mess with your date values in any way that I am aware
of. What you pass in is what gets stored. If iBATIS is changing your
date values upon insertion then this would be a bug. So, it is your
responsibility to set the Date value on your object correctly prior to
asking iBATIS to ins
I actually do not think iBATIS is changing my date values. I think it (or
Oracle JDBC driver) formats dates with my default timezone when it needs to
format them, which is expectable as a Java common convention.
My problem here is I need to keep my default timezone unchanged, and I need to
stor
Not sure if this solution will work for you but here is what we use.
First off you need to know the TZ of your database. In most cases it
will be kept in GMT time. Then you will also have to know what the
users current TZ is.
At this point you can write something like
new_time(#dateP
Hi,I want to find out the easiest possible way to start a transaction, create a thread that performs DAO inserts, and still have the newly created thread honor the start and end transaction from the launching application.
I'm working on a project where I'm using iBatis DAO with SQLMAP as my transa
RowHandler will be OK in mapping results with no nested structure. But I'm
afraid that it cannot handle result with nested structure. Look the
following mapping I used for testing:
SELECT M.M_ID as MasterID, M.M_Name as MasterNam
