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 | | <[EMAIL PROTECTED]> | | Apache Jetspeed Portal Project | | Apache Pluto Portlet Container | *================================* > -----Original Message----- > From: Celeste Haseltine [mailto:[EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED]
