quality@glassfish.java.net

Re: [Issue 5836] [entity-persistence] Sequence isn't created which leads to exception

From: Sherry Shen <Sherry.Shen_at_Sun.COM>
Date: Wed, 03 Sep 2008 09:33:52 -0700

Hi Adam,

I added number for test steps.
--1. deploy app, "asadmin deploy LeanestCrud.war"
--2. access URI, /LeanestCrud/BookManagementView
--3. see "Book created!" on browser.
--4. modified persistence.xml with more logging message.
     <property name="eclipselink.logging.level" value="FINE"/>
--5. restart server
--6. access URI again,
--7. see "Book created!" on browser and server.log about SEQ and BOOK.

Your example works fine at step 3 without restart server.
The restart server at step 5 for logging change in step 4.

Now, I backed up the logging change
% pwd
/space/test1/v3/glassfish/domains/domain1/applications/LeanestCrud/WEB-INF/classes/META-INF
% cp persistence.xml~ persistence.xml
and access app and see FINE log is still shown.
[#|2008-09-03T09:24:03.719-0700|FINE||org.eclipse.persistence.session.file:
/space/test1/v3/glassfish/domains/domain1/applications/LeanestCrud/WEB-INF/classes/-book.sql
|_ThreadID=17;_ThreadName=Thread-4;ClassName=null;MethodName=null;|
INSERT INTO BOOK (ID, NAME) VALUES (?, ?)
        bind => [2, Productive Java EE]|#]

Thanks!

Sherry
Adam Bien wrote, On 9/3/2008 8:53 AM:

> Sherryshen,
>
> why did you restart the server? It wasn't necessary in GF v2...
>
> regards,
>
> adam
> sherryshen_at_dev.java.net schrieb:
>
>> https://glassfish.dev.java.net/issues/show_bug.cgi?id=5836
>>
>>
>>
>>
>>
>>
>> ------- Additional comments from sherryshen_at_dev.java.net Wed Sep 3
>> 15:35:10 +0000 2008 -------
>> I saw that attached example works fine.
>> --v3 b22 promoted + ejb from Update Center.
>> --deploy app, "asadmin deploy LeanestCrud.war"
>> --access URI, /LeanestCrud/BookManagementView
>> --see "Book created!" on browser.
>> --modified persistence.xml with more logging message.
>> <property name="eclipselink.logging.level" value="FINE"/>
>> --restart server
>> --access URI again,
>> --see "Book created!" on browser and server.log about SEQ and BOOK.
>>
>> [#|2008-09-03T08:25:14.990-0700|FINE||org.eclipse.persistence.session.file:/space/test1/v3/glassfish/domains/domain1/applications/LeanestCrud/WEB-INF/classes/-book.sql|_ThreadID=16;_ThreadName=Thread-4;ClassName=null;MethodName=null;|DELETE
>>
>> FROM SEQUENCE WHERE SEQ_NAME = SEQ_GEN|#]
>>
>> [#|2008-09-03T08:25:15.036-0700|FINE||org.eclipse.persistence.session.file:/space/test1/v3/glassfish/domains/domain1/applications/LeanestCrud/WEB-INF/classes/-book.sql|_ThreadID=16;_ThreadName=Thread-4;ClassName=null;MethodName=null;|SELECT
>>
>> * FROM SEQUENCE WHERE SEQ_NAME = SEQ_GEN|#]
>>
>> [#|2008-09-03T08:25:15.064-0700|FINE||org.eclipse.persistence.session.file:/space/test1/v3/glassfish/domains/domain1/applications/LeanestCrud/WEB-INF/classes/-book.sql|_ThreadID=16;_ThreadName=Thread-4;ClassName=null;MethodName=null;|INSERT
>>
>> INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values (SEQ_GEN, 0)|#]
>>
>> [#|2008-09-03T08:25:15.171-0700|FINE||org.eclipse.persistence.session.file:/space/test1/v3/glassfish/domains/domain1/applications/LeanestCrud/WEB-INF/classes/-book.sql|_ThreadID=16;_ThreadName=Thread-4;ClassName=null;MethodName=null;|UPDATE
>>
>> SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?
>> bind => [50, SEQ_GEN]|#]
>>
>> [#|2008-09-03T08:25:15.218-0700|FINE||org.eclipse.persistence.session.file:/space/test1/v3/glassfish/domains/domain1/applications/LeanestCrud/WEB-INF/classes/-book.sql|_ThreadID=16;_ThreadName=Thread-4;ClassName=null;MethodName=null;|SELECT
>>
>> SEQ_COUNT FROM SEQUENCE WHERE SEQ_NAME = ?
>> bind => [SEQ_GEN]|#]
>>
>> [#|2008-09-03T08:25:15.277-0700|FINE||org.eclipse.persistence.session.file:/space/test1/v3/glassfish/domains/domain1/applications/LeanestCrud/WEB-INF/classes/-book.sql|_ThreadID=16;_ThreadName=Thread-4;ClassName=null;MethodName=null;|INSERT
>>
>> INTO BOOK (ID, NAME) VALUES (?, ?)
>> bind => [1, Productive Java EE]|#]
>>
>>
>>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: quality-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: quality-help_at_glassfish.dev.java.net
>