You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by ds...@excite.com on 2005/06/07 00:06:27 UTC

multiple resultsets question

quick question on using oracle with multiple resultsets bound as output parameters:

Will multiple these be able to be mapped to object properly?

also is this done via the parameter map instead of resultmap?

thanks

DS






 --- On Mon 06/06, Wulf, Andrew < AHWulf@firstcommand.com > wrote:
From: Wulf, Andrew [mailto: AHWulf@firstcommand.com]
To: ibatis-user-java@incubator.apache.org
Date: Mon, 6 Jun 2005 16:34:20 -0500
Subject: RE: Unexplained exception in GeneralStatement.executeQueryForObject

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6603.0">
<TITLE>RE: Unexplained exception in GeneralStatement.executeQueryForObject</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Hmm another tidbit:</FONT>
</P>

<P><FONT FACE="Arial">--- Cause: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] </FONT></P>

<P><FONT FACE="Arial">Was the actual exception, which is some hideous internal oracle exception. So the only issue is why do I get:</FONT>
</P>

<P><FONT SIZE=2 FACE="Arial">java.lang.NoClassDefFoundError: com/ibatis/sqlmap/engine/transaction/TransactionException</FONT>
</P>
<BR>
<UL>
<P><FONT FACE="Arial"></FONT>�<FONT SIZE=1 FACE="Tahoma">-----Original Message-----</FONT>

<BR><B><FONT SIZE=1 FACE="Tahoma">From: �</FONT></B> <FONT SIZE=1 FACE="Tahoma">Wulf, Andrew� </FONT>

<BR><B><FONT SIZE=1 FACE="Tahoma">Sent:��</FONT></B> <FONT SIZE=1 FACE="Tahoma">Monday, June 06, 2005 4:30 PM</FONT>

<BR><B><FONT SIZE=1 FACE="Tahoma">To:����</FONT></B> <FONT SIZE=1 FACE="Tahoma">'ibatis-user-java@incubator.apache.org'</FONT>

<BR><B><FONT SIZE=1 FACE="Tahoma">Subject:�������</FONT></B> <FONT SIZE=1 FACE="Tahoma">Unexplained exception in GeneralStatement.executeQueryForObject</FONT>
</P>

<P><FONT SIZE=2 FACE="Arial">In 2.1.0.565 I get this exception which makes little sense to me. Running on Weblogic 8.1 JDK 1.42. Basically it gets to line 100 and never returns. The database is Oracle 10g. The code worked fine on the prior version of ibatis. The NoClassDefFoundError seems a bit odd since I see the class in the jar. I see no evidence of the prior version anywhere in the domain...</FONT></P>

<P><FONT SIZE=2 FACE="Arial"><Jun 6, 2005 4:10:44 PM CDT> <Error> <HTTP> <BEA-101017> <[ServletContext(id=27579072,name=mapserver,context-path=/maps</FONT>

<BR><FONT SIZE=2 FACE="Arial">rver)] Root cause of ServletException.</FONT>

<BR><FONT SIZE=2 FACE="Arial">java.lang.NoClassDefFoundError: com/ibatis/sqlmap/engine/transaction/TransactionException</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:100)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:561)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:536)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:97)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:69)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at com.firstcommand.services.maps.dataaccess.Access.fetchAgent(Unknown Source)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at com.firstcommand.services.maps.MapServlet.doGet(MapServlet.java:80)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)</FONT>


<BR><FONT SIZE=2 FACE="Arial">������� at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)</FONT>


<BR><FONT SIZE=2 FACE="Arial">������� at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1006)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6718)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3764)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2644)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)</FONT>

<BR><FONT SIZE=2 FACE="Arial">������� at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)</FONT>
</P>

<P><FONT SIZE=2 FACE="Arial">- Andrew</FONT>
</P>
<BR>
</UL>
</BODY>
</HTML><p>STATEMENT OF CONFIDENTIALITY:     The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure.   Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer.<br>

_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!