https://stackoverflow.com/questions/35966337/transition-from-yahoo-groups-to-google-groups
On 18.10.2019 ã. 14:45, emb_blas...@hotmail.com [firebird-support] wrote:
>
> Hi!
>
> Recently I learned that Yahoo! will close Groups.
>
> We will lose all the content?
>
> Will we move to another
Hi,
You can try by turning Forced writes off on the database. Firebird does
very frequent writes to it's transaction pages and that is overkill for
SSD. Without good write cache this hurts performance a lot.
I suggest you do the above only to test and see is there any difference
in the
Hi,
I just got my last piece (the motherboard) for my new Ryzen system. I'll
install all the software during the next few days and will write back
here about my experience with FB.
I'm moving from FX-8350 to Ryzen 7 1800X with some decent upgrade on the
storage (RAID 10 with 6 HDD) so I
Hi,
I'm looking for some example how to use TraceAPI provided in Jaybird.
--
Doychin Bondzhev
dSoft-Bulgaria Ltd.
PowerPro - billing & provisioning solution for Service providers
PowerStor - Warehouse & POS
http://www.dsoft-bg.com/
Mobile: +359888243116
[Non-text portions of this message have
Hi,
I'm looking for easy to use solution that can help me trace statements
executed inside every transaction and keep them until transaction is active.
Once it is closed(commit or rollback) statements are discarded.
I need this to be able to run on a production system in order to track
which
The only protection that I found until now is to use forced writes on
the database.
this can save you from real troubles.
Without this option turned off you might lose some data even when your
database is in perfect shape.
With forced writes you have the guarantee that at least until the last
You need to install compat-libstdc++-33 package. That package will give you
the needed C++ libraries to run firebird on RHEL/CentOS 6
On Sat, Apr 18, 2015 at 10:37 PM, Emil Totev em...@tot-consult.com
[firebird-support] firebird-support@yahoogroups.com wrote:
I will have to install firebird
Hi,
I tried to convert binary blob field to varchar column in select statement but
It did not work.
Here is what I did:
1. I created a domain
CREATE DOMAIN D_BIGVARCHAR AS
VARCHAR(32000) CHARACTER SET OCTETS
COLLATE OCTETS;
Then when I use this query
select cast(JOB_INFO as
On 9.10.2014 ã. 14:32 ÷., brucedickin...@wp.pl [firebird-support] wrote:
Thank you guys for your input! I appreciate it!
I have some doubts.. isn't TCP/IP a bottleneck here? I mean, I am
sending for example 4 times (4 threads) more data to insert via network.
@Doychin I do have like 2-3
Hi Costantino,
I did some experimenting before one year and I found that Firebird is
much faster when you use page size = cluster size on the file system.
So if your file system is with 4K cluster I suggest to use page size of 4K.
This is very helpful when you have Forced Write = ON.
Hi,
This exception I get when I try to close connection that I get from a
Datasource that I lookup from JNDI.
I use
try {
// Some code that uses connection
} finally {
connection.close();
}
11:58:47,160 ERROR [STDERR] Caused by: org.firebirdsql.jdbc.FBSQLException:
Connection enlisted
This is with jaybird 2.2.5 JDK 7. I use JBoss App server 4.2.3 on JDK 1.7.0-40
My datasource definition is:
?xml version=1.0 encoding=UTF-8?
connection-factories
tx-connection-factory
jndi-nameDSoftDS/jndi-name
xa-transaction/
track-connection-by-tx/
In this particular case the heavy load is not in this table. It is another
table.
This insert is run only once a day when the first client connects to the system.
All other clients should be able to see the inserted records and will just load
them.
The problem might happen only of 2 clients
I'm using Firebird 2.1.6. Also I tried to upgrade to latest jaybird before but
it does not work properly with JBoss 4.2.3. I remember something has changed
and as soon as I try to start apps server and run client, exceptions were
starting to popup in the log.
This code path uses long running
I'm not sure it is locked table.
What I'm looking for is idea or advice how to find what the real problem is.
My data source definition is this:
connection-factories
tx-connection-factory
jndi-namePowerProDS/jndi-name
xa-transaction/
track-connection-by-tx/
CASHBOXID is already know. It is a reference to a table that we don't touch in
the transaction.
This table contains the current total amount of a cash box at the begging of
the day.
So when I try to load data for a cash box a java code checks is there record
for this cash box for current
Hi guys,
I'm looking for some ideas how to find what is causing this lock.
I have 2 production databases that process multiple insert/update statements.
There is one background process that does all these modifications 24h/day.
The problem is that with one of these databases almost every
They all use READ COMMITTED isolation.
It is an application that runs in JBoss App server so I have single datasource
defined that uses READ COMMITTED.
Blocked statements are insert and update. Selects are not blocked.
This is the definition of the table that locks on insert:
CREATE TABLE CASH_CASHBOX_DAY_AMMOUNT
(
CASHBOXID INTEGER NOT NULL,
DATE_TIME NUMERIC( 18, 0) NOT NULL,
AMMOUNTNUMERIC( 18, 0),
CONSTRAINT PK_CASH_CASHBOX_DAY_AMMOUNT PRIMARY KEY
Yes background process is running to on same application server and uses same
data source.
I use EJB 2 and CPM for doing database operations.
App server is 4.2.3 and jaybird is 2.1.6
20 matches
Mail list logo