It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Invalid Object Name Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Invalid Object Name" Watch "Invalid Object Name" New topic

Invalid Object Name

Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I am working on a web application which involves MS SQL Server 7.0 at the backend.
I am also using the jdbc-odbc bridge to connect to the database.
The database has a table called PersonalProfile.
The JSP goes like this : -
<TITLE>Data Base testing</TITLE>
This is the list of employees
<%@ page import="java.sql.*, java.util.*,*,*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");<br /> String url = "jdbc dbc:dbEIS";<br /> String user=null;<br /> String password = null;<br /> Connection con = DriverManager.getConnection(url, user, password);<br /> Statement stmt = con.createStatement();<br /> String Query = "Select FirstName from Administrator.PersonalProfile";<br /> <br /> ResultSet rs = stmt.executeQuery(Query);<br /> while ( {<br /> %>
<%= rs.getString(1); %>

<% } %>
This is giving me an error that "Invalid Object Name PersonalProfile". I have checked that there is a table called PersonalProfile in the database dbEIS.
Please help me. I am stuck.
I agree. Here's the link:
subject: Invalid Object Name
jQuery in Action, 3rd edition