Hi,
It looks like there is a problem logging into the database:
Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
E
Please make sure you have set up your persistence.xml correctly.
HTH, Wouter van Reeven
On Wed, Apr 29, 2009 at 05:25:25AM -0700, farag saad wrote:
> I'm new to JPA
>
> the attached code gives me alot of exceptions
> i think it from the server not the code
>
>
>
> package com.tutorial;
>
> import javax.naming.InitialContext;
> import javax.naming.NamingException;
>
> public class ClientTest
> {
>
> public static void main(String[] args)
> {
> InitialContext ctx;
> try
> {
> ctx = new InitialContext();
> SimpleBean bean = (SimpleBean) ctx.lookup("ejb/SimpleBeanJNDI");
>
> bean.createCustomers();
>
> Customer cust = bean.getCustomer(1);
>
>
> System.out.println("customer");
> System.out.println(cust.getId());
> System.out.println(cust.getName());
>
>
>
> }
> catch(NamingException nExc)
> {
> nExc.printStackTrace();
> }
> }
>
> }
> package com.tutorial;
>
> import java.io.Serializable;
>
> import javax.persistence.Column;
> import javax.persistence.Entity;
> import javax.persistence.Id;
> import javax.persistence.Table;
>
> @Entity
> @Table(name="CUSTOMER")
> public class Customer implements Serializable
> {
>
> private static final long serialVersionUID = 1L;
>
> @Id
> @Column(name="ID")
> private int id;
>
> @Column(name="NAME")
> private String name;
>
> void setId(int id)
> {
> this.id = id;
> }
>
> int getId()
> {
> return id;
> }
>
> void setName(String name)
> {
> this.name = name;
> }
>
> String getName()
> {
> return name;
> }
> }
> Apr 26, 2009 8:41:09 AM com.sun.corba.ee.impl.encoding.CDRInputStream_1_0 read_value
> WARNING: "IOP00810257: (MARSHAL) Could not load class oracle.toplink.essentials.exceptions.DatabaseException"
> org.omg.CORBA.MARSHAL: vmcid: SUN minor code: 257 completed: Maybe
> at com.sun.corba.ee.impl.logging.ORBUtilSystemException.couldNotFindClass(ORBUtilSystemException.java:9684)
> at com.sun.corba.ee.impl.logging.ORBUtilSystemException.couldNotFindClass(ORBUtilSystemException.java:9699)
> at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.read_value(CDRInputStream_1_0.java:1042)
> at com.sun.corba.ee.impl.encoding.CDRInputStream.read_value(CDRInputStream.java:475)
> at com.sun.corba.ee.impl.io.IIOPInputStream.inputObjectField(IIOPInputStream.java:1974)
> at com.sun.corba.ee.impl.io.IIOPInputStream.inputClassFields(IIOPInputStream.java:2199)
> at com.sun.corba.ee.impl.io.IIOPInputStream.inputObject(IIOPInputStream.java:1211)
> at com.sun.corba.ee.impl.io.IIOPInputStream.simpleReadObject(IIOPInputStream.java:422)
> at com.sun.corba.ee.impl.io.ValueHandlerImpl.readValueInternal(ValueHandlerImpl.java:362)
> at com.sun.corba.ee.impl.io.ValueHandlerImpl.readValue(ValueHandlerImpl.java:328)
> at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.readRMIIIOPValueType(CDRInputStream_1_0.java:966)
> at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.read_value(CDRInputStream_1_0.java:1052)
> at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.read_value(CDRInputStream_1_0.java:896)
> at com.sun.corba.ee.impl.encoding.CDRInputStream.read_value(CDRInputStream.java:466)
> at com.sun.corba.ee.impl.servicecontext.UEInfoServiceContextImpl.<init>(UEInfoServiceContextImpl.java:65)
> at com.sun.corba.ee.spi.servicecontext.ServiceContextDefaults$5.create(ServiceContextDefaults.java:200)
> at com.sun.corba.ee.impl.servicecontext.ServiceContextsImpl.unmarshal(ServiceContextsImpl.java:276)
> at com.sun.corba.ee.impl.servicecontext.ServiceContextsImpl.get(ServiceContextsImpl.java:459)
> at com.sun.corba.ee.impl.protocol.CorbaClientRequestDispatcherImpl.processResponse(CorbaClientRequestDispatcherImpl.java:511)
> at com.sun.corba.ee.impl.protocol.CorbaClientRequestDispatcherImpl.marshalingComplete(CorbaClientRequestDispatcherImpl.java:363)
> at com.sun.corba.ee.impl.protocol.CorbaClientDelegateImpl.invoke(CorbaClientDelegateImpl.java:219)
> at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.privateInvoke(StubInvocationHandlerImpl.java:192)
> at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.invoke(StubInvocationHandlerImpl.java:152)
> at com.sun.corba.ee.impl.presentation.rmi.bcel.BCELStubBase.invoke(BCELStubBase.java:225)
> at com.tutorial.__SimpleBean_Remote_DynamicStub.createCustomers(com/tutorial/__SimpleBean_Remote_DynamicStub.java)
> at com.tutorial._SimpleBean_Wrapper.createCustomers(com/tutorial/_SimpleBean_Wrapper.java)
> at com.tutorial.ClientTest.main(ClientTest.java:17)
> Apr 26, 2009 8:41:09 AM com.sun.corba.ee.impl.servicecontext.UEInfoServiceContextImpl <init>
> WARNING: "IOP00810261: (MARSHAL) Could not read exception from UEInfoServiceContext"
> org.omg.CORBA.MARSHAL: vmcid: SUN minor code: 261 completed: Maybe
> at com.sun.corba.ee.impl.logging.ORBUtilSystemException.couldNotReadInfo(ORBUtilSystemException.java:9798)
> at com.sun.corba.ee.impl.servicecontext.UEInfoServiceContextImpl.<init>(UEInfoServiceContextImpl.java:70)
> at com.sun.corba.ee.spi.servicecontext.ServiceContextDefaults$5.create(ServiceContextDefaults.java:200)
> at com.sun.corba.ee.impl.servicecontext.ServiceContextsImpl.unmarshal(ServiceContextsImpl.java:276)
> at com.sun.corba.ee.impl.servicecontext.ServiceContextsImpl.get(ServiceContextsImpl.java:459)
> at com.sun.corba.ee.impl.protocol.CorbaClientRequestDispatcherImpl.processResponse(CorbaClientRequestDispatcherImpl.java:511)
> at com.sun.corba.ee.impl.protocol.CorbaClientRequestDispatcherImpl.marshalingComplete(CorbaClientRequestDispatcherImpl.java:363)
> at com.sun.corba.ee.impl.protocol.CorbaClientDelegateImpl.invoke(CorbaClientDelegateImpl.java:219)
> at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.privateInvoke(StubInvocationHandlerImpl.java:192)
> at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.invoke(StubInvocationHandlerImpl.java:152)
> at com.sun.corba.ee.impl.presentation.rmi.bcel.BCELStubBase.invoke(BCELStubBase.java:225)
> at com.tutorial.__SimpleBean_Remote_DynamicStub.createCustomers(com/tutorial/__SimpleBean_Remote_DynamicStub.java)
> at com.tutorial._SimpleBean_Wrapper.createCustomers(com/tutorial/_SimpleBean_Wrapper.java)
> at com.tutorial.ClientTest.main(ClientTest.java:17)
> Caused by: org.omg.CORBA.MARSHAL: vmcid: SUN minor code: 257 completed: Maybe
> at com.sun.corba.ee.impl.logging.ORBUtilSystemException.couldNotFindClass(ORBUtilSystemException.java:9684)
> at com.sun.corba.ee.impl.logging.ORBUtilSystemException.couldNotFindClass(ORBUtilSystemException.java:9699)
> at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.read_value(CDRInputStream_1_0.java:1042)
> at com.sun.corba.ee.impl.encoding.CDRInputStream.read_value(CDRInputStream.java:475)
> at com.sun.corba.ee.impl.io.IIOPInputStream.inputObjectField(IIOPInputStream.java:1974)
> at com.sun.corba.ee.impl.io.IIOPInputStream.inputClassFields(IIOPInputStream.java:2199)
> at com.sun.corba.ee.impl.io.IIOPInputStream.inputObject(IIOPInputStream.java:1211)
> at com.sun.corba.ee.impl.io.IIOPInputStream.simpleReadObject(IIOPInputStream.java:422)
> at com.sun.corba.ee.impl.io.ValueHandlerImpl.readValueInternal(ValueHandlerImpl.java:362)
> at com.sun.corba.ee.impl.io.ValueHandlerImpl.readValue(ValueHandlerImpl.java:328)
> at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.readRMIIIOPValueType(CDRInputStream_1_0.java:966)
> at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.read_value(CDRInputStream_1_0.java:1052)
> at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.read_value(CDRInputStream_1_0.java:896)
> at com.sun.corba.ee.impl.encoding.CDRInputStream.read_value(CDRInputStream.java:466)
> at com.sun.corba.ee.impl.servicecontext.UEInfoServiceContextImpl.<init>(UEInfoServiceContextImpl.java:65)
> ... 12 more
> Exception in thread "main" javax.ejb.EJBException
> at com.tutorial._SimpleBean_Wrapper.createCustomers(com/tutorial/_SimpleBean_Wrapper.java)
> at com.tutorial.ClientTest.main(ClientTest.java:17)
> Caused by: org.omg.CORBA.MARSHAL: vmcid: SUN minor code: 261 completed: Maybe
> at com.sun.corba.ee.impl.logging.ORBUtilSystemException.couldNotReadInfo(ORBUtilSystemException.java:9798)
> at com.sun.corba.ee.impl.servicecontext.UEInfoServiceContextImpl.<init>(UEInfoServiceContextImpl.java:70)
> at com.sun.corba.ee.spi.servicecontext.ServiceContextDefaults$5.create(ServiceContextDefaults.java:200)
> at com.sun.corba.ee.impl.servicecontext.ServiceContextsImpl.unmarshal(ServiceContextsImpl.java:276)
> at com.sun.corba.ee.impl.servicecontext.ServiceContextsImpl.get(ServiceContextsImpl.java:459)
> at com.sun.corba.ee.impl.protocol.CorbaClientRequestDispatcherImpl.processResponse(CorbaClientRequestDispatcherImpl.java:511)
> at com.sun.corba.ee.impl.protocol.CorbaClientRequestDispatcherImpl.marshalingComplete(CorbaClientRequestDispatcherImpl.java:363)
> at com.sun.corba.ee.impl.protocol.CorbaClientDelegateImpl.invoke(CorbaClientDelegateImpl.java:219)
> at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.privateInvoke(StubInvocationHandlerImpl.java:192)
> at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.invoke(StubInvocationHandlerImpl.java:152)
> at com.sun.corba.ee.impl.presentation.rmi.bcel.BCELStubBase.invoke(BCELStubBase.java:225)
> at com.tutorial.__SimpleBean_Remote_DynamicStub.createCustomers(com/tutorial/__SimpleBean_Remote_DynamicStub.java)
> ... 2 more
> Caused by: org.omg.CORBA.MARSHAL: vmcid: SUN minor code: 257 completed: Maybe
> at com.sun.corba.ee.impl.logging.ORBUtilSystemException.couldNotFindClass(ORBUtilSystemException.java:9684)
> at com.sun.corba.ee.impl.logging.ORBUtilSystemException.couldNotFindClass(ORBUtilSystemException.java:9699)
> at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.read_value(CDRInputStream_1_0.java:1042)
> at com.sun.corba.ee.impl.encoding.CDRInputStream.read_value(CDRInputStream.java:475)
> at com.sun.corba.ee.impl.io.IIOPInputStream.inputObjectField(IIOPInputStream.java:1974)
> at com.sun.corba.ee.impl.io.IIOPInputStream.inputClassFields(IIOPInputStream.java:2199)
> at com.sun.corba.ee.impl.io.IIOPInputStream.inputObject(IIOPInputStream.java:1211)
> at com.sun.corba.ee.impl.io.IIOPInputStream.simpleReadObject(IIOPInputStream.java:422)
> at com.sun.corba.ee.impl.io.ValueHandlerImpl.readValueInternal(ValueHandlerImpl.java:362)
> at com.sun.corba.ee.impl.io.ValueHandlerImpl.readValue(ValueHandlerImpl.java:328)
> at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.readRMIIIOPValueType(CDRInputStream_1_0.java:966)
> at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.read_value(CDRInputStream_1_0.java:1052)
> at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.read_value(CDRInputStream_1_0.java:896)
> at com.sun.corba.ee.impl.encoding.CDRInputStream.read_value(CDRInputStream.java:466)
> at com.sun.corba.ee.impl.servicecontext.UEInfoServiceContextImpl.<init>(UEInfoServiceContextImpl.java:65)
> ... 12 more
> Apr 26, 2009 8:41:05 AM oracle.toplink.essentials.session.file:/C:/winxpsetsup/GlassFish2.0/glassfish/domains/domain1/autodeploy/EJBTutorial.jar/-my_persistence_ctx
> INFO: TopLink, version: Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007))
> Apr 26, 2009 8:41:05 AM oracle.toplink.essentials.session.file:/C:/winxpsetsup/GlassFish2.0/glassfish/domains/domain1/autodeploy/EJBTutorial.jar/-my_persistence_ctx
> INFO: Server: unknown
> Apr 26, 2009 8:41:07 AM com.sun.enterprise.resource.LocalTxConnectorAllocator createResource
> WARNING: RAR5038:Unexpected exception while creating resource
> Apr 26, 2009 8:41:07 AM com.sun.enterprise.connectors.ConnectionManagerImpl internalGetConnection
> WARNING: RAR5117 : Failed to obtain/create connection from connection pool [ DerbyPool ]. Reason : Connection could not be allocated because: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
> Apr 26, 2009 8:41:07 AM com.sun.gjc.spi.base.DataSource getConnection
> WARNING: RAR5114 : Error allocating connection : [Error in allocating a connection. Cause: Connection could not be allocated because: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.]
> Apr 26, 2009 8:41:07 AM oracle.toplink.essentials.session.file:/C:/winxpsetsup/GlassFish2.0/glassfish/domains/domain1/autodeploy/EJBTutorial.jar/-my_persistence_ctx
> SEVERE:
> Local Exception Stack:
> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007))): oracle.toplink.essentials.exceptions.DatabaseException
> Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
> Error Code: 0
> at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:305)
> at oracle.toplink.essentials.jndi.JNDIConnector.connect(JNDIConnector.java:150)
> at oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:184)
> at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:233)
> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.connect(DatabaseAccessor.java:242)
> at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:309)
> at oracle.toplink.essentials.threetier.ConnectionPool.buildConnection(ConnectionPool.java:117)
> at oracle.toplink.essentials.threetier.ExternalConnectionPool.startUp(ExternalConnectionPool.java:135)
> at oracle.toplink.essentials.threetier.ServerSession.connect(ServerSession.java:451)
> at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:616)
> at oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:282)
> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:229)
> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:93)
> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:126)
> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:99)
> at com.sun.enterprise.util.EntityManagerWrapper._getDelegate(EntityManagerWrapper.java:326)
> at com.sun.enterprise.util.EntityManagerWrapper.persist(EntityManagerWrapper.java:440)
> at com.tutorial.SimpleBeanImpl.createCustomers(SimpleBeanImpl.java:19)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1067)
> at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
> at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2895)
> at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:3986)
> at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:203)
> at com.sun.ejb.containers.EJBObjectInvocationHandlerDelegate.invoke(EJBObjectInvocationHandlerDelegate.java:117)
> at $Proxy37.createCustomers(Unknown Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveTie.java:154)
> at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:687)
> at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:227)
> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1846)
> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1706)
> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:1088)
> at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:223)
> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:806)
> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.dispatch(CorbaMessageMediatorImpl.java:563)
> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.doWork(CorbaMessageMediatorImpl.java:2567)
> at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:555)
> Caused by: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
> at com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:115)
> at oracle.toplink.essentials.jndi.JNDIConnector.connect(JNDIConnector.java:145)
> ... 42 more
> Apr 26, 2009 8:41:08 AM com.sun.ejb.containers.BaseContainer postInvoke
> INFO: EJB5018: An exception was thrown during an ejb invocation on [SimpleBeanImpl]
> Apr 26, 2009 8:41:08 AM com.sun.ejb.containers.BaseContainer postInvoke
> INFO:
> javax.ejb.EJBException
> at com.sun.ejb.containers.BaseContainer.processSystemException(BaseContainer.java:3869)
> at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3769)
> at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3571)
> at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1354)
> at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1316)
> at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:210)
> at com.sun.ejb.containers.EJBObjectInvocationHandlerDelegate.invoke(EJBObjectInvocationHandlerDelegate.java:117)
> at $Proxy37.createCustomers(Unknown Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveTie.java:154)
> at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:687)
> at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:227)
> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1846)
> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1706)
> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:1088)
> at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:223)
> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:806)
> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.dispatch(CorbaMessageMediatorImpl.java:563)
> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.doWork(CorbaMessageMediatorImpl.java:2567)
> at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:555)
> Caused by: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007))): oracle.toplink.essentials.exceptions.DatabaseException
> Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
> Error Code: 0
> at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:305)
> at oracle.toplink.essentials.jndi.JNDIConnector.connect(JNDIConnector.java:150)
> at oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:184)
> at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:233)
> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.connect(DatabaseAccessor.java:242)
> at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:309)
> at oracle.toplink.essentials.threetier.ConnectionPool.buildConnection(ConnectionPool.java:117)
> at oracle.toplink.essentials.threetier.ExternalConnectionPool.startUp(ExternalConnectionPool.java:135)
> at oracle.toplink.essentials.threetier.ServerSession.connect(ServerSession.java:451)
> at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:616)
> at oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:282)
> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:229)
> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:93)
> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:126)
> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:99)
> at com.sun.enterprise.util.EntityManagerWrapper._getDelegate(EntityManagerWrapper.java:326)
> at com.sun.enterprise.util.EntityManagerWrapper.persist(EntityManagerWrapper.java:440)
> at com.tutorial.SimpleBeanImpl.createCustomers(SimpleBeanImpl.java:19)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1067)
> at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
> at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2895)
> at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:3986)
> at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:203)
> ... 17 more
> Caused by: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
> at com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:115)
> at oracle.toplink.essentials.jndi.JNDIConnector.connect(JNDIConnector.java:145)
> ... 42 more
> i need to connect to mysql database not derby database
> the project EJBTutorial gives me attached exceptions
>
> note mysql jdbc uses MysqlDataSource not javax.sql.DataSource ==> com.mysql.jdbc.jdbc2.optional.MysqlDataSource
>
>
> used Application server GlassFish(Sun Java System Application Server 9.1)
> used database MySql server 5.0.17
> jdbc driver jar mysql-connector-java-5.0.4-bin.jar
>
> used database example contain table Customer(id,name)
>
>
>
> package com.tutorial;
>
> import javax.ejb.Remote;
>
> @Remote
> public interface SimpleBean
> {
> //public void createCustomers(int id, String name);
> public void createCustomers();
> public Customer getCustomer(int id);
> }
> package com.tutorial;
>
> import javax.ejb.Stateless;
> import javax.persistence.EntityManager;
> import javax.persistence.PersistenceContext;
>
> @Stateless(name="SimpleBeanImpl", mappedName="ejb/SimpleBeanJNDI")
> public class SimpleBeanImpl implements SimpleBean
> {
> @PersistenceContext(name="my_persistence_ctx")
> EntityManager em;
>
> public void createCustomers()
> {
> Customer c1 = new Customer();
> c1.setId(1);
> c1.setName("Farag");
>
> em.persist(c1);
>
> /*c1.setId(2);
> c1.setName("Ali");
> em.persist(c1);*/
>
>
> }
>
> public Customer getCustomer(int id)
> {
> Customer c = em.find(Customer.class, new Integer(id));
>
> return c;
> }
>
>
>
> }
--
"WHAT DO YOU GET IF YOU MULTIPLY SIX BY NINE?"
"Six by nine. Forty two. That's it. That's all there is."
"I always thought something was fundamentally wrong with the universe"
[The Hitchhiker's Guide To The Galaxy]