createMDTable: priviledges problem

User 86810cf9fa

01-04-2008 10:51:56

Dear support,

I would like to create a MD table to store my pharmacophoric fingerprints. Here is the code I am using:

Code:

generator.setConnectionHandler(connection);

generator.setStructureTableName("MY_CSMOL");

generator.createMDTable("PF", "chemaxon.pharmacophore.PharmacophoreFingerprint", "", "");

generator.setDescriptor(0, "molecules.pfp", "PF", pfpConfig, "");

generator.init();

generator.run();

generator.close();

connCsmol.close();

My problem is that I have got an ORA-01031: Insufficient priviledges. on createMDTable.

Could you please tell me which priviledges I need to create my table. I already set the CREATE TABLE priviledge but it is not enough.

Thank you very much.

Best regards,

Severine

ChemAxon efa1591b5a

02-04-2008 14:31:26

Hi Severine,

createMDTable() does access the JCHEMPROPERTIES table and inserts 3 new rows. Do you have update rights on this table?

Regards,

Miklos

User 86810cf9fa

02-04-2008 15:04:59

Hi Miklos,

Thank you for your answer.

I tryed to create the MD table with MDTableHandler and it works now.

Heowever, is it possible to set a specific tablespace in which create the table?

Thank you

Best regards,

Severine

ChemAxon efa1591b5a

04-04-2008 07:27:44

Hi,

well, that's one way, but it's far too low level to perform such operation.

You should be able to do the same on higher level using the GenerateMD class as you did in your original code. This is what createMDTable() does:

Code:

public void createMDTable( String descrName, String className,

String settings, String comment ) throws MDGeneratorException {

checkMDTableHandler();

try {

mdTableHandler.createMDTable( descrName, className, settings, comment, updateOnInsert );

}

catch ( SQLException e ) {

e.printStackTrace();

throw new MDGeneratorException( "SQL Exception: " + e.getMessage() );

}

}

As you see it invokes the MDTableHandler....

Does this help?

Regards,

Miklos