All Questions
72 questions
0
votes
0
answers
68
views
Firebird-Postgres replication using Kafka
We have a bunch of sql queries running once a day to replicate data from Firebird to Postgres. I am working on moving this ETL process to Kafka. Some tables are large and requires immediate ...
-2
votes
1
answer
87
views
Firebird jdbc connection error: no suitable Driver instance
When I'm trying to connect db with Java application, I'm facing below error.
caused by: java.lang.runtimeexception: failed to get driver instance for jdbcurl=jdbc:firebirdsql://veddb.floor:3050/c:\...
- 1
1
vote
1
answer
426
views
Firebird JDBC connection pool validation on Payara server
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 ...
1
vote
2
answers
1k
views
Firebird connection using Spring Boot
How to create a Firebird connection using Spring Boot to make views in SQL using the Firebird database? I have no idea how to build this.
try {
Class.forName("org.firebirdsql.jdbc.FBDriver&...
- 21
0
votes
1
answer
816
views
java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver
I am not able to access the Firebird configuration string, and it works perfectly in MySQL.
package testej;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
...
1
vote
1
answer
655
views
FBDriver reporting warnings I can't figure out how to fix
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....
0
votes
1
answer
417
views
Why useFirebirdAutocommit=true won't work and additionally disable JDBC autocommit
I use to connect with Firebird:
org.apache.commons.dbcp2.BasicDataSource;
But if I set:
ds.addConnectionProperty("autoCommit", "true");
ds.addConnectionProperty(...
- 1
0
votes
2
answers
2k
views
No suitable driver found for jdbc:firebirdsql://localhost:3050
I build a javafx maven app , using jaybird dependency . Every thing work fine from intelliJ.
when i export the jar file ,I receive this message :
No suitable driver found for jdbc:firebirdsql://...
- 23
0
votes
0
answers
126
views
Intermittent connection success to Firebird 1.5.4 using RazorSQL 9.3 and included (current) Firebird JDBC driver
I'm connecting to a set of Firebird 1.5.2 servers (2.4.20 Linux kernel - circa 2003. These are a closed, end of life system serving a telephony application (Service Control Point) in an SS7 switching ...
1
vote
1
answer
3k
views
Get an error when connecting to Firebird database
Springboot:
pom.xml
org.firebirdsql.jdbc jaybird 4.0.0.java8
application.properties
spring.datasource.url=jdbc:firebirdsql://SERVER:3050/D:\company\DbPro\Data\file.fdb
spring.datasource....
- 11
0
votes
0
answers
87
views
Using SymmetricDS to connect to a firebird database [duplicate]
I want to synchronise two databases, one of them being a Firebird database. I am currently trying to use SymmetricDS for this. I am having trouble connecting to a Firebird database, unfortunately:
...
0
votes
0
answers
134
views
Subscribe to Firebird events using a Jdbc driver for connection?
I am writing an application in a B4J environment with data connection on Firebird.
https://www.b4x.com/b4j.html
B4J uses the Firebird Jdbc driver for communication between the application and the db ...
- 1
0
votes
0
answers
820
views
How to Use JDBC Driver (Jaybird) on Android?
I had done a lot of searches about how to connect an android app to a firebird DB but still cannot do it.
First of all this is my code to create a connection:
@NonNull
public static void ...
- 750
2
votes
1
answer
2k
views
java.sql.SQLException: The result set is closed on Firebird when executing two statements
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 ...
- 23
1
vote
1
answer
351
views
Jaybird SocketInputStream.socketread0 thread blocking
I am using JDBC connection to firebird.
<groupId>org.firebirdsql.jdbc</groupId>
<artifactId>jaybird-jdk18</artifactId>
<version>3.0.5</version>
When I am reading ...
- 355
0
votes
0
answers
94
views
Error 335544421. connection rejected by remote interface [duplicate]
I have the code
package com.redsoft.company.dao;
import org.firebirdsql.jdbc.FBDriver;
import java.sql.Connection;
import java.sql.DriverManager;
public class AbstractDao {
private static final ...
2
votes
1
answer
654
views
Firebird NUMERIC/DECIMAL precision and scale in Jaybird
I am testing Firebird NUMERIC / DECIMAL fields behavior in JDBC (Jaybird) in Java.
When using FBResultSetMetaData to check the column properties (for using ResultSet.getObject method for e.g. SELECT *...
- 453
3
votes
1
answer
545
views
date time result from sql database is not same in clojure jdbc
I have problem with timestamp in database(firebird) with jdbc
data in database
timestamp 1994-10-12T00:00:00.000000000-00:00
I test with python and result is same in database but when I use jdbc(...
1
vote
2
answers
15k
views
java.sql.DataTruncation: Data truncation exception and LIKE operator relation
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 *
...
- 1,113
1
vote
1
answer
682
views
Java Driver Firebird 2.5 on Mac OS High Sierra
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 ...
3
votes
1
answer
1k
views
Does the latest Firebird JDBC driver have a virus?
I recently downloaded the latest Firebird JDBC driver (Jaybird 3.0.4 for Java 8) from the Firebird.org website. Windows Defender has quarantined the download saying it is infected with the Trojan:...
- 531
2
votes
1
answer
2k
views
Error "Insufficient memory to allocate page buffer cache" while connecting to Firebird database
I am struggling to understand how a data source runs validation. I have a pool of connections which runs query on Firebird database, but there are few connection in pool which throws error like
...
- 105
3
votes
1
answer
2k
views
Firebird 3.0 Encryption with AES128 plugin - Unable to connect
I'm using Firebird 3 with encryption via the AES128 plugin found here. https://www.ibphoenix.com/products/encryption-plugin.html
I have successfully encrypted the database, and I am able to connect ...
- 4,059
2
votes
1
answer
169
views
Jaybird JDBC 3.0 - Connection Timing Out
I'm connecting to a Firebird 3.0 database using the Jaybird JDBC 3.0.3 driver. I'm connecting from within the ColdFusion Administrator -> Data Sources area. In the past, using JDBC 2.0 driver I ...
- 4,059
0
votes
2
answers
945
views
Calling Firebird Stored procedure from Java Servlet
I have a Firebird Database with some stored procedure, and I am developing a Java web/database application. I want to know if it is possible and how to call those stored procedures from a java Class ...
- 82
2
votes
1
answer
342
views
Passing user from user session in Java to Firebird Trigger using Hibernate or JDBC
I have a trigger that is used to audit data modifications. I need to send a query before every JDBC call so it sends user id to Firebird. How could I use it with Hibernate?
JDBC query example:
...
1
vote
1
answer
1k
views
Proper Setup of jaybird/Firebird DataSource with HikariCP
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 ...
- 33
0
votes
1
answer
2k
views
Java JDBC type conversion (Firebird / Jaybird): check value/type compatibility before using getter or updater ResultSet method?
If I understand (and test a sample JDBC code; using Jaybird for Firebird) well, even using a proper (= respecting the type mapping) updater method (e.g. ResultSet.updateString), or maybe ...
- 453
1
vote
1
answer
174
views
Jaybird 3 and database-file properties (page size, SQL Dialect, ODS major/minor)
In version of jaybird 2 I can get the database page size via gds isc_info_page_size. But now I can't find out - is it possible in jaybird 3.0 to do that?
I have host:port, database file name/alias and ...
- 625
-3
votes
2
answers
576
views
Error While Inserting Data in to Database
I tried to insert my data into my database table name called newdevice.
My query is:
String query= uni +"," + nam +","+ temp + "," + vendor + "," + invoice +","+ dop +"," + cost ;
res=...
- 21
0
votes
1
answer
9k
views
Connecting JDBC with Firebirdsql
I had a problem in connecting with the firebirdsql.
here is my code.
try {
Class.forName("org.firebirdsql.jdbc.FBDriver");
Connection con= DriverManager.getConnection("jdbc:...
- 21
1
vote
1
answer
1k
views
Why won't my Java JDBC to Firebird database connection disconnect?
I am using the following code to connect to a firebird database
public static Connection dbStatic;
...
public void getConnection(){
FBWrappingDataSource DataSource = new ...
- 475
1
vote
1
answer
2k
views
How to add a string variable to a SQL query on a jdbc firebird connection [closed]
I am trying to query a Firebird database from a Java application. This query contains 2 integer variables and 1 string. The query looks like this:
Statement statement = conn.createStatement();
...
- 53
0
votes
1
answer
799
views
Date to Timestamp conversion with Firebird
I need to convert a date (without time component), chosen using toedter JCalendar, to an SQL Timestamp (i.e. with 0:00:00 time part) to use it in SQL queries.
I there nothing more simple or elegant ...
- 453
0
votes
0
answers
225
views
iReport plugin doesn't find FBDriver class
I'm trying to connect my application to my Firebird database, and I need to generate a report in iReport plugin, I'm using JDK 1.8.
When I set the Firebird JDBC Driver (org.firebirdsql.jdbc.FBDriver) ...
2
votes
1
answer
212
views
Jaybird (Firebird JDBC) absolute() method
The absolute(int row) Java Doc says:
Moves the cursor to the given row number in this ResultSet object. If the row number is positive, the
cursor moves to the given row number with respect to the ...
- 802
0
votes
2
answers
1k
views
Set the charset for Firebird connection from Pentaho DI
I'm trying to set the connection Charset for my Firebird connection using Pentaho DI but still couldn't read the data in the right encoding.
I used many parameters like encoding , charSet,...etc but ...
- 1,469
0
votes
0
answers
109
views
Connecting to a datasource defined in new class
Is it possible to connect to a datasource defined in another class, without any frameworks or servers etc just for a local application, built just for practice.
I have a class called ...
- 145
1
vote
0
answers
362
views
Error connecting to Firebird with JDBC
I am trying to connect a Java application to a Firebird database (I don't have access to the source code).
The application requires Driver class, JDBC URL, Username and Password.
No matter what ...
- 64
2
votes
1
answer
537
views
Firebird excessive logging
I'm using WildFly 10 with Hibernate and some JDBC.
I have no logs at all If I declare my data source like this:
<datasource jta="true" jndi-name="java:jboss/Firebird" pool-name=&...
0
votes
1
answer
825
views
Jaybird (Firebird JDBC) ResultSet FetchSize -- Pagination long lasting queries
I am trying to find a way how to force jaybird to do "pagination" in ResultSet. Suppose we have some long lasting sql query (it returns for example 5000 rows in 15 seconds). However, fetching of first ...
2
votes
1
answer
389
views
Firebird CHAR_TO_UUID, failed with GDS Exception. 335544606
First background.
I am coding desktop application with Java as Eclipse RCP (efxclipse).
My configuration:
Eclipse Mars
efxclipse 2.0.0
JDK 1.8_66
Equinox OSGi framework
Firebird 2.5.5.26952
...
- 193
0
votes
2
answers
1k
views
How to getString(Table.Column) in ResultSet JayBird
I need to use the database Firebird and for this I use the Jaybird 2.2.9.
When I used the MySQL driver, to converter of ResultSet to Object this way:
empresa.setBairro(rs.getString("empresa.bairro"))...
1
vote
2
answers
3k
views
No suitable driver found for jdbc in Java 8 with Maven
I have a Maven console application using JDBC and FirebirdSQL and Java 8, according to the specification, there is not need to add the class registration anymore, so the line Class.forName("org....
- 4,130
3
votes
1
answer
1k
views
BIRT Report Designer empty DataSet scripting
I am using BIRT Report Designer 4.4.0 and I kept getting the error message
org.eclipse.birt.report.engine.api.EngineException: Cannot fetch the next data row. org.eclipse.birt.report.data.oda.jdbc....
- 322
0
votes
2
answers
570
views
Impossible to generate metamodel in spagoBI studio with Firebird
In SpagoBI Studio, after saving a connection that was ok with the result firebird database, showed no table in the schema. It is possible to connect with Squirrel.
Data of the local connection:
url: ...
0
votes
1
answer
3k
views
Jaybird java.lang.NoClassDefFoundError
Probably I'm asking a common question but I really don't get what I'm doing wrong and what I could forget when I try to connect with my Firebird DB through Jaybird. I've added the Jaybird.jar to my ...
- 946
-1
votes
1
answer
519
views
How to install Firebird JDBC on Centos
Can anyone help me to install or setup Firebird JDBC on my centos machine. I see no documentation on how to install from their site.
Thank you in advance.
- 77
2
votes
1
answer
919
views
Firebird JDBC update listener
I need to develop app which could do this: user launches few copies of my app, in every copy there's one table with data from Firebird database. When user changes something in one copy of app, any ...
2
votes
2
answers
3k
views
How to connect to Firebird using LibreOffice
I have to create some reports using LibreOffice. I need to connecto a Firebird database using JDBC. I installed the driver (adding it to the classpath) and configured my connection to use
firebirdsql:...
- 472