Re: Data type mismatch with queryForObject, on String property with String value!

2008-02-15 Thread Richard Yee
What is the type of the TCTCDE field? -R Tracey Annison wrote: Hiya We've been using ibatis with Java for ages, agaionst dtaabases on an AS/400, and have a standard way of coding that works fine for loads of files. But now I have some weird behaviour that I don't understand… I have a Tr

Re: Transaction Time Out and Stale Connection Exception when using IBatis SQLMapper

2008-02-15 Thread Christopher Lamey
First, some etiquette advise is in order. It is considered a faux pas to send the same message to the list 6 times in a short amount of time. Posting something more will not get you more or quicker responses. Also, sending the same message directly to members of the list immediately after posting

RE: Subquery with where clause

2008-02-15 Thread Vinaya Tirikkovalluru
Nevermind... I got it working .. Thanks Vinaya From: Vinaya Tirikkovalluru Sent: Tuesday, February 12, 2008 4:11 PM To: 'user-java@ibatis.apache.org' Subject: Subquery with where clause Hi, I have this situation where I need to write a sub qu

Is there a way to make MyClassExample searches from Abator case insensitive?

2008-02-15 Thread Jared Blitzstein
I looked through the iBatis documentation, Abator documentation, and the mailing list archive to see if there was a way to make the searching case insensitive but didn't see any info. Since I'm not writing the SQL, I didn't see a way to do a lowercase or uppercase on the comparisons. Thanks in

Re: Using Ibatis as core for an Eclipse SQL plugin

2008-02-15 Thread Maarten Meijer
Thank you for confirming that is the route to go, I found that as well in http://www.ibm.com/developerworks/library/os-ecl-osgi/index.html Maybe it's time to suggest adding ibatis to the orbit project: http://eclipse.org/orbit Maarten We are developing an Eclipse Rich Client project using iB

RE: Data type mismatch with queryForObject, on String property with String value!

2008-02-15 Thread Tracey Annison
Hiya Thanks for that! I have no clue why it'd throw a wobbly on this file and not all the other near-identical ones, but that gives me somewhere to look... brilliant. Much appreciated! Cheers Tracey Annison _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 February 2008 15:3

Re: Data type mismatch with queryForObject, on String property with String value!

2008-02-15 Thread Marc . Heimann
If I remember correctly we had the same problem in the past. The error actually occured with the BigDecimal parameter but was reported to happen elsewhere. Try #departmentCode:DECIMAL# and see if it helps. Cheers Marc Heimann Software Engineer Prolifics Deutschland GmbH Notkestr. 3, D-22607 Ham

Re: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationExc eption

2008-02-15 Thread Graeme J Sweeney
On Fri, 15 Feb 2008, erosik wrote: i am using ibatis in my jsp application, i have created db with a unique field (e.g. id) so when i insert a record with same id again i m getting error like this, can any one help to sort out this exception com.mysql.jdbc.exceptions.MySQLIntegrityConstrai

Data type mismatch with queryForObject, on String property with String value!

2008-02-15 Thread Tracey Annison
Hiya We've been using ibatis with Java for ages, agaionst dtaabases on an AS/400, and have a standard way of coding that works fine for loads of files. But now I have some weird behaviour that I don't understand... I have a TransactionCode.xml with a query in it like this :

Re: Abator superclass per table

2008-02-15 Thread Jeff Butler
The ability to do this was very recently added to Abator (last week sometime). If you build Abator from the source in SVN you'll be able to specify the rootClass property on each table element. Jeff Butler On Fri, Feb 15, 2008 at 4:31 AM, Zach Visagie <[EMAIL PROTECTED]> wrote: > Hi > > I want

Transaction Time Out and Stale Connection Exception when using IBatis SQLMapper

2008-02-15 Thread venkatesh.madhavan
Hi, I am using WAS 6.0 Datasource inside my Ibatis sql mapper. The code in my sqlmapconfig.xml is as follows. I am calling the database operations from my EJB which is stateless and Bean Managed. The code inside my EJB

com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException

2008-02-15 Thread erosik
Hi, i am using ibatis in my jsp application, i have created db with a unique field (e.g. id) so when i insert a record with same id again i m getting error like this, can any one help to sort out this exception com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate

Re: Auxiliary insert parameter

2008-02-15 Thread oliverw
If I could use a constant, I wouldn't have made it a variable in the first place :) Chetan Nayak wrote: > > why don't you just hard code it to some value . > Something like to_tsvector(' ',#item_name#). > Hope this helps > > Thanks > Chetan > > > > On 2/15/08, oliverw <[EMAIL PROTECTED]> w

Re: Auxiliary insert parameter

2008-02-15 Thread oliverw
Interesting. I didn't know that IBatis will happily resolve nested property identifiers. Thanks! I'll give this a a shot. Dave.Derry wrote: > > I'm no pro with ibatis, but you could probably use a Map > > Map params = new HashMap(); > params.put("itemName", [instance of ItemName]); > params.pu

Re: Auxiliary insert parameter

2008-02-15 Thread Dave . Derry
I'm no pro with ibatis, but you could probably use a Map Map params = new HashMap(); params.put("itemName", [instance of ItemName]); params.put("ts_config", [value of ts_config]); then modify your insert statement INSERT INTO item_names (item_id, item_name, item_name_tsv, culture_id) VALUES(#

Re: Auxiliary insert parameter

2008-02-15 Thread Chetan Nayak
why don't you just hard code it to some value . Something like to_tsvector(' ',#item_name#). Hope this helps Thanks Chetan On 2/15/08, oliverw <[EMAIL PROTECTED]> wrote: > > > > INSERT INTO item_names (item_id, item_name, item_name_tsv, culture_id) > VALUES(#item_id#, #item_name#, to_tsvector(

Auxiliary insert parameter

2008-02-15 Thread oliverw
INSERT INTO item_names (item_id, item_name, item_name_tsv, culture_id) VALUES(#item_id#, #item_name#, to_tsvector(#ts_config#, #item_name#), #culture_id# ) In the above insert statement the #ts_config# is only needed as an argument to the to_tsvector() function call. Thus I would like to avoi

Abator superclass per table

2008-02-15 Thread Zach Visagie
Hi I want to be able to specify a different superclass for each model object. So either as an option in the abator config for the table element or abator should preserve "extends" added to the model. I generate using the flat model. Any ideas of how I can jump start achieving this? thanks Zach V

Re: Using Ibatis as core for an Eclipse SQL plugin

2008-02-15 Thread Marc . Heimann
We are developing an Eclipse Rich Client project using iBatis and faced the same problem. Our solution is to use the Eclipse Buddy mechanism (see http://www.eclipsezone.com/articles/eclipse-vms/ and http://help.eclipse.org/help31/index.jsp?topic=/org.eclipse.platform.doc.isv/reference/misc/bundl

Transaction Time Out and Stale Connection Exception when using IBatis SQLMapper

2008-02-15 Thread IBATIS
Hi, I am using WAS 6.0 Datasource inside my Ibatis sql mapper. The code in my sqlmapconfig.xml is as follows. I am calling the database operations from my EJB which is stateless and Bean Managed. The code inside my EJB