Hi,
Iu2019m trying to work with JPA and a custom datasource in CE 7.1.1. It works fine with the system datasource, but when I use the custom datasource, injection of the entity manager doesnu2019t work.
My setup is an EJB 3.0 Stateless Session Bean exposed as a web service that performs some basic operations on a simple JPA entity: insert two rows or get all.
Hereu2019s how I configured the custom datasource:
Itu2019s a Hypersonic SQL DB 1.8.
I changed the password of user SA to u201CSAu201D because NWA wonu2019t accept an empty password.
The database is up and running. I can connect it using the hsql database manager and I have an active connection from NWDS.
The EJB DC has a connection to the database. Generating DDL from the JPA entities works fine. I can also browse and edit tables and their contents from NWDS.
I uploaded the JDBC driver file hsqldb.jar for this DBMS to the CE server using NWA > Application Resources under the name u201Chsqlu201D. In the Resource List, the state of the driver is given as u201Cunknownu201D.
I created a User-Defined JDBC DataSource named u201CHSQLu201D parametrized as follows:
- Driver Name: hsql
- SQL Engine: Vendor SQL
- Isolation Level: Default
- Driver Class: org.hsqldb.jdbcDriver
- Database URL: jdbc:hsqldb:hsql://<hostname of the DBMS>/PUBLIC/
- Username: sa, Password: sa
- Description: hsql
- I didnu2019t touch anything on the other tabs and saved it.
In my EAR DC META-INF/data-source-aliases.xml, Iu2019m referring to it as follows:
<?xml version="1.0" encoding="UTF-8"?>
<data-source-aliases xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="data-source-aliases.xsd">
<application-name>LocalDevelopment~0~mysql_ear~aoksystems.de</application-name>
<aliases>
<data-source-name>HSQL</data-source-name>
<alias>HSQLALIAS</alias>
</aliases>
</data-source-aliases>
In my EJB DC, Iu2019m using the alias defined above. Here is the content of META-INF/persistence.xml:
<?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="mysql_pu">
<jta-data-source>HSQLALIAS</jta-data-source>
<properties>
<property name="com.sap.jpa.versioning.generator.tablename"
value="MYSQL_VERSION_GEN" />
</properties>
</persistence-unit>
</persistence>
Hereu2019s the code of the entity with its two named queries:
@Entity
@Table(name = "MYSQL_EMPLOYEE")
@NamedQueries( {
@NamedQuery(name = "Employee.getAll", query = "SELECT e FROM Employee e"),
@NamedQuery(name = "Employee.getById", query = "SELECT e FROM Employee e WHERE e.id = :id") })
public class Employee implements Serializable {
@Id
@Column(name = "ID")
@GeneratedValue(strategy = GenerationType.TABLE, generator = "mysqlGen")
@TableGenerator(name = "mysqlGen", table = "MYSQL_VERSION_GEN")
private int id;
@Column(name = "FIRST_NAME")
private String firstName;
@Column(name = "LAST_NAME")
private String lastName;
@Version
@Column(name = "VERSION")
private int version;
private static final long serialVersionUID = 1L;
public Employee() {
super();
}
// Setters and getters
// ...
}
Hereu2019s the code of the Stateless Session Bean:
@WebService(name="NewEmployeeFacade", portName="NewEmployeeFacadeBeanPort", serviceName="NewEmployeeFacadeService", targetNamespace="http://mysql.aoksystems.de/")
@Stateless
public class EmployeeFacadeBean implements EmployeeFacadeLocal {
@PersistenceContext(unitName = "mysql_pu")
protected EntityManager em;
// methods
}
Again, everything works fine as soon as I change META-INF/data-source-alias.xml in the EAR DC and set the datasource to u201CSAPCE1DBu201D, thus using the system database.
But when I use datasource HSQL, I get this exception:
javax.ejb.EJBException: Exception in getMethodReady() for stateless bean aoksystems.de/mysql_earannotation|aoksystems.de~mysql_ejb.jar*annotation|EmployeeFacadeBean; nested exception is: com.sap.engine.services.ejb3.util.pool.PoolException: javax.ejb.EJBException: Cannot perform injection over bean instance de.aoksystems.mysql.EmployeeFacadeBean@14ca646 for bean
aoksystems.de/mysql_earannotation|aoksystems.de~mysql_ejb.jarannotation|EmployeeFacadeBean; nested exception is: com.sap.engine.lib.injection.InjectionException: Injection on field em of instance de.aoksystems.mysql.EmployeeFacadeBean@14ca646 failed. Could not get a value to be injected from the factory.*
I get the same error when I remove the named queries from the entity and the calls from the session bean. Exactly the same happens when I use MySQL 5.1.7 instead of HSQL.
Can anyone help? Thanks,
Thorsten
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.