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:[EMAIL PROTECTED] > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Saturday, August 09, 2003 2:09 PM > To: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
