|
-
Error in java sql
I am running the following code in JSP and I am receiving the error message:
"sun.jdbc.odbc.JdbcOdbcResultSet@1627086 "
String sql1 = "SELECT employeeID, groupPolicyNo FROM employee WHERE employeeID = 9;";
Statement stmtAdmin =con.createStatement();
ResultSet res = stmtAdmin.executeQuery(sql1);
out.println(res);
// the next query finds all the employees who have that group policy no.
String sql2 = "SELECT employeeID, groupPolicyNo FROM employee WHERE groupPolicyNo = "+res+" ;";
Statement stmt =con.createStatement();
ResultSet rs = stmt.executeQuery(sql2);
out.println(rs);
These queries are running perfectly in the database but not on the browser,
Can any one shed some light?
Similar Threads
-
By Lori Piquet in forum Talk to the Editors
Replies: 114
Last Post: 10-10-2002, 06:01 AM
-
Replies: 3
Last Post: 06-28-2002, 07:36 AM
-
By Kirsten Darrow in forum Web
Replies: 0
Last Post: 12-08-2000, 06:23 AM
-
Replies: 2
Last Post: 11-16-2000, 09:09 PM
-
By Devaraj in forum Enterprise
Replies: 0
Last Post: 05-11-2000, 12:48 PM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks