Sfs2x send me error on starting like
Code: Select all
Exception: org.postgresql.util.PSQLException
Message: Can't use query methods that take a query string on a PreparedStatement.
Description: The DBManager Test SQL failed
Please double check your SQL code and make sure that Database server is running.
But when i run Sms 1.x with the same connection property all is Ok.
I undestend that it is probably my mistake, but have no idea what is it.
Sfs1.x property
Code: Select all
<DatabaseManager active="true">
<Driver>org.postgresql.Driver</Driver>
<ConnectionString>jdbc:postgresql://localhost:5432/game_new</ConnectionString>
<UserName>postgres</UserName>
<Password>admin</Password>
<TestSQL><![CDATA[SELECT COUNT(*) FROM users]]></TestSQL>
<MaxActive>10</MaxActive>
<MaxIdle>10</MaxIdle>
<OnExhaustedPool>fail</OnExhaustedPool>
<BlockTime>5000</BlockTime>
</DatabaseManager>
Sfs2x property
Code: Select all
<databaseManager active="true">
<driverName>org.postgresql.Driver</driverName>
<connectionString>jdbc:postgresql://127.0.0.1:5432/game</connectionString>
<userName>postgres</userName>
<password>admin</password>
<testSql>SELECT COUNT(*) FROM users</testSql>
<maxActiveConnections>10</maxActiveConnections>
<maxIdleConnections>10</maxIdleConnections>
<exhaustedPoolAction>FAIL</exhaustedPoolAction>
<blockTime>5000</blockTime>
</databaseManager>
I use prostgre 8.4(windows) or 8.3(ubuntu)