Issue promoting a mysql table containing a structure field

User f67d4188b6

23-12-2013 11:24:57

I have an issue promoting a mysql table containing a structure field.

This is the table definition:

CREATE TABLE `test3` (
  `x_id` int(11) NOT NULL AUTO_INCREMENT,
  `structure` text NOT NULL,
  `ID` varchar(12) DEFAULT NULL,
  `FORMULA` varchar(15) DEFAULT NULL,
  `WEIGHT` varchar(11) DEFAULT NULL,
  `SMILES` varchar(88) DEFAULT NULL,
  `KEGG` varchar(9) DEFAULT NULL,
  `NAME` varchar(15) DEFAULT NULL,
  `CAS` varchar(67) DEFAULT NULL,
  PRIMARY KEY (`x_id`)


IJC does not see the table as containing structures, and is thus promoting it to a standard table.

I tried converting the TEXT field into a MEDIUMBLOB field, to no avail.

I probably missed something obvious, and would be grateful to anyone that can point it out.

ChemAxon 2bdd02d1e5

06-01-2014 09:53:36

The table which is created by your CREATE TABLE statement is not valid JChem structure table. You can not create JChem structure tables directly in MySQL. Structure table contains specific chemical finger print and flag columns. Please read the details at 

You can create structure tables by importing data in GUI by JCMan or IJC, or using JChem API directly in Java.

User f67d4188b6

07-01-2014 10:08:08

In this tutorial:

an existing table is promoted to a structure table.
Was this existing table created using one of the tools you mentioned ?


ChemAxon 2bdd02d1e5

08-01-2014 08:11:31

Yes, that's right. The tables were formerly created by IJC (but other mentioned tools are also suitable).