J2EE Car Rental Example

[Former Member]

I have deployed the ear file and followed all the steps(I think) mentioned in the example. However, when I try to run it in the browser, I get the following error:

Application error occurs during processing the request.

Details: com.sap.engine.services.ejb.exceptions.BaseEJBException: Exception in method viewActiveBookings.

at com.sap.examples.quickcarrental.QuickOrderProcessorLocalLocalObjectImpl0.viewActiveBookings(QuickOrderProcessorLocalLocalObjectImpl0.java:269)

at com.sap.examples.quickcarrental.servlet.QuickReservationServlet.viewAllBookings(QuickReservationServlet.java:152)

at com.sap.examples.quickcarrental.servlet.QuickReservationServlet.doWork(QuickReservationServlet.java:51)

at com.sap.examples.quickcarrental.servlet.QuickReservationServlet.doGet(QuickReservationServlet.java:29)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:385)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:263)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:337)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:315)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:815)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:238)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:147)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:37)

at com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run(UnorderedChannel.java:71)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:151)

Caused by: com.sap.engine.services.ejb.exceptions.BaseEJBException: Exception in method com.sap.examples.quickcarrental.QuickBookingLocalHomeImpl0.findByStatus(java.lang.String).

at com.sap.examples.quickcarrental.QuickBookingLocalHomeImpl0.findByStatus(QuickBookingLocalHomeImpl0.java:713)

at com.sap.examples.quickcarrental.QuickOrderProcessorBean.viewActiveBookings(QuickOrderProcessorBean.java:124)

at com.sap.examples.quickcarrental.QuickOrderProcessorLocalLocalObjectImpl0.viewActiveBookings(QuickOrderProcessorLocalLocalObjectImpl0.java:251)

... 19 more

Caused by: com.sap.engine.services.ejb.exceptions.BaseEJBException: Exception in method QuickBookingBean0.FindByStatus(java.lang.String).

at com.sap.examples.quickcarrental.QuickBookingBean0PM.ejbFindByStatus(QuickBookingBean0PM.java:401)

at com.sap.examples.quickcarrental.QuickBookingLocalHomeImpl0.findByStatus(QuickBookingLocalHomeImpl0.java:685)

... 21 more

Caused by: com.sap.sql.log.OpenSQLException: The SQL statement "SELECT "b"."BOOKINGID" FROM "QCR_RESERVATION" "b" WHERE "b"."STATUS" LIKE ?" contains the semantics error[s]: column "b.BOOKINGID" not in any scope

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:106)

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:145)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.check(StatementAnalyzerImpl.java:45)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:124)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:107)

at com.sap.sql.jdbc.common.CommonPreparedStatement.<init>(CommonPreparedStatement.java:154)

at com.sap.sql.jdbc.common.CommonConnectionImpl.prepareStatement(CommonConnectionImpl.java:255)

at com.sap.engine.services.dbpool.cci.ConnectionHandle.prepareStatement(ConnectionHandle.java:81)

at com.sap.examples.quickcarrental.QuickBookingBean0PM.ejbFindByStatus(QuickBookingBean0PM.java:363)

... 22 more

Caused by: com.sap.sql.sqlparser.CommonSQLParserException: column "b.BOOKINGID" not in any scope

at com.sap.sql.sqlparser.CommonSQLStatement.checkSemantics(CommonSQLStatement.java:185)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.check(StatementAnalyzerImpl.java:41)

... 28 more

Any ideas?

[Former Member]

Hi,

I would guess that the column bookingid ist named somehow else since the sql error message is stating that this column is not known. I would check for spelling errors in the sql statement.

Best Regards, Astrid