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]
