Re: sql:query var empty
And after a day of messing around and 5 minutes after posting.. i find: http://marc.theaimsgroup.com/?l=taglibs-userm=109948926807297w=4 I guess that means jakarta-taglibs-standard-1.1.2/README is a big fat liar :) good lord. On Wed, 2004-11-17 at 16:29 -0600, Matthew Lenz wrote: I'm really new to java so you'll have to forgive me. here is the setup: j2sdk1.4.2_06 (rpm from sun) apache-ant-1.6.2 (from apache.org) jakarta-tomcat-5.0.28 (from apache.org) jakarta-taglibs-standard-1.1.2 (from apache.org) MySQL-server-4.1.7-0 (rpm from MySQL AB) mysql-connector-java-3.0.15-ga (zip from MySQL AB) and I've done the following: 1. setup the JAVA_HOME and ANT_HOME environment variables 2. copied the jakarta-tomcat-5.0.28/server/lib/catalina-ant.jar to ANT_HOME/lib 3. copied the mysql-connector-java-3.0.15-ga to jakarta-tomcat-5.0.28/common/lib 4. copied jakarta-taglibs-standard-1.1.2/lib/*.jar to jakarta-tomcat-5.0.28/common/lib I already had mysql setup with some sample data and verified that the username and password worked as well as a few queries. I've created an example application with the following structure: ./src ./src/net ./src/net/level1tech ./src/net/level1tech/EpayManager.java ./build.xml ./web ./web/META-INF ./web/META-INF/context.xml ./web/WEB-INF ./web/WEB-INF/web.xml ./web/index.jsp ./docs ./build.properties I modified the example build.xml file that comes with tomcat to pass a 'config' param and point to my build/META-INF/context.xml file. I just use it to setup the database as a Resource in the context. I added the corresponding resource-ref to the WEB-INF/web.xml file. The application has been deployed using ant install and everything seems to work ok. The servlet is just a hello world type program and works fine. Here is a copy of the index.jsp: %@ taglib uri=http://java.sun.com/jsp/jstl/core; prefix=c % %@ taglib uri=http://java.sun.com/jsp/jstl/sql; prefix=sql % sql:query var=rs dataSource=jdbc/EpayManager SELECT username FROM tbUser /sql:query html head titletbUser/title /head body h2Results/h2 c:forEach var=user begin=0 items=${rs.rows} c:out value=${user.username} /br/ /c:forEach Row Count: c:out value=${rs.rowCount} /br /body /html As you can see its pretty darn basic. Here is the source for the html that is generated: html head titletbUser/title /head body h2Results/h2 ${user.username}br/ Row Count: ${rs.rowCount}br /body /html The annoying thing is that the database is being connected to and if I mess up the query it complains about it not being a valid query. The query also shows up in the mysql server log files. I can see all the connections etc and there are no errors in the mysql server error log files. So basically, the taglibs SEEM to be working, but not entirely. I've tried adding the taglib's rar files to the WEB-INF/lib directory of my application and adding the corresponding taglib entries in the WEB- INF/web.xml file to no avail. I really don't think thats it, since they are installed in the tomcat common lib directory. - 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]
Re: sql:query var empty
- Original Message - From: Chris Gow [EMAIL PROTECTED] To: Tag Libraries Users List [EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 5:01 PM Subject: Re: sql:query var empty On November 17, 2004 05:40 pm, Matthew Lenz wrote: And after a day of messing around and 5 minutes after posting.. i find: http://marc.theaimsgroup.com/?l=taglibs-userm=109948926807297w=4 I guess that means jakarta-taglibs-standard-1.1.2/README is a big fat liar :) Err...not exactly. It took me a while to figure out how to correctly configure things too. Especially when some of the examples I found online were for 1.0. Anyways, I would put the http://java.sun.com/jsp/jstl/core header back into your jsp page. What you need to do is change your taglib entry in your web.xml to: actually, i was referring to the thread not that specific post. the only thing that was wrong was the web.xml web-app schema links. I fixed that and now it works, no need for the taglib entries in web.xml from what I can tell. taglib taglib-urihttp://jakarta.apache.org/taglibs/core/taglib-uri taglib-location!-- some/path/c.tld --/taglib-location /taglib And make sure that the URI in the tld matches the uri specified in your web.xml hth -- chris - 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]