Hi - thanks for pointing that out. The field is also called 'name' in the Oracle schema as well as HSQLDB. Basically in Oracle you can't call a field 'synonym' because it is a reserved keyword.
I'm thinking this might need to be a special-case where the SQL statement should be moved to the database-specific DBHelper class (HypersonicDBHelper, MySQLDBHelper, OracleDBHelper, etc.), as is done with references to the 'seq' column of the 'biosequence' table for instance. Richard Holland Bioinformatics Specialist GIS extension 8199 --------------------------------------------- This email is confidential and may be privileged. If you are not the intended recipient, please delete it and notify us immediately. Please do not copy or use it for any purpose, or disclose its content to any other person. Thank you. --------------------------------------------- > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > bradford powell > Sent: Wednesday, July 06, 2005 3:33 AM > To: biojava-l@biojava.org > Subject: [Biojava-l] field names in term_synonym > > > org.biojava.bio.seq.db.biosql.OntologySQL refers to the 'name' field > of the table 'term_synonym'. The field is only called 'name' in the > hsqldb schema; it is called 'synonym' in the other schemas > (postgresql, mysql, oracle). > > It seems that the references to 'name' should be changed to 'synonym' > in lines 305 and 577 of OntologySQL, and that the hsqldb schema be > corrected to follow the naming schema of the others. > > -- Bradford Powell > > _______________________________________________ > Biojava-l mailing list - Biojava-l@biojava.org > http://biojava.org/mailman/listinfo/biojava-l > _______________________________________________ Biojava-l mailing list - Biojava-l@biojava.org http://biojava.org/mailman/listinfo/biojava-l
