You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by to...@db.apache.org on 2004/04/15 22:20:36 UTC

[DB Torque Wiki] Updated: HarderTorqueFaq

   Date: 2004-04-15T13:20:32
   Editor: 217.85.255.245 <>
   Wiki: DB Torque Wiki
   Page: HarderTorqueFaq
   URL: http://wiki.apache.org/db-torque/HarderTorqueFaq

   no comment

Change Log:

------------------------------------------------------------------------------
@@ -3,7 +3,7 @@
 == How can I create DB-Schemes where Tables contain a Primary-Key with more than one column? ==
 
 For Example:
-[[[<?xml version="1.0" encoding="UTF-8"?>
+{{{<?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE database SYSTEM "D:\JAVA\database_3_1.dtd">
 <database defaultIdMethod="native" name="survey_db">
 	<table name="survey_system">
@@ -23,6 +23,11 @@
 			<reference local="systemid" foreign="systemid"/>
 		</foreign-key>
 	</table>
-</database>]]]
+...
+...
+...
+</database>}}}
 
-If try to insert a Survey you will get an Error. So... What to do?!?
+If you try to insert a "Survey" you will get an Error. Or isn't it allowed to use multi-column-Primary-Keys?!? After debugging the Torque-Source-Code (I still have a head-ache :-) ) I found out, that the PK-Engine only looks for the first column with the PK-Attribute. If i'm right, I had to completely restructure my database-design to have only ONE column as Primary-Key.
+
+Any Ideas or Comments?!?

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