You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by werner <we...@connecties.com> on 2005/06/22 23:58:15 UTC
Datasource/jstl problem
Hi,
I followed the example on : http://jakarta.apache.org/tomcat/
tomcat-5.0-doc/jndi-datasource-examples-howto.html
The only thing I changed was jdbc/TestDB into jdbc/weblog.
on al locations I could find.
If I look at my page (http://www.karnhuis.nl/gastenboek.jsp)
The ${row.name} and other such thingies do not seem to be 'rendered'.
I use tomcat 5.0.19 and java version 1.4.2_04
I can't find anything that I did wrong so maybe one of you will have any
idea of what went wrong.
I get an exception saying that jdbc is not bound to this context.
snippets :
gastenboek.jsp
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<sql:query var="rs" dataSource="jdbc/weblog">
select name, datum, tekst, id from gb order by id desc limit 10
</sql:query>
<c:forEach var="row" items="${rs.rows}">
<div id='entry'>
<h4 class='title'> ${row.name} wrote on </h4>
<h5 class='date'> ${row.datum} </h5>
${row.tekst}
</div>
</c:forEach>
web.xml
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/weblog</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
server.xml
<Host name="www.karnhuis.nl" appBase="xxx"
unpackWARs="true" autoDeploy="true">
<Context path="" docBase="." >
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="karnhuis_log."
suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/weblog" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/weblog">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>username</name>
<value>This is a secret</value>
</parameter>
<parameter>
<name>password</name>
<value>you don't wanna know</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://www.karnhuis.nl:3306/weblog</
value>
</parameter>
</ResourceParams>
</Context>
</Host>
Kind regards
Werner van Mook
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Datasource/jstl problem
Posted by Charl Gerber <ch...@yahoo.com>.
Its seems you have correctly defined the datasource,
but it is not linked to your application. In the
server.xml your application should be defined as a
"context" and in the context you have to specify that
the global resource defined earlier is available to
this application.
Look at resource-ref settings. You can also defined
the resource directly within your context, then the
reference is not necessary, but other apps cannot
access the resource.
Your application could also be defined in its own
seperate xml file, but you still need to add the
reference to the global datasource there.
Charl
--- werner <we...@connecties.com> wrote:
> Hi,
>
> I followed the example on :
> http://jakarta.apache.org/tomcat/
> tomcat-5.0-doc/jndi-datasource-examples-howto.html
>
> The only thing I changed was jdbc/TestDB into
> jdbc/weblog.
> on al locations I could find.
>
> If I look at my page
> (http://www.karnhuis.nl/gastenboek.jsp)
>
> The ${row.name} and other such thingies do not seem
> to be 'rendered'.
>
> I use tomcat 5.0.19 and java version 1.4.2_04
>
> I can't find anything that I did wrong so maybe one
> of you will have any
> idea of what went wrong.
>
>
> I get an exception saying that jdbc is not bound to
> this context.
>
>
>
> snippets :
>
> gastenboek.jsp
>
> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql"
> prefix="sql" %>
> <%@ taglib uri="http://java.sun.com/jsp/jstl/core"
> prefix="c" %>
>
> <sql:query var="rs" dataSource="jdbc/weblog">
> select name, datum, tekst, id from gb order by id
> desc limit 10
> </sql:query>
>
> <c:forEach var="row" items="${rs.rows}">
> <div id='entry'>
> <h4 class='title'> ${row.name} wrote on
> </h4>
> <h5 class='date'> ${row.datum} </h5>
> ${row.tekst}
> </div>
> </c:forEach>
>
> web.xml
>
> <resource-ref>
> <description>DB Connection</description>
> <res-ref-name>jdbc/weblog</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>
>
> server.xml
>
> <Host name="www.karnhuis.nl" appBase="xxx"
> unpackWARs="true" autoDeploy="true">
> <Context path="" docBase="." >
> <Logger
> className="org.apache.catalina.logger.FileLogger"
> directory="logs"
> prefix="karnhuis_log."
> suffix=".txt"
> timestamp="true"/>
>
> <Resource name="jdbc/weblog"
> auth="Container"
> type="javax.sql.DataSource"/>
>
> <ResourceParams name="jdbc/weblog">
> <parameter>
> <name>factory</name>
>
>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> </parameter>
> <parameter>
> <name>maxActive</name>
> <value>20</value>
> </parameter>
> <parameter>
> <name>maxIdle</name>
> <value>10</value>
> </parameter>
> <parameter>
> <name>removeAbandoned</name>
> <value>true</value>
> </parameter>
> <parameter>
>
> <name>removeAbandonedTimeout</name>
> <value>60</value>
> </parameter>
> <parameter>
> <name>maxWait</name>
> <value>10000</value>
> </parameter>
> <parameter>
> <name>username</name>
> <value>This is a secret</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value>you don't wanna
> know</value>
> </parameter>
> <parameter>
> <name>driverClassName</name>
>
> <value>org.gjt.mm.mysql.Driver</value>
> </parameter>
> <parameter>
> <parameter>
> <name>url</name>
>
> <value>jdbc:mysql://www.karnhuis.nl:3306/weblog</
> value>
> </parameter>
> </ResourceParams>
> </Context>
> </Host>
>
>
> Kind regards
> Werner van Mook
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> tomcat-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org