error in connection string
Posted: 16 Oct 2010, 19:06
Ok i understand how i can create an extension but i have some doubt.
DataBase is SQLServer,
I have this errore
Code: Select all
<DatabaseManager active="true">
<Driver>sun.jdbc.odbc.JdbcOdbcDriver</Driver>
<ConnectionString>Data Source=localhost;Initial Catalog=Destinies;User Id=xxxxxx;Password=xxxxxx</ConnectionString>
<UserName>yourname</UserName>
<Password>yourpassword</Password>
<TestSQL><![CDATA[SELECT COUNT(*) FROM UserBase]]></TestSQL>
<MaxActive>10</MaxActive>
<MaxIdle>10</MaxIdle>
<OnExhaustedPool>fail</OnExhaustedPool>
<BlockTime>5000</BlockTime>
</DatabaseManager>
I have this errore
Code: Select all
22:26:52.902 - [ SEVERE ] > DbManager could not retrive a connection. java.sql.S
QLException: No suitable driver found for Data Source=localhost;Initial Catalog=
Destinies;User Id=XXXXXXX;Password=XXXXXXX
it.gotoandplay.smartfoxserver.exceptions.DbManagerException: The Test SQL statem
ent failed! Please check your configuration.
at it.gotoandplay.smartfoxserver.SmartFoxServer.setupZone(SmartFoxServer
.java:1843)
at it.gotoandplay.smartfoxserver.lib.ConfigReader.parse_Zones(ConfigRead
er.java:806)
at it.gotoandplay.smartfoxserver.lib.ConfigReader.readZoneConfig(ConfigR
eader.java:174)
at it.gotoandplay.smartfoxserver.SmartFoxServer.initServerSocket(SmartFo
xServer.java:339)
at it.gotoandplay.smartfoxserver.SmartFoxServer.run(SmartFoxServer.java:
607)
Problems in config file: The Test SQL statement failed! Please check your config
uration.
it.gotoandplay.smartfoxserver.exceptions.ConfigurationException: The Test SQL st
atement failed! Please check your configuration.
at it.gotoandplay.smartfoxserver.lib.ConfigReader.readZoneConfig(ConfigR
eader.java:199)
at it.gotoandplay.smartfoxserver.SmartFoxServer.initServerSocket(SmartFo
xServer.java:339)
at it.gotoandplay.smartfoxserver.SmartFoxServer.run(SmartFoxServer.java:
607)
Errors found in configuration files.
Unable to start the server.
Shutting down server...