I installed TimesTen 11.2.1.8.0 on AIX 5.3 using system user "oracle". I created another application user "risk" to use in my application with TimesTen.
When running my app with user "risk" to connect with TimesTen it is OK. But when I want to use the feature XLA, when I invoke function createDurableSubscriber, it returns error
javax.jms.JMSException: SQLDriverConnect failed (XlaCommon.c, line 48): S1000 7001 [TimesTen][TimesTen 11.2.1.8.0 ODBC Driver][TimesTen]TT7001: User authentication failed -- file "db.c", lineno 9722, procedure "sbDbConnect"
It is strange that if I switch to user "oracle", it works fine.
Can anyone please help to figure out the reason why.
Thanks