IBatis sql map IBator sql map woes (noob)

2009-06-12 Thread david
Hello IBatis dev, gurus and mortals, I have a Wicket/AppFuse web application in Eclipse that uses a simple xxxsql.xml map. The web app builds and deployes OK on both jetty and tomcat. Then, I installed the IBator Eclipse plugin and generated the artifacts for the xxxsql.xml mapped as generated b

Re: Help required

2009-06-12 Thread Sundar Sankar
Count is a keyword. it might not be accepted. Try something else. Did u execute this query directly On Fri, Jun 12, 2009 at 7:44 AM, DelGurth wrote: > To me that COUNT seems like an alias for the result of COUNT(CD) as in > SELECT COUNT(CD) AS COUNT > > But, what is the error? > > DelGurth > >

Re: Help required

2009-06-12 Thread DelGurth
Btw, I think the problem is in the #date:VARCHAR# part. Why don't you put the date in as :DATE or :TIMESTAMP ? Did you try to put com.ibatis and java.sql log to debug, so you see the exact parameter going into the #date# parameter? DelGurth On Fri, Jun 12, 2009 at 4:44 PM, DelGurth wrote: > To

Re: Help required

2009-06-12 Thread DelGurth
To me that COUNT seems like an alias for the result of COUNT(CD) as in SELECT COUNT(CD) AS COUNT But, what is the error? DelGurth On Fri, Jun 12, 2009 at 3:35 PM, Brandon Goodin wrote: > I didn't look over it thoroughly but i noticed you appear to have a > misplaced "COUNT": >  SELECT CG , COUNT

Re: Unexpected error while running Ibator NPE

2009-06-12 Thread andig
That's it- thank you! Dan Turkenkopf wrote: > > You're probably running into a bug that requires the DAOGenerator to be > included. It's been fixed in Subversion, so you can build from source or > just uncomment your DAOGenerator and then ignore the generated classes. > > See this thread: > h

Re: Help required

2009-06-12 Thread Brandon Goodin
I didn't look over it thoroughly but i noticed you appear to have a misplaced "COUNT": SELECT CG , COUNT(CD) *COUNT*, SUM ( TO_DATE(EDATE||' '|| etime ,'DD-MM- HH24:MI:SS' ) - TO_DATE(ADATE||' '|| atime ,'DD-MM- HH24:MI:SS' ) ) total_time Perh

Re: Unexpected error while running Ibator NPE

2009-06-12 Thread Dan Turkenkopf
You're probably running into a bug that requires the DAOGenerator to be included. It's been fixed in Subversion, so you can build from source or just uncomment your DAOGenerator and then ignore the generated classes. See this thread: http://mail-archives.apache.org/mod_mbox/ibatis-user-java/20090

Unexpected error while running Ibator NPE

2009-06-12 Thread andig
I'm trying to run Ibator on Eclipse seeing this error: !ENTRY org.apache.ibatis.ibator.eclipse.ui 4 4 2009-06-12 13:30:57.656 !MESSAGE Unexpected error while running Ibator. !STACK 0 java.lang.NullPointerException at org.apache.ibatis.ibator.api.IntrospectedTable.calculateDAOImplementati

Re: Memeory leak in com.iBatis.sqlmap.engine.impl.SqlMapClientImpl class

2009-06-12 Thread ankurgur
Hi there, I am in dire need of help regarding Memory leak problem i am facing in my application. After analysis it seems there is some problem with the way we are using iBATIS in our application. Actually we are uploading huge amount of data (around 50k) into DB through our application using tra

Re: multiple table mapping scenario.

2009-06-12 Thread Steven A
Axel, That solves my problem. Sorry I wasn't able to find that in the documentation. My testcase now passes! Thanks. On Fri, Jun 12, 2009 at 1:11 AM, Leucht, Axel wrote: > I don't fully understand you're problem but to get rid off the '' around > the string you should give > > select * from

AW: multiple table mapping scenario.

2009-06-12 Thread Leucht, Axel
I don't fully understand you're problem but to get rid off the '' around the string you should give select * from zomg_$tableName$ a try.

RE : RE : Using a user variable in a request with MySQL

2009-06-12 Thread Gilles SCHLIENGER
It works great with iBATIS/MySQL. Thanks a lot Larry and sorry for bothering you with something I could/should have found myself... Regards Gilles De : Larry Meadors [larry.mead...@gmail.com] Date d'envoi : jeudi 11 juin 2009 17:22 À : user-java@ibatis.a

multiple table mapping scenario.

2009-06-12 Thread Steven A
Hello all, new to iBatis, here goes. I have a table structure like this: create table zomg_zh ( id int(10) not null, name varchar(64) null, age int(10) null, primary key(id), unique(id) ) create table zomg_er ( id int(10) not null, name varcha