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)
CDO exception [message #507286] 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


Zakarov
Re: CDO exception [message #507298 is a reply to message #507286] 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 #507378 is a reply to message #507286] 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: 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
Re: CDO exception [message #507442 is a reply to message #507286] 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
Re: CDO exception [message #507575 is a reply to message #507442] 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:teneo, databinding, model and a treeview
Next Topic:CDO exception
Goto Forum:
  


Current Time: Fri Jun 18 19:28:58 GMT 2021

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

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

Back to the top