Hello,
I think I have found a depencency on java 1.4 in some of the custom sql code. I have debugged into
org.hibernate.loader.custom.SQLQueryReturnProcessor
and found the following line of code:
private void addPersister(boolean useGeneratedAliases, Map propertyResult, SQLLoadable persister) {
this.persisters.add(persister);
this.propertyResults.add(propertyResult);
this.aliasModes.add(Boolean.valueOf(useGeneratedAliases));
}
the method Boolean.valueOf(boolean flag);
does not exist in JSDK 1.3.1
Do I need to raise an issue for this?
I shall continue my investigations but would welcome any help
Many Thanks,
Ben
Hibernate version: 3.0.5
Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.du.ezmarket.business.marketbasket.MarketBasketImpl" table="tblmarketbasket">
<id name="id" column="id" type="com.du.ezmarket.integration.marketbasket.DomainObjectType">
</id>
<set name="lines" table="tblbasketline" fetch="join">
<key column="fk_basket_id"/>
<many-to-many column="fk_auctionline_id"
unique="true"
class="com.du.ezmarket.business.parallelnegotiation.AuctionLineImpl"/>
</set>
<property name="allowBidComments" />
<property name="allowProxyBidding"/>
<property name="bidDecrementIncrement" column="BIDDECR" />
<property name="displayBidIncDec" column="BIDINCDEC" />
<property name="calculateDecFrom" column="CALCULATEINCDECFROM" />
<property name="description"/>
<property name="displayReservePrice"/>
<property name="displayStartingPrice"/>
<property name="forceBidDecr" />
<property name="forceReservePrice" column="FORCERESERVE"/>
<property name="forceStartingPrice" column="FORCESTARTPRICE"/>
<property name="auctionHeaderId" column="FK_AUCTIONHEADERID" />
<property name="incDecType" column="INCDETYPE" />
<property name="displayLastBid" column="LASTBID" />
<property name="name" />
<property name="reservePrice"/>
<property name="displayReserveMet" column="SHOWRESERVEMET"/>
<property name="startingPrice"/>
<property name="displaySuggestedBid" column="SUGGESTEDBID"/>
<property name="displayWinningIndicator" column="WINNINGINDICATOR"/>
</class>
<class name="com.du.ezmarket.business.parallelnegotiation.AuctionLineImpl" table="tblauctionline">
<id name="id" column="id" type="com.du.ezmarket.integration.marketbasket.DomainObjectType">
</id>
<property name="name" column="partNumber"/>
<property name="bidStartingPrice" column="bidStartingPrice"/>
<property name="reservePrice" column="reserveprice"/>
<property name="quantity" column="quantity"/>
<property name="BidDecrement" column="BidDecrement"/>
</class>
<sql-query name="findBasketsByHeaderId">
<return alias="marketbasket" class="com.du.ezmarket.business.marketbasket.MarketBasketImpl"/>
SELECT
tblmarketbasket.ID AS {marketbasket.id},
tblmarketbasket.NAME AS {marketbasket.name},
tblmarketbasket.description AS {marketbasket.description},
tblmarketbasket.allowBidComments AS {marketbasket.allowBidComments},
tblmarketbasket.allowProxyBidding AS {marketbasket.allowProxyBidding},
tblmarketbasket.BIDDECR AS {marketbasket.bidDecrementIncrement},
tblmarketbasket.BIDINCDEC AS {marketbasket.displayBidIncDec},
tblmarketbasket.CALCULATEINCDECFROM AS {marketbasket.calculateDecFrom},
tblmarketbasket.displayReservePrice AS {marketbasket.displayReservePrice},
tblmarketbasket.displayStartingPrice AS {marketbasket.displayStartingPrice},
tblmarketbasket.forceBidDecr AS {marketbasket.forceBidDecr},
tblmarketbasket.FORCERESERVE AS {marketbasket.forceReservePrice},
tblmarketbasket.FORCESTARTPRICE AS {marketbasket.forceStartingPrice},
tblmarketbasket.FK_AUCTIONHEADERID AS {marketbasket.auctionHeaderId},
tblmarketbasket.INCDETYPE AS {marketbasket.incDecType},
tblmarketbasket.LASTBID AS {marketbasket.displayLastBid},
tblmarketbasket.reservePrice AS {marketbasket.reservePrice},
tblmarketbasket.SHOWRESERVEMET AS {marketbasket.displayReserveMet},
tblmarketbasket.startingPrice AS {marketbasket.startingPrice},
tblmarketbasket.SUGGESTEDBID AS {marketbasket.displaySuggestedBid},
tblmarketbasket.WINNINGINDICATOR AS {marketbasket.displayWinningIndicator}
FROM tblmarketbasket
WHERE tblmarketbasket.FK_AUCTIONHEADERID= :headerId
</sql-query>
<sql-query name="findStandAloneLinesByHeaderId">
<return alias="auctionline" class="com.du.ezmarket.business.parallelnegotiation.AuctionLineImpl"/>
SELECT
tblauctionline.ID AS {auctionline.id},
tblauctionline.partnumber AS {auctionline.name},
tblauctionline.bidStartingPrice AS {auctionline.bidStartingPrice},
tblauctionline.quantity AS {auctionline.quantity},
tblauctionline.reservePrice AS {auctionline.reservePrice},
tblauctionline.BidDecrement AS {auctionline.BidDecrement}
FROM tblauctionline
WHERE tblauctionline.AUCTIONHEADERID= :headerId
and tblauctionline.ID not in (select tblbasketline.fk_auctionline_id from tblbasketline)
</sql-query>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():
List lines = session.getNamedQuery("findStandAloneLinesByHeaderId").setLong("headerId",marketID.longValue().longValue()) .list();
Full stack trace of any exception that occurs:
[20/06/05 08:50:47:640 GMT] 41ab41ab CommerceSrvr E com.ibm.commerce.command.ECCommandTarget executeCommand CMN0420E: The following CommandException occurred during processing: "java.lang.NoSuchMethodError: java/lang/Boolean.valueOf(Z)Ljava/lang/Boolean;".java.lang.NoSuchMethodError: java/lang/Boolean.valueOf(Z)Ljava/lang/Boolean;
at java.lang.Throwable.<init>(Throwable.java)
at java.lang.Throwable.<init>(Throwable.java)
at java.lang.NoSuchMethodError.<init>(NoSuchMethodError.java:56)
at org.hibernate.loader.custom.SQLQueryReturnProcessor.addPersister(SQLQueryReturnProcessor.java:133)
at org.hibernate.loader.custom.SQLQueryReturnProcessor.processRootReturn(SQLQueryReturnProcessor.java)
at org.hibernate.loader.custom.SQLQueryReturnProcessor.processReturn(SQLQueryReturnProcessor.java:98)
at org.hibernate.loader.custom.SQLQueryReturnProcessor.process(SQLQueryReturnProcessor.java)
at org.hibernate.loader.custom.SQLCustomQuery.<init>(SQLCustomQuery.java)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java)
at com.du.ezmarket.integration.marketbasket.MarketBasketHibernateCustomFinder.findBasketsByMarketId(MarketBasketHibernateCustomFinder.java)
at com.du.ezmarket.business.transport.marketbasket.AuctionSummaryDTOBuilder.getAuctionBasketSummary(AuctionSummaryDTOBuilder.java)
at com.du.ezmarket.reverseauction.controllercommands.AuctionSummaryRedirectorCmdImpl.performExecute(AuctionSummaryRedirectorCmdImpl.java:83)
at com.ibm.commerce.command.ECCommandTarget.executeCommand(ECCommandTarget.java:132)
at com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCache.java:282)
at com.ibm.websphere.command.CacheableCommandImpl.execute(CacheableCommandImpl.java:161)
at com.ibm.commerce.command.AbstractECTargetableCommand.execute(AbstractECTargetableCommand.java:175)
at com.ibm.commerce.webcontroller.ControllerCmdExecUnit.execute(ControllerCmdExecUnit.java:193)
at com.ibm.commerce.webcontroller.WebController.executeTransaction(WebController.java:222)
at com.ibm.commerce.webcontroller.WebController.processRequest(WebController.java:877)
at com.ibm.commerce.adapter.AbstractHttpAdapter.processRequest(AbstractHttpAdapter.java:330)
at com.ibm.commerce.server.RequestServlet$2.run(RequestServlet.java:1504)
at com.ibm.commerce.server.RequestServlet.service(RequestServlet.java:1574)
at com.du.ezmarket.reverseauction.servlets.EZMRequestServlet.service(EZMRequestServlet.java:85)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:76)
at com.ibm.commerce.dynacache.filter.CacheFilter$1.run(CacheFilter.java:359)
at com.ibm.commerce.dynacache.filter.CacheFilter.doFilter(CacheFilter.java:396)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:939)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:610)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:435)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)
Name and version of the database you are using:
DB2
The generated SQL (show_sql=true):
not got that fae
Debug level Hibernate log excerpt:
|