[TM4J-users] importing xtm to Db with hibernate

[Daniel M. <mei...@hi...>]

Hello

 

Im trying to import a "big" xtm file (~6MByte, ~4000 topics and ~ 4000
assocciations ) to an oracle 8 database (hibernate backend).

Code looks like:

 

TopicMapProviderFactory factory = TopicMapProviderFactory.newInstance(); 

TopicMapProvider provider = factory.newTopicMapProvider(); 

TopicMapSource source = new SerializedTopicMapSource("c:\\temp\\opera.xtm");


TopicMap map = provider.addTopicMap(source);

 

 

Now this process takes very looong (>1h). When I log the hibernate sql
commands,

I see that the backend is autocommiting every insert/update. This is in my
mind

not good, and is probably the problem. One commit at the end is enough
during an import.

So I set autocommit in the provider.properties to false, and added the code:

.

TopicMap map = provider.addTopicMap(source);

Provider.getOpenTransaction().commit();

 

But this doesen't helped.

Maybe the problem is that provider.isTransactional() returns false. I think
the oracle DB

should be able to handle transactions. (I use the jdbc driver from oracle).

 

What can I do?

 

Greetings, Daniel