CDO exception [message #507286] |
Tue, 12 January 2010 18:26 |
|
Hi all,
i'm a new user of cdo ,
i'm trying to save a model into cdo but i get this exception
org.eclipse.net4j.db.DBException: Column 'ISPOINT' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'ISPOINT' is not a column in the target table.
at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.j ava:428)
...........
my metamodel contains a class with an optionnal boolean attribute 'ispoint' (0..1)
Thank you in advance.
Zakarov
Zakarov
|
|
|
Re: CDO exception [message #507298 is a reply to message #507286] |
Tue, 12 January 2010 20:02 |
|
Hi Zakarov,
CDO is supported in the EMF newsgroup which I've added to the list of
recipients.
Which CDO version are you using?
What is the full stack trace?
Can you attach a copy of your model?
Cheers
/Eike
----
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Zakarov schrieb:
> Hi all,
>
> i'm a new user of cdo ,
> i'm trying to save a model into cdo but i get this exception
>
> org.eclipse.net4j.db.DBException: Column 'ISPOINT' is either not in
> any table in the FROM list or appears within a join specification and
> is outside the scope of the join specification or appears in a HAVING
> clause and is not in the GROUP BY list. If this is a CREATE or ALTER
> TABLE statement then 'ISPOINT' is not a column in the target table.
> at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.j
> ava:428)
> ...........
>
> my metamodel contains a class with an optionnal boolean attribute
> 'ispoint' (0..1)
>
> Thank you in advance.
> Zakarov
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
Re: CDO exception [message #507378 is a reply to message #507286] |
Wed, 13 January 2010 09:49 |
|
Hi Eike,
First thank you for your reply
i use the 2.0.0 version of cdo
since i'm not yet allowed to attach files in this forum , here is the full stack , you will find after the model .
...................
TCPSelector [org.eclipse.spi.net4j.Channel] Handling buffer from multiplexer: Buffer@21 --> Channel[1, CLIENT]
ReceiveSerializer-Channel[1, CLIENT] [org.eclipse.net4j.signal.SignalProtocol] Received buffer for correlation -6
main [org.eclipse.internal.net4j.buffer.BufferPool] Retaining Buffer@21
[ERROR] Rollback in DBStore: org.eclipse.net4j.db.DBException: Column 'ISPOINT' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'ISPOINT' is not a column in the target table.
at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.j ava:428)
at org.eclipse.net4j.spi.db.DBAdapter.createTable(DBAdapter.jav a:144)
at org.eclipse.net4j.spi.db.DBAdapter.createTables(DBAdapter.ja va:109)
at org.eclipse.emf.cdo.server.internal.db.mapping.AbstractMappi ngStrategy.createMapping(AbstractMappingStrategy.java:298)
at org.eclipse.emf.cdo.server.internal.db.DBStoreAccessor.write PackageUnits(DBStoreAccessor.java:496)
at org.eclipse.emf.cdo.spi.server.StoreAccessor.write(StoreAcce ssor.java:129)
at org.eclipse.emf.cdo.server.internal.db.DBStoreAccessor.acces s$4(DBStoreAccessor.java:1)
at org.eclipse.emf.cdo.server.internal.db.DBStoreAccessor$1.run Loop(DBStoreAccessor.java:80)
at org.eclipse.emf.cdo.server.internal.db.DBStoreAccessor$1.run Loop(DBStoreAccessor.java:1)
at org.eclipse.net4j.util.om.monitor.ProgressDistributor.run(Pr ogressDistributor.java:96)
at org.eclipse.emf.cdo.server.internal.db.DBStoreAccessor.write (DBStoreAccessor.java:294)
at org.eclipse.emf.cdo.internal.server.TransactionCommitContext Impl.write(TransactionCommitContextImpl.java:269)
at org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication$1.runLoop(CommitTransactionIndication.java:73)
at org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication$1.runLoop(CommitTransactionIndication.java:1)
at org.eclipse.net4j.util.om.monitor.ProgressDistributor.run(Pr ogressDistributor.java:96)
at org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicatingCommit(CommitTransactionIndication.ja va:325)
at org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicating(CommitTransactionIndication.java:198 )
at org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicating(CommitTransactionIndication.java:140 )
at org.eclipse.net4j.signal.IndicationWithMonitoring.indicating (IndicationWithMonitoring.java:84)
at org.eclipse.net4j.signal.IndicationWithResponse.doExtendedIn put(IndicationWithResponse.java:90)
at org.eclipse.net4j.signal.Signal.doInput(Signal.java:312)
at org.eclipse.net4j.signal.IndicationWithResponse.execute(Indi cationWithResponse.java:63)
at org.eclipse.net4j.signal.IndicationWithMonitoring.execute(In dicationWithMonitoring.java:63)
at org.eclipse.net4j.signal.Signal.runSync(Signal.java:239)
at org.eclipse.net4j.signal.Signal.run(Signal.java:147)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unkno wn Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Exception in thread "main" org.eclipse.net4j.util.transaction.TransactionException: Rollback in DBStore: org.eclipse.net4j.db.DBException: Column 'ISPOINT' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'ISPOINT' is not a column in the target table.
at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.j ava:428)
at org.eclipse.net4j.spi.db.DBAdapter.createTable(DBAdapter.jav a:144)
at org.eclipse.net4j.spi.db.DBAdapter.createTables(DBAdapter.ja va:109)
at org.eclipse.emf.cdo.server.internal.db.mapping.AbstractMappi ngStrategy.createMapping(AbstractMappingStrategy.java:298)
at org.eclipse.emf.cdo.server.internal.db.DBStoreAccessor.write PackageUnits(DBStoreAccessor.java:496)
at org.eclipse.emf.cdo.spi.server.StoreAccessor.write(StoreAcce ssor.java:129)
at org.eclipse.emf.cdo.server.internal.db.DBStoreAccessor.acces s$4(DBStoreAccessor.java:1)
at org.eclipse.emf.cdo.server.internal.db.DBStoreAccessor$1.run Loop(DBStoreAccessor.java:80)
at org.eclipse.emf.cdo.server.internal.db.DBStoreAccessor$1.run Loop(DBStoreAccessor.java:1)
at org.eclipse.net4j.util.om.monitor.ProgressDistributor.run(Pr ogressDistributor.java:96)
at org.eclipse.emf.cdo.server.internal.db.DBStoreAccessor.write (DBStoreAccessor.java:294)
at org.eclipse.emf.cdo.internal.server.TransactionCommitContext Impl.write(TransactionCommitContextImpl.java:269)
at org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication$1.runLoop(CommitTransactionIndication.java:73)
at org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication$1.runLoop(CommitTransactionIndication.java:1)
at org.eclipse.net4j.util.om.monitor.ProgressDistributor.run(Pr ogressDistributor.java:96)
at org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicatingCommit(CommitTransactionIndication.ja va:325)
at org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicating(CommitTransactionIndication.java:198 )
at org.eclipse.emf.cdo.internal.server.protocol.CommitTransacti onIndication.indicating(CommitTransactionIndication.java:140 )
at org.eclipse.net4j.signal.IndicationWithMonitoring.indicating (IndicationWithMonitoring.java:84)
at org.eclipse.net4j.signal.IndicationWithResponse.doExtendedIn put(IndicationWithResponse.java:90)
at org.eclipse.net4j.signal.Signal.doInput(Signal.java:312)
at org.eclipse.net4j.signal.IndicationWithResponse.execute(Indi cationWithResponse.java:63)
at org.eclipse.net4j.signal.IndicationWithMonitoring.execute(In dicationWithMonitoring.java:63)
at org.eclipse.net4j.signal.Signal.runSync(Signal.java:239)
at org.eclipse.net4j.signal.Signal.run(Signal.java:147)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unkno wn Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.eclipse.emf.internal.cdo.transaction.CDOSingleTransactio nStrategyImpl.commit(CDOSingleTransactionStrategyImpl.java:6 3)
at org.eclipse.emf.internal.cdo.transaction.CDOTransactionImpl. commit(CDOTransactionImpl.java:598)
at org.eclipse.emf.internal.cdo.transaction.CDOTransactionImpl. commit(CDOTransactionImpl.java:612)
at rg.eclipse.emf.cdo.examples.Test.doRunC(Test.java:118)
at rg.eclipse.emf.cdo.examples.Test.main(Test.java:85)
----------------------------------------------
the xmi model :
<?xml version="1.0" encoding="ASCII"?>
<cobol:Model xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<model>
<programmes name="FLCV07">
<fonctions name="F0A">
<sousFonctionsOrLigne xsi:type="cobol:SousFonction" name="F0ASFBB" extendedName="ACCES DIRECT PROGRAMME INTERDIT" niveau="10">
<lignes xsi:type="cobol:IF">
<condition xsi:type="cobol:OperatorExp">
<leftExp>
<leftExp>
<leftExp>
<leftExp>
<leftExp>
<leftExp xsi:type="cobol:ConstantExp">
<value xsi:type="cobol:RealSegment" name="EIBCALEN"/>
</leftExp>
</leftExp>
</leftExp>
</leftExp>
<opName/>
<rightExp>
<leftExp>
<leftExp>
<leftExp>
<leftExp xsi:type="cobol:ConstantExp">
<value xsi:type="cobol:KeywordLiteral" value="ZERO"/>
</leftExp>
</leftExp>
</leftExp>
</leftExp>
</rightExp>
</leftExp>
</leftExp>
</condition>
<thenStatements xsi:type="cobol:EXEC" ordreCICS="SEND LENGTH (25) ERASE FROM (Z900-X25X00)"/>
<thenStatements xsi:type="cobol:EXEC" ordreCICS="RETURN"/>
</lignes>
</sousFonctionsOrLigne>
</fonctions>
</programmes>
</model>
</cobol:Model>
Thank you.
Zakarov
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.01843 seconds