SmartFoxServer: 2X 2.0.0 RC1b
SmartFoxSerer API: SFS2X_API_AS3 2.0.0.RC1b
OpenSpace: SFS2X 2.0.3
I have pasted exactly what has been successful for so long in SFS 1.x and am getting the following error while having the Test SQL present.
Is there a difference in what the configuration should be in 2X?
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.
Test SQL Exception
Which way are you doing it code-wise?
e.g. IDBManager :: from API, which suggests that you need to pass it a string and not a prepared statement...
e.g. IDBManager ::
Code: Select all
executeQuery(String sql)
The DB configuration, having tried it without the function as well:
<databaseManager active="true">
<driverName>com.microsoft.sqlserver.jdbc.SQLServerDriver</driverName>
<connectionString>jdbc:sqlserver://localhost:1433;DatabaseName=WizardBrewStudios;</connectionString>
<userName>userName</userName>
<password>password</password>
<testSql>SELECT COUNT(*) FROM ServerSelectTest</testSql>
<maxActiveConnections>10</maxActiveConnections>
<maxIdleConnections>10</maxIdleConnections>
<exhaustedPoolAction>FAIL</exhaustedPoolAction>
<blockTime>20</blockTime>
</databaseManager>
<databaseManager active="true">
<driverName>com.microsoft.sqlserver.jdbc.SQLServerDriver</driverName>
<connectionString>jdbc:sqlserver://localhost:1433;DatabaseName=WizardBrewStudios;</connectionString>
<userName>userName</userName>
<password>password</password>
<testSql>SELECT COUNT(*) FROM ServerSelectTest</testSql>
<maxActiveConnections>10</maxActiveConnections>
<maxIdleConnections>10</maxIdleConnections>
<exhaustedPoolAction>FAIL</exhaustedPoolAction>
<blockTime>20</blockTime>
</databaseManager>
Who is online
Users browsing this forum: No registered users and 116 guests