persistence@glassfish.java.net

Re: Please, Help

From: christopher delahunt <christopher.delahunt_at_oracle.com>
Date: Wed, 29 Apr 2009 11:12:41 -0400

Someone had a similar problem at:
http://www.nabble.com/Use-Oracle-with-Glassfis2-u2-for-JPA-td20563623.html

Best Regards,
Chris

farag saad wrote:
> Error connecting to server localhost on port 1527
> means that it try to connect to derby server,
> i need it to connect to Mysql server
>
> persistence.xml attached
>
> Farag
>
>
> --- On *Wed, 4/29/09, Wouter van Reeven /<wouter_at_van.reeven.nl>/* wrote:
>
>
> From: Wouter van Reeven <wouter_at_van.reeven.nl>
> Subject: Re: Please, Help
> To: persistence_at_glassfish.dev.java.net
> Date: Wednesday, April 29, 2009, 3:47 PM
>
> 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]
>
>