For forums, blogs and more please visit our
Developer Tools Community.
By: John Kaster
Abstract: Read the chat log and listen to the replay of the live interview with Ramesh and Joerg on Delphi 2005 database features
Listen to the audio replay.
This is a log of the chat room during the live audio chat from December 20, 2004 on
Delphi 2005 with Ramesh Theivendran and Joerg Weingarten.
They discuss database features in Delphi 2005.
Note: This log is only the chat room
transcript. There is much additional information covered in the audio
replay that is not available in this chat log. For all previous and
upcoming live chats, see https://bdntv.borland.com/chat.html.
jkaster: drbob42: "Do you have (code) examples of
passing parameters in a DataSync/RemoteServer -
RemoteConnection/DataHub setting (with a parameterized query as
SelectComand for a DataAdapter/DataProvider at the DataSync
side)?" - Definitely there is a way you can pass
parameters. Every time a client comes in, your client-activated object
is remoted to the client. Each gets its own instance of the datasync.
You could change your provider collection and refresh on the hub.
We'll post something publicly for this.
jkaster: drbob42: "Does UpdateMode = Changed only
apply to BdpDataAdapters (or also to SqlDataProvider?)" -
UpdateMode and commitbehavior only apply to BDP data
adapters. When we did BDP, ADO.NET 1.0 didn't have any metadata
abstraction so we couldn't do opmtimal sql generation for updating.
For anything other than BDP, we use commandbuilder, which does not
generate optimal SQL for updating.
jkaster: nickh: "Will you be adding the
ability to build Datasnap /servers/ into VCL.NET?" -
Seppy would probably be the right person to ask this
question. We'll definitely investigate if there's a lot of
jkaster: RobLove: "Is there a way for the
Data Explorer to support any ADO.Net provider, or does it only support
BDP?" - Ramesh: Right now Data Explorer is tied to
BDP. We're working on a new model for the next release. Joerg: My
visiion is to have an "open tools API" for the Data Explorer.
One of my goals is to show dbExpress in the connections explorer, and
hook up your own designers, etc.
jkaster: drbob42: "Could you modify BdpConnection
to load the SqlXXX components (supported connection pooling
etc.)?" - Ramesh: If we update the DataExplorer the
way we want, this won't be that needed. Joerg: connection pooling
is one of the most asked features for BDP. Right now we're looking
at what ADO.NET 2.0's framework provides to determine the best way
for providing connection pooling.
jkaster: livechat: "Has the development of
BDP adapter for Sybase SQL Anywhere been cancelled, and if not when can
we expect to see it available?" - Ramesh:That's
a question you should follow up with John Kaster and Michael
jkaster: Serge_d: "Do you feel a danger in
not be able to keep up with version updates for databases you are
supported." - Ramesh: That's a very, very good
question. It's a big problem for us. We are constantly trying to
match up with the latest and the greatest features of our supported
jkaster: Serge_d: "If developer is using
ANSI SQL and works with ANSI_SQL complaint DB, how ADO.Net would be
less sensitive for DB migrations?" - Ramesh: If you
look at data migration capabilities in ADO.NET today, they are minimal.
What you achieve with BDP is standard data type mappings that work
jkaster: tmiller: "/ask Will you be
publishing a new dbExpress interface guide?" -
Ramesh: There are plans to get the documentation in a clear,
updated form. We're also working on BDP interface
jkaster: JoeH: "Why can't the delphi
database vendors keep their own bdp drivers current ? Are they provided
the specs to develop their own BDP drivers ?" - We just
answered this. There is a draft we'll post hopefully by end of
jkaster: Jaap: "It is know that you must
always use the Close method of the BdpCommand so the Connection can be
freed, but that seems not to work when you call a stored procedure
(MSSQL)" - Ramesh: It looks like a bug report to me.
We'll have to investigate. Please provide a QC bug report.
jkaster inserts the following link: https://qc.borland.com
jkaster: is the QualityCentral web site
jkaster: tmiller: "What about source code
for dbExpress and BDP drivers?" - Ramesh: That again
has to go through product marketing and management. We have opinions as
developers, but we don't make final decision on this. The dbExpress
MySQL driver for Kylix is available on Source Forge.
jkaster: JoeH: "a comparison grid between
dbgo, bdp, and dbexpress on where to use each (advantages per setting)
would be helpful" - Joerg: That's a very good
jkaster: tmiller: "What about keeping
older version compatibility in the drivers too?" -
Ramesh: There are scenarios where we cannot avoid backward
compatibility, but we try to maintain backward compatibility as much as
Welcome to the moderated Borland Community Chat!
You are allowed to speak freely with everyone in this lower window. In
the upper window you'll find all messages written by moderators and
EricH: sound is good.
drbob42: Hi Ramesh, good to "see" you again.
doychin: anyone from bulgaria?
youseful: hi all
livechat: Hi youseful!
nickh: I asked the Datasnap question to Seppy, and they
told me to ask Ramesh this week! ;-)
livechat: Connection pooling is usually a domain of each
particular ADO.NET provider.
livechat: Thank you. Yes, I believe Sybase Anywhere is a
very important database engine to support.
bmoelk: re: comparison grid; should include ado.net as
JoeH: thanks again for these great chat events !
bmoelk: yes, thank you
Could not retrieve comments. Please try again later.
Download Delphi 10 now!
Webinars on demand!
More social media choices:
Delphi on Google+
@RADTools on Twitter
Server Response from: ETNASC04