did anyone succeed with connecting spring to a .gdb database or .fdb database?
I need little help to execute some query and display it on the screen.
There is almost no information on the internet about connecting spring to firebird...
Thanks
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 than this? What is recommended?
Date dt =…
I'm working in a new project to convert our Delphi + Firebird system to Java 8 / JavaFX / JPA (Hibernate) and Firebird. We are using the latest version of Jaybird and connecting to Firebird 1.5, Firebird 3.0 and InterBase XE3 databases. I have not…
Here is Jaybird download page : http://www.firebirdsql.org/en/jdbc-driver/
it include a shared library ( libjaybird22.so ).
here is checked result with "file" command in Linux (ARM machine)
/usr/share/java/JayBird-2.2.10/libjaybird22.so: ELF 32-bit…
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 no luck.
Correct me what i have missed ?
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 FireBirdDataSource:
import…
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 50 (random) rows takes just a fraction of…
I'm trying to add a Message Store using a Firebird SQL Database on WSO2 and it gives me the following error:
java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver
Of course WSO2 cannot find the jar/driver/class for the Firebird…
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")); //…
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: jdbc: FirebirdSQL:…
I am using Spagobi version 3.6.0, Jaybird-2.2.2JDK_1.7 and Firebird 2.5 (x64). I set up a datasource and the testing is OK.
I set up a dataset and the preview shows the correct list of colunms, only there is no data. Access via some other SQL viewer…
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 Java build path but still getting an error …
Using Hibernate 4, the below generated query failed:
delete from ErpEmploye_AUD where (code, folder_codeId, REV)
IN
(select code, folder_codeId, REV from HT_ErpEmploye_AUD where hib_sess_id=1)
Firebird exception:
SQL error code = -104
Token…
I'm trying to insert or update elements in an existing Firebird database using JDBC. I access the database with the default credentials (SYSDBA and masterkey).
The request are done successfully according to JDBC, but the database is not modified…