I'm having trouble connectiong to Firebird database (jaybird driver) from JBoss 7.1.0 CR1
This is the log:
JBAS014775: New missing/unsatisfied dependencies:
service jboss.jdbc-driver.firebirdsql (missing) dependents: [service…
I am new to Liferay 7.x and am having trouble with, I suspect, OSGI.
I am trying to write an DB Authenticator which just checks for users in a separate DB. The DB is a FirebirdSQL DB.
When setting the depenency in build.gradle like…
After a Firebird database crash the connections of the JDBC pool become invalid. (We have to flush the pool manually.) A good concept might be to use jdbc connection pool validation.
Connection validation properties
I am not sure what is the…
I'm trying to connect to a Firebird database hosted in a Docker from the DataGrip client, but this error appears:
WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding
[42000][335544851] Dynamic SQL…
I connect with names in capital letters, but it does not want to connect with small letters in the login.
Here is a small test
String ENCODING = "WIN1251";
String CONNECTION_URL = "jdbc:firebirdsql:localhost:C:/ProgramData/test.FDB";
Properties…
I'm developing a RESTful application and whenever I make a request, it works fine, but also outputs these warnings:
o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Warning Code: 0, SQLState: null
o.h.engine.jdbc.spi.SqlExceptionHelper :…
I'm trying to insert a file in a blob field in a Firebird database using lib jaybird 2.1.6.
First, I create a record in my database, then, with the id of record, I try to insert my file in a blob (subtype 0) field.
Here is my code:
public static…
I try to make 2 queries from a Firebird 2.5 DB. I use two separate Statement objects, but when in second query program try to use data from first query, it gets an error:
java.sql.SQLException: The result set is closed.
conn =…
I am using JDBC connection to firebird.
org.firebirdsql.jdbcjaybird-jdk183.0.5
When I am reading data with:
resultSet.next(); //resultSet is instance of FBResultSet
sometimes thread…
My problem very close the one mentioned in Using UUID PK or FK in Firebird with Jooq
Setup:
Jaybird 3.0.5, Firebird 2.5.7, jOOQ 3.11.7, JDK 1.8
My PK and FK fields like
ID CHAR(16) CHARACTER SET OCTETS NOT NULL
and
TABLE_ID CHAR(16) CHARACTER SET…
I'm working on a spring boot rest project. I have a web service that is searching a text in multiple fields. I'm using java specification to generate query.
Resulting query is like that
select *
from V_AGENCY agencyview0_
where…
I cloned a Java project in NetBeans 8.2 on Mac OS High Sierra that uses a Firebird database using jars jaybird-2.2.8.jar and jaybird-full-2-2-8.jar and it works well on computers with Windows 8.2 and 10, and Linux Ubuntu 16.04. The Firebird engine…
I'm trying to build a successful connection to a Firebird DB running on Windows using Spring Data JPA, Hibernate and a HikariCP Connection Pool. I have gotten everything to run correctly on other JDBC compliant DBs (H2, Derby, MySQL, etc.) but when…
I have a Firebird DB file, test.fdb in some directory, I want to access the DB from java application. What are the required libraries files to access.
I am using Jaybird JDBC Driver to access the embedded Firebird database, but I'm getting the…
