Subject Re: [Firebird-Java] Jaybird 4, Firebird 4 and DBSchema
Author Mark Rotteveel
On 2019-05-16 16:22, sbailey@... [Firebird-Java]
wrote:
> My java says that it is Oracle Version 8 Update 201 (build
> 1.8.0_201-b09).

Ok, that version should support SHA-256 (unless it's explicitly disabled
using a custom configuration).

> The Jaybird version looks like 11-4.0.0-beta-1.

The 11 is not part of the version, it is part of the classifier that
identifies the target Java version (Java 11 in this case), but that
version cannot run on Java 8, which might indicate that your tool is
using its own JVM.

>> What happens if you specify the Jaybird connection property
>> authPlugins=Srp256 ?
>
> That sounds like you are asking me to edit something in Jaybird's
> configuration. Unfortunately, I don't know how to do that (I'd never
> even heard of it until a few days ago)! If you can give me some
> guidance I shall have a go.

No, that is not part of the configuration of Jaybird itself. It is part
of your connection properties (the configuration of your specific
connection). Connection properties can be part of the JDBC-url, or
possibly specified separately as a set of key-value pairs.

For example, if you connection string is

jdbc:firebirdsql://localhost/employee

you can add the properties to the URL:

jdbc:firebirdsql://localhost/employee?authPlugins=Srp256

(if you need more properties, you separate them by "&" or ";").