{"id":22,"date":"2009-11-25T17:53:33","date_gmt":"2009-11-25T17:53:33","guid":{"rendered":"http:\/\/salientsoft.co.uk\/?p=22"},"modified":"2009-12-17T13:19:12","modified_gmt":"2009-12-17T13:19:12","slug":"eclipsejpa-outside-containerglassfish-example","status":"publish","type":"post","link":"https:\/\/salientsoft.co.uk\/?p=22","title":{"rendered":"Eclipse\/JPA outside container\/Glassfish example"},"content":{"rendered":"

JPA Eclipse + GlassFish + Oracle XE \u2013 Outside EJB Container<\/span><\/strong><\/p>\n

Introduction<\/span><\/strong><\/p>\n

This example details the configuration of JPA running in Eclipse, using EclipseLink and GlassFish 2.1 and Oracle XE.
\nEclipselink therefore overrides the built in TopLink Essentials JPA in GlassFish 2.1.<\/p>\n

\u00a0<\/p>\n

Installation<\/span><\/strong><\/p>\n

    \n
  1. Install the latest Java JDK 1.6 release<\/li>\n
  2. Install the Eclipse Galilieo Java EE package (includes EclipseLink)<\/li>\n
  3. Install GlassFish 2.1<\/li>\n
  4. Install the GlassFish Eclipse Plugin (see web notes about downloading\/installing this)<\/li>\n
  5. Download and install Oracle XE<\/li>\n<\/ol>\n

    \u00a0<\/strong><\/p>\n

    \u00a0Database Creation<\/span><\/strong><\/p>\n

    In the Oracle XE database home page, click on Administration, then Manage Database Users, create database user. For testing purposes, you can give the user all roles and privileges, however you would not do this in a production environment. Note that in Oracle, creating a database user also creates an empty database schema, as the two terms are synonymous. A single Oracle XE database installation can have any number of schemas (users), all as distinct logical databases in the same database instance (container).<\/p>\n

    \u00a0<\/p>\n

    \u00a0Connection Pool \/ JDB Resource Creation<\/span><\/strong><\/p>\n

    Open the GlassFish administration web page (by default this is at http:\/\/localhost:4848<\/a>) and log in (default is admin\/adminadmin). Open Resources, JDBC, and click on Connection Pools – the text, not the adjacent arrow. This will display the connection pools in the RHS pane. Click on New. Name the pool JPATestPool. Select a resource type of javax.sql.datasource, <\/strong>and select Oracle as the database vendor. Click Next, then in the additional properties, set the following values :-<\/p>\n\n\n\n\n\n\n
    \n

    Property Name<\/strong><\/p>\n<\/td>\n

    		\n

    Value<\/strong><\/p>\n<\/td>\n<\/tr>\n

    User<\/td>\nYour XE database username<\/td>\n<\/tr>\n
    Password<\/td>\nYour XE database password<\/td>\n<\/tr>\n
    URL<\/td>\njdbc:oracle:thin:@localhost:1521:xe<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \u00a0
    \nClick Save to save the new connection pool.<\/p>\n

    Click on JDBC Resources in the left hand pane (again, the wording not the arrow), and click new to create a new resource. Select the conncetion pool just created in the dropdown list. For the JNDI name, enter jdbc\/JPATestPool and click OK to save. Note that the JNDI name given must match the name given in the <non-jta-data-source> element value in persistence.xml.<\/p>\n

    \u00a0<\/strong><\/p>\n

    Project Creation<\/span><\/strong><\/p>\n

      \n
    1. Create a new JPA project with the wizard. Select \u201cGlassFish v2.1 Java EE 5\u201d as the target runtime.<\/li>\n
    2. Select either Default, Utility, or minimal for the configuration \u2013 this determines which facets are added to the project. Facets can be added later via the \u201cProject Facets\u201d page in the project properties.
      \nAll of the above configurations worked.<\/li>\n
    3. Following this, a connectivity driver (for Oracle in this case) needs adding to Eclipse and then to the project as follows :-
      \nDownload ojdbc14.jar<\/strong> from Oracle.com here :-
      \nhttp:\/\/www.oracle.com\/technology\/software\/tech\/java\/sqlj_jdbc\/htdocs\/jdbc_10201.html<\/a><\/li>\n
    4. Copy the file to the glassfish\\lib folder under the GlassFish installation directory and Restart GlassFish.
      \nN.B. the jar file must be placed in this location<\/li>\n
    5. Click on Window, preferences, and select Data Management, Connectivity, Driver Definitions in the left pane.<\/li>\n
    6. Click Add, and assuming Oracle XE is in use, select \u201cOracle Thin Driver\u201d for Oracle 10.<\/li>\n
    7. Click on the Jar List tab. ojdbc14.jar <\/strong>should be listed. Browse for the above location where the actual jar was placed (<GlassFish_Home>\\glassfish\\lib) and select the jar from there.
      \nThe properties tab allows defaults to be set up for database connectivity, but these values will be added in GlassFish when the data source is created.<\/li>\n
    8. \u00a0Select Java Build Path in the project properties for the project you created above. Pick the libraries tab, and click Add Library. Click \u201cAdd Library\u201d and select \u201cConnectivity Driver Definitions\u201d from the list. Select \u201cOracle thin Driver\u201d from the drop down. If it is not present (i.e. because you did not create it correctly as above), you can click the button\/icon to the right of the drop down and add the connectivity driver to Eclipse from there. Once done, you select it in the drop down then click finish to add it to the project.<\/li>\n<\/ol>\n

      \u00a0<\/p>\n

      \u00a0Creating the Source Code<\/span><\/strong><\/p>\n

      Create the following java classes in Eclipse by right clicking the \u201csrc\u201d folder of the project and selecting New,\u00a0 Class. For the package name, enter uk.co.salientsoft.jpatest.domain. For the UserInfo class (which is the persisted class), the combined package and classname must match the value given in the <class> element in persistence.xml.<\/p>\n

      Class: JPATest<\/span><\/strong><\/p>\n

      package uk.co.salientsoft.jpatest.domain;\r\nimport javax.persistence.*;\r\npublic class JPATest {\r\n\r\n\u00a0private static final String PERSISTENCE_UNIT_NAME = \"JPATest\";\r\n\u00a0private EntityManagerFactory factory;\r\n\u00a0\r\n\u00a0public static void main(String[] args) {\r\n\u00a0\u00a0JPATest jpaTest = new JPATest();\r\n\u00a0\u00a0jpaTest.addEntries();\r\n\u00a0}\r\n\r\n\u00a0public JPATest() {\r\n\u00a0\u00a0factory = Persistence.createEntityManagerFactory(PERSISTENCE_UNIT_NAME);\r\n\u00a0}\r\n\u00a0\r\n\u00a0public void addEntries() {\r\n\u00a0\u00a0EntityManager em = factory.createEntityManager();\r\n\r\n\u00a0\u00a0\/\/ Begin a new local transaction so that we can persist a new entity\r\n\u00a0\u00a0em.getTransaction().begin();\r\n\r\n\u00a0\u00a0\/\/ Read the existing entries\r\n\u00a0\u00a0Query q = em.createQuery(\"select u from UserInfo u\");\r\n\r\n\u00a0\u00a0\/\/ Do we have entries?\r\n\u00a0\u00a0boolean createNewEntries = (q.getResultList().size() == 0);\r\n\r\n\u00a0\u00a0\/\/ No, so lets create new entries\r\n\u00a0\u00a0if (createNewEntries) {\r\n\r\n\u00a0\u00a0\u00a0UserInfo userInfo;\u00a0\u00a0\u00a0\r\n\u00a0\u00a0\u00a0\r\n\u00a0\u00a0\u00a0userInfo = new UserInfo();\r\n\u00a0\u00a0\u00a0userInfo.setUserName(\"Bilbo.Baggins\");\r\n\u00a0\u00a0\u00a0em.persist(userInfo);\r\n\u00a0\u00a0\u00a0userInfo = new UserInfo();\r\n\u00a0\u00a0\u00a0userInfo.setUserName(\"Frodo.Baggins\");\r\n\u00a0\u00a0\u00a0em.persist(userInfo);\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\u00a0\u00a0}\r\n\r\n\u00a0\u00a0\/\/ Commit the transaction, which will cause the entity to\r\n\u00a0\u00a0\/\/ be stored in the database\r\n\u00a0\u00a0em.getTransaction().commit();\r\n\u00a0\u00a0\r\n\u00a0\u00a0\/\/ It is always good practice to close the EntityManager so that\r\n\u00a0\u00a0\/\/ resources are conserved.\r\n\u00a0\u00a0em.close();\r\n\u00a0}\u00a0\r\n}<\/pre>\n
      Class: UserInfo<\/span><\/strong><\/p>\n
      package uk.co.salientsoft.jpatest.domain;\r\nimport java.io.Serializable;\r\nimport javax.persistence.*;\r\n\r\n\/**\r\n\u00a0* Entity implementation class for Entity: UserInfo\r\n\u00a0*\r\n\u00a0*\/\r\n@Entity\r\npublic class UserInfo implements Serializable {\r\n\u00a0\r\n\u00a0@Id\r\n\u00a0@GeneratedValue(strategy=GenerationType.AUTO)\r\n\u00a0private long userID;\r\n\u00a0private String userName;\r\n\u00a0private static final long serialVersionUID = 1L;\u00a0\r\n\u00a0public UserInfo() {\r\n\u00a0\u00a0super();\r\n\u00a0}\r\n\u00a0\r\n\u00a0public long getUserID() {\r\n\u00a0\u00a0\u00a0return this.userID;\r\n\u00a0}\r\n\r\n\u00a0public void setUserID(long userID) {\r\n\u00a0\u00a0this.userID = userID;\r\n\u00a0}\r\n\u00a0\u00a0\u00a0\r\n\u00a0public String getUserName() {\r\n\u00a0\u00a0\u00a0return this.userName;\r\n\u00a0}\r\n\r\n\u00a0public void setUserName(String userName) {\r\n\u00a0\u00a0this.userName = userName;\r\n\u00a0}\r\n}\r\n\u00a0<\/pre>\n
      Persistence.xml<\/span><\/strong><\/p>\n
      <?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<persistence version=\"1.0\"\r\n\u00a0xmlns=\"http:\/\/java.sun.com\/xml\/ns\/persistence<\/a>\"\r\n   xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\r\n<\/a>\u00a0xsi:schemaLocation=\"http:\/\/java.sun.com\/xml\/ns\/persistence<\/a>\r\n   http:\/\/java.sun.com\/xml\/ns\/persistence\/persistence_1_0.xsd<\/a>\">\r\n\u00a0<persistence-unit name=\"JPATest\" transaction-type=\"RESOURCE_LOCAL\">\r\n\u00a0\u00a0<provider>org.eclipse.persistence.jpa.PersistenceProvider<\/provider>\r\n\u00a0\u00a0<non-jta-data-source>jdbc\/JPATestPool<\/non-jta-data-source>\r\n\u00a0\u00a0<class>uk.co.salientsoft.jpatest.domain.UserInfo<\/class>\r\n\u00a0\u00a0<properties>\r\n\u00a0\u00a0\u00a0<property name=\"eclipselink.target-server\" value=\"None\" \/>\r\n\u00a0\u00a0\u00a0<property name=\"eclipselink.logging.level\" value=\"FINEST\" \/>\r\n\u00a0\u00a0\u00a0<property name=\"eclipselink.session-name\" value=\"JPATestSession\" \/>\r\n\r\n\u00a0\u00a0\u00a0<!-- EclipseLink should create the database schema automatically -->\r\n\u00a0\u00a0\u00a0<property name=\"eclipselink.ddl-generation\" value=\"drop-and-create-tables\" \/>\r\n\u00a0\u00a0\u00a0<property name=\"eclipselink.ddl-generation.output-mode\" value=\"database\" \/>\r\n\r\n\u00a0\u00a0<\/properties>\r\n\u00a0<\/persistence-unit>\r\n<\/persistence><\/pre>\n
      \u00a0<\/strong><\/p>\n
      Notes\u00a0 on Persistence.xml<\/span><\/strong><\/p>\n
      \u00a0<persistence-unit name=\"JPATest\" transaction-type=\"RESOURCE_LOCAL\"><\/pre>\n
      The persistence unit defines a related grouping of classes, metadata etc. which are being persisted .<\/p>\n
      \u00a0NOTE \u2013 ensure that the value matches the one passed to createEntityManagerFactory in the code, or the call causes a stack trace citing no persistence provider found \u2013 all the available persistence providers are tried and listed and they all return null. They are all tried to see if they support the given persistence unit\u00a0 (i.e. are they listed as the provider for that persistence unit in persistence.xml) hence the error.<\/p>\n
      \u00a0Transaction-type needs to be \u201dRESOURCE_LOCAL\u201d if jpa is used outside the EJB container, in which case the datasource is defined as a <non-jta-data-source>. Note that the datasource in this case is still defined in GlassFish.<\/p>\n
      The alternative for jpa usage inside the conainer , e.g. from a session bean, would be to defined transaction-type as \u201cJTA\u201d and the datasource as a <jta-data-source>.<\/p>\n
      <property name=\"eclipselink.target-server\" value=\"None\" \/><\/pre>\n
      \u00a0<\/strong><\/p>\n
      Note<\/strong>\u00a0 that with JPA inside the container, the above property would have the following value :-<\/p>\n
      <property name=\"eclipselink.target-server\" value=\"SunAS9\" \/><\/pre>\n
      \u00a0<\/p>\n
      When set to “SunAS9”, you must<\/strong> use a JTA data source and JTA transaction type or you get an error. When you use “None” you can use <non-jta-data-source> and “RESOURCE_LOCAL”, but note that you can still refer to the data source defined in GlassFish, or you can define one explicitly in persistence.xml. You could define one explicitly in persistence.xml as follows :-<\/p>\n
       <property name=\"eclipselink.jdbc.url\" value=\"jdbc:oracle:thin:@localhost:1521:xe\"\/>\r\n\u00a0<property name=\"eclipselink.jdbc.user\" value=\"jpatest\"\/>\r\n\u00a0<property name=\"eclipselink.jdbc.password\" value=\"jpatest\"\/>\r\n\u00a0<property name=\"eclipselink.jdbc.driver\" value=\"oracle.jdbc.OracleDriver\"\/><\/pre>\n
      \u00a0<\/p>\n
      The mechanism used to drop and create the tables automatically (\u201cdrop-and-create-tables\u201d value) is jpa provider dependant (and may not always be available). When it is used with EclipseLink as above, a stack trace with a number of errors is dumped when it tries to drop non existant tables etc., and due to other issues. If you check in Oracle XE and can see the tables and the data, the errors can be ignored. The drop and create only needs to be done once to create the tables. You can remove this property from persistence.xml to prevent the tables being dropped and created each time.\u00a0Note that this can also be done directly from Eclipse via the project context menu, as detailed here<\/a><\/strong>.
      \n\u00a0<\/p>\n
      Running the application<\/span><\/strong><\/p>\n
        \n
      1. In Eclipse, select Window, Show View, Servers. If GlassFish is not listed, right click the server window and select New Server. Then Select GlassFish 2.1 Java EE 5. Click Next, and browse for the <GlassFish_Home>\\glassfish directory (leave the JRE as the default).<\/li>\n
      2. Right click the server in the servers view, then select start to start it if it is not running.<\/li>\n
      3. Right click on JPATest.java and select Run as, then Java application.<\/li>\n
      4. The application should then run and populate the database. Log in to the XE database home page as the user\/schema you created, and click on the object browser.<\/li>\n
      5. Click on the UserInfo table and you should see the rows which were created.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
        JPA Eclipse + GlassFish + Oracle XE \u2013 Outside EJB Container Introduction This example details the configuration of JPA running in Eclipse, using EclipseLink and GlassFish 2.1 and Oracle XE. Eclipselink therefore overrides the built in TopLink Essentials JPA in GlassFish 2.1. \u00a0 Installation Install the latest Java JDK 1.6 release Install the Eclipse Galilieo […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[9,10,182,15],"_links":{"self":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/22"}],"collection":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=22"}],"version-history":[{"count":31,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/22\/revisions"}],"predecessor-version":[{"id":24,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/22\/revisions\/24"}],"wp:attachment":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=22"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=22"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}