Hi Adam,
I searched my server.log again for
"Caused by: java.sql.SQLSyntaxErrorException: Die Tabelle/Ansicht
'SEQUENCE' istnicht vorhanden." or others, but did not find them.
I do see expected Exceptions as enclosed.
cc Mitesh who works JPA support.
Hi Mitesh,
Would you please check when we may see the error Adam reported?
Is it possible to reduce the stacktrace for expected Exceptions
so that we can find the real problem easily?
Thanks!
Sherry
PS:
% grep SQLSyntaxErrorException server.log
% grep SQLException server.log
Internal Exception: java.sql.SQLException: 'DROP TABLE' cannot be
performed on 'BOOK' because it does not exist.
.......
Internal Exception: java.sql.SQLException: Table/View 'SEQUENCE'
already exists in Schema 'DBUSER'.
They are due to no BOOK table doesn't exist in the initial run
or due to an existing SEQUENCE in previous run.
Adam Bien wrote, On 9/3/2008 8:42 AM:
> 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]|#]
>>
>>
>>
>
>
>