User e5eaaed899
19-09-2011 15:26:11
Hi,
I've created a JChem table that contains structures and other (imported properties) such as PCT_INHIB.
PCT_INHIB is a float and was defined as such when creating the table.
I can retrieve molecules and the associated properties as soon as they are char or varchar (using the JChemSearch component of PP with Fetch DB Fields). I the error below whenever I try to retrieve a property that is a int or a float.
Is this a bug? Is there a specific way of defining ints and floats that makes it work? Is BigDecimal something post java 1.6.0_01?
Many thanks for your help.
Jerome.
--
Unknown type for property PCT_INHIB : java.math.BigDecimal
JChem version : 5.5.0.1
Component collection version : 1.9_j55
JVM: Sun Microsystems Inc. Java HotSpot(TM) 64-Bit Server VM 1.6.0_01
Memory: 227.0 MB maximum 91.0 MB total 54.0 MB free
OS: amd64 Windows Vista 6.1
Exception ID: E43629197
Current input structure:
No PP input structure found.
Please find detailed report in log file: "\..\..\chemaxon\logs\pp_error_2011_09_19.txt"
java.lang.Exception: Unknown type for property PCT_INHIB : java.math.BigDecimal
at chemaxon.pp.ChemAxonComponent.defineProperty(ChemAxonComponent.java:278)
at chemaxon.pp.JChemSearch.returnNextHit(JChemSearch.java:449)
at chemaxon.pp.JChemSearch.onProcessBody(JChemSearch.java:301)
at chemaxon.pp.ChemAxonComponent.onProcess(ChemAxonComponent.java:50)
at com.scitegic.pilot.Pilot.callOnProcess(Pilot.java:300)
CComponentJavaPlugin::onProcess: Pipeline Pilot exception rethrown
-> Internal ChemAxon JChemSearch (JChemSearch) - error during Data Record Processing phase
CProtocolStd::onProcess: Pipeline Pilot exception rethrown
CProtocol::onProcess: Pipeline Pilot exception rethrown
-> JChemSearch (JChemSearch) - error during Data Record Processing phase
CProtocolStd::onProcess: Pipeline Pilot exception rethrown
CProtocol::onProcess: Pipeline Pilot exception rethrown
Protocol New Protocol6, user xxxx: Pipeline Pilot exception caught
Protocol New Protocol6, user xxxx: Protocol failed: Pipeline Pilot error
Pipeline Pilot Server version 8.0.1.700
Server OS: Windows 6.1 Server