用sqlserver修改表单问题

acb13202 · 发表于 2017-7-3 10:45:51

使用sqlserver数据库。online表单开发，第一次建表没有问题。但是表说明好像没有插入到数据库。然后第二次改表提示失败。找了一下，TableSQLServerHandleImpl的getCommentSql方法，不知道是不是这个方法有问题。

admin · 发表于 2017-7-5 14:19:42

具体错误和配置说明下

acb13202 · 发表于 2017-7-7 14:46:19

本帖最后由 acb13202 于 2017-7-7 17:03 编辑

admin 发表于 2017-7-5 14:19
具体错误和配置说明下

jeecg最新版本
配置信息
jeecg_database.properties

#SQLServer2005\u4ee5\u4e0a
diver_name=org.hibernate.dialect.SQLServerDialect
url=jdbc:sqlserver://localhost:1433;DatabaseName=jeecg
username=sa
password=123123
database_name=jeecg

dbconfig.properties
hibernate.dialect=org.jeecgframework.core.common.hibernate.dialect.MySQLServer2008Dialect
validationQuery.sqlserver=SELECT 1
jdbc.url.jeecg=jdbc:sqlserver://localhost:1433;DatabaseName=jeecg
jdbc.username.jeecg=sa
jdbc.password.jeecg=123123
jdbc.dbType=sqlserver

sysConfig.properties

#database type for spring jdbc
jdbc.url.jeecg=sqlserver

spring-minidao.xml
<property name="dbType" value="sqlserver"></property>

acb13202 · 发表于 2017-7-7 15:17:07

admin 发表于 2017-7-5 14:19
具体错误和配置说明下

新建表没加任何字段同步是这样的，
七月 07, 2017 2:19:59 下午 org.apache.tomcat.util.http.Parameters processParameters
警告: Parameters: Invalid chunk '' ignored.
[2017-07-07 14:20:30] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:52] <?xml version="1.0"

encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-

mapping-3.0.dtd">
<hibernate-mapping>
<class name="test2" table="test2" optimistic-lock="version">
<id name="id" type="java.lang.String" length="36" unsaved-value="null">
<generator class="uuid" />
</id>

<property name="bpm_status"
type="java.lang.String"
access="property">
<column name="bpm_status" length="32"
default="1"
not-null="false" unique="false">
<comment>流程状态</comment>
</column>
</property>
......字数太多
<column name="update_date" length="20"

not-null="false" unique="false">
<comment>更新日期</comment>
</column>
</property>
</class>
</hibernate-mapping>
[2017-07-07 14:20:30] [WARN] [org.hibernate.internal.util.xml.DTDEntityResolver:74] HHH000223: Recognized obsolete hibernate

namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6

Migration Guide!

create table test2 (
      id varchar(36) not null,
      bpm_status varchar(32) default 1,
      create_name varchar(50),
      create_by varchar(50),
      update_name varchar(50),
      update_by varchar(50),
      sys_org_code varchar(50),
      sys_company_code varchar(50),
      create_date datetime2,
      update_date datetime2,
      primary key (id)
)

acb13202 · 发表于 2017-7-7 15:51:57

admin 发表于 2017-7-5 14:19
具体错误和配置说明下

然后我加个字段，test

[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:220]

getColumnMetadataFormDataBase --->COLUMN_NAME:ID TYPE_NAME :varchar DECIMAL_DIGITS:0 COLUMN_SIZE:36
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:220]

getColumnMetadataFormDataBase --->COLUMN_NAME:BPM_STATUS TYPE_NAME :varchar DECIMAL_DIGITS:0 COLUMN_SIZE:32
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:220]

getColumnMetadataFormDataBase --->COLUMN_NAME:CREATE_NAME TYPE_NAME :varchar DECIMAL_DIGITS:0 COLUMN_SIZE:50
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:220]

getColumnMetadataFormDataBase --->COLUMN_NAME:CREATE_BY TYPE_NAME :varchar DECIMAL_DIGITS:0 COLUMN_SIZE:50
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:220]

getColumnMetadataFormDataBase --->COLUMN_NAME:UPDATE_NAME TYPE_NAME :varchar DECIMAL_DIGITS:0 COLUMN_SIZE:50
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:220]

getColumnMetadataFormDataBase --->COLUMN_NAME:UPDATE_BY TYPE_NAME :varchar DECIMAL_DIGITS:0 COLUMN_SIZE:50
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:220]

getColumnMetadataFormDataBase --->COLUMN_NAME:SYS_ORG_CODE TYPE_NAME :varchar DECIMAL_DIGITS:0 COLUMN_SIZE:50
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:220]

getColumnMetadataFormDataBase --->COLUMN_NAME:SYS_COMPANY_CODE TYPE_NAME :varchar DECIMAL_DIGITS:0 COLUMN_SIZE:50
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:220]

getColumnMetadataFormDataBase --->COLUMN_NAME:CREATE_DATE TYPE_NAME :datetime2 DECIMAL_DIGITS:0 COLUMN_SIZE:27
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:220]

getColumnMetadataFormDataBase --->COLUMN_NAME:UPDATE_DATE TYPE_NAME :datetime2 DECIMAL_DIGITS:0 COLUMN_SIZE:27
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:261]

getColumnMetadataFormCgForm ---->COLUMN_NAME:id TYPE_NAME:string DECIMAL_DIGITS:0 COLUMN_SIZE:36
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:261]

getColumnMetadataFormCgForm ---->COLUMN_NAME:bpm_status TYPE_NAME:string DECIMAL_DIGITS:0 COLUMN_SIZE:32
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:261]

getColumnMetadataFormCgForm ---->COLUMN_NAME:create_name TYPE_NAME:string DECIMAL_DIGITS:0 COLUMN_SIZE:50
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:261]

getColumnMetadataFormCgForm ---->COLUMN_NAME:create_by TYPE_NAME:string DECIMAL_DIGITS:0 COLUMN_SIZE:50
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:261]

getColumnMetadataFormCgForm ---->COLUMN_NAME:update_name TYPE_NAME:string DECIMAL_DIGITS:0 COLUMN_SIZE:50
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:261]

getColumnMetadataFormCgForm ---->COLUMN_NAME:update_by TYPE_NAME:string DECIMAL_DIGITS:0 COLUMN_SIZE:50
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:261]

getColumnMetadataFormCgForm ---->COLUMN_NAME:sys_org_code TYPE_NAME:string DECIMAL_DIGITS:0 COLUMN_SIZE:50
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:261]

getColumnMetadataFormCgForm ---->COLUMN_NAME:sys_company_code TYPE_NAME:string DECIMAL_DIGITS:0 COLUMN_SIZE:50
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:261]

getColumnMetadataFormCgForm ---->COLUMN_NAME:create_date TYPE_NAME:date DECIMAL_DIGITS:0 COLUMN_SIZE:20
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:261]

getColumnMetadataFormCgForm ---->COLUMN_NAME:update_date TYPE_NAME:date DECIMAL_DIGITS:0 COLUMN_SIZE:20
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:261]

getColumnMetadataFormCgForm ---->COLUMN_NAME:test TYPE_NAME:string DECIMAL_DIGITS:0 COLUMN_SIZE:32
[2017-07-07 14:22:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:141] [alter table  test2

ALTER COLUMN  id varchar(36) NOT NULL ;, EXECUTE sp_updateextendedproperty N'MS_Description', '主键', N'SCHEMA', N'dbo',

N'TABLE', N'test2', N'COLUMN', N'id', alter table  test2  ALTER COLUMN  sys_org_code varchar(50) NULL ;, EXECUTE

sp_updateextendedproperty N'MS_Description', '所属部门', N'SCHEMA', N'dbo', N'TABLE', N'test2', N'COLUMN', N'sys_org_code',

alter table  test2  ALTER COLUMN  bpm_status varchar(32) NULL DEFAULT 1;, EXECUTE sp_updateextendedproperty N'MS_Description',

'流程状态', N'SCHEMA', N'dbo', N'TABLE', N'test2', N'COLUMN', N'bpm_status', alter table  test2  ALTER COLUMN  create_date

datetime NULL ;, EXECUTE sp_updateextendedproperty N'MS_Description', '创建日期', N'SCHEMA', N'dbo', N'TABLE', N'test2',

N'COLUMN', N'create_date', alter table  test2  ADD  test varchar(32) NULL ;, EXECUTE sp_updateextendedproperty

N'MS_Description', 'test', N'SCHEMA', N'dbo', N'TABLE', N'test2', N'COLUMN', N'test', alter table  test2  ALTER COLUMN

create_by varchar(50) NULL ;, EXECUTE sp_updateextendedproperty N'MS_Description', '创建人登录名称', N'SCHEMA', N'dbo',

N'TABLE', N'test2', N'COLUMN', N'create_by', alter table  test2  ALTER COLUMN  create_name varchar(50) NULL ;, EXECUTE

sp_updateextendedproperty N'MS_Description', '创建人名称', N'SCHEMA', N'dbo', N'TABLE', N'test2', N'COLUMN', N'create_name',

alter table  test2  ALTER COLUMN  sys_company_code varchar(50) NULL ;, EXECUTE sp_updateextendedproperty N'MS_Description', '所

属公司', N'SCHEMA', N'dbo', N'TABLE', N'test2', N'COLUMN', N'sys_company_code', alter table  test2  ALTER COLUMN  update_name

varchar(50) NULL ;, EXECUTE sp_updateextendedproperty N'MS_Description', '更新人名称', N'SCHEMA', N'dbo', N'TABLE', N'test2',

N'COLUMN', N'update_name', alter table  test2  ALTER COLUMN  update_date datetime NULL ;, EXECUTE sp_updateextendedproperty

N'MS_Description', '更新日期', N'SCHEMA', N'dbo', N'TABLE', N'test2', N'COLUMN', N'update_date', alter table  test2  ALTER

COLUMN  update_by varchar(50) NULL ;, EXECUTE sp_updateextendedproperty N'MS_Description', '更新人登录名称', N'SCHEMA', N'dbo',

N'TABLE', N'test2', N'COLUMN', N'update_by']
[2017-07-07 14:22:31] [WARN] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper:143] SQL Error: 15217, SQLState: S0002
[2017-07-07 14:22:31] [ERROR] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper:144] 无法更新或删除属性。'dbo.test2.id' 不存在

属性 'MS_Description'。
[2017-07-07 14:22:31] [ERROR] [org.jeecgframework.web.cgform.service.impl.config.CgFormFieldServiceImpl:277] 无法更新或删除属性

。'dbo.test2.id' 不存在属性 'MS_Description'。
org.hibernate.exception.SQLGrammarException: 无法更新或删除属性。'dbo.test2.id' 不存在属性 'MS_Description'。

acb13202 · 发表于 2017-7-7 16:47:19

admin 发表于 2017-7-5 14:19
具体错误和配置说明下

at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation

(AbstractStatementProxyHandler.java:129)
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at com.sun.proxy.$Proxy125.executeUpdate(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:916)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:909)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:909)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:970)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:980)
at org.jeecgframework.core.common.dao.impl.GenericBaseCommonDao.executeSql(GenericBaseCommonDao.java:918)
at org.jeecgframework.core.common.service.impl.CommonServiceImpl.executeSql(CommonServiceImpl.java:370)
at org.jeecgframework.web.cgform.service.impl.config.CgFormFieldServiceImpl.dbSynch(CgFormFieldServiceImpl.java:239)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation

(TransactionInterceptor.java:98)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction

(TransactionAspectSupport.java:262)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy92.dbSynch(Unknown Source)
at org.jeecgframework.web.cgform.controller.config.CgFormHeadController.doDbSynch(CgFormHeadController.java:232)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod

(HandlerMethodInvoker.java:175)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod

(AnnotationMethodHandlerAdapter.java:446)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle

(AnnotationMethodHandlerAdapter.java:434)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jeecgframework.core.aop.GZipFilter.doFilter(GZipFilter.java:93)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:140)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal

(OpenSessionInViewFilter.java:150)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 无法更新或删除属性。'dbo.test2.id' 不存在属性 'MS_Description'。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement

(SQLServerPreparedStatement.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute

(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2717)
at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1052)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2715)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeUpdate(PreparedStatementProxyImpl.java:106)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:237)
at sun.reflect.GeneratedMethodAccessor394.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation

(AbstractStatementProxyHandler.java:122)
... 67 more

acb13202 · 发表于 2017-7-7 17:01:44

admin 发表于 2017-7-5 14:19
具体错误和配置说明下

强制同步提示这些信息,但是强制同步会崩溃浏览器。也没有效果
[2017-07-07 14:23:31] [INFO] [org.jeecgframework.web.cgform.service.impl.config.util.DbTableProcess:52] <?xml version="1.0"

encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-

mapping-3.0.dtd">
<hibernate-mapping>
      <class name="test2" table="test2" optimistic-lock="version">
                                             <id name="id" type="java.lang.String" length="36" unsaved-value="null">
                                                      <generator class="uuid" />
                                             </id>

                                    <property name="bpm_status"
                                                            type="java.lang.String"
access="property">
                                             <column name="bpm_status" length="32"
                                                      default="1"
                                                      not-null="false" unique="false">
                                                      <comment>流程状态</comment>
                                             </column>
                                    </property>

.....字数太多不让发
                                    <property name="test"
                                                            type="java.lang.String"
access="property">
                                             <column name="test" length="32"

                                                      not-null="false" unique="false">
                                                      <comment>test</comment>
                                             </column>
                                    </property>
      </class>
</hibernate-mapping>
[2017-07-07 14:23:31] [WARN] [org.hibernate.internal.util.xml.DTDEntityResolver:74] HHH000223: Recognized obsolete hibernate

namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6

Migration Guide!

create table test2 (
      id varchar(36) not null,
      bpm_status varchar(32) default 1,
      create_name varchar(50),
      create_by varchar(50),
      update_name varchar(50),
      update_by varchar(50),
      sys_org_code varchar(50),
      sys_company_code varchar(50),
      create_date datetime2,
      update_date datetime2,
      test varchar(32),
      primary key (id)
)

wgx · 发表于 2017-7-28 16:33:40

请问你解决这个问题了么

,可以把解决方法告诉我么

[Online开发] 用sqlserver修改表单问题