Search found 18 matches

by JavaPauloMG
16.08.2011, 20:58
Forum: 6.6 - stable
Topic: Erro ZeosLib 6.6.6., with Oracle 10g + Delphi 7
Replies: 2
Views: 688

The error appers related to miliseconds convert, i do a convert in statement and now it's work, the question is how to correct the error to all users? select TO_TIMESTAMP(TO_CHAR(current_timestamp, 'DD-MM-YYYY HH24:MI:SS'), 'DD-MM-YYYY HH24:MI:SS') from dual The inspiration to this correction is fro...
by JavaPauloMG
16.08.2011, 19:32
Forum: 6.6 - stable
Topic: Erro ZeosLib 6.6.6., with Oracle 10g + Delphi 7
Replies: 2
Views: 688

Erro ZeosLib 6.6.6., with Oracle 10g + Delphi 7

Hello my friends, I found a error when i execute a simple SQL statement in a TZQuery: select current_timestamp from dual The error is "invalid argument to time encode", i comment this line in code, and this pass correct. It can be a propertie from ZConnection to Oracle? The ZeosLib work's ...
by JavaPauloMG
03.08.2011, 15:45
Forum: 6.6 - stable
Topic: Error to do Update, using the same ZConnection in a While
Replies: 6
Views: 853

I discover the error, this only occours when i set "wConnection.Properties.Add('hard_commit=yes');" in the connection, but i need this statement, to convert, and use the same behavior of DBX, now the question is, is a error of experimental hard_commit=yes? I know i need to change my archit...
by JavaPauloMG
02.08.2011, 17:49
Forum: 6.6 - stable
Topic: Error to do Update, using the same ZConnection in a While
Replies: 6
Views: 853

I will show my connections params, maybe it can be i use hard_commit = true. wConnection.TransactIsolationLevel := tiReadCommitted; wConnection.HostName := '127.0.0.1'; wConnection.Database := ''; wConnection.User := 'SYSDBA' wConnection.Password := 'masterkey'; wConnection.Protocol := 'firebird-1.5...
by JavaPauloMG
02.08.2011, 13:32
Forum: 6.6 - stable
Topic: Error to do Update, using the same ZConnection in a While
Replies: 6
Views: 853

This realy strange, in DBX its works, but now it's is the problem, i convert 20 app, and all use this logic, if i put a diferent connection to query it works, but my convert process now is more slow...
by JavaPauloMG
01.08.2011, 20:38
Forum: 6.6 - stable
Topic: Error to do Update, using the same ZConnection in a While
Replies: 6
Views: 853

Error to do Update, using the same ZConnection in a While

Hello, I still convert all programs, to ZeosLib 6.6.6, but i found a strange problemn, in this code, when the "Next" statement is called, but in DBX this code Works, and in many applications this logic are used, i do something wrong? procedure TFi000.btnClick(Sender: TObject); var query1 :...
by JavaPauloMG
20.07.2011, 13:31
Forum: Off Topic
Topic: ZeosLib Still in Development?
Replies: 5
Views: 25001

As stated some days ago, we are in the process of restart the development. Anyway it look to me FB 2.1 works well .. I try do some tests with FB 2.5 in order to verify all works as usual It's good my friend, i decide chance for the zeoslib, because the dbxpress are a close plataform, and i don't wa...
by JavaPauloMG
19.07.2011, 14:04
Forum: Off Topic
Topic: ZeosLib Still in Development?
Replies: 5
Views: 25001

ZeosLib Still in Development?

I have search in many places, but i dont found any notice about this, the zeoslib still in developing? i make this question because i chance all libs in my projects, now i using firebird 1.5 with dbxpress, but i want to chance to firebird 2.1 with zeos, and in the future to 2.5. i can help in someth...
by JavaPauloMG
20.06.2011, 15:07
Forum: 6.6 - stable
Topic: Server Performance Decrease on Firebird 2.1 with ZEOSLIB
Replies: 0
Views: 540

Server Performance Decrease on Firebird 2.1 with ZEOSLIB

Hi again my friends, I have some problemns in convert a lot of big applicattions, acually this applications still using DBX conection, and firebird 1.5, but now we gone to migrate do firebird 2.1, but the connector DBX, don't support 1.5, this is motiving me to use ZeosLib, in all applications, but ...
by JavaPauloMG
13.06.2011, 20:39
Forum: 6.6 - stable
Topic: Error When a ZQuery Open a Image Blob Field Firebird 2.1
Replies: 1
Views: 513

Problemn Solve

Hi my friends, the erros only ocorrurs, when the subtype is negative, if i chance the subtype to zero (0), the error don't ocorrurs.

But the negative value for a subtype in a blob, is supported by firebird, it's a error on zeoslib?

Thanks to all.
by JavaPauloMG
10.06.2011, 15:56
Forum: 6.6 - stable
Topic: Error When a ZQuery Open a Image Blob Field Firebird 2.1
Replies: 1
Views: 513

Error When a ZQuery Open a Image Blob Field Firebird 2.1

Hi friends again, I have a new problem when i open a VCL ZQuery, and the statment point to a blob field in table, and this fileld "LOGOMARCA" keep a image inside, the program give the error atach, i doing something wrong? Thanks to all. Script table /* Table: SCCLIENT, Owner: SYSDBA */ CRE...
by JavaPauloMG
26.05.2011, 14:00
Forum: ZDBC (ZEOS Database Connectivity)
Topic: Memory Leak at DriverManager.GetConnection
Replies: 11
Views: 3341

It's me again, i discover my error, this a sample how the error occurs: procedure TForm1.btnTmpClick(Sender: TObject); var fConnection : IZConnection; fPreparedStatement : IZPreparedStatement; begin fConnection := DriverManager.GetConnection('zdbc:firebird-2.1://127.0.0.1/C:\Desenvolvimento\OODelphi...
by JavaPauloMG
25.05.2011, 12:28
Forum: ZDBC (ZEOS Database Connectivity)
Topic: Memory Leak at DriverManager.GetConnection
Replies: 11
Views: 3341

I discover the error, when i use de IZPreparedStatement, with a "select" command, the memory leak, ocorrurs, but when i use IZStatment, so make a "select" the memory leak don't ocorrurs, somebody can tell me if this is a correct behavior? or i use the wrong component to make a si...
by JavaPauloMG
24.05.2011, 14:30
Forum: ZDBC (ZEOS Database Connectivity)
Topic: Memory Leak at DriverManager.GetConnection
Replies: 11
Views: 3341

I make some more tests, and the memory leaks only ocorrurs when the prepared statement, execute a select statement, the erro not ocorrurs, when are a update, insert, or delete statment.
by JavaPauloMG
24.05.2011, 12:58
Forum: ZDBC (ZEOS Database Connectivity)
Topic: Memory Leak at DriverManager.GetConnection
Replies: 11
Views: 3341

Hi my friend, i have test following the way you show me, and the memory leak only have ocorrured when i execute the statment, but when i execute de statment "remove" the error don't ocorrurs: procedure TEntityManagerFirebird.persist(entity: TDpaEntity); var fPreparedStatement : IZPreparedS...