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:08:25 GMT
Hi Scott,

Thanks. I think I'll witch to TDK 2.3 then first. I'm just trying to get 
into the whole issue, the real development hasn't startet yet. Think 
that's the solution for my problem.

Btw: I hope my posts aren't messed up too much. (I have to use IBM Notes 
as a mail-client here, told it to only send plain text, but I don't think 
it really works. You know notes? ... better for you, if you don't! ;)

David





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