hi, is there articles that compare the orm mappers out
there for mapping performance? i.e. after i get a
query result how long does it take to generate the
object, and what if the resultset is like a million of
records
thanks
__
Do You Yahoo!?
Tire
There are 2 things here that jump out as bad ideas:
1) Using M$ Access for *anything* Java-related
2) Hijacking another thread and adding your questions to it
So, I would suggest you get either MySQL or PostregreSQL or...well,
almost ANYTHING would be a better choice than Access (except for may
I am very new to struts and ibatis. I am trying to develop a very small
application. I just have jsp
Page (application is developed using struts) which has textbox, which
gets the id. I want to put the value in the variable id into the
microsoft access database using ibatis. That's all.
I have
Hello, regarding my last question, let me simplify this question:
I have a resultMap that contains another select statement that populates
one of the column,
If the resultMap contains 10 column, which 2 of them contains another
select statement, then this is what happens:
- if i map the res
Dear Niels,
Thanks for your warm-heared and helpful reply, I will try it.
Thanks again.
Steven
On 2/9/06, Niels Beekman <[EMAIL PROTECTED]> wrote:
Hi,I'm not sure I understand your question, but the -tag supports (amongst others) all Collection implementations (so ArrayList is supported) and
Hi,
I'm not sure I understand your question, but the -tag supports
(amongst others) all Collection implementations (so ArrayList is supported) and
arrays. You do not have to change anything in your first query to make it work.
The []-syntax is there to let iBATIS know it should retrieve propert
I have done it with SQL itself using DECODE function in oracle, but curious
of whether this can be done through iBATIS
Thanks
Vijai
- Original Message -
From: "VIJAISENTHIL, P. K." <[EMAIL PROTECTED]>
To:
Sent: Wednesday, February 08, 2006 1:51 PM
Subject: Re: pass a result (a String)
Yea, that would different as in my example, bcos the assessment would be
associated with a subject.
The constraint is, based on the scoring level of the assessment
either i need to score a subject directly
or the outcomes of the subject.
Hope you got me.
Thanks
-Vijai
- Orig
Hi Vijai,
I have a question about your question: Will Assessments.ID be the
same as Scores.subject_id and Subject.parent_subject_id?
They are different in your example (12 and 13), but I was wondering if
that was a typo.
Thanks,
Ted
On 08/02/06, VIJAISENTHIL, P. K. <[EMAIL PROTECTED]> wrote:
Hi,
I have a situation like, I
need to pass a result (a String) of a query to another SQL as
parameter.
E.g. like this.
SELECT SCORING_LEVEL FROM ASSESSMENTS WHERE ID =
12;
IF
SCORING_LEVEL="THIS"
SELECT SUBJECT, MARK FROM SCORES WHERE
SUBJECT_I
Hi Zoran,
Try moving the status criteria for UserCats to the LEFT OUTER JOIN
instead of the WHERE:
SELECT *
FROM Users as U LEFT OUTER JOIN
UserCat as UC on U.user_id = UC.user_id AND UC.status = 1
WHERE U.status = 1
Keeping UC.status in the WHERE clause would filter records from
Dear all,
I know "iterate" is of java.util.List, so I have to initial the length for the array in Java. Generally it use brackets[].
(#fruits[].id#, #fruits[].name#)
Now I need insert some data, and the length is not fixed. So can I use the arraylist to replace list? Writing like this:
I'm looking for a tip:
I need to launch a b2b system for my customer and connect to its database. The
customer has about 100 partners and each of those may have a few managers
working with these data. How do I develop a strategy for database and cache
tuning so that the office db load decreases?
This is what I tried first but it threw an SQL error.
Z.
> I think you can use a sub query so
>
> SELECT * FROM Users as U
> left outer join ( Select FROM UserCat WHERE status = 1 ) UC on U.user_id =
> UC.user_id
> WHERE U.status = 1
>
> Steve
>
>
> This e-mail and any attachment is for au
I tried that but that's not what I need.
If I had three users (U1, U2, U3).
And their status = 1.
They each have three children UserCats U1C1, U1C2, U1C3, U2 C1, U2C2 , ...,
U3C3
All of U1 usercats have status = 1, U2 has 1 usercat status = 1 and U3 has
none,
I want to get a table like
User_id,
And this simple statement ?
SELECT * FROM Users as U
left outer join UserCat as UC on U.user_id = UC.user_id
WHERE U.status = 1
AND UC.status = 1
Zoran Avtarovski a écrit :
I have a parent:child table relationship using a Join SQL statement and I am
having trouble getting it right. One parent
I have a parent:child table relationship using a Join SQL statement and I am
having trouble getting it right. One parent many children.
The starting statement is:
SELECT * FROM Users as U
left outer join UserCat as UC on U.user_id = UC.user_id
This simple statement returns all content from Users
Hi all,
I would like to use iBatis on my project. I have some constraints :
- I need to use a connection management mecanism external to iBatis.
- I need to use a transactionnal mecanism external to iBatis (not EJB
but another one).
Following the javadoc example I have successfully inserted an o
18 matches
Mail list logo
