Return-Path: Delivered-To: apmail-ibatis-dev-archive@www.apache.org Received: (qmail 81354 invoked from network); 21 Jun 2006 19:19:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 21 Jun 2006 19:19:57 -0000 Received: (qmail 16366 invoked by uid 500); 21 Jun 2006 19:19:57 -0000 Delivered-To: apmail-ibatis-dev-archive@ibatis.apache.org Received: (qmail 16225 invoked by uid 500); 21 Jun 2006 19:19:56 -0000 Mailing-List: contact dev-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ibatis.apache.org Delivered-To: mailing list dev@ibatis.apache.org Received: (qmail 16214 invoked by uid 99); 21 Jun 2006 19:19:56 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Jun 2006 12:19:56 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [209.237.227.198] (HELO brutus.apache.org) (209.237.227.198) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Jun 2006 12:19:55 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 91EBF410006 for ; Wed, 21 Jun 2006 19:18:30 +0000 (GMT) Message-ID: <33493192.1150917510594.JavaMail.jira@brutus> Date: Wed, 21 Jun 2006 19:18:30 +0000 (GMT+00:00) From: "Larry Meadors (JIRA)" To: dev@ibatis.apache.org Subject: [jira] Commented: (IBATIS-312) Select without where clause after table name causes Exception In-Reply-To: <18528723.1150882169893.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ http://issues.apache.org/jira/browse/IBATIS-312?page=comments#action_12417162 ] Larry Meadors commented on IBATIS-312: -------------------------------------- That looks like an oracle error, not an ibatis error. Does the statement get logged correctly? Can you run it from another tool like squirrel? > Select without where clause after table name causes Exception > ------------------------------------------------------------- > > Key: IBATIS-312 > URL: http://issues.apache.org/jira/browse/IBATIS-312 > Project: iBatis for Java > Type: Bug > Components: SQL Maps > Versions: 2.1.7 > Environment: Oracle 8.1.7 > jdk 1.3.1 > Reporter: Florent Carpentier > > I have the following query: > > that causes this: > com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in Card.xml. > --- The error occurred while applying a result map. > --- Check the getCardList-AutoResultMap. > --- The error happened while setting a property on the result object. > --- Cause: java.lang.NullPointerException > Caused by: java.lang.NullPointerException > at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:188) > at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123) > at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610) > at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584) > at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:101) > at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:78) > at Main.run(Main.java:39) > at Main.main(Main.java:25) > Caused by: > java.lang.NullPointerException > at oracle.jdbc.ttc7.MAREngine.buffer2Value(MAREngine.java(Compiled Code)) > at oracle.jdbc.ttc7.MAREngine.unmarshalUB4(MAREngine.java:864) > at oracle.jdbc.ttc7.TTIoer.unmarshal(TTIoer.java:138) > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:541) > at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1478) > at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:969) > at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:267) > at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:393) > at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) > at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205) > at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173) > at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123) > at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610) > at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584) > at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:101) > at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:78) > at Main.run(Main.java:39) > at Main.main(Main.java:25) > Exception in thread "main" > If I write it like this: > > or just add something after the table name (where clause or just a space), it works. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira