JDBC in JSP not working

Hi all,
In Eclipse a choosed new -> Dynamic Web Project. Then I selected tomcat (as runtime) and jdk. Next, created a jsp file, named index.

I want, to connect to MySQL, and retrieve the data. I have already created a table named "catalog" under a database named "catalog" and filled it with data. Table columns are id(int), name (varchar), location (varchar) and marker(boolean). When are run it , i get on the browser screen only "Test!". Why it doesn't print "Int01" value ?
I'll appreciate any help. Thnx in advance.
P.S: Sorry for my english.

Popescu,
Some best practices:
1) It is better not to have Java code, especially JDBC, in a JSP. It is harder to read/debug/maintain. JSPs are meant for display logic. Search for MVC to see what you should to instead.
2) The result set/statement/connection should be closed in a finally block in case there is a database error.
3) Variable names being with lowercase in Java so "Int01" should be "int01". Or better still "id" so someone reading the code knows what it is.

On your actual question, is there an error message in the system error logs? There should be if the code is throwing an exception.

I changed variables.
In the console i get this:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1643)
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1488)
	at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:126)
	at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:169)
	at org.apache.jsp.index_jsp._jspService(index_jsp.java:66)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:306)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:550)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:380)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:166)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:288)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)

Any ideas?

Popescu Ion
The jdbc driver for mysql - com.mysql.jdbc.Driver is not been found in runtime.
You will have to add the jar to the WAR .

Lingan Rajan wrote:Popescu Ion
The jdbc driver for mysql - com.mysql.jdbc.Driver is not been found in runtime.
You will have to add the jar to the WAR .

Thnx, it works now.