I do not think primarykey is supported on Oracle. We can do this
quickly but we will need your help with tests.
@Denes, can you help with this as well?
On Aug 23, 10:14 pm, tomt <tom_tren...@yahoo.com> wrote:
> I recently tried to access some legacy tables in an Oracle database
> with web2py. The connection string and model I generated in db.py
> allows successful connection and queries from the command line are
> successful, when I try to use the web2py database administration
> function I get the following error:
>
> Invalid Query ORA-00907: missing right parenthesis
>
> The connection string is:
> db = DAL('oracle://username:password@database')
>
> And a typical table in the model looks like this:
> db.define_table('tablename',
> Field('column1','integer'),
> Field('column2','string'),
> Field('column3','integer'),
> Field('column4','integer'),
> primarykey=['column1'],
> migrate=False
> )
> (The first column is unique but it is NOT autoincrementing)
>
> I don't expect to be able to edit these tables with the dbadmin tool,
> but I thought I would be able to view the rows. (I have had success
> with legacy tables in mysql)
>
> Perhaps there is something unusual about my Oracle tables, but I'm not
> sure where to start debugging this problem. Any suggestions?
>
> Thanks, -Tom
