BDNradio: Database features of Delphi 2005 with Ramesh Theivendran and Joerg Weingarten

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

Delphi 2005 Database Features with Ramesh Theivendran and Joerg Weingarten

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

VIP Lounge

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 interest.

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 Swindell.

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 databases.

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 across databases.

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 documentation.

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 January 2005.

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:
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 idea.

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 possible.

Public chat

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 invited speakers.

doychin: hi
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 as well
JoeH: thanks again for these great chat events !
bmoelk: yes, thank you
Jaap: Thanks

Server Response from: ETNASC01