Connection problems.

[Francisco Chiotta]

Hello everybody, 

                        I am beginner in activejdbc, and I am learning how to use this fantastic tool, I think it's very good.

I am facing a problem with connections. I am developing a swing application which retrieves information from a postgres database. Since swing application are multi-threads, I don't know how to manage it. Should I reopen a connection every time I make a DB operation? My app performs DB operations depending on events from the GUI, and I use SwingWorker(new thread) to do the work, so the connection(previously opened) is not active in this new thread.

Cheers.

[Igor Polevoy]

If I were to build an app like that, I would use an in-memory database connection pool. 

I would then:

1. Implement my simple DataSource and used this method: http://javalite.github.io/activejdbc/org/javalite/activejdbc/Base.html#open(javax.sql.DataSource) to open a connection from data source. 

The custom datasource would pull a connection from  the pool. 

2. I would write one  class for all database access, and hide model code inside methods of that class. Think of this as a data access facade

For instance: 

3. How to open connection: use Java Proxy feature to get a new implementation of the PeopleFacade class, but the one that can open a connection before method, and close one after the method: 

Here is code example that does not use models, or actually opens connection, but it gives you a clue for my suggestion:

https://gist.github.com/ipolevoy/8226928

Simply use code in DatabaseConnectionHandler  to open a connection before method execution and close after. The connection itself can be opened directly or sourced from a pool

hope this helps

tx

[Francisco Chiotta]

Igor, thank you very much for your help. It helped a lot.

Cheers.

[Igor Polevoy]

Glad this helps, good luck