> String username=user_xx;
> String password=xxx;
Give the user name and password within quotes like this.
String username="user_xx";
String password="xxx";
Hari
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 8:53 PM
Subject: Problems when connecting JSP and Oracle
Hi!
I am trying to publish this page:
----------------//------------
<html>
<body>
<%@ page import="java.sql.*" %>
<%
String url = "jdbc:pool:oracle:thin:@localhost:1521:MY_DB";
String username=user_xx;
String password=xxx;
Connection conn = DriverManager.getConnection(url, username,
password);
Statement stat = conn.createStatement();
ResultSet result = stat.executeQuery("SELECT * FROM MY_TABLE");
result.next();
int n = result.getInt(1);
result.close();
n++;
stat.executeUpdate("UPDATE DBTest SET Tested = " + n);
%>
<p>Database test executed <%= n %> times.</p>
<%
conn.close();
%>
</ul>
</body>
</html>
But I get this error:
org.apache.jasper.JasperException: Unable to compile class for
JSP/usr/lib/jakarta-tomcat-3.2.3/work/localhost_8080/_0002fdb_0002ejsp
db_jsp_1.java:65: Undefined variable: user_xx
String username=user_xx;
^
/usr/lib/jakarta-tomcat-3.2.3/work/localhost_8080/_0002fdb_0002ejspdb_
jsp_1.java:66: Undefined variable: xxx
String password=xxx;
What am I doing wrong?
---------------------------------------------------------
This mail was sent through Eoffice: http://www.eoffice.dk
