Re: [Oreka-devel] Hello developers

Gonzalo,

 

Thanks for your feedback. We are moving to a new database naming system
where all tables are prefixed in order to avoid name clash. This is actually
already implemented in svn head. So I am assuming you are compiling 0.5-313.
If this is the case, all jars are in the oreka-0.5-1-java-dependencies.zip
that can be found under Oreka-0.5 on the sourceforge download page.

 

Cheers,

Henri

 

  _____  

From: Gonzalo Brusella [mailto:gbr...@gm...] 
Sent: 20 October 2009 10:37
To: oreka-devel
Subject: [Oreka-devel] Hello developers

 

Hello Oreka Developers,

First  things first. My Name is Gonzalo Brusella, I'm a developer from
Buenos Aires, Argentina, mostly a newbie on Java.

Last week I had to deploy Oreka using a MSSQL 2008 as DB server and I had a
problem: The user table name. Since MSSQL 2005 user is a reserved word (and
this is not the only DB engine with the word listed as reserved, I remember
PostgreSQL as a sample).

In order to fix this I had to recompile the Java projects (by the way: new
windows compile instructions are required and very appreciated), with a
modification on the User.java file on the "orkabasej" project. The
modification was simple: change the table to "@Table(name = "[user]")" (the
square brackets are for escaping the reserved word user).

I know that is not a polite solution (It would be better to have a
SQL2005/2008 dialect on hibernate... but the 3.1 beta 1 version does not
have it, as far as I know).

Thanks for your patience on this, and sorry for my bad English.

Gonzalo A. Brusella
go...@br...
http://www.brusella.com.ar