donderdag 14 maart 2013
C# oracle connection pool problems
The Oracle C# driver is not smart enough to check whether a connection is still active in the connection pool. This makes it possible for the C# code to get an disconnected connection when you open een new connection to Oracle.
One possible solution given on the Internet is using the "Validate Connection=true;" in your connection string. However, that does not solve your problem at all.
The only way to solve the problem is to add this string to your connection string:
"Min Pool Size=0;Connection Lifetime=120;Connection Timeout=60;Incr Pool Size=5;Decr Pool Size=3;"
This means: The minimum Pool size is 0, and eventually the Pool size will become 0 when no activity is going on for some time. Works great.
Oracle 10g client datetime errors
In my case the language was incorrectly defined. I had the american NLS_LANG in my registry.
The correct NLS_LANG for me was:
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1]
"NLS_LANG"="DUTCH_THE NETHERLANDS.WE8MSWIN1252"
The correct NLS_LANG for me was:
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1]
"NLS_LANG"="DUTCH_THE NETHERLANDS.WE8MSWIN1252"
zaterdag 2 maart 2013
Shared folders on VirtualBox
A coworker of mine said that VirtualBox shared folders are a lot faster than using a host-only network on VirtualBox. And it is much easier to setup.
Abonneren op:
Posts (Atom)