Quick Fix for GlassFish/MySQL NoPasswordCredential Found

Posted by MarkH on Oracle Blogs See other posts from Oracle Blogs or by MarkH
Published on Tue, 5 Jun 2012 17:44:25 +0000 Indexed on 2012/06/05 22:44 UTC
Read the original article Hit count: 181

Filed under:

/Blog Spotlight

Just the other day, I stood up a GlassFish 3.1.2 server in preparation for a new web app we've developed. Since we're using MySQL as the back-end database, I configured it for MySQL (driver) and created the requisite JDBC resource and supporting connection pool. Pinging the finished pool returned a success, and all was well.

Until we fired up the app, that is -- in this case, after a weekend. Funny how things seem to break when you leave them alone for a couple of days. :-) Strangely, the error indicated "No PasswordCredential found". Time to re-check that pool.

All the usual properties and values were there (URL, driverClass, serverName, databaseName, portNumber, user, password) and were populated correctly. Yes, the password field, too. And it had pinged successfully. So why the problem?

A bit of searching online produced enough relevant material to offer promise. I didn't take notes as I was investigating the cause (note to self), but here were the general steps I took to resolve the issue:

First, per some guidance I had found, I tried resetting the password value to nothing (using () for a value). Of course, this didn't fix anything; the database account requires a password. And when I tried to put the value back, GlassFish politely refused. Hmm.

I'd seen that some folks created a new pool to replace the "broken" one, and while that did work for them, it seemed to simply side-step the issue. So I deleted the password property - which GlassFish allowed me to do - and restarted the domain. Once I was back in, I re-added the password property and its value, saved it, and pinged...success! But now to the app for the litmus test.

The web app worked, and everything and everyone was now happy. Not bad for a Monday. :-D

Hope this helps,
Mark

Related posts about /Blog Spotlight

RSS Feeds currently on Simple-Talk

as seen on Simple Talk - Search for 'Simple Talk'
There are a number of news-feeds for the Simple-Talk site, but for some reason they are well hidden. Whilst we set about reorganizing them, I thought it would be a good idea to list some of the more important ones. The most important one for almost all purposes is the Homepage RSS feed which represents… >>> More
Maintaining shared service in ASP.NET MVC Application

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Depending on the application sometimes we have to maintain some shared service throughout our application. Let’s say you are developing a multi-blog supported blog engine where both the controller and view must know the currently visiting blog, it’s setting , user information and url generation service… >>> More
Blog Posts - Smart Tips on How to Optimize Your Blog Posts For Google

as seen on Ezine Articles - Search for 'Ezine Articles'
There are so many informative blogs in the online arena today. Sadly, not all of them are getting the kind of attention they deserve. One of the reasons is because their content is not properly optimized. SEO blog writing doesn't need to be a complicated task. Here's an easy... >>> More
Why is django giving me an attribute error when I call _set.all() for its children models?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two models defined from django.db import models class Blog(models.Model): title = models.CharField(max_length=144) @property def posts(self): self.Post_set.all() class Post(models.Model): title = models.CharField(max_length=144) text = models.TextField() … >>> More
Blog - BlogPost - BlogPostComment vs Blog - Post - Comment

as seen on Stack Overflow - Search for 'Stack Overflow'
Don't really know how to formulate the title, but it should be pretty obvious from the example. More specifically, what rules do you use for naming "dependent" classes. For example, Blog is a pretty descriptive name itself, but how do I deal with posts? BlogPost or Post? Clearly, first name clearly… >>> More

Developer IT