or which tests to
>> perform?
I don't really have an idea, but you might want to check if there is a
registry entry that is pointing to the Program Files folder. Delete that
entry and try again. See http://www.destructor.de/firebird/instreg.htm
Mark
---
f arrays. Only potential for problems would be the interface
native Firebird <> Java.
Mark
--
Got Input? Slashdot Needs You.
Take our quick survey online. Come on, we don't ask for help often.
Plus, you&#
s). You need to have all class-files inside your
Firebird server. That doesn't preclude the possibility of installing
software that is a Trojan, but is a lot less likely than from downloading
software of an unknown source.
Mark
--
On Thu, 28 Jul 2011 10:44:06 +0400, Alex Peshkoff wrote:
> On 07/27/11 17:10, Adriano dos Santos Fernandes wrote:
>> From FB POV, signed code for sysadmin means nothing. Sysadmin should
>> just be able to put files where it wants and like UDFs, if it's in the
>> right place it should be used.
>
e
problems and 2) not introduce new and maybe worse problems.
Don't fix things when they are not broken.
Mark
On Thu, 25 Aug 2011 11:50:57 +0300, marius adrian popa
wrote:
> This page may help the project in choosing a better DVCS
>
> "PHP uses Subversion (SVN) as its versio
On Sun, 28 Aug 2011 18:20:31 +0300, "Vlad Khorsun"
wrote:
>> Certainly, we can make API look like we _do_ join a new attachment to
an
>> existing distributed transaction. To do so we just start new
transaction
>> in API call internally (need to know TPB...) and join it with existing
>> distributed
On Tue, 30 Aug 2011 00:17:19 +0300, "Vlad Khorsun"
wrote:
>> The XA semantics are a bit complicated, but essentially the database is
a
>> Resource Manager (RM), and a distributed transaction is assigned an Xid
>> by
>> the Transaction Manager (eg in the case of JavaEE it could be the
>> applicatio
there).
> That happened to me when I refactored that code few years ago, that's
> happening to Mark right now. :)
I will probably need to study the current implementation some more, maybe
the questions I am asking right now have already been addressed in a way I
don't fully un
> 09.04.2012 20:22, Dimitry Sibiryakov wrote:
>>
>> Isn't aliasname field of XSQLVAR for the relation alias name?..
>
> It's the field alias, IIRC.
As far as I know it does indeed contain the field alias, but there is a
comment in the code that says it is for t
> > In this way, you lose dynamic registration, and have the administrator
> > manage the list of databases shown in RDB$DATABASES.
>
> In what database ?
I'd suggest: aliases.fdb ;)
--
NEU: FreePhone - kostenlos mobil telefonieren und surfen!
Jetzt informieren: http:/
> Hi,
>
> When will there be a 64bit version of the Jaybird driver?
Which part of the Jaybird driver? The pure-Java part of Jaybird is
platform-independent and will work on both 32 bit and 64 bit. So you can
connect to a Firebird-server using the TCP/IP protocol.
The embedded part requires a D
Is the tracker down, or is it in maintenance right now? After a long
time I get a 503 Service Temporarily Unavailable.
Mark
--
Mark Rotteveel
--
Get a FREE DOWNLOAD! and learn more about uberSVN rich system,
user
rallel, is that a
correct interpretation?
Third: Can Firebird handle enlistment of multiple transaction handles in
a single two-phase commit, or would this require using a single
transaction handle for a single transaction branch?
Mark
--
Mark
Not sure i understand you correctly... Attachment could participate in
> few separate distributed transactions at the same time (if this was your
> question).
This is essentially restating that I would like to know if it is
possible to have multiple attac
aybe related CORE-1109, CORE-1685, CORE-1061
--
Mark Rotteveel
--
EMC VNX: the world's simplest storage, starting under $10K
The only unified storage solution that offers unified management
Up to 160% m
ure and
requirements, but a query explosion to 600 queries for opening a catalog
(which on the surface sounds easy) seems a bit excessive. Are you sure you
aren't falling in the N+1 query trap, where 1 query could suffice?
Mark
--
2011/04/common-table-expression-cte-and-tree.html
(in Firebird you will need to use WITH RECURSIVE for this)
Mark
--
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at
?
I think that the Oracle WHEN-clause is simply syntactic sugar for wrapping
the entire body in an IF-condition. I don't think there would be much
difference performance-wise.
Mark
--
All the data continuously
umber of code execution points (and
the work for Oracle in terms of code maintenance for a separate conditional
evaluation before triggers).
Mark
--
All the data continuously generated in your IT infrastructure contai
condition.
>
> Seems conditional triggers have sence only for external (non-PSQL)
> triggers.
If you are going to add it, I'd say: add it for everything, not just
non-PSQL triggers, if only for consistency :)
Mark
-
t be a valid
password for another system or connection. Storing it could be a potential
security breach.
Mark
--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, applicat
On Wed, 19 Oct 2011 15:27:36 +0200, Dimitry Sibiryakov
wrote:
> 19.10.2011 15:23, Mark Rotteveel wrote:
>> Storing it could be a potential security breach.
>
>But a great advantage for DBA on support. But, as Alex already said,
it
>is impossible.
True, but if it were
On Wed, 19 Oct 2011 19:41:33 +0200, Thomas Steinmaurer
wrote:
>> 19.10.2011 15:31, Mark Rotteveel wrote:
>>> True, but if it were possible, this is something where the balance
>>> between
>>> convenience and security should tip to security.
>>
>&
Hi,
I am unable to reach the tracker, does anyone else have this problem?
Mark
--
Mark Rotteveel
--
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is
world most characters would occupy 1 byte.
Treating it as actually being variable length instead of simply saying
'it's 4 bytes' would allow you to use 63 upto 254 characters, not just 63.
BTW: Instead of saying 'it is a limit in BLR', what would be the effort to
modify BLR t
ing parameters
> block is not critical from API point of view.
But it does add to to the userfriendliness of that API; which I think is
an important consideration.
Mark
--
All the data continuously generated in yo
essible at all?
>Practice to nullify such fields was born from the inability to
protect
>them from public
> reading.
Why shouldn't it be readable? It is very useful to retrieve and show
metadata and regenerate D
On Tue, 29 Nov 2011 10:07:29 +0100, Dimitry Sibiryakov
wrote:
>Perhaps, better approach would be silently cut long index keys to
>implementation limit.
> This way we don't loose anything, just increase number of "real
> comparsions" with negative
> result during selects.
Wouldn't that gi
On Tue, 29 Nov 2011 10:26:10 +0100, Dimitry Sibiryakov
wrote:
> 29.11.2011 10:20, Mark Rotteveel wrote:
>> Wouldn't that give false positives? Or does the engine also compare the
>> actual (full) value after identifying a row in the index?
>
>Yes, real values are
pty for the
> server binaries but set for the .NET provider packages.
Is it able to discern between 32 and 64 bit? On Windows Vista 64 bit
(using Firefox 32 bit though) I get the suggestion to download the Firebird
32 bit package. It is not that important, but if we can finetune t
m
in embedded, or that I need a find a way to close connections before exit.
Can a core developer look at this?
Mark
--
Mark Rotteveel
--
All the data continuously generated in your IT infrastructure
contains a defin
distributed
>> transaction?
>
>I'm disappointed in distributed transactions, so I don't care. What
is
>returned by
> getInfo() for them?
What do you mean with 'disappointed in distributed transactions'?
Mark
On 4-12-2011 14:43, Mark Rotteveel wrote:
> CORE-3671 describes a JVM access violation which occurs when a Java
> application using Firebird embedded exits when a connection hasn't been
> closed.
>
> The solution / workaround is of course to close() the connection from
&
ormat functions.
>
> For Windows users this binary representation is also wrong now, cause
> reserved bits is not documented in it.
You might want to look at 4.1.1 Variant
Mark
--
Learn Windows Azure Live! Tuesday, Dec
Is there any documentation available on SRP for driver developers. I
looked over the commit Alex did yesterday and although I think I get the
general gist of it, it would be helpful to have some additional
documentation.
Mark
--
Mark Rotteveel
It looks like the snapshots on the website do no include embedded. Is
there another location that includes a Win32 embedded build of the 2.5.2
snapshot?
If not, could someone build one for me so I can verify that CORE-3671 is
resolved by this?
--
Mark Rotteveel
se I see it now :(
--
Mark Rotteveel
--
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
Intel AppUpSM pr
Is there an overview available for the structure of system tables in all
Firebird (ODS) versions? Or do I need to keep databases of the relevant ODS
versions and check those?
Mark
--
Write once. Port to many.
Get the SDK
On 26-12-2011 8:04, Alex Peshkoff wrote:
> On 12/24/11 13:01, Mark Rotteveel wrote:
>> Is there any documentation available on SRP for driver developers. I
>> looked over the commit Alex did yesterday and although I think I get the
>> general gist of it, it would be
or
> plane crash.
Could you stop with the absurd comparisons? One is normal maintenance
and the other is (extreme) disaster recovery which are in no way comparable.
Mark
--
Mark Rotteveel
--
Ridiculously easy VDI. Wi
On 2-1-2012 16:43, Dimitry Sibiryakov wrote:
> 02.01.2012 16:10, Mark Rotteveel wrote:
>> Could you stop with the absurd comparisons? One is normal maintenance
>> and the other is (extreme) disaster recovery which are in no way comparable.
>
> But downtime is downtime.
t
least: being set).
Mark
--
Mark Rotteveel
--
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
On 3-1-2012 22:25, Mark Rotteveel wrote:
> What is the exact meaning of this field? Is it only 0 for computed
> columns, or also in other cases (eg views)? Both the Interbase 6 as
> Helen's book mention it is not used, but apparently it is used (or at
> least: being set).
Ok, I
-v6 versions of gds32.
> All Firebird versions would still be supported, as well as InterBase 6.0
> and above.
>
> This is about Firebird 3.0, of course. Such a cleanup would allow to
> simplify the code and make some future enhancements a bit easier.
No objections from me: remove
On 3-1-2012 22:38, Ann Harrison wrote:
> Mark,
>
>> I am currently going over the JDBC metadata returned by Jaybird, and I
>> was looking for a way to see if a column is COMPUTER BY / GENERATED
>> ALWAYS AS.
>>
>> I found that I should probably look at R
ature of Firebird 3.0 cannot connect to some of
the earlier Firebird versions.
--
Mark Rotteveel
--
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver
1
>
> Why is rdb$field_sub_type for test1 column "0"? Then it looks like
> bigint. Checking the rdb$field_scale could be a solution, but is it
> then numeric or decimal?
I'd say it is a bug. And it is also an indication that I need to revert a
change I did in Jaybir
ficiently. As
> far as I remember, setting affinity on windows sometimes results in
> about 10% performance increase.
I wonder if that assumption is still valid. In recent years Microsoft has
made a number of improvements in its scheduler. I would assume that this
'problem'
e plugins is that every plugin would need to handle
this, and if you have multiple plugins and misconfigure one then you have
inconsistent behavior depending on the plugin for allowing or disallowing
metadata changes (or da
d if it has subtype 0 it should
not be allowed to have a scale other than 0.
> Or consider this - what (sub)type do you think should return this
> expression ?
> NumericField(15, 4) + DecimalField(15, 4)
I would expe
be replaced by programs that do)' by a similar saying
that has 'send mail' replaced by 'process JSON' (as also happened with XML
in the end of 90s start of 00s)?
Mark
--
Keep Your Developer S
ive:
http://people.planetpostgresql.org/andrew/index.php?/archives/245-I-didnt-say-that.html
Mark
--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is ju
me(...) in
http://firebird.cvs.sourceforge.net/viewvc/firebird/client-java/src/main/org/firebirdsql/jdbc/AbstractDatabaseMetaData.java?view=markup
Mark
--
Keep Your Developer Skills Current with LearnDevNow!
The most com
(
http://docs.oracle.com/javase/6/docs/api/java/sql/ResultSet.html#insertRow()
).
--
Mark Rotteveel
--
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft develo
M) with
a readme.txt with instructions to execute it.
This example contains the current Jaybird 2.2 jar and dll, but this
could easily be replaced with the Jaybird 2.1.6 jar and dll (or .so).
--
Mark Rotteveel
--
Virtualizati
On 11-2-2012 15:54, Mark Rotteveel wrote:
> I am looking for the cause of CORE-3701 / JDBC-233, but I can't identify
> the problem.
>
> The problem is this: When using Jaybird native (using fbclient 2.5.1)
> the parametrized insert of a single character into a CHAR(1) colum
On 11-2-2012 16:03, Mark Rotteveel wrote:
> And just after I sent my mail I thought of a potential cause which I am
> now investigating. It looks like the XSQLVAR sqllen field 4, while the
> data array was only 1 entry long. Reducing the sqllen to the actual
> length of the array *or*
On 11-2-2012 17:49, Mark Rotteveel wrote:
> On 11-2-2012 16:03, Mark Rotteveel wrote:
>> And just after I sent my mail I thought of a potential cause which I am
>> now investigating. It looks like the XSQLVAR sqllen field 4, while the
>> data array was only 1 entry long. Reduc
The related issue CORE-3701 can be closed (I don't have the rights to do
that).
Mark
--
Mark Rotteveel
--
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualizat
hort*)currentXsqlvar.sqldata) =
(short)byteArray.Size();
memcpy( currentXsqlvar.sqldata, byteArray.Read(), byteArray.Size());
Which is (sort of) an overflow for single character, one byte, UTF-8 and
messes up the p
rd .NET provider, it is probably better to
ask this question on the Firebird-net-provider mailinglist (see
http://www.firebirdsql.org/en/mailing-lists/ )
It is probably a good idea to include the code that you use to create
your connections (you might be using connection po
On 18-2-2012 20:33, Jiri Cincura wrote:
> Hi *,
>
> can I somehow ask for isc_info_firebird_version without database
> handle? I'd like to know it before processing op_attach.
>
Out of curiosity: why do you want to know the version before attach?
On 18-2-2012 22:38, Dmitry Yemanov wrote:
> 15.02.2012 20:01, Mark Rotteveel wrote:
>
>> Does SQL_VARYING require the sqllen to be updated as well, or can that
>> be left as it was originally set by isc_dsql_describe_bind?
>
> I'd say it should correspond to the real
I finally got around to checking Vlad's fix for CORE-3671: it works, the
access violation no longer occurs.
If nothing else needs to happen it can be marked as resolved.
Mark
--
Mark Rotteveel
--
Virtualiz
On 13-2-2012 16:33, Dmitry Yemanov wrote:
>> * Is 0x20 (space) the right pad char for connection characterset NONE?
>
> Yes.
When sending a CHAR CHARACTER SET OCTETS field, I assume that it should
be padded with 0x00, right?
Mark
--
Ma
On 19-2-2012 10:54, Jiri Cincura wrote:
> On Sun, Feb 19, 2012 at 9:34 AM, Mark Rotteveel wrote:
>> Out of curiosity: why do you want to know the version before attach?
>
> For some EF internals.
>
Ok, but to what end do you need that information before the attach?
it about time to drop support for dialect 1?
Mark
--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint,
h a clear error
message and advise people to migrate their database to dialect 3 on
Firebird 2.5 or earlier. IMHO This should have happened earlier (eg with
Firebird 2). Dropping this kind of deprecated baggage would be a good
thing; especially as th
direction?
Mark
--
Mark Rotteveel
--
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered
a process (see
http://msdn.microsoft.com/en-us/library/windows/desktop/cc441804%28v=vs.85%29.aspx
)
If Firebird is not accessing certain memory pages, Windows is free to
reduce the working set and store those memory pages in the pagefile.
Ma
Are events available on embedded, and if so are there any special things
you need to take care of to get them working?
Mark
--
Mark Rotteveel
--
For Developers, A Lot Can Happen In A Second.
Boundary is the first to
On 9-4-2012 12:43, Dmitry Yemanov wrote:
> 09.04.2012 14:19, Mark Rotteveel wrote:
>
>> Are events available on embedded, and if so are there any special things
>> you need to take care of to get them working?
>
> Of course they're available and working out of the box
On 9-4-2012 13:42, Dmitry Yemanov wrote:
> 09.04.2012 15:24, Mark Rotteveel wrote:
>
>> Ok, then I need to get digging why some of the event related embedded
>> tests are failing. I had ignored them previously because of this
>> stackoverflow post:
>> http://stackover
relational alias information as part of the prepare?
Mark
--
Mark Rotteveel
--
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try
I was just looking at an old ticket for Jaybird (JDBC-94) which is
actually caused by a bug / deficiency in Firebird (see CORE-2697). This
was fixed for Firebird 3.0 in 2009.
I was wondering if this fix can also be backported to Firebird 2.5?
Mark
--
Mark Rotteveel
authentication?
--
Mark Rotteveel
--
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary
On 18-4-2012 20:20, Dmitry Yemanov wrote:
> 18.04.2012 21:55, Mark Rotteveel wrote:
>
>> I just installed Firebird 3 from the Windows x64 zip kit, but I am
>> unable to authenticate using FlameRobin, or using Jaybird.
>
> What fbclient version is loaded by FlameRobin?
>
d Legacy_Auth to the AuthServer setting
Thanks, I had overlooked that setting, I thought both lines started with
AuthClient and had wondered why it was shown twice :|
Mark
--
Mark Rotteveel
--
Better than sec? Noth
On 18-4-2012 20:39, Mark Rotteveel wrote:
> On 18-4-2012 20:30, Vlad Khorsun wrote:
>>> In the conf file I have uncommented:
>>> AuthClient = Srp, Win_Sspi, Legacy_Auth
>>
>> This is client setting.
>>
>>> Am I missing an additional step to g
On 18-4-2012 20:41, Mark Rotteveel wrote:
On 18-4-2012 20:39, Mark Rotteveel wrote:
On 18-4-2012 20:30, Vlad Khorsun wrote:
In the conf file I have uncommented:
AuthClient = Srp, Win_Sspi, Legacy_Auth
This is client setting.
Am I missing an additional step to get things working with
On 18-4-2012 19:22, Adriano dos Santos Fernandes wrote:
> On 18/04/2012 14:12, Mark Rotteveel wrote:
>> I was just looking at an old ticket for Jaybird (JDBC-94) which is
>> actually caused by a bug / deficiency in Firebird (see CORE-2697). This
>> was fixed for Firebird 3.0
On Thu, 19 Apr 2012 09:35:13 +0400, Александр Пешков
wrote:
>> It looks like Jaybird uses an authentication mechanism that is no
longer
>> supported with Firebird 3:
>>
>> Hex dump from wireshark for both Jaybird (fails) and Flamerobin
>> (succeeds) is attached. Most obvious thing I notice that
On Thu, 19 Apr 2012 11:36:15 +0400, Dmitry Yemanov
wrote:
> 19.04.2012 11:22, Mark Rotteveel wrote:
>
>> Thanks. I also created a ticket to see if it is easy to change Jaybird
to
>> use the hashed authentication for Jaybird 2.2, but I don't want to do
>> major
>&g
On Thu, 19 Apr 2012 10:23:16 +0200, Kjell Rilbe
wrote:
> Den 2012-04-19 10:17 skrev Dmitry Yemanov såhär:
>> 19.04.2012 12:02, Mark Rotteveel wrote:
>>
>>> Ok, that sounds relatively easy. What is the hashing algorithm, and
>>> where
>>> in the Fire
On 19-4-2012 10:17, Dmitry Yemanov wrote:
> 19.04.2012 12:02, Mark Rotteveel wrote:
>
>> Ok, that sounds relatively easy. What is the hashing algorithm, and where
>> in the Firebird sources can I find its implementation?
>
> Something derived from DES, AFAIK. See ENC_cryp
On Fri, 20 Apr 2012 10:40:29 +0400, Alex Peshkoff
wrote:
> On 04/19/12 22:48, Mark Rotteveel wrote:
>> On 19-4-2012 10:17, Dmitry Yemanov wrote:
>>> 19.04.2012 12:02, Mark Rotteveel wrote:
>>>
>>>> Ok, that sounds relatively easy. What is the hashing algorit
uld just as well use the Type 2 (native) driver .
This uses fbclient, which - I assume - should be able to load the plugin by
itself.
Mark
--
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know..
e I've really killed that authentication method. Will fix.
>
> Please check it now. Should work.
As far as I can see this change is not yet in the Windows snapshot build
(just looking at the ChangeLog).
Mark
--
Mark Rotteveel
--
e I've really killed that authentication method. Will fix.
>
> Please check it now. Should work.
Tested it against Firebird-3.0.0.29945-0_x64 on Windows 7: plain text
authentication works again.
Mark
--
Mark Rotteveel
---
On 18-4-2012 22:08, Mark Rotteveel wrote:
> On 18-4-2012 19:22, Adriano dos Santos Fernandes wrote:
>> On 18/04/2012 14:12, Mark Rotteveel wrote:
>>> I was just looking at an old ticket for Jaybird (JDBC-94) which is
>>> actually caused by a bug / deficiency in Fir
but in my opinion that is overruled by the fact that the ATT
website itself says it is under EPL before you download it.
If you want to know for sure, contact either g...@research.att.com
(feedback link on the download page) or at...@at
On Thu, 24 May 2012 08:39:55 +0200, Mark Rotteveel
wrote:
> They also state that the entire package is covered by the license:
> http://www2.research.att.com/sw/download/
Under 'License' in the menu on the
On Thu, 24 May 2012 10:36:51 +0200, Michal Kubecek wrote:
> On Thu, May 24, 2012 at 08:39:55AM +0200, Mark Rotteveel wrote:
>> Before downloading you have to accept the EPL license. Now that package
>> does contain a stdio.h (in src/lib/sfio/stdio_s) with the 'scary
r many
> warnings per statement (or per API call) it will be the best, as for me.
In JDBC warnings are either on Connection, Statement or ResultSet level.
If the API is going to be more OO, then it might be an idea to link the
warnings on similar levels.
nterfere with new design for no
> reason".
Are you saying warnings are useless, or just the way they are currently
implemented?
--
Mark Rotteveel
--
Live Security Virtual Conference
Exclusive live event will
, Jaybird could do so as well.
You could also look at manually changing the
/WEB-INF/classes/entitydefs/entitymodel.xml file to see if you can solve
the problem that way (see 'Configuring the Entity Engine for JIRA' in the
JIRA documentation.
Mark
--
On Wed, 27 Jun 2012 17:19:34 +0200, Mark Rotteveel
wrote:
> It would be interesting to see what other JDBC drivers report for the
the
> DatabaseMetaData.getSQLKeywords() method. Jaybird explicitly does not
> include TIMESTAMP as that should already be a SQL-92 (and/or SQL:2003)
> r
"what kind of idiot must be DB developer to choose reserved word
> as a field's
> name", they wouldn't have had chance to reject it this way.
> People are inertial, you have to kick hard to make them moving.
I have to say that this kind of attitude is toxic
On Fri, 6 Jul 2012 09:22:13 +0300, marius adrian popa
wrote:
> I propose that default dialect to be Dialect 3 and dropping support for
> dialect 1 in far and future Firebird 3.5.x/4.x for example (mark is as
> deprecated and it will not do anything when set)
>
> in python driver
ant to save on transliteration would still have
>> that ability by matching the server and connection charsets or by using
>> NONE as a connection charset. Does anybody see any problem here?
>
>Yep: how to find out server version before creating databas
1 - 100 of 1718 matches
Mail list logo
