EclipseLink can't discover all the SQL 2005 tables
posted 6 years ago
I having problem to create entities from tables. The problem is I can create for some of them, but around 10% of tables can't be created automatically (Via Eclipse) or manually. Here is the details:
Mac Pro with i7 processor, with java 1.6 & Eclipse Helios installed.
Connector: sqljdbc4.jar, EclipseLink: 2.1.1
SQL 2005 server on remote machine in same network.
The error message:
Column "xxx" can't be resolved on table "xxxxxxxxxxxxx", even Data Source Explorer can't see the columns. But query via Sql Scrapbook(Eclipse build-in) is fine.
That table have around 25 columns, with around 200 records in that.