CD_SORTABLE_FORMULA missing from 3.2.6 to 5.0.1 upgrade

After upgrade 3.2.6 to 5.0.1, when running jcman to regenerate the tables, it comlains that the column CD_SORTABLE_FORMULA is missing.





Is this column needed ?


How do I create it (normal sql alter table ...).





Regards,


Mikael

The regeneration function of JChemManager should do this for you. Please, run

Code:

jcman u

and answer the questions with yes -- especially when asked if the tables should be altered. (If you prefer the JChemManager GUI, you can start regeneration from the File menu.)





Thanks


Peter

I am using the gui and it is the gui that reports the errors.





jcman u results in the following errors.


oracle@vader:~> jcman u


Cannot connect:


java.sql.SQLException: invalid arguments in call


at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)


at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161)


at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:226)


at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:205)


at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:360)


at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:150)


at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)


at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595)


at java.sql.DriverManager.getConnection(DriverManager.java:512)


at java.sql.DriverManager.getConnection(DriverManager.java:171)


at chemaxon.util.ConnectionHandler.setConnected(ConnectionHandler.java:197)


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


at chemaxon.jchem.Command.run(Command.java:555)


at chemaxon.jchem.Command.main(Command.java:201)








The regeneration of the tables from the gui does not add the missing column.


Regards,


Mikael

Quote:

The regeneration of the tables from the gui does not add the missing column.

Adding the column is no performed by regeneration.


Altering the tables should be offered automatically at GUI startup (after the connection dialog), before offering regeneration or before you can regenerate manually.


Please answer yes in the dialog.





Szilard

You probably don't let the GUI save the connection parameters into ${HOME}/.chemaxon/.jchem. I suggest adding the -l and -p option:

Code:

jcman u -l <login> -p <password>

Thanks


Peter

Thanks.


Now it asked me to update the tables.





Is there any way to choose singles table ?

Quote:

Is there any way to choose singles table ?

There is no option update a single table, the new column will be added to all of your tables.





Best regards,





Szilard