[h2] Re: Getting error after upgrading to H2 DB 1.4.200 from 1.4.199 and deploying on Tomcat 9.x

['Balamurali Krishna Ippili' via H2 Database]

Hello Team,

*Are there any pointers on how to resolve the issue?*

I am giving the problem description again here:


I have upgraded my h2DB jar from 1.4.199 to 1.4.200 and when deploying it
on Tomcat 9.0.44 it was giving the following error:

This is not the case with h2 DB version 1.4.199.

How can I solve this? Any pointers?

WARNING [main] 
*org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads
The web application [ca-nim-sm_h2DB] appears to have started a thread named
[H2 TCP Server (tcp://10.230.44.99:55171 )] but
has failed to stop it. This is very likely to create a memory leak. Stack
trace of thread:*
 java.net.DualStackPlainSocketImpl.accept0(Native Method)


Thanks,
Balamurali

On Fri, Mar 19, 2021 at 4:16 PM Balamurali Krishna Ippili <
balamurali.ipp...@broadcom.com> wrote:

> Hi Team,
>
> I have upgraded my h2DB jar from 1.4.199 to 1.4.200 and when deploying it
> on Tomcat 9.0.44 it was giving the following error:
>
> This is not the case with h2 DB version 1.4.199.
>
> How can I solve this? Any pointers?
>
> WARNING [main]
> org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The
> web application [ca-nim-sm_h2DB] appears to have started a thread named [H2
> TCP Server (tcp://10.230.44.99:55171)] but has failed to stop it. This is
> very likely to create a memory leak. Stack trace of thread:
>  java.net.DualStackPlainSocketImpl.accept0(Native Method)
>
>  
> java.net.DualStackPlainSocketImpl.socketAccept(DualStackPlainSocketImpl.java:131)
>  java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:409)
>  java.net.PlainSocketImpl.accept(PlainSocketImpl.java:199)
>  java.net.ServerSocket.implAccept(ServerSocket.java:560)
>  java.net.ServerSocket.accept(ServerSocket.java:528)
>  org.h2.server.TcpServer.listen(TcpServer.java:263)
>  org.h2.tools.Server.run(Server.java:610)
>  java.lang.Thread.run(Thread.java:748)
>
>
> Thanks,
> Balamurali
>
> This electronic communication and the information and any files
> transmitted with it, or attached to it, are confidential and are intended
> solely for the use of the individual or entity to whom it is addressed and
> may contain information that is confidential, legally privileged, protected
> by privacy laws, or otherwise restricted from disclosure to anyone else. If
> you are not the intended recipient or the person responsible for delivering
> the e-mail to the intended recipient, you are hereby notified that any use,
> copying, distributing, dissemination, forwarding, printing, or copying of
> this e-mail is strictly prohibited. If you received this e-mail in error,
> please return the e-mail to the sender, delete it from your computer, and
> destroy any printed copy of it.

-- 
This electronic communication and the information and any files transmitted 
with it, or attached to it, are confidential and are intended solely for 
the use of the individual or entity to whom it is addressed and may contain 
information that is confidential, legally privileged, protected by privacy 
laws, or otherwise restricted from disclosure to anyone else. If you are 
not the intended recipient or the person responsible for delivering the 
e-mail to the intended recipient, you are hereby notified that any use, 
copying, distributing, dissemination, forwarding, printing, or copying of 
this e-mail is strictly prohibited. If you received this e-mail in error, 
please return the e-mail to the sender, delete it from your computer, and 
destroy any printed copy of it.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/CAG6_yCCFv_D_wTx5VnUMCNF4zEdwbj6uSeAkX3gPXu%3DYqejetw%40mail.gmail.com.


smime.p7s
Description: S/MIME Cryptographic Signature

Re: [h2] Don't get AVG(DareDiff) field in java and H2

[Andreas Reichel]

Vitali,

while I am not a H2 developer, it appears from your e-mail that your
challenge is related to your persistence framework but not to the H2
database itself.
You wrote that you can run your query against the JDBC data source and
would get the correct result for AVG().

If the persistence frame work returns AVG() == NULL then I would double
check first for the actual selected rows before aggregation.
Aggregate functions will return NULL when no rows have been selected.

Also it might worth replacing H2 with another RDBMS (Derby,
Postgres) temporarily just for the sake of narrowing down the issue.

Right now I can only advise:

1) send your questions to the persistence framework as long as your
query works correctly (or unless you come up with a DDL and a query
which fails directly on H2)

2) send (short, simplified, reproducible) code examples instead of
screen shots, because nobody will be able to walk through the code
using screenshots only

Best regards
Andreas 

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/3831e0978e92cd00cc7df32151e58efec25253fc.camel%40manticore-projects.com.