DB2 database connection failed.
Hi,
I’m trying to connect to the Data source using JDBC Connection/Data Connection
I used type2 driver. I have placed JAR files in BIN/EXT folder. But still getting below error if connected through type 2 driver.( IBMDB2(type2)/com.ibm.db2.jcc.DB2Driver)
“Can't get the Connection for specified properties; com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][3.64.106] Invalid database URL syntax: jdbc:db2://OHMODEL:50005/AHB10UQA:user=ax0642;password=passvalue. ERRORCODE=-4461, SQLSTATE=42815 “.
I got below error if trying to connect through JDBC driver(IBMDB2/COM.ibm.db2.jdbc.app.DB2Driver)
Can't get the Connection for specified properties; com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][t4][10205][11234][3.64.106] Null userid is not supported. ERRORCODE=-4461, SQLSTATE=42815
I’m using DB2 of version DB2 v9.7.0.7. with Fixpack # 7 and build level s121002. So I downloaded Jar files v9.7fp7_jdbc_sqlj from online. When I tried to connect to DB2 database without SOAPUI Pro, I have successfully able to connect. I’m using same login details here. Attached screen shots for more info.
Thanks
Pro User.
I’m trying to connect to the Data source using JDBC Connection/Data Connection
I used type2 driver. I have placed JAR files in BIN/EXT folder. But still getting below error if connected through type 2 driver.( IBMDB2(type2)/com.ibm.db2.jcc.DB2Driver)
“Can't get the Connection for specified properties; com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][3.64.106] Invalid database URL syntax: jdbc:db2://OHMODEL:50005/AHB10UQA:user=ax0642;password=passvalue. ERRORCODE=-4461, SQLSTATE=42815 “.
I got below error if trying to connect through JDBC driver(IBMDB2/COM.ibm.db2.jdbc.app.DB2Driver)
Can't get the Connection for specified properties; com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][t4][10205][11234][3.64.106] Null userid is not supported. ERRORCODE=-4461, SQLSTATE=42815
I’m using DB2 of version DB2 v9.7.0.7. with Fixpack # 7 and build level s121002. So I downloaded Jar files v9.7fp7_jdbc_sqlj from online. When I tried to connect to DB2 database without SOAPUI Pro, I have successfully able to connect. I’m using same login details here. Attached screen shots for more info.
Thanks
Pro User.
