Re: iBATIS with DB2 stored procedure call problem

2007-12-13 Thread Abhigyan Agrawal1
Are you sure that the user name you are providing in config file has access to the schema? I tried simulating the problem but it is working without specifying in the schema name. May be you can send what config you are using. Cheers, Abhigyan Agrawal "Kezerashvili, Denis" <[EMAIL PROTECTED

Re: QueryforList and Generics

2007-12-13 Thread Jeff Butler
+1 I'd only add that Niels' solution is the coolest! Then you only have the dreaded annotation in one spot. The is the closest you can get to "resolving" this with iBATIS in its current form. Perhaps we can do something about it (like Neils' solution) for iBATIS 3.0 - and no, I don't know when

Re: QueryforList and Generics

2007-12-13 Thread Larry Meadors
You can't. If you think about it, it'll make sense. The sqlMapClient returns lists of objects, to 'resolve' the warning, you'd have to make it return lists of *your* objects...at compile time. That can't happen. :-) The 'resolution' is to suppress the warnings. Larry On Dec 13, 2007 3:25 PM,

Re: QueryforList and Generics

2007-12-13 Thread Stefano Tranquillini
Yes. I can hide the warning but i want resolve not hide. On Dec 13, 2007 9:44 PM, Jeff Butler <[EMAIL PROTECTED]> wrote: > This warning is a *compiler* warning. Probably your IDE or compiler has a > way to turn it off. For example, in Eclipse go to: > > Window->Preferences->Java->Compiler->E

RE: Newbie tries to solve the N+1 selects problem and cries for help

2007-12-13 Thread Brian Parkinson
Which I have just finished. ;-) iBATIS is very cool - a row handler is completely simple to implement. Wicked. parki... From: Poitras Christian [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 3:02 PM To: user-java@ibatis.apache.org S

RE: Newbie tries to solve the N+1 selects problem and cries for help

2007-12-13 Thread Poitras Christian
In this case, you have to implement a row handler. Christian From: Brian Parkinson [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 12:14 PM To: user-java@ibatis.apache.org Subject: Newbie tries to solve the N+1 selects problem and cries for help

Re: QueryforList and Generics

2007-12-13 Thread Jeff Butler
This warning is a *compiler* warning. Probably your IDE or compiler has a way to turn it off. For example, in Eclipse go to: Window->Preferences->Java->Compiler->Errors/Warnings Then disable the warning for "Unchecked generic type" operation. Jeff Butler On Dec 13, 2007 1:06 PM, Stefano Tranq

RE: QueryforList and Generics

2007-12-13 Thread Niels Beekman
One thing you could do is introduce a utility method that accepts an extra 'resultClass' argument, something like this: @SuppressWarnings("unchecked") public List queryForList(Class resultClass, String id, Object parameterObject) { return queryForList(id, parameterObject); } Invocat

Re: QueryforList and Generics

2007-12-13 Thread Stefano Tranquillini
Hi, there is a "little" problem i've 100 total warning in a 68 strutc action. there isn't a place where put the "Magic string" and this is valid for all? maybe in the bean or something else? bye On Dec 13, 2007 7:38 PM, Brian Parkinson <[EMAIL PROTECTED]> wrote: > Hi Stefano: > > > Just put that

iBATIS with DB2 stored procedure call problem

2007-12-13 Thread Kezerashvili, Denis
> We are using iBATIS as a persistence layer running on top of DB2. > We've ran into a problem executing stored procedure. > > The following works: > > {call PERMIT.PERMIT_DELETE_USER_BY_ID_SP(#id#, > #updateId#)} > > > But this does not: > >

RE: QueryforList and Generics

2007-12-13 Thread Brian Parkinson
Hi Stefano: Just put that magic line right above the method that is complaining, and the warning will go away. parki... From: Stefano Tranquillini [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 12:37 PM To: user-java@ibatis.apache.org Sub

Re: QueryforList and Generics

2007-12-13 Thread Stefano Tranquillini
Where? but, this is the only way to resolve? there isn't a methtod to resolve it? On Dec 13, 2007 7:33 PM, Jeff Butler <[EMAIL PROTECTED]> wrote: > Add this annotation: > > @SuppressWarnings("unchecked") > > Jeff Butler > > > On Dec 13, 2007 12:24 PM, Stefano Tranquillini < > [EMAIL PROTECTED]> w

Re: QueryforList and Generics

2007-12-13 Thread Jeff Butler
Add this annotation: @SuppressWarnings("unchecked") Jeff Butler On Dec 13, 2007 12:24 PM, Stefano Tranquillini < [EMAIL PROTECTED]> wrote: > Hi everybody. > I've a problem. How i can resolve the warning when i try to do this: > > List contatti = null; > contatti = > sqlMap.getSqlMap().queryFo

QueryforList and Generics

2007-12-13 Thread Stefano Tranquillini
Hi everybody. I've a problem. How i can resolve the warning when i try to do this: List contatti = null; contatti = sqlMap.getSqlMap().queryForList("get_Contatti_from_Nome_Cognome_Questionario_aggiungi", aq); the warning is: found : java.util.List required: java.util.List tnx bye -- Stefan

Newbie tries to solve the N+1 selects problem and cries for help

2007-12-13 Thread Brian Parkinson
Hello: I am having a problem with the ol' N+1 selects problem - wondering if someone can help. I have a Status object, which contains a list of StatusEquipment objects, as well as a list of StatusZone objects. I want, in one select statement, to retrieve the one Status object, and populate

Re: Logical OR'ing

2007-12-13 Thread Jeff Butler
I can't think of a way to do this with the tag. The iBATIS dynamic SQL tags are not a functionally complete language, so there are some limitations. Abator generates code that would do it, but it boils down to this: $oredExpression$ Where $oredSolution$ comes from a list of Strings like th

Re: How do I use "where ... IN (...)" in my queries still up to date?

2007-12-13 Thread Larry Meadors
Look at the tag. Larry On Dec 13, 2007 8:48 AM, Heinrich Götzger <[EMAIL PROTECTED]> wrote: > Hi, > > is the wiki-article 'How do I use "where ... IN (...)" in my queries' > in > http://opensource.atlassian.com/confluence/oss/pages/viewpage.action?pageId=5925 > still up to date? > > Or is there

How do I use "where ... IN (...)" in my queries still up to date?

2007-12-13 Thread Heinrich Götzger
Hi, is the wiki-article 'How do I use "where ... IN (...)" in my queries' in http://opensource.atlassian.com/confluence/oss/pages/viewpage.action?pageId=5925 still up to date? Or is there another, more convenient and secure solution possible today? Thanks Cheers Heinrich

Logical OR'ing

2007-12-13 Thread Gurpiar Bassi
I am trying to do the following using IBATIS: If(x != null|| y != null || z != null) { //DO SOME SQL } How do I specify this using sql map using ? The PCMS Development Team promoting PCMS Values ~Integrity~Respect~Commitment~ ~Continuous Improvement~ The informatio

Re: On Before Get Connection

2007-12-13 Thread Denis Karpov
Thank you very much. The main trick is that you can specify class in TYPE attribute. . Denis. You could implement your own transaction manager and do the initiailzation there before returning the connection to iBATIS. Jeff Butler

Re: listing cache models

2007-12-13 Thread Darren Davison
Thanks Larry. Since SqlMapClientImpl is currently the only internal class that implements both of those interfaces, would there be an issue to move the getDelegate() method into the SqlMapClient interface itself, or even merging the two interfaces? Of course, this would break anyone's code if the

Re: Mysql Database not showing the inserted record

2007-12-13 Thread Larry Meadors
Does your cache model have a flushOnExecute for that insert statement? Larry On Dec 13, 2007 12:22 AM, AVenkatesan <[EMAIL PROTECTED]> wrote: > > > Thank For your reply Axel > But at last i tried following whicvh got worked, > > sqlMapClient.startTransaction(); > sqlMapClient.insert("Co

Re: listing cache models

2007-12-13 Thread Larry Meadors
Nope, that's the only way - other than reflection, which would have the same issue. Once you get it working, it shouldn't be a problem unless you update iBATIS or Spring. Larry On Dec 13, 2007 2:00 AM, Darren Davison <[EMAIL PROTECTED]> wrote: > hi, > > on our project we'd like to include an ad

listing cache models

2007-12-13 Thread Darren Davison
hi, on our project we'd like to include an admin page that allows someone to manually flush any particular cache that ibatis is using. It looks like we can get an iterator over the cache models by doing something like this (untried yet!); ExtendedSqlMapClient ext = (ExtendedSqlMapClient) sqlMapC