MSSQL invalid object name Error, but it exist!
843854May 14 2004 — edited May 14 2004I 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());}