connect jboss to db2 on IMS (mainframe)

[leier]

I am looking for some documentation on how to configure a datasource to connect to db2 on IMS from Jboss 4.2.2 on linux. Is this possible? If there is info already posted, pls let me know as there seems to be no applicable information.

[vickyk]

"leier" wrote:
If there is info already posted, pls let me know as there seems to be no applicable information.

Did you searched it here ?

[leier]

Yes, I can find plenty of info on DB2 UDB, but nothing on DB2 for IMS (mainframe DB2)

[vickyk]

"leier" wrote:
Yes, I can find plenty of info on DB2 UDB, but nothing on DB2 for IMS (mainframe DB2)

Ok , have you been able to connect to this DB using java as standalone application ?
I am trying to understand if there is a java driver available for connecting to this DB , if it is available then things would be simpler from the JBoss side .

[leier]

I am considering a few issues here. Mainly, for a udb db2 connection, you specify the database instance owner/user, and a password. i.e. :

<local-tx-datasource>
<jndi-name>datasource_name</jndi-name>
<connection-url>jdbc:db2://server:port/database</connection-url>
<driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
<user-name>username</user-name>
password
................



But for a mainframe db2 connection, a user authenticates to a db and schema with an individual logon and password from a racf (or similar authentication) backend. So in that case, I am wondering how to pass on a unique logon and password to the already defined datasource.

[vickyk]

"leier" wrote:
So in that case, I am wondering how to pass on a unique logon and password to the already defined datasource.

Looks to me that you want reauthentication feature whose details are here
http://jira.jboss.com/jira/browse/JBAS-1429