Got it. ;) Thanks ----- Original Message ----- From: "Weaver, Scott" <[EMAIL PROTECTED]> To: "'Jetspeed Users List'" <[EMAIL PROTECTED]> Sent: Friday, June 21, 2002 6:45 PM Subject: RE: jdbc access via custom portlet
> 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]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
