[postgis-users] Postgis concurrence question

[Kirill Zinov]

Hello Fernando,

Looks like something has not been released after you closed connection. 
This may happen due to java native. I mean garbage collector approach to 
free the objects. If you'll use a proper connection pool it will take 
care of the connections re-usage and will speed up your application.

When I began my Java coding I tried a low level approach too. Thanks to 
my friend with strong skills in j2ee, I have realized the benefits from 
Hibernate and other frameworks faster.

Take a look at Hibernate: https://www.hibernate.org/

There is a spatial extension: http://www.hibernatespatial.org/

I didn't try spatial extension as I wrote before. Even if you will 
decide not to use Hibernate, I suggest you read a few good articles 
about connection pooling. It's a faster way to post/get data because of 
the connections re-usage. Actually this is a de facto standard in Java 
world.

Kirill,

Fernando Tong wrote:
> Hello Kiril,
>
> I'm afraid i'm not using a connection pooling, just an static way to 
> load the drivers
>
> public class PgSQLDBConn {
>
> static {
> try {
> Class.forName("org.postgresql.Driver");
>
> } catch (Exception e) {
> System.out.println(e.getMessage());
> }
> }
>
>
> public Connection getConnection() {
> Connection connection = null;
> try {
> connection = 
> DriverManager.getConnection("jdbc:postgresql://localhost:5432/db_gpstracker","MYUSER","MYPWD");
> } catch (Exception e) {
> System.out.println(e.getMessage());
> }
> return connection;
> }
> }
>
> I call the method getConnection each time i want to connect to the 
> database, execute the statements and then i close the connection 
> (repeat each time i receive some data from the GPS device)
>
> Best regards
>
> Fernando
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091112/e9117e4e/attachment.html>