The Wiert Corner – irregular stream of stuff

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

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

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

    Join 1,854 other subscribers

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 »

Capture tmux output – the much less painful way | Rico’s Tech Memo – copy full tmux buffer to file…

Posted by jpluimers on 2016/03/21

Simple steps to Capture tmux output – the much less painful way | Rico’s Tech Memo

Note the last line under 8) is a literal command: type it as such and it will save to that file.

–jeroen

Posted in *nix, *nix-tools, Power User, tmux | Leave a Comment »

Solving VMware Fusion 6 and Windows 7 VM performance issues | Shogan.tech

Posted by jpluimers on 2016/03/21

Add these entries to your .vmx file:

MemTrimRate = "0"
sched.mem.pshare.enable = "FALSE"
prefvmx.useRecommendedLockedMemSize = "TRUE"

Works in VMware Fusion 5, 6, and 7. Probably 8 too.

–jeroen

via Solving VMware Fusion 6 and Windows 7 VM performance issues | Shogan.tech.

Posted in Fusion, Power User, Virtualization, VMware | 2 Comments »

What is 1e100.net? – Google Help

Posted by jpluimers on 2016/03/19

LOL:

Most typical Internet users will never see 1e100.net, but we picked a Googley name for it just in case (1e100 is scientific notation for 1 googol).

Source: What is 1e100.net? – Google Help

Posted in Fun | Leave a Comment »

Highest peak power so far for 1060NP71 3.250kW: 2424 Watt

Posted by jpluimers on 2016/03/18

At 20160703, we had the highest peak power this year so far: 2424 Watt. It was for just a moment, but still (:

Source: 1060NP71 3.250kW | Live Output

–jeroen

Posted in LifeHacker, Power User, Solar Power | Leave a Comment »

OpenVPN – How to connect to Access Server from a Mac – basically says use Tunnelblick

Posted by jpluimers on 2016/03/18

Nice summary for just saying “Use Tunnelblick

This howto article explains how to obtain and setup a Mac openvpn client to connect to the OpenVPN Access Server.

Source: How to connect to Access Server from a Mac

–jeroen

Posted in Apple, Mac, Mac OS X / OS X / MacOS, Mac OS X 10.5 Leopard, Mac OS X 10.6 Snow Leopard, Mac OS X 10.7 Lion, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, MacMini, OpenVPN, OS X 10.11 El Capitan, OS X 10.8 Mountain Lion, OS X 10.9 Mavericks, Power User | Leave a Comment »

TP Link ER5120 limitations: lacking and disturbing features

Posted by jpluimers on 2016/03/18

Mikrotik have statistics and way more features. The most lacking or disturbing features on the TP-LINK (none of which are mentioned in their documentation):

  • The documentation mentions you can enable Enable Bandwidth Based Balance Routing then select the WAN connections to combine but that doesn’t work at all, even if you follow the bandwidth steps carefully.
  • Balanced Routing work when you perform these steps as mentioned at time point 457 in this video https://youtu.be/YDUfP8a5zNY
    • Enable Application Optimized Routing
    • Enable Bandwidth Based Balance Routing
  • Virtual-Server table can only handle 32 incoming port redirects; you get the message “Cannot add more than 32 Virtual Server entries” like in the picture below.
  • No IPv6 support
  • No way to show any statistics as graphs.
  • Every once in a while the web interface becomes really really slow which only a reboot can resolve.
  • You cannot have one of the WAN connections have multiple IP addresses.
  • Local DHCP clients are not added to the DNS proxy which means you cannot resolve them by name.
  • TCP Sequence Prediction: Difficulty=0 (Trivial joke)
  • You cannot configure how often to check WAN connections

On the other hand: when you do balanced routing indeed bundles all the WAN connections, configured Virtual Servers do work well and WAN specific routing settings to what they need to.

Source: Gigabit Load Balance Broadband Router TL-ER5120 – Welcome to TP-LINK

Verdict: fine for home use, not good for real multi-WAN use.

–jeroen

Read the rest of this entry »

Posted in Internet, Power User, routers | 1 Comment »

English…

Posted by jpluimers on 2016/03/18

After getting the pronunciation of bear wrong for the umpteenth time and searched for bear beer tear pear peer and more, I came across the below poem often wrongly attributed to George Bernard Shaw but in fact written by a Dutch guy: Gerard Nolst Trenité and called The Chaos.

Some videos: Bernard Shaw Poem English Pronunciation.

Here is the poem in full:

Read the rest of this entry »

Posted in Fun, Quotes | Leave a Comment »

The Default magic function in Delphi

Posted by jpluimers on 2016/03/17

Stefan Glienke worded it perfectly: Default(typeIdentifier) is a “magic” function that is implemented into the compiler and causes it to generate the correct code – like for records with managed fields it generates a call to FinalizeRecord and some instructions to zero the remaining fields.

Source: I know I can write MyRecordVar := Default(TMyRecordType) because I asked a qu…

–jeroen

Posted in Delphi, Delphi 10 Seattle, Delphi XE, Delphi XE2, Delphi XE3, Delphi XE4, Delphi XE5, Delphi XE6, Delphi XE7, Delphi XE8, Development, 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 »