Re: stored procedure - resultClass example?

2009-04-21 Thread Nicholoz Koka Kiknadze
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF+CURSOR+Solutions On Tue, Apr 21, 2009 at 12:19 AM, sjpn p...@vignette.com wrote: Hi, I want to use ibatis as the standard for a large project. The client I'm working for does everything in stored procs for performance

Null handling of Ibator's Criteria class.

2009-04-21 Thread Iwao AVE!
Hi all, A Criteria inner class generated by Ibator throws RuntimeException when addCriterion() or addCriterionForJDBCDate() method is called with null as its 'value' argument. As a result of this behavior, when I build a dynamic criteria, I have to check null for each condition. Criteria

Re: stored procedure - resultClass example?

2009-04-21 Thread sjpn
Thanks. That is the code I am working off of currently. When I run my stored proc in sqldeveloper, it gives me back results. When I call it from my webapp with ibatis, I get an empty list. I don't see errors in the logs. [2009-04-21 08:56:14,428][DEBUG][com.ibatis.common.jdbc.SimpleDataSource] -

Sql Map file

2009-04-21 Thread Jhaver, Rishi
Hi I'm new to Ibatis and was wondering if anyone's faced this issue before. Couldn't find a solution on the website FAQs. I have the following in my sqlmapconfig file. transactionManager type=JDBC commitRequired=false dataSource type=SIMPLE property name=JDBC.Driver

Re: Sql Map file

2009-04-21 Thread Alex Sherwin
Not sure about doing it programatically, but it's going to end up being cleartext (or close to it) somewhere... For example when you use a connection pool in an app server, the user/password ends up being plain text in your domains configuration file... I believe most people focus on

Re: Sql Map file

2009-04-21 Thread Brandon Goodin
You could use JNDI, or can extends the simple datasource and add your own hashing. I'm not sure why you are that concerned about the password being in there. If someone gets access to your WEB-INF folder and you don't want them in there... you have bigger issues my friend. :) Brandon On Tue,

Re: Sql Map file

2009-04-21 Thread Chris O'Connell
I would suggest the appserver route. In at least the version of weblogic that I am using, the password is saved to the file system, but it is encrypted in the config file. If that isn't possible, just encrypt the password yourself and put some decryption code in an extension of the datasource.

Re: stored procedure - resultClass example?

2009-04-21 Thread sjpn
could it be possible that ibatis is return back an empty cached resultset? if so, how can i disable this cache or trigger it to clear? -- View this message in context: http://www.nabble.com/stored-procedure--%3E-resultClass-example--tp23148960p23160958.html Sent from the iBATIS - User - Java

Question about the executeBatch......

2009-04-21 Thread Joey Lv
Hi, Below is my java code, to execute a batch this.getSqlMapClient().startBatch(); for (Subscriber subscriber : subscriberList) { this.getSqlMapClient().update(Subscriber_updateSubscriber, subscriber); } ListBatchResult batchResult = this.getSqlMapClient().executeBatchDetailed(); But I