Nathan Maves | 2 Nov 2009 03:29
Picon

[Announcement] iBATIS 3.0 beta 5 released

Only a few minor issues were submitted over the last few weeks, and all have been addressed. It's been pretty quiet, and so I'm gaining more confidence in this release. Could Beta 5 be the one that goes GA? Only you can say for sure. Give it a try, and let us know!

The java downloads can be found at the following link.  


The releases has also been posted to the maven2 repositories.


We welcome all feedback, and the sooner we get it the faster the community can move iBATIS 3.0 into GA!

Enjoy,

iBATIS Team
Mahesh219 | 2 Nov 2009 06:07
Picon

iBatis API for fetching the sqlmap queries

Hi, We are using iBatis 3 with Spring. We wish to provide our DAOs with both, Spring's JdbcTemplate and iBatis SqlMapClientTemplate facilities. Does iBatis provide a way to fetch the queries defined in one of the xmls using the id attribute programmatically? Any help is highly appreciated. Regards, Mahesh

View this message in context: iBatis API for fetching the sqlmap queries
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Martin Ellis | 2 Nov 2009 15:19
Picon

Re: [Announcement] iBATIS 3.0 beta 5 released

On Mon, Nov 2, 2009 at 2:29 AM, Nathan Maves <nathan.maves <at> gmail.com> wrote:
> Only a few minor issues were submitted over the last few weeks, and all have
> been addressed. It's been pretty quiet, and so I'm gaining more confidence
> in this release. Could Beta 5 be the one that goes GA? Only you can say for
> sure. Give it a try, and let us know!

Are you only considering bugs, and not new features here?

There was no activity on the SLF4J patch I submitted:
https://issues.apache.org/jira/browse/IBATIS-678

Martin
abdesai | 2 Nov 2009 16:05
Favicon

iBatis queryforList not working for dynamic Stored Proc


Hi ppl,

I am using iBatis to call a stored proc, which in turn calls 6 other stored
procs, resulting in 7 resultSets.

Everything was working fine earlier. Later, I changed the 2nd stored
proc(SP) to take in an additional OPTIONAL variable, (declare  <at> var int =
null), and then, changed the SP to be dynamic i.e. it builds a where clause
dynamically depending on  <at> var variable.

    if  <at> var is not null
        select  <at> l_var = " and a.var = " + convert(varchar(20),  <at> var)

    exec("select ..... 
	from .....
	where 1=1 " +  <at> l_var
        + " and ......"
        )

Does iBatis support such dynamic StoredProcs?

This throws the following error:
================================================================
java.lang.IndexOutOfBoundsException: Index: 1, Size: 1
	at java.util.ArrayList.RangeCheck(ArrayList.java:547)
	at java.util.ArrayList.get(ArrayList.java:322)
	at
com.nomura.rdp.rdmgateway.dao.impl.OrganisationDaoImpl.findByRDMId(OrganisationDaoImpl.java:92)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at
org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
	at
com.nomura.rdp.rdmgateway.interceptor.PerformanceMonitorInterceptor.doPerformanceMonitor(PerformanceMonitorInterceptor.java:39)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
	at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
	at
org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at $Proxy22.findByRDMId(Unknown Source)
	at
com.nomura.rdp.rdmgateway.business.OrganisationBo.findByRDMId(OrganisationBo.java:68)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at
org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:54)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at $Proxy23.findByRDMId(Unknown Source)
	at
com.nomura.rdp.rdmgateway.service.impl.OrganisationServiceImpl.findByRDMId(OrganisationServiceImpl.java:62)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at
org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:54)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at $Proxy23.findByRDMId(Unknown Source)
	at
com.nomura.rdp.rdmgateway.service.OrganisationServiceTest.findByRDMIdusingFinderHelper(OrganisationServiceTest.java:94)
	at
com.nomura.rdp.rdmgateway.service.OrganisationServiceTest.findByRDMIdusingFinder(OrganisationServiceTest.java:66)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at
org.springframework.test.context.junit4.SpringTestMethod.invoke(SpringTestMethod.java:160)
	at
org.springframework.test.context.junit4.SpringMethodRoadie.runTestMethod(SpringMethodRoadie.java:233)
	at
org.springframework.test.context.junit4.SpringMethodRoadie$RunBeforesThenTestThenAfters.run(SpringMethodRoadie.java:333)
	at
org.springframework.test.context.junit4.SpringMethodRoadie.runWithRepetitions(SpringMethodRoadie.java:217)
	at
org.springframework.test.context.junit4.SpringMethodRoadie.runTest(SpringMethodRoadie.java:197)
	at
org.springframework.test.context.junit4.SpringMethodRoadie.run(SpringMethodRoadie.java:143)
	at
org.springframework.test.context.junit4.SpringJUnit4ClassRunner.invokeTestMethod(SpringJUnit4ClassRunner.java:160)
	at
org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:51)
	at
org.junit.internal.runners.JUnit4ClassRunner$1.run(JUnit4ClassRunner.java:44)
	at
org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:27)
	at org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:37)
	at
org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner.java:42)
	at
org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:97)
	at
org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
	at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
	at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
	at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
	at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

================================================================
--

-- 
View this message in context: http://old.nabble.com/iBatis-queryforList-not-working-for-dynamic-Stored-Proc-tp26157123p26157123.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Clinton Begin | 2 Nov 2009 16:55
Picon

Re: iBatis API for fetching the sqlmap queries

Yes, you can introspect on the full iBATIS configuration at runtime by grabbing the Configuration instance from the SqlSessionFactory.  It has lists and maps of various configuration components.

Clinton

On Sun, Nov 1, 2009 at 10:07 PM, Mahesh219 <maheshforjava <at> gmail.com> wrote:
Hi, We are using iBatis 3 with Spring. We wish to provide our DAOs with both, Spring's JdbcTemplate and iBatis SqlMapClientTemplate facilities. Does iBatis provide a way to fetch the queries defined in one of the xmls using the id attribute programmatically? Any help is highly appreciated. Regards, Mahesh
View this message in context: iBatis API for fetching the sqlmap queries
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Clinton Begin | 2 Nov 2009 16:56
Picon

Re: [Announcement] iBATIS 3.0 beta 5 released

No new features will be added in the Beta cycle.  It's stabilization and bug fixes only.

Clinton

On Mon, Nov 2, 2009 at 7:19 AM, Martin Ellis <ellis.m.a <at> gmail.com> wrote:
On Mon, Nov 2, 2009 at 2:29 AM, Nathan Maves <nathan.maves <at> gmail.com> wrote:
> Only a few minor issues were submitted over the last few weeks, and all have
> been addressed. It's been pretty quiet, and so I'm gaining more confidence
> in this release. Could Beta 5 be the one that goes GA? Only you can say for
> sure. Give it a try, and let us know!

Are you only considering bugs, and not new features here?

There was no activity on the SLF4J patch I submitted:
https://issues.apache.org/jira/browse/IBATIS-678

Martin

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
For additional commands, e-mail: user-java-help <at> ibatis.apache.org


Martin Ellis | 2 Nov 2009 17:24
Picon

Re: [Announcement] iBATIS 3.0 beta 5 released

On Mon, Nov 2, 2009 at 3:56 PM, Clinton Begin <clinton.begin <at> gmail.com> wrote:
> No new features will be added in the Beta cycle.  It's stabilization and bug
> fixes only.

OK.

On Mon, Nov 2, 2009 at 2:29 AM, Nathan Maves <nathan.maves <at> gmail.com wrote:
>> > Could Beta 5 be the one that goes GA? Only you can say
>> > for sure. Give it a try, and let us know!

Beta 5 seems to work OK here.  At least, it passes our integration tests.
It's a new app, and we've no load/stress tests yet, so can't say
anything more useful than that, I'm afraid.

Martin
Kai Grabfelder | 2 Nov 2009 18:14
Picon
Favicon

Re: java.io.EOFException

I never had problems with mySql and selectKey. Have you tried the solution that is proposed in the blog entry?

Regards

Kai

--- Original Nachricht ---
Absender: deligeli
Datum: 01.11.2009 00:57
> hi
> 
> i have read here:
> 
> http://www.mikesparr.com/2007/04/07/ibatis-mysql-communications-line-failure-fix/
> 
> that the problem is with the selectKey.
> 
> does it mean that selectKey doesn't work? how can i make it work please?
> 
> 
> deligeli wrote:
>> 
>> hi!
>> 
>> i got this message recently:
>> 
>> ERROR,11:50:57 - Error calling Connection.prepareStatement:
>> java.sql.SQLException: No operations allowed after connection
>> closed.Connection was implicitly closed due to underlying exception/error:
>> 
>> 
>> ** BEGIN NESTED EXCEPTION **
>> 
>> com.mysql.jdbc.CommunicationsException
>> MESSAGE: Communications link failure due to underlying exception:
>> 
>> ** BEGIN NESTED EXCEPTION **
>> 
>> java.io.EOFException
>> 
>> STACKTRACE:
>> 
>> java.io.EOFException
>> at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
>> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380)
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
>> at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
>> at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:4913)
>> at com.mysql.jdbc.Connection.rollback(Connection.java:4810)
>> at
>> com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:629)
>> 
>> 
>> i reach the database like this:
>> <settings cacheModelsEnabled="true" />
>> 	<transactionManager type="JDBC" commitRequired="false">
>> 		<dataSource type="SIMPLE">
>> 			<property value="${driver}" name="JDBC.Driver" />
>> 			<property value="${url}" name="JDBC.ConnectionURL" />
>> 			<property value="${username}" name="JDBC.Username" />
>> 			<property value="${password}" name="JDBC.Password" />
>> 		</dataSource>
>> 	</transactionManager>
>> 
>> what is problem with it? why did it happen?
>> 
> 
Jeff Butler | 2 Nov 2009 20:39
Picon

Re: iBatis queryforList not working for dynamic Stored Proc

If I understand the question, it seems you are asking if ibatis
supports optional parameters for stored procedure calls. The simple
answer is "yes".

See the <if...> tag with ibatis 3 or the <isnotnull...> tag with ibatis 2.

Jeff Butler

On 11/2/09, abdesai <abhijit.desai <at> nomura.com> wrote:
>
> Hi ppl,
>
> I am using iBatis to call a stored proc, which in turn calls 6 other stored
> procs, resulting in 7 resultSets.
>
> Everything was working fine earlier. Later, I changed the 2nd stored
> proc(SP) to take in an additional OPTIONAL variable, (declare  <at> var int =
> null), and then, changed the SP to be dynamic i.e. it builds a where clause
> dynamically depending on  <at> var variable.
>
>     if  <at> var is not null
>         select  <at> l_var = " and a.var = " + convert(varchar(20),  <at> var)
>
>     exec("select .....
> 	from .....
> 	where 1=1 " +  <at> l_var
>         + " and ......"
>         )
>
> Does iBatis support such dynamic StoredProcs?
>
> This throws the following error:
> ================================================================
> java.lang.IndexOutOfBoundsException: Index: 1, Size: 1
> 	at java.util.ArrayList.RangeCheck(ArrayList.java:547)
> 	at java.util.ArrayList.get(ArrayList.java:322)
> 	at
> com.nomura.rdp.rdmgateway.dao.impl.OrganisationDaoImpl.findByRDMId(OrganisationDaoImpl.java:92)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
> 	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
> 	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
> 	at
> org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
> 	at
> com.nomura.rdp.rdmgateway.interceptor.PerformanceMonitorInterceptor.doPerformanceMonitor(PerformanceMonitorInterceptor.java:39)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at
> org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
> 	at
> org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
> 	at
> org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
> 	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> 	at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
> 	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> 	at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
> 	at $Proxy22.findByRDMId(Unknown Source)
> 	at
> com.nomura.rdp.rdmgateway.business.OrganisationBo.findByRDMId(OrganisationBo.java:68)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
> 	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
> 	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
> 	at
> org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:54)
> 	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> 	at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
> 	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> 	at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
> 	at $Proxy23.findByRDMId(Unknown Source)
> 	at
> com.nomura.rdp.rdmgateway.service.impl.OrganisationServiceImpl.findByRDMId(OrganisationServiceImpl.java:62)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
> 	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
> 	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
> 	at
> org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:54)
> 	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> 	at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
> 	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> 	at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
> 	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> 	at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
> 	at $Proxy23.findByRDMId(Unknown Source)
> 	at
> com.nomura.rdp.rdmgateway.service.OrganisationServiceTest.findByRDMIdusingFinderHelper(OrganisationServiceTest.java:94)
> 	at
> com.nomura.rdp.rdmgateway.service.OrganisationServiceTest.findByRDMIdusingFinder(OrganisationServiceTest.java:66)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at
> org.springframework.test.context.junit4.SpringTestMethod.invoke(SpringTestMethod.java:160)
> 	at
> org.springframework.test.context.junit4.SpringMethodRoadie.runTestMethod(SpringMethodRoadie.java:233)
> 	at
> org.springframework.test.context.junit4.SpringMethodRoadie$RunBeforesThenTestThenAfters.run(SpringMethodRoadie.java:333)
> 	at
> org.springframework.test.context.junit4.SpringMethodRoadie.runWithRepetitions(SpringMethodRoadie.java:217)
> 	at
> org.springframework.test.context.junit4.SpringMethodRoadie.runTest(SpringMethodRoadie.java:197)
> 	at
> org.springframework.test.context.junit4.SpringMethodRoadie.run(SpringMethodRoadie.java:143)
> 	at
> org.springframework.test.context.junit4.SpringJUnit4ClassRunner.invokeTestMethod(SpringJUnit4ClassRunner.java:160)
> 	at
> org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:51)
> 	at
> org.junit.internal.runners.JUnit4ClassRunner$1.run(JUnit4ClassRunner.java:44)
> 	at
> org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:27)
> 	at org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:37)
> 	at
> org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner.java:42)
> 	at
> org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:97)
> 	at
> org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
> 	at
> org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> 	at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> 	at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> 	at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> 	at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
>
>
>
> ================================================================
> --
> View this message in context:
> http://old.nabble.com/iBatis-queryforList-not-working-for-dynamic-Stored-Proc-tp26157123p26157123.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
> For additional commands, e-mail: user-java-help <at> ibatis.apache.org
>
>

--

-- 
Sent from my mobile device
Bhaarat Sharma | 4 Nov 2009 17:39
Picon
Gravatar

how to implement resultSetType and resultSetConcurrency in iBatis Stored Procedure.

We are using Oracle. 

we have an old JDBC call like this...

Conn.prepareCall("{call some_sp_name()}",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);

usually we make the following parameter map in our mapping. 

<procedure id="getMax" parameterMap="getMaxCall">{call some_sp_name()}</procedure>

  <parameterMap id="getDebtMaxUpdateNumCall" class="map">
    <parameter property="Result0" jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT" resultMap="getMaxResult"/>
  </parameterMap>

  <resultMap id="getMaxResult" class="java.util.HashMap">
    <result property="pk_value" column="pk_value"/>
  </resultMap>


but now that we have resultSetType and resultSetConcurrency parameters...how do we implement that in iBatis mapping?



Gmane