Create and update database using Java

I have created a database using Java with simple SQL statements. Now I have a list of smiles in a file which I want to use as my source to update the database can you describe how this is done, or point me to relevant resources.


Thanks


Wiraj

Could let us know what ChemAxon product are you using or describe in more detail what functionality are you looking for ?





If you want to crate a structural database I suggest ot look at JChem Base:





http://www.chemaxon.com/product/jc_base.html





Best regards,





Szilard

I am currently evaluating the use of the JChem Java library for integration with our product and I am using a evaluation version of the JChem Java library for this purpose. I need to be able to dynamically create and update databases and later use these databases to search for substructures.





The create and update phase of these dynamic databases need to be done programatically as the source data for these databases are read off text files as smiles

Hi,





I see in th other topic you have already started to explore the JChem Base API:





http://www.chemaxon.com/forum/viewpost19400.html#19400





Some additional tips:





I see you use Importer for importing structures.


We also provide UpdateHandler to individually insert / update / delete structures if needed:





http://www.chemaxon.com/jchem/doc/api/chemaxon/jchem/db/UpdateHandler.html





With UpdateHandler you can also create and drop tables:





http://www.chemaxon.com/jchem/doc/api/chemaxon/jchem/db/UpdateHandler.html#createStructureTable(chemaxon.util.ConnectionHandler,%20chemaxon.jchem.db.StructureTableOptions)


http://www.chemaxon.com/jchem/doc/api/chemaxon/jchem/db/UpdateHandler.html#dropStructureTable(chemaxon.util.ConnectionHandler,%20java.lang.String)





Best regards,





Szilard

Hi Wiraj,





You can also see some examples here:


connect to DB:


http://www.chemaxon.com/jchem/examples/java/search/Connection.java.html





DB creation:


http://www.chemaxon.com/jchem/examples/java/search/TableOperations.java.html





Bye,


Robert

Thanks a lot both you guys this was very helpful