Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MSSQL invalid object name Error, but it exist!

843854May 14 2004 — edited May 14 2004
I have a table named Member
When I execute this code the query gives an error that says "[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'Member' ". When I create the table from my class, then this code does NOT give a problem but I cannot see the created table in MSSQL Enterprise Manager, this time manager does not see the table! Help me I will give all the DUke dollars I can when I achieve to solve the problem
try{
ConnectionPool cp = ConnectionPool.getInstance();
Connection con = cp.getConnection();
Statement stmt = con.createStatement();
if(stmt == null)
{
System.out.println("Statement is null");
}
ResultSet rs = stmt.executeQuery("select m.mid from Member m where m.mname = "+
"'?zer Akarg?n' and m.mem_password = 'jsqlp'");
int i=0;
while(rs.next())
{
i++;
System.out.println("Resultset column: "+i+" row: 1 ---->"+rs.getString(1));
}
}catch(Exception ex){System.out.print(ex.getMessage());}
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2004
Added on May 14 2004
3 comments
712 views