users@glassfish.java.net

Re: Can't connect to JavaDB database

From: Sathyan Catari <Sathyan.Catari_at_Sun.COM>
Date: Thu, 28 May 2009 09:46:58 -0700

You might also want to check the connection pool parameters to see if
the values are in sync with what's displayed
in NB(as a tool-tip on top of DB connection).

HTH
-Sathyan


Maori wrote:
> Hi, answer below.
>
>
> glassfish-2 wrote:
>
>> I just created a JavaDB in NetBeans 6Beta1 and tried to configure a JDBC
>> datasource in Glassfish v2. After I created the connection Pool, and tried
>> to ping it. I got an error message saying "Connection authentication
>> failure occurred. Reason: userid or password invalid." But I can login
>> into the database in NetBeans with the same username/password. I had this
>> problem in both windows and solaris 10 environment. Is this a bug?
>> [Message sent by forum member 'taoli66' (taoli66)]
>>
>>
>
> I have just now encountered the same problem and found this request for
> help. For future use:
> It is most probable you had the SecurityMechanism property of the Connection
> Pool set to 4 (this is the default when you create new Connection Pool in
> glassfish using derby). In your case it should be the value 3 (or you can as
> well delete the property value). For a reference on the meaning of those
> values visit http://wiki.apache.org/db-derby/SecurityMechanism.
>
>