Comments (2)
You are right, the cakephp-oracle-driver plugin need more documentation on configs options.
For using the cakephp-oracle-driver without modifing the code, you can use the flags and init options in your config file.
Below an personnal example of cakephp-oracle-driver config in config/app.php
the use of, ['flags'=>'charset'], ['flags=>'persistent'] or ['init'] is not documented
'default' => [
'className' => 'CakeDC\OracleDriver\Database\OracleConnection',
'driver' => 'CakeDC\OracleDriver\Database\Driver\OracleOCI', # For OCI8
'host' => '', # Database host name or IP address or blank for complexe oracle database entry defined in database option
'port' => '', # Database port number (default: 1521)
'username' => 'user1', # Database username
'password' => 'password', # Database password
'database' => '(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=server1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=server1)(PORT=1521)) )(CONNECT_DATA=(SERVICE_NAME=INSTX_TAF)(INSTANCE_NAME=INSTX)(GLOBAL_NAME=INSTD)))',
'flags'=> [
'charset'=>'al32utf8',
'persistent'=>true
],
'init'=>["ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,'"]
from cakephp-oracle-driver.
Thank you very much for the clearness and conciseness of your answer.
from cakephp-oracle-driver.
Related Issues (20)
- Add cacheMetadata key to the config example in README HOT 1
- OracleOCI default configuration HOT 2
- info : cakePHP 3.7+ some deprecated messages (16384) for OracleOCI::connection()
- "FROM DUAL" incorrectly appended when "from" at begin of line HOT 1
- Declaration of CakeDC\OracleDriver\Database\OracleConnection must be compatible with Cake\Database\Connection HOT 4
- NLS_NUMERIC_CHARACTERS problem for ptBR Database HOT 2
- Stored Procedure Problem - ORA 06502, ORA 06512 HOT 1
- array_combine error as a result of find()->toArray() HOT 1
- Pagination error HOT 1
- 5.x queries are always logged without respect of $config['log']
- 5x : strtolower() expects parameter 1 to be string, null given
- 5.x Always quote SELECT identifier for Oracle HOT 1
- 5.x Driver config() function always returns null values
- 5.x Foreign keys not selected
- ORA-00911: invalid character
- OracleBase inccorectly assumes that the tableName does not hold the schema too.
- Plugin for PHP 8 HOT 4
- Reference to non-existing trait
- Support CakePHP 5 HOT 1
- Fatal error: Declaration of CakeDC\OracleDriver\Config\ConfigTrait::config($key = NULL, $value = NULL, $merge = true) must be compatible with Cake\Database\Driver::config(?string $key = NULL, $value = NULL, bool $merge = true): array in C:\xampp\htdocs\prontuariov4\vendor\cakedc\cakephp-oracle-driver\src\Database\Driver\OracleBase.php on line 75
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from cakephp-oracle-driver.