RE: Need support for Dynamic procedure invocation

2010-05-24 Thread Nicky Jha
Joe/Jeff Please help. this class is not part of framework, this is approach, we have used in case our procedure changes at runtime, so will its parameter.For that we using public class DynamicProcedureParams { >> private String procedureName; >> private List params = new ArrayList(); >> >>

Re: Need support for Dynamic procedure invocation

2010-05-24 Thread Clinton Begin
I'm not familiar with that class, as it's not part of the framework (maybe post it here). Short story is that JDBC requires nullable column types to be specified. Ibatis allows for this in the parameter map (crack open the user guide and search for "jdbcType" for more). Cheers, Clinton On 201

Re: Need support for Dynamic procedure invocation

2010-05-24 Thread Clinton Begin
Are you setting the jdbcType in your parameter map for all nullable columns? Clinton On Mon, May 24, 2010 at 11:03 PM, Nicky Jha wrote: > > Hi > > with approach mentioned below(DynamicProcedureParams) , I want to also pass > some of parameter as null((private List params = new > ArrayList(); pa

Re: Need support for Dynamic procedure invocation

2010-05-24 Thread Nicky Jha
Hi with approach mentioned below(DynamicProcedureParams) , I want to also pass some of parameter as null((private List params = new ArrayList(); params.add(null))), but when I pass string value as null , it executes parametes procedure as call procname(?,?,?,?,?) Parameters: [#IMNT_RISK_SENSI

Re: Still see SQL in log for cached statements

2010-05-24 Thread Clinton Begin
With a read/write cache that is NOT serializable, it sort of eliminates any benefit of caching. This was a little confusing in iBATIS 2... but the only settings that really make sense together are: readOnly="true" serializable="false" readOnly="false" serializable="true" The first one is the def

Still see SQL in log for cached statements

2010-05-24 Thread Warren Bell
I am still seeing SQL for statements that should be cached when I turn logging on. Is that normal? And if so how do I know the cache is working? My cache configuration: serialize="false"> -- Thanks, Warren Bell ---

Re: iBATIS with Java, SQL Server 2008

2010-05-24 Thread Larry Meadors
It's super easy - I use the freetds jdbc driver and it just works. However, use mybatis instead: http://www.mybatis.org/ The entire ibatis development team has moved there instead of remaining with the ASF due to technological issues and philosophical differences. :) Larry -

iBATIS with Java, SQL Server 2008

2010-05-24 Thread Jane88
Hello, I am new to iBATIS and I am gethering information for a project. We have SQL Server 2005/2008 but I would like to use java and ibatis for the backend. Could some one tall me it is feasible and point me some direction to start with(example or tutorial ) ? Thanks in advance. -- View this me