Generator-jhipster: Jhipster Error on Connecting H2 Database

Created on 29 Aug 2018  路  2Comments  路  Source: jhipster/generator-jhipster

I'm a newbie on JHipster!
When i tried to generate an spring + angular project i got this error.
please help.
thanks!

2018-08-29 11:21:24.740  WARN 5704 --- [hips-Executor-1] i.g.j.c.liquibase.AsyncSpringLiquibase   : Starting Liquibase asynchronously, your database might not be ready at startup!
2018-08-29 11:21:25.043 ERROR 5704 --- [hips-Executor-1] i.g.j.c.liquibase.AsyncSpringLiquibase   : Liquibase could not start correctly, your database is NOT ready: liquibase.exception.DatabaseException: Unknown data type: "娄NT"; SQL statement:
CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID 娄NT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)) [50004-197] [Failed SQL: CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID 娄NT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]

liquibase.exception.LockException: liquibase.exception.DatabaseException: Unknown data type: "娄NT"; SQL statement:
CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID 娄NT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)) [50004-197] [Failed SQL: CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID 娄NT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]
        at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:242)
        at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:170)
        at liquibase.Liquibase.update(Liquibase.java:196)
        at liquibase.Liquibase.update(Liquibase.java:192)
        at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:431)
        at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:388)
        at io.github.jhipster.config.liquibase.AsyncSpringLiquibase.initDb(AsyncSpringLiquibase.java:103)
        at io.github.jhipster.config.liquibase.AsyncSpringLiquibase.lambda$afterPropertiesSet$0(AsyncSpringLiquibase.java:83)
        at io.github.jhipster.async.ExceptionHandlingAsyncTaskExecutor.lambda$createWrappedRunnable$1(ExceptionHandlingAsyncTaskExecutor.java:68)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: liquibase.exception.DatabaseException: Unknown data type: "娄NT"; SQL statement:
CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID 娄NT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)) [50004-197] [Failed SQL: CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID 娄NT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]
        at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:103)
        at liquibase.lockservice.StandardLockService.init(StandardLockService.java:94)
        at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:206)
        ... 11 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLException: Unknown data type: "娄NT"; SQL statement:
CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID 娄NT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)) [50004-197]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
        at org.h2.message.DbException.get(DbException.java:179)
        at org.h2.message.DbException.get(DbException.java:155)
        at org.h2.command.Parser.parseColumnWithType(Parser.java:4400)
        at org.h2.command.Parser.parseColumnForTable(Parser.java:4215)
        at org.h2.command.Parser.parseTableColumnDefinition(Parser.java:6662)
        at org.h2.command.Parser.parseCreateTable(Parser.java:6570)
        at org.h2.command.Parser.parseCreate(Parser.java:4615)
        at org.h2.command.Parser.parsePrepared(Parser.java:380)
        at org.h2.command.Parser.parse(Parser.java:335)
        at org.h2.command.Parser.parse(Parser.java:307)
        at org.h2.command.Parser.prepareCommand(Parser.java:278)
        at org.h2.engine.Session.prepareLocal(Session.java:611)
        at org.h2.engine.Session.prepareCommand(Session.java:549)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)
        at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:217)
        at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:205)
        at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
        at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
        at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307)
        ... 16 common frames omitted

2018-08-29 11:21:33.219 DEBUG 5704 --- [  restartedMain] com.mevsun.mevhips.config.WebConfigurer  : Registering CORS filter
2018-08-29 11:21:33.379  INFO 5704 --- [  restartedMain] com.mevsun.mevhips.config.WebConfigurer  : Web application configuration, using profiles: dev
2018-08-29 11:21:33.380 DEBUG 5704 --- [  restartedMain] com.mevsun.mevhips.config.WebConfigurer  : Initializing Metrics registries
2018-08-29 11:21:33.388 DEBUG 5704 --- [  restartedMain] com.mevsun.mevhips.config.WebConfigurer  : Registering Metrics Filter
2018-08-29 11:21:33.389 DEBUG 5704 --- [  restartedMain] com.mevsun.mevhips.config.WebConfigurer  : Registering Metrics Servlet
2018-08-29 11:21:33.405 DEBUG 5704 --- [  restartedMain] com.mevsun.mevhips.config.WebConfigurer  : Initialize H2 console
2018-08-29 11:21:33.405  INFO 5704 --- [  restartedMain] com.mevsun.mevhips.config.WebConfigurer  : Web application fully configured
2018-08-29 11:21:38.719 DEBUG 5704 --- [  restartedMain] c.m.m.config.DatabaseConfiguration       : Starting H2 database
2018-08-29 11:21:39.973  WARN 5704 --- [  restartedMain] c.n.c.sources.URLConfigurationSource     : No URLs will be polled as dynamic configuration sources.
2018-08-29 11:21:40.004  WARN 5704 --- [  restartedMain] c.n.c.sources.URLConfigurationSource     : No URLs will be polled as dynamic configuration sources.
2018-08-29 11:21:40.726 DEBUG 5704 --- [  restartedMain] i.g.j.c.apidoc.SwaggerAutoConfiguration  : Starting Swagger
2018-08-29 11:21:40.834 DEBUG 5704 --- [  restartedMain] i.g.j.c.apidoc.SwaggerAutoConfiguration  : Started Swagger in 108 ms
2018-08-29 11:21:45.498  INFO 5704 --- [  restartedMain] com.mevsun.mevhips.MevhipsApp            : Started MevhipsApp in 43.816 seconds (JVM running for 44.927)
2018-08-29 11:21:45.507  INFO 5704 --- [  restartedMain] com.mevsun.mevhips.MevhipsApp            :
----------------------------------------------------------
        Application 'mevhips' is running! Access URLs:
        Local:          http://localhost:8080
        External:       http://192.168.56.1:8080
        Profile(s):     [dev, swagger]
----------------------------------------------------------
2018-08-29 11:27:08.385 DEBUG 5704 --- [  XNIO-2 task-9] c.m.mevhips.aop.logging.LoggingAspect    : Enter: com.mevsun.mevhips.repository.CustomAuditEventRepository.add() with argument[s] = [AuditEvent [timestamp=2018-08-29T08:27:08.325Z, principal=anonymousUser, type=AUTHORIZATION_FAILURE, data={details=org.springframework.security.web.authentication.WebAuthenticationDetails@b364: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: null, type=org.springframework.security.access.AccessDeniedException, message=Access is denied}]]
2018-08-29 11:27:08.390 DEBUG 5704 --- [  XNIO-2 task-9] c.m.mevhips.aop.logging.LoggingAspect    : Exit: com.mevsun.mevhips.repository.CustomAuditEventRepository.add() with result = null
2018-08-29 11:27:08.429  WARN 5704 --- [  XNIO-2 task-9] o.z.p.spring.web.advice.AdviceTrait      : Unauthorized: Full authentication is required to access this resource
2018-08-29 11:27:08.665  WARN 5704 --- [  XNIO-2 task-9] .m.m.a.ExceptionHandlerExceptionResolver : Resolved exception caused by Handler execution: org.springframework.security.authentication.InsufficientAuthenticationException: Full authentication is required to access this resource
2018-08-29 11:27:13.813 DEBUG 5704 --- [ XNIO-2 task-12] c.m.mevhips.aop.logging.LoggingAspect    : Enter: com.mevsun.mevhips.web.rest.UserJWTController.authorize() with argument[s] = [LoginVM{username='admin', rememberMe=null}]
2018-08-29 11:27:13.953 DEBUG 5704 --- [ XNIO-2 task-12] c.m.m.security.DomainUserDetailsService  : Authenticating admin
Hibernate: select user0_.id as id1_3_0_, authority2_.name as name1_0_1_, user0_.created_by as created_2_3_0_, user0_.created_date as created_3_3_0_, user0_.last_modified_by as last_mod4_3_0_, user0_.last_modified_date as last_mod5_3_0_, user0_.activated as activate6_3_0_, user0_.activation_key as activati7_3_0_, user0_.email as email8_3_0_, user0_.first_name as first_na9_3_0_, user0_.image_url as image_u10_3_0_, user0_.lang_key as lang_ke11_3_0_, user0_.last_name as last_na12_3_0_, user0_.login as login13_3_0_, user0_.password_hash as passwor14_3_0_, user0_.reset_date as reset_d15_3_0_, user0_.reset_key as reset_k16_3_0_, authoritie1_.user_id as user_id1_4_0__, authoritie1_.authority_name as authorit2_4_0__ from jhi_user user0_ left outer join jhi_user_authority authoritie1_ on user0_.id=authoritie1_.user_id left outer join jhi_authority authority2_ on authoritie1_.authority_name=authority2_.name where user0_.login=?
2018-08-29 11:27:14.289  WARN 5704 --- [ XNIO-2 task-12] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 42102, SQLState: 42S02
2018-08-29 11:27:14.289 ERROR 5704 --- [ XNIO-2 task-12] o.h.engine.jdbc.spi.SqlExceptionHelper   : Table "JHI_USER" not found; SQL statement:
select user0_.id as id1_3_0_, authority2_.name as name1_0_1_, user0_.created_by as created_2_3_0_, user0_.created_date as created_3_3_0_, user0_.last_modified_by as last_mod4_3_0_, user0_.last_modified_date as last_mod5_3_0_, user0_.activated as activate6_3_0_, user0_.activation_key as activati7_3_0_, user0_.email as email8_3_0_, user0_.first_name as first_na9_3_0_, user0_.image_url as image_u10_3_0_, user0_.lang_key as lang_ke11_3_0_, user0_.last_name as last_na12_3_0_, user0_.login as login13_3_0_, user0_.password_hash as passwor14_3_0_, user0_.reset_date as reset_d15_3_0_, user0_.reset_key as reset_k16_3_0_, authoritie1_.user_id as user_id1_4_0__, authoritie1_.authority_name as authorit2_4_0__ from jhi_user user0_ left outer join jhi_user_authority authoritie1_ on user0_.id=authoritie1_.user_id left outer join jhi_authority authority2_ on authoritie1_.authority_name=authority2_.name where user0_.login=? [42102-197]
2018-08-29 11:27:14.343 ERROR 5704 --- [ XNIO-2 task-12] c.m.mevhips.aop.logging.LoggingAspect    : Exception in com.mevsun.mevhips.web.rest.UserJWTController.authorize() with cause = 'org.springframework.dao.InvalidDataAccessResourceUsageException: could not prepare statement; SQL [select user0_.id as id1_3_0_, authority2_.name as name1_0_1_, user0_.created_by as created_2_3_0_, user0_.created_date as created_3_3_0_, user0_.last_modified_by as last_mod4_3_0_, user0_.last_modified_date as last_mod5_3_0_, user0_.activated as activate6_3_0_, user0_.activation_key as activati7_3_0_, user0_.email as email8_3_0_, user0_.first_name as first_na9_3_0_, user0_.image_url as image_u10_3_0_, user0_.lang_key as lang_ke11_3_0_, user0_.last_name as last_na12_3_0_, user0_.login as login13_3_0_, user0_.password_hash as passwor14_3_0_, user0_.reset_date as reset_d15_3_0_, user0_.reset_key as reset_k16_3_0_, authoritie1_.user_id as user_id1_4_0__, authoritie1_.authority_name as authorit2_4_0__ from jhi_user user0_ left outer join jhi_user_authority authoritie1_ on user0_.id=authoritie1_.user_id left outer join jhi_authority authority2_ on authoritie1_.authority_name=authority2_.name where user0_.login=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not prepare statement' and exception = 'could not prepare statement; SQL [select user0_.id as id1_3_0_, authority2_.name as name1_0_1_, user0_.created_by as created_2_3_0_, user0_.created_date as created_3_3_0_, user0_.last_modified_by as last_mod4_3_0_, user0_.last_modified_date as last_mod5_3_0_, user0_.activated as activate6_3_0_, user0_.activation_key as activati7_3_0_, user0_.email as email8_3_0_, user0_.first_name as first_na9_3_0_, user0_.image_url as image_u10_3_0_, user0_.lang_key as lang_ke11_3_0_, user0_.last_name as last_na12_3_0_, user0_.login as login13_3_0_, user0_.password_hash as passwor14_3_0_, user0_.reset_date as reset_d15_3_0_, user0_.reset_key as reset_k16_3_0_, authoritie1_.user_id as user_id1_4_0__, authoritie1_.authority_name as authorit2_4_0__ from jhi_user user0_ left outer join jhi_user_authority authoritie1_ on user0_.id=authoritie1_.user_id left outer join jhi_authority authority2_ on authoritie1_.authority_name=authority2_.name where user0_.login=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not prepare statement'
picture mevsungur

Most helpful comment

@mevlts you messed up your database, just do ./mvnw clean. Next time please follow the issue template!

picture jdubois on 29 Aug 2018
👎3 👍2 ❤1

All 2 comments

This ticket has been closed as the guidelines are not followed.

Tickets must follow our Guidelines, as mentioned in:

  1. our Readme file on the front page of the project,
  2. the "create a new ticket" page and
  3. our Help page

We have also created a template on the "create a new ticket" page to help you follow those guidelines.

If this is indeed a JHipster bug, please open a new issue with proper details or update this issue with all details and request to reopen.
Issues opened without proper details will be closed without explanation.

If you have a question please use Stack Overflow, and tag the question with jhipster. This helps the project to keep the issue tracker clean. Also, Stack Overflow will give your question a larger audience:

  • This will increase your chances to get an answer
  • Answers will be of higher quality, as there is a voting system
  • This will also help other users who might have the same issue, as questions are tagged and easily searchable
pascalgrimaud picture pascalgrimaud on 29 Aug 2018

@mevlts you messed up your database, just do ./mvnw clean. Next time please follow the issue template!

jdubois picture jdubois on 29 Aug 2018
👎3 👍2 ❤1
Was this page helpful?
0 / 5 - 0 ratings

Related issues

Steven-Garcia picture Steven-Garcia  路  3Comments
sdoxsee picture sdoxsee  路  4Comments
SudharakaP picture SudharakaP  路  3Comments
pascalgrimaud picture pascalgrimaud  路  4Comments
pascalgrimaud picture pascalgrimaud  路  3Comments