On 5-9-2014 19:48, doyc...@dsoft-bg.com [firebird-support] wrote:
> 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.
I'd start with obtaining a thread dump of the application when it is
hanging. The stacktraces might hint at the cau
On 04 Sep 2014 13:31:14 -0700, "doyc...@dsoft-bg.com [firebird-support]"
wrote:
> 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
How have you determined
On 4-9-2014 13:53, doyc...@dsoft-bg.com [firebird-support] wrote:
> They all use READ COMMITTED isolation.
Are you using the default read committed config of Jaybird, or have you
overridden it? Default is
isc_tpb_read_committed,isc_tpb_rec_version,isc_tpb_write,isc_tpb_wait
> It is an applicati
On Wed, 03 Sep 2014 10:31:46 +0400, "Dmitry Yemanov
dim...@users.sourceforge.net [firebird-support]"
wrote:
> 03.09.2014 09:44, Macma wrote:
>>
>> I found that after upgrade from FireBird 2.1.5 Update 1 to 2.1.6 my
>> query stop working with error "Dynamic SQL Error SQL error code = -104
>> Invali
On 02 Sep 2014 04:16:16 -0700, "map...@gmail.com [firebird-support]"
wrote:
> What is fsql.exe ?
http://mujweb.cz/iprenosil/interbase/fsql.htm
Questions on Firebird 3.0 - as long as it isn't final - should be
directed to the firebird-devel mailinglist.
Note that the document you link to is about the provider architecture,
there is no ODBC provider included in Firebird 3.0, so this doesn't work
out of the box.
Mark
On 30-8-2014 12:25
On 28-8-2014 18:02, patrick_mar...@yahoo.com [firebird-support] wrote:
> Hello,
>
> any attempt to do a search ends with the screen
>
> Oops!
> Polls feature not enabled
Looks like you are talking about the Yahoo groups web interface. It is
simply bad, and it seems to be getting progressively wor
On Thu, 28 Aug 2014 14:29:31 +0200, "Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]"
wrote:
> (by the way, I don't understand [minb], is that
> some kind of parameter?).
As the OP talks about Access, I assume that is the SQL Server and Access
identifier quoting.
M
On Thu, 28 Aug 2014 12:54:33 +0200, "Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]"
wrote:
> At my workplace, we encrypt (or obfuscate) some fields in our programs
and
> only use Firebird for storage of the field (hence, Firebird knows
nothing
> about the encryptio
On Thu, 28 Aug 2014 12:11:59 +0100, "Alan J Davies
alan.dav...@aldis-systems.co.uk [firebird-support]"
wrote:
> Hi, I'm looking at a system that I have not touched for some years and
> wonder if there is a way to improve this code. This all works, but is
> there a better or more efficient way? I
On 28 Aug 2014 03:24:18 -0700, "trsk...@yahoo.com [firebird-support]"
wrote:
> Hi all,
>
> I have a table with ddl : create table Tbl1(id int,dscp varchar(100))
>
> Is there a tool to encrypt data in field dscp? I only need to encrypt
that
> field, not all field.
There is no standard functional
On 28 Aug 2014 01:10:40 -0700, "russ...@belding.co.nz [firebird-support]"
wrote:
> Perhaps my problem is in an incorrect installation setting?
>
> I have FB 2.5.3 on a laptop. Win 7 32 bit.
> I introduced a stored procedure and in it call F_LEFT(:varName, 24) to
> truncate :varName from a vc
On Thu, 28 Aug 2014 10:32:51 +0200, "Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]"
wrote:
>>Perhaps my problem is in an incorrect installation setting?
>>I have FB 2.5.3 on a laptop. Win 7 32 bit.
>>I introduced a stored procedure and in it call F_LEFT(:varName,
On Fri, 22 Aug 2014 01:18:17 -0500, "Caroline Beltran
caroline.d.belt...@gmail.com [firebird-support]"
wrote:
> I created the following computed index:
> CREATE INDEX IDX_FNAME ON PEOPLE COMPUTED BY (lower(fname))
>
> This works fine and instead of traversing the entire table when
performing
> a
On 17 Aug 2014 12:05:08 -0700, "vogonjeltzprostet...@yahoo.com
[firebird-support]" wrote:
> This was something I would resort to years ago in Paradox. Suppose I
had
> a table CORPORATION with columns S_KEY INTEGER, SUBSIDIARY_NAME CHAR(50)
> and a table EMPLOYEE with columns CORPORATION_S_KEY INT
On 14-8-2014 10:17, grenzhan...@yahoo.com [firebird-support] wrote:
> Hi, I'm in the progress of converting an existing application from
> Sybase SQL (11.0.3 - from the stoneage) to Firebird.From Sybase (as well
> as some other databases I work with) I'm used to entering date literals
> as 'mmd
On 14-8-2014 10:29, Lutz Kutscher grenzhan...@yahoo.com
[firebird-support] wrote:
> (3rd try. Sending to newsgroup gmane.comp.db.firebird.user or sending
> via yahoo's "New Topic" button didn't seem to work - or am I just too
> impatient?)
This mailinglist is moderated. So your message might not
On 8-8-2014 20:53, jim.rhema...@gmail.com [firebird-support] wrote:
> The stored procedure is supposed to match the input vin to a vin in
> another table. Then within the SP I want to update a different table
> with the values retrieved from the first select.
>
> I am executing a stored procedure
On 8-8-2014 21:16, dixonepper...@yahoo.com [firebird-support] wrote:
> You are missing the SUSPEND; which is necessary when returning data.
> Also you shouldn't have a statement after the DO key word. Rewrite it
> like this:
SUSPEND is not necessary for returning data, suspend is only necessary
On 4-8-2014 16:42, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
> Hello,
>
> I have three questions relating CONTAINING predicate.
>
> In "The Firebird Book" I read on page 318 that indexes are used
> also on search conditions against CONTAING predicates. I did some
On 29-7-2014 09:47, Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support] wrote:
> Don't know whether windowing functions can be used in the WHERE clause, but
> when Firebird 3 is released, it would be tempting to try things like
>
> WHERE MOD(ROW_NUMBER() OVER (ORDER BY
On 18-7-2014 21:03, 'checkmail' check_m...@satron.de [firebird-support]
wrote:
> Hello Mark,
>
> Here the code of the sub-Procedure:
>
> create or alter procedure P_U_CN_TO_INT (
> CN_IN varchar(30))
> returns (
> INT_OUT integer,
> STATUS smallint)
> AS
> declare variable I_ISNUMER
On 18-7-2014 15:55, 'E. D. Epperson Jr' dixonepper...@gmail.com
[firebird-support] wrote:
> If he were to use the alias.conf file on his client, would that solve
> the issue and wouldn't be the best way to do this?
Using aliases.conf is the better option for specifying a database.
However it won
On 18-7-2014 14:34, Tim Ward t...@telensa.com [firebird-support] wrote:
> On 18/07/2014 13:31, Mark Rotteveel m...@lawinegevaar.nl
> [firebird-support] wrote:
>>
>>
>> That would give an entirely different error. The database file either
>> doesn't exist, or th
On 18-7-2014 14:00, 'checkmail' check_m...@satron.de [firebird-support]
wrote:
> If I use the following code to extract a part of a string, it works fine:
>
> s_datum = substring(:dat from 13 for 4);
> s_datum = char(4)
>
> Now I would give the same a stored procedure, the first input parameter
>
On 18-7-2014 13:53, Σπύρος Μπιμπίλας bibi...@gmail.com
[firebird-support] wrote:
> FbConnection conn = new
> FbConnection(@"Server=172.X.XX.XX;User=SYSDBA;Password=masterkey;Database=D:\ng\DATA\CUSTOMER.FDB");
>
> But I get the following error:
>
> I/O error during "CreateFile (open)" operation fo
On 17-7-2014 16:51, rud...@gmail.com [firebird-support] wrote:
> TempDirectories = D:\FIREBIRD_TMP;D:\WINDOWS_TEMP
>
> DefaultDbCachePages = 512
>
> TempBlockSize = 8388608
>
> LockMemSize = 10097152
>
> LockHashSlots = 60540
The documentation of LockHashSlots says:
# Tune lock hash list; more ha
On Wed, 16 Jul 2014 09:19:51 -0400, "'E. D. Epperson Jr'
dixonepper...@gmail.com [firebird-support]"
wrote:
> I understand the timezone issue. What I don't understand is how or why
the
> virtual machine gets it wrong (sometimes) until after I log in using
RDP.
> After that it will report it corr
On 15 Jul 2014 13:02:45 -0700, "dixonepper...@yahoo.com
[firebird-support]"
wrote:
> My web database is on a virtual machine, separate from the web server.
>
> One of the task the web server does when a page is visited is log that
to
> the database
>
> On an admin page, also web based I can
On Wed, 16 Jul 2014 10:35:12 +0530, "Venus Software Operations
venussof...@gmail.com [firebird-support]"
wrote:
> On 15-07-2014 16:48, Mark Rotteveel m...@lawinegevaar.nl [1]
> [firebird-support] wrote:
>
>
> On 15 Jul 2014 03:47:07 -0700, "venussof...@gmail.com
[firebird-support]"
> [2]
>
On 15 Jul 2014 03:47:07 -0700, "venussof...@gmail.com [firebird-support]"
wrote:
> Hi all
>
> My application in 32 bit which stopped getting to the registry of
FireBird
> HKLM\Software\FireBird Project\FireBird Server\Instances >
DefaultInstance
> which the WinAPI RegOpenKey() fails and returns a
On 12-7-2014 18:30, Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support] wrote:
> Your statement is equivalent to "CASE WHEN umowy.numer_umowy IS NULL THEN 0
> ELSE NULL END", so I think your problem simply is that NULL is returned if
> numer_umowy has a value. You may
On 12-7-2014 17:07, Piotr Olszewski piotr.olszew...@eskrzynka.pl
[firebird-support] wrote:
>> On 12-7-2014 15:57, Łukasz Bączek bacze...@o2.pl [firebird-support] wrote:
>> > Hello,
>> > I have a SQL query:
>> >
>> >
>> > SELECT
>> > CASE WHEN umowy.numer_umowy IS NULL THEN 0 END AS numer_umowy
>>
On 12-7-2014 15:57, Łukasz Bączek bacze...@o2.pl [firebird-support] wrote:
> Hello,
> I have a SQL query:
>
>
> SELECT
> CASE WHEN umowy.numer_umowy IS NULL THEN 0 END AS numer_umowy
> FROM umowy
> WHERE umowy.data_podpisania IS NOT NULL AND umowy.id_wnioski IN
> (SELECT CASE WHEN wnioski.id_wniosk
On 11-7-2014 17:31, Sergio Garcia sergiogarciar...@gmail.com
[firebird-support] wrote:
>
>
> Hi All.
>
> Can I create a procedure inside another procedure? Something like this:
>
> SET TERM ^;
>
> RECREATE PROCEDURE proc
> AS
> DECLARE VARIABLE tmp INTEGER;
>
> PROCEDURE insideproc
>
On 9-7-2014 20:57, vtre...@yahoo.com [firebird-support] wrote:
> We're in the process of changing an application that accesses a Firebird
> database file from a regular application to a windows service. For
> legacy reasons this uses the Firebird embedded DLL (fbclient) for
> version 1.5.6. The cod
On 9-7-2014 21:34, 'Edward Mendez' emendez...@nc.rr.com
[firebird-support] wrote:
> I have a situation where I might have to open up a FIREBIRD Database
> file that I didn’t create or maintain. I probably will not know the
> exact version of FIREBIRD this file was used with. It can be anything
> f
On 7-7-2014 19:02, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 7-7-2014 17:54, russ...@smxi.com [firebird-support] wrote:
>> I am using Delphi XE6 and Firedac and my query is similar to
>>
>> SELECT A.NAME, 'HTTP://WWW.XYZ.COM?
On 7-7-2014 17:54, russ...@smxi.com [firebird-support] wrote:
> I am using Delphi XE6 and Firedac and my query is similar to
>
> SELECT A.NAME, 'HTTP://WWW.XYZ.COM?URN=' || A.URN || '&ACTION=' ||
> A.ACTIONFIELD
> FROM MYTABLE
>
> the problem I have is that the returned result doesn't include the
>
On 6-7-2014 11:36, Matthias Hanft m...@hanft.de [firebird-support] wrote:
> Hi,
>
> I have a FB 2.0.3 server on Linux. Everything runs well, but I'm planning
> to upgrade to the latest 2.5.x version. Since I can't remember exactly
> which users are installed at the server (and I guess I can't use t
On 26-6-2014 10:14, Tim Ward t...@telensa.com [firebird-support] wrote:
> It was in fact elementid being null.
>
> Having discovered this I was unable to tell the list as a reply to my
> original message because this list doesn't seem to send messages to
> their originator.
The e-mails I send to t
On 25-6-2014 17:48, kokok_ko...@yahoo.es [firebird-support] wrote:
> The connection is via network, TCP, not single user mode.
Connecting through TCP does not preclude single user mode.
Mark
--
Mark Rotteveel
On 25-6-2014 16:55, kokok_ko...@yahoo.es [firebird-support] wrote:
>
>
> I have a web server suing Firebird. I installed it using Classic mode
> because it seems more robust.
> Usually, databases have between 1 to 3 users concurrently as maximum.
> However, there are 50 databases and eventually man
On 25-6-2014 16:08, Tim Ward t...@telensa.com [firebird-support] wrote:
> Anyone know what this error message actually means?
May I suggest that you also include the error in the message body, when
reading e-mail on a mobile device, long subject lines have a tendency to
get truncated.
(The erro
On 20 Jun 2014 03:54:42 -0700, "tomconl...@gmail.com [firebird-support]"
wrote:
> Thanks for the replies.
>
> - Same results with ISQL + CTE
> - FB version 2.1.3.18185 SS on Windows 2008 Server R2 (on a VM)
> - will validate the db when possible.
Firebird 2.1.3 is relatively old, and a larg
On 20 Jun 2014 04:53:39 -0700, "r...@xs4all.nl [firebird-support]"
wrote:
> Thanks Mark, I've tried executing fbsvcmgr (from the MS DOS prompt) but
> both action_display_user_adm and action_display_user are always
returning
> "no" for the adm column.
>
> [WI-T3.0.0.30809 Firebird 3.0 Alpha 2]
On 18-6-2014 15:23, r...@xs4all.nl [firebird-support] wrote:
> As SYSDBA I like to know which users are granted in the past with the
> ADMIN ROLE (as in CREATE USER Test1 PASSWORD 'test' GRANT ADMIN ROLE).
>
> I guess those users have the system defined RDB$ADMIN role assigned in
> the security dat
On 19-6-2014 16:58, tomconl...@gmail.com [firebird-support] wrote:
> I was expecting to see one row for
>
> "melvin comms directors 30.04.13" and also for "DCFTG210513".
>
> QUERY
>
> select '['|| TRIM(SUBSTRING(COMMENTS FROM 1 FOR 100)) || ']', count(*)
> from target
> group by 1
> having count(*
On 11 Jun 2014 07:50:26 -0700, "jonatan.laurit...@yahoo.dk
[firebird-support]" wrote:
> It is really strange behavior. It is hard to imagine any kind of
> configuration that could result in such behaviour.
It could be explained if one is Classic Server and the other SuperServer.
The default cache
On 10-6-2014 18:20, Arnold Levy arnoldjl...@gmail.com [firebird-support]
wrote:
> I suspect that the parser of Firebird SQL was written as a recursive
> decent implementation - judging from the poor error reporting. I heard
> that Firebird is written in C. A great LR grammar parser such as Hyacc -
On Tue, 10 Jun 2014 11:09:42 +0200, "Arnold Levy arnoldjl...@gmail.com
[firebird-support]" wrote:
> I've written my DDL script to populate the created database - and I
> keep getting the a/m annoying message - apparently in the CREATE TABLE
> script. Line 7 is the definition for my column "_Emails
On Fri, 23 May 2014 01:48:31 -0300, "Antônio Cristóvão Gomes
acgomes2...@yahoo.com.br [firebird-support]"
wrote:
> then why not include "Alias Table" in "XSQLVAR"?
The information for the relation alias has only been available since
Firebird 2.0. There is no field for it in an XSQLVAR, and exte
On 22-5-2014 19:15, acgomes2...@yahoo.com.br [firebird-support] wrote:
> I have the SQL:
>
> select
> CADPRO.CLIENTE_PRO,
>CADPRO.FORNECEDOR_PRO,
...
> FORNECEDOR.NOME_CLI NOME_FORNECEDOR,
> CLIENTE.NOME_CLINOME_CLIENTE,
..
> from CADPRO
> inner join CADCLI as FORNECEDOR on
On 15-5-2014 17:49, Łukasz Bączek bacze...@o2.pl [firebird-support] wrote:
>> Warsaw (without any non-ASCII) will be 6 bytes.
>
> Try the "Warszawa" is 7 bytes.
Warszawa is 8 characters, so would at minimum require a VARCHAR(8). And
as they are all in ASCII, with UTF-8 that is 8 bytes, however to
On 15-5-2014 17:02, Łukasz Bączek bacze...@o2.pl [firebird-support] wrote:
> Hello
> I write in Java one thing and needs to check if the data word, eg
> "Warszawa" includes storage space encoded as UTF8
I am not sure what you mean with "data word".
> I started googling for this and found somethin
On 15-5-2014 08:33, markovdmi...@yahoo.com [firebird-support] wrote:
> Hello. I wrote about databases that became broken for some time ago, for
> today I do big work for fixing this, but sometimes databases became
> broken without any reasons.
Define broken? What errors or problems do you observe?
On 09 May 2014 05:14:42 -0700, "srotyli...@gmail.com [firebird-support]"
wrote:
> Hi Sean,
>
> This may very well be the case. unfortunately I do not have access to
the
> query statements inside the client so I may have to resort to writing
my
> own reports outside of the client.
As a workar
801 - 857 of 857 matches
Mail list logo