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 Noah <no...@visionsolutions.com> on 2011/07/28 15:14:44 UTC
Storing PSML in a derby database
I am wondering if it is possible to save PSML files inside a derby database as
opposed to a DB2, MSSQL, MySql, PostgreSQL, Oracle, or SapDB database. I want
to be able to use templates for folder/pages/etc when storing the PSML in the
derby database.
Thanks,
Noah
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: Storing PSML in a derby database
Posted by Noah <no...@visionsolutions.com>.
Randy Watler <watler <at> wispertel.net> writes:
>
> Okay, let me know if you cannot make the portal site admin solution work.
>
> Randy
>
> On 7/28/2011 11:23 AM, Noah wrote:
> > Randy Watler<watler<at> wispertel.net> writes:
> >
> >> IIRC, PSML import/export fro Derby can be done using the portal site
> >> admin portlets.
> >>
> >> Of course, this is not an offline ETL based process. I also suspect that
> >> it does not have the ability to convert between Jetspeed versions.
> >>
> >> Noah, can you describe the situation in which you are attempting to
> >> import/export PSML?
> >>
> >> Randy
Randy,
Thank you again for all your help. I was able to log in as the admin on the
jetspeed sample, and navigate Import/Export Service tab. The Import/Export
portlet only allows for xml files to be uploaded. However, I was able to export
psml files from the Portal Site Manager tab. From here, I navigated to
Administrative/site.psml, and successfully exported it, and was able to see it
appear in my Jetspeed-2.1.4\temp\admin directory. However, I don't think I am
able to import this psml file, just export it.
To reiterate my situation, I have access to only a derby database, and I want to
be able to load psml files from it rather than use my page manger using a local
filesystem. I am aware that psml files can be stored in other databases, but is
it possible to store the psml in a derby database for the jetspeed sample?
Perhaps I am overlooking something?
Thanks,
Noah
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: Storing PSML in a derby database
Posted by Randy Watler <wa...@wispertel.net>.
Okay, let me know if you cannot make the portal site admin solution work.
Randy
On 7/28/2011 11:23 AM, Noah wrote:
> Randy Watler<watler<at> wispertel.net> writes:
>
>> IIRC, PSML import/export fro Derby can be done using the portal site
>> admin portlets.
>>
>> Of course, this is not an offline ETL based process. I also suspect that
>> it does not have the ability to convert between Jetspeed versions.
>>
>> Noah, can you describe the situation in which you are attempting to
>> import/export PSML?
>>
>> Randy
>
>
>
> Randy,
>
> I am trying to transfer the psml files from a current jetspeed
> installation using a folder based page manager to a derby database.
>
> -Noah
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: Storing PSML in a derby database
Posted by Noah <no...@visionsolutions.com>.
Randy Watler <watler <at> wispertel.net> writes:
>
> IIRC, PSML import/export fro Derby can be done using the portal site
> admin portlets.
>
> Of course, this is not an offline ETL based process. I also suspect that
> it does not have the ability to convert between Jetspeed versions.
>
> Noah, can you describe the situation in which you are attempting to
> import/export PSML?
>
> Randy
Randy,
I am trying to transfer the psml files from a current jetspeed
installation using a folder based page manager to a derby database.
-Noah
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: Storing PSML in a derby database
Posted by Randy Watler <wa...@wispertel.net>.
IIRC, PSML import/export fro Derby can be done using the portal site
admin portlets.
Of course, this is not an offline ETL based process. I also suspect that
it does not have the ability to convert between Jetspeed versions.
Noah, can you describe the situation in which you are attempting to
import/export PSML?
Randy
On 7/28/2011 7:54 AM, Jeff Pierce wrote:
> I believe Noah may be confused based on the documentation found here:
>
> http://portals.apache.org/jetspeed-2.1.3/guide-etl-migration.html
>
> It states that Derby is not a supported database when selecting a
> database in the "Importing a Jetspeed database" section.
>
> When using a Derby database what is the recommended way to migrate
> your page/folder structure from the file system to the database?
>
> On Thu, Jul 28, 2011 at 8:45 AM, Randy Watler<wa...@wispertel.net> wrote:
>> Noah,
>>
>> Yes, Derby is one of the supported configurations. See the website for RDBMS
>> configuration instructions.
>>
>> As far as the templates go, they too would reside in the Derby database.
>>
>> HTH,
>>
>> Randy
>>
>> On 7/28/2011 7:14 AM, Noah wrote:
>>> I am wondering if it is possible to save PSML files inside a derby
>>> database as
>>> opposed to a DB2, MSSQL, MySql, PostgreSQL, Oracle, or SapDB database. I
>>> want
>>> to be able to use templates for folder/pages/etc when storing the PSML in
>>> the
>>> derby database.
>>>
>>> Thanks,
>>> Noah
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>>> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>>>
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>>
>>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: Storing PSML in a derby database
Posted by Jeff Pierce <ha...@gmail.com>.
I believe Noah may be confused based on the documentation found here:
http://portals.apache.org/jetspeed-2.1.3/guide-etl-migration.html
It states that Derby is not a supported database when selecting a
database in the "Importing a Jetspeed database" section.
When using a Derby database what is the recommended way to migrate
your page/folder structure from the file system to the database?
On Thu, Jul 28, 2011 at 8:45 AM, Randy Watler <wa...@wispertel.net> wrote:
> Noah,
>
> Yes, Derby is one of the supported configurations. See the website for RDBMS
> configuration instructions.
>
> As far as the templates go, they too would reside in the Derby database.
>
> HTH,
>
> Randy
>
> On 7/28/2011 7:14 AM, Noah wrote:
>>
>> I am wondering if it is possible to save PSML files inside a derby
>> database as
>> opposed to a DB2, MSSQL, MySql, PostgreSQL, Oracle, or SapDB database. I
>> want
>> to be able to use templates for folder/pages/etc when storing the PSML in
>> the
>> derby database.
>>
>> Thanks,
>> Noah
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: Storing PSML in a derby database
Posted by Randy Watler <wa...@wispertel.net>.
Noah,
Yes, Derby is one of the supported configurations. See the website for
RDBMS configuration instructions.
As far as the templates go, they too would reside in the Derby database.
HTH,
Randy
On 7/28/2011 7:14 AM, Noah wrote:
> I am wondering if it is possible to save PSML files inside a derby database as
> opposed to a DB2, MSSQL, MySql, PostgreSQL, Oracle, or SapDB database. I want
> to be able to use templates for folder/pages/etc when storing the PSML in the
> derby database.
>
> Thanks,
> Noah
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org