hi,
Thanks to Carsten Heyl for solving the dbaccess problem.
Iam using JavaServer (tm) Web Development Kit
Version 1.0 Early Access
I was following the jsp syntax (jsp1.0) as giving by the sun site.
the page tag given in it is as "<%@ page language="java"
import="java.sql.*"%>"
but the page was unable to import the java.sql.* resulting in a compilation
error.
But when i changed it to imports i.e "<%@ page language="java"
imports="java.sql.*"%>"
(as suggested by carsten) it worked.
just wanted to let u guys who have just started off !!
rds,
naveen
----- Original Message -----
From: Chuthari Srinivas <[EMAIL PROTECTED]>
To: naveen <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, September 23, 1999 1:51 AM
Subject: Re: dbaccess problem
| Naveen..,
|
| If there is any problem with sql import the error should come at the
Connection
| statement it self. Can u send me the sever log....?
|
| Regards
| Sreeni
|
| naveen wrote:
|
| > hi,
| >
| > I get "HTTP 500 - Internal server error "
| > The page is not getting displayed.
| >
| > I looked up the temporary servlet formed in the work directory.
| > but it does'nt seem to include the java.sql.* while importing.
| >
| > hence the below error is ocurring in the dos prompt(server log).
| >
| > work\%3A8080%2Fexamples\myappmain_jsp_1.java:56: Class
| > C_0003a.javawebserver.jsw
| > dk.examples.jsp.myapp.ResultSet not found.
| > ResultSet rs=st.executeQuery("Select
| > Name,ID,Place,Dgn from employee");
| > ^
| > how do i make the servlet formed include the java.sql .*..
| > the import statement in the page tag is not getting recognised..
| >
| > any directions would be most helpful
| >
| > thanks
| > naveen
| >
| > ----- Original Message -----
| > From: Carsten Heyl <[EMAIL PROTECTED]>
| > To: naveen <[EMAIL PROTECTED]>
| > Cc: < >
| > Sent: Wednesday, September 22, 1999 11:55 PM
| > Subject: Re: dbaccess problem
| >
| > |
| > | >hi,
| > | >This might seem a bit trivial,but i am just not able to connect to a
db
| > | >i have set the classpath to tools.jar as well as jsdk.jar...
| > | >JSP's code works fine except for recognising the sql related
keywords..
| > | >i know it has got to do with importing java.sql packages ,but it is
not
| > | >happening..
| > |
| > | So what DOES happen on your code below?
| > | Compile time error?
| > | Exceptions?
| > |
| > | >here is the code below...can anyone show me where the problem might
be..
| > | >thanks,
| > | >naveen
| > | >
| > | ><HTML>
| > | >
| > | ><HEAD><TITLE>
| > | >A JSP APPLICATION
| > | ></TITLE></HEAD>
| > | ><BODY BGCOLOR="white">
| > | >
| > | ><%out.println("it prints");%>
| > | ><%@ page language="java" import="java.sql.*" %>
| > | >
| > | ><%
| > | > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
| > | > Connection c =
| > DriverManager.getConnection("jdbc:odbc:naveen","dba","sql");
| > | > Statement st=c.createStatement();
| > | > ResultSet rs=st.executeQuery("Select Name,ID,Place,Dgn from
employee");
| > | >
| > | >%>
| > | ><table>
| > | > <% while(rs.next())
| > | > { %>
| > | > <tr>
| > | > <td><%=rs.getInt("ID")%></td>
| > | > <td><%=rs.getString("Name")%></td>
| > | > <td><%=rs.getString("Place")%></td>
| > | > <td><%=rs.getString("Dgn")%></td>
| > | > </tr>
| > | >
| > | > <%}%>
| > | > </table>
| > | >
| > | >
| > | ></BODY>
| > | ></HTML>
| > | >
| > |
| >
===========================================================================
| > | >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
| > |
| > | Ciao,
| > | Carsten Heyl
| > |
| > | Carsten Heyl [EMAIL PROTECTED]
| > | NADS - Solutions on Nets http://www.nads.de/
| > | NADS GmbH http://www.pixelboxx.de/
| > | Hildebrandtstr. 4E Tel.: +49 211 933 02-90
| > | D-40215 Duesseldorf Fax.: +49 211 933 02-93
| >
| >
===========================================================================
| > 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
|
===========================================================================
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
