Re: PSML in database?

[tom friday <to...@yahoo.com>]

Please excuse me if this is sent more than once.
My mail system had trouble with it, and I wanted to
make sure it got out, so I'm using anotehr system.
--------------------------------------

Thanks to all who responded to this issue.

Today I tried again, and was mysteriously unable to
duplicate the 
problem I experienced previously.

After some experimentation, I discovered that I had
apparently NOT 
seen this problem under beta4 as I had thought.   I am
able to 
duplicate this only under beta3, not beta4, so
apparently it's 
something that's already fixed.

Now I am moving on to trying to import the
filesystem's PSML files 
into postgres.  To help eliminate problems due to my
particular app, 
I am working with the jetspeed sample app.

The importer is still reporting 0 profiles imported,
but I see some
things in the log file.  First a NullPointerException,
then a bunch
of ArrayIndexOutOfBoundExceptions.  No cause of these
was immediately obvious to me.  

As an experiment, I tried changing the id method from
"native"
to "idbroker" in dbpsml-schema.xml and using a
newly-created
database, but I got the same results. 

Here are some relevant bits from the jetspeed.log. 
Please pardon
the length, I didn't want to leave out anything
important:

[13 May 2003 15:49:22  WARN] -
DatabasePsmlManagerService.query: exception
java.lang.NullPointerException
        at
org.apache.torque.util.BasePeer.createQuery(BasePeer.java:1219)
        at
org.apache.torque.util.BasePeer.createQueryString(BasePeer.java:927)
        at
org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1351)
        at
org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer.doSelectVi
llageRecords(BaseJetspeedUserProfilePeer.java:393)
        at
org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer.doSelect(B
aseJetspeedUserProfilePeer.java:340)
        at
org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.selectOrdered(
JetspeedUserProfilePeer.java:181)
        at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerServi
ce.query(DatabasePsmlManagerService.java:784)
        at
org.apache.jetspeed.services.PsmlManager.query(PsmlManager.java:208)
        at
org.apache.jetspeed.services.psmlmanager.PsmlImporter.alreadyImporte
d(PsmlImporter.java:232)
        at
org.apache.jetspeed.services.psmlmanager.PsmlImporter.run(PsmlImport
er.java:190)
        at
org.apache.jetspeed.services.psmlmanager.PsmlImporter.main(PsmlImpor
ter.java:172)
[13 May 2003 15:49:22  INFO] - Running with Importer
Service: class org.apache.
jetspeed.services.psmlmanager.db.DatabasePsmlManagerService
[13 May 2003 15:49:22  INFO] - Running with Exporter
Service: class org.apache.
jetspeed.services.psmlmanager.CastorPsmlManagerService
[13 May 2003 15:49:22 DEBUG] - PSMLManager: calculated
resource:user/admin/html
/default.psml. Base: ./webapp/WEB-INF/psml File:
/home/tfriday/plainjs/webapp/W
EB-INF/psml/user/admin/html/default.psml
[13 May 2003 15:49:23  WARN] -
DatabasePsmlManagerService.createOrSaveDocument:
 profile: BaseProfile[user/admin/html/default.psml]
tableName: JETSPEED_USER_PR
OFILE
java.lang.ArrayIndexOutOfBoundsException
        at
org.apache.xerces.util.NamespaceSupport.popContext(NamespaceSupport.
java:218)
        at
org.apache.xml.serialize.XMLSerializer.endElementIO(XMLSerializer.ja
va:400)
        at
org.apache.xml.serialize.XMLSerializer.endElement(XMLSerializer.java
:387)
        at
org.apache.xml.serialize.XMLSerializer.endElement(XMLSerializer.java
:533)
        at
org.exolab.castor.xml.Marshaller.marshal(Marshaller.java:985)
        at
org.exolab.castor.xml.Marshaller.marshal(Marshaller.java:980)
        at
org.exolab.castor.xml.Marshaller.marshal(Marshaller.java:538)
        at
org.apache.jetspeed.services.psmlmanager.db.DBUtils.portletsToBytes(
DBUtils.java:147)
        at
org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.doInsertOrUpda
te(JetspeedUserProfilePeer.java:119)
        at
org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.insert(Jetspee
dUserProfilePeer.java:65)
        at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerServi
ce.createOrSaveDocument(DatabasePsmlManagerService.java:632)
        at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerServi
ce.createDocument(DatabasePsmlManagerService.java:592)
        at
org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService.ex
port(CastorPsmlManagerService.java:1226)
        at
org.apache.jetspeed.services.psmlmanager.PsmlImporter.run(PsmlImport
er.java:203)
        at
org.apache.jetspeed.services.psmlmanager.PsmlImporter.main(PsmlImpor
ter.java:172)

There are a bunch more
ArrayIndexOutOfBoundsExceptions, for 
each psml file it tried to import.  But they're all
basically the same, so 
I left  them out here.

I tried dropping the jetspeed_user_profile,
jetspeed_group_profile, 
and jetspeed_role_profile tables, just in case "ant
import" wanted to 
be able to create them itself, but got the same
results.

Any ideas or pointers are appreciated.


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

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