Hi ,
i ahve some problem with jsp using jdbc.
i written a code like this. but it is not running.
<%@ page import= "javax.sql.*,java.io.*" %>
<html><head></head>
<body>
<% try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection con =
DriverManager.getConnection("jdbc:odbc:aidbora","aidb","aidb");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from
employee");
while (rs.next()) {
String emp=rs.getString(2);
System.out.println("emp name:" + emp);
} %>
<p>Employee name for this<%=emp%>
<% } catch(Exception ex) {
System.out.print("SQLException: ");
System.out.println(ex.getMessage());
}
} %>
</body></html>
i have some errors with this code.
Error: 500
Internal Servlet Error:
org.apache.jasper.compiler.ParseException:
C:\gan1.jsp(0,4) Invalid directive
at
org.apache.jasper.compiler.Parser$Directive.accept(Parser.java:174)
at
org.apache.jasper.compiler.Parser.parse(Parser.java:984)
at
org.apache.jasper.compiler.Parser.parse(Parser.java:959)
at
org.apache.jasper.compiler.Parser.parse(Parser.java:955)
at
org.apache.jasper.compiler.Compiler.compile(Compiler.java:140)
at
org.apache.jasper.runtime.JspLoader$2.run(JspLoader.java:271)
at java.security.AccessController.doPrivileged(Native
Method)
at
org.apache.jasper.runtime.JspLoader.loadJSP(JspLoader.java:269)
at
org.apache.jasper.runtime.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:142)
at
org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:153)
at
org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:243)
at
org.apache.jasper.runtime.JspServlet.service(JspServlet.java:348)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:868)
at
org.apache.tomcat.core.ServiceInvocationHandler.method(ServletWrapper.java:621)
at
org.apache.tomcat.core.ServletWrapper.handleInvocation(ServletWrapper.java:529)
at
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:373)
at
org.apache.tomcat.core.Context.handleRequest(Context.java:648)
at
org.apache.tomcat.server.ConnectionHandler.run(ConnectionHandler.java:205)
pls help me asap.
praveen
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
