tomcat-taglibs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "PAZDZIOREK,LUKASZ (HP-Poland,ex1)" <lukasz.pazdzio...@hp.com>
Subject RE: Data source usage
Date Tue, 12 Aug 2003 08:12:43 GMT
Hi,

Thanks for the explanation.
I did not know how to write setDataSource tag:

<sql:setDataSource
  dataSource="jdbc/test"
  var="test"
/>

when I did it, it workes now.

reards,
Lukasz

> -----Original Message-----
> From: Siggelkow, Bill [mailto:bill.siggelkow@mirant.com] 
> Sent: Monday, August 11, 2003 3:49 PM
> To: 'Tag Libraries Users List'
> Subject: RE: Data source usage
> 
> 
> I believe you want to use the JNDI name from the web.xml -- 
> e.g. "jdbc/test".
> 
> Following is from the JSTL spec:
> 
> The first way [to specify a DataSource] is through a JNDI 
> relative path, assuming a container supporting
> JNDI. For example, with the absolute JNDI resource path 
> java:comp/env/jdbc/
> myDatabase, the JNDI relative path to the data source 
> resource would simply be
> jdbc/myDatabase, given that java:comp/env is the standard 
> JNDI root for a
> J2EE application.
> 
> -----Original Message-----
> From: p@zdzior [mailto:pazdzior@interia.pl]
> Sent: Saturday, August 09, 2003 2:09 PM
> To: taglibs-user@jakarta.apache.org
> Subject: Data source usage
> 
> 
> Hi,
> 
> I have defined a data source in my server xml file:
> 
>           <Resource name="jdbc/test"
>                auth="Container"
>                type="javax.sql.DataSource"/>
> 
>           <ResourceParams name="jdbc/test">
>             <parameter>
>               <name>factory</name>
>               
> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
>             </parameter>
> 
>             <!-- Maximum number of dB connections in pool. 
> Make sure you
>                  configure your mysqld max_connections large 
> enough to handle
>                  all of your db connections. Set to 0 for no limit.
>             -->
>             
>             <parameter>
>               <name>maxActive</name>
>               <value>100</value>
>             </parameter>
> 
>             <!-- Maximum number of idle dB connections to 
> retain in pool.
>                  Set to 0 for no limit.
>             -->
>             <parameter>
>               <name>maxIdle</name>
>               <value>30</value>
>             </parameter>
> 
>             <!-- Maximum time to wait for a dB connection to 
> become available
>                  in ms, in this example 10 seconds. An 
> Exception is thrown if
>                  this timeout is exceeded.  Set to -1 to wait 
> indefinitely.
>             -->
>             <parameter>
>               <name>maxWait</name>
>               <value>10000</value>
>             </parameter>
>  
>             <!-- MySQL dB username and password for dB 
> connections  -->
>             <parameter>
>               <name>username</name>
>               <value>test</value>
>             </parameter>
>             <parameter>
>               <name>password</name>
>               <value>test</value>
>             </parameter>
> 
>             <!-- Class name for mm.mysql JDBC driver -->
>             <parameter>
>               <name>driverClassName</name>
>               <value>org.gjt.mm.mysql.Driver</value>
>             </parameter>
>  
>             <!-- The JDBC connection url for connecting to 
> your MySQL dB.
>                  The autoReconnect=true argument to the url 
> makes sure that the
>                  mm.mysql JDBC Driver will automatically 
> reconnect if mysqld closed the
>                  connection.  mysqld by default closes idle 
> connections after 8 hours.
>             -->
>             <parameter>
>               <name>url</name>
>               
> <value>jdbc:mysql://localhost:3306/TEST?autoReconnect=true</value>
>             </parameter>
>           </ResourceParams>
> 
> then I have defined a reference in web.xml file of my application:
> 
>   <resource-ref>
>       <description>DB Connection</description>
>       <res-ref-name>jdbc/test</res-ref-name>
>       <res-type>javax.sql.DataSource</res-type>
>       <res-auth>Container</res-auth>
>   </resource-ref>
> 
> I would like to use it with jstl tag libray <sql>,
> Could anyboty tell my what should I write 
> into the datasource value:
> <sql:transaction dataSource="${???}">
> to make it working?
> 
> or shall I define it somehow?
> 
> thanks,
> regards,
> Lukasz
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
> 

Mime
View raw message