Import Problem

I have tried to import a file containing multiple molecules into a mysql database via jcman. This file was created either with marvin sketch or chemdraw and saved in several formats including .mrv, .sdf, .rdf, smiles, and mol format. The file is imported into a mysql database with jcman with no errors. However, only one record is created containing a single structure record that contains all of the structures in the file rather than a separate record for each molecule in the file. Is this an issue with licensing setup, import settings, the database setup, or JDBC driver?





I am using Marvin 4.06


JChem3.1.7.1


mysql 4.1.20


JDBC driver: mysql-connector-java-3.1.13


Centos Linux

Hi,





This is simply a single molecule with multiple fragments.


(This concept is used for storing structures with solvents, counterions, etc.)





For formats that support it, MarvinSketch (msketch) always offers appending to the structure file.





1. Edit and save a single structure (or load it form file with msketch)


2. Draw a new structure


3. Press "Save"


4. Choose "Append"


5. Go back to #2 to add more structures





I have attached an example for this.


Please note the difference when you open it in mview or msketch.





Best regards,





Szilard

Thanks for the prompt reply. That solved the problem.





--Michael