Scott, Thank you for the information. I figured that I did not have to use Torque, but I wanted to verify that.
As to the authentication standard, I most likely will have to use what is currently in the client's database, which I don't yet have a very good understanding of. I just know that it is a very complex combination of log-in authorization and security codes contained in several tables that determine what data can be accessed and viewed by whom, both internal and external. We will start fleshing out our design next week, so I will have a better understanding of our login mechanism in the next week or two. I would be interested in seeing your code, and using it if it fits our needs if I have your permission. Like most clients today, this one waited until last week to bring someone on board for this project (me), and they want a first release of the portal rolled out to the web by Jan 15. They have a staff of two people, both of whom are VB 6.0 developers with no OO background, that I am suppose to retrain into J2EE developers while we are coding. So as you can imagine, I am really going to be under the gun on this project. Thank you again Scott, and I look forward to seeing your security event pipeline code. Celeste Haseltine, PE -----Original Message----- From: Weaver, Scott [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2003 11:44 AM To: 'Jetspeed Users List' Subject: RE: Can I use Stored Procedure to return a result set for use in Jets peed 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
