[jboss-jira] [JBoss JIRA] (AS7-4613) hibernate.hbm2ddl.auto=create-drop fails arquillian tests, but value=create works fine

[Bartosz Baranowski (JIRA)]

    [ https://issues.jboss.org/browse/AS7-4613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12733643#comment-12733643 ] 

Bartosz Baranowski commented on AS7-4613:
-----------------------------------------

The test lacks some container setup. Without this its like poking for dark cat in dark room.
After some struggle I managed to get it in some working condition but: 
{noformat}
[0m11:43:14,761 INFO  [org.jboss.as.server] (management-handler-thread - 4) JBAS018559: Deployed "FBTutorialDemo.war"
java.io.FileNotFoundException: http://127.0.0.1:8080/FBTutorialDemo/rest/webService/UserRequest/1000/Ihave%20ZeroFriends
	at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1613)
	at com.example.domain.UtilClass.doPOST(UtilClass.java:69)
	at com.example.domain.UtilClass.createPlayerWithFriends(UtilClass.java:93)
	at com.example.domain.MyWebServiceTest.setup(MyWebServiceTest.java:41)
{noformat}
                
> hibernate.hbm2ddl.auto=create-drop fails arquillian tests, but value=create works fine
> --------------------------------------------------------------------------------------
>
>                 Key: AS7-4613
>                 URL: https://issues.jboss.org/browse/AS7-4613
>             Project: Application Server 7
>          Issue Type: Bug
>    Affects Versions: 7.1.1.Final
>            Reporter: Craig Schwarzwald
>            Priority: Critical
>              Labels: AS7, arquillian, hibernate
>
> You can find my project with the tests here:
> https://github.com/CavemanCraig/IssueWithTestsUsingCreateDrop/tags
> I created 2 tags, a v0.9 which has persistence.xml specifying value=create which you can use to prove the tests work correctly, and v1.0 which specifies value=create-drop which should work just as well, but doesn't.
> The main error that seems to be getting returned is:
> Caused by: org.h2.jdbc.JdbcSQLException: Sequence "HIBERNATE_SEQUENCE" not found; SQL statement:
> call next value for hibernate_sequence [90036-161]
> NOTE: I just thought of something.  I am running both in-container and client mode tests in this project.  It may be possible that the Hibernate DB is getting setup when the in-container tests start, and then with create-drop, AS7 drops the DB as soon as the in-container tests finish, then causing errors when the client mode tests start to run.  This could explain why I don't get the errors when I run with value=create.  I'm not sure that's what's happening, and even if it is, I'm not sure if that would be correct behavior or not.  If someone could validate this and fix it (if it is a bug), it would be much appreciated.
> Thanks a lot.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira