I thought Pat wanted to access an "external" database. But you're right : Torque API is the way if you store all your data in the Jetspeed/turbine database ----- Original Message ----- From: "Weaver, Scott" <[EMAIL PROTECTED]> To: "'Jetspeed Users List'" <[EMAIL PROTECTED]> Sent: Friday, June 21, 2002 6:05 PM Subject: RE: jdbc access via custom portlet
> > AFAIK Jetspeed does not deal with JDBC access > Actually, Jetspeed does provide you with jdbc access through Turbine's > Torque api. > > in 1.3a2 > DBConnection con = TurbineDB.getConnection(); > //... do some stuff > TurbineDB.releaseConnection(con); > > in 1.3a3 > java.sql.Connection con = Torque.getConnection(); > //... do some stuff > > > DBConnection will give you access to the underlying java.sql.Connection > object through DBConnection.getConnection(). You must have the database > values set up correctly in either TurbineResources.properties or in > Torque.properties respectively. > > These are very simple examples. Torque can support pooling for multiple > RDBMSes at once. > > see: <http://jakarta.apache.org/turbine> for more information on this > subject. > > hth, > Scott > > > > > > -----Original Message----- > > From: Josselin Lebret [mailto:[EMAIL PROTECTED]] > > Sent: Friday, June 21, 2002 11:40 AM > > To: Jetspeed Users List > > Subject: Re: jdbc access via custom portlet > > > > > > AFAIK Jetspeed does not deal with JDBC access : you'll have to connect > > manually your portlet to Oracle (by creating a JSP or a Java portlet) > > ----- Original Message ----- > > From: "Pat Ryan" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, June 21, 2002 5:30 PM > > Subject: jdbc access via custom portlet > > > > > > > > > > > > > Hello Everyone > > > > > > I am new to JetSpeed so I have a newbie question - sorry about that. > > > > > > I am prototyping a couple of portlets, one of which needs > > to access a > > > database via jdbc. How do I configure the jdbc > > information and then > > > access that in my portlet? > > > > > > I did see the tasklist example which seems to provide the > > configuration > > > information, but I am unclear how to access that in my portlet. > > > > > > BTW; I am using Oracle 8.1.6 as my database. > > > > > > Thank you > > > Pat > > > > > > > > > > > > > > > > > > -- > > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
