Bert, If you are using JRUN, you can set up a datasource with connection pooling, within the JRUNServer console. When you do that, you can use the datasource within the JSP tag library, or even within your JavaServer Pages directly. You can see an example of using a datasource named NYTC, defined in the JRUN console, in my previous posting to you on the XML/XSLT example. Download the Adobe documentation off of JRUN's web site for both the JRUN Server and the JRUN tag library. If you are coming from ASP, forget most of what you know. JSP may be based off the same internet protocol/object library (Request, Response, ect), but that pretty much is where the similarities end. JRUN's Adobe documentation will give you examples and explain in greater detail how to set up a datasource. REMEMBER, setting up a datasource within the JRUN console with connection pooling requires that you have a JDBC driver that supports both of these features (i.e.. the javax.sql libraries, particularly the JNDI interface, and connection pooling). Preferable a Type III or Type IV JDBC driver. If you are not using a driver that supports these features, I don't think you can set up a datasource in the JRUN Server console, but I may be wrong. I always use a Type IV JDBC driver, so I have never tried it. Perhaps someone else on this forum has had some experience with the other driver types. Celeste -----Original Message----- From: Bert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 2:56 PM To: JRun-Talk Subject: Database Bean Is i t better to use a Database Bean or put the connection in a Servlet or right into the Jsp page? Bert ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
