Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » CDO exception
CDO exception [message #621988] Tue, 12 January 2010 18:26 Go to next message
Zakarov is currently offline ZakarovFriend
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
Re: CDO exception [message #621990 is a reply to message #621988] Tue, 12 January 2010 20:02 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6579
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


Re: CDO exception [message #621991 is a reply to message #621988] Wed, 13 January 2010 09:49 Go to previous messageGo to next message
Zakarov is currently offline ZakarovFriend
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
Re: CDO exception [message #621993 is a reply to message #621988] Wed, 13 January 2010 14:18 Go to previous messageGo to next message
Zakarov is currently offline ZakarovFriend
Messages: 24
Registered: January 2010
Junior Member
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


--
Zakarov


Zakarov
Re: CDO exception [message #621994 is a reply to message #621993] Wed, 13 January 2010 21:16 Go to previous message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6579
Registered: July 2009
Senior Member
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:CDO exception
Next Topic:[MWE] MWE project evolution?
Goto Forum:
  


Current Time: Thu Jun 17 17:15:11 GMT 2021

Powered by FUDForum. Page generated in 0.02898 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top