B4J Question jRDC FireBird

[hwatech]

I am experiencing an issue while attempting to connect to a local instance of firebird 3 on windows using jRDC (this is my first attempt to use jRDC). This is very generic example, no changes to the modules except where needed. I have scoured the forum and found many posts on FB/jRDC, but none that specifically address this. To make matters worse, I am very familiar with the error message I am getting...

java.sql.SQLInvalidAuthorizationSpecException: Your user name and password are not defined. Ask your database administrator to set up a Firebird login. [SQLState:28000, ISC error code:335544472]

...but not why I'm getting it. I've used FB for a while now and I've seen this message on a brand new instance when the username/password is typed in incorrectly. But I've verified the credentials many times and used both isql and ibq to connect and query the db manually. Don't get me wrong, this is obviously something that I've done wrong but I just can't find it.

Thanks in advance for any help. --Larry

Here is my pertinent code and log:

#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.

#DATABASE CONFIGURATION
DriverClass=org.firebirdsql.jdbc.FBDriver
JdbcdbcUrl=jdbc:firebirdsql://localhost:3050/C:/Program Files (x86)/Firebird/Firebird_3_0/examples/empbuild/employee.fdb?encoding=UTF8
User=SYSDBA
Password=masterkey
#Java server port
ServerPort=17178

#SQL COMMANDS
sql.select=select FIRST_NAME,LAST_NAME from EMPLOYEE;

'Non-UI application (console / server application)
#Region  Project Attributes
    #CommandLineArgs:
    #MergeLibraries: True
#End Region

'change based on the jdbc jar file
#AdditionalJar: jaybird-full-4.0.1.java11

Sub Process_Globals
    Public srvr As Server
    Public rdcConnector1 As RDCConnector
    Public const VERSION As Float = 2.22
    Type DBCommand (Name As String, Parameters() As Object)
    Type DBResult (Tag As Object, Columns As Map, Rows As List)
End Sub

Sub AppStart (Args() As String)
    srvr.Initialize("")
    rdcConnector1.Initialize
    srvr.Port = rdcConnector1.serverPort
    srvr.AddHandler("/test", "TestHandler", False)
    srvr.AddHandler("/rdc", "RDCHandler", False)
    srvr.Start
    Log($"jRDC is running (version = $1.2{VERSION})"$)
    StartMessageLoop
End Sub

B4J Version: 8.50
Java Version: 11
Parsing code.    (0.01s)
Building folders structure.    (0.01s)
Compiling code.    (0.02s)
Compiling layouts code.    (0.00s)
Organizing libraries.    (0.00s)
Compiling generated Java code.    (0.00s)
Building jar file.    (2.35s)
Jar file created: D:\Devel\Projects\B4J\jRDC\Objects\jRDC.jar
Running application.    (0.01s)
Completed successfully.

2020-09-27 18:21:04.586:INFO::main: Logging initialized @211ms to org.eclipse.jetty.util.log.StdErrLog
Sep 27, 2020 6:21:04 PM com.mchange.v2.log.MLog
INFO: MLog clients using java 1.4+ standard logging.
Sep 27, 2020 6:21:05 PM com.mchange.v2.c3p0.C3P0Registry
INFO: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
2020-09-27 18:21:05.352:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 11.0.1+13
2020-09-27 18:21:05.384:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2020-09-27 18:21:05.384:INFO:oejs.session:main: No SessionScavenger set, using defaults
2020-09-27 18:21:05.386:INFO:oejs.session:main: node0 Scavenging every 600000ms
2020-09-27 18:21:05.392:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@15d49048{/,file:///D:/Devel/Projects/B4J/jRDC/Objects/www,AVAILABLE}
2020-09-27 18:21:05.396:INFO:oejs.AbstractNCSARequestLog:main: Opened D:\Devel\Projects\B4J\jRDC\Objects\logs\b4j-2020_09_27.request.log
2020-09-27 18:21:05.417:INFO:oejs.AbstractConnector:main: Started ServerConnector@2f666ebb{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
2020-09-27 18:21:05.418:INFO:oejs.Server:main: Started @1051ms
jRDC is running (version = 2.22)
Sep 27, 2020 6:21:25 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource
INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1hge165ac1m8bwmaxafg12|75329a49, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> org.firebirdsql.jdbc.FBDriver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge165ac1m8bwmaxafg12|75329a49, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:firebirdsql://localhost:3050/employee?encoding=UTF8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800...
Sep 27, 2020 6:22:52 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@3b0f991c -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLInvalidAuthorizationSpecException: Your user name and password are not defined. Ask your database administrator to set up a Firebird login. [SQLState:28000, ISC error code:335544472]
    at org.firebirdsql.gds.ng.FbExceptionBuilder$Type$4.createSQLException(FbExceptionBuilder.java:579)
    at org.firebirdsql.gds.ng.FbExceptionBuilder.toFlatSQLException(FbExceptionBuilder.java:304)
    at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readStatusVector(AbstractWireOperations.java:140)
    at org.firebirdsql.gds.ng.wire.AbstractWireOperations.processOperation(AbstractWireOperations.java:204)
    at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readOperationResponse(AbstractWireOperations.java:163)
    at org.firebirdsql.gds.ng.wire.version13.V13WireOperations.authReceiveResponse(V13WireOperations.java:124)
    at org.firebirdsql.gds.ng.wire.version10.V10Database.authReceiveResponse(V10Database.java:569)
    at org.firebirdsql.gds.ng.wire.WireConnection.identify(WireConnection.java:335)
    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:145)
    at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:599)
    at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:65)
    at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:109)
    at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:114)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: org.firebirdsql.jdbc.FBSQLExceptionInfo: Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
Sep 27, 2020 6:22:52 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@6bb60380 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.

 

[EnriqueGonzalez]

my best guess is this line:
jdbc:firebirdsql://localhost:3050/C:/Program Files (x86)/Firebird/Firebird_3_0/examples/empbuild/employee.fdb?encoding=UTF8

you either connect to a host: port or to a file. try removing one or the other and test. it is likely that the one really attached to that port has indeed a diferent user and password

 

[amorosik]

Using Firebird 3 and the Ado-net provider it is necessary to disable the wire-encrypted protocol, perhaps this is also the case with the java driver
Just add the three lines indicated in the link to firebird.conf
Firebird wire_encrypt disable
WireCrypt = Disabled
AuthServer = Legacy_Auth, Srp, Win_Sspi
AuthClient = Legacy_Auth, Srp, Win_Sspi

Let us know

 

[amorosik]

In my program i use jSQL 1.61 library with code :

#AdditionalJar: jaybird-full-4.0.0.java8.jar    <<<======
 
Db_Driver_Class="org.firebirdsql.jdbc.FBDriver"
Db_Jdbc_Url="jdbc:firebirdsql://127.0.0.1:3050/C:/PIPPO/ERP2_30.fdb"
Db_Username="gigietoni"
Db_Password= "ciucciamariuccia"
 
MyDB.Initialize2(Db_Driver_Class,Db_Jdbc_Url,Db_Username,Db_Password)
Dim MyRs As ResultSet = MyDB.ExecQuery("select * from CUSTOMER")
 
Do While MyRs.NextRow
    id_cust = MyRs.GetLong("ID_CUSTOMER")
    cust_name= MyRs.GetString("NAME")
    ........
    Loop

 

[OliverA]

1) Try

JdbcdbcUrl=jdbc:firebirdsql://localhost:3050/C:/Program%20Files%20(x86)/Firebird/Firebird_3_0/examples/empbuild/employee.fdb?encoding=UTF8

Reason: Spaces need to be URL encoded
2) Try creating a DB that is not in Program Files (x86)
Reason: That is a write protected folder and may give you issues (including, guessing, logging into the DB)

 

[hwatech]

I thank you all for your advice and I have implemented each suggestion but to no avail, I am still having the same issue. Here's a recap of things I've done.


I've created a new database and placed it in a non-admin location. I am able to connect with isql and ibq but not via jdbc2 . After seeing the suggestion from OliverA, I was really thinking that the location of the db was going to be the problem...

I altered the JdbcUrl in many ways, I escaped the spaces also suggested by OliverA,

#DATABASE CONFIGURATION
DriverClass=org.firebirdsql.jdbc.FBDriver
JdbcUrl=jdbc:firebirdsql://localhost:3050/D:/Devel/Projects/B4J/jRDC/employee.fdb?encoding=UTF8
#JdbcUrl=jdbc:firebirdsql://localhost:3050/employee?encoding=UTF8
#JdbcUrl=jdbc:firebirdsql://localhost:3050/C:/Program%20Files%20(x86)/Firebird/Firebird_3_0/examples/empbuild/employee.fdb?encoding=UTF8
#JdbcUrl=jdbc:firebirdsql://localhost:3050/C:/Program Files (x86)/Firebird/Firebird_3_0/examples/empbuild/employee.fdb?encoding=UTF8
#User=SYSDBA
#Password=materkey
User=doc
Password=pa55word
#Java server port
ServerPort=17178

I used an alias as defined in databases.conf so no spaces existed

# ------------------------------
# List of known databases
# ------------------------------

#
# Makes it possible to specify per-database configuration parameters.
# See the list of them and description on file firebird.conf.
# To place that parameters in this file add them in curly braces
# after "alias = /path/to/database.fdb" line. Example:
#    big = /databases/bigdb.fdb
#    {
#        LockMemSize = 32M        # We know that bigdb needs a lot of locks
#        LockHashSlots = 19927    #    and big enough hash table for them
#    }
#

#
# Example Database:
#
#employee.fdb = $(dir_sampleDb)/employee.fdb
#employee = $(dir_sampleDb)/employee.fdb

#
# Master security database specific setup.
# Do not remove it until you understand well what are you doing!
#
security.db = $(dir_secDb)/security3.fdb
{
    RemoteAccess = false
    DefaultDbCachePages = 50
}

#
# Live Databases:
#
employee.fdb = D:\Devel\Projects\B4J\jRDC\employee.fdb
employee = D:\Devel\Projects\B4J\jRDC\employee.fdb

I changed the firebird.conf as suggested by amorosik and of course restarted the firebird process
l
I've tried using the local IP address rather than localhost, and tried 127.0.0.1

I created a new user/password and enabled admin rights for that user

At one point after changing from jaybird-full-4.0.1.java11 to jaybird-4.0.1.java11 I got a different error that

no suitable driver found

then on the next run it was back to the username/password error



I also ran the jar file from a command prompt but got the same results

D:\Devel\Projects\B4J\jRDC\Objects>D:\Devel\jdk-11.0.1\bin\java -jar jrdc.jar

2020-09-28 13:44:15.941:INFO::main: Logging initialized @193ms to org.eclipse.jetty.util.log.StdErrLog
Sep 28, 2020 1:44:16 PM com.mchange.v2.log.MLog
INFO: MLog clients using java 1.4+ standard logging.
Sep 28, 2020 1:44:18 PM com.mchange.v2.c3p0.C3P0Registry
INFO: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
2020-09-28 13:44:18.714:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 11.0.1+13
2020-09-28 13:44:18.749:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2020-09-28 13:44:18.749:INFO:oejs.session:main: No SessionScavenger set, using defaults
2020-09-28 13:44:18.752:INFO:oejs.session:main: node0 Scavenging every 600000ms
2020-09-28 13:44:18.757:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@13526e59{/,file:///D:/Devel/Projects/B4J/jRDC/Objects/www,AVAILABLE}
2020-09-28 13:44:18.764:INFO:oejs.AbstractNCSARequestLog:main: Opened D:\Devel\Projects\B4J\jRDC\Objects\logs\b4j-2020_09_28.request.log
2020-09-28 13:44:18.786:INFO:oejs.AbstractConnector:main: Started ServerConnector@4b2c5e02{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
2020-09-28 13:44:18.788:INFO:oejs.Server:main: Started @3045ms
jRDC is running (version = 2.22)
Sep 28, 2020 1:44:28 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource
INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1hgeidyac1ndvryu1ld6p8t|7f010382, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> org.firebirdsql.jdbc.FBDriver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hgeidyac1ndvryu1ld6p8t|7f010382, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:firebirdsql://localhost:3050/D:/Devel/Projects/B4J/jRDC/employee.fdb?encoding=UTF8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 150, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {password=******, user=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> true, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
Sep 28, 2020 1:45:55 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@4cc3fa5d -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLInvalidAuthorizationSpecException: Your user name and password are not defined. Ask your database administrator to set up a Firebird login. [SQLState:28000, ISC error code:335544472]
        at org.firebirdsql.gds.ng.FbExceptionBuilder$Type$4.createSQLException(FbExceptionBuilder.java:579)
        at org.firebirdsql.gds.ng.FbExceptionBuilder.toFlatSQLException(FbExceptionBuilder.java:304)
        at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readStatusVector(AbstractWireOperations.java:140)
        at org.firebirdsql.gds.ng.wire.AbstractWireOperations.processOperation(AbstractWireOperations.java:204)
        at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readOperationResponse(AbstractWireOperations.java:163)
        at org.firebirdsql.gds.ng.wire.version13.V13WireOperations.authReceiveResponse(V13WireOperations.java:124)
        at org.firebirdsql.gds.ng.wire.version10.V10Database.authReceiveResponse(V10Database.java:569)
        at org.firebirdsql.gds.ng.wire.version10.V10Database.attachOrCreate(V10Database.java:111)
        at org.firebirdsql.gds.ng.wire.version10.V10Database.attach(V10Database.java:81)
        at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:148)
        at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:599)
        at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:65)
        at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:109)
        at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:114)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
        at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: org.firebirdsql.jdbc.FBSQLExceptionInfo: Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

I am noticing that it can take up to a minute for the error messages to appear in the logs in the IDE, not sure that has anything to do with it but I thought I'd mention it. I'm guessing that this has to do with the timeouts and retries more than anything

I have been able to get the whole thing to work with mysql and postgresql but not firebird. I will continue to try to get this to work as my project is supposed to use a firebird db. I am confident that there is a solution, I just hope it's not something completely stupid on my part...

--Larry

 

[amorosik]

Can you post a complete mini-program WITH the problem?
We can try on our system

 

[DMW]

Hi,
I don't pretend to be a FB db specialist but so far I have only been able to use FB 2.5 to open a local db with the following snippet (primitive) code:

#Region Project Attributes 
    #MainFormWidth: 600
    #MainFormHeight: 600 
    #AdditionalJar : jaybird-full-2.2.15.jar
#End Region

...

Dim fbSQL As SQL
   
    Dim stSQL As String = $"SELECT Country, Currency FROM Country;"$
    Dim Cursor As ResultSet
   
    fbSQL.Initialize2("org.firebirdsql.jdbc.FBDriver","jdbc:firebirdsql://localhost:3050/C:\Program Files\Firebird\Firebird_2_5\examples\empbuild\EMPLOYEE.FBD?encoding=NONE","SYSDBA","masterkey")
    Cursor = fbSQL.ExecQuery(stSQL)
   
    Do While Cursor.NextRow
        Log(Cursor.GetString("Country") & "_" & Cursor.GetString("Currency"))
    Loop
   
    Cursor.Close
    fbSQL.Close

 

[MiguelL]

Hi,
I'm new also and tried out the sample example from Erel's video tutorial:

Not important for your problem, but in addition to my experience:
As unluckily my DB is also named "test", It cost me several hours to realize the "test" in "localhost/test" has nothing to do with the DB, but with the way the testhandler is setup. (yes ... VERY new here )

More relevant maybe:
For me, this works. (I've seen you use Jdbcdbcurl):
JdbcUrl=jdbc:firebirdsql://localhost:3050/C:/FireBird/DB/TEST.FDB?characterEncoding=utf8

I'm using Firebird 3 - 64 bit, installed as Superserver.
BTW: You don't have to do anything with XAMPP or similar for this part of the connection to work.

HIH
MiguelL

 

[hwatech]

Thanks all for the input, I will try all suggestions and report back, but in the meantime, I convinced the client to allow me to use a postgresql db and all is well. I am starting to believe that it's not my code but the way I have fb setup, I'm going to tear down the server and rebuild from scratch to see if that helps. One complication is that the server is freebsd and I'm limited to the 2.5 release...

Thanks again

 

[MiguelL]

Thanks all for the input, I will try all suggestions and report back, but in the meantime, I convinced the client to allow me to use a postgresql db and all is well. I am starting to believe that it's not my code but the way I have fb setup, I'm going to tear down the server and rebuild from scratch to see if that helps. One complication is that the server is freebsd and I'm limited to the 2.5 release...

Thanks again

2.5? Yes that might probably explain it. For example Jaybird 4.0.1 no longer supports FB 2.0 and 2.1. (2.5?). Also every jdbc driver has a range of Java which it supports. Jaybird 4.0.1 for example needs Java to be higher than java 8. https://www.firebirdsql.org/file/do....0.x/release_notes.html#compatibility-changes
regards

 

[incendio]

When using Firebird, you must set

WireCrypt = Enabled

in firebird.conf file,don't set AuthServer or AuthClient , also, I didn't use jaybird 4, I use jaybird-full-3.0.2.jar, runs OK with firebird 3.