firebirdsql | Firebird RDBMS sql driver for Go | SQL Database library
kandi X-RAY | firebirdsql Summary
kandi X-RAY | firebirdsql Summary
Firebird RDBMS SQL driver for Go.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of firebirdsql
firebirdsql Key Features
firebirdsql Examples and Code Snippets
Community Discussions
Trending Discussions on firebirdsql
QUESTION
This worked fine for me be building under Java 8. Now under Java 17.01 I get this when I do mvn deploy.
mvn install works fine. I tried 3.6.3 and 3.8.4 and updated (I think) all my plugins to the newest versions.
Any ideas?
...ANSWER
Answered 2022-Feb-11 at 22:39Update: Version 1.6.9 has been released and should fix this issue! 🎉
This is actually a known bug, which is now open for quite a while: OSSRH-66257. There are two known workarounds:
1. Open ModulesAs a workaround, use --add-opens
to give the library causing the problem access to the required classes:
QUESTION
I want to develop a demo project in ASP.NET Core MVC with embedded Firebird v2.5. I read Firebird connection string information from a text file. Because I will change database in project presentation thus I must read from a text file. Or what is the your idea?
In this project I create a DbContext
file and I fill in the database information using this class:
ANSWER
Answered 2022-Feb-01 at 12:47You are not using Firebird Embedded. As you specified FbServerType.Default
(which is also the default value), you are connecting through a normal Firebird server using TCP/IP, and the error indicates that the database file does not exist (or possibly that the Firebird server process does not have sufficient access rights to open the file).
If you really want to use Firebird Embedded (which personally I think is not a good idea for a server application), you need to specify FbServerType.Embedded
. Also make sure that the database file actually exists at C:\Firma\BlinePalmeWEB\Mandanten\11PalmeIT\GDI21.FDB
on the server specified by dataSource
.
QUESTION
I'm developing a RESTful application and whenever I make a request, it works fine, but also outputs these warnings:
...ANSWER
Answered 2022-Jan-12 at 07:54The reason for this is that Jaybird currently doesn't support a timeout for Connection.isValid(int)
and ignores it, and thus - if the specified timeout is non-zero - it registers a SQLWarning
on the connection (instead of throwing an exception). Although registering a warning here isn't specified in the JDBC specification, this is similar to what JDBC requires a driver to do when it replaces/ignores user-specified values when configuring the result set type, concurrency and holdability.
When Hibernate notices there is a warning registered on the connection, it will log that warning in org.hibernate.engine.jdbc.spi.SqlExceptionHelper
. This logging of warnings can be disabled by setting the property hibernate.jdbc.log.warnings=false
(see Query Settings in the Hibernate documentation). In case of Spring Boot, I guess you can set this as property spring.jpa.properties.hibernate.jdbc.log.warnings
(but I haven't verified this).
The timeout is configurable through the HikariCP property validationTimeout
, but - by default - this doesn't accept a value lower than 250 milliseconds (you can change that with system property com.zaxxer.hikari.timeoutMs.floor
). Alternatively, you can configure HikariCP property connectionTestQuery
with - for example - select 1 from rdb$database
, so HikariCP uses the test query instead of Connection.isValid(int)
. Be aware that a test query has more overhead.
The warning code printed is the SQLWarning.getErrorCode()
(technically, SQLException.getErrorCode()
, a.k.a the vendor code). And given this warning doesn't have an error/warning code, its value is 0, which simply means "there is no specific vendor code associated with this warning".
I have created this issue to see if actual timeout support can be added in Jaybird 4.0.6 or Jaybird 5.
Disclosure: I am one of the maintainers of Jaybird.
QUESTION
I am attempting to run a working jmeter script in blazemeter, but getting the following error where it tries to run my groovy scripts. I am writing trying to access jmeter properties that were set in a previou groovy script.
...ANSWER
Answered 2021-Nov-18 at 06:18In order to resolve the compilation failure issue you need to change this:
QUESTION
I had to switch my code from being in .NET Core to .NET Framework and now I get an error. the error says that local variable named 'listadb' cannot be declared in this scope. This function worked before and I don't know how to get around it now. Here is the code:
...ANSWER
Answered 2021-Oct-28 at 11:36QUESTION
I have this program, that I have to handle the exceptions for, but I never done it so I'm kind of confused. I'm guessing I'd have to handle exceptions like the value in the textfile is empty, there is no index, there is no "=" or the file is empty, but I don't really know how to define them or where to put them. Here is my code: (the lines in the text file should look like this: EMPIS_MAG_BUDOW=12
EMPIS_DESKA_FASOLKA=2
SM_PORTAL_POL1=-4 )
...ANSWER
Answered 2021-Oct-21 at 07:18//try something like below.
QUESTION
I have to make a select statement on a database and than compare the results with a text file using only C# in Visual Studio. If the text file has a bigger value than the record in the database, the program returns the value from the text file, and if the database record has a bigger value, the program returns the value from the database. The results are added to a list being a class WynikPorownania{}. The user types in the file an index of a product and the value(in this case the value is it's availability condition).
For example:
The textfile says this:
WYR_WR_CZ1=12
VIDIS_JIMU_BOX=3
REREK_KOTEK_T=5
In the database, theses indexes are connected to an availability condition like this
WYR_WR_CZ1=-1.0000
VIDIS_JIMU_BOX=-13.0000
REREK_KOTEK_T=0.0000
Now the program should return the bigger value in a list being the WynikPorownania{} class.
For now, I managed to do this much: I took every record from the select query and put it in to a list as a class. I have a function that checks the "standysp"(availability condition) for a specified index, and I asigned the text file value to a string. I think that it could be done maybe with this "zwr" function and maybe a loop but I don't really know where to go from now on. This is my code for now:
...ANSWER
Answered 2021-Oct-20 at 10:13You mean something like this?
QUESTION
I have transactional service that I use to create a Person and persist it in db. The problem is that entity is not saved into db after transaction is commited.
At first I thought it was the fault of the JpaRepository, which opens a new transaction every time a method is called, but from what I've learned, these are just logical transactions inside a single physical one that gets opened in my service.
I use Spring Boot and Hibernate to connect with my firebird databases. For this purpose i configured two separate datasources and transaction managers. In each @Transactional annotation, I specify the transaction manager to be used. Fetching data works perfect. The problem concerns only saving.
I'm actually performing more operations here, but for the sake of the example I'll limit myself to just saving the entities. Simple example below.
...ANSWER
Answered 2021-Oct-17 at 10:55Ok, the problem was that JPA entities does not work with DataSourceTransactionManager
.
I used JpaTransactionManager
instead and it works fine
QUESTION
I'm trying to read fdb files in Ubuntu using firebirdsql:
...ANSWER
Answered 2021-Jul-14 at 12:16In the comments you indicate you don't have a Firebird server installed on your machine. As there is no server listening on localhost port 3050, you get the connection refused error.
That firebirdsql, the driver you're using, is pure Python doesn't mean it can open database files by itself, it means it doesn't use a native library to establish a connection, but that it implements the Firebird TCP/IP wire protocol in Python. You will need a Firebird server (either localhost or remotely) to connect to.
Also: a server normally won't be able to access files in your home directory.
QUESTION
I recently downloaded the new Firebird 4 server and installed it. It's running as a service on my Windows 10 box. I'm able to connect to it just fine with the FB Maestro IDE, but when I try to connect to it from some ADO.NET code, I get an error. Upon calling await connection.OpenAsync
(where connection
is a FirebirdSql.Data.FirebirdClient.FbConnection
instance):
FirebirdSql.Data.Common.IscException: 'Error occurred during login, please check server firebird.log for details'
Looking at the server log, I see the following two errors, repeated various times:
DESKTOP-NAME Thu Jun 24 15:14:32 2021 Authentication error No matching plugins on server
DESKTOP-NAME Thu Jun 24 15:14:35 2021 INET/inet_error: read errno = 10054, client host = DESKTOP-NAME, address = 127.0.0.1/54653, user = Mason
I have no idea what this means, and some basic searching fails to turn up anything useful. Anyone know what I need to do to resolve this?
In case it's relevant, my connection string looks like this:
User=SYSDBA;Password=[my password];Database=[db name];DataSource=localhost;Port=3050;Dialect=3;Charset=UTF8;
Once again, I know the server is working correctly because I can connect to it with FB Maestro. The problem is clearly in my .NET code somewhere. I just have no idea where!
...ANSWER
Answered 2021-Jun-24 at 21:39The driver you use doesn't support srp256 and Firebird 4 server by default doesn't support anything else. You must edit firebird.conf changing AuthServer parameter to include srp plugin at least. Don't forget to restart the Firebird server afterward.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install firebirdsql
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page