Page 1 of 1

error in connection string

Posted: 16 Oct 2010, 19:06
by gsources75
Ok i understand how i can create an extension but i have some doubt.


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>

DataBase is SQLServer,

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...

Posted: 16 Oct 2010, 20:11
by BigFIsh