Community,
How do I configure Derby (JavaDB) from glassfish for Persistence Context?
----------
I a new to EJB3, and attempting to execute code from ProEJB3 from apress book.
When attempting to use the Persistence Unit from the EJB Container, I get the following error.
NOTE: I use the same enities locally to test but when using the PU from the conatiner I am having this problem.
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: org.apache.derby.client.am.SqlException: Schema 'J2EE' does not existError Code: -1
Call:SELECT ID, NAME, SALARY, STARTDATE, DEPARTMENT_ID, MANAGER_ID, ADDRESS_ID FROM EMPLOYEE
Query:ReportQuery(examples.model.Employee)
--------------------
I attempted to match the configuration with the J2EE Tutorial.
By Derby Database Configurations are:
Edit JDBC Resource
JNDI Name: jdbc/jpqlExample
Pool Name: jpqlExamplePool
Edit Connection Pool
name: jpqlExamplePool
Datasource Classname: org.apache.derby.jdbc.ClientDataSource
Resource Type: javax.sql.DataSource
DatabaseName jpqlExamples
Password j2ee
User j2ee
ServerName localhost
PortNumber 1527
Please help in advance.
Tony
[Message sent by forum member 'mrbigman' (mrbigman)]
http://forums.java.net/jive/thread.jspa?messageID=222213