... Looks like http://tracker.firebirdsql.org/browse/CORE-2348 Setup and run FB 2.1.3 RC2. Make database read-only Make backup of database using gbak version...
104109
Nando Dessena
nandod2ita
Sep 1, 2009 7:35 am
Myles, M> I'm wondering if there is a 'best practice' for doing this. I have a M> database full of contact records. Of these, many have related tables of M>...
104110
Codebue Fabio - P-Soft
fcodebue
Sep 1, 2009 9:48 am
Anyone have any idea how to use firebird in the embedded version on a PDS/smartphone? I'm developing a small app with lazarus using standard component to...
104111
Mark Rotteveel
Avalanche1979@...
Sep 1, 2009 10:07 am
Have you considered simply not allowing deletes and instead allow for an archiving option? Archiving would allow you to keep records, history and other...
104112
Milan Babuskov
mbabuskov
Sep 1, 2009 11:51 am
... I'm not an expert in Java, but you will probably get transliteration errors when you try to fetch UTF-8 character which do not exist in ISO8859_1. It would...
104113
Petri Parviainen
parviainen.p...
Sep 1, 2009 1:35 pm
Gongratulations Vlad You make it work. Back to the basics. How can we avoid this kind of situation. Places are 24/7 and we don't know when those places have...
104114
Alec Swan
aukcioner
Sep 1, 2009 2:43 pm
Shouldn't the character set specified in the JDBC URL match the character set of the database? Here is the jist of my problem: 1. I need to create indexes on...
104115
Kjell Rilbe
krilbe
Sep 1, 2009 2:52 pm
... Not necessarily. The server will transliterate all character data (except charset NONE and... a couple of others like that I believe) into the connection's...
104116
Dimitry Sibiryakov
aafemt
Sep 1, 2009 2:57 pm
... No, it rather must reflect character set in which your application want to get data in. For JAVA it is usually Unicode, thus - UTF8. SY, SD....
104117
Vlad Khorsun
fbvlad
Sep 1, 2009 4:08 pm
... Your database was created near 2 years ago. I.e. your application generated 2147483646 transactions in less than 800 days. Or more than 2.6 mln tx per day,...
104118
Alan McDonald
metaalan
Sep 1, 2009 4:26 pm
... then you need another server. The DBs need to replicate. Then you need the users to switch servers, stop the replication and do a B/R cycle on the idle ...
104119
Dimitry Sibiryakov
aafemt
Sep 1, 2009 4:51 pm
... And as a bonus you'll get hot standby or High Availability Solution + perhaps, load balancing. SY, SD....
104120
Alec Swan
aukcioner
Sep 1, 2009 5:05 pm
There is no real server in EMBEDDED mode. So, I am assuming that the Jaybird JDBC driver will have to do the conversion. Thank you all for your help. Alec ... ...
104121
Dimitry Sibiryakov
aafemt
Sep 1, 2009 5:15 pm
... Where did you pick up this... strange idea? SY, SD....
104122
Mark Rotteveel
Avalanche1979@...
Sep 1, 2009 5:37 pm
... In embedded there is a server, it is just run inside your application and only accessible to the application. It works in regard to charactersets exactly...
104123
Ann W. Harrison
annwharrison
Sep 1, 2009 6:05 pm
... There is a risk with all the methods suggested that a concurrent transaction could add a child record while you're doing your check or even between your...
104124
Alec Swan
aukcioner
Sep 1, 2009 6:11 pm
Makes sense, thank you. ... [Non-text portions of this message have been removed]...
104125
Alexandre Benson Smith
thoriblist
Sep 1, 2009 9:13 pm
... I got your point, and I think it is good... but, I think you will do a lot of checks for every record visited, and only a fraction of those would be a...
104126
astrofacesresearcher
astrofacesre...
Sep 2, 2009 1:19 am
Hello everyone, we're running a research database on Firebird 2.1.3 SuperServer. we upgraded to Fedora 11 two weeks ago and it's been running fine. the...
104127
Petri Parviainen
parviainen.p...
Sep 2, 2009 3:40 am
This has to be think. -br- Petri From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Alan McDonald Sent: 1. syyskuuta...
104128
Petri Parviainen
parviainen.p...
Sep 2, 2009 3:40 am
When you have data ready and it's checked to be correct and you insert it into database, why it's bad idea to commit it? You have correct data to use for other...
104129
Philippe Makowski
tempo93fr
Sep 2, 2009 6:46 am
... Yes, that's a bug in the update process of the Fedora rpm see : https://admin.fedoraproject.org/updates/F11/FEDORA-2009-8340...
104130
Vlad Khorsun
fbvlad
Sep 2, 2009 8:15 am
... And you commit every single record, isn't it ? ... Group 10 ready-to-be-committed records in one transaction and lower amount of transactions 10 times...
104131
Le Phuc
lephuc@...
Sep 2, 2009 9:02 am
Hi all, I use FB 2.1.3 RC2, I have a string(Ex: ABCD), I want to add an empty space(or an character ‘,’) between each characters in string. Please send me...
104132
Anderson Farias
peixedragao
Sep 2, 2009 11:29 am
Hi, ... Use SUBSTRING , ex: select substring(yourfield from 1 for 1)||','||substring(yourfield from 2 for 1) from yourtable Regards, Anderson...
104133
Anderson Farias
peixedragao
Sep 2, 2009 11:39 am
Hi, ... Why not use and 64bit integer count instead of current 32bit? And, I gess, even using an 'unsigned 32bit integer' would at least double the number of...
104134
astrofacesresearcher
astrofacesre...
Sep 2, 2009 11:47 am
Philippe Makowski, Thanks! ... mkdir /var/run/firebird chown = firebird:firebird chmod = 700 like haldaemon. should it be 644 like rpcuser? reboot, and ......
104135
Dimitry Sibiryakov
aafemt
Sep 2, 2009 11:50 am
... It is not only matter of transaction counters, but (mostly) number of TIPs in database. They are not reused. SY, SD....
104136
Vlad Khorsun
fbvlad
Sep 2, 2009 1:04 pm
... Because tx number stored in the header of every record version. ... This is not a problem at all. It is very possible to reuse TIP pages. Regards, Vlad...
104137
Philippe Makowski
tempo93fr
Sep 2, 2009 1:16 pm
... The policy for files permission in packages has always been to use the most simplest scheme (644 for non-executable, 755 for executables and directories)...
