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:42:01 +0200

Sherryshen,

I saw the output too, but a huge stacktrace as well. Futher I didn't
found the record in the DB (with DB-explorer)...
It seems like the exception was swallowed somehow - therefore the
successful output. Could you please re-check it?

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


-- 
 Consultant, Author, Java Champion
 
 Homepage: www.adam-bien.com
 Weblog: blog.adam-bien.com
 eMail:  abien_at_adam-bien.com
 Mobile: 0049(0)170 280 3144
 Books: Enterprise Architekturen (ISBN: 393504299X),
        Java EE 5 Architekturen  (ISBN: 3939084247),
        J2EE Patterns, J2EE Hotspots, Enterprise Frameworks and Struts