Once you guys have figured out whether it's a primitive mapping problem and the correct stack trace/line numbers...let me know.
If it is an iBATIS problem, I'll give you a hand looking for the issue. The N+1 stuff is a bit tough to navigate. I am always embarassed when an NPE is thrown...there's no good excuse for it. So I really hope its not the iBATIS code. ;-) Regards, Clinton On 12/4/06, Jeff Butler <[EMAIL PROTECTED]> wrote:
Something is very odd. The line numbers in the stack trace are nowhere near the current line numbers - I had to go back over 2 years to find a match. So I think part of the problem is that there is a really old version of iBATIS somewhere in your classpath. Please make sure that you are using a current version of iBATIS, and that all old version are removed from the classpath. That should help a lot! Jeff Butler On 12/4/06, Warren <[EMAIL PROTECTED]> wrote: > > I tried changing the int properties to Integer and I am still getting > the same exceptions. I guess it is time to give up. Thanks for everyones > > help. > > Warren wrote: > > I will give it a try. I don't seem to have this problem with other > > sqlMaps I am using. This is the first n+1 I have tried. Is this the > > Exception that leads you to believe that it is a primitive mapping > > problem: > > > > > com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getPrimitiveResultMappingValue > (BasicResultMap.java:268) > > > > > > Jeff Butler wrote: > >> Thanks for the stack trace. > >> > >> I'll have to look into this a little further. iBATIS is a little > >> finicky when it comes to using primitive types. You might have > >> better luck if you changed to using Integer instead of int for the > >> primary keys. > >> > >> Jeff Butler > >> > >> > >> On 12/1/06, *Warren* <[EMAIL PROTECTED] > >> <mailto: [EMAIL PROTECTED]>> wrote: > >> > >> Caused by: com.ibatis.dao.client.DaoException: Error executing > >> query for > >> list. Cause: com.ibatis.common.jdbc.exception.NestedSQLException: > >> --- The error occurred in > >> > >> com/clarks/spanky/persistence/sqlmapdao/sql/postgres/batchOrder- > postgres.xml. > >> > >> > >> --- The error occurred while applying a result map. > >> --- Check the BatchOrder.catItemsResults. > >> --- Check the result mapping for the 'items' property. > >> --- Cause: java.lang.NullPointerException > >> Caused by: java.lang.NullPointerException > >> Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: > >> --- The error occurred in > >> com/clarks/spanky/persistence/sqlmapdao/sql/postgres/batchOrder- > >> postgres.xml. > >> > >> --- The error occurred while applying a result map. > >> --- Check the BatchOrder.catItemsResults. > >> --- Check the result mapping for the 'items' property. > >> --- Cause: java.lang.NullPointerException > >> Caused by: java.lang.NullPointerException > >> at > >> > >> > com.clarks.spanky.persistence.sqlmapdao.BaseSqlMapDao.executeQueryForList( > BaseSqlMapDao.java:35) > >> > >> at > >> > >> > com.clarks.spanky.persistence.sqlmapdao.BatchOrderSqlMapDao.getBatchedItemPromoPrices > >> > >> (BatchOrderSqlMapDao.java :270) > >> ... 34 more > >> Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: > >> --- The error occurred in > >> > >> com/clarks/spanky/persistence/sqlmapdao/sql/postgres/batchOrder- > postgres.xml > >> > >> . > >> > >> --- The error occurred while applying a result map. > >> --- Check the BatchOrder.catItemsResults. > >> --- Check the result mapping for the 'items' property. > >> --- Cause: java.lang.NullPointerException > >> Caused by: java.lang.NullPointerException > >> at > >> > >> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback( > GeneralStatement.java:155) > >> > >> at > >> > >> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList > >> > >> (GeneralStatement.java:95) > >> at > >> > >> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList( > SqlMapExecutorDelegate.java:247) > >> > >> at > >> > >> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList ( > SqlMapExecutorDelegate.java > >> > >> :232) > >> at > >> > >> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList( > SqlMapSessionImpl.java:71) > >> > >> at > >> > >> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList( > SqlMapClientImpl.java:49) > >> > >> at > >> > >> > com.clarks.spanky.persistence.sqlmapdao.BaseSqlMapDao.executeQueryForList > >> > >> (BaseSqlMapDao.java:32) > >> ... 35 more > >> Caused by: java.lang.NullPointerException > >> at > >> > >> > com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getPrimitiveResultMappingValue( > BasicResultMap.java:268) > >> > >> at > >> > >> com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getResults( > BasicResultMap.java:107) > >> > >> at > >> > >> com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults( > SqlExecutor.java:274) > >> > >> at > >> com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery > >> (SqlExecutor.java :125) > >> at > >> > >> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery > (GeneralStatement.java:172) > >> > >> at > >> > >> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback > >> > >> (GeneralStatement.java:139) > >> ... 41 more > >> > >> > >> Jeff Butler wrote: > >> > Sorry for your frustration, but you'll have to tell us where > the > >> > NullPointerException is coming from. Could you post a stack > >> trace? > >> > > >> > Jeff Butler > >> > > >> > >
