Zeoslib Portal

Simple example attached.

Multiple TZConnections to same base doesn't works.

I was able to create working example application, that reproduce error in short time (about 5 minutes). And got detailed stacktrace: TZRowAccessor.CheckColumnConvertion(???,???) TZRowAccessor.IsNull(1) TZGenericCachedResolver.FormWhereClause($3F9976C,$3F4EE28) TZGenericCachedResolver.FormUpdateState...

After adding simple check to prevent 'out of range' exception if (FInitialRowsList.Count > 0) and (FCurrentRowsList.Count > 0) then got feedback with bit different stacktrace 15:58:07.754 ERROR [00619029] ZAbstractDataset.TZAbstractDataset.InternalUpdate (Line 388, "..\..\src\component\ZAbstrac...

I guess you know the location where the exception is raised. What I would do it to wrap that block around in a Try ... Except block and then log as much information as I can to identify the situation before re-raising the exception. Dump record IDs, internal component states and everything else wha...

Due to security restriction, I do not have access to that server.
Screenshot from log file (will be discarded in 30 days):

do you have an example where FInitialRowsList is empty and that code can be reached?

It's from logs on production server without debugging, occuring sometimes. Can't reproduce.

In methods: TZAbstractCachedResultSet.InsertRow TZAbstractCachedResultSet.UpdateRow TZAbstractCachedResultSet.DeleteRow in "except" block used very unsafe code, that cause crash in some time: FRowsList[RowNo - 1] := FInitialRowsList[FInitialRowsList.Count - 1]; if FInitialRowsList.Count re...

Sorry, I write to wrong thread, my zeosdbo version is 7.1.4 (stable)

I need to disable cashing of whole result table. It impossible for TZCachedResultSet, by design. It use TList for every result record with RowNum as index. And rcReadOnly and rtForwardOnly do not change that behavior.

TZCachedResultSet is not optimized for read-only unidirectinal access, so it not applicable to very large (millions rows) results. And it only ResultSet for some database types (SQLite, MySQL, PostgreSQL). I suggest some tweaks: unit ZDbcCachedResultSet; TZAbstractCachedResultSet = class (TZAbstract...

I'm from Russia and our president is fucking crazy. There no good chance, that he can be overthrown, for one oppositioner is 3-5 loyalist. Our region is depressive, but it quickly become worse. Situation become dangerously now for me and my family. Please, give me some direction, where in EU i can f...

I successfully used Zeos from development branch (2013-03-05) on Ubuntu Linux 13.04 and 12.04 (x86) with Oracle instant client. compiled with Lazarus 1.0.10, 1.1; FPC 2.6.0, 2.6.2, 2.7.1; under VirtualBox 4.2 @miab3, you can use VirtualBox for testing on different OS - it very simple and handy. It a...

svn://svn.code.sf.net/p/zeoslib/code-0 (commit number 2772) ZAbstractDataset.pas: 524 BM := Bookmark; // cause type error in FPC 2.6.3 if BookmarkValid({$IFDEF WITH_TBOOKMARK}BM{$ELSE}@BM{$ENDIF}) Then begin InternalGotoBookmark({$IFDEF WITH_TBOOKMARK}BM{$ELSE}@BM{$ENDIF}); Resync([rmExact, rmCenter...

Unexpected problem - metadata request for packaged stored procedure gets parameters for all procedures with similar names. We have procedures: some_pkg.some_proc( param_a ) some_pkg.some_proc_one( param_a, param_b ) some_pkg.some_proc_two( param_c ) When we do StoredProcedureName:='some_pkg.some_pro...

It's working now! Thank you!

serbod , Oracle supports Procedure-Overloads. Can you provide a little example how to call such a overloaded procedure-name? Sorry, we don't have such procedures in our projects. I try to convince our DBA create one for testing. UPD: DBA says, that TZSQLProcessor with Oracle reporting some error ab...