Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

eclipse database perspective error


Hello there,

when i right click on the table and select to view the table i get a error.i have attached a screenshot.please help.

cheers
zolf
Capture.GIF
0
zolf
Asked:
zolf
  • 4
  • 3
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
zolf,

Since you have asked this here, I am guessing you have confirmed the table does exist in the dbo schema. Therefore, other causes include permissions and invalid connection. You can try disconnecting and reconnecting to the database and see if that refreshed reference to the table. In the process, ensure that the Login has access to that particular table.

Regards,
Kevin
0
 
zolfAuthor Commented:

thanks for your comment.

>>I am guessing you have confirmed the table does exist in the dbo schema.
as you can see in the screenshot i have posted,it is in dbo.

>>In the process, ensure that the Login has access to that particular table.
i can connect to the db from sql management studio.
0
 
Kevin CrossChief Technology OfficerCommented:
I can see that Hibernate thinks it is in dbo, but I meant in SSMS if it was actually in there. Did you try disconnecting the data connection in Eclipse and reconnect?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
zolfAuthor Commented:
>>Did you try disconnecting the data connection in Eclipse and reconnect?
yes i tried,but no luck.please help
0
 
zolfAuthor Commented:

i have attached screenshot of the table in SSMS
Capture.GIF
0
 
Kevin CrossChief Technology OfficerCommented:
I cannot seem to duplicate this error at all. Try deleting the database connection and recreating. I just connected to a SQL Server with same version (10.50.1600) using the following:

Microsoft SQL Server 2008 JDBC Driver
JAR: sqljdbc4.jar (defaulted to sqljdbc.jar)
URL: jdbc:sqlserver://{servername}:1433;databaseName={database}
0
 
zolfAuthor Commented:
thanks a lot.it worked when i deleted and recreated the db.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now