Tables created in Java applications don't appear in HANA Admin. console

[Former Member]

Hello,

I'm trying to create database tables in Java applications running on the HCP using JPA, but when checking on the HANA Administration Console from Eclipse, the tables don't appear. I'm creating tables like the example on the "Introduction to SAP HANA Cloud Platform (repeat) - week 2" (and as explained here). I create Entity class, ejb class, add the entity class to persistence.xml, and the tables do appear on the JPA diagram. But after republishing, restarting the server and refreshing, the new tables don't appear on the HANA Administration console.

The only way I managed to see the new tables is deleting the server (java application) and the schema from the cockpit, creating them again and importing them back into the HANA Administration console, but that can't be the solution to the problem.

Can anyone tell me how to make the tables appear in the HANA Administration Console?

Perhaps a tunnel connection to the database might help?

[Vlado · Accepted solution]

Since you say "new tables", I understand that you are adding new JPA entities to an existing project, and republishing it. If that's the case, and if you have selected the DDL generation type Create Tables in persistence.xml as described in the linked help page, EclipseLink will not create a new schema since it's already been created. In order to get the new schema created, you have to select the DDL generation type Drop and Create Tables. However, keep in mind that this will delete all data stored in the existing tables.

HTH!

[Former Member · Accepted solution]

Thanks for the answer.

We eventually decided to use JDBC instead.