Topic
  • 2 replies
  • Latest Post - ‏2013-04-19T15:23:20Z by fjb_saper
SystemAdmin
SystemAdmin
4179 Posts

Pinned topic jdbcprovider for as400 db2

‏2009-07-24T14:56:59Z |
hi everybody , I have configured as400 JDBCProvider into my broker , setup like this

JDBCProviders
AS400DS3
connectionUrlFormat='jdbc:as400://serverName;user=user;password=[passwor
d];'
connectionUrlFormatAttr1=''
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='STALIBRP'
databaseType='default_Database_Type'
databaseVersion='default_Database_Version'
description='default_Description'
jarsURL='C:\driver_jt400'
portNumber='default_Port_Number'
securityIdentity='asp3'
serverName='10.10.229.121'
type4DatasourceClassName='com.ibm.as400.access.AS400JDBCXADataSource'
type4DriverClassName='com.ibm.as400.access.AS400JDBCDriver'

When i try to connect in a java node with the code

Connection conn = getJDBCType4Connection("AS400DS3", JDBC_TransactionType.MB_TRANSACTION_AUTO);

I get error :
( WBRK61_DEFAULT_BROKER.flowsGoupsTest ) An error occurred in node: 'JavaCompute' There was a problem establishing a connection to the given database URL: 'datasource URL = jdbc:as400://10.10.229.121;user=DDSBVCMAE;password=********;' Exception details: 'The application requester cannot establish the connection.'

The node was unable to establish a connection to the given database URL.

Contact your WebSphere Message Brokers administrator.
Maybe the cause could be the connectionUrlFormat is not correct .Somebody knows if Websphere Message Broker is compatible to create JDBCProvider with Db2 for As400

thanks

Christian
Updated on 2013-04-03T21:02:56Z at 2013-04-03T21:02:56Z by frengifo
  • frengifo
    frengifo
    2 Posts

    Re: jdbcprovider for as400 db2

    ‏2013-04-03T21:02:56Z  
    Any advanced on this?
  • fjb_saper
    fjb_saper
    125 Posts

    Re: jdbcprovider for as400 db2

    ‏2013-04-19T15:23:20Z  

    Did you also configure DB2 Connect?