Actually, it is the default behaviour. :-/
It's a combination of both the iBATIS transaction manager default
configuration and SimpleDataSource.
To make a long story short, in the good old days, some JDBC drivers
literally required a rollback to "reset" the connection. *cough* Sybase
*cough*
That is not the default iBATIS behavior, I'm guessing your container is
getting involved.
>From what I understand, the SIMPLE datasource type is generally for
standalone programs, not for apps running in a container.
On 3/4/08 4:20 PM, "Tom Henricksen" <[EMAIL PROTECTED]> wrote:
> Currently we a
Currently we are using JDBC with simple datasource.
But we are transitioning to JNDI datasource.
This is just a web application. I will take a look at the Wiki.
So is this default behavior of iBatis to create a transaction and roll
it back for even a select?
Wou
What transaction manager are you using?
Is this an EJB application with CMT, or just a web application?
Have you read the information in the WIKI about configuring iBATIS on
WebSphere?
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Environment+Specific+Information
Jeff Butler
On
We are performance monitoring our application and my DBA let me know
that we had over 3 MILLION rollbacks in a single day. We are using
WebSphere to DB2 on Win2k3 servers.
I looked in our code and could not find anything. Used p6spy and found
that every time queryForXXX is called I received a ro
I created a "Custom" DAO that extends the Abator generated DAO. That gave
me the ability to rebuild the Abator DAOs on the fly, and still have custom
methods for handling custom queries, translating between custom extended
Models, etc. So I have a custom DAO that extends the Abator DAO, a custom
I did want to use Spring for its power and nice features, but there is
not enough time.
It's just 6 to 8 iterations of one week... and now we are in our third
iteration.
So it's too much overhead for this 'college' project.
I've planned to start using Spring on my own - altogether with
iBAT
IIRC
#value# + '%'
Clinton
-Original Message-
From: Abhishek Pratap Singh08 [mailto:[EMAIL PROTECTED]
Sent: March-04-08 8:01 AM
To: user-java@ibatis.apache.org
Subject: Regarding SQL injection chaniging SELECT QUERY
Hi Again,
Suppose I have a query
Select * from table where column L
Hi,
Select * from table where column LIKE CONCAT(#value#, '%')
Christian
-Original Message-
From: Abhishek Pratap Singh08 [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2008 10:01 AM
To: user-java@ibatis.apache.org
Subject: Regarding SQL injection chaniging SELECT QUERY
Hi Again,
Hi Again,
Suppose I have a query
Select * from table where column LIKE '$value$%'
Can be changed to
select * from table where column LIKE #value# || '%'
but this works on ORACLE
what is the work around for MySQL?
Regards,
Abhishek
-Original Message-
From: Larry Meadors [mailto:
Yep, all of the links are on the page I sent.
Cheers,
Clinton
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: March-04-08 5:53 AM
To: user-java@ibatis.apache.org
Subject: RE: Remove from list
Clinton,
After I unsubscribe myself from the list, if I need to be subscribed ag
Exactly.
Some people do this when they go on vacation.
Christian
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2008 7:53 AM
To: user-java@ibatis.apache.org
Subject: RE: Remove from list
Clinton,
After I unsubscribe myself from the l
Clinton,
After I unsubscribe myself from the list, if I need to be subscribed again
then that time can I use the same email id as before?
Thanks
Jasmin
"Clinton Begin" <[EMAIL PROTECTED]>
03/03/2008 03:00 PM
Please respond to
user-java@ibatis.apache.org
To
cc
Subject
RE: Remove from lis
Chapter 1
Don't use the replacement ($property$) syntax unless you scrub the input.
The end.
:-)
Larry
On Tue, Mar 4, 2008 at 3:05 AM, Abhishek Pratap Singh08
<[EMAIL PROTECTED]> wrote:
>
>
>
>
> Hi All,
>
> I need the guidelines of handling sql
> injection in i
Why do you have the prepend="AND" there?
RTC_FK_CABINET_CBT_ID = #cabinetId# AND
RTC_FK_UTILISATEUR_USR_ID = USR_ID AND
Larry
Thanks,
The problem is then performance, since the query would be less optimized if the
join statements are first.
We found a "solution" by adding "1=1" or "1=0" before the dynamic statements.
But I'm still open to other suggestions!
Thanks again
Regards
Gilles
- Message d'origine
De
Move your join constraints before the dynamic statements, the dynamic
statements can then always use AND.
-Original Message-
From: Gilles Schlienger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2008 11:13 AM
To: user-java@ibatis.apache.org
Subject: Re : Dynamic request with null va
Thanks,
I'm afraid this does not work, it generates a query like:
select *
from TABLE_1,TABLE_2
and RCC_FK_UTILISATEUR_USR_ID = USR_ID
and USR_FK_CRCC_CRG_ID = CRG_ID
that breaks.
Any other thoughts?
Thanks again in advance,
Regards,
Gilles
- Message d
Hi All,
I need the guidelines of handling sql injection
in iBatis. Any pdf or link will be very helpful.
Regards,
Abhishek
CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for
I can't use Abator, because I have to migrate a legacy application. Yesterday I
tried the iterate-Tag in the mapping file and this works for me at the moment.
greetz
wolle
Original-Nachricht
> Datum: Tue, 4 Mar 2008 03:16:44 +0400
> Von: "Koka Kiknadze" <[EMAIL PROTECTED]>
>
20 matches
Mail list logo
