Hello Kirill guess what? I changed my code to use a connection pool, but it was still failing. So, i started to think the problem was the jdbc driver (postgresql-8.4-701.jdbc3.jar).I was testing PostgreSQL in windows XP sp3. I changed to windows 2k3 and everything's working fine now! It seems it was an issue with Windows XP
I tested it with and without the connection pool. Both ways worked, but i left the connection pool. Thanks everyone for your suggestions! Best regards Fernando On Thu, Nov 12, 2009 at 9:49 AM, Fernando Tong <[email protected]> wrote: > Hello Kirill, > > thanks for your suggestions. I'll try to change my application (j2se) to > make it work with a connection pool. > > Best regards > > Fernando > > On Thu, Nov 12, 2009 at 3:01 AM, Kirill Zinov <[email protected]>wrote: > >> 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 >> >> >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
