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

2009-10-14 Thread Rick . Wellman
(from the way you wrote your question) Assumption #1: You have N web-applications that each have their own Spring 'applicationContext.xml' file. Assumption #2: Until now, each configLocation property of the sqlMapClient bean has been identical. If Assumptions #1 and #2 are correct, then you have a

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

2009-10-14 Thread gunacesun_ibatis
Does the question make sense? Is it too trivial? Why no response?:-( gunacesun_ibatis wrote: > > I've been using Spring 2.5 and iBatis 2.3 to connect to Oracle 10g. > > I'm testing our move to Oracle 11g RAC. In the RAC setup, some of my apps > use one service and others use a different service

Re: IBatis Array feild insertion problem in postgres database()Please help me)

2009-10-14 Thread Ingmar Lötzsch
Look at the stacktrace: > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in org/ada/kms/sqlmap/KmsgroupSQLMap.xml. > --- The error occurred while applying a parameter map. > --- Check the kmsgroups.insertgroups-InlineParameterMap. > --- Check the parameter

Re: can IBATIS handle mysql "DATE" keyword?

2009-10-14 Thread Ed Stafford
The required escape characters for xml are: " " ' ' < < > > & & Your problem isn't so much with iBatis xml config as it is with the general requirements of well formed xml. Cheers, -Ed 2009/10/14 meindert > Off the top of my head that would be <, # and $ > > -Original Message---

RE: can IBATIS handle mysql "DATE" keyword?

2009-10-14 Thread meindert
Off the top of my head that would be <, # and $ -Original Message- From: jrhitokiri [mailto:jrhitok...@gmail.com] Sent: 14 October 2009 01:02 PM To: user-java@ibatis.apache.org Subject: RE: can IBATIS handle mysql "DATE" keyword? I tried it. It works now. Wow, and I was stumped on that

RE: can IBATIS handle mysql "DATE" keyword?

2009-10-14 Thread jrhitokiri
I tried it. It works now. Wow, and I was stumped on that for an hour before I decided to post here. this helped a lot! Thanks! But anyway, aside from the greater than and less than symbols, what other symbols need escaping? so that I'll know when to use this again. Niels Beekman-2 wrote: > >

RE: can IBATIS handle mysql "DATE" keyword?

2009-10-14 Thread Niels Beekman
Did you try it? Looks like it should work. -Original Message- From: jrhitokiri [mailto:jrhitok...@gmail.com] Sent: Wednesday, October 14, 2009 12:11 PM To: user-java@ibatis.apache.org Subject: Re: can IBATIS handle mysql "DATE" keyword? will this be okay: CODE: Regards, JR Ed

Re: can IBATIS handle mysql "DATE" keyword?

2009-10-14 Thread jrhitokiri
will this be okay: CODE: Regards, JR Ed Stafford-3 wrote: > > You could also wrap it in CDATA block if you don't want to deal with > escaping everything (http://www.w3schools.com/xmL/xml_cdata.asp). > > -Ed > > 2009/10/14 Niels Beekman > > -- View this message in context: http:

Re: can IBATIS handle mysql "DATE" keyword?

2009-10-14 Thread Ed Stafford
You could also wrap it in CDATA block if you don't want to deal with escaping everything (http://www.w3schools.com/xmL/xml_cdata.asp). -Ed 2009/10/14 Niels Beekman > You should escape your < and >. > > Niels > > -Original Message- > From: jrhitokiri [mailto:jrhitok...@gmail.com] > Sent:

RE: can IBATIS handle mysql "DATE" keyword?

2009-10-14 Thread Niels Beekman
You should escape your < and >. Niels -Original Message- From: jrhitokiri [mailto:jrhitok...@gmail.com] Sent: Wednesday, October 14, 2009 10:21 AM To: user-java@ibatis.apache.org Subject: can IBATIS handle mysql "DATE" keyword? I have this query I tested in mysql. it works when I type

can IBATIS handle mysql "DATE" keyword?

2009-10-14 Thread jrhitokiri
I have this query I tested in mysql. it works when I type it and use example input: CODE: select * from eservations where (DATE(start) < DATE(input_start) AND DATE(input_start) < DATE(END)) OR (DATE(start) < DATE(input_end) AND DATE(input_end) < DATE(end)) the thing is, ibatis throws an excep