M:N select and groupBy

Ok, I may be referring to the concept inaccurately as I'm not an sql guru (non available so the work falls to me). I'm trying to accomplish the following query: SELECT SUM(name.size) as totalBytes, name.type, log.timestamp FROM name, log WHERE nam

Re: [JDBC type = ARRAY / Java type = ?] Deadlock found when trying to get lock (MySQL 5.0 with innodb)

No worries, and in all liklihood it isn't an ibatis specific bug, I had just held out hope that someone else might have encountered the issue and arrived at a solution. I've tried both simple and dbcp data sources witht the same results and I'm currently using mysql with innodb tables and row leve

Re: [JDBC type = ARRAY / Java type = ?] Deadlock found when trying to get lock (MySQL 5.0 with innodb)

Did no one ever find a solution to this? I'm getting it left and right when an application crashes and is then restarted... Any advice would be greatly appreciated! Chun Wei Ho wrote: > > Hi! > > We are using apache ibatis with our MySQL 5.0 database (using innodb > tables), in our web applica

Re: [JDBC type = ARRAY / Java type = ?] parameter map and like %?% query

, what happens if > value is '%blah%';drop table employee;--'? > > That would be an "OMG!" moment for most developers. :-) > > A third option that might be better is this: > > select * from employee where lastname like '%' || #value# ||

RE: parameter map and like %?% query

erMap = new HashMap(); > > It's just a java.util.Map > > > > -Original Message- > From: cmose [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 15, 2007 4:18 PM > To: user-java@ibatis.apache.org > Subject: RE: parameter map and like %?% query >

RE: parameter map and like %?% query

hmnnn...thinking about it further, I suppose I could use a typehandlercallback to add the leading and trailing %'s to the parameter... cmose wrote: > > Milo, > thanks for that information - I had hoped to not have to put the wildcards > in the parameter programmatically pri

RE: parameter map and like %?% query

re first_name like #nameParm# > > > > Then your code can call this statement like this: > > parameterMap.put("nameParm", "%"+nameParmValue+"%"); > List results = sqlMapClient.queryForList("selectLikeName", > parameterMap); > > > G

parameter map and like %?% query

I hope this isn't a blatantly obvious question but it may well be... I'm trying to do a LIKE query using either a parameter map or an inline parameter map and I can't seem to get that to work with the % and % characters, what I would like to do is something along the lines of LIKE %?% or LIKE %#v

Re: Deadlock found when trying to get lock; try restarting transaction

dles that. > > > > On 2/2/07, cmose <[EMAIL PROTECTED]> wrote: >> >> >> Clinton, thanks for the advice, I did remove those settings, however, >> that >> did not appear to have any noticeable effect on the problem. >> >> I'm not rea

Re: Deadlock found when trying to get lock; try restarting transaction

mportant > than > the size of the values. > > In the future I may suggest we remove these settings altogether. They > were > a performance benefit for some extremely constrained architectures, like > the > onese in the PetStore performance testingit's all a bit

Deadlock found when trying to get lock; try restarting transaction

Hello all, I've got fairly staright forward application in which there ~ 3 -15 threads running that hit a database. The threads can potentially try to update the same table. I'm just getting into the test stage and have hit a snag with ibatis and transactions. I'll randomly receive MySQLTransactio

Re: Phantom data results??

sven, thanks for the info, wasn't aware of that - does the data get committed once one's session ends or...? -- View this message in context: http://www.nabble.com/Phantom-data-results---tf2036087.html#a5611732 Sent from the iBATIS - User - Java forum at Nabble.com.

Re: Phantom data results??

Gwyn, that's an interesting insight regarding isql*plus, I'll have to look into that. I was under the impression that the inserts are "committed" in fairly short order, e.g., I think in the past I've done some similar tests with ibatis that involved prepopulating some tables using isql*plus and I

Re: Phantom data results??

Jeff thanks for the reply, I didn't really believe that there were phantom tables being created somewhere ;-) Trouble is that I have 0 caching configured anywhere and am not using explicit transactions anywhere, strictly using a simple data source that just connects to the database via jdbc and t

Phantom data results??

Hey all, I'm mostly an ibatis noob and having quite a bizarre problem, for me at least, with ibatis returning phantom results on some test queries. Basically, is there any caching happening with Ibatis behind the scenes that I should be aware of?? Right now I'm using a simple data source and lett