[
https://issues.apache.org/jira/browse/TORQUE-369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Max Philipp Wriedt updated TORQUE-369:
--------------------------------------
Description:
When referencing an external schema (to use foreign key references in another
schema definition) and back referencing to its origin, we get an infinite
recursion.
Example:
First Schema:
{code:java}
<?xml version="1.0" encoding="UTF-8" ?>
<database>
<external-schema filename=secondary-schema.xml" />
<table name="test" javaName="Test">
<column name="Id" javaName="Id" required="true" type="INTEGER"
primaryKey="true"/>
<column name="Name" javaName="Name" required="true" type="VARCHAR"
size="5"/>
<column name="foreign-key" javaName="ForeignKey" required="true"
type="INTEGER" size="2"/>
<!-- define foreign key to secondary scheme!-->
</table>
</database>{code}
Second Schema:
{code:java}
<?xml version="1.0" encoding="UTF-8" ?>
<database
xmlns="http://db.apache.org/torque/5.0/templates/database";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://db.apache.org/torque/5.0/templates/database
https://db.apache.org/torque/torque-5.0/documentation/orm-reference/database-5-0-strict.xsd";
name="test" defaultIdMethod="native" defaultJavaType="object">
<external-schema filename=first-schema.xml" />
<table name="foreign-key" javaName="Test">
<column name="Id" javaName="Id" required="true" type="INTEGER"
primaryKey="true"/>
<column name="Name" javaName="Name" required="true" type="VARCHAR"
size="5"/>
</table>
<table name="test2" javaName="Test2">
<column name="Id" javaName="Id" required="true" type="INTEGER"
primaryKey="true"/>
<column name="Name" javaName="Name" required="true" type="VARCHAR"
size="5"/>
<column name="foreign-key" javaName="ForeignKey" required="true"
type="INTEGER" size="2"/>
<!-- define foreign key to first scheme!-->
</table>
</database>{code}
> LoadExternalSchemaTransformer recursively includes when cross-referencing
> -------------------------------------------------------------------------
>
> Key: TORQUE-369
> URL: https://issues.apache.org/jira/browse/TORQUE-369
> Project: Torque
> Issue Type: Improvement
> Reporter: Max Philipp Wriedt
> Priority: Major
>
> When referencing an external schema (to use foreign key references in another
> schema definition) and back referencing to its origin, we get an infinite
> recursion.
>
> Example:
> First Schema:
> {code:java}
> <?xml version="1.0" encoding="UTF-8" ?>
> <database>
> <external-schema filename=secondary-schema.xml" />
> <table name="test" javaName="Test">
> <column name="Id" javaName="Id" required="true" type="INTEGER"
> primaryKey="true"/>
> <column name="Name" javaName="Name" required="true" type="VARCHAR"
> size="5"/>
> <column name="foreign-key" javaName="ForeignKey" required="true"
> type="INTEGER" size="2"/>
> <!-- define foreign key to secondary scheme!-->
> </table>
> </database>{code}
> Second Schema:
> {code:java}
> <?xml version="1.0" encoding="UTF-8" ?>
> <database
> xmlns="http://db.apache.org/torque/5.0/templates/database";
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
> xsi:schemaLocation="http://db.apache.org/torque/5.0/templates/database
>
> https://db.apache.org/torque/torque-5.0/documentation/orm-reference/database-5-0-strict.xsd";
> name="test" defaultIdMethod="native" defaultJavaType="object">
> <external-schema filename=first-schema.xml" />
> <table name="foreign-key" javaName="Test">
> <column name="Id" javaName="Id" required="true" type="INTEGER"
> primaryKey="true"/>
> <column name="Name" javaName="Name" required="true" type="VARCHAR"
> size="5"/>
> </table>
> <table name="test2" javaName="Test2">
> <column name="Id" javaName="Id" required="true" type="INTEGER"
> primaryKey="true"/>
> <column name="Name" javaName="Name" required="true" type="VARCHAR"
> size="5"/>
> <column name="foreign-key" javaName="ForeignKey" required="true"
> type="INTEGER" size="2"/>
> <!-- define foreign key to first scheme!-->
> </table>
> </database>{code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscr...@db.apache.org
For additional commands, e-mail: torque-dev-h...@db.apache.org
