question about use JCHEM with PHP

I test the demo Jchem with Tomcat and Jchem Manager and it works well.


I can import structures successfully and query my mysql database.





I have an information system based on oracle + Php + Idbs tools.


I would like to test the move in Jchem but I have no experiment in JSp or java.


In my oracle database, I have table "structure" and table "compounds".


For example, 2 or 3 compounds can refers 1 structure.





is it possible to use Php with Jchem?

Hi TRAN-MINH,





You can't use JChem with PHP at the moment, but we are going to bring out a web service interface for JChem still this year. It will allow of access to JChem from non Java based script languages.





If your database server is Oracle, you can use JChem Cartridge for access JChem functions. You can find the documentation here:


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


http://www.chemaxon.com/jchem/doc/guide/cartridge/index.html





Regards, Edvard

There is one existing solution also:





You could use JChem Cartridge. It can handle arbitrary database structure, not just JChem tables. Furthermore, it is accessible through Oracle SQL interface, which is available from all programming languages. We have numerous customers who use it successfully on IDBS tables. (They put JChem index on the structure column within the IDBS table, and perform chemical searches using JChem Cartridge.)





You can find more information about JChem Cartridge here:


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





Best regards,


Szabolcs

IDBS gives us tools for query too : substructure, similarity, .... and it is enough for us.





I just would like to create a same information system but with Jchem tools in place of IDBS but I have no experiment in JSP.


With IDBS, we have tables Chemstruct for structure and OBJDTAIL for compound. I don't find these tables with Jchem cartridge.

Hi,





With JChem Cartridge, you could use any table structure as long as there is one column that contains chemical structures. You should create a JChem index on that column, and it can be searched by chemical operators.





The concept is best explained in the JChem Cartridge technical presentation:


http://www.chemaxon.com/conf/JChem_Cartridge.ppt


(I particularly refer to slides 20 and 21.)





Best regards,


Szabolcs