'RE: Success... Re: Converting from PSML files to a PSML Database'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jetspeed-user
Subject:    RE: Success... Re: Converting from PSML files to a PSML Database
From:       "Emmanuel Bardet" <emmanuel () bardet ! org>
Date:       2002-01-25 9:38:49
[Download RAW message or body]

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:fth4mura@yahoo.com]
> 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" <fth4mura@yahoo.com>
> To: "Jetspeed Users List" <jetspeed-user@jakarta.apache.org>
> 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" <david@bluesunrise.com>
> > To: "Jetspeed Users List" <jetspeed-user@jakarta.apache.org>
> > 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" <emmanuel@bardet.org>
> > > To: "Jetspeed Users List" <jetspeed-user@jakarta.apache.org>
> > > 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:emmanuel@bardet.org]
> > > > 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:emmanuel@bardet.org]
> > > > 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:david@bluesunrise.com]
> > > > 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" <emmanuel@bardet.org>
> > > > To: "Jetspeed Users List" <jetspeed-user@jakarta.apache.org>
> > > > 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:jetspeed-user-unsubscribe@jakarta.apache.org>
> > > > > For additional commands, e-mail:
> > > > <mailto:jetspeed-user-help@jakarta.apache.org>
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > To unsubscribe, e-mail:
> > > > <mailto:jetspeed-user-unsubscribe@jakarta.apache.org>
> > > > For additional commands, e-mail:
> > > > <mailto:jetspeed-user-help@jakarta.apache.org>
> > > >
> > > >
> > > > --
> > > > To unsubscribe, e-mail:
> > > > <mailto:jetspeed-user-unsubscribe@jakarta.apache.org>
> > > > For additional commands, e-mail:
> > > > <mailto:jetspeed-user-help@jakarta.apache.org>
> > > >
> > > >
> > > > --
> > > > To unsubscribe, e-mail:
> > > > <mailto:jetspeed-user-unsubscribe@jakarta.apache.org>
> > > > For additional commands, e-mail:
> > > > <mailto:jetspeed-user-help@jakarta.apache.org>
> > > >
> > > >
> > > > --
> > > > To unsubscribe, e-mail:
> > > <mailto:jetspeed-user-unsubscribe@jakarta.apache.org>
> > > > For additional commands, e-mail:
> > > <mailto:jetspeed-user-help@jakarta.apache.org>
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> > <mailto:jetspeed-user-unsubscribe@jakarta.apache.org>
> > > For additional commands, e-mail:
> > <mailto:jetspeed-user-help@jakarta.apache.org>
> > >
> >
> >
> > _________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.com address at http://mail.yahoo.com
> >
> >
> > --
> > To unsubscribe, e-mail:
> <mailto:jetspeed-user-unsubscribe@jakarta.apache.org>
> > For additional commands, e-mail:
> <mailto:jetspeed-user-help@jakarta.apache.org>
> >
>
>  _________________________________________________________ Do You
> Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
> --
> To unsubscribe, e-mail:
<mailto:jetspeed-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail:
<mailto:jetspeed-user-help@jakarta.apache.org>


--
To unsubscribe, e-mail:   <mailto:jetspeed-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-user-help@jakarta.apache.org>

[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic