java.util.ServiceConfigurationError: org.firebirdsql.gds.impl.GDSFactoryPlugin: Error reading configuration file from Java Stored Procedure in Oracle

[Altiy Zemlytskiy]

I loaded with loadjava tool jaybird-jdk18-3.0.10-20201219.134254-1.jar driver and my java class to Oracle database. All classes were resolved. When I run Java Stored Procedure from Oracle first time got exception stacktrace

java.sql.SQLException: No message for code 335544421 found. [SQLState:HY000, ISC error code:335544421]

at org.firebirdsql.gds.ng.FbExceptionBuilder$Type$1.createSQLException(FbExceptionBuilder.java:532)

at org.firebirdsql.gds.ng.FbExceptionBuilder.toFlatSQLException(FbExceptionBuilder.java:302)

at org.firebirdsql.gds.ng.wire.WireConnection.identify(WireConnection.java:326)

at org.firebirdsql.gds.ng.wire.FbWireDatabaseFactory.performConnect(FbWireDatabaseFactory.java:51)

at org.firebirdsql.gds.ng.wire.FbWireDatabaseFactory.connect(FbWireDatabaseFactory.java:39)

at org.firebirdsql.gds.ng.wire.FbWireDatabaseFactory.connect(FbWireDatabaseFactory.java:32)

at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:142)

at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:558)

at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:65)

at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:124)

at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:143)

at java.sql.DriverManager.getConnection(DriverManager.java)

at java.sql.DriverManager.getConnection(DriverManager.java)

at org.wgsoftpro.ads.ADSConnect.getConnection(ADSConnect.java:137)

at org.wgsoftpro.ads.ADSConnect.getConnection2Source(ADSConnect.java:252)

at org.wgsoftpro.ads.ADSConnect.readResultSet(ADSConnect.java:68)

at org.wgsoftpro.ads.ADSConnect.readResultSet(ADSConnect.java:121)

at org.wgsoftpro.ads.ADSConnect.getResultSet(ADSConnect.java:50)

at org.wgsoftpro.ads.ADSConnect.getResultSetbyStringID(ADSConnect.java:43)

Caused by: org.firebirdsql.jdbc.FBSQLExceptionInfo: No message for code 335544421 found.

Checked error code 335544421 from FAQ, username and login are not null, nothing is mentioned in firebird.log, WireCrypt = enabled in firebird.conf, paragraph 3.4.5 - I think is not my case.  

[Mark Rotteveel]

On 20-12-2020 13:09, Altiy Zemlytskiy wrote:
> I loaded with loadjava tool jaybird-jdk18-3.0.10-20201219.134254-1.jar
> driver and my java class to Oracle database. All classes were resolved.
> When I run Java Stored Procedure from Oracle first time got exception
> stacktrace
> java.sql.SQLException: No message for code 335544421 found.
> [SQLState:HY000, ISC error code:335544421]

[..]

> Checked error code 335544421 from FAQ, username and login are not null,
> nothing is mentioned in firebird.log, WireCrypt = enabled in
> firebird.conf, paragraph 3.4.5 - I think is not my case.

As I mentioned in the comments on Stack Overflow, it looks like the way
Jaybird was loaded into Oracle has either corrupted something, or it did
not include the resources.

It looks like Jaybird cannot load some of its resources, as demonstrated
by your earlier problem where Jaybird could not initialize some of its
internal plugins (which means it cannot read the service definition
resources in META-INF/services), and by the fact that you get a "No
message for code 335544421 found." instead of "connection rejected by
remote interface" (which means that isc_error_msg.properties cannot be
loaded or is otherwise corrupted).

If we follow that lead, then likely Jaybird also couldn't load the
resources driver_property_info.properties and isc_dpb_types.properties,
which are essential for the connection properties to work correctly.

Check if the following resources exists in your Oracle database (I don't
know loadjava, so I cannot provide specifics):

META-INF/services/java.sql.Driver
META-INF/services/org.firebirdsql.encodings.EncodingSet
META-INF/services/org.firebirdsql.gds.impl.GDSFactoryPlugin
META-INF/services.org.firebirdsql.gds.ng.wire.ProtocolDescriptor
org/firebirdsql/jdbc/jaybird_error_msg.properties
org/firebirdsql/jdbc/jaybird_error_sqlstates.properties
org/firebirdsql/jdbc/version.properties
translation/hpux.properties
driver_property_info.properties
isc_dpb_types.properties
isc_error_message.properties
isc_error_sqlstates.properties
isc_tpb_mapping.properties

Mark
--
Mark Rotteveel

[Altiy Zemlytskiy]

Many thanks, Mark. I need some time to find out the issue. For the moment I see just classes from jar in Oracle. There are not any META-INF/* or *.properties

воскресенье, 20 декабря 2020 г. в 14:51:48 UTC+2, ma...@lawinegevaar.nl:

[Altiy Zemlytskiy]

Mark,

all metioned files are present in oracle data base

 

воскресенье, 20 декабря 2020 г. в 15:56:37 UTC+2, Altiy Zemlytskiy:

[Mark Rotteveel]

On 20-12-2020 15:59, Altiy Zemlytskiy wrote:
> all metioned files are present in oracle data base

All things point to the fact that Jaybird can't load them (or, if it can
load them, that the content is somehow garbled). Given my lack of
knowledge of Oracle's loadjava, I'm not really sure what you would need
to check or look at next.

Mark
--
Mark Rotteveel

[Altiy Zemlytskiy]

ok, thank you for your time

воскресенье, 20 декабря 2020 г. в 17:19:59 UTC+2, ma...@lawinegevaar.nl: