You'd have to 1) Install OpenACS http://openacs.org/
or 2) try to extract the database api procedures in
http://cvs.openacs.org/cvs/openacs-4/packages/acs-tcl/tcl/
00-database-procs.tcl
00-database-procs-postgresql.tcl
00-database-procs-oracle.tcl
and take the queries out of the XML files
00-database-procs-postgresql-postgresql.xql into the tcl library file
(due to datbase abstraction technique specific to OpenACS.)
The code relies on a configuration param in your AOLserver config file also see
return [nsv_get ad_database_type .] where there is an nsv variable
set on startup to decide oracle or postgresql.
This was just a quick review there might be other stuff you will need
to make it work.
OpenACS also has automatic database handle handling (sorry couldn't
think of a better word for that.)
This contains the postgresql bind variable emulation implementation as
well that replaces tcl variables in the query string.
Here is an overview of how the database api works.
http://openacs.org/doc/current/db-api.html
Dave
On Wed, Apr 2, 2008 at 3:49 PM, Xavier Bourguignon <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> Does anybody know what is required to use "OpenAcs DB API" for
> accessing Postgres DB within aolserver?
>
> Thank you
>
> --
> Xavier Bourguignon
>
>
> --
> AOLserver - http://www.aolserver.com/
>
> To Remove yourself from this list, simply send an email to <[EMAIL
> PROTECTED]> with the
> body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
> field of your email blank.
>
--
Dave Bauer
[EMAIL PROTECTED]
http://www.solutiongrove.com
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.
