Eclipse Community Forums: e(fx)clipse » dbo schema is hidden when connecting to sql server 2012 (RTM) with jdbc 4.1 in eclipse

Home » Eclipse Projects » e(fx)clipse » dbo schema is hidden when connecting to sql server 2012 (RTM) with jdbc 4.1 in eclipse(JPA entities from tables in sql 2012 can't be generated)

Show: Today's Messages :: Show Polls :: Message Navigator

dbo schema is hidden when connecting to sql server 2012 (RTM) with jdbc 4.1 in eclipse [message #1710077]

Sat, 03 October 2015 20:55

besmart besmart

Messages: 1
Registered: October 2015

Junior Member

I use Jdbc 4.2 downloaded from microsoft download site
to connect with SQL server 2012 standard from within eclipse MARs v4.5.0 .
I can run query with database and return results in eclipse , but i can't generate JPA entities from tables because all tables are in dbo schema, and dbo schema is hidden .
Dbo schema is completely hidden in all databases in the server.

i used a third party Jdbc and all schema are available including dbo and i can generate entites from table.
i checked the jdbc with sql 2008 server and it is working fine.

The attached file msjdbc.png show the bug in case of using ms jdbc , the other third-party-jdbc.png show the normal case without bug.

my question : how to resolve this problem ? Is there a bug in eclipse with jdbc 4.2 for sql server 2012 ?
i googled many hours and i can't find a solution.

Attachment: msjdbc.png
(Size: 67.34KB, Downloaded 223 times)
Attachment: third-party-jdbc.png
(Size: 82.13KB, Downloaded 152 times)