[Tm4j-developers] [ tm4j-Bugs-973979 ] Exception when creating two topics with the same base name

[SourceForge.net <no...@so...>]

Bugs item #973979, was opened at 2004-06-16 17:08
Message generated for change (Comment added) made by kal_ahmed
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=391879&aid=973979&group_id=27895

Category: Hibernate Impl
Group: TM4J 0.9.4
Status: Open
Resolution: None
Priority: 5
Submitted By: Andy Peel (atpeel)
Assigned to: Nobody/Anonymous (nobody)
Summary: Exception when creating two topics with the same base name

Initial Comment:
If I create two topics with the same base name, I get
this exception:

Message:
testUpdateTopic_SameBaseName(test.client.TestTopicDelegate):
Source exception thrown:
org.tm4j.topicmap.TopicMapRuntimeException: 
Cause: java.sql.SQLException: ERROR:  syntax error at
or near "topic_types" at character 15
Cause:ERROR:  syntax error at or near "topic_types" at
character 15

The problem seems to be inside
org.tm4j.topicmap.hibernate.TopicImpl.replaceTopicReference()
where the SQL query generated includes the fragment
"update ignore". The ignore keyword only seems to work
on BDB/MySQl, whereas I'm using PostgreSQL.

----------------------------------------------------------------------

>Comment By: Kal Ahmed (kal_ahmed)
Date: 2004-06-16 19:10

Message:
Logged In: YES 
user_id=176992

I wonder if this is a Hibernate problem. There was a new
Hibernate release on June 1st (2.1.4) - perhaps it is worth
giving that a spin to see if the Postgres problem got fixed ?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=391879&aid=973979&group_id=27895