Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

No tables created #23

Open
gentunian opened this issue Sep 1, 2014 · 4 comments
Open

No tables created #23

gentunian opened this issue Sep 1, 2014 · 4 comments

Comments

@gentunian
Copy link

I've cloned the repo and I get an error:

[host] ~ JAVA_HOME=/etc/alternatives/java_sdk ./grailsw run-app 
| Running Grails application
| Error 2014-09-01 17:26:46,182 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - HHH000389: Unsuccessful: alter table pet drop constraint FK_98le5nat0hd479mg10eua8xn0 if exists
| Error 2014-09-01 17:26:46,184 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - Table "PET" not found; SQL statement:
    alter table pet 
        drop constraint FK_98le5nat0hd479mg10eua8xn0 if exists [42102-176]
| Error 2014-09-01 17:26:46,185 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - HHH000389: Unsuccessful: alter table pet drop constraint FK_f265r1o5eddpmock5mflwfywl if exists
| Error 2014-09-01 17:26:46,185 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - Table "PET" not found; SQL statement:
    alter table pet 
        drop constraint FK_f265r1o5eddpmock5mflwfywl if exists [42102-176]
| Error 2014-09-01 17:26:46,185 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - HHH000389: Unsuccessful: alter table vet_speciality drop constraint FK_obpuagylkoe92jbh89228tfam if exists
| Error 2014-09-01 17:26:46,186 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - Table "VET_SPECIALITY" not found; SQL statement:
    alter table vet_speciality 
        drop constraint FK_obpuagylkoe92jbh89228tfam if exists [42102-176]
| Error 2014-09-01 17:26:46,186 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - HHH000389: Unsuccessful: alter table vet_speciality drop constraint FK_2y6r6dv8pf8b3fxvwek33exqy if exists
| Error 2014-09-01 17:26:46,186 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - Table "VET_SPECIALITY" not found; SQL statement:
    alter table vet_speciality 
        drop constraint FK_2y6r6dv8pf8b3fxvwek33exqy if exists [42102-176]
| Error 2014-09-01 17:26:46,187 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - HHH000389: Unsuccessful: alter table visit drop constraint FK_ifoofk96i1wm1ck2eu2518ehq if exists
| Error 2014-09-01 17:26:46,187 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - Table "VISIT" not found; SQL statement:
    alter table visit 
        drop constraint FK_ifoofk96i1wm1ck2eu2518ehq if exists [42102-176]
| Parent process shutdown. Exiting...
| Error Forked Grails VM exited with error
| Server running. Browse to http://localhost:8080/petclinic
[host] ~   netstat -lptun | grep 8080
[host] ~

No server running. Did I miss something from README.md? DB scripts or something?

@gentunian
Copy link
Author

Hey folks... I really wanted to try grails, but you seem not interested in that. From the grails site:

Simply unpack the zip file and run either ./grailsw run-app (Unix-like systems)

It isn't working at all. No configuration info was provided. Isn't it supposed to work out-of-the-box? Do I need to create the tables?

Hope to hear something from you,
regards

@caseyscarborough
Copy link
Contributor

Those error messages appear to be an issue with Hibernate 4 and the H2 in-memory database, but it doesn't stop the application from running.

Does the application start if you make the following change in the grails-app/conf/BuildConfig.groovy file?

// Change this line:
run: [maxMemory: 768, minMemory: 64, debug: false, maxPerm: 256, forkReserve:false],

// To this:
run: false,

Then run:

$ ./grailsw clean
$ ./grailsw run-app

@jeffscottbrown
Copy link

I don't know why your server is exiting right away but I am not sure that it is related to the error messages related to dropping constraints. When I run the app on OS X I do see the error messages about dropping constraints but the app works. I can verify that not only be interacting with the app but also by looking at the database and/or turning SQL logging on. Tables are in fact created and the app is functioning as designed. The errors about dropping constraints should be addressed, but they don't appear to be problematic in a way that prevents that app from functioning.

@gentunian
Copy link
Author

The errors are about inexistent tables. I've tried what @caseyscarborough said without luck. The only difference is that after executing the command is not returning to prompt and the server seems to be running:

| Running Grails application
| Error 2014-09-21 22:36:41,787 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - HHH000389: Unsuccessful: alter table pet drop constraint FK_98le5nat0hd479mg10eua8xn0 if exists
| Error 2014-09-21 22:36:41,789 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - Table "PET" not found; SQL statement:

    alter table pet 
        drop constraint FK_98le5nat0hd479mg10eua8xn0 if exists [42102-176]
| Error 2014-09-21 22:36:41,789 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - HHH000389: Unsuccessful: alter table pet drop constraint FK_f265r1o5eddpmock5mflwfywl if exists
| Error 2014-09-21 22:36:41,789 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - Table "PET" not found; SQL statement:

    alter table pet 
        drop constraint FK_f265r1o5eddpmock5mflwfywl if exists [42102-176]
| Error 2014-09-21 22:36:41,790 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - HHH000389: Unsuccessful: alter table vet_speciality drop constraint FK_obpuagylkoe92jbh89228tfam if exists
| Error 2014-09-21 22:36:41,790 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - Table "VET_SPECIALITY" not found; SQL statement:

    alter table vet_speciality 
        drop constraint FK_obpuagylkoe92jbh89228tfam if exists [42102-176]
| Error 2014-09-21 22:36:41,790 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - HHH000389: Unsuccessful: alter table vet_speciality drop constraint FK_2y6r6dv8pf8b3fxvwek33exqy if exists
| Error 2014-09-21 22:36:41,791 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - Table "VET_SPECIALITY" not found; SQL statement:

    alter table vet_speciality 
        drop constraint FK_2y6r6dv8pf8b3fxvwek33exqy if exists [42102-176]
| Error 2014-09-21 22:36:41,791 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - HHH000389: Unsuccessful: alter table visit drop constraint FK_ifoofk96i1wm1ck2eu2518ehq if exists
| Error 2014-09-21 22:36:41,791 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport  - Table "VISIT" not found; SQL statement:

    alter table visit 
        drop constraint FK_ifoofk96i1wm1ck2eu2518ehq if exists [42102-176]
| Server running. Browse to http://localhost:8080/petclinic

# netstat -lptun | grep 8080
tcp        0      0 0.0.0.0:8080            0.0.0.0:*               LISTEN      2830/java   

But:

Firefox can't establish a connection to the server at localhost:8080.

I'm puzzled with the sample...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants