| Author |
Message
|
| Sowmiya |
 Posted: Fri Aug 16, 2013 4:55 am Post subject: Broker JDBC connectivity issue while using new JDBCProvider |
 |
|
Newbie
Joined: 16 Aug 2013
Posts: 4
|
Hi,
I am on WMB8.0.0.0 and JRE6. I am trying to create a type4JDBC connection for the broker to talk to a SAP HANA remote database. For this I have created a new JDBCProvider(as built-in not available) and copied the driver ngdbc.jar into broker installation path. I have set the user-id and password to my security identity also.
But when I try running this, for some strange reason, I keep getting an exception saying 'Incorrect username or password'. I can see in the debug trace that my username is getting replaced in the connection URL correctly but my password is not displayed. So I tried running a JDBC trace at the URL level and got the below trace.
new Connection 'jdbc:sap://<ip>:30015/'
autocommit=false
TRACE STOP ON ERROR OFF:user=Myuser;password=Mypassword;
trace=C:\Sowmiya\traceFile.txt
HOSTLIST: [10.128.218.5:30015,]
Property: java.security.auth.login.config=C:\Program Files\IBM\MQSI\8.0.0.0\classes\wsjaas.conf
Property: javax.security.auth.useSubjectCredsOnly=not set
Using current access context subject
Reject authentication method GSS
Timestamp: 2013-08-15 12:39:44.023com.sap.db.jdbc.exceptions.jdbc40.SQLNonTransientConnectionException: Error using GSS authentication [org.ietf.jgss.GSSException, major code: 13, minor code: 0
major string: Invalid credentials
minor string: SubjectCredFinder: no JAAS Subject].
at com.sap.db.jdbc.exceptions.jdbc40.SQLNonTransientConnectionException.createException(SQLNonTransientConnectionException.java:40)
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:241)
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateSQLException(SQLExceptionSapDB.java:136)
at com.sap.db.util.security.GSSAuthentication.getInitialDataInternal(GSSAuthentication.java:373)
at com.sap.db.util.security.GSSAuthentication.getInitialData(GSSAuthentication.java:344)
at com.sap.db.util.security.AuthenticationManager.authenticate(AuthenticationManager.java:74)
at com.sap.db.jdbc.ConnectionSapDB.openSession(ConnectionSapDB.java:570)
at com.sap.db.jdbc.ConnectionSapDB.doConnect(ConnectionSapDB.java:440)
at com.sap.db.jdbc.ConnectionSapDB.<init>(ConnectionSapDB.java:199)
at com.sap.db.jdbc.ConnectionSapDBFinalize.<init>(ConnectionSapDBFinalize.java:13)
at com.sap.db.jdbc.Driver.connect(Driver.java:255)
at com.ibm.broker.jdbcnodes.JDBCConnection.createConnection(JDBCConnection.java:272)
at com.ibm.broker.jdbcnodes.JDBCDatabaseManager.getThreadOwnedConnections(JDBCDatabaseManager.java:623)
at com.ibm.broker.jdbcnodes.DatabaseRetrieveNode.evaluate(DatabaseRetrieveNode.java:398)
at com.ibm.broker.plugin.MbNode.evaluate(MbNode.java:1472)
Does this make any sense to anyone? I have been tryin for a while to find out how to reset javax.security.auth.useSubjectCredsOnly to false as I understand it is a default jvm property. Has anyone tried setting-up a JDBC connectivity and faced the same (or similar) issue? Thanks!!
Note : I have masked the ip address and credentials purposely. |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Fri Aug 16, 2013 4:57 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| Sowmiya |
| Posted: Fri Aug 16, 2013 5:04 am Post subject: |
|
|
Newbie
Joined: 16 Aug 2013
Posts: 4
|
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Aug 16, 2013 5:10 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
No this is not true. JDBC type IV connections are limited to Oracle or DB2.
To interface with SAP, you should be using the SAP nodes. Directly accessing the SAP database would never work, as SAP performs business coordination on business objects before it persists those objects in the SAP datastore. Therefore, if you bypass this business processing by connecting to the SAP datastore directly, you will break the SAP business layer. Thats why WMB has SAP nodes so you can safely connect to SAP and read/write to the SAP datastore through the SAP business layer.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Sowmiya |
| Posted: Fri Aug 16, 2013 6:48 am Post subject: |
|
|
Newbie
Joined: 16 Aug 2013
Posts: 4
|
But I am not connecting to a SAP datastore. I am connecting to the SAP HANA database. SAP HANA is the data warehousing variant and my database is actually not in the business layer. It receives data from SAP-ECC periodically.
And the reason why I am trying to connect directly to the database is because I need to send some frequent, time critical information to my downstream systems. Reading the table seemed like the only option. And I would only read a table and not write to it. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Aug 16, 2013 6:52 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Sowmiya wrote: |
But I am not connecting to a SAP datastore. I am connecting to the SAP HANA database. SAP HANA is the data warehousing variant and my database is actually not in the business layer. It receives data from SAP-ECC periodically.
And the reason why I am trying to connect directly to the database is because I need to send some frequent, time critical information to my downstream systems. Reading the table seemed like the only option. And I would only read a table and not write to it. |
You cannot use JDBC type IV to do this.
These are the supported databases by WMB:
http://publib.boulder.ibm.com/infocenter/wmbhelp/v8r0m0/index.jsp?topic=%2Fcom.ibm.etools.mft.doc%2Fah10030_.htm
| Quote: |
| DB2®1, 2 Informix®5 Microsoft SQL Server1 Oracle1, 3, 4 solidDB® Sybase1 |
You must use DataDirect drivers provided with WMB to connect to any database.
JDBC Type IV:
| Quote: |
| On distributed platforms, only DB2 and Oracle are supported. |
Web Services is your better bet for time-sensitivity.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mgk |
| Posted: Fri Aug 16, 2013 6:59 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
So that this statement is not really correct - it is only correct for XA connections
| Quote: |
| JDBC Type 4 database connections are only supported for DB2 or Oracle. No other databases are supported. |
Looking at this part of the docs shows other JDBC providers that are also supported (basically the same list as the ODBC ones):
http://publib.boulder.ibm.com/infocenter/wmbhelp/v8r0m0/topic/com.ibm.etools.mft.doc/ah61310_.htm
However, SAP is not one of them. You could raise a requirement to request support if you need it here: https://www.ibm.com/developerworks/rfe/
Kind regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| Sowmiya |
| Posted: Fri Aug 16, 2013 7:48 am Post subject: |
|
|
Newbie
Joined: 16 Aug 2013
Posts: 4
|
Hi MGK,
Thanks for the response. I guess then I should go ahead raise a request through my organisation and look for an alternative option for this requirement.
Thank you both!! |
|
| Back to top |
|
|
|
|
