RE: Can I use Stored Procedure to return a result set for use in Jets peed

["Weaver, Scott" <Sw...@rippe.com>]

Celeste,

For creating portlets, you can use anything you like to get information.  I used OJB exclusively for any object persistence through a RDBMS.  I also have report portlets that do straight JDBC calls to an iSeries (AS/400).  So, yes, you can implement data access in whatever manner you like.

Will you be allowed to use the existing/standard Jetspeed database schema for User/Roles/Groups and security?  Or do you have to conform to some other standard for authentication/authorization.  I have done both and have them working side by side in my security event pipeline. I plan on donating the pipeline into 1.5, but I could get you the code sooner if you have implement a complicated/delegated security architecture.

hth,
*================================* 
| Scott T Weaver                 |
| <we...@apache.org>            | 
| Apache Jetspeed Portal Project |
| Apache Pluto Portlet Container |
*================================*

> -----Original Message-----
> From: Celeste Haseltine [mailto:CHaseltine@unifocus.com]
> Sent: Friday, October 31, 2003 11:29 AM
> To: 'Jetspeed Users List'
> Subject: Can I use Stored Procedure to return a result set for use in Jets
> peed
> 
> My client's VP  has decided as of today to go with Jetspeed for a new
> portal
> development project I've just been hired to design and oversee.  I have no
> experience with Jetspeed, Torque, or Turbine, so I will be running through
> the tutorials this weekend.  But I have one important questions I need to
> ask upfront, so I apologize in advance if this is a question that is
> covered
> in the documentation somewhere.  One of the requirements my client has is
> that he make no changes to his existing database schema that I will need
> to
> obtain my data from, as the current database obtains it's information from
> the manufacturing line, and the client cannot afford to modify the
> software
> running the line.  The database schema is extremely complex, and uses a
> ton
> of stored procedures and triggers.
> 
> In order for me to obtain the information that my clients customers need
> from that database for displaying into Jetspeed, I will need to utilize
> his
> parameterized stored procedures already written in the database to return
> my
> result sets.  I know how to do this with plain JDBC calls, as I have done
> this in the past for other manufacturing clients, and my JDBC driver and
> tag
> libraries I am using handle parameterized stored procedures.  My question
> is
> can I do this via Torque, or do I even need to use Torque?  Can I write my
> own Java classes to handle this (as I have done in the past) and just use
> the <use bean> tag and my own tag libraries in a jetspeed portlet to
> obtain
> my data for displaying?
> 
> If I need to use Torque, other than the Torque documentation/website, does
> anyone have any advice/web sites/example code to offer that deals with
> paramertized stored procedures?
> 
> My thanks in advance for any advice/assistance.
> 
> Celeste Haseltine, PE
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org