quality@glassfish.java.net

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

From: Adam Bien <abien_at_adam-bien.com>
Date: Wed, 03 Sep 2008 17:53:22 +0200

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]|#]
>
>
>