i'm havin trouble to connect to my DB with SFS2X, in SFSPro we used the following settings:
Code: Select all
<DatabaseManager active="true">
<Driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</Driver
<ConnectionString>jdbc:sqlserver://DB_IP_ADDRESS;databaseName=DB_NAME;integratedSecurity=false;;</ConnectionString>
<UserName>DB_USER_USERNAME</UserName>
<Password>DB_USER_PASSWORD</Password>
<TestSQL><![CDATA[SELECT Count(*) FROM [dbo].[USER]]]></TestSQL>
<MaxActive>10</MaxActive>
<MaxIdle>10</MaxIdle>
<OnExhaustedPool>fail</OnExhaustedPool>
<BlockTime>5000</BlockTime>
</DatabaseManager>
and it worked fine, now in SFS2X it doesnt connect and on server start get the following error:
Code: Select all
Exception: com.microsoft.sqlserver.jdbc.SQLServerException
Message: The method executeQuery() cannot take arguments on a PreparedStatement or CallableStatement.
Description: The DBManager Test SQL failed
Please double check your SQL code and make sure that Database server is running.
can anybody help out?
Thanks