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.psmlmanager.Cas > torPsmlManagerService > services.PsmlImportManager.classname=org.apache.jetspeed.services.psmlmanage > r.CastorPsmlManagerService > services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.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.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]> > > > > > > > > > -- > > > 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]>
