Code: |
<html> <body> <%@ page language="java" import="java.io.*,java.sql.*,java.util.*, java.lang.*, javax.sql.*" %> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); <!--// Complies this with out error //--> <% String url = "jdbc:odbc:test"; %> <% Connection con = DriverManager.getConnection(url); %> <!--//Attempt number 1 //--> <br> Connection dbCon=DriverManager.getConnection("jdbc:odbc:test"); <!--//Attempt number 2 //--> <br> Connection dbCon = DriverManager.getConnection("jdbc:odbc:[odbc test]");<!--//Attempt number 3 //--> <% String hi="Hellow World"; out.println(hi); %> </body> </html> |
Quote: |
org.apache.jasper.JasperException: Unable to compile class for JSP Generated servlet error: [javac] Compiling 1 source file C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\Apoc\testforum_jsp.java:43: cannot resolve symbol symbol : class Connection location: class org.apache.jsp.testforum_jsp Connection myConn; ^ An error occurred at line: 1 in the jsp file: /Apoc/testforum.jsp Generated servlet error: C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\Apoc\testforum_jsp.java:51: cannot resolve symbol symbol : variable DriverManager location: class org.apache.jsp.testforum_jsp myConn = DriverManager.getConnection (dbUrl, user, pass); ^ An error occurred at line: 1 in the jsp file: /Apoc/testforum.jsp Generated servlet error: C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\Apoc\testforum_jsp.java:52: cannot resolve symbol symbol : class Statement location: class org.apache.jsp.testforum_jsp Statement myStmt = myConn.createStatement(); ^ An error occurred at line: 13 in the jsp file: /Apoc/testforum.jsp Generated servlet error: C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\Apoc\testforum_jsp.java:53: cannot resolve symbol symbol : class ResultSet location: class org.apache.jsp.testforum_jsp ResultSet myRs = myStmt.executeQuery("SELECT * FROM tblName"); ^ 4 errors at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:120) at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:293) at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:313) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:324) at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:474) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:184) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:380) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:533) at java.lang.Thread.run(Unknown Source) |
Code: |
<html> <% Connection myConn; String driverName = "sun.jdbc.odbc.JdbcOdbcDriver"; String dbUrl = "jdbc:odbc:test"; String user; String pass; Class.forName(driverName); myConn = DriverManager.getConnection (dbUrl, user, pass); Statement myStmt = myConn.createStatement(); ResultSet myRs = myStmt.executeQuery("SELECT * FROM tblName"); %> </html> |
output generated using printer-friendly topic mod, All times are GMT + 2 Hours