导入元数据,删除元数据报错
ddwinter 发布于1月前 1答/34阅

我的原始需求是:
eova连接oracle数据库实现数据的增删改查

实现过程中遇到的问题:

导入元数据,删除元数据报错
我觉得这个问题的原因是:

导入元数据报错:

Sql: select * from eova_object where code = ?

Sql: select column_name,comments from all_col_comments where owner = ? and table_name = ?

Sql: insert into eova_field(cn, data_decimal, data_size, data_type, data_type_name, defaulter, en, id, is_auto, is_required, object_code, order_num, type) values(?, ?, ?, ?, ?, ?, ?, seq_eova_field.nextval, ?, ?, ?, ?, ?)

11-10 20:45:41[ERROR]/meta/doImports

com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: Error

at com.jfinal.plugin.activerecord.Model.save(Model.java:533)

at com.eova.common.base.BaseModel.save(BaseModel.java:173)

at com.eova.core.meta.MetaController.importMetaField(MetaController.java:400)

at com.eova.core.meta.MetaController.importMeta(MetaController.java:374)

at com.eova.core.meta.MetaController.doImports(MetaController.java:226)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.jfinal.aop.Invocation.invoke(Invocation.java:73)

at com.jfinal.plugin.activerecord.tx.Tx.intercept(Tx.java:77)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at com.eova.interceptor.AuthInterceptor.intercept(AuthInterceptor.java:49)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at com.eova.interceptor.LoginInterceptor.intercept(LoginInterceptor.java:69)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at com.jfinal.core.ActionHandler.handle(ActionHandler.java:78)

at com.eova.handler.UrlBanHandler.handle(UrlBanHandler.java:38)

at com.jfinal.plugin.druid.DruidStatViewHandler.handle(DruidStatViewHandler.java:81)

at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:73)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)

at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)

at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:560)

at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)

at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1072)

at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)

at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)

at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)

at org.eclipse.jetty.server.Server.handle(Server.java:365)

at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)

at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:937)

at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:998)

at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)

at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)

at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)

at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)

at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)

at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)

at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)

at java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLException: Error

at com.alibaba.druid.pool.DruidDataSource.handleConnectionException(DruidDataSource.java:1246)

at com.alibaba.druid.pool.DruidPooledConnection.handleException(DruidPooledConnection.java:132)

at com.alibaba.druid.pool.DruidPooledStatement.checkException(DruidPooledStatement.java:68)

at com.alibaba.druid.pool.DruidPooledStatement.getGeneratedKeys(DruidPooledStatement.java:607)

at com.jfinal.plugin.activerecord.dialect.Dialect.getModelGeneratedKey(Dialect.java:143)

at com.jfinal.plugin.activerecord.Model.save(Model.java:529)

... 42 more

Caused by: java.lang.NullPointerException

at oracle.jdbc.driver.AutoKeyInfo.initMetaDataColumnIndexes(AutoKeyInfo.java:423)

at oracle.jdbc.driver.AutoKeyInfo.initMetaData(AutoKeyInfo.java:396)

at oracle.jdbc.driver.OracleReturnResultSet.getMetaData(OracleReturnResultSet.java:77)

at com.alibaba.druid.wall.WallFilter.preprocessResultSet(WallFilter.java:1395)

at com.alibaba.druid.wall.WallFilter.statement_getGeneratedKeys(WallFilter.java:657)

at com.alibaba.druid.filter.FilterChainImpl.statement_getGeneratedKeys(FilterChainImpl.java:2618)

at com.alibaba.druid.filter.FilterAdapter.statement_getGeneratedKeys(FilterAdapter.java:2524)

at com.alibaba.druid.filter.FilterEventAdapter.statement_getGeneratedKeys(FilterEventAdapter.java:415)

at com.alibaba.druid.filter.FilterChainImpl.statement_getGeneratedKeys(FilterChainImpl.java:2618)

at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.getGeneratedKeys(StatementProxyImpl.java:299)

at com.alibaba.druid.pool.DruidPooledStatement.getGeneratedKeys(DruidPooledStatement.java:599)

... 44 more

删除元数据报错

Sql: select * from eova_object where code = ?

Sql: select * from eova_field where object_code = ? order by fieldnum,order_num

11-10 20:40:19[ERROR]/grid/delete/eova_object_code

java.lang.RuntimeException: 当前数据类型转换器无法匹配数据库字段类型:INT,请更换其它常用类型或自定义类型转换器

at com.eova.core.type.Convertor.getJavaType(Convertor.java:63)





[沙发] Jieven
@ddwinter 只有专业版支持完美支持Oracle, 并且提供1V1的技术支持, 解决所有遇到的问题.
提交评论