-rw-r--r-- 1 lurie lurie  29418160 2010-12-31 16:47 apache-openjpa-2.0.1-binary.zip
-rw-r--r-- 1 lurie lurie 427579388 2010-12-31 17:35 db2exc_972_LNX_x86.tar.gz
-rw-r--r-- 1 lurie lurie  69655311 2010-12-31 17:08 extremescaletrial710.zip
-rw-r--r-- 1 lurie lurie 356157440 2010-12-31 17:34 iif.11.70.UC1IE.Linux-RHEL5.tar

				
lurie@merlin:/work/dwOpenJPA/work/openjpa/apache-openjpa-2.0.1/examples/hellojpa$ ant
Buildfile: build.xml

pre-compile:

compile:
    [javac] Compiling 2 source files

run:
     [java] 4232  hellojpa  TRACE  [main] openjpa.jdbc.SQL - t 8204368, conn 15666395 
executing stmnt 22424679 CREATE TABLE Message (id BIGINT NOT NULL, created TIMESTAMP, 
message VARCHAR(255), PRIMARY KEY (id))

     [java] 4347  hellojpa  TRACE  [main] openjpa.jdbc.SQL - t 8204368, conn 15666395 
[115 ms] spent

     [java] 4683  hellojpa  TRACE  [main] openjpa.jdbc.SQL - t 8204368, conn 15975876 
executing prepstmnt 29412736 INSERT INTO Message 
(id, created, message) VALUES (?, ?, ?) [params=?, ?, ?]

     [java] 4695  hellojpa  TRACE  [main] openjpa.jdbc.SQL - t 8204368, conn 15975876 
[12 ms] spent

     [java] 4969  hellojpa  TRACE  [main] openjpa.jdbc.SQL - t 8204368, conn 20336357 
executing prepstmnt 32685187 SELECT t0.id, t0.created, t0.message FROM Message t0

     [java] 4970  hellojpa  TRACE  [main] openjpa.jdbc.SQL - t 8204368, conn 20336357 
[1 ms] spent

     [java] Hello Persistence! (created on: Mon Jan 03 13:18:48 EST 2011)

BUILD SUCCESSFUL
Total time: 10 seconds

				
        <property name="openjpa.ConnectionPassword" 
                value="secret"/>


		<property name="openjpa.DataCache"
	          value="com.ibm.websphere.objectgrid.openjpa.ObjectGridDataCache(
       		   ObjectGridName=BasicTestObjectGrid,ObjectGridType=EMBEDDED,
       		   maxNumberOfReplicas=4)"/>
		<property name="openjpa.QueryCache"
          	value="com.ibm.websphere.objectgrid.openjpa.ObjectGridQueryCache()"/>
		<property name="openjpa.RemoteCommitProvider" value="sjvm"/>



        <properties>
    <persistence-unit>

				
 <fileset dir="${root}">
            <include name="openjpa-all-*.jar"/>
            <include name="lib/derby*.jar"/>
        <fileset>
        <!-- add path to the eXtreme Scale jar file -->
         <pathelement path="xs"/>
        <fileset dir="/home/lurie/tmp/xs71/ObjectGrid/lib">
            <include name="objectgrid.jar"/>
        <fileset>
        <!-- end of mods to find  eXtreme Scale jar file -->

    </path>

				
/work/dwOpenJPA/work/openjpa/apache-openjpa-2.0.1/examples/hellojpa$ ant
[java]  ReplicatedPar I CWOBJ1511I: BasicTestObjectGrid:IBM_SYSTEM_ENTITYMANAGER_MAPSET:0
		 (primary) is open for business.
     [java]  ReplicatedPar I CWOBJ1511I: BasicTestObjectGrid:MAPSET_BasicTestObjectGrid:0
		 (primary) is open for business.
     [java]  ObjectGridRes I CWOBJ3134I: The ObjectGrid type is embedded and the default 
		maximum number of replicas is 47.  The maximum number of replicas must be 
		greater than or equal to the number of JVMs in the system.
     [java] hellojpa  TRACE  [P=324170:O=0:CT] openjpa.jdbc.SQL - <t 1720215176, 
		conn 362616221> executing prepstmnt 652224224 INSERT INTO Message 
		(id, created, message) VALUES (?, ?, ?) [params=?, ?, ?]
     [java] hellojpa  TRACE  [P=324170:O=0:CT] openjpa.jdbc.SQL - <t 1720215176, 
		conn 362616221> [212 ms] spent
... lines deleted ...
     [java] hellojpa  TRACE  [P=324170:O=0:CT] openjpa.jdbc.SQL - <t 1720215176, 
		conn 696330625> executing prepstmnt 856306442 SELECT t0.id, t0.created, 
		t0.message FROM Message t0
     [java] hellojpa  TRACE  [P=324170:O=0:CT] openjpa.jdbc.SQL - <t 1720215176, 
		conn 696330625> [1 ms] spent

				
        EntityManager em = factory.createEntityManager();

        // *** loop here to put a bunch of rows in the database
            for ( int i=0; i<100;i++)
        {
        
        // *** don't forget to put a closing } below

        // Begin a new local transaction so that we can persist a new entity
        em.getTransaction().begin();

        // Create and persist a new Message entbity
        em.persist(new Message("Hello Persistence!"));

        // Commit the transaction, which will cause the entity to
        // be stored in the database
        em.getTransaction().commit();

        // *** end of loop
        }

				
 // Create a fresh, new EntityManager
        EntityManager em2 = factory.createEntityManager();

        // **** set up a timer of how long the queries take
        long starttm = System.currentTimeMillis();


        // Perform a simple query for all the Message entities
        Query q = em2.createQuery("select m from Message m");

        // Go through each of the entities and print out each of their
        // messages, as well as the date on which it was created
        for (Message m : (List<Message> q.getResultList()) {

        // *** better comment this out or 20,000 prints are coming back!
        //  System.out.println(m.getMessage()
        //      + " (created on: " + m.getCreated() + ")");

        }
        // *** report on the first run
       long end1sttm = System.currentTimeMillis();
       System.out.println("\n\nfirst run took: " + (end1sttm-starttm) +
		"  millisec\n\n\n");

        
        // **** second run should be in local cache
        // Perform a simple query for all the Message entities
        Query q2 = em2.createQuery("select m from Message m");

        // Go through each of the entities and print out each of their
        // messages, as well as the date on which it was created
        for (Message m : (List<Message> q2.getResultList()) {
         //System.out.println(m.getMessage() 
		//+ " (created on: " + m.getCreated() + ")");
        }
        long end2ndtm = System.currentTimeMillis();
        System.out.println("\n\nsecond run, from cache took: " 
		+ (end2ndtm-end1sttm) + "  millisec\n\n\n");


        // Again, it is always good to clean up after ourselves
        em2.close();

				
 [java] [1/26/11 11:00:11:776 EST] 3a883a88 SystemOut     O 
     [java] 
     [java] first run took: 3761  millisec
     [java] 
     [java] 
     [java] 
     [java] [1/26/11 11:00:11:865 EST] 3a883a88 SystemOut     O 
     [java] 
     [java] second run, from cache took: 89  millisec
     [java] 
     [java] 

				
build.xml

<project default="usagewarning">>

    <property name="parent" value="${basedir}/.."/>
    <property name="root" value="${parent}/.."/>

    <!-- database connection properties
    <property name="dbdriver" value="org.apache.derby.jdbc.EmbeddedDriver"/>
    <property name="dburl"
        value="jdbc:derby:${basedir}/${example}-database;create=true"/>
    <property name="dbuser" value=""/>
    <property name="dbpass" value=""/>

-->
<!-- database connection properties -->
<!-- informix instead of derby -->

    <property name="dbdriver" value="com.informix.jdbc.IfxDriver"/>
    <property name="dburl"
        value="jdbc:informix-sqli://merlin:54321/idsopenjpa:informixserver=ids115"/>
    <property name="dbuser" value="informix"/>
    <property name="dbpass" value="idsr0cks"/>

    <target name="usagewarning">


PATH CHANGES

<path id="classpath"
        description="The classpath to use for compiling and running">
        <pathelement path="${parent}"/>
        <fileset dir="${root}">
            <include name="**/*.jar"/>
        </fileset>
        <pathelement path="xs"/>
        <fileset dir="/home/lurie/tmp/xs71/ObjectGrid/lib">
            <include name="objectgrid.jar"/>
        </fileset>
        <pathelement path="ifx"/>
        <fileset dir="/opt/IBM/informix/jdbc/lib">
            <include name="ifxjdbc.jar"/>
        </fileset>
    </path>

Informix Configuration

Don't create any tables, just a database.  It seems almost too easy.

informix@merlin:~$ dbaccess - - 
> create database idsopenjpa with buffered log;

Database created.

				

  [java] [1/26/11 17:28:38:751 EST] 72887288 SystemOut     O 
     [java] 
     [java] first run took: 1096  millisec rows processed= 10000
     [java] 
     [java] 
     [java] 
     [java] [1/26/11 17:28:38:800 EST] 72887288 SystemOut     O 
     [java] 
     [java] second run, from cache took: 49  millisec
     [java] 

				

create table "informix".message 
  (
    id decimal(32,0) not null ,
    created datetime year to fraction(3),
    message varchar(255),
    primary key (id) 
  );