"Folkens, Brad" <[EMAIL PROTECTED]> writes:
Hi,
thanks for testing out. I will add the firstname patch; this has
slipped somehow and PostgreSQL and MySQL don't seem to mind.
I remember adding the size="0" to the schema because of some
compatibility issue with PostgreSQL. I will have to look into this.
I have no current access to an Oracle DB (too lazy to download the 100+ MB
from the OTA).
Regards
Henning
>------_=_NextPart_001_01C46F28.12EDB600
>Content-Type: text/plain
>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]
>------_=_NextPart_001_01C46F28.12EDB600--
--
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen INTERMETA GmbH
[EMAIL PROTECTED] +49 9131 50 654 0 http://www.intermeta.de/
RedHat Certified Engineer -- Jakarta Turbine Development -- hero for hire
Linux, Java, perl, Solaris -- Consulting, Training, Development
"Fighting for one's political stand is an honorable action, but re-
fusing to acknowledge that there might be weaknesses in one's
position - in order to identify them so that they can be remedied -
is a large enough problem with the Open Source movement that it
deserves to be on this list of the top five problems."
-- Michelle Levesque, "Fundamental Issues with
Open Source Software Development"
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
