useGeneratedKeys issue in insert statement w/patch

2009-10-15 Thread Jonathan Curran
Hi all, here is what I am running into when using useGeneratedKeys in an insert statement: org.apache.ibatis.exceptions.IbatisException: ### Error updating database. Cause: org.apache.ibatis.executor.ExecutorException: Error getting generated key or setting result to parameter object. Cause:

RE: Password Encryption

2009-10-15 Thread Ejaz X Mohammed
Works! I just override the initialize method ... public void initialize(Map map) { EventConfig ec = EventConfig.getInstance(); String pass = PasswordUtility.getInstance().getDecodedPassword(ec.getJdbcPassword()); pass = pass.trim(); map.put("JDBC.Password",

RE: Password Encryption

2009-10-15 Thread Rick . Wellman
I needed to use the following technique to solve a similar challenge recently and, though seemingly obvious, I found no references on the web. I cannot give it a full stamp of approval but it is working for us so far: 1) Extend the iBatis class SimpleDataSourceFactory: public class YourClass

RE: Password Encryption

2009-10-15 Thread Ejaz X Mohammed
I'm using SIMPLE transactionmanager From: Rick.Wellman [mailto:rick.well...@kiewit.com] Sent: Thursday, October 15, 2009 12:51 PM To: user-java@ibatis.apache.org Subject: RE: Password Encryption Dependi

RE: Password Encryption

2009-10-15 Thread Rick . Wellman
Depending on the DataSource you are using, you might be able extend that class to override a particular property/method call. Can you describe your iBatis configuration? (i.e. sqlMap.xml, are you using Spring, what datasource are you using) From: Ejaz X Mohammed [mailto:ejaz.moham...@jpmorgan.

Password Encryption

2009-10-15 Thread Ejaz X Mohammed
Hello, I have encrypted password in properties file. To decrypt I have to call a function. How can I make ibatis call this function to get decrypted password before making jdbc connection? Thanks Ejaz This email is confidential and subject to important disclaimers and conditions including on

RE: How to configure SqlMapClient for multiple Oracle RAC services?

2009-10-15 Thread Rick . Wellman
I may be overstepping my overall iBatis knowledge but here is my understanding: 1) The workhorse of iBatis is the SqlMapClient object which is configured through an iBatis XML file (and you may be using Spring configuration as well, sounds like it). 2) The XML file defines one, and only one, dataso

Re: Select Query 'LIKE' Issue

2009-10-15 Thread Clinton Begin
I personally prefer to add the wildcards in the Java code. But concatenation in the SQL works as well. Clinton On Thu, Oct 15, 2009 at 6:31 AM, Ingmar Lötzsch < iloetz...@asci-systemhaus.de> wrote: > If || is the operator for string concatenation, try > > like '$pattern$' || '%' > > respectively

Re: Select Query 'LIKE' Issue

2009-10-15 Thread Ingmar Lötzsch
If || is the operator for string concatenation, try like '$pattern$' || '%' respectively like '%' || '$pattern$' || '%' gonas schrieb: > Hello , > > I am using Ibatis 2.3.Issue Persist as Below mentioned. > > Query in Respective Configuration XML As: > > > select ifnull(max(account_nu

Setting query timeout in runtime

2009-10-15 Thread Chema
HELO: I've got iBatis 2.3.0.677 release and I'm setting query timeout in some queries. But I'd like to pass this parameter to query in runtime Is it possible ? Thanks Regards - To unsubscribe, e-mail: user-java-unsubscr...@iba

Select Query 'LIKE' Issue

2009-10-15 Thread gonas
Hello , I am using Ibatis 2.3.Issue Persist as Below mentioned. Query in Respective Configuration XML As: select ifnull(max(account_number),0) from account_details where account_number like '$pattern$%' TRIED PATTERS : $pattern$% , %$pattern$% So Here SQL always retuning Non Zero Val