I am trying to set up the EPCIS repository according to the instructions in the user guide.
Most of the steps went fine, but when trying to configure the repository to connect to the DB, I found that the $TOMCAT_HOME/conf/Catalina/localhost/ directory is empty.
I tried creating an epcis-repository-0.5.0.xml file myself (copying the text from the user guide), but I don't think that worked...
From what I can see, the DB connection is not working properly...
- the Tomcat log contains several warnings; the first one is as follows:
WARN (2014-01-21 14:06:23,118) [org.hibernate.cfg.SettingsFactory:117] - Could not obtain connection metadata
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
- When trying the capture interface, I get the following error: Capture request failed (HTTP response code 500)
- When trying the query interface, I get the following error:
Unexpected error while invoking EPCIS Query Interface.
org.fosstrak.epcis.soap.ImplementationExceptionResponse: SQL error during query execution: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
I'm trying to set this up on a brand new install of XAMPP 1.8.2 on a Windows 7 machine
I have installed the MySQL connector (mysql-connector-java-gpl-5.1.28.msi) and copied the jar file into the Tomcat lib directory
Your help would be greatly appreciated.
GS1 New Zealand