RE: Help with JDBC Connection Pool

[Mark Johnson]

[EMAIL PROTECTED] wrote:
>Mark,
>Can you post it or send it to me as well. I am looking for examples to do that as 
>well. >Thanks much.
>
>Regards,
>
>Muki Soomar
>

Here it is:
****************begin struts-config.xml fragment******************
<?xml version="1.0" encoding="ISO-8859-1" ?>

<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts 
Configuration 1.1//EN" "http://jakarta.apache.org/struts/dtds/struts-config_1_1.dtd";>

<struts-config>

  <!-- ========== Data Sources ========== --> 
   <data-sources>

      <data-source className="org.apache.struts.config.DataSourceConfig"
                   key="MyData"
                   type="org.apache.commons.dbcp.BasicDataSource">

         <set-property property="driverClassName" 
                       value="org.postgresql.Driver"/> 
         <set-property property="maxActive"       
                       value="4"/> 
         <set-property property="password"
                       value="my_postgres_password"/> 
         <set-property property="url"
                       value="jdbc:postgresql:mydata"/> 
         <set-property property="username"
                       value="my_postgres_username"/>

      </data-source>

   </data-sources>
****************end struts-config.xml fragment********************
*******begin overridden ActionForward.execute fragment*******
HttpSession session = request.getSession();
BasicDataSource ds = (BasicDataSource) 
        session.getServletContext().getAttribute("MyData");
Connection conn = null;
PreparedStatement prpd_st = null;
ResultSet res = null;
try {
  conn = ds.getConnection();
*******end overridden ActionForward.execute fragment*********
*****files you need in WEB-INF/lib that might not be there*****
$ ls -l WEB-INF/lib
-rw-r--r--    1 markj    markj      107105 May 21 11:37 commons-collections.jar
-rw-r--r--    1 markj    markj       35870 May 21 11:37 commons-dbcp.jar
-rw-r--r--    1 markj    markj       28840 May 21 11:37 commons-pool.jar
-rw-r--r--    1 markj    markj        6727 May 21 11:37 jdbc2_0-stdext.jar
-rw-r--r--    1 markj    markj      116204 May 10 14:26 pgjdbc2.jar
...
***end files you need in WEB-INF/lib that might not be there***
>
>-----Original Message-----
>From: Mark Johnson [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, May 22, 2002 12:58 PM
>To: [EMAIL PROTECTED]
>Subject: Re: Help with JDBC Connection Pool
>
>I had difficulty getting this working under 1.02, too, but now have it
>working with BasicDataSource under a nightly build. If you are
>interested, I can send sample config and code which works under
>struts-20020520.
>
>from [EMAIL PROTECTED]:
>>Hi,
>>I'm using struts 1.02 (which is the latest stabel release) and
>>GenericDataSource is not depricated in this version.   
>>I have not looked in to the beta releases (which usually will get you more
>>trouble than the official releases).
>>
>>"Mark Johnson" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
>>> What struts version are you using? GenericDataSource was recently
>>> deprecated.
>>>
>>> from [EMAIL PROTECTED]:
>>>I got a little confused with the JDBC connection pool, when trying out
the
>>>samples from struts user guide.
>>>
>>> --
>>>
>>> Mark Johnson
>>> [EMAIL PROTECTED]
>>>
>
>-- 
>
>Mark Johnson
>[EMAIL PROTECTED]

-- 

Mark Johnson
[EMAIL PROTECTED]

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>