java.sql.SQLException [Microsoft] [ODBC SQL Server Driver] [SQL Server] Invalid object name 'table name'

Question

When I connect Java to Mssql using JDBC ODBC driver

try 
{
    ps=conn.prepareStatement("UPDATE products SET stock=? WHERE id=?");

    ps.setInt(1, prods.getStock());
    ps.setInt(2, prods.getId());

    int b = ps.executeUpdate();

    if(b!=0)
    {
        System.out.println("success");
    }
    else
    {
        System.out.println("Fail");
    } 
}
catch(SQLException e)
{
    System.out.println(e);
}

This catch block rises this exception

java.sql.SQLException [Microsoft] [ODBC SQL Server Driver]
  [SQL Server] Invalid object name 'products'

I am working on this part from last 2 days. How I will solve this exception?

Maybe you selected a wrong DB? Can you show how the connection is created? — hage
– hage, Commented May 16, 2012 at 11:39
i already used that UPDATE[products] i am getting the same error — pardhu
– pardhu, Commented May 16, 2012 at 12:08

juergen d · Accepted Answer · 2012-05-16 11:40:11Z

5

This error message is thrown when the table can't be found. That can have several reasons:

you are connecting to a different DB
the table was deleted
the table is in another DB schema
your user does not have read permissions on that table any more

answered May 16, 2012 at 11:40

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

pardhu Over a year ago

table is exists and database is also same , but still it is giving error.

pardhu Over a year ago

here i am using windows authentication is there any problem with that?

juergen d Over a year ago

@pardhu: Does your windows user have rights in your MSSQL Server? You can check that if you connect with that user to your DB using MS SQL Studio and try to browse the table you need.

pardhu Over a year ago

i am browsing that table and watching those data is all possible, then which rights i need here?

juergen d Over a year ago

@pardhu: Could you show your connection string? Also are you sure that the table is in the default schema of your user?

Charleh · Accepted Answer · 2012-05-16 14:05:58Z

1

I'd imagine that your connection string has no default database - you are probably connecting to 'master' in which case the above won't work

You can test this by qualifying your query with the database and schema name:

e.g.

ps=conn.prepareStatement("UPDATE [YourDatabaseName].[schema].products SET stock=? WHERE id=?");

put your values in where needed (standard default schema is 'dbo' eg. ProductsDatabase.dbo.products)

If this works then your connection string is incorrect

answered May 16, 2012 at 14:05

Charleh

14k3 gold badges41 silver badges58 bronze badges

2 Comments

pardhu Over a year ago

i write using this query "master.dbo.products" here also i am getting same error.please help me

Charleh Over a year ago

Is the product table in the 'master' database or another database? I would expect that you created a new database for the table, in which case you should not put master.dbo.products but <productsdatabasename>.dbo.products - can you show your connection string?

James Reeves · Accepted Answer · 2012-05-16 11:42:07Z

0

Normally this exception is thrown if the table does not exist, or that there is an error with the connection string. Maybe not connecting to the correct database?

answered May 16, 2012 at 11:42

James Reeves

972 silver badges13 bronze badges

1 Comment

pardhu Over a year ago

here i am using windows authentication is there any problem with that?

Rebeccah · Accepted Answer · 2017-04-24 15:00:03Z

0

I ran into similar issue. Cause of the issue in my case was the user running the report has the DEFAULT_DATABASE pointing to the master database, after changing it to the right database it was able to locate the object.

Thanks

answered Apr 24, 2017 at 15:00

Rebeccah

1

Collectives™ on Stack Overflow

java.sql.SQLException [Microsoft] [ODBC SQL Server Driver] [SQL Server] Invalid object name 'table name'

4 Answers 4

5 Comments

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related