Can't find tables created by JPA in HCP Catalog

[Former Member]

Hi experts,

I have created some tables using JPA on eclipse and deployed the Java application to HCP.

I have bound the application with an hana instance on the cockpit, and created an XS application for the instance.

But in the web-based development workbench catalog, there is no tables under the schema "DEV_******".

Could you tell me how to access the tables? Thank you.

Best regards,

Ziqian

[anton_levin · Accepted solution]

Hi Ziqian,

tables are created under user schema which is a NEO_* one.

Regards,

Anton

[Former Member · Accepted solution]

Hi Anton,

There are no tables under NEO_*** schema. I'm using the trial account, would that be a reason?

Thank you.

Best regards,

Ziqian

[anton_levin · Accepted solution]

Trial is not a problem. Make sure that your app really creates tables (all necessary SQL statements are executed without errors etc)

Regards,

Anton

[Former Member · Accepted solution]

Hi Anton,

There is an authentication error I never met before. Could you help me have a look at it? Thank you.

2016 01 13 17:50:00#+00#ERROR#com.sap.core.persistence.osgi.config.pool.trace.PoolLogger#BC-NEO-PERS#anonymous#http-bio-8041-exec-1#com.sap.core.persistence.osgi.config#i850532trial#iotnestjava3#web#i850532trial#[10]: authentication failed

com.sap.db.jdbc.exceptions.jdbc40.SQLInvalidAuthorizationSpecException: [10]: authentication failed

  at com.sap.db.jdbc.exceptions.jdbc40.SQLInvalidAuthorizationSpecException.createException(SQLInvalidAuthorizationSpecException.java:40)

  at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:301)

  at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:185)

  at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:102)

  at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1030)

  at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:820)

  at com.sap.db.util.security.AbstractAuthenticationManager.connect(AbstractAuthenticationManager.java:43)

  at com.sap.db.jdbc.ConnectionSapDB.openSession(ConnectionSapDB.java:569)

  at com.sap.db.jdbc.ConnectionSapDB.doConnect(ConnectionSapDB.java:421)

  at com.sap.db.jdbc.ConnectionSapDB.<init>(ConnectionSapDB.java:174)

  at com.sap.db.jdbc.ConnectionSapDBFinalize.<init>(ConnectionSapDBFinalize.java:13)

  at com.sap.db.jdbc.Driver.connect(Driver.java:235)

  at com.sap.db.jdbcext.DataSourceSAPBase.openPhysicalConnection(DataSourceSAPBase.java:350)

  at com.sap.db.jdbcext.DataSourceSAP.getConnection(DataSourceSAP.java:39)

  at com.sap.core.persistence.jdbc.trace.TraceableDataSource.getConnection(TraceableDataSource.java:79)

  at org.apache.commons.dbcp.DataSourceConnectionFactory.createConnection(DataSourceConnectionFactory.java:43)

  at com.sap.core.persistence.osgi.config.pool.PoolableConnectionFactoryAdapter.makeObject(PoolableConnectionFactoryAdapter.java:166)

  at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)

  at com.sap.core.persistence.osgi.config.pool.trace.TraceableGenericObjectPool.borrowObject(TraceableGenericObjectPool.java:36)

  at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)

  at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:123)

  at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)

  at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:204)

  at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:741)

  at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:239)

  at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685)

  at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:204)

  at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:304)

  at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:336)

  at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:302)

  at nest.DataHelper.addClientConnection(DataHelper.java:28)

  at nest.NestServlet.doGet(NestServlet.java:103)

  at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)

  at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

  at com.sap.core.communication.server.CertValidatorFilter.doFilter(CertValidatorFilter.java:324)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)

  at com.sap.core.jpaas.security.auth.service.lib.AbstractAuthenticator.invoke(AbstractAuthenticator.java:205)

  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

  at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)

  at com.sap.core.tenant.valve.TenantValidationValve.invokeNextValve(TenantValidationValve.java:168)

  at com.sap.core.tenant.valve.TenantValidationValve.invoke(TenantValidationValve.java:92)

  at com.sap.js.statistics.tomcat.valve.RequestTracingValve.invoke(RequestTracingValve.java:24)

  at com.sap.core.js.monitoring.tomcat.valve.RequestTracingValve.invoke(RequestTracingValve.java:25)

  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)

  at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)

  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)

  at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

  at java.lang.Thread.run(Thread.java:812)

[anton_levin · Accepted solution]

Which jars do you have in your WAR file under WEB-INF/lib?

[Former Member · Accepted solution]

Hi Anton,

I have com.sap.security.core.server.csi_1.0.1.jar, eclipselink-2.5.1.jar, gson-2.3.jar, javax.persistence-2.1.0.jar.

Best regards,

Ziqian

[anton_levin · Accepted solution]

And RT you use is Java EE 6 Web Profile runtime, right? Did you try to deploy a sample app available in SDK under samples/persistence-with-jpa ? If that one works for you it would be easy to compare 2 projects and identify the issues. It is hard to say for now what might be wrong.

Regards,

Anton

[Former Member · Accepted solution]

Hi Anton,

Thank you for your reply. I will try it first.

Best regards,

Ziqian