With the October patch OCT 2020 PSU, Oracle has changed the internal JVM contained in the Oracle Database from version JDK 1.6 to JDK 1.7. Unfortunately, a statically initialized field from a nested class was affected by the modified behavior of the Java runtime in version 1.7. An indication of this fatal behavior is when […]
Knowledge Base
OpenPGP Knowledge Base (Java, C#, VB.NET examples and solutions)
Blazor server app with PGP encryption
Recently we were asking ourselves will OpenPGP Library for .NET work in a Blazor application. As you probably know there are two types of Blazor applications, server and WASM (web assembly). In this article, we will demonstrate the usage of the library in a server application. For WASM a few words will be said at […]
Recent updates in the Oracle PL/SQL extensions product line (April)
OraSFTP OraSFTP is now in version 1.4.7 with recent enhancements being a fix for connecting to SFTP server FileMage Gateway located on Azure and a new method that allows setting remote file permissions. OraRSA OraRSA has been updated to version 1.3.4 with a different set of setup files for Oracle 11-18 and Oracle19. A set […]
New authentication methods in OraSFTP
OraSFTP version 1.4.5 adds support for Elliptic Curve based SFTP key exchange and public-key signatures. The complete list of new cryptography enhancements in this version is available below: Key exchange (KEX) An SSH session begins with a cryptographic exchange based on asymmetric cryptography algorithms, in order for the client and the server to agree on […]
OraRSA with CMS cryptography, OraSFTP with WGET
In the past few months, we have released a couple of updates to both OraRSA and OraSFTP. OraRSA The newest version of OraRSA now provides CMS (Cryptography Message Syntax) support. Encrypting, signing, decrypting and verifying CMS data is now supported from PL/SQL. OraSFTP Custom timeout adjustment is now possible when establishing an SFTP connection. A […]
java.sql.SQLException: ORA-00942: table or view doesn’t exist
When loading one of our addon products for the Oracle© Database, with the loadjava tool, you may encounter the error: java.sql.SQLException: ORA-00942: table or view doesn’t exist The reason for the above error is that the schema (database login account) under which the loadjava must store the JAR files of our addon doesn’t have sufficient […]
OraRSA is a proven solution for the German energy sector
As of August 1, 2019, the RSASSA-PSS digital signing algorithm must be used by all operators in the German energy and water industry sector. The ORA_SMIME package that ships with DidiSoft OraRSA have already been verified by two Geman TSO organizations to fulfill the S/MIME email format requirements for exchanging electric energy supply information. ORA_SMIME […]
Custom storage and key modification events for the KeyStore class
DidiSoft OpenPGP Library for .NET till now offered only a file-based mass key storage and temporary in-memory located one. In the latest version 1.9.1.31 has been implemented extended support for a custom key storage location. An example of such storage of the keys is a BLOB field in a database. In addition, this version of […]
Custom storage for the KeyStore class
As of version 3.2.1 DidiSoft OpenPGP Library for Java offers a custom storage mechanism for its KeyStore class. Up till now, the KeyStore class was limited to in-memory and file-based storage. If an application design required the keys to be stored on a different kind of media, for example in a database BLOB field, the […]
“ORA-01536: space quota exceeded for tablespace ‘USERS”
Loading Java stored procedures in Oracle© Databases with the loadjava utility you may encounter errors with error messages: “ORA-01536: space quota exceeded for tablespace ‘USERS” Such error indicates that the schema where the Java classes needed for the stored procedure has surpassed its tablespace quota. The easiest way to overcome this error and continue with […]