Thanks for your response Martina. I started the DB from NB and now I am getting the following error message:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.1 (Build b60e-fcs (12/23/2008))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WEB_BOOKSTORE_BOOKS' does not exist.
Error Code: -1
Call: SELECT BOOKID, FIRSTNAME, DESCRIPTION, PRICE, TITLE, ONSALE, SURNAME, CALENDAR_YEAR, INVENTORY FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?)
bind => [203]
Query: ReadObjectQuery(com.sun.bookstore.database.Book)
Here is the log file:
"Record Number
906
Message ID
StandardWrapperValve[BookStoreServlet]
Complete Message
PWC1406: Servlet.service() for servlet BookStoreServlet threw exception Local Exception
Stack: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.1 (Build b60e-fcs
(12/23/2008))): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception:
java.sql.SQLNonTransientConnectionException: A communications error has been detected:
Software caused connection abort: recv failed. Error Code: 40000 Call: SELECT BOOKID,
FIRSTNAME, DESCRIPTION, PRICE, TITLE, ONSALE, SURNAME, CALENDAR_YEAR, INVENTORY FROM
WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) bind => [203] Query:
ReadObjectQuery(com.sun.bookstore.database.Book) at
oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:3
19) at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(Database
Accessor.java:566) at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAcces
sor.java:452) at
oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:473) at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(D
atasourceCallQueryMechanism.java:228) at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(D
atasourceCallQueryMechanism.java:214) at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectOneRow(
DatasourceCallQueryMechanism.java:635) at
oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectOneRowFromT
able(ExpressionQueryMechanism.java:2453) at
oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectOneRow(Expr
essionQueryMechanism.java:2428) at
oracle.toplink.essentials.queryframework.ReadObjectQuery.executeObjectLevelReadQuery(ReadObj
ectQuery.java:365) at
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLev
elReadQuery.java:724) at
oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:628) at
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.j
ava:692) at
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLeve
lReadQuery.java:746) at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkIm
pl.java:2248) at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.jav
a:952) at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.jav
a:909) at
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerImpl.findInternal(EntityManage
rImpl.java:354) at
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerImpl.findInternal(EntityManage
rImpl.java:330) at
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.find(EntityManagerImpl.java:14
8) at com.sun.bookstore1.database.BookDBAO.getBook(BookDBAO.java:55) at
com.sun.bookstore1.servlets.BookStoreServlet.doGet(BookStoreServlet.java:75) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:734) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at
org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:4
27) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java
:333) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at
com.sun.bookstore1.filters.HitCounterFilter.doFilter(HitCounterFilter.java:71) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java
:246) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:313) at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:287)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:218) at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648) at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593) at
com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94) at
com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipel
ine.java:98) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:222) at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648) at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096) at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:166) at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648) at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096) at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:288) at
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessor
Task.java:647) at
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask
.java:579) at
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.j
ava:831) at
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTas
k.java:341) at
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263) at
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214) at
com.sun.enterprise.web.portunif.PortUnificationPipeline$PUTask.doTask(PortUnificationPipelin
e.java:380) at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265) at
com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)
Caused by: java.sql.SQLNonTransientConnectionException: A communications error has been
detected: Software caused connection abort: recv failed. at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source) at
org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at
org.apache.derby.client.am.Connection.prepareStatement(Unknown Source) at
com.sun.gjc.spi.base.ConnectionHolder.prepareStatement(ConnectionHolder.java:475) at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.prepareStatement(Database
Accessor.java:1162) at
oracle.toplink.essentials.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall
.java:612) at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(Database
Accessor.java:485) ... 55 more Caused by: org.apache.derby.client.am.DisconnectException: A
communications error has been detected: Software caused connection abort: recv failed. at
org.apache.derby.client.net.NetAgent.throwCommunicationsFailure(Unknown Source) at
org.apache.derby.client.net.Reply.fill(Unknown Source) at
org.apache.derby.client.net.Reply.ensureALayerDataInBuffer(Unknown Source) at
org.apache.derby.client.net.Reply.readDssHeader(Unknown Source) at
org.apache.derby.client.net.Reply.startSameIdChainParse(Unknown Source) at
org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source) at
org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source) at
org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source) at
org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source) at
org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
Source) at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source) at
org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source) ... 60 more Caused
by: java.net.SocketException: Software caused connection abort: recv failed at
java.net.SocketInputStream.socketRead0(Native Method) at
java.net.SocketInputStream.read(SocketInputStream.java:129) ... 72 more "
Record Number
906
Message ID
StandardWrapperValve[BookStoreServlet]
Complete Message
PWC1406: Servlet.service() for servlet BookStoreServlet threw exception Local Exception
Stack: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.1 (Build b60e-fcs
(12/23/2008))): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception:
java.sql.SQLNonTransientConnectionException: A communications error has been detected:
Software caused connection abort: recv failed. Error Code: 40000 Call: SELECT BOOKID,
FIRSTNAME, DESCRIPTION, PRICE, TITLE, ONSALE, SURNAME, CALENDAR_YEAR, INVENTORY FROM
WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) bind => [203] Query:
ReadObjectQuery(com.sun.bookstore.database.Book) at
oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:3
19) at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(Database
Accessor.java:566) at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAcces
sor.java:452) at
oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:473) at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(D
atasourceCallQueryMechanism.java:228) at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(D
atasourceCallQueryMechanism.java:214) at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectOneRow(
DatasourceCallQueryMechanism.java:635) at
oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectOneRowFromT
able(ExpressionQueryMechanism.java:2453) at
oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectOneRow(Expr
essionQueryMechanism.java:2428) at
oracle.toplink.essentials.queryframework.ReadObjectQuery.executeObjectLevelReadQuery(ReadObj
ectQuery.java:365) at
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLev
elReadQuery.java:724) at
oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:628) at
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.j
ava:692) at
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLeve
lReadQuery.java:746) at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkIm
pl.java:2248) at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.jav
a:952) at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.jav
a:909) at
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerImpl.findInternal(EntityManage
rImpl.java:354) at
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerImpl.findInternal(EntityManage
rImpl.java:330) at
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.find(EntityManagerImpl.java:14
8) at com.sun.bookstore1.database.BookDBAO.getBook(BookDBAO.java:55) at
com.sun.bookstore1.servlets.BookStoreServlet.doGet(BookStoreServlet.java:75) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:734) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at
org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:4
27) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java
:333) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at
com.sun.bookstore1.filters.HitCounterFilter.doFilter(HitCounterFilter.java:71) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java
:246) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:313) at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:287)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:218) at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648) at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593) at
com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94) at
com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipel
ine.java:98) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:222) at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648) at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096) at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:166) at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648) at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096) at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:288) at
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessor
Task.java:647) at
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask
.java:579) at
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.j
ava:831) at
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTas
k.java:341) at
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263) at
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214) at
com.sun.enterprise.web.portunif.PortUnificationPipeline$PUTask.doTask(PortUnificationPipelin
e.java:380) at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265) at
com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)
Caused by: java.sql.SQLNonTransientConnectionException: A communications error has been
detected: Software caused connection abort: recv failed. at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source) at
org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at
org.apache.derby.client.am.Connection.prepareStatement(Unknown Source) at
com.sun.gjc.spi.base.ConnectionHolder.prepareStatement(ConnectionHolder.java:475) at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.prepareStatement(Database
Accessor.java:1162) at
oracle.toplink.essentials.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall
.java:612) at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(Database
Accessor.java:485) ... 55 more Caused by: org.apache.derby.client.am.DisconnectException: A
communications error has been detected: Software caused connection abort: recv failed. at
org.apache.derby.client.net.NetAgent.throwCommunicationsFailure(Unknown Source) at
org.apache.derby.client.net.Reply.fill(Unknown Source) at
org.apache.derby.client.net.Reply.ensureALayerDataInBuffer(Unknown Source) at
org.apache.derby.client.net.Reply.readDssHeader(Unknown Source) at
org.apache.derby.client.net.Reply.startSameIdChainParse(Unknown Source) at
org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source) at
org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source) at
org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source) at
org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source) at
org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
Source) at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source) at
org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source) ... 60 more Caused
by: java.net.SocketException: Software caused connection abort: recv failed at
java.net.SocketInputStream.socketRead0(Native Method) at
java.net.SocketInputStream.read(SocketInputStream.java:129) ... 72 more
Regards,
i matua
[Message sent by forum member 'imatua' (imatua)]
http://forums.java.net/jive/thread.jspa?messageID=345149