Subject Re: [Firebird-Java] Re: Jaybird and MacroMediaCFMX 6.1
Author Clausheeg
Post date 2003-12-11T22:17:24Z
Hello Roman , thank  you  for reply  to my questions...
 
I will give all details ...
the Cold Fusion MX6.1 does support the blobs retrieved by ODBCJDBC brigde using firebird odbc drivers...
(even snapshots) and this is the query
 
 
select x from Xtab ; x for a blob field maybe a  "text"
 
the CFM handle queries like that
<cfquery  name="myquery" datasource="my_jdbc_db">
select blob_text from text_archives where ...
</cfquery
--> gives a bunch of context variables
myquery.currentrow 1..n
myquery.recordcount = n
and the variable myquery.blob_text  containing the blob-text
This is all true when I use the ODBCJdbc driver snapshot from IBPhoenix.
 
 
JAYBIRD
 
pure Java / JCA Jaybird connection is doing "normal" field values varchar, char, int, double , number(n,p) ...
and it is FASTER then the odbc.
But with BLOB it raise an error and also the "recordcount"  is not there.
When I do select a blob field then I get :
 
<<< you can't read a new blob >>> Error Executing  Database Query
 
the Jaybird is one posted an sourceforge -  "firebirdsql.jar"  Date 29.04.2003 296kb
 
----- Original Message -----
Sent: Thursday, December 11, 2003 11:59 AM
Subject: [Firebird-Java] Re: Jaybird and MacroMediaCFMX 6.1

> I have tested  Jaybird form sept/2003 Jdbc and CFMX 6.1 using XP and
> FB1.5 so I found no support to select blob_fields -- Error  message
> "Error READ NEW BLOB"

Can you post exact version of the driver?

> and to get the variables
>
> myquery.recordcount

Currently server does not return number of records in a query, since
it knows it only after fetching the last record. In order to get
number of records another query has to be executed.

> myquery.currentrecord

What does it mean? Record number?

> simple question regdg BLOB - are not supported?

They are supported. It is not clear why don't they work for you, but I
hardly can tell anything without seeing calls being executed.

Best regards,
Roman Rokytskyy



To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.