File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
It's not a secret anymore!