Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "EclipseLink/Examples/JPA/Derby"
< EclipseLink | Examples | JPA
m (→Running EclipseLink on the Derby Database) |
m (→SE persistence.xml) |
||
| Line 32: | Line 32: | ||
<class>org.eclipse.persistence.example.jpa.server.business.Cell</class> | <class>org.eclipse.persistence.example.jpa.server.business.Cell</class> | ||
<properties> | <properties> | ||
| − | |||
<property name="eclipselink.target-database" value="Derby"/> | <property name="eclipselink.target-database" value="Derby"/> | ||
| − | <property name=" | + | <property name="javax.persistence.jdbc.driver" value="org.apache.derby.jdbc.ClientDriver"/> |
| − | <property name=" | + | <property name="javax.persistence.jdbc.url" value="jdbc:derby://localhost:1527/weblogic;create=true"/> |
| − | <property name=" | + | <property name="javax.persistence.jdbc.user" value="APP"/> |
| + | <property name="javax.persistence.jdbc.password" value="APP"/> | ||
<property name="eclipselink.logging.level" value="ALL"/> | <property name="eclipselink.logging.level" value="ALL"/> | ||
<property name="eclipselink.ddl-generation" value="drop-and-create-tables"/> | <property name="eclipselink.ddl-generation" value="drop-and-create-tables"/> | ||
| Line 44: | Line 44: | ||
</persistence> | </persistence> | ||
</source> | </source> | ||
| + | |||
===Add derby jars=== | ===Add derby jars=== | ||
*SE: Add '''derbyclient.jar''' to the application classpath | *SE: Add '''derbyclient.jar''' to the application classpath | ||
Revision as of 13:24, 15 January 2010
Contents
Running EclipseLink on the Derby Database
- Running EclipseLink on derby has several advantages including ease of installation and small footprint for rapid development - and the fact that it is also open source like EclipseLink.
- This tutorial is currently working with Derby 10.5.3.0.
Embedded Derby Driver VS Derby Client
Retrofitting an existing Java SE application to use Derby
WebLogic Server Console configuration
EE persistence.xml
<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="example" transaction-type="JTA"> <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider> <jta-data-source>localJTA</jta-data-source> <!-- optional --><class>org.eclipse.persistence.example.business.Cell</class> <properties> <!-- optional --><property name="eclipselink.target-database" value="org.eclipse.persistence.platform.database.DerbyPlatform"/> <property name="eclipselink.target-server" value="WebLogic_10"/> <property name="eclipselink.logging.level" value="FINEST"/> </properties> </persistence-unit> </persistence>
SE 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="dao.create.tables.derby" transaction-type="RESOURCE_LOCAL"> <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider> <class>org.eclipse.persistence.example.jpa.server.business.Cell</class> <properties> <property name="eclipselink.target-database" value="Derby"/> <property name="javax.persistence.jdbc.driver" value="org.apache.derby.jdbc.ClientDriver"/> <property name="javax.persistence.jdbc.url" value="jdbc:derby://localhost:1527/weblogic;create=true"/> <property name="javax.persistence.jdbc.user" value="APP"/> <property name="javax.persistence.jdbc.password" value="APP"/> <property name="eclipselink.logging.level" value="ALL"/> <property name="eclipselink.ddl-generation" value="drop-and-create-tables"/> <property name="eclipselink.ddl-generation.output-mode" value="database"/> </properties> </persistence-unit> </persistence>
Add derby jars
- SE: Add derbyclient.jar to the application classpath
- EE: Add derby jars to the application server classpath (Example: for WebLogic place in the modules directory)
References
- Originated 20091113 for Derby 10.5.3.0