How to write from Xpages to PostgreSql database?

Question

I have to create an Xpage web application which directly inputs data in a PostgreSql database. I've never worked with a PostgreSql database so I have absolutely no idea on how to approach this.

The application will be used through a browser if that matters.

Any help would be highly appreciated.

score 2 · Answer 1 · edited May 23 '17 at 12:27

2

You need to use a JDBC connection to connect to PostgreSQL. Use the extension library. This library contains a demo application which connects to a sql database using JDBC. Please take a look at this question : How do I access SQL from XPages.

edited May 23 '17 at 12:27

Community

1
1

answered Sep 14 '12 at 10:08

jjtbsomhorst

1,667
11
28

score 2 · Accepted Answer · answered Sep 14 '12 at 11:25

or, if you do not want to use the extLib for this purpose only, take a look at http://www.eknori.de/2011-07-03/using-mysql-data-in-xpages/ The article describes, how to access MySQL, but you can use the same code even for PstGreSQL with the correct JDBC drive. The article also contains a link to OpenNTF where you can download the full source code.

How to write from Xpages to PostgreSql database?

2 Answers2