jchemManger and Markush structure

User 26c54ae8b9

08-04-2008 20:49:41

Dear Chemaxon,





I want to import a sdf file in a mysql database.


I use jchemanager but i have a error on a molecule.





JchemManager doesn't want to import a molecule, the message is : "insertion a query or Markush structure is not allowed for table .... ".





The molecule is :


Smile :
  • .
  • .C[C@@H](O)[C@H](C)NC1=NC2=CC=CC=C2S1


    Formula : C11H14N2OR2S


    Weight : 222.3044





    Do you have an idea about this error ?





    Thanks,





    Karim.
  • ChemAxon e274e1bada

    08-04-2008 21:55:22

    Hi Karim,





    your SMILES in fact is a SMARTS and it contains two 'any' atom on front of the string:
  • .
  • .


    'Any atom' is a query feature, it can be used in query structures or markush structures only.


    See this: http://www.chemaxon.com/jchem/doc/user/Query.html#generatom





    Edvard
  • ChemAxon a3d59b832c

    09-04-2008 07:40:02

    Please use the "Any structure" table type instead of "Molecules". You will be able to import your structure to this kind of table.


    See: http://www.chemaxon.com/jchem/doc/admin/#tableTypes





    Best regards,


    Szabolcs

    User 26c54ae8b9

    09-04-2008 09:57:11

    It's Ok with a structure table.





    Thanks Chemaxon !