-
-
Carson 小试身手Lv3
发表于2019-1-29 10:21
悬赏100
已解决
楼主
安装报错Error creating bean with name 'platform_bulletgroupmgr_factory' defined in file [/home/dt/apache-tomcat-6.0.20/webapps/BI/WEB-INF/classes/com/esen/platform/notice/BulletinGroupManagerFactory.class]: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platform_bulletmgr_factory' defined in file [/home/dt/apache-tomcat-6.0.20/webapps/BI/WEB-INF/classes/com/esen/platform/notice/BulletinManagerFactory.class]: Invocation of init method failed; nested exception is com.esen.jdbc.orm.ORMSQLException:
创建表:ES10_BULLETIN
CREATE TABLE ES10_BULLETIN(ID_ VARCHAR(50) BINARY NOT NULL ,TITLE_ VARCHAR(100) BINARY NOT NULL ,CONTENT_ MEDIUMTEXT NOT NULL ,CONTENTNOSTYLE_ MEDIUMTEXT NOT NULL ,ONTOP_ VARCHAR(1) NOT NULL ,ONTOPTIME_ DATETIME NULL ,ONTOPCHANGETIME_ DATETIME NULL ,PUBTIME_ DATETIME DEFAULT 0 NOT NULL ,PUBLISHER_ VARCHAR(50) BINARY NOT NULL ,GID_ VARCHAR(50) BINARY NULL ,PRIMARY KEY (ID_)) row_format = compressed
出现异常:Invalid default value for 'PUBTIME_'
PUBTIME_ DATETIME DEFAULT 0 NOT NULL ,
这个建表语句是datetime类型，默认值给的是0
如何解决！
创建表:ES10_BULLETIN
CREATE TABLE ES10_BULLETIN(ID_ VARCHAR(50) BINARY NOT NULL ,TITLE_ VARCHAR(100) BINARY NOT NULL ,CONTENT_ MEDIUMTEXT NOT NULL ,CONTENTNOSTYLE_ MEDIUMTEXT NOT NULL ,ONTOP_ VARCHAR(1) NOT NULL ,ONTOPTIME_ DATETIME NULL ,ONTOPCHANGETIME_ DATETIME NULL ,PUBTIME_ DATETIME DEFAULT 0 NOT NULL ,PUBLISHER_ VARCHAR(50) BINARY NOT NULL ,GID_ VARCHAR(50) BINARY NULL ,PRIMARY KEY (ID_)) row_format = compressed
出现异常:Invalid default value for 'PUBTIME_'
PUBTIME_ DATETIME DEFAULT 0 NOT NULL ,
这个建表语句是datetime类型，默认值给的是0
如何解决！
