- 382.3K All Categories
- 2.1K Data
- 209 Big Data Appliance
- 1.9K Data Science
- 447.9K Databases
- 220.9K General Database Discussions
- 25 Multilingual Engine
- 522 MySQL Community Space
- 465 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 492 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.1K SQL & PL/SQL
- 21K SQL Developer
- 293.2K Development
- 7 Developer Projects
- 128 Programming Languages
- 290K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 264 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 228 Portuguese
JVM in Oracle Database - How to store sensitive data in memory only ?
One of my customers requests me to develop a PL/SQL package that will connect and retrieve sensitive data from a Web Service.
I plan to use Java in Oracle Database to connect and retrieve data from the Web Service.
I've already done some tests and it seems easy to implement.
But for security and performance reasons, I need to store these sensitive data in memory.
These sensitive data will only be changed every 10 minutes. Therefore, for performance reasons, there is no need to connect and retrieve data from the Web Service each times an Oracle session call my PL/SQL package.
At first call to my PL/SQL package, I retreive the data from the Web Service then I should store these data either in Java or in Database to provide them quickly to further calls to my PL/SQL package.
For security reasons, I can not store these data in a table or a file. These sensitive data must be stored in memory.
Either in Java memory or in Database memory.
So my questions are:
Is there a way to store data in memory and share them between JVM ?
Can I create an in-memory Java object that I can access from multiple JVM ?
Like a file but in memory.
Don't forget this JVM is in the Oracle Database.
Is there a way to store data in memory and share them between Oracle session ?
Can I create an in-memory object that I can access from multiple Oracle session ?
Like a table but in memory only.
Last solution would be to create a tmpfs or ramfs on the database linux server and access it with Java.
I will continue to search the web for the best solution.
But any ideas are welcomed.
Thanks for your help,
Oracle session and JVM calls is explained here
each Oracle session has its own JVM (Not really but the Oracle session see its JVM as its own one)