SQL Error in Service Builder generated class

[Michel Wicky, modificado 12 Anos atrás.]

I got an exception when executing a portlet developped using service builder to access the database.

The exception is trivial:
Caused by: java.sql.SQLException: ORA-00904: "SLRDOCUMEN0_"."SLR_DOC_TYP_SUB_TITLE" : identificateur non valide

The table name is wrong ! I don't know from where service builder took this name ... this is a mystery. I check the persistence implementation class and didn't find this reference to SLRDOCUMEN0_. Seem a bug to me !

Do somebody know something for such a problem ? Where to debug to find the error ?

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE service-builder PUBLIC "-//Liferay//DTD Service Builder 6.0.0//EN" "http://www.liferay.com/dtd/liferay-service-builder_6_0_0.dtd">
<service-builder package-path="slr.comment">
<author>Wite Partners Sàrl, Michel Wicky</author>
<namespace>slr</namespace>

<entity name="SlrDocumentTyp" table="SLR_DOCUMENT_TYP" local-service="true" data-source="slrDS" session-factory="slrSF" tx-manager="slrTX">

<!-- PK fields -->

<column name="SlrDocumentTypId" db-name="SLR_DOCUMENT_TYP_ID" type="long" primary="true" filter-primary="true" id-type="sequence" id-param="SLR_DOCUMENT_TYP_SEQ"/>

<!-- Fields -->

<column name="SlrDocTypLabel" db-name="SLR_DOC_TYP_LABEL" type="String" />
<column name="SlrDocTypMainTitle" db-name="SLR_DOC_TYP_MAIN_TITLE" type="String" />
<column name="SlrDocTypSubTitle" db-name="SLR_DOC_TYP_SUB_TITLE" type="String" />
<column name="SlrDocTypDesc" db-name="SLR_DOC_TYP_DESC" type="String" />

<column name="slrDocuments" type="Collection" entity="SlrDocument" mapping-key="SlrDocumentTypId" />

<!-- Order -->

<order by="asc">
<order-column name="SlrDocTypLabel" />
</order>

</entity>

<entity name="SlrDocument" table="SLR_DOCUMENT" local-service="true" data-source="slrDS" session-factory="slrSF" tx-manager="slrTX">

<!-- PK fields -->

<column name="SlrDocumentId" db-name="SLR_DOCUMENT_ID" type="long" primary="true" filter-primary="true" id-type="sequence" id-param="SLR_DOCUMENT_SEQ"/>

<!-- Fields -->

<column name="SlrDocumentTypId" db-name="SLR_DOCUMENT_TYP_ID" type="long" />
<column name="SlrDocumentDateFrom" db-name="SLR_DOCUMENT_DATE_FROM" type="Date" />
<column name="SlrDocumentDateTo" db-name="SLR_DOCUMENT_DATE_TO" type="Date" />
<column name="SlrDocumentPeriodLabel" db-name="SLR_DOCUMENT_PERIOD_LABEL" type="String" />

<column name="SlrDocumentStructures" type="Collection" entity="SlrDocumentStructure" mapping-key="SlrDocumentId" />
<column name="SlrComments" type="Collection" entity="SlrComment" mapping-key="SlrDocumentId" />

<!-- Order -->

<order by="desc">
<order-column name="SlrDocumentDateFrom" />
<order-column name="SlrDocumentDateTo" />
</order>

<!-- Finder methods -->

<finder name="DocumentTypId" return-type="Collection">
<finder-column name="SlrDocumentTypId" />
</finder>
</entity>

<entity name="SlrAnchor" table="SLR_ANCHOR" local-service="true" data-source="slrDS" session-factory="slrSF" tx-manager="slrTX">

<!-- PK fields -->

<column name="SlrAnchorId" db-name="SLR_ANCHOR_ID" type="long" primary="true" filter-primary="true" id-type="sequence" id-param="SLR_ANCHOR_SEQ"/>

<!-- Fields -->

<column name="SlrAnchorLabel" db-name="SLR_ANCHOR_LABEL" type="String" />
<column name="SlrAnchorHeader1" db-name="SLR_ANCHOR_HEADER1" type="String" />
<column name="SlrAnchorHeader2" db-name="SLR_ANCHOR_HEADER2" type="String" />
<column name="SlrAnchorText" db-name="SLR_ANCHOR_TEXT" type="String" />
<column name="SlrAnchorDesc" db-name="SLR_ANCHOR_DESC" type="String" />

<column name="SlrDocumentStructures" type="Collection" entity="SlrDocumentStructure" mapping-key="SlrAnchorId" />
<column name="SlrGraphs" type="Collection" entity="SlrGraph" mapping-key="SlrAnchorId" />

<!-- Order -->

<order by="asc">
<order-column name="SlrAnchorLabel" />
</order>

</entity>

<entity name="SlrDocumentStructure" table="SLR_DOCUMENT_STRUCTURE" local-service="true" data-source="slrDS" session-factory="slrSF" tx-manager="slrTX">

<!-- PK fields -->

<column name="SlrDocumentStructureId" db-name="SLR_DOCUMENT_STRUCTURE_ID" type="long" primary="true" filter-primary="true" id-type="sequence" id-param="SLR_DOCUMENT_STRUCTURE_SEQ"/>

<!-- Fields -->

<column name="SlrDocumentTypId" db-name="SLR_DOCUMENT_TYP_ID" type="long" />
<column name="SlrAnchorId" db-name="SLR_ANCHOR_ID" type="long" />

<column name="SlrAnchors" type="Collection" entity="SlrAnchor" mapping-key="SlrAnchorId" />

<!-- Order -->

<order by="asc">
<order-column name="SlrDocumentTypId" />
</order>

<!-- Finder methods -->

<finder name="AnchorId" return-type="Collection">
<finder-column name="SlrAnchorId" />
</finder>
</entity>

<entity name="SlrComment" table="SLR_COMMENT" local-service="true" data-source="slrDS" session-factory="slrSF" tx-manager="slrTX">

<!-- PK fields -->

<column name="SlrCommentId" db-name="SLR_COMMENT_ID" type="long" primary="true" filter-primary="true" id-type="sequence" id-param="SLR_COMMENT_SEQ"/>

<!-- Fields -->

<column name="SlrDocumentId" db-name="SLR_DOCUMENT_ID" type="long" />
<column name="SlrAnchorId" db-name="SLR_ANCHOR_ID" type="long" />
<column name="SlrCommentTyp" db-name="SLR_COMMENT_TYP" type="String" />
<column name="SlrCommentOrder" db-name="SLR_COMMENT_ORDER" type="int" />
<column name="SlrCommentStatus" db-name="SLR_COMMENT_STATUS" type="String" />
<column name="SlrCommentText" db-name="SLR_COMMENT_TEXT" type="String" />

<!-- Order -->

<order by="asc">
<order-column name="SlrDocumentId" />
<order-column name="SlrAnchorId" />
<order-column name="SlrCommentTyp" />
<order-column name="SlrCommentOrder" />
</order>

<!-- Finder methods -->

<finder name="DocumentIdAndAnchorId" return-type="Collection">
<finder-column name="SlrDocumentId" />
<finder-column name="SlrAnchorId" />
</finder>
</entity>

<entity name="SlrGraph" table="SLR_GRAPH" local-service="true" data-source="slrDS" session-factory="slrSF" tx-manager="slrTX">

<!-- PK fields -->

<column name="SlrGraphId" db-name="SLR_GRAPH_ID" type="long" primary="true" filter-primary="true" id-type="sequence" id-param="SLR_GRAPH_SEQ"/>

<!-- Fields -->

<column name="SlrAnchorId" db-name="SLR_ANCHOR_ID" type="long" />
<column name="JSReportUnitId" db-name="JS_REPORT_UNIT_ID" type="long" />

<!-- Order -->

<order by="asc">
<order-column name="SlrAnchorId" />
</order>

<!-- Finder methods -->

<finder name="AnchorId" return-type="Collection">
<finder-column name="SlrAnchorId" />
</finder>
</entity>
</service-builder>

[Michel Wicky, modificado 12 Anos atrás.]

See http://www.liferay.com/community/forums/-/message_boards/message/8818743