You should look at extending the user. This makes it possible to use the User object as a foreign key in your application tables.
Jeffery Painter On Thu, 16 Oct 2003 David_Solbach/MR/de/[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
