I created a Java Service in webMethod’s Integration Server that should log something to the server.log file. As it turns out, this is quite simple: Generate Java code for calling the internal Service pub.flow.debugLog by right-clicking on the Service in Software AG Designer and selecting “Generate Code…”, “For calling this service from another service”. The [...]
System error 5 when accessing a network share on Windows 2008 using a DNS alias name
When I tried to access a network share on a Windows 2008 server locally (!) today using a DNS alias I configured, I got System error 5 has occurred. Access is denied (Systemfehler 5 aufgetreten. Zugriff verweigert in German): As you see in the screenshot, the shares are enumerated correctly when using the server’s computer [...]
Setting up the JDBC adapter in webMethods’ Integration Server to connect to an Oracle database
Today, I wanted to use the JDBC adapter in webMethod’s Integration Server to connect to a database from a Java service. As it turns out, the configuration was quite frustrating for me. Here’s a history of the problems that appeared while trying to get a database connection running: Error encountered [ART.118.5042] Adapter Runtime (Connection): Unable [...]
Oracle: SELECT top N rows skipping the first X rows
Apparently, it is not possible to use Oracle’s pseudo column rownum to select rows after a given number of rows, e.g. like SELECT * FROM tab WHERE rownum > 100; or in MySQL SELECT * FROM tab LIMIT 100,50; Oracle’s explanation for this (from the DB reference: ROWNUM): The first row fetched is assigned a [...]
Git ignores .gitignore when working with PowerShell
Today, a Git problem drove me nuts: I added files to the .gitignore file to make sure Git does not track and commit them to the repository. However, Git stubbornly ignored the file and kept adding all the files in my directory to the index. As it turned out, PowerShell was the problem. I added [...]
PowerShell: Check whether a Windows command or executable is available
In one of my recent PowerShell scripts I needed to find out if certain commands (in my case “svn”, “git”, “ant” and “mvn”) were available or not. I wrote this small function that tries to call the given command and returns whether it is callable. function commandAvailable($cmd, $options) { $error.clear(); $ErrorActionPreference = "silentlycontinue"; [...]
VBoxManage: error: VT-x features locked or unavailable in MSR. (VERR_VMX_MSR_LOCKED_OR_DISABLED)
Today I wanted to add a new 64bit virtual machine to my VirtualBox installation but when I tried to power it on I got the following error message: root@debian /home/vms/Webserver # VBoxManage startvm Webserver –type headless Waiting for VM “Webserver” to power on… VBoxManage: error: VT-x features locked or unavailable in MSR. (VERR_VMX_MSR_LOCKED_OR_DISABLED) VBoxManage: error: [...]
Connecting to an Oracle database via ODBC using only the InstantClient
Until today, I thought to be able to connect to an Oracle database from your Windows machine, you need to install the complete Oracle client including the Enterprise Manager etc. (>1GB). However, today I finally found a way to use Oracle via ODBC using only the InstantClient (ca. 50MB) on the Oracle website: First of [...]
PowerShell: How to read contents from text files without converting the lines into an array
Apparently, PowerShell’s get-content cmdlet automatically converts the contents of text files into an array of strings, splitting the contents at the line breaks (see Using the Get-Content Cmdlet). In many cases this is convenient: Contents of file test.txt: 1 2 3 gc text.txt | % { write-host “line: ” $_ } line: 1 line: 2 [...]
Single Sign On with Kerberos using Debian and Windows Server 2008 R2
Recently, I wanted to add single sign on (SSO) functionality to our intranet server, which runs a Debian Linux. Users should be automatically logged in to the website using their Windows user accounts, which are stored in an Active Directory on a Windows Server 2008 R2, without entering their credentials again. To make this work [...]
