User ea78dc1699
11-07-2013 19:14:22
I just had a mysql database set up. I can connect with jchem manager and create /edit schema but I am not able to connect using IJC. Am using 6.0 version of jchem and IJChem.
Here is the error that is created
Error creating bean with name 'ijcMetadataDao' defined in URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-ijc-server-impl.jar!/META-INF/spring/applicationContext-shared-server-and-local-beans.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.im.ijcs.impl.dao.IJCMetadataDao]: Constructor threw exception; nested exception is java.lang.RuntimeException: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [CREATE TABLE IJC_CUSTOM_ITEMS_SHARING (
SCHEMA_ID VARCHAR(32) NOT NULL,
CUSTOM_ITEM_ID VARCHAR(32) NOT NULL,
AUTHORITY VARCHAR(50) NOT NULL,
PRIV VARCHAR(100) NOT NULL,
CONSTRAINT PK_IJC_CUSTOM_ITEMS_SHARING PRIMARY KEY (SCHEMA_ID, CUSTOM_ITEM_ID, AUTHORITY, PRIV),
CONSTRAINT FK_IJC_CUSTOM_ITEMS_SHARING FOREIGN KEY (SCHEMA_ID, CUSTOM_ITEM_ID) REFERENCES IJC_CUSTOM_ITEMS (SCHEMA_ID, ID) ON DELETE CASCADE,
CONSTRAINT FK_IJC_C_I_S_AUHORITY FOREIGN KEY (AUTHORITY) REFERENCES IJC_AUTHORITIES (AUTHORITY) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8]; SQL state [HY000]; error code [1005]; Can't create table 'ijc_db.ijc_custom_items_sharing' (errno: 150); nested exception is java.sql.SQLException: Can't create table 'ijc_db.ijc_custom_items_sharing' (errno: 150)