# jsreport-oracle-store

> Extension allowing to store template in Oracle Database

Latest version **0.2.0** (published 2021-04-16) · 0 weekly downloads

## Install

```sh
npm install jsreport-oracle-store
pnpm add jsreport-oracle-store
yarn add jsreport-oracle-store
bun add jsreport-oracle-store
```

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support; pre 1.0.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 0.2.0 |
| Published | 2021-04-16 |
| First published | 2021-04-16 |
| Weekly downloads | 0 |
| TypeScript types | none |
| Module format | CommonJS |
| Node | >=14.0.0 |
| Dependencies | 2 |
| Unpacked size | 12 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 1 |
| Author | Jan Blaha |
| Maintainers | pofider |

## Links

- npm: https://www.npmjs.com/package/jsreport-oracle-store
- Repository: https://github.com/jsreport/jsreport-oracle-store
- Homepage: https://github.com/jsreport/jsreport-oracle-store#readme
- Issues: https://github.com/jsreport/jsreport-oracle-store/issues
- npm.io page: https://npm.io/package/jsreport-oracle-store

## Dependencies (2)

- [oracledb](https://npm.io/package/oracledb.md) 5.1.0
- [jsreport-sql-store](https://npm.io/package/jsreport-sql-store.md) 1.4.2

## Recent versions

- 0.2.0 (latest) — 2021-04-16

## README

# jsreport-oracle-store

[![NPM Version](http://img.shields.io/npm/v/jsreport-oracle-store.svg?style=flat-square)](https://npmjs.com/package/jsreport-oracle-store)
[![Build Status](https://travis-ci.com/jsreport/jsreport-oracle-store.png?branch=master)](https://travis-ci.com/jsreport/jsreport-oracle-store)

**[jsreport](https://github.com/jsreport/jsreport) template store extension allowing to persist data in [Oracle database](https://www.oracle.com/database/)**


## Installation

**Only version 12 or higher is supported**

1. Install instant client basic: [oracle-instant-client](https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html)

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
```js
{
	"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](https://github.com/jsreport/jsreport-core)

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

---
_Source: https://npm.io/package/jsreport-oracle-store · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._