[Rob Silver]

Problem that appears to be caused by the installation of an extra Derby server install outside of MyEclipseIde’s sandbox:

Please advise how do I get the sandbox version of Derby to work properly

I now get the following error when I try to run the sample project:
DWRSpringJPAExample

Please advise how do I fix this problem:
DWRSpringJPAExample

HTTP Status 500 –

——————————————————————————–

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /summary.jspf at line 12

9: .getRequiredWebApplicationContext(getServletContext());
10: CarManager manager = (CarManager) springContext
11: .getBean(“CarManager”);
12: String[] customerNames = manager.getCustomerNames();
13: String[] employeeNames = manager.getEmployeeNames();
14: String[] products = manager.getProductNames();
15: %>

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:435)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

Exception [TOPLINK-4002] (Oracle TopLink Essentials – 2.0 (Build b40-rc (03/21/2007))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
Error Code: -4499
oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:290)
oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:87)
oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:170)
oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:537)
oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206)
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:212)
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:111)
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:105)
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:379)
$Proxy15.createEntityManager(Unknown Source)
org.springframework.orm.jpa.EntityManagerFactoryAccessor.createEntityManager(EntityManagerFactoryAccessor.java:116)
org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:178)
org.springframework.orm.jpa.JpaTemplate.executeFind(JpaTemplate.java:152)
org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:299)
org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:295)
com.myeclipseide.examples.dwrspring.spring.CustomerDAO.findAll(CustomerDAO.java:155)
com.myeclipseide.examples.dwrspring.bean.CarManager.getCustomerNames(CarManager.java:31)
org.apache.jsp.index_jsp._jspService(index_jsp.java:134)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

java.sql.SQLTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(DriverManager.java:582)
java.sql.DriverManager.getConnection(DriverManager.java:154)
oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:85)
oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:170)
oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:537)
oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206)
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:212)
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:111)
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:105)
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:379)
$Proxy15.createEntityManager(Unknown Source)
org.springframework.orm.jpa.EntityManagerFactoryAccessor.createEntityManager(EntityManagerFactoryAccessor.java:116)
org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:178)
org.springframework.orm.jpa.JpaTemplate.executeFind(JpaTemplate.java:152)
org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:299)
org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:295)
com.myeclipseide.examples.dwrspring.spring.CustomerDAO.findAll(CustomerDAO.java:155)
com.myeclipseide.examples.dwrspring.bean.CarManager.getCustomerNames(CarManager.java:31)
org.apache.jsp.index_jsp._jspService(index_jsp.java:134)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

org.apache.derby.client.am.DisconnectException: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
org.apache.derby.client.net.NetAgent.<init>(Unknown Source)
org.apache.derby.client.net.NetConnection.newAgent_(Unknown Source)
org.apache.derby.client.am.Connection.<init>(Unknown Source)
org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
org.apache.derby.client.net.NetConnection40.<init>(Unknown Source)
org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown Source)
org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(DriverManager.java:582)
java.sql.DriverManager.getConnection(DriverManager.java:154)
oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:85)
oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:170)
oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:537)
oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206)
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:212)
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:111)
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:105)
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:379)
$Proxy15.createEntityManager(Unknown Source)
org.springframework.orm.jpa.EntityManagerFactoryAccessor.createEntityManager(EntityManagerFactoryAccessor.java:116)
org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:178)
org.springframework.orm.jpa.JpaTemplate.executeFind(JpaTemplate.java:152)
org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:299)
org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:295)
com.myeclipseide.examples.dwrspring.spring.CustomerDAO.findAll(CustomerDAO.java:155)
com.myeclipseide.examples.dwrspring.bean.CarManager.getCustomerNames(CarManager.java:31)
org.apache.jsp.index_jsp._jspService(index_jsp.java:134)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

java.net.ConnectException: Connection refused: connect
java.net.PlainSocketImpl.socketConnect(Native Method)
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
java.net.Socket.connect(Socket.java:519)
java.net.Socket.connect(Socket.java:469)
java.net.Socket.<init>(Socket.java:366)
java.net.Socket.<init>(Socket.java:180)
org.apache.derby.client.net.OpenSocketAction.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
org.apache.derby.client.net.NetAgent.<init>(Unknown Source)
org.apache.derby.client.net.NetConnection.newAgent_(Unknown Source)
org.apache.derby.client.am.Connection.<init>(Unknown Source)
org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
org.apache.derby.client.net.NetConnection40.<init>(Unknown Source)
org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown Source)
org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(DriverManager.java:582)
java.sql.DriverManager.getConnection(DriverManager.java:154)
oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:85)
oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:170)
oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:537)
oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206)
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:212)
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:111)
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:105)
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:379)
$Proxy15.createEntityManager(Unknown Source)
org.springframework.orm.jpa.EntityManagerFactoryAccessor.createEntityManager(EntityManagerFactoryAccessor.java:116)
org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:178)
org.springframework.orm.jpa.JpaTemplate.executeFind(JpaTemplate.java:152)
org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:299)
org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:295)
com.myeclipseide.examples.dwrspring.spring.CustomerDAO.findAll(CustomerDAO.java:155)
com.myeclipseide.examples.dwrspring.bean.CarManager.getCustomerNames(CarManager.java:31)
org.apache.jsp.index_jsp._jspService(index_jsp.java:134)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.13 logs.

[support-swapna]

rss245b,

Sorry that you are seeing this issue.

Did you start the sandbox Derby server manually on your computer ? Is it listening at port 1527?

You will have to start the sandbox Derby manually by double-clicking it in the Server’s view.

Please recheck and let us know how it works for you.

[Rob Silver]

I found the following console information which may make this problem clearer to understand.

TopLink Info]: 2012.05.11 11:30:21.142–ServerSession(19935173)–TopLink, version: Oracle TopLink Essentials – 2.0 (Build b40-rc (03/21/2007))
[TopLink Info]: 2012.05.11 11:30:24.949–ServerSession(19935173)–file:/C:/Users/Robert/ws00/.metadata/.me_tcat/webapps/DWRSpringJPA/WEB-INF/classes/-CLASSICCARS login successful
[TopLink Warning]: 2012.05.11 11:30:26.831–UnitOfWork(28965003)–Exception [TOPLINK-4002] (Oracle TopLink Essentials – 2.0 (Build b40-rc (03/21/2007))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Schema ‘CLASSICCARS’ does not exist
Error Code: -1
Call: SELECT CUSTOMERNUMBER, PHONE, ADDRESSLINE1, COUNTRY, ADDRESSLINE2, CONTACTLASTNAME, CITY, POSTALCODE, CONTACTFIRSTNAME, SALESREPEMPLOYEENUMBER, STATE, CREDITLIMIT, CUSTOMERNAME FROM CLASSICCARS.CUSTOMER
Query: ReportQuery(com.myeclipseide.examples.dwrspring.jpa.Customer)
May 11, 2012 11:30:26 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet jsp threw exception
org.apache.derby.client.am.SqlException: Schema ‘CLASSICCARS’ does not exist
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(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)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1147)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:597)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:470)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:465)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2240)
at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllReportQueryRows(ExpressionQueryMechanism.java:2206)
at oracle.toplink.essentials.queryframework.ReportQuery.executeDatabaseQuery(ReportQuery.java:774)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:731)
at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:346)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultList(EJBQueryImpl.java:453)
at org.springframework.orm.jpa.JpaTemplate$9.doInJpa(JpaTemplate.java:307)
at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:185)
at org.springframework.orm.jpa.JpaTemplate.executeFind(JpaTemplate.java:152)
at org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:299)
at org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:295)
at com.myeclipseide.examples.dwrspring.spring.CustomerDAO.findAll(CustomerDAO.java:155)
at com.myeclipseide.examples.dwrspring.bean.CarManager.getCustomerNames(CarManager.java:31)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:134)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)

[support-swapna]

rss245b ,

Thank you for the console information.

Can you switch to the MyEclipse Database Explorer view and browse the sandbox Derby to check if it contains the CLASSICCARS schema ?

[Rob Silver]

Yes I already did that. The problem is it does not work with my external derby database, however, I did get it working with MySQL although I have another issue I need to resolve in another thread. I still have a problem getting the sand box Derby server to configure and run. I would appreciate any trouble shooting tips you may give me..

[support-swapna]

rss245b,

Can you please answer some more questions for us to investigate further?

1. Do you want it to work with the sandbox Derby or the external Derby?

2. If you are trying with the sandbox Derby, is the sandbox Derby started when you try to run the application?

3. Is the external Derby running at the time when you are trying to run the application, and on the same port as the sandbox Derby?

4. If there is a port conflict, did you try changing the port in the sandbox Derby connector?

[Rob Silver]

I changed the port number from 1527 to 1528 on the sandbox and although MyEclipse shows it started – No way did it really start. There is no port showing when I do a
netstat -a|find “1528” or 1527 even when MyEclipse shows it started. Oh and I can not
shut down the server. Press the red square button says its shutting down but never does.

Only way to reset that is to shutdown myeclipse 4 spring.

[Rob Silver]

1. Do you want it to work with the sandbox Derby or the external Derby?
(Either)
2. If you are trying with the sandbox Derby, is the sandbox Derby started when you try to run the application?
(No)
3. Is the external Derby running at the time when you are trying to run the application, and on the same port as the sandbox Derby?
(no) – I have tried both. External Derby does setup a listening port but the database fails to connect in the sample. Ultimately I got this working with my external MySQL server.
What other servers can be placed in the sandbox and how does it work exactly or more importantly why might my sandbox derby fail to run?)
(I fixed a problem with Tomcat sandbox server but that was due to a version 1.7 JDK rather than 1.6_13 which sadly has security issues. While I am asking how do I setup
Sun JDK 1.7 as a JRE/ JDK environment default and are there any issues I should know about?)
4. If there is a port conflict, did you try changing the port in the sandbox Derby connector?
(yes – That clearly has nothing to do with here since I have changed ports to no avail)

[support-swapna]

rss245b,

Thank you for the details.

1. Can you please share the Installation Details from MyEclipse > Installation Summary > Installation Details ? Paste them here for us.

2. Can you please open up the sandbox Derby connector configuration and click on all Restore buttons to see if it helps ? Please stop the external Derby or any other database which might use the same port and check.

3. If you are still seeing the issue, I suggest you repair the MyEclipse installation and check if you still see the issue. When you rerun the installer ,you will see an option to “Repair”.

Let us know how it works for you.

[Rob Silver]

As requested:
*** Date:
Monday, May 21, 2012 12:08:59 PM EDT

*** System properties:
OS=WindowsVista
OS version=6.1.0
OS arch=x86
Profile arch=x86
Window system=win32
Java version=1.6.0_13
Workspace=file:/C:/Users/Robert/ws_robots/
VM Args=-Xmx512m
-XX:ReservedCodeCacheSize=64m
-Dosgi.nls.warnings=ignore
-XX:MaxPermSize=512m
-Djava.class.path=C:\Users\Robert\AppData\Local\MYECLI~1\MYECLI~1\../Common/plugins/ORB7B5~1.JAR

*** Subscription information
Product Id: E3MS (MyEclipse for Spring Subscription)
License version: 3.0
Full Maintenance Included
Subscription expiration date (YYYYMMDD): 20130514
Number of users: 1

*** Eclipse details:
MyEclipse for Spring

Version: 10.0.0

Build ID: 10.0.0 Build 7 (111109_1440)

Blueprint: MyEclipse for Spring 10

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-showsplash
-launcher
C:\Users\Robert\AppData\Local\MyEclipse for Spring\MyEclipse for Spring 10\myeclipseforspring.exe
-name
Myeclipseforspring
–launcher.library
C:\Users\Robert\AppData\Local\MyEclipse for Spring\MyEclipse for Spring 10\../Common/plugins/org.eclipse.equinox.launcher.i18n.win32.win32.x86_4.2.0.v201201111650\eclipse_4201.dll
-startup
C:\Users\Robert\AppData\Local\MyEclipse for Spring\MyEclipse for Spring 10\../Common/plugins/org.eclipse.equinox.launcher_1.2.0.v20110502.jar
-install
C:\Users\Robert\AppData\Local\MyEclipse for Spring\MyEclipse for Spring 10
-configuration
C:\Users\Robert\AppData\Local\MyEclipse for Spring\MyEclipse for Spring 10\configuration
-vm
C:\Users\Robert\AppData\Local\MyEclipse for Spring\Common\binary\com.sun.java.jdk.win32.x86_1.6.0.013\jre\bin\client\jvm.dll

=====
2. As requested I checked. Note the Derby server failed to listen on port 1527 when I tried to start it though the sandbox view showed it supposedly running and nothing showed on the console – quite weird really! Stopping Derby never happened probably because it never really started at all as I said no port was listening
=======
3. How do I repair the installation?

[support-swapna]

rss245b,

1. How did you install MyEclipse for Spring ? Is it using the All-In-One installer or Pulse ?

2. You could try to repair your MyEclipse profile or install a new MyEclipse profile. Here is what you need to do, re-run your MyEclipse for Spring 10 installer. You would be given 4 different options – Run MyEclipse, Repair MyEclipse, Install Another, Un-install MyEclipse. Either you could choose Repair MyEclipse or Install Another and follow the wizard.

3. If you have installed it using Pulse, then open up the Pulse Explorer, right click on MyEclipse for Spring 10 under My Profiles section and select ‘Reinstall then Run’.

4. Since you are on version 10.0, after repairing the profile, you can go to MyEclipse Configuration Center > Software > Updates Available. Select 10.1, apply the changes and follow the wizard. Restart the IDE when it prompts to.

Let us know how it works for you.

[Rob Silver]

1. How did you install MyEclipse for Spring ? Is it using the All-In-One installer or Pulse ?

A bit of both I installed originally with the All-in-one. Then I used Pulse to add some items
e.g Android, and Blackberry libraries

2. You could try to repair your MyEclipse profile or install a new MyEclipse profile. Here is what you need to do, re-run your MyEclipse for Spring 10 installer. You would be given 4 different options – Run MyEclipse, Repair MyEclipse, Install Another, Un-install MyEclipse. Either you could choose Repair MyEclipse or Install Another and follow the wizard.
Yes but I am looking for a more diagnostic answer like how to debug what is failing and change the classpath or add some missing files or replace some files specifically for Derby sandbox server. What you are proposing does not save me effort and could make other things worse. It reminds of Microsoft’s reinstall policy.
I really want to understand why the sandbox is not working for Derby not fixing an IDE installation if you get my meaning

3. If you have installed it using Pulse, then open up the Pulse Explorer, right click on MyEclipse for Spring 10 under My Profiles section and select ‘Reinstall then Run’.
Again not the solution I was hoping for

4. Since you are on version 10.0, after repairing the profile, you can go to MyEclipse Configuration Center > Software > Updates Available. Select 10.1, apply the changes and follow the wizard. Restart the IDE when it prompts to.
Not the solution I was looking for

[support-swapna]

rss245b,

If you are unable to get the sandbox Derby started and running, then it might be possible that it is corrupted and so to fix it, you will have to either repair or reinstall the installation.

Can you please confirm the problems you are seeing with different databases ?

1. MySQL is working OK.

2. External Derby connects but doesn’t have the CLASSICCARS schema.

3. Sandbox Derby cannot connect.

If you do not have the CLASSICCARS schema in the external Derby, then you need to define it. If internal Derby isn’t running properly, you will have to repair the installation.

[Rob Silver]

1. MySQL is working OK.
yes
2. External Derby connects but doesn’t have the CLASSICCARS schema.
yes probably because I should be connecting to myeclipse not Classiccars
but the big issue is the sandbox version of Derby.

3. Sandbox Derby cannot connect.
Yes sandbox does not work at all . No console no error messages no connection possible
no way to shut it down not that it ever started Just MyEclipse thinks it started. no ports listened to etc ..

If you do not have the CLASSICCARS schema in the external Derby, then you need to define it. If internal Derby isn’t running properly, you will have to repair the installation.

There is no way to debug this issue by hand checking .xml files etc.. ??

[support-swapna]

rss245b,

I am afraid there is no way you can debug it by checking .xml files.

Can you stop the external Derby, switch to a new workspace and try starting the Sandbox Derby. Now copy paste the contents of the .log file which is located at <workspace dir>/.metadata/.log for us.

[Author]

Posts