pofider/jsreport-oracle-store

jsreport-oracle-store

jsreport template store extension allowing to persist data in Oracle database

Installation

Only version 12 or higher is supported

1. Install instant client basic: oracle-instant-client

2. set environment variables e.g. for 18.5

ORACLE_HOME=/usr/lib/oracle/18.5/client64
PATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib

3. npm install jsreport-oracle-store

4. Alter jsreport configuration

{
	"store": {
		"provider": "oracle"
	},
	"extensions": {
		"oracle-store": {
			"user": "jsreport",
			"password": "password",
			"connectionString": "localhost:1521/XEPDB1",
			"poolMin": 0,
			"poolMax": 20,
			"poolIncrement": 1
		}
	}
}

After jsreport initializes you should see tables like jsreport.TemplateType and others in jsreport database.

Schema changes

If you do changes to the database schema by enabling additional extensions you need to drop the affected tables and let jsreport to reinitialize them.

jsreport-core

You can apply this extension also manually to jsreport-core

var jsreport = require('jsreport-core')()
jsreport.use(require('jsreport-oracle-store')({ server: '...'}))