somoso / vaadin-appfoundation

Automatically exported from code.google.com/p/vaadin-appfoundation
0 stars 0 forks source link

PermissionEntity does not work with Oracle #14

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Use Oracle as DBMS
2. Create an new PermissionEntity
3. Try to store it

What is the expected output? What do you see instead?
The entity must be stored but the "resource" column (or PermissionEntity class 
attribute) is a reserverd keyword so I got an error.

What version of the product are you using?
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product

Please provide any additional information below.
We can bypass this problem with use of doublequotes like SELECT "RESOURCE" FROM 
PERMISSIONENTITY or use a different word.

Original issue reported on code.google.com by jbrechbu...@gmail.com on 8 Oct 2010 at 2:08

GoogleCodeExporter commented 9 years ago
This issue has been fixed in the development repository. The "resource" is a 
reserved keyword in oracle, the fix was to rename the database column to 
"perm_resource". This fix will be included in the next release, for now, you 
can take a clone of the dev repository and build the project as a jar and 
include it in your project.

Original comment by kimp...@gmail.com on 30 Oct 2010 at 1:03