No PasswordCredential found
By vbkraemer on Nov 04, 2008
I have seen a number of people run into problems with using databases that use an empty string as the value for a password. I have seen many of these reports coming from folks using MySQL. But I had never investigated the problem... until today.
I have been asked to prepare some training materials about the integration between NetBeans and GlassFish for folks that aren't in the thick of developing NetBeans or GlassFish. So, I decided to try out the NetBeans, MySQL, GlassFish bundle... and ran straight into the grief that others have been talking about.
I installed the bundle on my laptop and tried to retarget the JsfJpa sample to MySQL. When I tried to create the JDBC Connection Pool in the IDE, I hit the first problem. The wizard for creating the connection pool insisted that I must enter a value in the field.
I filed an issue against NetBeans so this can get fixed.
After I got the pool defined... incorrectly. I decided to try to correct it. So, I tried setting the value to an empty string via the CLI and the Admin GUI and was thwarted on all fronts.
I was lucky though. I have Kedar just down the hall... and he gave me the info that I needed.
And now, I am going to give that to you.
There is a special meta-string that can be used in property values to represent a zero length string.
This special string can be used in asadmin's set subcommand, in the Admin GUI's property table and in the IDE wizards.