Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[jetty-users] WebSocketHandler or WebSocketListener - where to open JDBC connection

Good evening,

I am working on a word game, moving it 
from AJAX/PHP to Websockets/Jetty. 
Most of code is in stored procedures for PostgreSQL anyway.

Being a Servlets and JDBC newbie I have a question please:

If you would have a custom WebSocketHandler like
https://github.com/afarber/jetty-newbie/blob/master/WebsocketHandler/src/main/java/de/afarber/MyHandler.java

And a custom WebSocketListener similar to
https://github.com/afarber/jetty-newbie/blob/master/WebsocketHandler/src/main/java/de/afarber/MyListener.java

where would you be opening JDBC connection?

I.e. where would you call code like

        Connection conn = DriverManager.getConnection("jdbc:postgresql://127.0.0.1/", props);

so that you could use it in onWebSocketConnect and onWebSocketText?

Maybe there is even some 3rd object in 
Jetty life cycle which would suit well?

Thank you
Alex

Back to the top