Home » Modeling » EMF » [CDO] Hibernate Oracle Store
|
| Re: [CDO] Hibernate Oracle Store [message #665569 is a reply to message #665558] |
Fri, 15 April 2011 06:22   |
|
Hi Erdal,
I can hardly comment on Hibernate-specific questions, but...
Am 15.04.2011 08:00, schrieb Erdal Karaca:
> I am trying to connect cdo with oracle through the hibernate store. When the cdo server is started, some cdo specific tables are generated in the oracle database (e.g. CDO_PACKAGE_INFO, ...).
> Unfortunately, if I open a transaction to the cdo server and try to commit the model, I will get errors:
>
> !MESSAGE Rollback in HibernateStore: org.hibernate.exception.SQLGrammarException: could not insert: [PointType]
Stack traces are always helpful ;-)
>
> And the oracle driver complains about missing tables as the model tables are not generated automatically.
>
> What do I miss?
> This is the server-config.xml
>
> <repository name="repo1">
> <property name="overrideUUID" value="repo1" />
> <property name="supportingAudits" value="false" />
> <property name="supportingBranches" value="false" />
> <property name="verifyingRevisions" value="false" />
> <property name="currentLRUCapacity" value="10000" />
> <property name="revisedLRUCapacity" value="100" />
The last three properties are deprecated and ignored.
>
> <property name="teneo.mapping.cascade_policy_on_non_containment"
> value="PERSIST,MERGE" />
> <property name="teneo.mapping.inheritance" value="JOINED" />
> <property name="teneo.mapping.add_index_for_fk" value="true" />
> <property name="hibernate.hbm2ddl.auto" value="update" />
> <property name="hibernate.show_sql" value="false" />
> <property name="hibernate.connection.pool_size" value="10" />
> <property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider" />
>
> <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />
> <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver" />
> <property name="hibernate.connection.url"
> value="jdbc:oracle:thin:@myserver:1521:MYSID" />
> <property name="hibernate.connection.username" value="me" />
> <property name="hibernate.connection.password" value="me" />
> <property name="hibernate.connection.autocommit" value="false" />
I can only guess, but aren't these properties supposed to be nested within the <store> element?
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
>
> <store type="hibernate">
> <mappingProvider type="teneo">
> </mappingProvider>
> </store>
> </repository>
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
| Re: [CDO] Hibernate Oracle Store [message #665570 is a reply to message #665569] |
Fri, 15 April 2011 06:45 |
 Martin Taal
Messages: 5468
Registered: July 2009 |
Senior Member |
|
|
Hi Erdal,
Indeed a full stack trace would help, also do you see other tables being created for your domain model? Hibernate will
print errors in the log if table creation fails but it will continue and throw real exceptions when you try to persist
stuff.
gr. Martin
On 04/15/2011 08:22 AM, Eike Stepper wrote:
> Hi Erdal,
>
> I can hardly comment on Hibernate-specific questions, but...
>
>
> Am 15.04.2011 08:00, schrieb Erdal Karaca:
>> I am trying to connect cdo with oracle through the hibernate store. When the cdo server is started, some cdo specific
>> tables are generated in the oracle database (e.g. CDO_PACKAGE_INFO, ...).
>> Unfortunately, if I open a transaction to the cdo server and try to commit the model, I will get errors:
>>
>> !MESSAGE Rollback in HibernateStore: org.hibernate.exception.SQLGrammarException: could not insert: [PointType]
> Stack traces are always helpful ;-)
>
>>
>> And the oracle driver complains about missing tables as the model tables are not generated automatically.
>>
>> What do I miss?
>> This is the server-config.xml
>>
>> <repository name="repo1">
>> <property name="overrideUUID" value="repo1" />
>> <property name="supportingAudits" value="false" />
>> <property name="supportingBranches" value="false" />
>> <property name="verifyingRevisions" value="false" />
>> <property name="currentLRUCapacity" value="10000" />
>> <property name="revisedLRUCapacity" value="100" />
> The last three properties are deprecated and ignored.
>
>>
>> <property name="teneo.mapping.cascade_policy_on_non_containment"
>> value="PERSIST,MERGE" />
>> <property name="teneo.mapping.inheritance" value="JOINED" />
>> <property name="teneo.mapping.add_index_for_fk" value="true" />
>> <property name="hibernate.hbm2ddl.auto" value="update" />
>> <property name="hibernate.show_sql" value="false" />
>> <property name="hibernate.connection.pool_size" value="10" />
>> <property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider" />
>>
>> <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />
>> <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver" />
>> <property name="hibernate.connection.url"
>> value="jdbc:oracle:thin:@myserver:1521:MYSID" />
>> <property name="hibernate.connection.username" value="me" />
>> <property name="hibernate.connection.password" value="me" />
>> <property name="hibernate.connection.autocommit" value="false" />
> I can only guess, but aren't these properties supposed to be nested within the <store> element?
>
> Cheers
> /Eike
>
> ----
> http://www.esc-net.de
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>>
>> <store type="hibernate">
>> <mappingProvider type="teneo">
>> </mappingProvider>
>> </store>
>> </repository>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
| | |
| Re: [CDO] Hibernate Oracle Store [message #665606 is a reply to message #665598] |
Fri, 15 April 2011 09:05 |
Erdal Karaca
Messages: 854
Registered: July 2009 |
Senior Member |
|
|
OK, thanks!
In the logs I see:
create table cdo_package_info (packageURI varchar2(255 char) not null, parentURI varchar2(255 char), cdo_package_unit_id varchar2(255 char), idx number(10,0), primary key (packageURI))
create table cdo_package_unit (nsUri varchar2(255 char) not null, originalType raw(255), timeStamp number(19,0), EPackageBlob blob, primary key (nsUri))
create table cdo_system_information (id number(10,0) not null, creationTime number(19,0), primary key (id))
create table cdo_system_property (name varchar2(255 char) not null, value clob, primary key (name))
alter table cdo_package_info add constraint FK5702C978798F06A8 foreign key (cdo_package_unit_id) references cdo_package_unit
But there is nothing that seems to create the tables for my meta model.
I would guess that prior to committing the model, teneo would have to create the meta model tables. It just tries to insert the model without checking whether the tables exist or not...
The full stack (client side):
[ERROR] Rollback in HibernateStore: org.hibernate.exception.SQLGrammarException: could not insert: [PointType]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateCo nverter.java:90)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExce ptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2285)
at org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2678)
at org.hibernate.action.EntityInsertAction.execute(EntityInsert Action.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:27 9)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue. java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue. java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.perfor mExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(De faultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
at org.eclipse.emf.cdo.server.internal.hibernate.HibernateStore Accessor.doWrite(HibernateStoreAccessor.java:633)
at org.eclipse.emf.cdo.spi.server.StoreAccessorBase.write(Store AccessorBase.java:149)
at org.eclipse.emf.cdo.internal.server.TransactionCommitContext .write(TransactionCommitContext.java:408)
at org.eclipse.emf.cdo.spi.server.InternalCommitContext$1.runLo op(InternalCommitContext.java:40)
at org.eclipse.emf.cdo.spi.server.InternalCommitContext$1.runLo op(InternalCommitContext.java:1)
at org.eclipse.net4j.util.om.monitor.ProgressDistributor.run(Pr ogressDistributor.java:96)
at org.eclipse.emf.cdo.server.internal.net4j.protocol.CommitTra nsactionIndication.indicatingCommit(CommitTransactionIndicat ion.java:244)
at org.eclipse.emf.cdo.server.internal.net4j.protocol.CommitTra nsactionIndication.indicating(CommitTransactionIndication.ja va:92)
at org.eclipse.emf.cdo.server.internal.net4j.protocol.CDOServer IndicationWithMonitoring.indicating(CDOServerIndicationWithM onitoring.java:109)
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:326)
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:251)
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)
Caused by: java.sql.BatchUpdateException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(D atabaseError.java:343)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(Orac lePreparedStatement.java:10698)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBa tcher.java:70)
at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatche r.java:56)
at org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2265)
... 27 more
|
|
|
| Re: [CDO] Hibernate Oracle Store [message #665626 is a reply to message #665606] |
Fri, 15 April 2011 09:44 |
Martin Taal
Messages: 5468
Registered: July 2009 |
Senior Member |
|
|
Hi Erdal,
Are you registering the epackages in CDO?
Can you paste the code you use to initialize CDO and persist a first object?
gr. Martin
On 04/15/2011 11:06 AM, Erdal Karaca wrote:
> OK, thanks!
>
> In the logs I see:
>
> create table cdo_package_info (packageURI varchar2(255 char) not null, parentURI varchar2(255 char), cdo_package_unit_id
> varchar2(255 char), idx number(10,0), primary key (packageURI))
> create table cdo_package_unit (nsUri varchar2(255 char) not null, originalType raw(255), timeStamp number(19,0),
> EPackageBlob blob, primary key (nsUri))
> create table cdo_system_information (id number(10,0) not null, creationTime number(19,0), primary key (id))
> create table cdo_system_property (name varchar2(255 char) not null, value clob, primary key (name))
> alter table cdo_package_info add constraint FK5702C978798F06A8 foreign key (cdo_package_unit_id) references
> cdo_package_unit
>
> But there is nothing that seems to create the tables for my meta model.
>
> I would guess that prior to committing the model, teneo would have to create the meta model tables. It just tries to
> insert the model without checking whether the tables exist or not...
>
> The full stack (client side):
>
> [ERROR] Rollback in HibernateStore: org.hibernate.exception.SQLGrammarException: could not insert: [PointType]
> at org.hibernate.exception.SQLStateConverter.convert(SQLStateCo nverter.java:90)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExce ptionHelper.java:66)
> at org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2285)
> at org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2678)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsert Action.java:79)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:27 9)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue. java:263)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue. java:167)
> at org.hibernate.event.def.AbstractFlushingEventListener.perfor mExecutions(AbstractFlushingEventListener.java:321)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(De faultFlushEventListener.java:50)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
> at org.eclipse.emf.cdo.server.internal.hibernate.HibernateStore Accessor.doWrite(HibernateStoreAccessor.java:633)
> at org.eclipse.emf.cdo.spi.server.StoreAccessorBase.write(Store AccessorBase.java:149)
> at org.eclipse.emf.cdo.internal.server.TransactionCommitContext .write(TransactionCommitContext.java:408)
> at org.eclipse.emf.cdo.spi.server.InternalCommitContext$1.runLo op(InternalCommitContext.java:40)
> at org.eclipse.emf.cdo.spi.server.InternalCommitContext$1.runLo op(InternalCommitContext.java:1)
> at org.eclipse.net4j.util.om.monitor.ProgressDistributor.run(Pr ogressDistributor.java:96)
> at org.eclipse.emf.cdo.server.internal.net4j.protocol.CommitTra
> nsactionIndication.indicatingCommit(CommitTransactionIndicat ion.java:244)
> at org.eclipse.emf.cdo.server.internal.net4j.protocol.CommitTra
> nsactionIndication.indicating(CommitTransactionIndication.ja va:92)
> at org.eclipse.emf.cdo.server.internal.net4j.protocol.CDOServer
> IndicationWithMonitoring.indicating(CDOServerIndicationWithM onitoring.java:109)
> 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:326)
> at org.eclipse.net4j.signal.IndicationWithResponse.execute(Indi cationWithResponse.java:63)
> Path: news.eclipse.org!not-for-mail
> From: Martin Taal <mtaal@elver.org>
> Newsgroups: eclipse.tools.emf
> Subject: Re: [CDO] Hibernate Oracle Store
> Date: Fri, 15 Apr 2011 10:03:25 +0200
> Organization: EclipseCorner
> Lines: 28
> Message-ID: <io8tm5$sr9$1@news.eclipse.org>
> References: <io8p3l$lva$1@news.eclipse.org> <io8q1u$ngl$1@news.eclipse.org>
> NNTP-Posting-Host: ip5650ded8.direct-adsl.nl
> Mime-Version: 1.0
> Content-Type: text/plain; charset=UTF-8; format=flowed
> Content-Transfer-Encoding: 7bit
> X-Trace: news.eclipse.org 1302854149 29545 86.80.222.216 (15 Apr 2011 07:55:49 GMT)
> X-Complaints-To: news@news.eclipse.org
> NNTP-Posting-Date: Fri, 15 Apr 2011 07:55:49 +0000 (UTC)
> User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.14) Gecko/20110223 Lightning/1.0b2 Thunderbird/3.1.8
> In-Reply-To: <io8q1u$ngl$1@news.eclipse.org>
> Xref: news.eclipse.org eclipse.tools.emf:53128
>
> These are just examples on how to customize the mapping to the relational db. In many cases you don't need to do that
> and the out-of-the-box generated mapping should work fine.
>
> gr. Martin
>
> On 04/15/2011 09:01 AM, Erdal Karaca wrote:
>> In the example (Company Project), I see there are some xml configuration files added to the cdo configuration
>> (company_model_teneo_annotations.xml, generated_hbm.xml) on the server side.
>>
>> I did not extend my metamodel by teneo annotations...
> at org.eclipse.net4j.signal.IndicationWithMonitoring.execute(In dicationWithMonitoring.java:63)
> at org.eclipse.net4j.signal.Signal.runSync(Signal.java:251)
> 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)
> Caused by: java.sql.BatchUpdateException: ORA-00942: table or view does not exist
>
> at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(D atabaseError.java:343)
> at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(Orac lePreparedStatement.java:10698)
> at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBa tcher.java:70)
> at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatche r.java:56)
> at org.hibernate.persister.entity.AbstractEntityPersister.inser t(AbstractEntityPersister.java:2265)
> ... 27 more
>
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
|
| Re: [CDO] Hibernate Oracle Store [message #665631 is a reply to message #665626] |
Fri, 15 April 2011 10:14 |
Erdal Karaca
Messages: 854
Registered: July 2009 |
Senior Member |
|
|
This is my connection method:
As you can see, I am registering only my own packages which have to start with "http://www.example.com/"
private void connect(final BundleContext bundleContext, String server,
String repoName) {
OMPlatform.INSTANCE.setDebugging(true);
OMPlatform.INSTANCE.addLogHandler(PrintLogHandler.CONSOLE);
OMPlatform.INSTANCE.addTraceHandler(PrintTraceHandler.CONSOL E);
container = ContainerUtil.createContainer();
Net4jUtil.prepareContainer(container);
TCPUtil.prepareContainer(container);
CDONet4jUtil.prepareContainer(container);
container.activate();
connector = TCPUtil.getConnector(container, server);
CDOSessionConfiguration configuration = CDONet4jUtil
.createSessionConfiguration();
configuration.setConnector(connector);
configuration.setRepositoryName(repoName);
session = configuration.openSession();
List<String> keys = new ArrayList<String>(
EPackage.Registry.INSTANCE.keySet());
for (String pak : keys) {
if (!pak.startsWith("http://www.example.com/")) {
continue;
}
EPackage pack = EPackage.Registry.INSTANCE.getEPackage(pak);
session.getPackageRegistry().putEPackage(pack);
}
session.options().setCollectionLoadingPolicy(
CDOUtil.createCollectionLoadingPolicy(0, 300));
}
I am committing my objects like this:
myResource = myFactory.createMyResource();
listOfRsources = transaction.getOrCreateResource("/myresources");
listOfResources.getContents().add(myResource);
transaction.commit();
Note: this works when using the db storage with any of the available adapters (e.g. h2, mysql).
[Updated on: Fri, 15 April 2011 10:16] Report message to a moderator |
|
| | | | |
Goto Forum:
Current Time: Fri Apr 19 06:01:50 GMT 2024
Powered by FUDForum. Page generated in 0.02607 seconds |
] 
Search
Help
Register
Login
Home
