Questions tagged [jaybird]

Jaybird is a DBC driver for the Firebird database server. Use this tag for questions about using Jaybird to connect to Firebird.

Jaybird is a JDBC driver for the Firebird database. The Jaybird driver is based on the JDBC standard.

Jaybird is free software distributed under the LGPL.

Resources

See also

141 questions
0
votes
2 answers

Spring + firebird

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
Paweł Meller
  • 23
  • 1
  • 8
0
votes
1 answer

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=…
Raj kumar
  • 21
  • 2
  • 6
0
votes
1 answer

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 than this? What is recommended? Date dt =…
Tom
  • 423
  • 1
  • 4
  • 13
0
votes
1 answer

Firebird and Hibernate - How do you specify a DB role?

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…
0
votes
1 answer

Where is jaybird for ARM binary/source?

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…
Kazuhiko Nakayama
  • 801
  • 1
  • 8
  • 24
0
votes
1 answer

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 no luck. Correct me what i have missed ?
Jason4Ever
  • 1,439
  • 4
  • 23
  • 43
0
votes
0 answers

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 FireBirdDataSource: import…
Novice
  • 145
  • 2
  • 2
  • 9
0
votes
1 answer

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 50 (random) rows takes just a fraction of…
0
votes
1 answer

WSO2 - How to add Database Connector for Firebird

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…
Victor Viola
  • 575
  • 1
  • 4
  • 14
0
votes
2 answers

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")); //…
0
votes
2 answers

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: jdbc: FirebirdSQL:…
0
votes
1 answer

SpagoBI + Firebird DataSource (The result set is closed)

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…
Joabe Lucena
  • 792
  • 8
  • 21
0
votes
1 answer

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 Java build path but still getting an error …
whizzzkey
  • 926
  • 3
  • 21
  • 52
0
votes
1 answer

Hibernate 4 Delete from HT_tables where IN clause Token unknown ","

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…
Nassim MOUALEK
  • 4,702
  • 4
  • 25
  • 44
0
votes
1 answer

Insert or update query executed successfully but data are not persistent

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…
reevolt
  • 797
  • 1
  • 9
  • 24
1 2 3
9
10