Unable to find database

[sam White]

Hello,

With Maven2, jpa2, hibernate 3.6.5.Final, Mysql 5 and Glassfish 3.1, I am trying to deploy a WAR file, but it comes up with the following error:

[#|2011-06-13T22:41:41.523+1000|WARNING|glassfish3.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.allocator|_ThreadID=67;_ThreadName=Thread-1;|RAR5038:Unexpected exception while creating resource for pool DerbyPool. Exception : javax.resource.spi.ResourceAllocationException: Connection could not be allocated because: java.net.ConnectException��������ӵ��˿�1527 ��ķ��� localhost ʱ�����ϢΪ Connection refused: connect��|#]

[#|2011-06-13T22:41:41.570+1000|WARNING|glassfish3.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors|_ThreadID=67;_ThreadName=Thread-1;|RAR5117 : Failed to obtain/create connection from connection pool [ DerbyPool ]. Reason : com.sun.appserv.connectors.internal.api.PoolingException: Connection could not be allocated because: java.net.ConnectException��������ӵ��˿�1527 ��ķ��� localhost ʱ�����ϢΪ Connection refused: connect��|#]

[#|2011-06-13T22:41:41.575+1000|WARNING|glassfish3.1|javax.enterprise.resource.resourceadapter.com.sun.gjc.spi|_ThreadID=67;_ThreadName=Thread-1;|RAR5114 : Error allocating connection : [Error in allocating a connection. Cause: Connection could not be allocated because: java.net.ConnectException��������ӵ��˿�1527 ��ķ��� localhost ʱ�����ϢΪ Connection refused: connect��]|#]

[#|2011-06-13T22:41:43.955+1000|WARNING|glassfish3.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.allocator|_ThreadID=67;_ThreadName=Thread-1;|RAR5038:Unexpected exception while creating resource for pool DerbyPool. Exception : javax.resource.spi.ResourceAllocationException: Connection could not be allocated because: java.net.ConnectException��������ӵ��˿�1527 ��ķ��� localhost ʱ�����ϢΪ Connection refused: connect��|#]

[#|2011-06-13T22:41:43.956+1000|WARNING|glassfish3.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors|_ThreadID=67;_ThreadName=Thread-1;|RAR5117 : Failed to obtain/create connection from connection pool [ DerbyPool ]. Reason : com.sun.appserv.connectors.internal.api.PoolingException: Connection could not be allocated because: java.net.ConnectException��������ӵ��˿�1527 ��ķ��� localhost ʱ�����ϢΪ Connection refused: connect��|#]

[#|2011-06-13T22:41:43.956+1000|WARNING|glassfish3.1|javax.enterprise.resource.resourceadapter.com.sun.gjc.spi|_ThreadID=67;_ThreadName=Thread-1;|RAR5114 : Error allocating connection : [Error in allocating a connection. Cause: Connection could not be allocated because: java.net.ConnectException��������ӵ��˿�1527 ��ķ��� localhost ʱ�����ϢΪ Connection refused: connect��]|#]

[#|2011-06-13T22:41:44.481+1000|SEVERE|glassfish3.1|javax.enterprise.system.core.com.sun.enterprise.v3.server|_ThreadID=67;_ThreadName=Thread-1;|Exception while invoking class org.glassfish.persistence.jpa.JPADeployer prepare method|#]

[#|2011-06-13T22:41:44.482+1000|SEVERE|glassfish3.1|javax.enterprise.system.core.com.sun.enterprise.v3.server|_ThreadID=67;_ThreadName=Thread-1;|Exception while preparing the app|#]

[#|2011-06-13T22:41:44.482+1000|SEVERE|glassfish3.1|javax.enterprise.system.core.com.sun.enterprise.v3.server|_ThreadID=67;_ThreadName=Thread-1;|[PersistenceUnit: GuestbookPU] Unable to build EntityManagerFactory
javax.persistence.PersistenceException: [PersistenceUnit: GuestbookPU] Unable to build EntityManagerFactory
        at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:901)
        at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74)
        at org.glassfish.persistence.jpa.PersistenceUnitLoader.loadPU(PersistenceUnitLoader.java:205)
        at org.glassfish.persistence.jpa.PersistenceUnitLoader.<init>(PersistenceUnitLoader.java:119)
        at org.glassfish.persistence.jpa.JPADeployer$1.visitPUD(JPADeployer.java:213)
        at org.glassfish.persistence.jpa.JPADeployer$PersistenceUnitDescriptorIterator.iteratePUDs(JPADeployer.java:486)
        at org.glassfish.persistence.jpa.JPADeployer.createEMFs(JPADeployer.java:220)
        at org.glassfish.persistence.jpa.JPADeployer.prepare(JPADeployer.java:166)
        at com.sun.enterprise.v3.server.ApplicationLifecycle.prepareModule(ApplicationLifecycle.java:870)
        at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:410)
        at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:240)
        at org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:370)
        at com.sun.enterprise.v3.admin.CommandRunnerImpl$1.execute(CommandRunnerImpl.java:360)
        at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:370)
        at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1067)
        at com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1200(CommandRunnerImpl.java:96)
        at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1247)
        at org.glassfish.deployment.autodeploy.AutoOperation.run(AutoOperation.java:145)
        at org.glassfish.deployment.autodeploy.AutoDeployer.deploy(AutoDeployer.java:577)
        at org.glassfish.deployment.autodeploy.AutoDeployer.deployAll(AutoDeployer.java:463)
        at org.glassfish.deployment.autodeploy.AutoDeployer.run(AutoDeployer.java:395)
        at org.glassfish.deployment.autodeploy.AutoDeployer.run(AutoDeployer.java:380)
        at org.glassfish.deployment.autodeploy.AutoDeployService$1.run(AutoDeployService.java:213)
        at java.util.TimerThread.mainLoop(Timer.java:512)
        at java.util.TimerThread.run(Timer.java:462)
Caused by: org.hibernate.HibernateException: Errors in named queries: Guest.findBySingingdate
        at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:437)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385)
        at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)
        at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:892)
        ... 24 more
|#]

[#|2011-06-13T22:41:45.017+1000|SEVERE|glassfish3.1|javax.enterprise.system.tools.admin.org.glassfish.deployment.admin|_ThreadID=67;_ThreadName=Thread-1;|Exception while preparing the app : [PersistenceUnit: GuestbookPU] Unable to build EntityManagerFactory
org.hibernate.HibernateException: Errors in named queries: Guest.findBySingingdate
        at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:437)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385)
        at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)
        at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:892)
        at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74)
        at org.glassfish.persistence.jpa.PersistenceUnitLoader.loadPU(PersistenceUnitLoader.java:205)
        at org.glassfish.persistence.jpa.PersistenceUnitLoader.<init>(PersistenceUnitLoader.java:119)
        at org.glassfish.persistence.jpa.JPADeployer$1.visitPUD(JPADeployer.java:213)
        at org.glassfish.persistence.jpa.JPADeployer$PersistenceUnitDescriptorIterator.iteratePUDs(JPADeployer.java:486)
        at org.glassfish.persistence.jpa.JPADeployer.createEMFs(JPADeployer.java:220)
        at org.glassfish.persistence.jpa.JPADeployer.prepare(JPADeployer.java:166)
        at com.sun.enterprise.v3.server.ApplicationLifecycle.prepareModule(ApplicationLifecycle.java:870)
        at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:410)
        at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:240)
        at org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:370)
        at com.sun.enterprise.v3.admin.CommandRunnerImpl$1.execute(CommandRunnerImpl.java:360)
        at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:370)
        at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1067)
        at com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1200(CommandRunnerImpl.java:96)
        at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1247)
        at org.glassfish.deployment.autodeploy.AutoOperation.run(AutoOperation.java:145)
        at org.glassfish.deployment.autodeploy.AutoDeployer.deploy(AutoDeployer.java:577)
        at org.glassfish.deployment.autodeploy.AutoDeployer.deployAll(AutoDeployer.java:463)
        at org.glassfish.deployment.autodeploy.AutoDeployer.run(AutoDeployer.java:395)
        at org.glassfish.deployment.autodeploy.AutoDeployer.run(AutoDeployer.java:380)
        at org.glassfish.deployment.autodeploy.AutoDeployService$1.run(AutoDeployService.java:213)
        at java.util.TimerThread.mainLoop(Timer.java:512)
        at java.util.TimerThread.run(Timer.java:462)
|#]

[#|2011-06-13T22:41:45.141+1000|WARNING|glassfish3.1|javax.enterprise.system.tools.deployment.org.glassfish.deployment.common|_ThreadID=67;_ThreadName=Thread-1;|[AutoDeploy] Autodeploy failed : C:\glassfish3\glassfish\domains\domain1\autodeploy\xxx-registration.war.|#]

[#|2011-06-13T22:41:45.142+1000|INFO|glassfish3.1|javax.enterprise.system.tools.deployment.org.glassfish.deployment.common|_ThreadID=67;_ThreadName=Thread-1;|[AutoDeploy] Selecting file C:\glassfish3\glassfish\domains\domain1\autodeploy\xxx-registration.war for autodeployment.|#]

[#|2011-06-13T22:41:52.511+1000|SEVERE|glassfish3.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=67;_ThreadName=Thread-1;|log4j:ERROR A "org.apache.log4j.ConsoleAppender" object is not assignable to a "org.apache.log4j.Appender" variable.|#]

[#|2011-06-13T22:41:52.511+1000|SEVERE|glassfish3.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=67;_ThreadName=Thread-1;|log4j:ERROR The class "org.apache.log4j.Appender" was loaded by |#]

[#|2011-06-13T22:41:52.511+1000|SEVERE|glassfish3.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=67;_ThreadName=Thread-1;|log4j:ERROR [WebappClassLoader (delegate=true; repositories=WEB-INF/classes/)] whereas object of type |#]

[#|2011-06-13T22:41:52.511+1000|SEVERE|glassfish3.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=67;_ThreadName=Thread-1;|log4j:ERROR "org.apache.log4j.ConsoleAppender" was loaded by [WebappClassLoader (delegate=true; repositories=WEB-INF/classes/)].|#]

[#|2011-06-13T22:41:52.511+1000|SEVERE|glassfish3.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=67;_ThreadName=Thread-1;|log4j:ERROR Could not instantiate appender named "Console".|#]

[#|2011-06-13T22:41:52.531+1000|SEVERE|glassfish3.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=67;_ThreadName=Thread-1;|log4j:WARN No appenders could be found for logger (org.hibernate.cfg.annotations.Version).|#]

[#|2011-06-13T22:41:52.531+1000|SEVERE|glassfish3.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=67;_ThreadName=Thread-1;|log4j:WARN Please initialize the log4j system properly.|#]

[#|2011-06-13T22:41:53.745+1000|INFO|glassfish3.1|org.hibernate.validator.engine.resolver.DefaultTraversableResolver|_ThreadID=24;_ThreadName=Thread-1;|Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.|#]

[#|2011-06-13T22:41:53.846+1000|INFO|glassfish3.1|org.hibernate.validator.engine.resolver.DefaultTraversableResolver|_ThreadID=24;_ThreadName=Thread-1;|Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.|#]

[#|2011-06-13T22:41:53.858+1000|INFO|glassfish3.1|org.hibernate.validator.engine.resolver.DefaultTraversableResolver|_ThreadID=24;_ThreadName=Thread-1;|Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.|#]

[#|2011-06-13T22:41:55.037+1000|WARNING|glassfish3.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.allocator|_ThreadID=67;_ThreadName=Thread-1;|RAR5038:Unexpected exception while creating resource for pool DerbyPool. Exception : javax.resource.spi.ResourceAllocationException: Connection could not be allocated because: java.net.ConnectException��������ӵ��˿�1527 ��ķ��� localhost ʱ�����ϢΪ Connection refused: connect��|#]

[#|2011-06-13T22:41:55.038+1000|WARNING|glassfish3.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors|_ThreadID=67;_ThreadName=Thread-1;|RAR5117 : Failed to obtain/create connection from connection pool [ DerbyPool ]. Reason : com.sun.appserv.connectors.internal.api.PoolingException: Connection could not be allocated because: java.net.ConnectException��������ӵ��˿�1527 ��ķ��� localhost ʱ�����ϢΪ Connection refused: connect��|#]

[#|2011-06-13T22:41:55.038+1000|WARNING|glassfish3.1|javax.enterprise.resource.resourceadapter.com.sun.gjc.spi|_ThreadID=67;_ThreadName=Thread-1;|RAR5114 : Error allocating connection : [Error in allocating a connection. Cause: Connection could not be allocated because: java.net.ConnectException��������ӵ��˿�1527 ��ķ��� localhost ʱ�����ϢΪ Connection refused: connect��]|#]

...
...

Here is my src/WEB-INF/persistence.xml file:

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.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_2_0.xsd">
 
  <persistence-unit name="GuestbookPU" transaction-type="JTA">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <class>guest.Guest</class>
    <properties>
    	<!-- Scan for annotated classes and Hibernate mapping XML files -->
	    <property name="hibernate.archive.autodetection" value="class, hbm"/>

        <property name="hibernate.show_sql" value="true" />
        <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver" />
        <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/guestbook"/>
        <property name="javax.persistence.jdbc.user" value="root" />
        <property name="javax.persistence.jdbc.password" value="admin" />
        <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect"/>
        <property name="hibernate.hbm2ddl.auto" value="update"/>
    </properties>
  </persistence-unit>
 
</persistence>

my src/main/webapp/WEB-INF/web.xml file:

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
 http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
  <servlet>
    <servlet-name>spring</servlet-name>
    <servlet-class>
      org.springframework.web.servlet.DispatcherServlet
    </servlet-class>
    <load-on-startup>2</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>spring</servlet-name>
    <url-pattern>*.html</url-pattern>
  </servlet-mapping>
    <session-config>
    <session-timeout>
      30
    </session-timeout>
    </session-config>
    <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
    </welcome-file-list>
</web-app>

I didn't create any datasource in glassfish. And I also don't understand why the deployment trying to find Derby. I actually have define MySQL in persistence.xml file.
Do I need to create datasource to point to mysql/guestbook? then how to use this newly created datasource in my persistence.xml file?

Very appreciate for any suggestion.

Thanks
Sam

[Anantha Sharma]

if you look at line 53

org.hibernate.HibernateException: Errors in named queries: Guest.findBySingingdate  

the system is complaining about a named query. please check its syntax.

hibernate parses all named queries while the system is starting up .. this way it can save time when the query is executed (as it doesn't have to parse it every time the query is run).