Archive for the ‘InterBase’ Category
Posted by jpluimers on 2009/09/18
Somehow, CodeCentral managed to not only delete my uploaded CodeRage 4 session materials (the videos are fine!), but also newer uploads with other submissions.
Since I’m in crush mode to get the BASTA! and DelphiLive 2009 Germany sessions done, and all Embarcadero sites having to do with their membership server perform like a dead horse, I have temporary moved the downloads, and corrected my earlier post on the downloads.
I have notified Embarcadero of the problems, so I’m pretty sure they are being addressed on their side as well.
Edit 20090919: Embarcadero indicated that between 20090913 and 20090914 there has been a database restore on CodeCentral. Some entries therefore have been permanently lost.
When I get back from the conferences, and CodeCentral is more responsive, I’ll retry uploading it there, and correct the posts.
In the mean time, be sure not to save shortcuts to the current locations, as they are bound to change.
The are the new download locations can all be found in my xs4all temporary CodeRage 4 2009 download folder.

This is the full list of my CodeRage 4 sessions and places where you can download everything: Read the rest of this entry »
Posted in .NET, CodeRage, CommandLine, Conferences, Database Development, Debugging, Delphi, Development, Encoding, Event, Firebird, ISO-8859, ISO8859, InterBase, Prism, SQL Server, Software Development, UTF-8, UTF8 | 1 Comment »
Posted by jpluimers on 2009/09/13
Embarcadero has made available the replays of the CodeRage 4 sessions.
You can find them in the CodeRage 4 sessions overview.
In order to download them from that overview, NOTE: To access this session replay, you must be logged into EDN. you can login or sign-up (which is free).
To make it easier to find all the relevant downloads, below is an overview of my sessions and their links.
Let me know what you use it for, I’m always interested!
Update 20090918: changed the download locations because CodeCentral messed up.
Read the rest of this entry »
Posted in .NET, C#, C# 2.0, CodeRage, CommandLine, Conferences, Database Development, Debugging, Delphi, Development, Encoding, Event, Firebird, ISO-8859, ISO8859, InterBase, Java, Prism, Software Development, UTF-8, UTF8, Visual Studio and tools, XML, XML/XSD, XSD | 4 Comments »
Posted by jpluimers on 2009/09/09
My CodeRage 4 session materials are available for download:
CodeRage 4 is a free, virtual conference on Embarcadero technologies with a lot of Delphi sessions.
It is held from September 8 till 11, 2009, i.e. while I write this 
If you want to watch sessions live, be sure to register through LiveMeeting (the technology they use for making this all happen).
Let me know if you download, and what you are using the sample code for.
–jeroen
Posted in .NET, CodeRage, CommandLine, Conferences, Database Development, Debugging, Delphi, Development, Encoding, Event, Firebird, ISO-8859, ISO8859, InterBase, Prism, SQL Server, Software Development, Source Code Management, TFS, UTF-8, UTF8, Visual Studio and tools, XML, XML/XSD, XSD | 3 Comments »
Posted by jpluimers on 2009/09/05
I just finished recording my CodeRage 4 sessions:
- Practical XML in Delphi
- Reliable Communication between Applications with Delphi and ActiveMQ
- Using Unicode and Other Encodings in your Programs
CodeRage 4 is a free, virtual conference on Embarcadero technologies with a lot of Delphi sessions.
It is held from September 8 till 11, 2009, i.e. next week 
If you want to watch sessions live, be sure to register through LiveMeeting (the technology they use for making this all happen).
This week, I found some time do migrate all the sample projects to the release versions of Delphi Win32 2010 and Delphi Prism 2010.
Delphi Win32 2010 works like a charm: it is much faster and has a much smaller footprint than any other Galileo based IDE.
In fact, it feels almost as fast as the pre-Galileo based IDE’s.
With the added benefit that all the new features make me much more productive, not the least because it has not yet crashed on me this week once.
Crashing has been a frequent thing on me since Delphi 4 (maybe I should not even mention that number ), for most IDE’s at least a couple of times a week, so this is good.
Delphi Prism 2010 works really nice too, it is rock solid, and the language as some great features not found in other .NET languages.
But it still needs a tiny bit more polishing on the Visual Studio IDE Integration part.
There are a few things not as smoothly integrated as I’m used to in C# and VB .NET (for instance when adding assembly references; C# and VB.NET allow you to do that from multiple places in the IDE; Delphi Prism from only one).
I know it is nitpicking (the same holds for the Team Foundation System integration in the Visual Studio IDE: ever tried to add files or folders? There is only one icon that allows you to do it. Ever tried to move files or folders around? No way you can drag & drop, in fact you can move only 1 file or folder at a time, and then the folder tree leaves you at the target).
The Embarcadero folks have worked hard on developer productivity in the Delphi Win32 2010 IDE.
(Did I mention the F6 key? It is an awesome way of directly jumping into configuration dialogs a zillion levels deep.
Did I mention the Ctrl-D key? It instantly reformats your source code to your formatting settings).
So maybe it is now time to put some of that effort into the Prism side as well.
Back to my CodeRage sessions: the recordings are done, they will soon become available as downloads together with the samples/slides.
Keep watching
–jeroen
Posted in .NET, CommandLine, Database Development, Debugging, Delphi, Development, Encoding, Event, Firebird, InterBase, Java, Package Development, Prism, Software Development, Source Code Management, TFS, Visual Studio and tools, XML, XML/XSD, XSD | Leave a Comment »
Posted by jpluimers on 2009/09/03
If you get this error message:
Sep 3, 2009 5:16:24 PM de.aderon.dl.adapter.DataAdapter getConnection
SEVERE: error DataAdapter getConnection : GDS Exception. 335544379. unsupported on-disk structure for file C:\\develop\\Db\\17_20090314.fdb; found 32779.13, support .
Reason: unsupported on-disk structure for file C:\\develop\\Db\\17_20090314.fdb; found 32779.13, support .
Most answers found by google mention that your ODS (on disk structure) is too new for your Firebird version.
But in this case, the portname was pointing to InterBase 2009 (relatively new) in stead of Firebird (2.1.1) also relatively new.
The solution was to fix the connection string:
<key name="connection_uri"><value>jdbc:firebirdsql:127.0.0.1/3050:C:\\develop\\Db\\17_20090314.fdb</value></key>
<key name="connection_uri"><value>jdbc:firebirdsql:127.0.0.1/30521:C:\\develop\\Db\\17_20090314.fdb</value></key>
Firebird 2.1.1 was running on port fbs_211 (decimal 30521), but the jdbc Firebird driver does not understand service names like fbs_211, only hard-coded TCP/IP ports like 30521.
InterBase 2009 was running onport 3050.
–jeroen
Posted in Database Development, Development, Firebird, InterBase | Leave a Comment »
Posted by jpluimers on 2009/08/13
Our strategy is that in all of our InterBase and Firebird databases, the column definitions are based on domains.
But some of our databases do not have that for all columns (usually because we got involved later in the development cycle).
When you forget to define a column based on a domain, then both InterBase and Firebird will create a new system domain on the fly that starts with ‘RDB$’.
So if you forget, you get a new system domain for every column!
The below query will list those columns. Read the rest of this entry »
Posted in Database Development, Development, Firebird, InterBase | 1 Comment »
Posted by jpluimers on 2009/08/13
Shortly, I’ll post a blog entry about find out which columns are not based on domains.
In order get the right definition for those domains, I needed a way to get that info from the DB, preferably in a SQL-statement (that saves you starting your application development environment).
The SQL-statement is based on my initial browsing of these documents:
If you find errors or omissions, please let me know.
So here it is:
Read the rest of this entry »
Posted in Database Development, Development, Firebird, InterBase | Leave a Comment »
Posted by jpluimers on 2009/05/15
I have edited the Conferences, seminars and other public appearances/ page and extended the list of conferences I have attended in the past including many sessions.
Topics covered in these sessions have been C#, Delphi, Databases, Linux, Kylix, debugging, Compact Framework, and much much more.
Let me know which sessions you’d like to see online first.
The list is far from complete, but it is another step into getting the list more accurate.
–jeroen
Posted in .NET, C#, C# 2.0, Component Development, Conferences, Database Development, Delphi, Designer Development, Development, Event, Firebird, InterBase, Package Development, SQL Server, Software Development, Visual Studio and tools, XML, XML/XSD | Leave a Comment »
Posted by jpluimers on 2009/04/22
Tomorrow, the 23rd of April, my Dutch and German InterBase colleauges from better office will be delivering the InterBase PowerDay inAmersfoort.
Speaking are Daniel Magin and Gwan Tan, attending are both regular InterBase developers and InterBase VARs.
The PowerDay costs EUR 124 excluding VAT to attend, and has 4 sessions that roughly covering these areas:
- What’s new in InterBase 2009
- InterBase as a vault
- Advanced InterBase
- Tools to maintain InterBase
The event is organized together with Barnsten, which are the representatives of CodeGear in The Netherlands.
A similar event is organized in Germany on the 6th of May in Frankfurt/Offenbach. That event is organized by better office Germany and CodeGear Germany.
better office Germany is InterBase master reseller, and better office benelux (where I work) has some very knowledgeable InterBase people too.
Posted in Database Development, Development, Event, InterBase, PowerDay | Leave a Comment »
Posted by jpluimers on 2009/04/21

I’ll be speaking during DelphiLive ‘09 that is held from May 13-16 in San Jose (CA, USA, not any of the other San Jose cities).
This is going to be a top event with really knowledgeable Delphi speakers from all over the world.
Besides the 2 sessions that I’m doing, I’ll be hanging around as are the other speakers.
So feel free to approach us, and learn from the things we learned. Or teach us something new: all of us are eager to learn as well as teach!
The downloads are now available.
Posted in Conferences, Database Development, Delphi, Development, Event, InterBase, Software Development | Tagged: Conferences, Delphi, Travel | Leave a Comment »