IJCPropertiesDao: Not being able to connect to mysql databas

While creating a new scheme, and choosing a MySql db, I get all the way to the Licenses tab. After plugging in the license keys, i click finish, but I get an error.

Quote:

"Error creating bean with name 'IjcPropertiesDao' defined in class path resource...

I can't see the rest.





On the command prompt I see the following......

Quote:

Testing com.im.df.core.derby.EmbeddedSourceFactory Testing com.im.df.core.oracle.OracleDataSourceFactory Testing com.im.df.db.mysql.MysqlDataSourceFactory INFO [com.im.df.impl.db.api.BaseDataSource]: Creating DB pool: jdbc:mysql://localhost/chem INFO [org.springframework.context.support.ClassPathXmlApplicationContext]: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@1ac44c2: display name [org.springframework.context.support.ClassPathXmlApplicationContext@1ac44c2]; startup date [Wed Aug 22 17:04:03 EDT 2007]; root of context hierarchy INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from class path resource [com/im/df/resources/core-bean-factory.xml] INFO [org.springframework.context.support.ClassPathXmlApplicationContext]: Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext@1ac44c2]: org.springframework.beans.factory.support.DefaultListableBeanFactory@1bf7701 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory]: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1bf7701: defining beans [schemaId,initalDataSourceFactoryBean,initialDataSource,authenticationInterceptor,databasePlatform,userDetailsDao,ijcPropertiesDao,userLoginDao]; root of factory hierarchy INFO [com.im.df.db.mysql.MysqlDataSource]: Loaded JDBC driver: com.mysql.jdbc.Driver INFO [com.im.df.impl.db.api.BaseDataSource]: Creating DB pool: jdbc:mysql://localhost/chem INFO [com.im.df.core.DatabasePlatform]: Testing com.im.df.core.impl.HsqlDatabasePlatformFactory INFO [com.im.df.core.DatabasePlatform]: Testing com.im.df.core.derby.DerbyDatabasePlatformFactory INFO [com.im.df.core.DatabasePlatform]: Testing com.im.df.core.oracle.OracleDatabasePlatformFactory INFO [com.im.df.core.DatabasePlatform]: Testing com.im.df.db.mysql.MysqlDatabasePlatformFactory Database Info: Product name: MySQL Product version: 3.23.58 Major version: 3 Minor version: 23INFO [com.im.df.impl.db.persist.IJCPropertiesDao]: Initializing IJCPropertiesDao

Any ideas? Is 3.23 not supported?

Yes, that is correct. MySQL 5.0 is the supported version. IJC uses the InnoDB table type, amongst other things, so needs a fairly recent version. Using MySQL 5.0 is required.


For more information on database implementation details see here:


http://www.chemaxon.com/instantjchem/ijc_2_0/docs/user/help/htmlfiles/tips_and_tricks/db_impl_notes.html





Tim

Thanks Tim