Skip to main content

Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

Difference between revisions of "EclipseLink/Examples/JPA/Derby"

m (Running EclipseLink on the Derby Database)
m (Running EclipseLink on the Derby Database)
Line 4: Line 4:
 
==Retrofitting an existing Java SE application to use Derby==
 
==Retrofitting an existing Java SE application to use Derby==
 
===Add persistence.xml===
 
===Add persistence.xml===
 
+
<source lang="java">
 +
<?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.jdbc.driver" value="org.apache.derby.jdbc.ClientDriver"/>
 +
      <property name="eclipselink.target-database" value="Derby"/>           
 +
      <property name="eclipselink.jdbc.url" value="jdbc:derby://localhost:1527/weblogic;create=true"/>
 +
      <property name="eclipselink.jdbc.user" value="APP"/>
 +
      <property name="eclipselink.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>
 +
</source>
 
===Add derby jars===
 
===Add derby jars===
  
 
==References==
 
==References==
 
*Originated 20091113 for Derby 10.5.3.0
 
*Originated 20091113 for Derby 10.5.3.0

Revision as of 21:04, 3 December 2009

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.

Retrofitting an existing Java SE application to use Derby

Add 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.jdbc.driver" value="org.apache.derby.jdbc.ClientDriver"/>
      <property name="eclipselink.target-database" value="Derby"/>            
      <property name="eclipselink.jdbc.url" value="jdbc:derby://localhost:1527/weblogic;create=true"/>
      <property name="eclipselink.jdbc.user" value="APP"/>
      <property name="eclipselink.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

References

  • Originated 20091113 for Derby 10.5.3.0

Back to the top