Need help with web service + jpa combo

[John Semler]

I was putting the finishing touch on my logic, but something happen and I was never able to recover - getting the following error mostly now. Been racking my brains for 6 hours.

The class in question below does have the @Entity annotation so I don't know where to go with this. I'm relatively new at this so I appreciate any help!

I'm developing under Linux using NetBeans 7.2 and GlassFish 3.1.2.

...
Caused by: java.lang.IllegalArgumentException: Unknown entity bean class: class net.jsemler.service.database.ZIPCodes, please verify that this class has been marked with the @Entity annotation.
	at org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:648)
	at org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:532)
	at net.jsemler.service.zipcode.ZIPCode.getRecord(ZIPCode.java:31)
...

ZIPCode.java (blows up at line 31):

package net.jsemler.service.zipcode;

import javax.ejb.Stateless;
import javax.jws.WebMethod;
import javax.jws.WebParam;
import javax.jws.WebService;
import javax.persistence.EntityManager;
import javax.persistence.Persistence;
import net.jsemler.service.database.Class;
import net.jsemler.service.database.States;
import net.jsemler.service.database.ZIPCodes;

/**
 *
 * @author jsemler
 */

@WebService(serviceName = "service")
@Stateless()
public class ZIPCode {
    static final String PU = "servicePU";
    static EntityManager em = 
        Persistence.createEntityManagerFactory(PU).createEntityManager();
    
    /**
     * Web service operation
     */
    @WebMethod(operationName = "getRecord")
    public ZIPCodeRecord getRecord(@WebParam(name = "id") String id) {        
        ZIPCodeRecord record = new ZIPCodeRecord();
        ZIPCodes zipCodes = em.find(ZIPCodes.class, id);
        
        if (zipCodes != null) {            
            record.setZipCode(zipCodes.getZIPCode());
            record.setLatitude(zipCodes.getLatitude());
            record.setLongitude(zipCodes.getLongitude());
            record.setCity(zipCodes.getCity());

            Class class1 = em.find(Class.class, zipCodes.getClass1());

            if (class1 != null) {
                record.setDescription(class1.getDescription());
            }

            States states = em.find(States.class, zipCodes.getStateCode());

            if (states != null) {
                record.setState(states.getStateName());
            }
            
            record.setValidResult(true);
        }

        return record;
    }
}

ZIPCodes.java (auto-generated):

package net.jsemler.service.database;

import java.io.Serializable;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.validation.constraints.NotNull;
import javax.validation.constraints.Size;
import javax.xml.bind.annotation.XmlRootElement;

/**
 *
 * @author jsemler
 */
@Entity
@Table(name = "ZIP_Codes")
@XmlRootElement
@NamedQueries({
    @NamedQuery(name = "ZIPCodes.findAll", query = "SELECT z FROM ZIPCodes z"),
    @NamedQuery(name = "ZIPCodes.findByZIPCode", query = "SELECT z FROM ZIPCodes z WHERE z.zIPCode = :zIPCode"),
    @NamedQuery(name = "ZIPCodes.findByLatitude", query = "SELECT z FROM ZIPCodes z WHERE z.latitude = :latitude"),
    @NamedQuery(name = "ZIPCodes.findByLongitude", query = "SELECT z FROM ZIPCodes z WHERE z.longitude = :longitude"),
    @NamedQuery(name = "ZIPCodes.findByClass1", query = "SELECT z FROM ZIPCodes z WHERE z.class1 = :class1"),
    @NamedQuery(name = "ZIPCodes.findByCity", query = "SELECT z FROM ZIPCodes z WHERE z.city = :city"),
    @NamedQuery(name = "ZIPCodes.findByStateCode", query = "SELECT z FROM ZIPCodes z WHERE z.stateCode = :stateCode")})
public class ZIPCodes implements Serializable {
    private static final long serialVersionUID = 1L;
    @Id
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 10)
    @Column(name = "ZIP_Code")
    private String zIPCode;
    @Size(max = 20)
    @Column(name = "Latitude")
    private String latitude;
    @Size(max = 20)
    @Column(name = "Longitude")
    private String longitude;
    @Size(max = 2)
    @Column(name = "Class")
    private String class1;
    @Size(max = 56)
    @Column(name = "City")
    private String city;
    @Size(max = 4)
    @Column(name = "State_Code")
    private String stateCode;

    public ZIPCodes() {
    }

    public ZIPCodes(String zIPCode) {
        this.zIPCode = zIPCode;
    }

    public String getZIPCode() {
        return zIPCode;
    }

    public void setZIPCode(String zIPCode) {
        this.zIPCode = zIPCode;
    }

    public String getLatitude() {
        return latitude;
    }

    public void setLatitude(String latitude) {
        this.latitude = latitude;
    }

    public String getLongitude() {
        return longitude;
    }

    public void setLongitude(String longitude) {
        this.longitude = longitude;
    }

    public String getClass1() {
        return class1;
    }

    public void setClass1(String class1) {
        this.class1 = class1;
    }

    public String getCity() {
        return city;
    }

    public void setCity(String city) {
        this.city = city;
    }

    public String getStateCode() {
        return stateCode;
    }

    public void setStateCode(String stateCode) {
        this.stateCode = stateCode;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (zIPCode != null ? zIPCode.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof ZIPCodes)) {
            return false;
        }
        ZIPCodes other = (ZIPCodes) object;
        if ((this.zIPCode == null && other.zIPCode != null) || (this.zIPCode != null && !this.zIPCode.equals(other.zIPCode))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "net.jsemler.service.database.ZIPCodes[ zIPCode=" + zIPCode + " ]";
    }
    
}

persistence.xml:

<?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="servicePU" transaction-type="JTA">
    <jta-data-source>serviceJNDI</jta-data-source>
    <exclude-unlisted-classes>false</exclude-unlisted-classes>
    <properties/>
  </persistence-unit>
</persistence>

glassfish-resources.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE resources PUBLIC "-//GlassFish.org//DTD GlassFish Application Server 3.1 Resource Definitions//EN" "http://glassfish.org/dtds/glassfish-resources_1_5.dtd">
<resources>
    <jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false" connection-creation-retry-attempts="0" connection-creation-retry-interval-in-seconds="10" connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" connection-validation-method="auto-commit" datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="true" lazy-connection-association="false" lazy-connection-enlistment="false" match-connections="false" max-connection-usage-count="0" max-pool-size="32" max-wait-time-in-millis="60000" name="mysql_zipcodes_db_rootPool" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" steady-pool-size="8" validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">
        <property name="serverName" value="localhost"/>
        <property name="portNumber" value="3306"/>
        <property name="databaseName" value="zipcodes_db"/>
        <property name="User" value="XXXX"/>
        <property name="Password" value="XXXX"/>
        <property name="URL" value="jdbc:mysql://localhost:3306/zipcodes_db?zeroDateTimeBehavior=convertToNull"/>
        <property name="driverClass" value="com.mysql.jdbc.Driver"/>
    </jdbc-connection-pool>
    <jdbc-resource enabled="true" jndi-name="serviceJNDI" object-type="user" pool-name="mysql_zipcodes_db_rootPool"/>
</resources>

[John Semler]

I'm also getting a lot of these errors. Keeps adding to the server log when I'm not doing anything. Probably a significant clue.

WARNING: RAR5035:Unexpected exception while destroying resource from pool mysql_zipcodes_db_rootPool. Exception message: WEB9031: WebappClassLoader unable to load resource [com.mysql.jdbc.ProfilerEventHandlerFactory], because it has not yet been started, or was already stopped
WARNING: RAR5035:Unexpected exception while destroying resource from pool mysql_zipcodes_db_rootPool. Exception message: WEB9031: WebappClassLoader unable to load resource [com.mysql.jdbc.ProfilerEventHandlerFactory], because it has not yet been started, or was already stopped
WARNING: RAR5035:Unexpected exception while destroying resource from pool mysql_zipcodes_db_rootPool. Exception message: WEB9031: WebappClassLoader unable to load resource [com.mysql.jdbc.ProfilerEventHandlerFactory], because it has not yet been started, or was already stopped
WARNING: RAR5035:Unexpected exception while destroying resource from pool mysql_zipcodes_db_rootPool. Exception message: WEB9031: WebappClassLoader unable to load resource [com.mysql.jdbc.ProfilerEventHandlerFactory], because it has not yet been started, or was already stopped
WARNING: RAR5035:Unexpected exception while destroying resource from pool mysql_zipcodes_db_rootPool. Exception message: WEB9031: WebappClassLoader unable to load resource [com.mysql.jdbc.ProfilerEventHandlerFactory], because it has not yet been started, or was already stopped
WARNING: RAR5035:Unexpected exception while destroying resource from pool mysql_zipcodes_db_rootPool. Exception message: WEB9031: WebappClassLoader unable to load resource [com.mysql.jdbc.ProfilerEventHandlerFactory], because it has not yet been started, or was already stopped

No error with another JPA module running in an EJB (it uses mysql_ephemeris_db_rootPool).

[John Semler]

Made the following changes:

1) Switched to Container Managed Persistence (see code below).
2) Copied "mysql-connector-java-5.1.18-bin.jar" to "/home/glassfish/glassfish/domains/domain1/lib/ext"

Works perfectly!

ZIPCode.java

package net.jsemler.service.zipcode;

import javax.jws.WebMethod;
import javax.jws.WebParam;
import javax.jws.WebService;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import net.jsemler.service.database.Class;
import net.jsemler.service.database.States;
import net.jsemler.service.database.ZIPCodes;

/**
 *
 * @author jsemler
 */
@WebService()
public class ZIPCode {
    @PersistenceContext(unitName="servicePU")
    private EntityManager em;
    
    /**
     * Web service operation
     */
    @WebMethod(operationName = "getRecord")
    public ZIPCodeRecord getRecord(@WebParam(name = "id") String id) {        
        ZIPCodeRecord record = new ZIPCodeRecord();
        ZIPCodes zipCodes = em.find(ZIPCodes.class, id);
        
        if (zipCodes != null) {            
            record.setZipCode(zipCodes.getZIPCode());
            record.setLatitude(zipCodes.getLatitude());
            record.setLongitude(zipCodes.getLongitude());
            record.setCity(zipCodes.getCity());

            Class class1 = em.find(Class.class, zipCodes.getClass1());

            if (class1 != null) {
                record.setDescription(class1.getDescription());
            }

            States states = em.find(States.class, zipCodes.getStateCode());

            if (states != null) {
                record.setState(states.getStateName());
            }
            
            record.setValidResult(true);
        }

        return record;
    }
}

persistence.xml<?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="servicePU" transaction-type="JTA"> <jta-data-source>zipcodes_db</jta-data-source> <exclude-unlisted-classes>false</exclude-unlisted-classes> <properties/> </persistence-unit> </persistence>

glassfish-resources.xml<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE resources PUBLIC "-//GlassFish.org//DTD GlassFish Application Server 3.1 Resource Definitions//EN" "http://glassfish.org/dtds/glassfish-resources_1_5.dtd"> <resources> <jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false" connection-creation-retry-attempts="0" connection-creation-retry-interval-in-seconds="10" connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" connection-validation-method="auto-commit" datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="true" lazy-connection-association="false" lazy-connection-enlistment="false" match-connections="false" max-connection-usage-count="0" max-pool-size="32" max-wait-time-in-millis="60000" name="mysql_zipcodes_db_rootPool" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" steady-pool-size="8" validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false"> <property name="serverName" value="localhost"/> <property name="portNumber" value="3306"/> <property name="databaseName" value="zipcodes_db"/> <property name="User" value="XXXX"/> <property name="Password" value="XXXX"/> <property name="URL" value="jdbc:mysql://localhost:3306/zipcodes_db?zeroDateTimeBehavior=convertToNull"/> <property name="driverClass" value="com.mysql.jdbc.Driver"/> </jdbc-connection-pool> <jdbc-resource enabled="true" jndi-name="zipcodes_db" object-type="user" pool-name="mysql_zipcodes_db_rootPool"/> </resources>