java - IBM JDBC DB2 Back-End Connection behind Firewall -
i'm creating java liberty web application on dedicated bluemix server. i'm trying create connection db2 on ibm's zos , trying use jdbc connection. can connect locally on machine, when attempts connection on application, it's throwing error:
[err] error message: [jcc][t4][10380][11951][3.65.97] required property "fpd1dbv.bhprod.ibm.com" unknown host. errorcode=-4222, sqlstate=08001
[err] sqlstate: 08001
[err] error code: -4222
[err] com.ibm.db2.jcc.am.sqlnontransientconnectionexception: [jcc][t4][10380][11951][3.65.97] required property "fpd1dbv.bhprod.ibm.com" unknown host. errorcode=-4222, sqlstate=08001
i have entered server.xml file within web application structure:
<library id="db2jcc4lib"> <fileset dir="/src/main/webapp/web-inf/lib" includes="db2jcc4.jar db2jcc_license_cisuz.jar db2jcc_license_cu.jar db2jcc.jar"/> </library> <datasource id="db2" jndiname="jdbc/db2" type="javax.sql.datasource" jdbcdriverref="db2jcc4lib"> <jdbcdriver libraryref="db2jcc4lib"></jdbcdriver> <properties databasename="bhprdfpd" servername="fpd1dbv.bhprod.ibm.com" portnumber="448" drivertype="4"/> </datasource>
i believe it's not finding host because it's behind ibm's firewall. there way can around firewall pull information database? or, there easier way pull information db2 behind ibm's firewall on dedicated bluemix server? provide getting around firewall pull information appreciated!
it unlikely db2-for-z/os publicly accessible. ask db2-for-z/os sysprogs or dba advice on connectability between bluemix jdbc client , z/os subsystem trying access.
it's possible there gateway machine publicly accessible (to degree), , gateway may run db2-connect software access db2-for-z/os. if solution jdbc client reference gateway (and not db2 z/os subsystem directly). ask dbas , sysprogs.
Comments
Post a Comment