db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David_Solbach/MR/de/Dade...@dadebehring.com
Subject Antwort: Re: Foreign-Key Problem
Date Thu, 16 Oct 2003 10:31:19 GMT
uhm, which version of the TDK I shall use? this one: 
http://jakarta.apache.org/~mpoeschl/tdk-2.3-20030905.tar.gz?

or is ther a newer release? The TDK-Homepage is slightly confusing at this 
point.




Bitte antworten an "Apache Torque Users List" <torque-user@db.apache.org>
An:     Apache Torque Users List <torque-user@db.apache.org>
Kopie: 

Thema:  Re: Foreign-Key Problem


Your question would be best addressed on the turbine users mailing
list - turbine-user@jakarta.apache.org.  I see that you attempted
to cross post, but you got the domain name wrong (BTW: please don't
cross post :-)

The answer you seek can be found here:
http://jakarta.apache.org/turbine/turbine-2.3/howto/extend-user-howto.html
The content of this document relates to Turbine 2.2.  I strongly
recommend moving to Turbine 2.3 if at all possible since it is
much much easier to do this kind of thing.  The page for T2.3 is
http://jakarta.apache.org/turbine/turbine-2.3/services/torque-security-service.html
(the link near the top of extend-user-howto is fixed in cvs, but
waiting for the site to be republished).

Good luck.

Scott

--
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au



David_Solbach/MR/de/DadeInt@dadebehring.com wrote:

>Hi,
>
>I have the following Problem with my turbine-project (fcar):
>
>in <WEB-INF/conf/turbine-schema.xml> I have:
>
>---
><Database name=turbine>
>...
><table name="TURBINE_USER" idMethod="idbroker">
>    <column name="USER_ID" required="true" primaryKey="true"
>type="INTEGER"/>
>    <column name="LOGIN_NAME" required="true" size="32" type="VARCHAR"/>
>    <column name="PASSWORD_VALUE" required="true" size="32"
>type="VARCHAR"/>
>    <column name="FIRST_NAME" required="true" size="99" type="VARCHAR"/>
>    <column name="LAST_NAME" required="true" size="99" type="VARCHAR"/>
>    <column name="EMAIL" size="99" type="VARCHAR"/>
>    <column name="CONFIRM_VALUE" size="99" type="VARCHAR"/>
>    <column name="MODIFIED" type="TIMESTAMP"/>
>    <column name="CREATED" type="TIMESTAMP"/>
>    <column name="LAST_LOGIN" type="TIMESTAMP"/>
>    <column name="OBJECTDATA" type="VARBINARY"/>
>
>    <unique>
>        <unique-column name="LOGIN_NAME"/>
>    </unique>
>
></table>
>...
>----
>
>and in <fcar-schema.xml> :
>
>---
><database name="fcar">
>  <table name="FCAR_ADDRESS" idMethod="idbroker">
>    <column name="ADDRESS_ID" required="true" primaryKey="true"
>type="INTEGER"/>
>    <column name="USER_ID" required="true" type="INTEGER"/>
>    <column name="STREET" size="255" type="VARCHAR"/>
>    <column name="NR" type="INTEGER"/>
>    <column name="CITY" size="255" type="VARCHAR"/>
>    <column name="PLZ" type="INTEGER"/>
>
>   <foreign-key foreignTable="TURBINE_USER">
>      <reference local="USER_ID" foreign="USER_ID" />
>    </foreign-key>
>
>  </table>
></database>
>---
>
>ant init now tells me:
>
>---
>...
>sql-classpath:
>[torque-sql] Using contextProperties file:
>/opt/tdk-2.2/webapps/fcar/WEB-INF/build/build.properties
>[torque-sql] Using classpath
>[torque-sql] Generating to file
>/opt/tdk-2.2/webapps/fcar/WEB-INF/src/sql/report.fcar.sql.generation
>[torque-sql] Resolver: used database.dtd from
>org.apache.torque.engine.database.transform package
>[torque-sql] Resolver: used database.dtd from
>org.apache.torque.engine.database.transform package
>[torque-sql] Resolver: used database.dtd from
>org.apache.torque.engine.database.transform package
>!! --> [torque-sql] ERROR!! Attempt to set foreign key to nonexistent
>table, TURBINE_USER!
>
>BUILD FAILED
>file:/opt/tdk-2.2/webapps/fcar/WEB-INF/build/build-torque.xml:198:
>Generation failed. For more information consult the velocity log, or
>invoke ant with the -debug flag.
>...
>---
>
>Of course, it's another Database-name for Torque, but isn't that kind of
>cross referencing possible, or is there a good workaround? Because I'd
>very much like to use Turbine's user/permission management capabilities
>directly in my application, where I might have a lot of tables, that need
>FK's to entries in the turbine-tables.
>
>Thank you,
>
>David
>
>




---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org





---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message