You would require to change the connection.properties file of your local Tomcat Server (Server > Java Web Tomcat 8 Server-config/config_master/connection_data), to point to the HANA database.Here are the usual parameters that need to be configured for HANA databasejavax.persistence.jdbc.driver=com.sap.db.jdbc.Driver javax.persistence.jdbc.url=jdbc:sap://:/?reconnect=true&autocommit=false javax.persistence.jdbc.user=db-user javax.persistence.jdbc.password=db-pass eclipselink.target-database=HANA

I faced a similar issue earlier but it was because of a bug in JAVA security package (refer link for more details)http://bugs.java.com/bugdatabase/view_bug.do?bug_id=7044060I just got updated myself to latest OpenJDK7 and it solved my issue. I think you can try the same and check if it helps.

Using SAP GUI, you can only access ABAP or ABAP+Java based system. You can check at multiple places if it is a dual system.T-code: SMICM, you can checklist of services in transaction SMICM (Goto --> Services) - dual stack systems will have the J2EE services listed too. There will also be an AS Java menu in SMICM on ABAP+Java systems.

When you use Java connector you need basic authorization to read metadata of Function Module. S_RFC is an authorization object for the RFC call.This object contains the following fieldsRFC_TYPE Type of the RFC object you want to protect. You can pass the value 'FUGR'- function group) or 'FUNC'- function module.RFC_NAME Name of RFC to be protected. This file contains a value of the function group or of function modules.CTVT ActivityThis field may take the value 16.In case you want a user to be able to call function modules in-group 'ABCD' remotely, following user authorization is required          ... Read More

As per my understanding,  the only way to get the MQ jar files or the MQ C/C++ library files onto a system is by installing any of the below:Using WebSphere MQ product orUsing WebSphere MQ Client SupportPacsYou can find jar file under WebSphere MQ V7.0 Clients SupportPacks. The install files are commonly available under java/lib directory.You can try installing jar files from Fix Central. Go to Fix Central and enter "Java" in the Text search box.https://www-945.ibm.com/support/fixcentral/swg/identifyFixes?query.parent=ibm~WebSphere&query.product=ibm~WebSphere~WebSphere%20MQ&query.release=9.0&query.platform=AllThe name of the file to be downloaded is in this format:-[IBM|WS]-MQ-Install-Java-All.jar.For example, for MQ V9.0:9.0.0.0-IBM-MQ-Install-Java-All.jar.You have the following files that can be moved to ... Read More

I would suggest you to use below instead of JCO_AHOST and JCO_SYSNR:Use JCO_R3NAME with system ID of the target hostUse JCO_MSHOST with message server host name or IP addressUse JCO_MSSERV with message server port numberUse JCO_GROUP with the name of the logon groupYou can refer to below link to check a working example:https://sourceforge.net/p/rcer/git/ci/master/tree/net.sf.rcer.conn