You can access "any" (external or whatever) database with Torque. See my last email for exactly how this is done.
Scott > -----Original Message----- > From: Josselin Lebret [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 21, 2002 12:33 PM > To: Jetspeed Users List > Subject: Re: jdbc access via custom portlet > > > 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]>
