search

kmmbvnr / sarasvati

Automatically exported from code.google.com/p/sarasvati
0 stars 5 forks source link

Oracle Support #68

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Set up com.googlecode.sarasvati.example.hib examples in eclipse; using 
Oracle10gDialect in hibernate.cfg.xml
2. Run HibTestSetup.main() ( which in turn calls init() ) to create schema
3. Got error message
4. Should I instead manually run the oracle schema set up script? But I could 
only find MySQL, PostGRESQL, Sybase folders in the sarasvati-java-1.0.3/db/ 
folder.

What is the expected output? What do you see instead?
Expected output is a successful load of demo workflow process definition into 
HibEngine.

What version of the product are you using? On what operating system?
Sarasvati 1.0.3, Windows Server 2003 Std, Oracle 10g, Java 1.5.0_22

Please provide any additional information below.

Original issue reported on code.google.com by yan...@gmail.com on 23 Nov 2010 at 8:41

Attachments:

GoogleCodeExporter commented 9 years ago 
I did some work on the oracle db init script. Unfortunately, all the sarasvati 
hibernate classes are configured to IDENTITY generation, which oracle does not 
support. If I change them to AUTO, that will break the current setup for 
postgresql users, since it will switch to sequence. I think I may need to write 
a custom id generator to do the right thing for the various databases.

Original comment by plor...@gmail.com on 23 Nov 2010 at 9:47

GoogleCodeExporter commented 9 years ago 
Uhoh, our team rather relies heavily on Oracle databases ... is there a way on 
my end to do anything to get Oracle and Sarasvati to mesh? Either modify / 
subclass the classes so that they use 
@GeneratedValue(strategy=GenerationType.AUTO) perhaps?

... I suppose writing that custom id generator will be a long term project?

Original comment by yan...@gmail.com on 23 Nov 2010 at 10:09

GoogleCodeExporter commented 9 years ago 
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.

Original comment by plor...@gmail.com on 24 Nov 2010 at 9:33

GoogleCodeExporter commented 9 years ago 
Thanks for such a quick response! I'll check out the custom id generator

Original comment by yan...@gmail.com on 25 Nov 2010 at 12:14

GoogleCodeExporter commented 9 years ago 
Reopening. Code broke postgres, will need to investigate how to handle both.

Original comment by plor...@gmail.com on 24 Jul 2011 at 4:27

GoogleCodeExporter commented 9 years ago

Original comment by plor...@gmail.com on 24 Jul 2011 at 4:27

GoogleCodeExporter commented 9 years ago

Original comment by plor...@gmail.com on 22 Sep 2011 at 1:58

GoogleCodeExporter commented 9 years ago 
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).

Original comment by plor...@gmail.com on 18 Oct 2012 at 1:50

GoogleCodeExporter commented 9 years ago

Original comment by plor...@gmail.com on 21 Oct 2012 at 2:57

GoogleCodeExporter commented 9 years ago 
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?

Original comment by hjlvande...@gmail.com on 1 Nov 2012 at 11:23

GoogleCodeExporter commented 9 years ago

Original comment by plor...@gmail.com on 2 Dec 2012 at 7:33