SPAGOBI-718 - Postgre SQL. Error in catalog double quotes

[KnowageServiceAcc]

Details

Key	Value
Key	SPAGOBI-718
Type	Bug
Status	Open
Priority	Major
Resolution
Affects	3.0 Alpha, 3.0.0, 3.2.0, 3.3.0
Fix	3.4.0
Components	META
Labels	jpa_generator

People

Key	Value
Assignee	Andrea Gioia
Reporter	Alberto Ghedin

Dates

Key	Value
Created	2012-01-16T11:14:25.000+0100
Updated	2013-12-02T15:01:55.000+0100
Resolved	n.d.

Description

When the JPA provider (Hibernate in this case) builds the SQL query, it doesnt't transform the quote ` in the correct db dependent quote.

The attached patch resolve the problem when the catalog is a lower case string.

To apply the patch you should:

1. unzip the file plugins.zip (after the unzip process you should have a folder plugins with a jar file inside)
2. open the folder SpagoBIStudioxxx/
3. copy the unzipped folder in the folder SpagoBIStudioxxx

Comments

Andrea Gioia added a comment - 2012-03-28T16:51:51.013+0200

In order to force Hibernate to quote an identifier in the generated SQL it is necessary to enclose the identifier name (catalog, schema, table o column) in backticks in the annotation. For more info see...

http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html/mapping.html#mapping-quotedidentifiers

The previous attached patch (i.e. plugin.zip) modifies the JPA generator plugin in order to enclose the name of all identifiers used in annotations with backticks. Unfortunately this patch does not work for catalog identifier because of a known bug of hibernate not yet solved in any version...

https://hibernate.onjira.com/browse/HHH-7195

To solve the problem we have fixed by ourself the hibernate lib adding a couple methods to class...

org.hibernate.mapping

we will release the patched version together with spagobi-qbe-core.jar starting from version 3.4.0