Hej arne vi sidder lige med en fejl vi ikke kan komme videre med. Når vi deployer får vi denne fejl:
Depends On Me: org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused)))]
13:57:34,177 WARN [JBossManagedConnectionPool] Unable to fill pool
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused)
Vi har brugt XDoclets til at lave vores beans ud fra dit eksempel i din artikel. Et eksempel på en bean vi har defineret:
package dk.faem.j2ee.beans.cmp;
import javax.ejb.*;
/**
* GenreBean.
*
* @ejb.bean
* name="Genre"
* type="CMP"
* cmp-version="2.x"
* local-jndi-name="ejb/entity/Genre"
* primkey-field="id"
*
* @ejb.finder
* signature="java.util.Collection findAll()"
*
* @ejb.persistence
* table-name="genre"
*
* @jboss.persistence
* datasource="java:/OpenBroadDB"
* datasource-mapping="SOLID"
*/
abstract public class GenreBean implements EntityBean {
private EntityContext entityContext;
public Integer ejbCreate(Integer id, String name ) throws CreateException {
setId(id);
setName(name);
return null;
}
public void ejbPostCreate(Integer id, String name) throws CreateException {
}
public void ejbRemove() throws RemoveException {
}
public void ejbLoad() {
}
public void ejbStore() {
}
public void ejbActivate() {
}
public void ejbPassivate() {
}
public void unsetEntityContext() {
this.entityContext = null;
}
public void setEntityContext(EntityContext entityContext) {
this.entityContext = entityContext;
}
/**
* @ejb.persistence
* column-name = "id"
*
* @ejb.pk-field
*
* @ejb.interface-method
* view-type="local"
*/
public abstract Integer getId();
/**
* @ejb.interface-method
* view-type="local"
*/
public abstract void setId(Integer id);
/**
* @ejb.persistence
* column-name = "name"
*
* @ejb.interface-method
* view-type="local"
*/
public abstract String getName();
/**
* @ejb.interface-method
* view-type="local"
*/
public abstract void setName(String name);
Og vores DB descriptor:
<?xml version="1.0" ?>
<datasources>
<local-tx-datasource>
<jndi-name>OpenBroadDB</jndi-name>
<connection-url>jdbc:
mysql://localhost/faem</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>openbroad</user-name>
<password>openbroad</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
</local-tx-datasource>
</datasources>
