Re: Issue 68 in sarasvati: Oracle Support

[sara...@googlecode.com]

Updates:
Summary: Oracle Support
Status: Fixed

Comment #3 on issue 68 by plorenz: Oracle Support
http://code.google.com/p/sarasvati/issues/detail?id=68

I've added the custom id generator and updated the oracle create scripts.
If you're interested, please check out trunk and see if it works for you. I
still need to double check that I haven't broken postgresql, but otherwise
I think this issue is resolved.

If you have any trouble let me know. I'm hoping I can do the testing and do
a release this weekend.

[sara...@googlecode.com]

Comment #4 on issue 68 by yangyq: Oracle Support
http://code.google.com/p/sarasvati/issues/detail?id=68

Thanks for such a quick response! I'll check out the custom id generator

[sara...@googlecode.com]

Updates:
Status: Accepted

Comment #5 on issue 68 by plor...@gmail.com: Oracle Support
http://code.google.com/p/sarasvati/issues/detail?id=68

Reopening. Code broke postgres, will need to investigate how to handle both.

[sara...@googlecode.com]

Updates:
Labels: -Milestone-1.0.4 Milestone-1.0.5

Comment #6 on issue 68 by plor...@gmail.com: Oracle Support
http://code.google.com/p/sarasvati/issues/detail?id=68

(No comment was entered for this change.)

[sara...@googlecode.com]

Updates:
Labels: -Milestone-1.0.5 Milestone-1.0.6

Comment #7 on issue 68 by plor...@gmail.com: Oracle Support

[sara...@googlecode.com]

Updates:
Status: Fixed
Owner: plor...@gmail.com

Comment #8 on issue 68 by plor...@gmail.com: Oracle Support
http://code.google.com/p/sarasvati/issues/detail?id=68

Fix with some patches from Massimo Manfredino. Unfortunately requires some
non-backwards compatible changes to the postgresql schema (which could be
handled with a migration script).

[sara...@googlecode.com]

Updates:
Labels: -Milestone-1.0.6 Milestone-1.1.0

Comment #9 on issue 68 by plor...@gmail.com: Oracle Support
http://code.google.com/p/sarasvati/issues/detail?id=68

[sara...@googlecode.com]

Comment #10 on issue 68 by hjlvande...@gmail.com: Oracle Support
http://code.google.com/p/sarasvati/issues/detail?id=68

We are trying to make Sarasvati work with Oracle and run into the same
problem:

Exception in thread "main" org.hibernate.MappingException: Dialect does not
support identity key generation

I have checked out the trunk, but cannot find the fix for Oracle this
thread talks about. How can we make Sarasvati run with Oracle?

[Paul Lorenz]

The fix was to switch the @Id annotations on the entity classes. 

Fix is in this commit: http://code.google.com/p/sarasvati/source/detail?r=1238

The deltas are all similar to:

40		public class HibArc implements Arc
40	41		{
41	42		@Id
42		-	@GeneratedValue(strategy=GenerationType.IDENTITY)
	43	+	@GeneratedValue(strategy=GenerationType.AUTO, generator="sequence_generator")
	44	+	@SequenceGenerator(name="sequence_generator", sequenceName="wf_arc_seq")

Have you tried running with trunk, and seen the same error?

Cheers,

Paul

--
You received this message because you are subscribed to the Google Groups "sarasvati-wf-issues" group.
To post to this group, send email to sarasvati-wf-issues@googlegroups.com.
To unsubscribe from this group, send email to sarasvati-wf-issues+unsub...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sarasvati-wf-issues?hl=en.

[sara...@googlecode.com]

Updates:
Status: Released
Labels: -Milestone-1.1.0 Milestone-2.0.0

Comment #11 on issue 68 by plor...@gmail.com: Oracle Support