Thank you for all your answers.
A stored proc cannot be used in a select statement, unlike a function. In fact,
I think the solution could be to create a function that wraps the call to the
stored proc and then returns the id. that way I can then use a statement like :
select fct_getnextid(ca
Where is the Java code for the iBATIS calls? It is critical that
you show us the complete Java source for what you're doing. This
includes JDBC connection management, iBATIS transaction management and
the timing demarcation and mechanism.
Basically post 2 files: JdbcTest.java and Ibatis.java
1) You are not actually passing the ResultSet values into a set of
objects with the JDBC test.
2) You should measure the second query for speed. In other words the
first time you called a mapped statement it caches the mapping. You
must measure the second call to the same mapped statement. Make sur
the best time to ibatis is 265
the best time to JDBC is 45
265/45 = 5.8 is difference.
In one query Ibatis there are 5 query JDBC, I believe that there is
difference.
there is one user concurrent, you have a good idea, I will test with more
users.
Rodrigo
XML Buddy is all you need.
.V
Brandon Goodin wrote:
My Eclipse rocks!!! But, if you have Intellij I can't imagine that
they wouldn't have that ability.
Brandon
Hi Clinton,
Thank you very much by your information, the environment is:
application server: weblogic 8.1
transaction manager: JNDI WL8.1
EJB class with three DAO's, IBATIS (Framework DAO, PLSQLDAO, JDBCDAO)
I thought that Ibatis had the same perfomance that native JDBC, butI believe
that th
Under low load, 1/3 of a second makes no difference.
Under how many concurent users before iBatis puls ahead?
.V
Brandon Goodin wrote:
Your metrics are generic. Is your JDBC and PL/SQL also translating
results into Lists of objects? Also, make sure you execute the
statement within ibatis more than
1up.com is using iBatis 2 and has 10 million members and 10,000
concurent users.
My new project is larger.
.V
Victor Stepanov wrote:
Brandon Goodin wrote:
I can vouch that we use iBatis internally at Plum Creek Timber
Company, Inc. But, i can't give you links or anything.
Brandon
On Apr 6, 2005 9
assuming the $BandName$ literal had the value of "Stellar" you should see:
SELECT Name FROM Band WHERE Name = '12#34Stellar56#78'
On Apr 6, 2005 3:25 PM, Ron Grabowski <[EMAIL PROTECTED]> wrote:
> How do I use the dollar sign notation (i.e. $xyz$) to send a string to
> the database that has a pou
How do I use the dollar sign notation (i.e. $xyz$) to send a string to
the database that has a pound sign on either side of it?
According to this post:
http://tinyurl.com/44je6
http://www.mail-archive.com/ibatis-user-java@incubator.apache.org/msg01358.html
I should use a double pound to send t
Your metrics are generic. Is your JDBC and PL/SQL also translating
results into Lists of objects? Also, make sure you execute the
statement within ibatis more than once. When you run a select for the
first time it caches the mapping to the object. The second time
through things are cached and shoul
This works in oracle:
select * from box
start with id = ?
connect by parentBoxId = PRIOR id
Steven Pannell wrote:
Sadly the wiki documentation does not appear to
be available for this topic :-(
-Original Message-
From: Brice Ruth[mailto:[EMAIL
Here we go again...
How are you testing this? Please don't post performance testing results WITHOUT THE SOURCE.
Once you post the source, we can begin to help you.
Cheers,
Clinton
On Apr 6, 2005 12:19 PM, rodrigo castillo <[EMAIL PROTECTED]> wrote:I tested the perfomance between ibatis, jdbc
I tested the perfomance between ibatis, jdbc, and pl/Sql where ibates is 5
times but slow that the previous ones. How Can i improve perfomance of ibatis?.
The query has 100 rows.
IBATIS: 265 ms. c=97
IBATIS: 281 ms. c=97
IBATIS: 265 ms. c=97
IBATIS: 296 ms. c=97
IBATIS: 311 ms. c=97
JDBC: 7
At 11:30 AM 4/6/2005 -0500, you wrote:
Check the Wiki, if you need more than that, let me know ... we use iBATIS
exclusively in our projects (we are, however, not a government body).
Brandon's point was simply that being in Apache's incubator does not mean
anything about the projects status as a
At 07:28 PM 4/6/2005 +0300, you wrote:
Yes I know that IBatis is stable
and so one but in this friday we will have big meeting and must provide
some references about this .
We also use ibatis but for goverment sector we must provide some document
becouse we have official claim.
And for me will be
No, it's just returning a list of integers.
- Original Message -
From: "Larry Meadors" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, April 06, 2005 11:04 AM
Subject: Re: ibatis says "no results" but manual query returns results
do you have a resultClass or resultMap defined for the query?
do you have a resultClass or resultMap defined for the query?On Apr 6, 2005 1:01 PM, Dan Tenenbaum <[EMAIL PROTECTED]> wrote:I am running a query from ibatis and I get this error:java.lang.reflect.UndeclaredThrowableExceptionat $Proxy9.getVisibleSelectedIds(Unknown Source)at(...)
I am running a query from ibatis and I get this error:
java.lang.reflect.UndeclaredThrowableException
at $Proxy9.getVisibleSelectedIds(Unknown Source)
at
(...)
... 18 more
Caused by: com.ibatis.dao.client.DaoException: Error executing query for
list. Cause: com.ibatis.co
hm ...
can you pass parameters in the tag?
-Original Message-
From: Jason Hall [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 06, 2005 1:26 PM
To: ibatis-user-java@incubator.apache.org; Brandon Goodin
Subject: RE: Using a stored proc in selectKey?
Why don't you call your stored
Why don't you call your stored procedure through the select statement.
ex.
select sp_get_next_id('CATEGORY_ID',???) as id from dual;
.
.
Jason Hall
-Original Message-
From: Brandon Goodin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 06, 2005 12:47 PM
To: ibatis-user-jav
AFAIK we don't support CallableStatement in the selectKey. If you
would like it to be, go ahead and place an enhancement request in
JIRA. But, i would think that if you are doing something like you are
describing, you would simply make your inserts all store procedures
and handle the increment int
If you want to make a case about iBATIS being in the incubator not
being a bad thing, you can mention the example of Apache Derby
(http://incubator.apache.org/projects/derby.html), which is still in
the incubator even if it was a commercial database sold by IBM until
very recently.
Aitor
Hi,
Is it possible to call an Oracle stored procedure in order to get the id
in the selectKey tag?
My stored proc is defined as :
CREATE OR REPLACE PROCEDURE SP_GET_NEXT_ID(nIDTYPE IN NUMBER, nNEXTID
OUT NUMBER) as
nIDTYPEBUF NUMBER;
nTheNewId NUMBER;
...
Where
IN : The idtype to be generated
Check the Wiki, if you need more than that, let me know ... we use iBATIS exclusively in our projects (we are, however, not a government body).
Brandon's point was simply that being in Apache's incubator does not mean anything about the projects status as a whole, it is simply an Apache thing (in
Sadly
the wiki documentation does not appear to be available for this topic
:-(
-Original Message-From: Brice Ruth
[mailto:[EMAIL PROTECTED]Sent: 06 April 2005 18:20To:
ibatis-user-java@incubator.apache.orgSubject: Re: building a
hierarchyCheck the Wiki for the 1:N and M:N
There are some solutions. The upcoming jpetstore (now jgamestore) will
be using a technique for hierarchal data storeage and retrieval. It is
based on a good article
(http://www.sitepoint.com/article/hierarchical-data-database). I found
some of the functionality lacking so i expanded upon it. I wou
Yes I know that IBatis is stable and so one but in this friday we will
have big meeting and must provide some references about this .
We also use ibatis but for goverment sector we must provide some
document becouse we have official claim.
And for me will be good to have some documents.
Brice
Check the Wiki for the 1:N and M:N N+1 selects stuff ... I think that's what you're looking for.
On Apr 6, 2005 11:16 AM, Steven Pannell <[EMAIL PROTECTED]> wrote:
Hi,Does anyone know how I could (if possible) build a hierarchy of objectsusing a single SQL statement. Is this possible?For example I
I absolutely concur with Brandon. We have been using iBATIS from the sourceforge.net days, and it is absolutely rock-solid stable.
On Apr 6, 2005 11:14 AM, Brandon Goodin <[EMAIL PROTECTED]> wrote:
Incubator has nothing to do with stability! We have been runningibatis from sourceforge for over 2 ye
Hi,
Does anyone know how I could (if possible) build a hierarchy of objects
using a single SQL statement. Is this possible?
For example I have a SQL table of BOXES. A BOX can contain other BOXES and
so on, like:
class BOX {
public void id();
public void parentBoxId();
p
Incubator has nothing to do with stability! We have been running
ibatis from sourceforge for over 2 years now. Incubator is simply an
acceptance process into the apache group. We are slated to graduate
from the incubator process. We would already have been, but, the
meeting that makes that decision
Thanks!
-Original Message-
From: Brandon Goodin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 06, 2005 12:11 PM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Selectkey Tag Question
the selectKey places the value in your java object. The reference you
pass into your insert wil
There are some references in the Wiki:
http://wiki.apache.org/ibatis/Powered_By_IBatis
Cheers,
Aitor
I can describe sitution we write one tender where describe that we use
IBatis but we've got claim that IBatis in Apche Incubator and not
stable for goverment sector development . For me will be
the selectKey places the value in your java object. The reference you
pass into your insert will then contain the id.
--- service ---
SomeObject someObject = new SomeObject();
...
myDao.insertSomeObject(someObject);
Integer myId = someObject.getObjectId();
... call some other Dao and pass the m
Brandon Goodin wrote:
I can vouch that we use iBatis internally at Plum Creek Timber
Company, Inc. But, i can't give you links or anything.
Brandon
On Apr 6, 2005 9:55 AM, Victor Stepanov <[EMAIL PROTECTED]> wrote:
Hi All.
I need to provide references about ibatis and sqlmaps that this product
i
I can vouch that we use iBatis internally at Plum Creek Timber
Company, Inc. But, i can't give you links or anything.
Brandon
On Apr 6, 2005 9:55 AM, Victor Stepanov <[EMAIL PROTECTED]> wrote:
> Hi All.
> I need to provide references about ibatis and sqlmaps that this product
> is stable can anyb
Hi All.
I need to provide references about ibatis and sqlmaps that this product
is stable can anybody give some references or where I can found it.
Thanks.
Title: Selectkey Tag Question
Hi,
I'm using Oracle sequences. I just wanted to know when using the tag, if there is a way to fetch that key in java
after it has been inserted. I need this key for other tables.
Thanks,
Jason Hall
39 matches
Mail list logo