I guess the message disappear because once the PSML files are imported in your database, you're done. Thereafter, every time you restart your server, you should get a message telling you there's nothing to import unless you have created a new psml file in the meantime. When your files are imported in your db, you can comment out the import service.
> -----Original Message----- > From: Frans Thamura [mailto:[EMAIL PROTECTED]] > Sent: vendredi 25 janvier 2002 08:19 > To: Jetspeed Users List > Subject: Success... Re: Converting from PSML files to a PSML Database > > > Hi all, > > I think if you want to convert your psml to PSML database,, > > you must see this in your console > > Starting service Tomcat-Standalone > Apache Tomcat/4.0.1 > data instanceof ServletConfig > Running PSMLImporter... > PSMLImporter completed. Exported 19 profiles > Starting service Tomcat-Apache > Apache Tomcat/4.0.1 > > If you shutdown and restart , those messages still disappear, mean you > jetspeed is still using PSML XML. > > cheers. > > Frans > > ----- Original Message ----- > From: "Frans Thamura" <[EMAIL PROTECTED]> > To: "Jetspeed Users List" <[EMAIL PROTECTED]> > Sent: Friday, January 25, 2002 2:45 AM > Subject: Re: Converting from PSML files to a PSML Database > > > > Hi All, > > > > I were not follow the db_psml documentation, because it is use Oracle, > > > > I want to test it in Hypersonic.. to used dbPSML > > > > I just move the PSMLManager service in JSP become like this > > > #services.PsmlManager.classname=org.apache.jetspeed.services.psmlm > anager.Cas > > torPsmlManagerService > > > services.PsmlImportManager.classname=org.apache.jetspeed.services. > psmlmanage > > r.CastorPsmlManagerService > > > services.PsmlManager.classname=org.apache.jetspeed.services.psmlma > nager.db.D > > atabasePsmlManagerService > > > > i think this is the correct way, right. > > > > I try to run the ManageDb.bat from > C:\tomcat4\webapps\jetspeed\WEB-INF\db > > > > and see there is a JETSPEED_USER_PROFILE, JETSPEED_GROUP_PROFILE, > > JETSPEED_ROLE_PROFILE, JETSPEED_ANON_PROFILE which this file is exactly > same > > with the dbpsml-schema.sql from torque directory, which i have generated > it > > using ant...this steps are clear and correct, i think... ;) > > > > Afterthat, i run the tomcat (I used tomcat 4.01), and run the jetspeed > like > > usually (http://localhost:8080/jetspeed) > > > > and wow, the Jetspeed run, and there is a 1.3a3-dev.. and run well.. > > > > and, i try to register new user, and wow several question show: > > > > 1. how can the jetspeed still create a psml files in psml directory. > > 2. and no action has done to create a record in hypersonic table. this > mean > > the services is not working > > 3. what is the steps that i can debug or know something that the db psml > > services is running.. > > > > Oke thanks ALl > > > > Frans > > ----- Original Message ----- > > From: "David Sean Taylor" <[EMAIL PROTECTED]> > > To: "Jetspeed Users List" <[EMAIL PROTECTED]> > > Sent: Thursday, January 10, 2002 11:57 PM > > Subject: Re: Converting from PSML files to a PSML Database > > > > > > > Im looking at the code now - om/dbpsml/JetspeedUserProfilePeer.java, > line > > > 158. > > > It would appear that its an easy fix, but the problem is that > this same > > code > > > is in two different cases: > > > > > > 1. public PSMLDocument getDocument(ProfileLocator locator) > > > 2. public Iterator query(QueryLocator locator) > > > > > > In the first case, it would be OK to set the language to NULL, but not > in > > > the second. > > > > > > ----- Original Message ----- > > > From: "Emmanuel Bardet" <[EMAIL PROTECTED]> > > > To: "Jetspeed Users List" <[EMAIL PROTECTED]> > > > Sent: Thursday, January 10, 2002 1:51 AM > > > Subject: RE: Converting from PSML files to a PSML Database > > > > > > > > > > Gents, > > > > > > > > I know this is a boring thread but hey I guess it references a bug. > > Shall > > > I > > > > raise it on Bugzilla or dig the source code myself ? > > > > > > > > Rgds, > > > > > > > > Emmanuel. > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: Emmanuel Bardet [mailto:[EMAIL PROTECTED]] > > > > Sent: mercredi 9 janvier 2002 14:01 > > > > To: Jetspeed Users List > > > > Subject: RE: Converting from PSML files to a PSML Database > > > > > > > > > > > > As the French nor the German entries exist in the table, Jetspeed > tries > > to > > > > load an entry regardless of the language. > > > > > > > > SELECT JETSPEED_ANON_PROFILE.PSML_ID, > JETSPEED_ANON_PROFILE.MEDIA_TYPE, > > > > JETSPEED_ANON_PROFILE.LANGUAGE, JETSPEED_ANON_PROFILE.COUNTRY, > > > > JETSPEED_ANON_PROFILE.PAGE, JETSPEED_ANON_PROFILE.PROFILE FROM > > > > JETSPEED_ANON_PROFILE WHERE > (JETSPEED_ANON_PROFILE.MEDIA_TYPE='html') > > AND > > > > (JETSPEED_ANON_PROFILE.PAGE='default.psml') > > > > > > > > This returns 3 entries: the default, the English and the Spanish. > > > > > > > > +---------+------------+----------+---------+--------------+- > > > > | PSML_ID | MEDIA_TYPE | LANGUAGE | COUNTRY | PAGE | > > > > +---------+------------+----------+---------+--------------+- > > > > | 120 | html | NULL | NULL | default.psml | > > PROFILES... > > > > | 121 | html | en | NULL | default.psml | > > > > | 123 | html | es | NULL | default.psml | > > > > +---------+------------+----------+---------+--------------+- > > > > > > > > Jetspeed seems to take the last returned ie the Spanish > which is why I > > get > > > > the tabs in Spanish. Jetspeed should query for the default: > > > > > > > > SELECT JETSPEED_ANON_PROFILE.PSML_ID, > JETSPEED_ANON_PROFILE.MEDIA_TYPE, > > > > JETSPEED_ANON_PROFILE.LANGUAGE, JETSPEED_ANON_PROFILE.COUNTRY, > > > > JETSPEED_ANON_PROFILE.PAGE, JETSPEED_ANON_PROFILE.PROFILE FROM > > > > JETSPEED_ANON_PROFILE WHERE > (JETSPEED_ANON_PROFILE.MEDIA_TYPE='html') > > AND > > > > (JETSPEED_ANON_PROFILE.PAGE='default.psml') AND > > > > (JETSPEED_ANON_PROFILE.LANGUAGE IS NULL) > > > > > > > > In order to get: > > > > > > > > +---------+------------+----------+---------+--------------+- > > > > | PSML_ID | MEDIA_TYPE | LANGUAGE | COUNTRY | PAGE | PROFILE > > > > +---------+------------+----------+---------+--------------+- > > > > | 120 | html | NULL | NULL | default.psml | > > > > +---------+------------+----------+---------+--------------+- > > > > > > > > It's really cosmetic and not high priority however I wouldn't mind a > > fix. > > > In > > > > the meantime, I'll create my local version. > > > > > > > > Thanks for your great efforts. > > > > > > > > Emmanuel. > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: Emmanuel Bardet [mailto:[EMAIL PROTECTED]] > > > > Sent: mercredi 9 janvier 2002 11:29 > > > > To: Jetspeed Users List > > > > Subject: RE: Converting from PSML files to a PSML Database > > > > > > > > > > > > Thanks David. > > > > > > > > > > > > It works fine except that I did not expect anonymous users to have > their > > > > tabs in Spanish (i.e. P�gina de Inicio, RSS, Din�micos) if the > language > > is > > > > either French or German. > > > > > > > > Can anybody help ? > > > > > > > > Thanks. > > > > > > > > Emmanuel > > > > -----Original Message----- > > > > From: David Sean Taylor [mailto:[EMAIL PROTECTED]] > > > > Sent: mardi 8 janvier 2002 23:04 > > > > To: Jetspeed Users List > > > > Subject: Re: Converting from PSML files to a PSML Database > > > > > > > > > > > > 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.doInsertOrUp > date(Jetsp > > > > > eedAnonProfilePeer.java:76) > > > > > at > > > > > > > > > > > > > > > org.apache.jetspeed.om.dbpsml.JetspeedAnonProfilePeer.insert(Jetsp > eedAnonPro > > > > > filePeer.java:49) > > > > > at > > > > > > > > > > > > > > > org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerSer > vice.creat > > > > > eOrSaveDocument(DatabasePsmlManagerService.java:580) > > > > > at > > > > > > > > > > > > > > > org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerSer > vice.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(PsmlImpo > rter.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]> > > > > > > > > > > > > -- > > > > 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]> > > > > > > > > > > > > -- > > > > 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]> > > > > > > > > > _________________________________________________________ > > Do You Yahoo!? > > Get your free @yahoo.com address at http://mail.yahoo.com > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > > _________________________________________________________ Do You > Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com > -- > 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]>
