You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Tom Friday <Fr...@infogenic.net> on 2003/05/12 18:09:18 UTC

Psml in database?

Hi all,

I was trying to get jetspeed to use my database (postgres) rather than 
filesystem for PSML files.

I read and followed the instructions at: 
http://jakarta.apache.org/jetspeed/site/psml_db.html

However my "ant import" command would always tell me it imported 0 
profiles.

So I tried a fresh install of jetspeed 1.4b4, and left it configured to 
use Hypersonic.
All I did was change the Psml manager as described in the docs, assuming 
that the tables
and data were already present, as the docs suggested.  However, I still 
get this error when hitting the portal:


Error retrieving Portal Page: Profile not found. 
(I get this regardless of whether I'm logged in.)

Just for fun, I tried the import, (after setting the import classpath as 
described) and it
ran but said "0 profiles imported".

Maybe others have run into this also, as I'm assuming most people using 
Jetspeed in any real situation
would want PSML in the databaseinstead of on the filesystem.

Anyone have any ideas?  At this point I'm willing to just assume that Psml 
Database support
is broken in this version and wait til someone fixes it.. but if there's 
something I've overlooked
and can fix myself, that would be great.  Thanks for any advice you can 
give.



RE: Psml in database?

Posted by Mark Orciuch <ma...@ngsltd.com>.
I just tried switching castor to db psml manager in fresh Beta 4 .war file
and all looks good. By default, importing over populated dbpsml tables will
not overwrite them (there's a little comment about this in the build.xml).
I'm not sure what your problem is with Hypersonic.

As to your Ingres import problem, I would turn on Torque debugging in
tr.props to see what went wrong:

services.LoggingService.logforj.log4j.rootCategory = WARNING, logforj

Best regards,

Mark Orciuch - morciuch@apache.org
Jakarta Jetspeed - Enterprise Portal in Java
http://jakarta.apache.org/jetspeed/

> -----Original Message-----
> From: Tom Friday [mailto:Friday_Tom@infogenic.net]
> Sent: Monday, May 12, 2003 11:09 AM
> To: jetspeed-user@jakarta.apache.org
> Subject: Psml in database?
>
>
> Hi all,
>
> I was trying to get jetspeed to use my database (postgres) rather than
> filesystem for PSML files.
>
> I read and followed the instructions at:
> http://jakarta.apache.org/jetspeed/site/psml_db.html
>
> However my "ant import" command would always tell me it imported 0
> profiles.
>
> So I tried a fresh install of jetspeed 1.4b4, and left it configured to
> use Hypersonic.
> All I did was change the Psml manager as described in the docs, assuming
> that the tables
> and data were already present, as the docs suggested.  However, I still
> get this error when hitting the portal:
>
>
> Error retrieving Portal Page: Profile not found.
> (I get this regardless of whether I'm logged in.)
>
> Just for fun, I tried the import, (after setting the import classpath as
> described) and it
> ran but said "0 profiles imported".
>
> Maybe others have run into this also, as I'm assuming most people using
> Jetspeed in any real situation
> would want PSML in the databaseinstead of on the filesystem.
>
> Anyone have any ideas?  At this point I'm willing to just assume
> that Psml
> Database support
> is broken in this version and wait til someone fixes it.. but if there's
> something I've overlooked
> and can fix myself, that would be great.  Thanks for any advice you can
> give.
>
>
>



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


RE: Psml in database?

Posted by Rajesh Balu <ra...@cisco.com>.
I was having trouble initially in importing psml to oracle. PSML Importer
would say it imported 24 profiles but nothing would be actually imported.
Turning some debugging on and writing my own System.out.println statements,
I noticed that it was trying to use oracle sequence that did not exist for
psml_id. It was using the table name as the sequence name.


-----Original Message-----
From: Tom Friday [mailto:Friday_Tom@infogenic.net] 
Sent: Monday, May 12, 2003 9:09 AM
To: jetspeed-user@jakarta.apache.org
Subject: Psml in database?


Hi all,

I was trying to get jetspeed to use my database (postgres) rather than 
filesystem for PSML files.

I read and followed the instructions at: 
http://jakarta.apache.org/jetspeed/site/psml_db.html

However my "ant import" command would always tell me it imported 0 
profiles.

So I tried a fresh install of jetspeed 1.4b4, and left it configured to 
use Hypersonic.
All I did was change the Psml manager as described in the docs, assuming 
that the tables
and data were already present, as the docs suggested.  However, I still 
get this error when hitting the portal:


Error retrieving Portal Page: Profile not found. 
(I get this regardless of whether I'm logged in.)

Just for fun, I tried the import, (after setting the import classpath as 
described) and it
ran but said "0 profiles imported".

Maybe others have run into this also, as I'm assuming most people using 
Jetspeed in any real situation
would want PSML in the databaseinstead of on the filesystem.

Anyone have any ideas?  At this point I'm willing to just assume that Psml 
Database support
is broken in this version and wait til someone fixes it.. but if there's 
something I've overlooked
and can fix myself, that would be great.  Thanks for any advice you can 
give.




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