The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My work

  • My badges

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming

    20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now

    20140424-Windows-7-free-disk-space

    More Photos
  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,627 other followers

Archive for the ‘Database Development’ Category

ORACLE-BASE – DDL With the WAIT Option (DDL_LOCK_TIMEOUT) in Oracle Database 11g Release 1

Posted by jpluimers on 2016/08/23

To work around this error:

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

ensure your DDL does wait a bit longer than the default of NOWAIT seconds:

alter session set ddl_lock_timeout=30
;
alter table TABLE_NAME
modify constraint CONSTRAINT_NAME enable
;
commit
;

via ORACLE-BASE – DDL With the WAIT Option (DDL_LOCK_TIMEOUT) in Oracle Database 11g Release 1.

Posted in Database Development, Development, OracleDB | Leave a Comment »

Im memoriam: Gwan Tan, friend, Delphi, Firebird, EKON and Delphi-Tage supporter

Posted by jpluimers on 2016/07/11

Overlijdensbericht Swie Gwan Tan; Eindhovens Dagblad; 20160711

Overlijdensbericht Swie Gwan Tan Eindhovens Dagblad; 20160711

Last friday, my good friend Swie Gwan Tan suddenly passed away. Like most good friends, we didn’t see each other often enough, but when we did it always was like we had last seen each other the day before.

We first met ages ago at early BorCon and EKON conferences: I remember them: Gwan, a little chine guy and a really really tall guy (Edwin) on many conferences. It didn’t take long before we chatted and became friends. It must have been the mid 199os, not even sure which year.

Was it the way he was a people person and both Edwin and me very technical? Or he deep into the database side of things and Edwin/me on the Delphi (and later .NET) side? Or were it the long (usually nights) of discussing all sorts of topics (way beyond software development) with some moderate alcohol intake?

I’m still not sure why. These things happen. The beauty of friendships.

Of course I knew Gwan was ill. More than a decade ago walking became more difficult because of a progressive muscle disease that would not affect his heart. Over time he got bound to a wheel-chair. Somewhere in-between he got a heart condition too.

Gwan stayed imperturbable and optimistic. He was enjoying watching sports (Gwan was – despite living near Eindhoven – a huge fan of AJAX, Edwin of Feyenoord, I didn’t care about soccer at all: we had so much fun!) current affairs and movies keeping in touch with so many people. Irregularly he even managed to visit both German and soccer matches. It was so good to see how he enjoyed those. He was also a great family guy: organising events was his thing. His siblings, nephews and nieces always had a great time when meeting him. And then there were the yearly summer BBQ events in the party: awesome!

So it was only natural that – after we started cooperating with better office Germany – Gwan would organise the Dutch “Knowledge Days” events and the technical guys (usually Edwin and me from the Dutch side and Daniel Magin from better office Germany) would present the sessions.

When better office Germany got in trouble (long story) Gwan asked if I could financially help him to take a stake so at least the German personnel could be payed. We did, lost financially but earned life long friendships (and learned a thing or two on how banks operate).

One of the things with Gwan was that there never was a dull moment and always an opportunity to learn. Even from mistakes. Of course we had words once every now and then. But never a really big fight. I guess that’s part of a good friendship.

Another thing was the combination of being modest about himself and proud about others. For example he always proudly named one of his sisters” my little sister” as he was so fond of what she accomplished.

I vividly remember spring 2009 when – right after the Delphi Live 2009 conference – some USA friends, Edwin and me organised a surprise 50th birthday dinner party for Gwan. Despite his condition, Gwan was really happy that he made it to the conference. So having a party like that was a total blast.

He attended way more conferences and seminars than I did, especially an Germany. Unlike me, Gwan loved driving long distance. So he attended many Firebird, Delphi-Tage and other events I didn’t make it to. When I was at events, I could always spot Gwan with lots of people around him. usually near a bar (:

Around the time Gwan’s mom died about 3.5 months ago he spent some time in hospital to treat the edema that came with his muscle condition. It took a while, but the medicines worked, he attended the funeral and moved to an apartment with facilities for disabled and direct access to care.

Last week he had was hospitalised and his conditions worsened faster than anyone expected. Friday morning he quietly passed away. No more pain. No more sorrow.

Sadly we are left behind, but also pleased that his ordeal is over.

A dear, generous, modest and positive friend is gone.

Attending the funeral service

If you want to attend the funeral service, please let me know so I can inform the family of an attendance estimate.

The funeral service will be held on Thursday morning July 14 at 11:30 at this location (they begin 11:30 sharp, be early!):

Onze Lieve Vrouw Presentatiekerk AalstEindhovenseweg 63
5582 HP Aalst -Waalre
The Netherlands

Phone: +31 40 221 22 85 (preferably between 10:00 and 12:00)

The above catholic church is easy to find as it is right in the center of Aalst-Waalre (see the church icon on the map). They welcome everyone: non-catholics and atheist are equally welcome.

There are parking spots nearby on the south side of “de Leesakker” (right behind Greek restaurant Olympia) or in the street next to Restaurant Lugar (for both, see the P markings on the map).

To stay: look for Hotels near Aalst-Waalre. I can recommend the Van der Valk Hotel Eindhoven as Gwan and I have organised some workshops and seminars there.

Sending flowers

Gwan in 2010

Gwan in 2010

If you want to send flowers, make sure they arrive Wednesday afternoon July 13 at this funeral service:

Monuta Sol funeral service
attn. family of Swie Gwan Tan
Felix Timmermanslaan 2
5644 RN  Eindhoven
The Netherlands

Phone: +31 40 212 9800

Monday (today) opportunity to condole

Today, Monday July 11 there will be a brief opportunity to condole the family from 16:30 till 17:30 at this funeral service:

Monuta Sol funeral service
Felix Timmermanslaan 2
5644 RN  Eindhoven
The Netherlands

Phone: +31 40 212 9800

Dutch “overlijdensbericht”

Op 8 juli 2016 is onze lieve, gulle, dappere broer en oom overleden.

Swie Gwan Tan

* Eindhoven, 16 mei 1959           ✝ Veldhoven, 8 juli 2016

zoon van

Sing Liong Tan en Polly Tan-The

  • Voorschoten: Swie Tjiang en Ida
  • Waalre: Yu Kai
  • Voorschoten: Li Sha en Jordi
  • Amstelveen: Swie Han en Marion
  • Amsterdam: Li Mai en Derek; Yu Ri en Marre
  • Amsterdam: Ingkie en Loes
  • Parijs: Xiu Lin en Bart; Qi Bo, Qi Mo, Qi San

Correspondentieadres:
Monuta Sol, t.a.v. familie Tan
Felix Timmermanslaan 2, 5644 RN  Eindhoven

De uitvaartdienst wordt gehouden op donderdag 14 juli a.s. om 11:30 uur in de Onze Lieve Vrouw Presentatiekerk, aan de Eindhovenseweg 63 te Waalre.

Later die dag brengen we Gwan in besloten krijg naar het crematorium te Heeze

Indien U geen persoonlijk bericht heeft ontvangen, gelieve deze aankondiging als zodanig te beschouwen.

English translation:

On July 8, 2016, our dear, generous, brave brother and uncle deceased.

Swie Gwan Tan

* Eindhoven, May 16, 1959           ✝ Veldhoven, July 8, 2016

son of

Sing Liong Tan and Polly Tan-The

  • Voorschoten: Swie Tjiang en Ida
  • Waalre: Yu Kai
  • Voorschoten: Li Sha en Jordi
  • Amstelveen: Swie Han en Marion
  • Amsterdam: Li Mai en Derek; Yu Ri en Marre
  • Amsterdam: Ingkie en Loes
  • Parijs: Xiu Lin en Bart; Qi Bo, Qi Mo, Qi San

Mailing address:
Monuta Sol funeral service
attn. Tan family
Felix Timmermanslaan 2
5644 RN  Eindhoven
The Netherlands

The funeral service will be held on Thursday, July 14 a.s. at 11:30 pm in the Onze Lieve Vrouw Presentatiekerk, Eindhovenseweg 63 Waalre.

Later that day we will privately bring over Gwan to the cremation center in Heeze.

–jeroen

Posted in About, Database Development, DB2, Delphi, Development, Firebird, History, InterBase, Personal, Software Development | Leave a Comment »

Firebird News » Migration Guide to Firebird 3

Posted by jpluimers on 2016/05/02

Reminder to self so I buys this: Firebird News » Migration Guide to Firebird 3

–jeroen

via: Ondrej Kelle

Posted in Database Development, Development, Firebird | Leave a Comment »

NHibernate, LINQ, Oracle and the placement of Take: avoid “Specified method is not supported.”

Posted by jpluimers on 2016/03/22

Even though as of 12c R1, Oracle supports a row limiting clause, NHibernate 4.2 with Oracle.DataAccess.dll 2.112.3.0 does not support that.

When you let it generate the SQL for a LINQ Take call to limit the number of results, you get an exception like this (full exception and stack trace are below):

System.NotSupportedException was unhandled by user code
  HResult=-2146233067
  Message=Specified method is not supported.

The place where you Take is important, as this does fail:
Read the rest of this entry »

Posted in .NET, .NET 2.0, .NET 3.0, .NET 3.5, .NET 4.0, .NET 4.5, .NET ORM, C#, C# 2.0, C# 3.0, C# 4.0, C# 5.0, C# 6 (Roslyn), Database Development, Development, NHibernate, OracleDB, Software Development | Leave a Comment »

Reminder to self: app.config and “ORA-12154: TNS:could not resolve the connect identifier specified”

Posted by jpluimers on 2016/03/17

When you have one app.config for your whole set of DTAP environments (develop/test/acceptance production), every once in a while you get this error:

ORA-12154: TNS:could not resolve the connect identifier specified

For this particular setup, it means the replacement of parameters in the app.config with actual values from the DTAP went wrong (or was missing). For that we’ve some steps in both the PreBuildEvent and PostBuildEvent of the .csproj file:

PreBuildEvent:

del "$(ProjectDir)$(TargetFileName).config"
copy "$(ProjectDir)app.config" "$(ProjectDir)$(TargetFileName).config"

PostBuildEvent:

powershell -noprofile -file Replace-Parameter.ps1 -Path "$(TargetDir)$(TargetFileName).config"

The PreBuildEvent looks like it is not needed, but sometimes Visual Studio forgets to perform the copy action.

–jeroen

Posted in .NET, .NET 2.0, .NET 3.0, .NET 3.5, .NET 4.0, .NET 4.5, .NET ORM, C#, C# 2.0, C# 3.0, C# 4.0, C# 5.0, C# 6 (Roslyn), Database Development, Development, NHibernate, OracleDB, Software Development | Leave a Comment »

 
Follow

Get every new post delivered to your Inbox.

Join 1,627 other followers

%d bloggers like this: