org.hibernate.exception.GenericJDBCException: Cannot open connection

[Ankit Varshney]

Hello friends,

I am deploying my ear file using NetBeans 6.5.1,Jboss 5.0.1GA and hibernate.
But while running my application I am getting some exception..The details are given below....

15:45:24,015 ERROR [JDBCExceptionReporter] Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57c2c5:74f:4b39a9e5:810 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57c2c5:74f:4b39a9e5:810 status: ActionStatus.ABORT_ONLY >)
15:45:24,328 ERROR [STDERR] javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection
15:45:24,328 ERROR [STDERR]         at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
15:45:24,328 ERROR [STDERR]         at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76)
15:45:24,328 ERROR [STDERR]         at cdac.nroa.sessions.CorporateElementsFacade.findCorpIdByElementId(CorporateElementsFacade.java:182)
15:45:24,328 ERROR [STDERR]         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15:45:24,828 ERROR [STDERR]         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
15:45:24,828 ERROR [STDERR]         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
15:45:24,828 ERROR [STDERR]         at java.lang.reflect.Method.invoke(Method.java:597)
15:45:24,828 ERROR [STDERR]         at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)
15:45:24,828 ERROR [STDERR]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
15:45:24,828 ERROR [STDERR]         at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)
15:45:24,828 ERROR [STDERR]         at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)
15:45:24,828 ERROR [STDERR]         at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)
15:45:24,828 ERROR [STDERR]         at sun.reflect.GeneratedMethodAccessor337.invoke(Unknown Source)
15:45:24,828 ERROR [STDERR]         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
15:45:24,828 ERROR [STDERR]         at java.lang.reflect.Method.invoke(Method.java:597)
15:45:24,828 ERROR [STDERR]         at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)
15:45:24,828 ERROR [STDERR]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
15:45:24,828 ERROR [STDERR]         at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)
15:45:24,828 ERROR [STDERR]         at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_29597895.invoke(InvocationContextInterceptor_z_fillMethod_29597895.java)
15:45:24,828 ERROR [STDERR]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
15:45:24,828 ERROR [STDERR]         at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)
15:45:24,828 ERROR [STDERR]         at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_29597895.invoke(InvocationContextInterceptor_z_setup_29597895.java)

While debugging the code the error point is....

List<CorporateElements> corporateElements = em.createNamedQuery("CorporateElements.findByCorporateId").setParameter("corporateId",new BigDecimal(Long.toString(2))).getResultList();
                  

What I understand is that while an entity want to connect with the database its throwing the above Exception..
There is no problem for a JSP to communicate with database using session bean....It running fine..
Please help me out to sort the problem..
My persistence.xml looks like this...

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
  <persistence-unit name="JRLDC-ejbPU" transaction-type="JTA">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <jta-data-source>java:/jnrldc/mysql83</jta-data-source>
    <properties>
         <property name="hibernate.archive.autodetection" value="class"/>
         <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
         <!--<property name="hibernate.hbm2ddl.auto" value="create-drop"/>-->
      </properties>
  </persistence-unit>
</persistence>

[Christian Dillinger]

Is your datasource you use here "<jta-data-source>java:/jnrldc/mysql83</jta-data-source> " correct? Can you open a connection with the parameters saved there?

[Ankit Varshney]

Yes ,Its Right
As I am able to retrieve my user name and password from a Jsp Page using the session bean,So I dont think its a problem of DataSource....

[Amar Deep Singh Chaudhary]

Hey ankit,
the problem, which i am seeing here is that, may be your entities are not connected with the database, can you tell me that at which point you have defined that. entity to connect to database. Have makes all the entries in **-ds.xml in jboss deploy directory, if not then you need to make that, the other problem which may is that, you will not be getting the reference of NamedQuery in which you are passing the parameter, can you also show us the code of your Entity, so that we can look into that, also show your **-ds.xml file code.

Thanks
With Regards
Amar Deep Singh
http://amardeep.100webspace.net