OpenACS

gustafn
committed
oacs-5-10:gustafn:20220215180742
on 15 Feb 22
Fixes for Oracle 19c: replaced "limit" by the portable idiom "fetch ... rows only"

This fixes the following bug in Oracle installations:
: … Show more
Fixes for Oracle 19c: replaced "limit" by the portable idiom "fetch ... rows only"

This fixes the following bug in Oracle installations:

:    SQL:

:                select aml_email_id from acs_mail_lite_from_external

:                where processed_p <>'1'

:                and release_p <>'1'

:                order by priority

:                !>>>!limit :email_max_ct

:    nsoracle.c:1367:OracleSelect: error in `OCIStmtExecute ()': ORA-00933: SQL command not properly ended

Show less

openacs-4/.../files/nsd-postgres.txt (+1 -1)
1 1 #!/bin/bash
2 2
3 3 # aolserver4 recommends descriptors limit (FD_SETSIZE) to be set to 1024,
4 4 # which is standard for most OS distributions
5   # For freebsd systems, uncomment following line:
  5 # For FreeBSD systems, uncomment following line:
6 6 # ulimit -n 1024
7 7
8 8 export PATH=$PATH:/usr/local/pgsql/bin
9 9 export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/pgsql/lib:/usr/local/aolserver/lib
10 10
11 11 exec /usr/local/aolserver/bin/nsd $*