Ehlo

How to use regular expressions in a DB2 select query?
The simple answer is you can't. But if you are very insistent you can acheive that.
A lot of RDBSes have built in support for regular expressions, why doesn't DB2 has one? I have no idea.

In MySQL you do REGEXP, NOT REGEXP or RLIKE. here is another link.

In Microsoft SQL Server 2000 you call xp_pcre. In Microsoft SQL Server 2005 you call integrated .NET Regex classes from .

In PostgreSQL you call the regexp functions, here is another link.

For Oracle here we have a bunch of resources: First, second and also on regular-expressions.info

If you'll do a search on DB2 regexp you will stumbled upon this IBM article:
http://www.ibm.com/developerworks/data/library/techarticle/0301stolze/0301stolze.html
Which I found very interesting.

I was reading today about a nice library for java for monitoring performance, looks really neat.
Check it out at: http://perf4j.codehaus.org/

Documentation: http://perf4j.codehaus.org/devguide.html

Today I was fighting with a problem at work.
If I tried and set the password in ADAM in C# it gave the next error:

Message: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException (0x80005008): Exception from HRESULT: 0x80005008.

As described in this page:
http://social.technet.microsoft.com/forums/en-US/exchangesvrdevelopment/thread/bb518eb3-02cb-4b3c-9a18-4ce85f245131/

They say there is a fix for that from Microsoft. I didn't try that but I found another solution to my problem.
So, I was:
1. Going against ADAM
2. Through SSL
3. .NET 1.1

The code I had was exactly from the page above:

de.Invoke("SetOption", new object[] {(int)ADS_OPTION_PASSWORD_PORTNUMBER, (object)_portNo });
de.Invoke("SetOption", new object[] { (int)ADS_OPTION_PASSWORD_METHOD, (object)ADS_PASSWORD_ENCODE_CLEAR});
de.Invoke("SetPassword", new object[] {newPassword});

What is sneacky here is the ADS_PASSWORD_ENCODE_CLEAR constant, btw the constants are declared like:

const long ADS_OPTION_PASSWORD_PORTNUMBER = 6;
const long ADS_OPTION_PASSWORD_METHOD = 7;

const int ADS_PASSWORD_ENCODE_REQUIRE_SSL = 0;
const int ADS_PASSWORD_ENCODE_CLEAR = 1;

As you can see the ADS_PASSWORD_ENCODE_REQUIRE_SSL is not used in my case.
So, what I had to change is from this:

de.Invoke("SetOption", new object[] { (int)ADS_OPTION_PASSWORD_METHOD, (object)ADS_PASSWORD_ENCODE_CLEAR});

To this:

de.Invoke("SetOption", new object[] { (int)ADS_OPTION_PASSWORD_METHOD, (object)ADS_PASSWORD_ENCODE_REQUIRE_SSL});

And it worked.
Remeber this is changing the password in ADAM through SSL.
And by the way on your DirectoryEntry object set the AuthenticationType to AuthenticationTypes.SecuredSocketLayer

Related links:

1. http://msdn.microsoft.com/en-us/library/aa772136(VS.85).aspx

2. http://msdn.microsoft.com/en-us/library/system.directoryservices.authenticationtypes.aspx

3. http://social.technet.microsoft.com/forums/en-US/exchangesvrdevelopment/thread/bb518eb3-02cb-4b3c-9a18-4ce85f245131/

4. http://www.techreplies.com/windows-2003-77/setting-user-passwords-adam-vb-net-466581/

5. http://directoryprogramming.net/forums/9/ShowForum.aspx

The exception you might get is:

Caused by: org.dom4j.DocumentException: Error on line 55 of document : The element type "property" must be terminated by the matching end-tag "". Nested exception: The element type "property" must be terminated by the matching end-tag "".

This means one thing: YOUR HIBERNATE MAPPING FILES HAVE A WRONG SYNTAX. Recheck them!

Good luck!