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]>
