Search for molecules directly inside the database.

Hi,

Is it possible to
perform a search directly within the database, passing "CC.CCC" value
as a parameter into stored procedure?

Thanks,

I think yes, if the sproc calls the JChem Cartridge.

Forwarding your question to the JCC team.

hamoriviktor wrote:

I think yes, if the sproc calls the JChem Cartridge. Forwarding your question to the JCC team.

What if its SQL Server?

We do not have MS SQL Server Cartrdige, we do have Oracle.

Hi,

Is your aim maybe to access our API from a non-Java envoironment or something else ?

Please note that you can also use JChem Base for MS SQL Server via the following non-Java wrappers:

- JChem Web Services (SOAP interface)

- Our .NET API (the full Java API translated with IKVM) 

Just FYI.

Best regards,

Szilard

hamoriviktor wrote:

We do not have MS SQL Server Cartrdige, we do have Oracle.

Does that mean it’s impossible to do
it on SQL Server then?

Szilard wrote:

Hi, Is your aim maybe to access our API from a non-Java envoironment or something else ? Please note that you can also use JChem Base for MS SQL Server via the following non-Java wrappers: - JChem Web Services (SOAP interface) - Our .NET API (the full Java API translated with IKVM)  Just FYI. Best regards, Szilard

Yes, I know how to doit using .NET API.

I'm basically getting molStr value(CC.CCC) from MarvinScetch and want to pass this value into stored procedure.
Ideally I want to query structure table directly from within stored procedure. Can that be done?

Thanks

Hi,

MolSearch - that is available from .NET API as well - can be used for this purpose.

https://www.chemaxon.com/api_land.html#molsearch

Best regards,

Krisztina