Saturday, May 15, 2010

EclipseLink Oracle Junit persistence.xml file

Running example from
Professional Oracle WebLogic Server

Using EclipseLink2.0.2
http://www.eclipse.org/eclipselink/downloads/


<?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="TestPU" transaction-type="RESOURCE_LOCAL">

<!-- <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider> -->

<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>

<class>com.bigrez.jpa.ValueObject</class>
<class>com.bigrez.jpa.DomainEntity</class>
<class>com.bigrez.domain.RoomType</class>
<class>com.bigrez.domain.ReservationRate</class>
<class>com.bigrez.domain.Reservation</class>
<class>com.bigrez.domain.Rate</class>
<class>com.bigrez.domain.Property</class>
<class>com.bigrez.domain.Offer</class>
<class>com.bigrez.domain.Money</class>
<class>com.bigrez.domain.Inventory</class>
<class>com.bigrez.domain.GuestProfile</class>
<class>com.bigrez.domain.CardDetails</class>
<class>com.bigrez.domain.Address</class>

<properties>

<!-- property name="eclipselink.target-server" value="WebLogic_10"/-->

<property name="eclipselink.logging.level" value="FINEST"/>
<property name="eclipselink.jdbc.driver" value="oracle.jdbc.driver.OracleDriver"/>
<property name="eclipselink.jdbc.platform" value="org.eclipse.persistence.platform.database.oracle.OraclePlatform"/>
<property name="eclipselink.jdbc.url" value="jdbc:oracle:thin:@localhost:1521:xe"/>
<property name="eclipselink.jdbc.user" value="xxxxxx"/>
<property name="eclipselink.jdbc.password" value="xxxxx"/>



</properties>
</persistence-unit>
</persistence>




[EL Info]: 2010-05-15 14:38:02.033--ServerSession(22118235)--Thread(Thread[Main Thread,5,main])--EclipseLink, version: Eclipse Persistence Services - 2.0.2.v20100323-r6872
[EL Fine]: 2010-05-15 14:38:09.491--Thread(Thread[Main Thread,5,main])--Detected Vendor platform: org.eclipse.persistence.platform.database.oracle.Oracle10Platform
[EL Config]: 2010-05-15 14:38:10.404--ServerSession(22118235)--Connection(24925706)--Thread(Thread[Main Thread,5,main])--connecting(DatabaseLogin(
platform=>Oracle10Platform
user name=> "bigrez"
datasource URL=> "jdbc:oracle:thin:@localhost:1521:xe"
))
[EL Config]: 2010-05-15 14:38:11.016--ServerSession(22118235)--Connection(24928619)--Thread(Thread[Main Thread,5,main])--Connected: jdbc:oracle:thin:@localhost:1521:xe
User: BIGREZ
Database: Oracle Version: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Driver: Oracle JDBC driver Version: 10.2.0.1.0XE
[EL Config]: 2010-05-15 14:38:11.023--ServerSession(22118235)--Connection(24936732)--Thread(Thread[Main Thread,5,main])--connecting(DatabaseLogin(
platform=>Oracle10Platform
user name=> "bigrez"
datasource URL=> "jdbc:oracle:thin:@localhost:1521:xe"
))
[EL Config]: 2010-05-15 14:38:11.05--ServerSession(22118235)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--Connected: jdbc:oracle:thin:@localhost:1521:xe
User: BIGREZ
Database: Oracle Version: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Driver: Oracle JDBC driver Version: 10.2.0.1.0XE
[EL Info]: 2010-05-15 14:38:12.474--ServerSession(22118235)--Thread(Thread[Main Thread,5,main])--file:/home/dave/workspace/javaEE/bigRezGenerated/build/classes/_TestPU login successful
[EL Fine]: 2010-05-15 14:38:12.941--ServerSession(22118235)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--SELECT COMMON_SEQUENCE.NEXTVAL FROM DUAL
[EL Fine]: 2010-05-15 14:38:15.348--ClientSession(21859967)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--INSERT INTO GUESTPROFILE (ID, LASTNAME, PHONE, EMAIL, LOGON, FIRSTNAME, PASSWORD, VERSION, CARDNUM, CARDTYPE, CARDEXP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [551, null, null, null, gp1, null, password, 1, null, null, null]
[EL Fine]: 2010-05-15 14:38:15.616--ClientSession(21859967)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--INSERT INTO PROPERTY (ID, PHONE, DESCRIPTION, FEATURES, IMAGEFILE, VERSION, POSTALCODE, ADDRESS1, STATECODE, ADDRESS2, CITY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [552, phone, description, features, null, 1, 5, 1, 4, 2, 3]
[EL Fine]: 2010-05-15 14:38:15.714--ClientSession(21859967)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--INSERT INTO ROOMTYPE (ID, SMOKINGFLAG, DESCRIPTION, FEATURES, NUMROOMS, MAXADULTS, VERSION, PROPERTY_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
bind => [553, false, description, features, 0, 0, 1, 552]
[EL Fine]: 2010-05-15 14:38:15.8--ClientSession(21859967)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--INSERT INTO GUESTPROFILE (ID, LASTNAME, PHONE, EMAIL, LOGON, FIRSTNAME, PASSWORD, VERSION, CARDNUM, CARDTYPE, CARDEXP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [557, null, null, null, gp2, null, password, 1, null, null, null]
[EL Fine]: 2010-05-15 14:38:15.805--ClientSession(21859967)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--INSERT INTO RESERVATION (ID, DEPART, CONFIRMNUM, ARRIVE, VERSION, GUESTPROFILE_ID, ROOMTYPE_ID, CARDNUM, CARDTYPE, CARDEXP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [555, 1970-01-01, 1722831502, 1970-01-01, 1, 551, 553, number, type, expiry]
[EL Fine]: 2010-05-15 14:38:15.816--ClientSession(21859967)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--INSERT INTO RESERVATION (ID, DEPART, CONFIRMNUM, ARRIVE, VERSION, GUESTPROFILE_ID, ROOMTYPE_ID, CARDNUM, CARDTYPE, CARDEXP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [556, 1970-01-01, 1722791483, 1970-01-01, 1, 557, 553, number, type, expiry]
[EL Fine]: 2010-05-15 14:38:15.817--ClientSession(21859967)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--INSERT INTO RESERVATION (ID, DEPART, CONFIRMNUM, ARRIVE, VERSION, GUESTPROFILE_ID, ROOMTYPE_ID, CARDNUM, CARDTYPE, CARDEXP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [554, 1970-01-01, 1723770378, 1970-01-01, 1, 551, 553, number, type, expiry]
[EL Fine]: 2010-05-15 14:38:15.987--ClientSession(21859967)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--SELECT ID, LASTNAME, PHONE, EMAIL, LOGON, FIRSTNAME, PASSWORD, VERSION, CARDNUM, CARDTYPE, CARDEXP FROM GUESTPROFILE WHERE (ID = ?)
bind => [551]
[EL Fine]: 2010-05-15 14:38:16.074--ClientSession(21859967)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--SELECT ID, DEPART, CONFIRMNUM, ARRIVE, VERSION, GUESTPROFILE_ID, ROOMTYPE_ID, CARDNUM, CARDTYPE, CARDEXP FROM RESERVATION WHERE (GUESTPROFILE_ID = ?)
bind => [551]
[EL Fine]: 2010-05-15 14:38:16.171--ClientSession(21859967)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--SELECT ID, SMOKINGFLAG, DESCRIPTION, FEATURES, NUMROOMS, MAXADULTS, VERSION, PROPERTY_ID FROM ROOMTYPE WHERE (ID = ?)
bind => [553]
[EL Fine]: 2010-05-15 14:38:16.19--ClientSession(21859967)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--SELECT ID, PHONE, DESCRIPTION, FEATURES, IMAGEFILE, VERSION, POSTALCODE, ADDRESS1, STATECODE, ADDRESS2, CITY FROM PROPERTY WHERE (ID = ?)
bind => [552]
[EL Fine]: 2010-05-15 14:38:16.206--ClientSession(21859967)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--SELECT ID, LASTNAME, PHONE, EMAIL, LOGON, FIRSTNAME, PASSWORD, VERSION, CARDNUM, CARDTYPE, CARDEXP FROM GUESTPROFILE WHERE (ID = ?)
bind => [557]
[EL Fine]: 2010-05-15 14:38:16.227--ClientSession(21859967)--Connection(24939581)--Thread(Thread[Main Thread,5,main])--SELECT ID, DEPART, CONFIRMNUM, ARRIVE, VERSION, GUESTPROFILE_ID, ROOMTYPE_ID, CARDNUM, CARDTYPE, CARDEXP FROM RESERVATION WHERE (GUESTPROFILE_ID = ?)
bind => [557]

2 comments:

  1. Thank you for posting this blog i honestly cherished it and submit some unique blogs about oracle........visit our internet site related to oracle fusion all modules education
    from
    oracle fusion training in Hyderabad

    ReplyDelete
  2. Enjoyed your approach to explaining how it works, hope to see more blog posts from you. thank you!

    Hibernate Online Training | Java Online Training


    Hibernate Training in Chennai Java Training in Chennai

    ReplyDelete