JchemManager detects "fake" older versions

Hi.


JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------


Oracle Database 10g Release 10.2.0.1.0 - 64bit Production


PL/SQL Release 10.2.0.1.0 - Production


CORE 10.2.0.1.0 Production


TNS for Linux: Version 10.2.0.1.0 - Production


NLSRTL Version 10.2.0.1.0 - Production


NLSRTL Version 10.2.0.1.0 - Production


JChem version in the database: 3.1.5


JChem version in the Tomcat server: 3.1.5


java.vm.version: 1.5.0_06-b05


java.vm.vendor: Sun Microsystems Inc.


Apache Tomcat/5.5.15





JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------


Major JDBC version in Tomcat: 10


Minor JDBC version in Tomcat: 2








Here is my "problem".


I have one central jchempropterties table located in schema jchem.


If I create a jchem table using jcman in schema test1 it works fine.


When I then try to create a jchem table in schema test2, whne I log on


to JChemManager it says the following


"JChem has detected that the following tables were created with an older


version of JChem, and log tables should be created for them to be usable


with this version"


This is not true, because I have created the table with the current version.


It seems to be related with the fact that user test2 does not have any privileges on user


test1's tables.


Am I right ?





/Mikael

Hi,





You are right: jcman checks for log tables at startup, and if cannot read them it thinks they do not exist, and offers to create them.





You can ignore this misleading message for the moment.





We will look for a better solution to detect the need for such changes.





Regards,





Szilard