Table generation issue, missing column

49 views
Skip to first unread message

Mr. K

unread,
Jun 1, 2017, 7:08:07 AM6/1/17
to CAS Community
Hello,

When I attempt to run the cas management web app I get the following exception.

Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'abstractre0_.bypassApprovalPrompt' in 'field list'


I have the cas running and attempting to run cas management web app on:

localhost:8080/cas
localhost:8080/cas-management

I ran cas with the following property once to generate the tables and then changed it to none.

#cas.serviceRegistry.jpa.ddlAuto=create
cas.serviceRegistry.jpa.ddlAuto=none

This property is also set in the management web app to none.

CAS proeprties

 cas.serviceRegistry.initFromJson=false
cas.serviceRegistry.jpa.healthQuery=SELECT 1
cas.serviceRegistry.jpa.url=jdbc:mysql://localhost:3306/cas?useSSL=false
cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
cas.serviceRegistry.jpa.user=root
cas.serviceRegistry.jpa.ddlAuto=none
cas.serviceRegistry.jpa.password=root
cas.serviceRegistry.jpa.driverClass=com.mysql.cj.jdbc.Driver

CAS Management web app properties.

cas.serviceRegistry.initFromJson=false
cas.serviceRegistry.jpa.healthQuery=SELECT 1
cas.serviceRegistry.jpa.url=jdbc:mysql://localhost:3306/cas?useSSL=false
cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
cas.serviceRegistry.jpa.user=root
cas.serviceRegistry.jpa.ddlAuto=none
cas.serviceRegistry.jpa.password=root
cas.serviceRegistry.jpa.driverClass=com.mysql.cj.jdbc.Driver

Thanks

Mr. K

unread,
Jun 1, 2017, 7:13:12 AM6/1/17
to CAS Community
Also during table generation i get the following exception

2017-06-01 12:11:38,824 WARN [org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl] - <GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement>
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement


Reply all
Reply to author
Forward
0 new messages