发帖    主题    评论    推荐    标签    作者    订阅    查搜    注册   登陆   关注
 
面向对象 设计模式 领域驱动设计 企业架构 框架 开发教程 微服务 大数据 扩展性 并发编程 事件驱动 分布式 SOA

Compiere下自建表的错误:ORA-01733: virtual column not allowed here

2004-12-01 09:57
赞助商链接

大家好,

我在Oracle中新建了一个表(很简单,仅供实验用),并在Compiere中建立了对应的窗口,但是在插入数据的时候,会发生错误ORA-01733: virtual column not allowed here.

我察看了sourceforge.net论坛上所有的相关帖子,在那里也遇到了有相同问题的朋友,但是尝试了各种能找到的建议之后,问题还是没有解决。

我的服务器配置:
Compiere 2.5.1g
Oracle 10g
Windows 2003 Server Standard Edition English
JDK 1.4.2_06

我的客户端配置:
Compiere 2.5.1g Client
Oracle 10g Client
Windows XP Professional, SP2 English
JDK 1.4.2_05


这是我用来建表的SQL脚本,很简单:
CREATE TABLE X_YanTest01 (
X_YanTest01_ID NUMBER(10),
AD_Client_ID NUMBER(10),
AD_Org_ID NUMBER(10),
Created DATE,
CreatedBy NUMBER(10),
Updated DATE,
UpdatedBy NUMBER(10),
IsActive CHAR(1),
X_TestField1 CHAR(1)
)
TABLESPACE USERS


这个是错误发生时在Console上显示的信息:
16:29:50.125 MTab: dataSave #0 - row=0
16:29:50.125 MTable: dataSave - NoNeed - Changed=false, Row=-1
16:29:50.125 MTab: dataNew #0
16:29:50.125 MTable: dataNew - Current=0, Copy=false
16:29:50.125 MTable: dataSave - Row=-2, Changed=-1/false
16:29:50.140 MTable: dataNew - Current=0, New=1
16:29:50.140 MTab: dataStatusChanged #0 - DataStatusEvent - Inserted : +*0/2

16:29:50.140 MTab: fireDataStatusChanged - DataStatusEvent - Inserted : +*1/
2
16:29:50.156 MTable: dataNew - Current=0, New=1 - complete
16:29:50.156 MTab: setCurrentRow = 1 - fire=true
16:29:50.156 MTab: fireDataStatusChanged - DataStatusEvent - Inserted : +*2/
2
16:29:50.171 MTab: dataStatusChanged #0 - DataStatusEvent - : + 0/2
16:29:50.171 MTab: fireDataStatusChanged - DataStatusEvent - : + 2/2
16:29:53.500 MTab: dataSave #0 - row=1
16:29:53.500 MTable: dataSave - NoNeed - Changed=false, Row=-1
16:29:53.500 MTable: dataSave - Saving row 1
16:29:53.500 MTable: dataSavePO - 0
===========> M_Table: getPO(id) - Class not found for X_YanTest01
16:29:53.625 MTable: MTable.dataSave - X_YanTest01 - No Persistent Object
16:29:53.656 MTable: dataSave - prepare inserting ... RowSet
16:29:53.687 MTable: dataSave - Info: X_YanTest01_ID -> 1000004 (Key)
16:29:53.687 MTable: dataSave - Info: AD_Org_ID= null -> 0 (Int)
16:29:53.703 MTable: dataSave - Info: AD_Client_ID= null -> 0 (Int)
16:29:53.703 MTable: dataSave - Info: IsActive= null -> Y (String)
16:29:53.703 MTable: dataSave - Info: X_TestField1= null -> N (String)
16:29:53.718 MTable: dataSave - Info: Updated/By -> 2004-11-29 16:29:53.656 -
100
16:29:53.718 MTable: dataSave - inserting ...
===========> MTable: dataSave
SQL= SELECT ROWID,X_YanTest01_ID,AD_Org_ID,AD_Client_ID,IsActive,X_TestField1,Cr
eated,CreatedBy,Updated,UpdatedBy FROM X_YanTest01 WHERE 1=2
java.sql.SQLException: ORA-01733: virtual column not allowed here

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedS
tatement.java:543)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1028)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:2888)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:2960)
at oracle.jdbc.driver.UpdatableResultSet.execute_insertRow(UpdatableResu
ltSet.java:2217)
at oracle.jdbc.driver.UpdatableResultSet.insertRow(UpdatableResultSet.ja
va:1499)
at org.compiere.model.MTable.dataSave(MTable.java:1651)
at org.compiere.model.MTab.dataSave(MTab.java:686)
at org.compiere.apps.APanel.cmd_save(APanel.java:1178)
at org.compiere.apps.APanel.actionPerformed(APanel.java:1048)
at org.compiere.apps.AppsAction.actionPerformed(AppsAction.java:213)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:17
86)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Abstra
ctButton.java:1839)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258
)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:245)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:2
31)
at java.awt.Component.processMouseEvent(Component.java:5100)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483
)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:201)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
===========> SaveError - ORA-01733: virtual column not allowed here

16:29:53.937 MTab: dataStatusChanged #0 - DataStatusEvent - SaveError ORA-017
33: virtual column not allowed here
: +*0/2
16:29:53.953 MTab: fireDataStatusChanged - DataStatusEvent - SaveError ORA-01
733: virtual column not allowed here
: +*2/2


多谢帮助,欢迎任何建议。

Elliot

2004-12-28 12:02

compiere对10g的支持还是有问题

赞助商链接

赞助商链接

返回顶部

移动版 关于本站 使用帮助 联系管理员 最佳分辨率1366x768
OpenSource JIVEJDON Powered by JdonFramework Code © 2002-20 jdon.com