Glassfish v3 connection pool problems
|
View:
New views
6 Messages
—
Rating Filter:
Alert me
|
 |
Glassfish v3 connection pool problems
by glassfish-2
::
Rate this Message:
Hi to all. Continuing my journy with Glassfish v3 I began to port a project from Glassfish v2.1 with eclipselink to Glassfish v3 b70 (latest) build. I use MySql database and I set all standart settings in the web admin console connection pool. I put the mysql jdbc driver in .../glassfish/domains/domain1/lib folder. When I try to [b] Ping [/b] i get the following exception:
[code] SEVERE: jdbc.exc_jb_val java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ... Caused by: java.lang.RuntimeException: The connection property 'largeRowSizeThreshold' only accepts integer values. The value '' can not be converted to an integer. at com.mysql.jdbc.ConnectionPropertiesImpl.setLargeRowSizeThreshold(ConnectionPropertiesImpl.java:4293) ... 75 more Caused by: java.sql.SQLException: The connection property 'largeRowSizeThreshold' only accepts integer values. The value '' can not be converted to an integer. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) ... [/code] So I change the property 'largeRowSizeThreshold' to 10 to be an int and different from empty string '' and saved. When i again clicked the [b] Ping [/b] button I get: [code] java.sql.SQLException: "Unable to create properties transform instance '' due to underlying exception: java.lang.ClassNotFoundException: " com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) com.mysql.jdbc.NonRegisteringDriver.parseURL(NonRegisteringDriver.java:663) com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:277) com.mysql.jdbc.jdbc2.op...[/code] When I stop and start the application server again I get the same error. It the server.log i have the following:[code]WARNING: Connection could not be allocated because: Unable to create properties transform instance '' due to underlying exception: java.lang.ClassNotFoundException: [/code] Any idea what could be wrong? [Message sent by forum member 'dpandulev' (deyan.pandulev@...)] http://forums.java.net/jive/thread.jspa?messageID=369830 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Glassfish v3 connection pool problems
by glassfish-2
::
Rate this Message:
This seems like an issue when there are some properties with "" as values for them. When i remove such properties and try to ping the connection pool, it succeeds.
There is an issue related to the removal of the properties with "" values when the pool is created. This would be done the admin GUI (same behavior as in V2). Please refer https://glassfish.dev.java.net/issues/show_bug.cgi?id=10780 . [Message sent by forum member 'sm157516' (shalini.muthukrishnan@...)] http://forums.java.net/jive/thread.jspa?messageID=370436 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Glassfish v3 connection pool problems
by Marina Vatkina
::
Rate this Message:
How about an empty password that was not possible to set via GUI in v2.x?
thanks, -marina glassfish@... wrote: > This seems like an issue when there are some properties with "" as values for them. When i remove such properties and try to ping the connection pool, it succeeds. > > There is an issue related to the removal of the properties with "" values when the pool is created. This would be done the admin GUI (same behavior as in V2). Please refer https://glassfish.dev.java.net/issues/show_bug.cgi?id=10780 . > [Message sent by forum member 'sm157516' (shalini.muthukrishnan@...)] > > http://forums.java.net/jive/thread.jspa?messageID=370436 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Glassfish v3 connection pool problems
by Anissa Lam
::
Rate this Message:
Hi Marina,
I agree with you, thats exactly why i need to change the behavior for v3. In v2, there is no way for user to specify a property with "" through GUI, for something like this: <property name="password" value="" /> Now, In v3, if user create a property with Name but didn't fill in the value in the value column, GUI will assume the user wants an empty value, and pass that to the backend. Resulting in <property name="property-with-empty-value" value="" /> It is now the user's responsibility to remove any property that they don't want instead of relying on GUI to filter that out. thanks Anissa Marina Vatkina wrote: > How about an empty password that was not possible to set via GUI in v2.x? > > thanks, > -marina > > glassfish@... wrote: >> This seems like an issue when there are some properties with "" as >> values for them. When i remove such properties and try to ping the >> connection pool, it succeeds. >> There is an issue related to the removal of the properties with "" >> values when the pool is created. This would be done the admin GUI >> (same behavior as in V2). Please refer >> https://glassfish.dev.java.net/issues/show_bug.cgi?id=10780 . >> [Message sent by forum member 'sm157516' >> (shalini.muthukrishnan@...)] >> >> http://forums.java.net/jive/thread.jspa?messageID=370436 >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscribe@... >> For additional commands, e-mail: users-help@... >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Glassfish v3 connection pool problems
by vince kraemer
::
Rate this Message:
when did http://blogs.sun.com/vkraemer/entry/no_passwordcredential_found
become obsolete in v2? vbk Anissa Lam wrote: > Hi Marina, > > I agree with you, thats exactly why i need to change the behavior for > v3. > In v2, there is no way for user to specify a property with "" through > GUI, for something like this: > <property name="password" value="" /> > > Now, In v3, if user create a property with Name but didn't fill in > the value in the value column, GUI will assume the user wants an > empty value, and pass that to the backend. Resulting in <property > name="property-with-empty-value" value="" /> > > It is now the user's responsibility to remove any property that they > don't want instead of relying on GUI to filter that out. > > thanks > Anissa > > Marina Vatkina wrote: >> How about an empty password that was not possible to set via GUI in >> v2.x? >> >> thanks, >> -marina >> >> glassfish@... wrote: >>> This seems like an issue when there are some properties with "" as >>> values for them. When i remove such properties and try to ping the >>> connection pool, it succeeds. >>> There is an issue related to the removal of the properties with "" >>> values when the pool is created. This would be done the admin GUI >>> (same behavior as in V2). Please refer >>> https://glassfish.dev.java.net/issues/show_bug.cgi?id=10780 . >>> [Message sent by forum member 'sm157516' >>> (shalini.muthukrishnan@...)] >>> >>> http://forums.java.net/jive/thread.jspa?messageID=370436 >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: users-unsubscribe@... >>> For additional commands, e-mail: users-help@... >>> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscribe@... >> For additional commands, e-mail: users-help@... >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Glassfish v3 connection pool problems
by Anissa Lam
::
Rate this Message:
Nothing change for v2. In your blog, you mentioned: 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. I have no idea if backend is still honoring this, GUI just pass in whatever user enters. I think GUI shouldn't rely on something like this which I doubt is documented anywhere and I consider that un-official. It needs to support an empty value password case for v3. Thus the changes. thanks Anissa. vince kraemer wrote: when did http://blogs.sun.com/vkraemer/entry/no_passwordcredential_found become obsolete in v2?--------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
| Free embeddable forum powered by Nabble | Forum Help |
