Eclipse Community Forums: EMF "Technology" (Ecore Tools, EMFatic, etc)

Help

Home

Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc) » CDO exception

Show: Today's Messages :: Show Polls :: Message Navigator

CDO exception [message #621988]

Tue, 12 January 2010 18:26

Zakarov

Messages: 24
Registered: January 2010

Junior Member

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
--
ddddddd

Zakarov

Report message to a moderator

Re: CDO exception [message #621990 is a reply to message #621988]

Tue, 12 January 2010 20:02

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

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

Report message to a moderator

Re: CDO exception [message #621991 is a reply to message #621988]

Wed, 13 January 2010 09:49

Zakarov

Messages: 24
Registered: January 2010

Junior Member

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: mailto: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 mailto: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

Zakarov

Report message to a moderator