Hi,
We are developing an application that have both ABL and web interface.
Web interface is a java web application.
We start servers with these commands:
_mprosrv.exe c:\pathto\mydb.db -H 192.168.0.13 -S 40000 -N TCP
_mprosrv.exe c:\pathto\mydb.db -H 192.168.0.13 -S 40010 -N TCP -m3
Sometimes web application lost connection and couldn't connect again unless we restart the server processes.
Error message is that we get is :
An error occured while establishing the connection.
Type: java.sql.SQLException Error Code: 0 SQL State: HY000
Message:
OE Broker fails to find a server available for connecting .
Regards.
Potentially, you need a few more parameters on the broker startup (I suspect you are hitting limits because of the defaults).
There are 2 parameters that you need to look at:
-Mn - This is the total number of server processes and login brokers and is only required on the primary broker.
-Mpb - This is a number of server processes per broker and must be set for each broker process started.
-Mn = -Mpb (on the primary) + -Mpb (on the secondary) + 1.
I've adjusted parameters as you write. It seems ok for now.
I wonder what are the default values ? Thanks.
Regards.