INSERT INTO ID_TABLE VALUES(8,'JETSPEED_USER_PROFILE',120,10);
INSERT INTO ID_TABLE VALUES(9,'JETSPEED_GROUP_PROFILE',120,10);
INSERT INTO ID_TABLE VALUES(10,'JETSPEED_ROLE_PROFILE',120,10);
INSERT INTO ID_TABLE VALUES(11,'JETSPEED_ANON_PROFILE',120,10);
looks like I did this for Hypersonic, but not the other databases, sorry
bout that, I'll try to update the cvs tonight
----- Original Message -----
From: "Emmanuel Bardet" <[EMAIL PROTECTED]>
To: "Jetspeed Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 08, 2002 2:41 PM
Subject: Converting from PSML files to a PSML Database
> Hi all,
>
> Well guessed! I was not lucky on this one. From jetspeed.log file, I can
see
> the PSMLImporter starting, then loading
> ${webappRoot}\WEB-INF\psml\anon\html\default.psml (just a sec the "but" is
> coming) but from this point Oops...
>
> [Tue Jan 08 22:02:50 GMT 2002] -- INFO -- Forced id retrieval - no
available
> vector
> [Tue Jan 08 22:02:50 GMT 2002] -- DEBUG -- BasePeer.doUpdate:
> whereClause=TABLE_NAME='JETSPEED_ANON_PROFILE'
> [Tue Jan 08 22:02:50 GMT 2002] -- ERROR -- Error saving
> profile:BaseProfile[:{},null,null,anon,html,null,null,default.psml]
> [Tue Jan 08 22:02:50 GMT 2002] -- ERROR -- Error occurred in Database PSML
> Manager:
> Exception: org.apache.turbine.util.TurbineException: The table
> JETSPEED_ANON_PROFILE does not have a proper entry in the ID_TABLE
> Stack Trace follows:
> org.apache.turbine.util.TurbineException: The table JETSPEED_ANON_PROFILE
> does not have a proper entry in the ID_TABLE
> at org.apache.turbine.util.db.IDBroker.selectRow(IDBroker.java:723)
> at org.apache.turbine.util.db.IDBroker.storeIDs(IDBroker.java:571)
> at org.apache.turbine.util.db.IDBroker.getNextIds(IDBroker.java:380)
> at
org.apache.turbine.util.db.IDBroker.getIdAsBigDecimal(IDBroker.java:294)
> at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:776)
> at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:687)
> at
>
org.apache.jetspeed.om.dbpsml.BaseJetspeedAnonProfilePeer.doInsert(BaseJetsp
> eedAnonProfilePeer.java:111)
> at
>
org.apache.jetspeed.om.dbpsml.BaseJetspeedAnonProfilePeer.doInsert(BaseJetsp
> eedAnonProfilePeer.java:317)
> at
>
org.apache.jetspeed.om.dbpsml.JetspeedAnonProfilePeer.doInsertOrUpdate(Jetsp
> eedAnonProfilePeer.java:76)
> at
>
org.apache.jetspeed.om.dbpsml.JetspeedAnonProfilePeer.insert(JetspeedAnonPro
> filePeer.java:49)
> at
>
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat
> eOrSaveDocument(DatabasePsmlManagerService.java:580)
> at
>
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat
> eDocument(DatabasePsmlManagerService.java:504)
> at
>
org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService.export(Cas
> torPsmlManagerService.java:1145)
> at
>
org.apache.jetspeed.services.psmlmanager.PsmlImporter.run(PsmlImporter.java:
> 116)
>
> Well, Turbine is right there is no entry for this table in ID_TABLE ie
>
> +-------------+-------------------------+---------+----------+
> | ID_TABLE_ID | TABLE_NAME | NEXT_ID | QUANTITY |
> +-------------+-------------------------+---------+----------+
> | 1 | TURBINE_PERMISSION | 100 | 10 |
> | 2 | TURBINE_ROLE | 120 | 10 |
> | 3 | TURBINE_GROUP | 100 | 10 |
> | 4 | TURBINE_USER | 140 | 10 |
> | 5 | TURBINE_SCHEDULED_JOB | 100 | 10 |
> | 6 | TURBINE_ROLE_PERMISSION | 100 | 10 |
> | 7 | TURBINE_USER_GROUP_ROLE | 100 | 10 |
> +-------------+-------------------------+---------+----------+
>
> Would you be kind enough to send me the INSERT statements ?
>
> Info: Jetspeed 1.3a2, MySQL, W2K
>
> By the way, you Jetspeed people are tremendous.
>
> Thanks a lot.
>
> Emmanuel.
>
>
>
> --
> To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
