Post your test code, and I'll show you what's wrong with it.ClintonOn 2/27/06, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
Sven,
thanks for your response. I did some preliminary test on iBATIS' performance. For JDBC (MySql 5.0), i recorded time from establishing connection, result set, and m
Some ideas:
- Are you using transactions in the correct way?
- If you were on Oracle you'd probably don't want to use SimpleDatasource
(because of rollbacks)
- Is your ping query setup correctly?
- Are you using parameter binding with your JDBC?
- Are you executing the same query (iBATIS/JDBC) u
3-5 times slower does not sound correct. I would be curious to hear
how you setup and administered these tests.
Brandon
On 2/27/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Sven,
>
> thanks for your response. I did some preliminary test on iBATIS'
> performance. For JDBC (MySql 5.0), i re
I have a ResultMap that calls another select statement to retrive an object.
...
SELECT col1, col2, ... FROM vendor WHERE ven_vendor_code = ' '
orderDog is an object. I keep getting java.lang.NullPointer Exceptions
related to the orderDog property. How do I get or
Sven,
thanks for your response. I did some preliminary test on iBATIS' performance. For JDBC (MySql 5.0), i recorded time from establishing connection, result set, and mapping the result to objects. For list of simple objects, it seems to me that iBATIS (no caching and lazyloading) is 3-5 times
It's comparing apples and oranges ;-) ... iBATIS in the end also boils
down to JDBC calls, so you can assume it's a bit slower than JDBC (the
price for more flexibility and ease of use). But with iBATIS you end up
with java objects while with JDBC you end up with primitives/string that
you yo
All,
I'm wondering if anybody has some stats on iBATIS' performance agains
direct JDBC calls.
Thx,
Tony
Dennis,Letting an exception trickle all the way to your user is generally a bad thing. If it was me I would catch this exception and then pull the error message from some where else, say a resources file, and the display this to the user. I have no clue what web framework you are using, if any, b
Title: Exception error message
Hi there:
When I display the getMessage() of the SQLException on the front-end screen it looks like the following:
java.rmi.RemoteException:
--- The error occurred in Abc.xml.
--- The error occurred while applying a parameter map.
--- Check the Abc
Hello,
I just tested it and i do not get an error, but I DO GET NULL values for all the properties in the LazyDynaBean.
From: Ben Munat <[EMAIL PROTECTED]>Reply-To: user-java@ibatis.apache.orgTo: user-java@ibatis.apache.orgSubject: Re: Result Map Extends/Date: Mon, 27 Feb 2006 08:43:49 -0800>I
>>
ORDER BY #sortBy#
replace this with following:
ORDER BY $sortBy$
-Henry
Vu, Thai wrote:
I cannot make the ORDER BY clause work.
public class RequirementsSummaryCondBean {
private String majcom;
private Integer budgetProject;
private String location;
I cannot make the ORDER BY clause work.
public class RequirementsSummaryCondBean {
private String majcom;
private Integer budgetProject;
private String location;
private String round;
private String sortBy;
// getter & setter methods here
}
My guess is that the problem is that LazyDynaBean does not implement java.util.Map, but sort of acts like a Map. iBATIS has special code to deal with Maps because the properties cannot be discovered with regular reflection methods.
I'd suggest that the best way to deal with this is to create so
I don't think Alden was asking for a dependency... I think he was just trying to use
LazyDynaBean as the resultClass in his sqlMap and it's not working. I would imagine that
has something to do with a clash between the reflection used by LazyDynaBean and the
relection used by SqlMap.
Alden, wh
It don't think it will be included. The idea is to have an absolute
minimal amount of dependencies on other software.
Regards,
Sven
Alden S wrote:
Hi,
I want to use org.apache.commons.beanutils.LazyDynaBean for the resultClass but
Ibatis does not allow me to.
resultClass="org.apache.com
Hi,
I want to use org.apache.commons.beanutils.LazyDynaBean for the resultClass but Ibatis does not allow me to. I know i can use HashMap and then do org.apache.commons.beanutils.BeanUtils.copyProperties(bean, map); which would be acceptable for queryForObject(..) but if you do queryFor
select the rows for names with the lowest date/time (per name):
select date, time, name from mytable A
having timestamp(date, time) = select min(timestamp(date, time))
from mytable B
where A.name = B.name
Regards,
Sven
>- Oorspro
Maybe the "having" clause :
select date, time, name from mytable
having date = min(date)
Ashish Kulkarni a écrit :
Hi
I have a table with 4 columns number, name, date,
time, it is not unique so can have multiple entries
for one name at different date and time.
I need to find out the first instan
18 matches
Mail list logo
