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

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

Tue, 12 January 2010 13:26

Eclipse User

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

Re: CDO exception [message #507298 is a reply to message #507286]

Tue, 12 January 2010 15:02

Eclipse User

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

Re: CDO exception [message #507378 is a reply to message #507286]

Wed, 13 January 2010 04:49

Eclipse User

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.

Re: CDO exception [message #507442 is a reply to message #507286]

Wed, 13 January 2010 09:18

Eclipse User

hi Eike,

i solved the problem ; thanks to this :

http://wiki.eclipse.org/Getting_started_with_CDO_Galileo#org .eclipse.net4j.db.DBException:_Column_.27CREATED.27.E2.80.A6

Re: CDO exception [message #507575 is a reply to message #507442]

Wed, 13 January 2010 16:16

Eclipse User

Zakarov schrieb:
> hi Eike,
>
> i solved the problem ; thanks to this :
>
> http://wiki.eclipse.org/Getting_started_with_CDO_Galileo#org .eclipse.net4j.db.DBException:_Column_.27CREATED.27.E2.80.A6
>
Excellent. We're here if you have more questions ;-)

Cheers
/Eike

----
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Previous Topic:	teneo, databinding, model and a treeview
Next Topic:	CDO exception

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 14:21:23 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter