When I execute query by setting parameter externally, query execution time is getting dramatically slow.
StopWatch stopWatch = new StopWatch();
stopWatch.start();
Query nativeQuery = mEntityManager.createNativeQuery(
"select first 100 * from…
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 * FROM NUMERICTEST query) I get the precision…
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
Insufficient memory to allocate page buffer cache…
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 created my data source as follows.
JDBC URL:…
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:
select rdb$set_context('USER_SESSION','CURRENT_USER',…
I would like to run a Java program(plug-in), for a trigger on a table, say AFTER INSERT. How do I create the database trigger, to achieve this and get the java program executed on insert of a row in the table.
I see in some documents, that a Java…
I am trying to connect to a firebird db using the jaybird jdbc driver. Firebird is running under ubuntu. I have created a simple database located under /tmp/hellofb.fdb (yeah not the best place, just for testing). I am running firebird superserver…
When I try to connect to a Firebird database with dbeaver this error is shown:
Connection rejected: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding). Please specify a connection character set (eg…
In previous version of jaybird (2.2) I was able to execute Services API to Firebird server to get active transaction markers: OIT, OAT, Next, etc.
In version 3.0, I can't find out how to do it properly. There are only ISC-constants (like…
I have problem with UUID ID fields defined by domain
CREATE DOMAIN OCTET16 AS CHAR(16) CHARACTER SET OCTETS;
I have defined AttributeConverter for jpa as
import java.util.UUID;
import javax.persistence.AttributeConverter;
import…
I've installed an external desktop application and established connection with their example Firebird database (it is locally on my computer, I have all parameters, passwords).
How can I connect to that Firebird database in my own application…
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 beginning of
the result set. The first row is…
I'm creating a java application that connects to a Firebird database and retrieve some data. The program is done, and it runs well in my computer. The problem is that, in the computer I need to run the application, the database is in another…
