Dear all,
I partially fixed it by running MySQL in strict mode and setting
jdbcCompliantTruncation to false.
Any comment anyway?
Thanks
S
----- Original Message -----
From: "Stefano Bianchi" <[EMAIL PROTECTED]>
To: "JETSPEED Users List" <[email protected]>
Sent: Wednesday, January 10, 2007 1:10 PM
Subject: Moving J1.6 db from MySQL 3.1 to MySQL 5.0
Dear ALL,
I am trying to move an old J1.6 installation to a new host and I am
getting problems with db.
After exporting and reimporting with SQLYog the jetspeed db from MySQL 3.1
to MySQL 5.0 I get something like:
There has been an error!
org.apache.jetspeed.services.security.UserException: Failed to save
user object : Data truncation: Data too long for column 'OBJECTDATA' at
row 1
and also
org.apache.jetspeed.services.security.UserException: Failed to retrieve
user 'euoexp1': Cannot convert value '0000-00-00 00:00:00' from column 9
to TIMESTAMP
I have checked and the contents in the db tables look different, e.g.
OBJECDATA changes and timestamp are stored differently...
Maybe it is just a MySQL issue (sorry), but has anyone successfully moved
db between such different MySQL version?
Any suggestion?
And as I am going to work on a new project, would a blank new installation
for J1.6 work on MySQL 5.0?
Thanks
S
Ing. Stefano Bianchi
Softeco Sismat S.p.A. - www.softeco.it
Via De Marini 1, WTC Tower
16149 GENOA (ITALY)
Tel. +39 010 6026 368
Fax +39 010 6026 350
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
