I have a Hibernate-MySQL problem....It goes like this...
Can hibernate create a view when I run the schema update as configured as
"<property name="hbm2ddl.auto">update</property> " in the Hibernate config file. I have a POJO mapped the same way as we do it for tables for the view I want to create with the columns that would be displayed in the view,
I got the following log output when i already created the view in MySQL:-
22:16:17,073 [INFO ] [hbm2ddl.DatabaseMetadata][getTableMetadata] [table not found: EPW3_USER_ACCTS]
22:16:17,073 [DEBUG] [hbm2ddl.SchemaUpdate][execute] [create table EPW3_USER_ACCTS (
USER_ID varchar(255) not null, NAME varchar(255), USER_NM varchar(255), MAIL_PASS tinyblob, MAIL_SRVR varchar(255), MAIL_ADDR varchar(255), MAIL_TOKEN varchar(255), ACCT_TYPE varchar(255), primary key (USER_ID))]
22:16:17,089 [ERROR] [hbm2ddl.SchemaUpdate][execute] [Unsuccessful: create table EPW3_USER_ACCTS (USER_ID varchar(255) not null, NAME varchar(255), USER_NM varchar(255), MAIL_PASS tinyblob, MAIL_SRVR varchar(255), MAIL_ADDR varchar(255), MAIL_TOKEN varchar(255), ACCT_TYPE varchar(255), primary key (USER_ID))]
22:16:17,105 [ERROR] [hbm2ddl.SchemaUpdate][execute] [Table 'epw3_user_accts' already exists]
22:16:17,105 [INFO ] [hbm2ddl.SchemaUpdate][execute] [schema update complete]
Now it first prints "table not found: EPW3_USER_ACCTS" then later prints "Table 'epw3_user_accts' already exists" when this is not a table but a view
|