Dear All,
Has anyone ever experienced problems with missing hours/minutes/seconds
in a date field (from oracle database)?
for example i have a query like this:
select id=select1 resultClass=java.util.HashMap
SELECT sysdate today, 'dummy' dummy_field1, 'dummy' dummy_field2
FROM dual
/Warning: rambling aside ahead:/ I remember the eye-opening I had in OS theory class when
we talked about IO-bound vs. processor-bound... and the fact that going to disk is often a
*thousand times slower* than getting something out of ram (microseconds vs. nanoseconds).
So, if the database
Hi
What is the best way to design java class for mapping,
for example suppose i have a SQL querry which join 2-3
tables and returns the data,
should i design java class to match this SQL querry,
or should i design java class to match tables, and
then create a Map in xml file and then populate
Hello Ashish,
Regarding a way to not have to create a java class for your result class, you
could very easily just set your resultClass to a java.util.HashMap. This will
be popultated for any results for the key being the name of the field being
returned and the value being the value.
As far
It is planned. But, it has not been implemented. I think there is a
JIRA issue on it. Feel free to cast a vote for it.
Brandon
On 3/1/06, Bryan Hunt [EMAIL PROTECTED] wrote:
Hi there,
I found a message on the serverside from 2004 indicating that
constructor based mapping was a planned
DISCLAIMER: I know that the address information should have been in a
different table but that is the reason that I need iBatis.
I would like to be able to define a column override like this. columnOverride column=ST property=address.state/If I do this it will generate the mappings and sql
Is the intended result:
1. A new domain object called Address
2. Address has a state property with getters/setters
3. An address property in the outer domain object with getters/setters
4. The outer object creates a new Address object in its constructor
Seems like a lot to infer from a column
I am having a problem inserting a date into a TIMESTAMP field. The field in
the database is exactly 8 hours ahead of the Date object I am inserting. My
insert statement is:
insert id=insertScanOrder parameterClass=scanOrder
INSERT INTO scanorder (clo1, col2, scn_date) values (#value1#,
You have a timezone problem. The date is being inserted in the GMT
timezone, but you are expecting it to be PST, 8 hrs behind. I'm not
familiar with PostgreSQL, maybe there's a default timezone setting or
default formatting that the postgres driver is doing.
-ed
On 3/1/06, Warren [EMAIL