> -----Original Message----- > From: Aurelien Pernoud [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 11, 2002 2:45 AM > To: 'Jetspeed Users List' > Subject: RE: Migrating from 1.4b1 to 1.4b2 : if you have trouble with > old database (users/profiles) > > > > Ok forget it, the new 1.4b2 is not using the create_id table > anymore, and I > can't create users from my old database, I always get a > constraint violation > on USER_ID... > > Does anyone know a simple way to migrate a db from 1.4b1 to > 1.4b2, and keep > users, profiles... ?
In 1.4b1, Hypersonic used the ID_TABLE to gen new ids. In 1.4b2, it uses the native method to gen new ids to be consistent with all databases supported by jetspeed. Hypersonic's native method is to use an auto-increment column. Unfortunately I don't have a good solution (yet). You will need to reseed Hypersonic's id generator to be of a higher value than the ids that are already in your system. I haven't figured out a way to do this short of writing Java code. For a quick fix, change your security-schema.xml back to using the ID_TABLE, add the new column, and regenerate. You must then add the new column to your hypersonic database in production by edition jetspeed.script. Finally, I don't think that the default Hypersonic DB is a good choice for a production system. It basically persists SQL statements to a text file, and stores the db in memory during runtime. Have you looked at MySQL? -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
