multiple chemical databases

How does one create multiple databases in different schemas (users) when jchemstreams.war is only configured to one schema.





Do I need to put the different chemical databases in one Oracle schem (user) or is there another option?

With the current implementation, the user which is configured for the JDBC connection in Tomcat has to be assigned privileges which empower it to create, delete and operate on objects in other users' schemata. The list of privileges required can be found at http://www.jchem.com/doc/admin/cartridge.html#server_jdbc and at


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





We plan to implement a mechanism to remove the requirement for a user with "superuser"-like privileges. It is discussed at http://www.chemaxon.hu/forum/ftopic425.html . Would you like to see a similar "feature" implemented in JChem Cartridge?

We have decided to configure multiple tomcat ports and install jchemstreams under each of them to different databases.