Search code examples
javaeclipsehibernatejpateradata

Columns not loading in Data Source Explorer or JPA Generate Custom Entities Wizard in Eclipse


I am trying to generate a JPA Entity class based on a table in a Teradata database using the JPA Tools in Eclipse. My Eclipse version is Luna 4.4.1. I've established a connection to the database via JDBC and I'm able to load my schema in the Data Source Explorer. I've also successfully executed queries from the SQL Scrapbook.

The Data Source Explorer sees my schema, and all of the tables in the schema, however when I click the drop down for the Columns, nothing appears.

The closest question I've seen so far is this: EclipseLink and JPA columns of table not showing up

However, my issue is that no columns appear when I expand the nodes of the tree.

When I attempt to create my Entity class using the Generate Custom Entity Wizard, I can select the schema and select tables from the schema, but none of the columns load.

Has anyone seen this before?


Solution

  • To anyone else who comes this way looking for an answer, I did figure it out.

    The User that you use for your database connection in Eclipse needs to have SELECT privileges on DBC.