IJCPropertiesDao: Not being able to connect to mysql databas

User 2793f13b08

22-08-2007 19:50:37

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[email protected]1ac44c2: display name [org[email protected]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[email protected]1ac44c2]: org.s[email protected]1bf7701


INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory]: Pre-instantiating singletons in org.s[email protected]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?

ChemAxon fa971619eb

22-08-2007 22:37:32

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

User 2793f13b08

23-08-2007 20:07:33

Thanks Tim