search

google-code-export / webical

Automatically exported from code.google.com/p/webical
GNU General Public License v3.0
1 stars 1 forks source link

Add oracle support. #86

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What happened?

Since WebiCal uses Hibernate for the DAO, it should be relatively
transpartent to use between different databases. However, this is not the
case with Oracle, as the table and column names used at the moment, a few
of them are reserved Oracle keywords. This required moderate modification
to the schema creation scripts, as well as heavy modification to the
hibernate implementation. While, in the future, it may be possible to
consider refactoring the hibernate implementation, the short term stopgap
would be to patch it. Attached is the modified scrips for Oracle schema.
Soon I hope to include a patch for the Hibernate implementation.

Original issue reported on code.google.com by andreus...@gmail.com on 23 Sep 2009 at 2:56

Attachments:

GoogleCodeExporter commented 9 years ago 
Here is the patch file. Note this only modifies the webical-core project. 
Anyone that
still wishes to implement this needs to modify webical-war project acording to 
their
environment.

Original comment by andreus...@gmail.com on 23 Sep 2009 at 3:05

Attachments:

GoogleCodeExporter commented 9 years ago 
I have taken a quick look at the patch and I see what you've done. I do think a 
lot
of the changes could have been isolated to the mapping files (specifying a 
different,
explicit table/column name) instead of altering the domain classes as well.

I would like to make some adoptions to the patch before merging it with trunk. 
I need
a couple of weeks to round up my current duties though. Would you be willing to 
help
me test the changes I make? I don't have access to an oracle server ATM and am 
not to
keen on setting one up (I have had some bitter arguments with 8/9 versions on 
linux
before).

Thanks for your efforts so far.

Original comment by ivovando...@gmail.com on 24 Sep 2009 at 1:09

GoogleCodeExporter commented 9 years ago 
I would have no problem testing it. If its possible however, would you be able 
to
recommend a good caldav server to match webical for testin?. We are still going 
over
infrastructure details in our organization and haven't touched the webical
installation aside from getting it up and running with our oracle database. I 
agree
that if its possible, the best course of action would be to refactor the table 
and
column names at the hibernate configuration level. However since while starting 
up
hibernate in tomcat it will validate the schema with the class properties, the 
class
properties had also to be changed unfortunately. Common practice would be to 
refactor
table and column names as something like wc_table and wc_column_name so to make 
it
database agnostic.

Original comment by andreus...@gmail.com on 24 Sep 2009 at 2:02

GoogleCodeExporter commented 9 years ago 
Great, that makes it much easier to implement something quickly.

Concerning the caldav server; there are a couple of options depending on your
preferences:
 - Cosmo / chandler
 - Apple calendar server (the open source version is quite good, I've used it for
development. Works great on linux to btw)
 - DavIcal (we use this at func)
 - Bedework. Haven't used this one in quite a while.

About the hibernate mappings. The validation is indeed done by checking the 
class
properties with the database column names by default. However, you can change 
this
by using a 'column' attribute on the property element. See
http://docs.jboss.org/hibernate/core/3.3/reference/en/html/components.html for 
more
details

Original comment by ivovando...@gmail.com on 24 Sep 2009 at 2:25

GoogleCodeExporter commented 9 years ago 
Created db creation script for Oracle.
Changed fields sizes in line with Oracle varchar2 length limits.
Removed reserved words for Oracle.

Original comment by hz0885 on 15 Aug 2012 at 6:54