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
30
votes
2 answers

Column aliasing in SELECT statements doesn't work with SQuirrel SQL + Firebird

I tried add an column alias in SELECT statement using SQuirrel SQL 3.4 + Firebird 1.5 + Driver JDBC Jaybird 2.2.[0|1] (JVM 1.7.0_03), but doesn't work. The column aliased appears with the original name of column. In another tool (DBExpert) the same…
xthiago
  • 484
  • 1
  • 6
  • 13
12
votes
7 answers

Firebird connection with java

I have installed Firebird 2.1 on windows Xp and using firebirdsql.jdbc-2.1.6 driver to connect with java. Code: Class.forName("org.firebirdsql.jdbc.FBDriver"); connection = DriverManager.getConnection( …
Rakesh Goyal
  • 3,117
  • 8
  • 39
  • 69
11
votes
3 answers

JDBC connection with auto reconnect

I am using JDBC to connect to a database server. The connection is over a wireless network and can be dodgy at times. At the moment when the connection is lost I need to close and restart the application. Does anyone have some examples of code where…
bumperbox
  • 10,166
  • 6
  • 43
  • 66
9
votes
5 answers

Spring Data JDBC Firebird dialect not recognized

I'm trying to connect to Firebird database using Spring Data JDBC and Spring Boot. I've created a simple app using Spring Tools. Spring Data JDBC doesn't recognize the dialect. I believe the problem is that the DialectResolver doesn't support…
ndwd
  • 93
  • 1
  • 1
  • 3
8
votes
1 answer

firebird user with granted privileges cannot access tables

I created a Firebird user (PIPPO) via jaybird, follows gsec "display": GSEC> di user name uid gid admin full name ------------------------------------------------------------------------------------------------ SYSDBA …
8
votes
1 answer

Using `META-INF/services` for internal plumbing of driver

I develop the Jaybird JDBC driver, and today I came across an issue (JDBC-325, How to configure Jaybird with hibernate) that is related to how Jaybird loads some of its components and how - in this case - NetBeans restricts classloading. The issue…
Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
7
votes
0 answers

Jaybird 2.2.4 NestedTransactionNotSupportedException: JpaDialect does not support savepoints

Using @Transactional(value ="erpJPA",propagation=Propagation.NESTED ) i have the exception Caused by: org.springframework.transaction.NestedTransactionNotSupportedException: JpaDialect does not support savepoints - check your JPA provider's…
Nassim MOUALEK
  • 4,702
  • 4
  • 25
  • 44
5
votes
1 answer

Firebird Jaybird 2.2.10 / ColdFusion 2018 - String Length Bug

I'm not sure if this is a ColdFusion 2018 bug, or if it is something in the way ColdFusion 2018 implements the Jaybird 2.2.10 driver for Firebird 2.5. I have a table that which contains a column named "item_date". This column has the Firebird…
Phil
  • 4,029
  • 9
  • 62
  • 107
5
votes
1 answer

Get Firebird server version info

I use java and jaybird driver. In my previous version with jaybird 2.x I used GDS low level access (Services API) to connect the server (without db-part in connection), to get the server version string. Now I try to use FB3 + jaybird3beta. There…
5
votes
1 answer

Firebird 3 sysdba password stunning issue

I migrated from firebird 2.5.x to 3.0 i have changed firebird.conf : WireCrypt = Enabled AuthServer = Legacy_Auth, Srp, Win_Sspi after that here you are what happened: I can connect from Netbeans IDE using SYSDBA masterkey. I can connect from…
kamel2005
  • 459
  • 3
  • 13
5
votes
1 answer

Steps to use a Firebird database in Grails

I am trying to connect my Grails application to a Firebird database. I am using: Grails 2.2.1 JDK 1.7 Firebird 2.5.2 Jaybird 2.2.2 So far, this is what I have done: I downloaded Jaybird-2.2.2JDK_1.7.zip from…
Stephan B
  • 837
  • 1
  • 16
  • 41
4
votes
1 answer

Unable to connect to Firebird server from android

I'm using Jaybird to connect to Firebird sql, my app was connected normally. But today I can't connect. The only change I made was to execute the auto corrector in inspector, in android studio. I have no idea what is causing this error. 05-06…
FelipeRsN
  • 887
  • 1
  • 9
  • 19
4
votes
1 answer

Firebird commit doesn't work in Java Application

I'm using a procedure to insert data in my firebird database. This procedure is called in a while command because there is no limit for how many items I can insert, for example: while (there's itens) { query("select * from…
Matheus Hernandes
  • 629
  • 1
  • 6
  • 25
4
votes
2 answers

Does Firebird Database support Schema? If so, how can I create a schema in Firebird DB through ISQL?

Does Firebird Database support Schema? If so, how can I create a schema in Firebird DB through ISQL? Please help me to create schemas in Firebird DB. I have tried to retrieve schema using AbstractDatabaseMetaData.getSchemas() But it is always…
user1615969
  • 61
  • 2
  • 5
4
votes
1 answer

How to configure Jaybird with hibernate

I'm using jaybird 2.2.3 with hibernate 3.5 and when I use the wizard to hibernate mapping files and pojos database the following error appears "java.lang.NullPointerException" I use the same mapping with mysql and it works correctly, so I believe it…
1
2 3
9 10