Problems about Table Schema Options

[Anonymous]

Hello,

I found a problem in Cloverleaf 6.0.2.0P installed on Windows 7 professional that is, when I apply Table Schema Options, then reopen database schemas it will throw exception:

Error occurred while attempting to read the database schema configuration file:

d:cloverleafcis6.0integratoretlsampleformatsdbschemaeasDEPARTMENT.xml

Error:

cvc-complex-type.3.2.2: Attribute ‘FIELD_SEP’ is not allowed to appear in element ‘TABLE’.

java.io.IOException: Error occurred while attempting to read the database schema configuration file:

d:cloverleafcis6.0integratoretlsampleformatsdbschemaeasDEPARTMENT.xml

Error:

cvc-complex-type.3.2.2: Attribute ‘FIELD_SEP’ is not allowed to appear in element ‘TABLE’.

   at com.hie.cloverleaf.configserver.LocalConfigServerSupport.lockAndGetConfig(Unknown Source)

   at com.hie.cloverleaf.configserver.LocalDBConfigServer.get(Unknown Source)

   at com.hie.cloverleaf.remoteserver.RemoteDBConfigServer.get(Unknown Source)

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

   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

   at java.lang.reflect.Method.invoke(Method.java:597)

   at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:303)

   at sun.rmi.transport.Transport$1.run(Transport.java:159)

   at java.security.AccessController.doPrivileged(Native Method)

   at sun.rmi.transport.Transport.serviceCall(Transport.java:155)

   at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)

   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)

   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)

   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

   at java.lang.Thread.run(Thread.java:662)

   at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:255)

   at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:233)

   at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:142)

   at com.hie.cloverleaf.remoteserver.RemoteDBConfigServer_Stub.get(Unknown Source)

   at com.hie.cloverleaf.gui.dbschema.DBSchemaMainPanel.internalReadConfig(Unknown Source)

   at com.hie.cloverleaf.gui.StdGuiMainPanel.safeReadConfig(Unknown Source)

   at com.hie.cloverleaf.gui.dbschema.DBSchemaTool.openFile(Unknown Source)

   at com.hie.cloverleaf.gui.launchpad.LaunchpadPanel.startTool(Unknown Source)

   at com.quovadx.ide.SiteTreeNode.execApp(Unknown Source)

   at com.hie.cloverleaf.gui.launchpad.LaunchpadPanel$11.mouseClicked(Unknown Source)

   at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253)

   at java.awt.Component.processMouseEvent(Component.java:6293)

   at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)

   at java.awt.Component.processEvent(Component.java:6055)

   at java.awt.Container.processEvent(Container.java:2039)

   at java.awt.Component.dispatchEventImpl(Component.java:4653)

   at java.awt.Container.dispatchEventImpl(Container.java:2097)

   at java.awt.Component.dispatchEvent(Component.java:4481)

   at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)

   at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4245)

   at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)

   at java.awt.Container.dispatchEventImpl(Container.java:2083)

   at java.awt.Window.dispatchEventImpl(Window.java:2482)

   at java.awt.Component.dispatchEvent(Component.java:4481)

   at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:648)

   at java.awt.EventQueue.access$000(EventQueue.java:84)

   at java.awt.EventQueue$1.run(EventQueue.java:607)

   at java.awt.EventQueue$1.run(EventQueue.java:605)

   at java.security.AccessController.doPrivileged(Native Method)

   at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

   at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)

   at java.awt.EventQueue$2.run(EventQueue.java:621)

   at java.awt.EventQueue$2.run(EventQueue.java:619)

   at java.security.AccessController.doPrivileged(Native Method)

   at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

   at java.awt.EventQueue.dispatchEvent(EventQueue.java:618)

   at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)

   at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)

   at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)

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

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

   at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

However you can workarround this by delete attributes FIELD_SEP and TERMINATION in TABLE element of according xml files in folder formatsdbschema

http://www.w3.org/2001/XMLSchema-instance” FIELD_SEP=”,” TERMINATION=”$”>

but that means Table Schema Options wont work anymore, anybody knows how to solve this problem?

Thanks & regards,

Yanni Mo

Topic

[Anonymous]

Found the reason of the problem, the schema file for db is under folder %HciRoot%formatdbschemadbschema.xsd which missing attribute  “FIELD_SEP” and “TERMINATION” (strange), I solved it by adding these two attributes. 😀

[Author]

Replies