• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • 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
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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