Does anyone know how to commit and close the connection to the postgres db
after I post to it?
--
View this message in context: http://www.nabble.com/close-connection-tp14807022p14807022.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Hi Dominique,
Do you mean after posting a wfs transaction request? If so then the
database connection should be committed after the request, if it is
successul of course. If an error occurs any changes are rolled back.
With GS 1.6.x database connections are pooled, which means connections
are not really closed but thrown back into the pool.
Can you tell us a bit more about how your making the request and why you
need to ensure the connection is closed afterwards?
-Justin
dbhalsema wrote:
Does anyone know how to commit and close the connection to the postgres db
after I post to it?
--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org
I asked someone about deadlocks and he said “Deadlock on the DB happens when a process performs and update and doe not commit. Make sure your statements are committing and closing the connections.” so I was just wondering if the fact that i’m not committing and closing the connection is the issue.
On 1/14/08, Justin Deoliveira <jdeolive@anonymised.com> wrote:
Hi Dominique,
Do you mean after posting a wfs transaction request? If so then the
database connection should be committed after the request, if it is
successul of course. If an error occurs any changes are rolled back.With GS 1.6.x database connections are pooled, which means connections
are not really closed but thrown back into the pool.Can you tell us a bit more about how your making the request and why you
need to ensure the connection is closed afterwards?-Justin
dbhalsema wrote:
Does anyone know how to commit and close the connection to the postgres db
after I post to it?–
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org
I see. This relates to your deadlock issue with weblogic. Here is an
idea. Would it possible to export some of your data from postgres into a
shapefile. Then set up geoserver to serve the data from the shapefile
and see if the problem persists.
Dominique Bessette - Halsema wrote:
I asked someone about deadlocks and he said "Deadlock on the DB happens
when a process performs and update and doe not commit. Make sure your
statements are committing and closing the connections." so I was just
wondering if the fact that i'm not committing and closing the connection
is the issue.On 1/14/08, *Justin Deoliveira* <jdeolive@anonymised.com
<mailto:jdeolive@anonymised.com>> wrote:Hi Dominique,
Do you mean after posting a wfs transaction request? If so then the
database connection should be committed after the request, if it is
successul of course. If an error occurs any changes are rolled back.With GS 1.6.x database connections are pooled, which means connections
are not really closed but thrown back into the pool.Can you tell us a bit more about how your making the request and why
you
need to ensure the connection is closed afterwards?-Justin
dbhalsema wrote:
> Does anyone know how to commit and close the connection to the
postgres db
> after I post to it?--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org!DSPAM:4007,478ba126117901439371379!
------------------------------------------------------------------------
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace!DSPAM:4007,478ba126117901439371379!
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:4007,478ba126117901439371379!
--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org
I dont really understand what you’re asking me to do, because I have to insert tracks into the database.
On 1/14/08, Justin Deoliveira <jdeolive@anonymised.com> wrote:
I see. This relates to your deadlock issue with weblogic. Here is an
idea. Would it possible to export some of your data from postgres into a
shapefile. Then set up geoserver to serve the data from the shapefile
and see if the problem persists.Dominique Bessette - Halsema wrote:
I asked someone about deadlocks and he said “Deadlock on the DB happens
when a process performs and update and doe not commit. Make sure your
statements are committing and closing the connections.” so I was just
wondering if the fact that i’m not committing and closing the connection
is the issue.On 1/14/08, Justin Deoliveira <jdeolive@anonymised.com
<mailto:jdeolive@anonymised.com >> wrote:Hi Dominique,
Do you mean after posting a wfs transaction request? If so then the
database connection should be committed after the request, if it is
successul of course. If an error occurs any changes are rolled back.With GS 1.6.x database connections are pooled, which means connections
are not really closed but thrown back into the pool.Can you tell us a bit more about how your making the request and why
you
need to ensure the connection is closed afterwards?-Justin
dbhalsema wrote:
Does anyone know how to commit and close the connection to the
postgres db
after I post to it?–
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org!DSPAM:4007,478ba126117901439371379!
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace!DSPAM:4007,478ba126117901439371379!
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:4007,478ba126117901439371379!
–
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org
How are you doing these inserts. Are you going through the wfs
interface... or are you going straight into the back end via some other
script?
Dominique Bessette - Halsema wrote:
I dont really understand what you're asking me to do, because I have to
insert tracks into the database.On 1/14/08, *Justin Deoliveira* <jdeolive@anonymised.com
<mailto:jdeolive@anonymised.com>> wrote:I see. This relates to your deadlock issue with weblogic. Here is an
idea. Would it possible to export some of your data from postgres
into a
shapefile. Then set up geoserver to serve the data from the shapefile
and see if the problem persists.Dominique Bessette - Halsema wrote:
> I asked someone about deadlocks and he said "Deadlock on the DB
happens
> when a process performs and update and doe not commit. Make sure your
> statements are committing and closing the connections." so I was just
> wondering if the fact that i'm not committing and closing the
connection
> is the issue.
>
> On 1/14/08, *Justin Deoliveira* <jdeolive@anonymised.com
<mailto:jdeolive@anonymised.com>
> <mailto:jdeolive@anonymised.com>>
wrote:
>
> Hi Dominique,
>
> Do you mean after posting a wfs transaction request? If so
then the
> database connection should be committed after the request, if
it is
> successul of course. If an error occurs any changes are rolled
back.
>
> With GS 1.6.x database connections are pooled, which means
connections
> are not really closed but thrown back into the pool.
>
> Can you tell us a bit more about how your making the request
and why
> you
> need to ensure the connection is closed afterwards?
>
> -Justin
>
> dbhalsema wrote:
> > Does anyone know how to commit and close the connection to the
> postgres db
> > after I post to it?
>
>
> --
> Justin Deoliveira
> The Open Planning Project
> http://topp.openplans.org
>
>
>
>
>
>
------------------------------------------------------------------------>
>
-------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
>
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
>
> !DSPAM:4007,478ba126117901439371379!
>
>
>
------------------------------------------------------------------------
>
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
> !DSPAM:4007,478ba126117901439371379!--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org!DSPAM:4007,478ba3d2125012090977483!
------------------------------------------------------------------------
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace!DSPAM:4007,478ba3d2125012090977483!
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:4007,478ba3d2125012090977483!
--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org
i’m posting to the wfs from aqualogic’s esb. so not through an interface.
On 1/14/08, Justin Deoliveira <jdeolive@anonymised.com> wrote:
How are you doing these inserts. Are you going through the wfs
interface… or are you going straight into the back end via some other
script?Dominique Bessette - Halsema wrote:
I dont really understand what you’re asking me to do, because I have to
insert tracks into the database.On 1/14/08, Justin Deoliveira < jdeolive@anonymised.com
mailto:[jdeolive@anonymised.com](mailto:jdeolive@anonymised.com)> wrote:I see. This relates to your deadlock issue with weblogic. Here is an
idea. Would it possible to export some of your data from postgres
into a
shapefile. Then set up geoserver to serve the data from the shapefile
and see if the problem persists.Dominique Bessette - Halsema wrote:
I asked someone about deadlocks and he said “Deadlock on the DB
happens
when a process performs and update and doe not commit. Make sure your
statements are committing and closing the connections.” so I was just
wondering if the fact that i’m not committing and closing the
connection
is the issue.On 1/14/08, Justin Deoliveira <jdeolive@anonymised.com
<mailto:jdeolive@anonymised.com >
<mailto:jdeolive@anonymised.com mailto:[jdeolive@anonymised.com](mailto:jdeolive@anonymised.com)>>
wrote:Hi Dominique,
Do you mean after posting a wfs transaction request? If so
then the
database connection should be committed after the request, if
it is
successul of course. If an error occurs any changes are rolled
back.With GS 1.6.x database connections are pooled, which means
connections
are not really closed but thrown back into the pool.Can you tell us a bit more about how your making the request
and why
you
need to ensure the connection is closed afterwards?-Justin
dbhalsema wrote:
Does anyone know how to commit and close the connection to the
postgres db
after I post to it?–
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services for
just about anything Open Source.http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
!DSPAM:4007,478ba126117901439371379!
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
mailto:[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@lists.sourceforge.net)
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:4007,478ba126117901439371379!
–
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org!DSPAM:4007,478ba3d2125012090977483!
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace!DSPAM:4007,478ba3d2125012090977483!
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:4007,478ba3d2125012090977483!
–
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org
OK... so I assume this means that the ESB is the one who is managing the
connections to the database? I wonder... could the problem be that
GeoServer is using its own connection pool when it should be using one
provided by the app server?
Andrea is our database connection pooling wizard. he may know off hand.
I would to do a bit of searching to find out more info.
Dominique Bessette - Halsema wrote:
i'm posting to the wfs from aqualogic's esb. so not through an interface.
On 1/14/08, *Justin Deoliveira* <jdeolive@anonymised.com
<mailto:jdeolive@anonymised.com>> wrote:How are you doing these inserts. Are you going through the wfs
interface... or are you going straight into the back end via some other
script?Dominique Bessette - Halsema wrote:
> I dont really understand what you're asking me to do, because I
have to
> insert tracks into the database.
>
> On 1/14/08, *Justin Deoliveira* < jdeolive@anonymised.com
<mailto:jdeolive@anonymised.com>
> <mailto:jdeolive@anonymised.com>>
wrote:
>
> I see. This relates to your deadlock issue with weblogic. Here
is an
> idea. Would it possible to export some of your data from postgres
> into a
> shapefile. Then set up geoserver to serve the data from the
shapefile
> and see if the problem persists.
>
>
> Dominique Bessette - Halsema wrote:
> > I asked someone about deadlocks and he said "Deadlock on the DB
> happens
> > when a process performs and update and doe not commit. Make
sure your
> > statements are committing and closing the connections." so
I was just
> > wondering if the fact that i'm not committing and closing the
> connection
> > is the issue.
> >
> > On 1/14/08, *Justin Deoliveira* <jdeolive@anonymised.com
<mailto:jdeolive@anonymised.com>
> <mailto:jdeolive@anonymised.com>
> > <mailto:jdeolive@anonymised.com
<mailto:jdeolive@anonymised.com> <mailto:jdeolive@anonymised.com
<mailto:jdeolive@anonymised.com>>>>
> wrote:
> >
> > Hi Dominique,
> >
> > Do you mean after posting a wfs transaction request? If so
> then the
> > database connection should be committed after the
request, if
> it is
> > successul of course. If an error occurs any changes are
rolled
> back.
> >
> > With GS 1.6.x database connections are pooled, which means
> connections
> > are not really closed but thrown back into the pool.
> >
> > Can you tell us a bit more about how your making the request
> and why
> > you
> > need to ensure the connection is closed afterwards?
> >
> > -Justin
> >
> > dbhalsema wrote:
> > > Does anyone know how to commit and close the
connection to the
> > postgres db
> > > after I post to it?
> >
> >
> > --
> > Justin Deoliveira
> > The Open Planning Project
> > http://topp.openplans.org
> >
> >
> >
> >
> >
> >
>
------------------------------------------------------------------------>
> >
> >
>
-------------------------------------------------------------------------
> > Check out the new SourceForge.net Marketplace.
> > It's the best place to buy or sell services for
> > just about anything Open Source.
> >
>
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
<http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace>
> >
> >
> >
> >
> >
>
------------------------------------------------------------------------
> >
> > _______________________________________________
> > Geoserver-users mailing list
> > Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
> <mailto:Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>>
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
<https://lists.sourceforge.net/lists/listinfo/geoserver-users>
> >
> >
> > !DSPAM:4007,478ba126117901439371379!
>
>
> --
> Justin Deoliveira
> The Open Planning Project
> http://topp.openplans.org
>
>
> !DSPAM:4007,478ba3d2125012090977483!
>
>
>
------------------------------------------------------------------------
>
>
-------------------------------------------------------------------------> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
>
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
>
> !DSPAM:4007,478ba3d2125012090977483!
>
>
>
------------------------------------------------------------------------>
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
> !DSPAM:4007,478ba3d2125012090977483!--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org!DSPAM:4007,478ba94c133791637810514!
--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org
sooooo, i was researching Aqualogic and
"The POST method passes all its data, of unlimited length, directly over the socket connection as part of its HTTP request body. The exchange is invisible to the client, and the URL doesn’t change at all. "
so when i post from geoserver to postgres, aqualogic uses it’s own socket connection, and i’m assuming geoserver does too. so I dont really know what to do, can i turn geoserver’s off? i dont even know if that makes sense.
On 1/14/08, Justin Deoliveira <jdeolive@anonymised.com> wrote:
OK… so I assume this means that the ESB is the one who is managing the
connections to the database? I wonder… could the problem be that
GeoServer is using its own connection pool when it should be using one
provided by the app server?Andrea is our database connection pooling wizard. he may know off hand.
I would to do a bit of searching to find out more info.Dominique Bessette - Halsema wrote:
i’m posting to the wfs from aqualogic’s esb. so not through an interface.
On 1/14/08, Justin Deoliveira < jdeolive@anonymised.com
mailto:[jdeolive@anonymised.com](mailto:jdeolive@anonymised.com)> wrote:How are you doing these inserts. Are you going through the wfs
interface… or are you going straight into the back end via some other
script?Dominique Bessette - Halsema wrote:
I dont really understand what you’re asking me to do, because I
have to
insert tracks into the database.On 1/14/08, Justin Deoliveira < jdeolive@anonymised.com
<mailto:jdeolive@anonymised.com >
<mailto:jdeolive@anonymised.com mailto:[jdeolive@anonymised.com](mailto:jdeolive@anonymised.com)>>
wrote:I see. This relates to your deadlock issue with weblogic. Here
is an
idea. Would it possible to export some of your data from postgres
into a
shapefile. Then set up geoserver to serve the data from the
shapefile
and see if the problem persists.Dominique Bessette - Halsema wrote:
I asked someone about deadlocks and he said “Deadlock on the DB
happens
when a process performs and update and doe not commit. Make
sure your
statements are committing and closing the connections.” so
I was just
wondering if the fact that i’m not committing and closing the
connection
is the issue.On 1/14/08, Justin Deoliveira <jdeolive@anonymised.com
<mailto: jdeolive@anonymised.com>
<mailto:jdeolive@anonymised.com mailto:[jdeolive@anonymised.com](mailto:jdeolive@anonymised.com)>
<mailto: jdeolive@anonymised.com
mailto:[jdeolive@anonymised.com](mailto:jdeolive@anonymised.com) <mailto:jdeolive@anonymised.com
mailto:[jdeolive@anonymised.com](mailto:jdeolive@anonymised.com)>>>
wrote:Hi Dominique,
Do you mean after posting a wfs transaction request? If so
then the
database connection should be committed after the
request, if
it is
successul of course. If an error occurs any changes are
rolled
back.With GS 1.6.x database connections are pooled, which means
connections
are not really closed but thrown back into the pool.Can you tell us a bit more about how your making the request
and why
you
need to ensure the connection is closed afterwards?-Justin
dbhalsema wrote:
Does anyone know how to commit and close the
connection to the
postgres db
after I post to it?–
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services for
just about anything Open Source.http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
< http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace>
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net >
<mailto:Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net >>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
< https://lists.sourceforge.net/lists/listinfo/geoserver-users>!DSPAM:4007,478ba126117901439371379!
–
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org!DSPAM:4007,478ba3d2125012090977483!
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services for
just about anything Open Source.http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
!DSPAM:4007,478ba3d2125012090977483!
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
mailto:[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@lists.sourceforge.net)
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:4007,478ba3d2125012090977483!
–
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org!DSPAM:4007,478ba94c133791637810514!
–
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org