Error streaming response: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Could not open connection

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Error streaming response: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Could not open connection

alexei8a
Hi
I built the SOS WebApp as you said on the documentation. I can do the requests and I have an answer on the webpage on Tomcat, bu when I click Send or do a HTTP GET, I have this problem:

Error streaming response: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Could not open connection

How can I fix it?

Thank you so much
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Error streaming response: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Could not open connection

Eike Hinderk Jürrens
Hi Alexei!

On 22.03.2017 03:40, alexei8a wrote:

> Hi
> I built the SOS WebApp as you said on the documentation. I can do the
> requests and I have an answer on the webpage on Tomcat, bu when I click Send
> or do a HTTP GET, I have this problem:
>
> Error streaming response: Could not open Hibernate Session for transaction;
> nested exception is org.hibernate.exception.JDBCConnectionException: Could
> not open connection
>
> How can I fix it?

You could provide a lot more details, because this error could have
several causes, like:

- database server down
- database credentials wrong

First, we need to know your used versions of: java, tomcat, 52nSOS. In
addtion, the details might be hidden in the log files. Please increase
the log level (admin -> settings -> logging) to debug for org.n52. Then
rerun your requests and provide the log files to the list using any
pastebin service.

By the way, what did the web say to your error message?

Kind regards,
Eike

--

Eike Hinderk Jürrens
52°North Initiative for Geospatial Open Source Software GmbH
Martin-Luther-King-Weg 24
48155 Münster, Germany
E-Mail: [hidden email]
Fon: +49-(0)-251–396371-33
Fax: +49-(0)-251–396371-11
http://52north.org/
Twitter: @FiveTwoN
General Managers: Dr. Albert Remke, Dr. Andreas Wytzisk
Local Court Muenster HRB 10849

_______________________________________________
SWE mailing list
[hidden email]
http://list.52north.org/mailman/listinfo/swe
http://sensorweb.forum.52north.org
Please respect our mailing list guidelines:
http://52north.org/resources/mailing-lists-and-forums/guidelines
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Error streaming response: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Could not open connection

alexei8a
Hi Eike
Answering your questions:
I have  Eclipse Mars with Java SE 1.8.0_121, Tomcat 7 , I've downloaded SOS from Github
I'm using ubuntu 14.04 as the OS
Where can I change the log level and where can i find the log files to send you them?
Thank you for your answer

Alexei

2017-03-29 2:07 GMT-05:00 Eike Hinderk Jürrens <[hidden email]>:
Hi Alexei!

On 22.03.2017 03:40, alexei8a wrote:
> Hi
> I built the SOS WebApp as you said on the documentation. I can do the
> requests and I have an answer on the webpage on Tomcat, bu when I click Send
> or do a HTTP GET, I have this problem:
>
> Error streaming response: Could not open Hibernate Session for transaction;
> nested exception is org.hibernate.exception.JDBCConnectionException: Could
> not open connection
>
> How can I fix it?

You could provide a lot more details, because this error could have
several causes, like:

- database server down
- database credentials wrong

First, we need to know your used versions of: java, tomcat, 52nSOS. In
addtion, the details might be hidden in the log files. Please increase
the log level (admin -> settings -> logging) to debug for org.n52. Then
rerun your requests and provide the log files to the list using any
pastebin service.

By the way, what did the web say to your error message?

Kind regards,
Eike

--

Eike Hinderk Jürrens
52°North Initiative for Geospatial Open Source Software GmbH
Martin-Luther-King-Weg 24
48155 Münster, Germany
E-Mail: [hidden email]
Fon: +49-(0)-251–396371-33
Fax: +49-(0)-251–396371-11
http://52north.org/
Twitter: @FiveTwoN
General Managers: Dr. Albert Remke, Dr. Andreas Wytzisk
Local Court Muenster HRB 10849

_______________________________________________
SWE mailing list
[hidden email]
http://list.52north.org/mailman/listinfo/swe
http://sensorweb.forum.52north.org
Please respect our mailing list guidelines:
http://52north.org/resources/mailing-lists-and-forums/guidelines


_______________________________________________
SWE mailing list
[hidden email]
http://list.52north.org/mailman/listinfo/swe
http://sensorweb.forum.52north.org
Please respect our mailing list guidelines:
http://52north.org/resources/mailing-lists-and-forums/guidelines
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Error streaming response: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Could not open connection

Carsten Hollmann
Hi Alexei,

thanks for the information.

You can change the log level via the SOS Admin interface:

    Admin -> Settings -> Logging

The log files are stored in the Tomcat logs folder and the log file has
the same name as the SOS webapp (e.g. 52n-sos-webapp).

Best,
Carsten
_______________________________________________
SWE mailing list
[hidden email]
http://list.52north.org/mailman/listinfo/swe
http://sensorweb.forum.52north.org
Please respect our mailing list guidelines:
http://52north.org/resources/mailing-lists-and-forums/guidelines
Loading...