Don't know if anyone can replicate it, but I was having some problems
getting the META plugin to run smoothly while using an Oracle database.
Simple fix though, I just needed to take out the explicit size="0" in the
date fields in TURBINE_USER.  The only other thing I noticed with Oracle is
that it enforces the NOT NULL clause as well, so the FIRST_NAME fields
needed to be filled in.

Attached are the patches (I've got Oracle to test this on, so I haven't
tested it with anything else yet, but last time I checked mysql is happy
without sizes on the ends of DATE datatypes too, so it should work ok)...



Index: turbine-security-data.xml 
=================================================================== 
RCS file:
/home/cvspublic/jakarta-turbine-2/extensions/maven-plugin/src/plugin-resourc
es/om-layer/torque/schema/Attic/turbine-security-data.xml,v

retrieving revision 1.1.2.1 
diff -u -r1.1.2.1 turbine-security-data.xml 
--- turbine-security-data.xml   4 Jul 2004 20:00:22 -0000       1.1.2.1 
+++ turbine-security-data.xml   14 Jul 2004 18:21:11 -0000 
@@ -32,13 +32,13 @@ 
   <TurbineUser UserId="1" 
                UserName="admin" 
                Password="password" 
-               FirstName="" 
+               FirstName="Admin" 
                LastName="Admin"/> 
  
   <TurbineUser UserId="2" 
                UserName="user" 
                Password="password" 
-               FirstName="" 
+               FirstName="User" 
                LastName="User"/> 
  
   <!-- Turbine Permissions --> 




Index: turbine-security-schema.xml 
=================================================================== 
RCS file:
/home/cvspublic/jakarta-turbine-2/extensions/maven-plugin/src/plugin-resourc
es/om-layer/torque/schema/Attic/turbine-security-schema.xml,v

retrieving revision 1.1.2.1 
diff -u -r1.1.2.1 turbine-security-schema.xml 
--- turbine-security-schema.xml 4 Jul 2004 20:00:22 -0000       1.1.2.1 
+++ turbine-security-schema.xml 14 Jul 2004 18:25:05 -0000 
@@ -41,9 +41,9 @@ 
     <column name="LAST_NAME" required="true" size="64" type="VARCHAR"/> 
     <column name="EMAIL" size="64" type="VARCHAR"/> 
     <column name="CONFIRM_VALUE" size="16" type="VARCHAR"
javaName="Confirmed"/> 
-    <column name="MODIFIED" type="TIMESTAMP" size="0"/> 
-    <column name="CREATED" type="TIMESTAMP" size="0"
javaName="CreateDate"/> 
-    <column name="LAST_LOGIN" type="TIMESTAMP" size="0"/> 
+    <column name="MODIFIED" type="TIMESTAMP"/> 
+    <column name="CREATED" type="TIMESTAMP" javaName="CreateDate"/> 
+    <column name="LAST_LOGIN" type="TIMESTAMP"/> 
     <column name="OBJECTDATA" type="VARBINARY"/> 
  
     <unique> 




Hope this helps. 

Bradford A. Folkens 
[EMAIL PROTECTED] 

Reply via email to