Skip to Content
0
May 03, 2018 at 01:20 PM

Using Tomee trying to connect to an existing db-modul

112 Views Last edit May 25, 2020 at 12:53 PM 2 rev

I want to deploy a Java module in a TomEE environment using a data base connection to our HANA DB. The Java module is providing a REST api (no OData). The deployment using the XS CLI tools is finalized successfully (see Deploy-Log.png).

But at runtime also a simple SQL statement like "select * from DUMMY" is failing with: "org.apache.cxf.interceptor.Fault: user lacks privilege or object not found: DUMMY {SELECT * from DUMMY} [code=-5501, state=42501]". In the debugger i can see a injected DataSource using a HSQLDB driver; expected is the HANA JDBC driver?! So i assume that i got a wrong data source provided by TomEE. The definition of the data source in TomEE is following the informations taken from the developer guide, so i have no idea what's wrong with my configuration. The context in the DB module is annotated with @OData.publish: true. Currently no security is in effect, because we have only a Java- and a DB module, no UI.