jrun & jstl

[Lorenzo Sicilia]

Hi to the list

Fist sorry for my english I am italian :o)
I use JSTL with JRUN4

some question about JSTL.

1-
The Sql tag is very usefull but I read in "JSTL in ACTION" that it don't support pooling connection. Is true?

with this tag:
<!--This script work but the pooling connection? -->
<sql:setDataSource
driver="com.mysql.jdbc.Driver" dataSource="jdbc:mysql://127.0.0.1:3306/aostacompany?user=xxx&password=xxx"
/>

<!--
This script don't work. The error is:"No suitable driver"
In Jrun admin console the JNDI is "aosta_db" and jrun send this message: "Connected to aosta_db successfully".
-->

<sql:setDataSource
driver="com.mysql.jdbc.Driver" dataSource="aosta_db"
/>

The book suggest to use the JNDI to bind a database with the poolconnection.Idea?

2-
I need read a recorset JSTL with JSP script because the JSTL tag put "\n" each time I close a tag. I need an output without "\n" but I like JSTL recorset.

<c:set var="language_set" value="it" />2
<sql:query var="elenco" >
SELECT ID_news,data,
titolo_<c:out value="${language_set}" /> as titolo,
abstract_<c:out value="${language_set}" /> as abstract,
testo_<c:out value="${language_set}" /> as testo,
data
FROM tb_news
</sql:query>
<!--
The follow script don't work. Do you now where path recorset variables are?
-->
<%
out.print(elenco);
%>

Any Help very Usefull

Thanks Lorenzo Sicilia



--
To unsubscribe, e-mail: <mailto:taglibs-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:taglibs-user-help@;jakarta.apache.org>