MYSQL connection

[Migrated From Jforum.net]

Hi!
1- If MY SQL server is on another machine from the tomcat and
database.connection.host=192.168.1.2

which type of database.connection.implementation is better to use: pooled or simple?

2- In case of PooledConnection - wich settings are optimal for:
database.connection.pool.min;
database.connection.pool.max;
database.connection.pool.timeout.

3- Are this settings works in case of SimpleConnection??

Thanks

Yanam

[originally posted on jforum.net by yanam]