db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From torque-...@db.apache.org
Subject [DB Torque Wiki] Updated: FrequentlyAskedQuestions
Date Thu, 06 May 2004 17:58:42 GMT
   Date: 2004-05-06T10:58:42
   Editor: 213.78.116.250 <>
   Wiki: DB Torque Wiki
   Page: FrequentlyAskedQuestions
   URL: http://wiki.apache.org/db-torque/FrequentlyAskedQuestions

   no comment

Change Log:

------------------------------------------------------------------------------
@@ -293,3 +293,32 @@
 torque.defaults.pool.maxWait=10
 }}}
 Read the Jakarta Commons DBCP docs about DBCP configuration and adapt your torque properties
file accordingly.
+
+-- Tarlika Elisabeth Schmitz
+
+== Why does Torque generate invalid SQL for PostgeSQL BOOL columns? ==
+
+Torque generates invalid SQL for bool comparisons:
+generated "WHERE xyz=0", but it should be ''WHERE xyz=FALSE'' or "WHERE xyz='0'". 
+
+The fault is in the adapter class \org\apache\torque\adapter\DBPostgres.class:
+{{{
+public String getBooleanString(Boolean b)
+{
+    //was : return (b == null) ? "0" : (Boolean.TRUE.equals(b) ? "1" : "0");
+    return (b == null) ? "NULL" : (Boolean.TRUE.equals(b) ? "TRUE" : "FALSE");
+}
+}}}
+
+-- Tarlika Elisabeth Schmitz
+
+== Why does the generated SQL fail with PostgreSQL? ==
+
+The SQL generated for PostgreSQL using defaultIdMethod "native" causes a problem with PostGreSQL
7.2 or higher:
+
+For each autoIncrement primary key a CREATE SEQUENCE statement is generated followed by the
CREATE TABLE statement. The latter fails because this version of PostgreSQL automatically
creates a SEQUENCE for each serial column. The table will not be created if the SEQUENCE already
exists.
+
+Remove line 7 ''#if ($sequence.length()>0)$sequence#end'' from the template sql\base\postgresql\table.vm
+
+-- Tarlika Elisabeth Schmitz
+

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


Mime
View raw message