Hello!
Good day!
My program is supposed to generate an XML and to get its contents it needs to access AS400.
I'm using Eclipse as
IDE. During
testing, the XML is valid when I run the program in Debug Mode.
Using Run As
Java application, the results were inconsistent. Sometimes its valid, sometimes its not.
When the XML is invalid, I notice that this is the error it gets:
java.sql.SQLException: The application requester cannot establish the connection.(Address already in use: connect)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:480)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:2742)
at com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:807)
at com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:698)
at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:285)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.amkor.oasn.dao.JDBCConnectionFactory.getIseriesConnection(JDBCConnectionFactory.java:90)
at com.amkor.oasn.dao.BaseDAO.getIseriesonnection(BaseDAO.java:59)
at com.amkor.oasn.dao.CS2OASND3DAO.getBinDetails(CS2OASND3DAO.java:306)
at com.amkor.oasn.mapping.OASNMapping.createDetail3(OASNMapping.java:1093)
at com.amkor.oasn.mapping.OASNMapping.createDetail2(OASNMapping.java:783)
at com.amkor.oasn.mapping.OASNMapping.createDetail(OASNMapping.java:725)
at com.amkor.oasn.mapping.OASNMapping.OASN(OASNMapping.java:604)user EBIZUSR
What do I need to modify? I think this needs some optimization in the connection.
Can anyone give me an idea on how to implement it?
Thanks,
Darren