[DougMH]

I’m attempting to import the examples on demand project DWRSpringJPAExample. It goes ok until it needs to connect (and I assume import or create tables) in MyEclipse Derby.

I can’t remember if I was ever able to connect to MyEclipse Derby, but now when I try in Database Explorer, it will not connect when attempting to test the connection:

Error while performing database login with MyEclipse Derby driver:

The configuration says I’m using

derbyclient.jar

in

C:\Documents and Settings\<user>\.myeclipse\libs\derby_10.2.2.0

user: classiccars
password: <whatever>

Did attempting to import the example screw something up?
[/img]

[Loyal Water]

I dont think the exmple has messed anything up.

Can you go to Windows > Preferences > MyEclipse > Servers > Integrated Sandbox > MyEclipse Debry and hit Restore MyEclipse Debry Driver and Restore database and then try starting the server from Database explorer. Does it work ?

[DougMH]

@support-nipun wrote:

I dont think the exmple has messed anything up.

Can you go to Windows > Preferences > MyEclipse > Servers > Integrated Sandbox > MyEclipse Debry and hit Restore MyEclipse Debry Driver and Restore database and then try starting the server from Database explorer. Does it work ?

I tried that without success, but when I just closed and restarted the MyEclipse, it worked fine… Weird.

Thanks for the quick response.

[DougMH]

Oddly, I can connect just fine using Database Explorer. When attempting to run the DWRSpringJPA sample though, I’m getting the following error

First here is the persistence.xml, which I’m sure mimicks my explorer connection?

<?xml version=”1.0″ encoding=”UTF-8″?>
<persistence xmlns=”http://java.sun.com/xml/ns/persistence&#8221;
xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance&#8221;
xsi:schemaLocation=”http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd&#8221;
version=”1.0″>

<persistence-unit name=”CLASSICCARS”
transaction-type=”RESOURCE_LOCAL”>
<provider>
oracle.toplink.essentials.PersistenceProvider
</provider>
<class>com.myeclipseide.examples.dwrspring.jpa.Customer</class>
<class>
com.myeclipseide.examples.dwrspring.jpa.Purchaseorder
</class>
<class>
com.myeclipseide.examples.dwrspring.jpa.Productline
</class>
<class>com.myeclipseide.examples.dwrspring.jpa.Payment</class>
<class>
com.myeclipseide.examples.dwrspring.jpa.Orderdetail
</class>
<class>com.myeclipseide.examples.dwrspring.jpa.Product</class>
<class>com.myeclipseide.examples.dwrspring.jpa.Office</class>
<class>com.myeclipseide.examples.dwrspring.jpa.Employee</class>
<class>
com.myeclipseide.examples.dwrspring.jpa.OrderdetailId
</class>
<class>com.myeclipseide.examples.dwrspring.jpa.PaymentId</class>
<properties>
<property name=”toplink.jdbc.driver”
value=”org.apache.derby.jdbc.ClientDriver” />
<property name=”toplink.jdbc.url”
value=”jdbc:derby://localhost:1527/myeclipse;create=true” />
<property name=”toplink.jdbc.user” value=”classiccars” />
<property name=”toplink.jdbc.password” value=”myeclipse” />
</properties>
</persistence-unit>

</persistence>

Here’s is the error which indicates I can’t connect with toplink on 1527?

type Exception report

message

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

exception

org.apache.jasper.JasperException: Exception [TOPLINK-4002] (Oracle TopLink Essentials – 2.0 (Build b40-rc (03/21/2007))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
Error Code: -4499
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541)
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.SQLException: 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(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:375)
$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.SQLException: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
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(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:375)
$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.ClientJDBCObjectFactoryImpl.newNetConnection(Unknown Source)
org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
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(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:375)
$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(Unknown Source)
java.net.PlainSocketImpl.connectToAddress(Unknown Source)
java.net.PlainSocketImpl.connect(Unknown Source)
java.net.SocksSocketImpl.connect(Unknown Source)
java.net.Socket.connect(Unknown Source)
java.net.Socket.connect(Unknown Source)
java.net.Socket.<init>(Unknown Source)
java.net.Socket.<init>(Unknown Source)
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.ClientJDBCObjectFactoryImpl.newNetConnection(Unknown Source)
org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
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(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:375)
$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.

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

[DougMH]

I deleted the entire project, performed the restores you mentioned in your previous post, then checked out the project again and all seems to work ok.

Thanks again.

[Loyal Water]

Your Welcome.

[Author]

Posts