Is the value defined in JDBC connection bigger then 0?
No: Increase the number fo JDBC connections.
To check the status of the connection pool
in the Visual Administrator tool choose server<instance_no> > services > JDBC Connector > DataSources > SAP<SYSTEM_ID>DB > Monitoring tab.
If the number of used connections is the same as the number of free connections, then there are no more free connections for new requests. You must increase the number of connections in the connection pool, as described in step 2.1 Resizing the connection pool.
If the number of used connections (number in red) is the less than the number of free connections (number in green), then check the log file for the following error messages.
To increase the number fo JDBC connections
To resize the connection pool, select server<instance_no> > services > JDBC Connector > DataSources > SAP<SYSTEM_ID>DB > Properties. Change the parameter sysDS.maximumConnections to an appropriate value.
make sure that the value is less than the number of database sessions as defined by the database. To launch the database administrator, using a browser, connect to http://<m/c name>:9999/webdbm and log on.
For Windows platform only, alternatively, you can also use the SAPMMC:
- Connect to the required SAP Web AS system and launch the management console (Start > Programs > SAP Management Console) and select the database node.
- Select Configuration > Parameters > MAXUSERTASKS. This value gives you the maximum number of simultaneous database sessions.