I am developing a number of db2 java stored procedures and have found that the biggest performance problem is caused by establishing the initial connection (eg. DriverManager.getConnection("jdbc:default:connection"
) each time the stored procedure is run. Does anyone know of a way to create a number of global connections within the database which could be used and left open instead of creating a new one each time the stored procedure is run?
) each time the stored procedure is run. Does anyone know of a way to create a number of global connections within the database which could be used and left open instead of creating a new one each time the stored procedure is run?