You are viewing a plain text version of this content. The canonical link for it is here.
Posted to taglibs-user@tomcat.apache.org by Lorenzo Sicilia <ar...@kemen.it> on 2004/03/04 12:24:56 UTC
jstl and binary field in mysql
Hi to the list,
I have a mysql db and I use SQL tag.
I have a strange problem when a field that has the attribute BINARY
With this snippets:
<sql:query var="query1" >
SELECT nick_name FROM user_comunity
</sql:query>
<c:forEach var="row" items="${query1.rows}">
<c:forEach var="column" items="${query1.columnNames}">
<c:out value="${column}" /> = <c:out value="${row[column]}" />,
</c:forEach>
<br>
</c:forEach>
the output is:
-- > nick_name = [B@171b246, (BINARY attribute)
or
-- > nick_name = myLogin (no attributes)
I need mantain BINARY attribute.
Does it exist a solution?
Regard Lorenzo Sicilia
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
Re: Tomcat Concurrency and Hit Rate Issue
Posted by Peter Lin <tc...@yahoo.com>.
I would try sql server forums first to see what kind of load your server can handle. You can load test some sample queries using JMeter. this will tell you the upper limit for your particular server.
jmeter-user@jakarta.apache.org - if you have questions.
If you're using a single CPU server, you should be able to handle 10 active sessions without any problems. assuming you've taken care to write stored procedures and you're not doing funky joins. Reads won't be any problem for you, it's really the writes.
peter lin
Thomas McDonald <to...@yahoo.com> wrote:
Thanks. Actually all the people will take it. It is
an internal survey and they are being told by their
managers that they must take it.
That said, I would expect about 12-25 people hiting
the site at any one time (If I send out all 400
invitations at one time).
Also, it isn't a one shot survey submission. It is a
3-4 question at a time kind of survey and about
200-300 questions total. So there will be lots of
reads/writes. Some of the initial queries are complex
(lots of joins, etc.) so I am a little worried about
SQL performance.
Anyway, I'll take this to the the list mentioned by
J.Petersen: tomcat-user@jakarta.apache.org, but if
anyone has anymore useful comments I would welcome
them.
--- Peter Lin wrote:
>
> from a pracitcal perspective, chances are at any
> given time there will only be 1 person submitting
> the completed form. 400 seems like a very low number
> to me.
>
> Now if you're talking about a survey that is sent
> out to 10K people with a window of 5 hours to submit
> it, it probably won't be a problem. Most people
> ignore surveys to begin with. Unless you know the
> users absolutely will fill it out, I wouldn't really
> worry about it.
>
> sql server 2K is ok as long as you don't have more
> than 50+ concurrent queries. The reason for that is
> the sql server worker thread to CPU ratio is:
>
> 2 worker thread: 1 cpu
>
> also, the kind of query has a tremendous impact on
> performance. if you really have to support a large
> number of concurrent insert/updates, you're going to
> have to dig around the various sql server community
> sites and use COM+/DAL. Your bottleneck won't be the
> webserver. whether you use IIS, resin or tomcat, the
> database will the bottleneck.
>
> peter lin
>
>
> Thomas McDonald wrote:
> I'm not sure if this is the right list to post this
> quesiton too, but here goes:
>
> I am doing a web survey on Tomcat 5.0.19 hooked to a
> SQL Server 2000 backend I am trying to figure out
> what
> sort of hit rate it can take.
>
> I'll send an email to 400 people inviting them to
> take
> the survey. They all won't show up at once (and I
> don't necessarily have to invite them all at the
> same
> time--I can spread it out over 3/4 hours), but I
> don't
> know if Tomcat can take the load of say, 50 people
> using the site at once.
>
> Any suggestions on how I can figure this out?
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Search - Find what you�re looking for faster
> http://search.yahoo.com
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> taglibs-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> taglibs-user-help@jakarta.apache.org
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Search - Find what you�re looking for faster.
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster
http://search.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
---------------------------------
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster.
Re: Tomcat Concurrency and Hit Rate Issue
Posted by Thomas McDonald <to...@yahoo.com>.
Thanks. Actually all the people will take it. It is
an internal survey and they are being told by their
managers that they must take it.
That said, I would expect about 12-25 people hiting
the site at any one time (If I send out all 400
invitations at one time).
Also, it isn't a one shot survey submission. It is a
3-4 question at a time kind of survey and about
200-300 questions total. So there will be lots of
reads/writes. Some of the initial queries are complex
(lots of joins, etc.) so I am a little worried about
SQL performance.
Anyway, I'll take this to the the list mentioned by
J.Petersen: tomcat-user@jakarta.apache.org, but if
anyone has anymore useful comments I would welcome
them.
--- Peter Lin <tc...@yahoo.com> wrote:
>
> from a pracitcal perspective, chances are at any
> given time there will only be 1 person submitting
> the completed form. 400 seems like a very low number
> to me.
>
> Now if you're talking about a survey that is sent
> out to 10K people with a window of 5 hours to submit
> it, it probably won't be a problem. Most people
> ignore surveys to begin with. Unless you know the
> users absolutely will fill it out, I wouldn't really
> worry about it.
>
> sql server 2K is ok as long as you don't have more
> than 50+ concurrent queries. The reason for that is
> the sql server worker thread to CPU ratio is:
>
> 2 worker thread: 1 cpu
>
> also, the kind of query has a tremendous impact on
> performance. if you really have to support a large
> number of concurrent insert/updates, you're going to
> have to dig around the various sql server community
> sites and use COM+/DAL. Your bottleneck won't be the
> webserver. whether you use IIS, resin or tomcat, the
> database will the bottleneck.
>
> peter lin
>
>
> Thomas McDonald <to...@yahoo.com> wrote:
> I'm not sure if this is the right list to post this
> quesiton too, but here goes:
>
> I am doing a web survey on Tomcat 5.0.19 hooked to a
> SQL Server 2000 backend I am trying to figure out
> what
> sort of hit rate it can take.
>
> I'll send an email to 400 people inviting them to
> take
> the survey. They all won't show up at once (and I
> don't necessarily have to invite them all at the
> same
> time--I can spread it out over 3/4 hours), but I
> don't
> know if Tomcat can take the load of say, 50 people
> using the site at once.
>
> Any suggestions on how I can figure this out?
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Search - Find what you�re looking for faster
> http://search.yahoo.com
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> taglibs-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> taglibs-user-help@jakarta.apache.org
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Search - Find what you�re looking for faster.
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster
http://search.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
Re: Tomcat Concurrency and Hit Rate Issue
Posted by Peter Lin <tc...@yahoo.com>.
from a pracitcal perspective, chances are at any given time there will only be 1 person submitting the completed form. 400 seems like a very low number to me.
Now if you're talking about a survey that is sent out to 10K people with a window of 5 hours to submit it, it probably won't be a problem. Most people ignore surveys to begin with. Unless you know the users absolutely will fill it out, I wouldn't really worry about it.
sql server 2K is ok as long as you don't have more than 50+ concurrent queries. The reason for that is the sql server worker thread to CPU ratio is:
2 worker thread: 1 cpu
also, the kind of query has a tremendous impact on performance. if you really have to support a large number of concurrent insert/updates, you're going to have to dig around the various sql server community sites and use COM+/DAL. Your bottleneck won't be the webserver. whether you use IIS, resin or tomcat, the database will the bottleneck.
peter lin
Thomas McDonald <to...@yahoo.com> wrote:
I'm not sure if this is the right list to post this
quesiton too, but here goes:
I am doing a web survey on Tomcat 5.0.19 hooked to a
SQL Server 2000 backend I am trying to figure out what
sort of hit rate it can take.
I'll send an email to 400 people inviting them to take
the survey. They all won't show up at once (and I
don't necessarily have to invite them all at the same
time--I can spread it out over 3/4 hours), but I don't
know if Tomcat can take the load of say, 50 people
using the site at once.
Any suggestions on how I can figure this out?
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster
http://search.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
---------------------------------
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster.
Tomcat Concurrency and Hit Rate Issue
Posted by Thomas McDonald <to...@yahoo.com>.
I'm not sure if this is the right list to post this
quesiton too, but here goes:
I am doing a web survey on Tomcat 5.0.19 hooked to a
SQL Server 2000 backend I am trying to figure out what
sort of hit rate it can take.
I'll send an email to 400 people inviting them to take
the survey. They all won't show up at once (and I
don't necessarily have to invite them all at the same
time--I can spread it out over 3/4 hours), but I don't
know if Tomcat can take the load of say, 50 people
using the site at once.
Any suggestions on how I can figure this out?
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster
http://search.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
FAQ
Posted by Derek <dh...@yahoo.com>.
Is there a general FAQ being maintained for this
listserv? Sun maintains a very high level overview
FAQ. However, I was wondering if something a bit more
detailed was available.
Thanks!
Derek
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster
http://search.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
Strange behavior of Tomcat
Posted by Ananth R <an...@csa.iisc.ernet.in>.
Hello
Whenever I add new jar files to WEB-INF/lib my tomcat doesnot work.It
says :The requested resource (/webapplication1/) is not available.
I tried to restart the Tomcat, that also does not work.So, a kind of fear
surrounds me whenever I add new Jar files or tld files.
Please tell me what I have to do.Should I write any entries to
server.xml/web.xml ...........
waiting for your generous solutions
A N A N T H. R
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org