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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
