243 results found
-
Support complex connect strings in direct mode
I would like to use complex connect strings similar to JDBC thin driver, e.g.
(DESCRIPTION=(CONNECTTIMEOUT=5)(TRANSPORTCONNECTTIMEOUT=3)(RETRYCOUNT=5)
(ADDRESSLIST=(LOADBALANCE=OFF)(FAILOVER=ON)
(ADDRESS=(PROTOCOL=tcp)(HOST=xyz1.abc.def.loc)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xyz2.abc.def.loc)(PORT=1521)))
(CONNECTDATA=(SERVICENAME=ABCD_GCSTANDBY)))It is similar to the entries you can put into the TNSNAMES.ORA file.
It looks like ODAC.net does support something similar,
I would like to have it in the VCL version.To us, the most important thing is Connect Time Failover
9 votes -
Allow us to copy parameters in dbMonitor
In dbMonitor on the parameters screen it would be wonderful to be able to right click and copy the parameter value. We use lots of GUIDs and that would make life so much better when debugging.
Or can I download the source code for dbMonitor and edit it myself?
thanks,
Jon.
3 votes -
pass fetch duration to DB Monitor
db Monitor has fetch checkbox that is useless at the moment.
It would be nice if the fetch time would be sent to the db monitor1 vote -
proper support for connections in threads so transactions can be used
Connection Pooling should work in multi threaded environments with transactions.
I think the current design may be flawed. I think there should be a special connectionpool with which connections can be linked. in a multi-threaded environment, you want the thread to grab a connection, use it, and release it. at the moment, if you want to start a transaction, with connection pooling enabled, the current connection is basically blocked as it does not do anything smart in tracking the underlying connection to a thread. I currenltly get an error - cannot start transaction when one is already active... so I…6 votes -
Support inherited tables on the TPgDump component of PgDAC
Actually (v6.2.4), the PgDac TPgDump component does not generate appropriate code for inherited tables, making it useless when inherited tables are used, and we need to get the SQL script to generate the given schema.
TPgDump should support tables inheritance and:
- create base tables before inherited tables
- use the inherits clause within the table creation sql statement
- do not generate insert statements for base tables data, only for inherited tablesThanks,
3 votes -
UNIDAC to support multiple connection pools in one application
It would be great if UNIDAC could allow the use of multiple connection pools. For example I need two connetion pools to 2 different databases at the same application. This is currently not supported in UNIDAC
4 votes -
Multithreading : Copy data from query
Hello,
I'am testing multithreading with IBDac. For the moment the solution I have found is :
1) Execute a TIbcquery in a thread
2) Copy the result of 1) into a Memory Dataset (in the main thread) when 1) finished.I would like to know if it possible to do something like Firedac :
https://delphi.programmingpedia.net/en/tutorial/4114/retrieving-updated-tdataset-data-in-a-background-thread
or
https://riptutorial.com/fr/delphi/example/14361/exemple-firedacThe very interesting to transfer data between Query is the property :
Form.FDQuery1.Data := Query.Data;
4 votes -
They should have a component that imports data from excel, csv, or text into a table and that supports large files.
They should have a component that easily imports data from excel, csv or text into a table and that supports large files.
3 votes -
dbMonitor needs an upgrade, adding some basic common sense functionality
It's about time dbMonitor had a long awaited upgrade with some really basic common sense pieces of functionality added.
1) Add buttons to clear terminated processes and all processes. Come on guys, having to select each process one by one to clear it is, quite frankly, ridiculous and poor UI design.
2) Parameters should be formatted according to the DB you're connected to.
E.g. for Oracle
Like this...
:SrcSchema VARCHAR2(13) :='MY_SCHEMA' ;rather than this
:SrcSchema(VARCHAR[13])='MY_SCHEMA'
Why? Well it allows us developers to set up anonymous blocks quickly to test the same call, if say an error occurs. Currently I…1 vote -
Properties From MyDAC
It would be Nice to have implementation of:
- TUniQuery.CommandTimeOut
- TUniQuery.Options.NullForZeroDate4 votes -
Support TDataset.FieldOptions (AutoCreateMode) in Unidac
Please implement the support of AutoCreateMode in your components.
Further description:
http://docwiki.embarcadero.com/Libraries/Rio/en/Data.DB.TFieldOptions.AutoCreateModeWith this option it's possible to create calculated fields in design time and all other fields will be added automaticly on runtime.
3 votes -
Support for Firebird 3 item isc_dpb_auth_plugin_list
Add support for Firebird 3 item iscdpbauthpluginlist and iscspbauthpluginlist. At the moment I am not able to specify what plugins are available to log in to Firebird 3.0 (Legycy_auth, Aug, Aug256)
1 vote -
Add desing time support for custom SQLite functions with UniDAC.
When you add a new sql function at runtime (TLiteUtils.RegisterFunction) you can't use it at design time in a UniQuery because the function is unknown.
1 vote -
Add CSV import to virtual table in addition to existing XML import.
It would be good to have the ability to populate a table direct from CSV file
8 votes -
Direct Mode Support When using Wallet
It is very important nowadays in using oracle cloud services, which require using the oracle Wallet, especially for ADW and ADT.
16 votes -
1 vote
-
csv
Dar soporte para archivos csv
4 votes -
Add "Inverse Null Sort" (f.e.: "IN") function to IndexFieldNames
As the "coInvertNullOrder" flag -for client side sorting the dataset- is already imlpemented for some of the providers, it would be nice to be able to control the default method how NULL values are sorted (comes as first or comes as last).
The best approach would be to be able to control this over f.e. with an "IN" postfix in the IndexFieldNames, per field.
Like: "SomeField DESC IN;OtherField ASC"
Thx.
3 votes -
dbmonitor
dbMonitor - Define in the application for each TUniConnection if it sends messages to dbMonitor or not.
3 votes -
Add cache for default values
FillFieldsDefaultValues (in TCustomDADataSet.DataEvent) procedure is called everytime for a dataset, if Options.DefaultValues is True. It creates a query to get the default values. It might be a good idea to cache the defaults and avoid the query.
11 votes
- Don't see your idea?