license Jchembase

I am trying to registrer for Jchem Base with the trial license you sent us. I am having problems and need your help !


I do not manage in reaching the graphical interface. Then I used the command line interface, obviously the commande "license" does not lauch the graphical interface. Then I tried "license -l" to see all the module I can registrer for, but I do not see anything called "JChemBase" all I see is "InstantJChem" and a long list of modules.


Please let me know how I shall proceed


thanks in advance

Hi,





Currently the license key for JChem Base, JKlustor and the Cartridge are to be set in a different way than other licenses.





You should use the JChemManager (jcman) GUI to connect to the database and enter the license key in the "Options" menu.





Please see the relevant part of administration guide:





http://www.chemaxon.com/jchem/doc/admin/#options





If you are having problems starting up the application, please write us exactly what you do and what you see (e.g. full stack trace of the error).





Please make sure to include the JDBC driver in the CLASSPATH environment variable before trying to run jcman as stated in the documentation.





Best regards,





Szilard

Hi Szilard (sorry about that!)


I followed all your advices and things are doing better, for example I can reply on the forum!


I did what you say and got the following error message :








java.sql.SQLException: No suitable driver


at java.sql.DriverManager.getConnection(Unknown Source)


at java.sql.DriverManager.getConnection(Unknown Source)


at chemaxon.util.ConnectionHandler.setConnected(ConnectionHandler.java:2


06)


at chemaxon.util.ConnectionHandler.connect(ConnectionHandler.java:246)


at chemaxon.jchem.gui.Connector.go(Connector.java:63)


at chemaxon.jchem.gui.JChemFrame.connect(JChemFrame.java:561)


at chemaxon.jchem.JChemManager.init(JChemManager.java:89)


at chemaxon.jchem.JChemManager.main(JChemManager.java:106)


C:\Program Files\ChemAxon\JChem\bin>





The thing is that you recommanded me to put "com.microsoft.sqlserver.jdbc.SQLServerDriver"


for the JDBC value.


And I have noticed that in our web config file we have the following value:


com.microsoft.jdbc.sqlserver.SQLServerDriver


(jdbc and sql serveur are inverted)


if I try with this value to regitrer, I get the following message :


java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver


at java.net.URLClassLoader$1.run(Unknown Source)


at java.security.AccessController.doPrivileged(Native Method)


at java.net.URLClassLoader.findClass(Unknown Source)


at java.lang.ClassLoader.loadClass(Unknown Source)


at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)


at java.lang.ClassLoader.loadClass(Unknown Source)


at java.lang.ClassLoader.loadClassInternal(Unknown Source)


at java.lang.Class.forName0(Native Method)


at java.lang.Class.forName(Unknown Source)


at chemaxon.util.ConnectionHandler.setConnected(ConnectionHandler.java:2


05)


at chemaxon.util.ConnectionHandler.connect(ConnectionHandler.java:246)


at chemaxon.jchem.gui.Connector.go(Connector.java:63)


at chemaxon.jchem.gui.JChemFrame.connect(JChemFrame.java:561)


at chemaxon.jchem.JChemManager.init(JChemManager.java:89)


at chemaxon.jchem.JChemManager.main(JChemManager.java:106)


C:\Program Files\ChemAxon\JChem\bin>





The dirver and everything works since I have an SQL application running witrh chemaxonproduts ...


Well I do not understand much of all this, and I once more need your advices


thanks in advance,





Bruno

Hi Bruno,





As you can see in this table in our FAQ, there are two kinds of JDBC drivers depending on SQL Server version it was made for:





http://www.chemaxon.com/jchem/FAQ.html#dburl





Both the driver class and the URL format has changed in SQL Server 2005.

Quote:

java.sql.SQLException: No suitable driver

This error message indicates that there is a mismatch between the driver and URL.


Since you have the latest driver, you should modify the URL to start with

Code:

jdbc:sqlserver://

instead of

Code:

jdbc:microsoft:sqlserver://

(Sorry, I did not notice this difference when you were asking in e-mail)

Quote:

And I have noticed that in our web config file we have the following value: com.microsoft.jdbc.sqlserver.SQLServerDriver

Probably your web server has an older driver in it's CLASSPATH.


I think it's easier to use the new driver now that you have it in your CLASSPATH, the new driver supports older SQL Server versions too.


Use "com.microsoft.sqlserver.jdbc.SQLServerDriver" for the new driver.





Please let me know if this helps.





Best regards,





Szilard

HI szilard,


I finally succeeded usiong all the parameters for SQL 2005, although I am pretty sure we are in SQL 2000 ...


Well doesn't matter, I'll report that to the company that develops the software for us.


Thanks a lot for your help





Bruno

Hi,

Quote:

I finally succeeded usiong all the parameters for SQL 2005, although I am pretty sure we are in SQL 2000 ... Well doesn't matter, I'll report that to the company that develops the software for us.

I am glad you could solve the problem.





I do not think you should report anything though.


It's just that you are using the new 2005 driver which also works with 2000 - so you have to specify things in the new format.


They were using the older 2000 driver.


Both solutions are completely OK.





Szilard