Re: loading jdbc Driver in servlet

2018-12-16 Thread Thomas Kellerer
Rob Sargent schrieb am 14.12.2018 um 19:28: > Using java 1.8, postgresql-42.1.4.jar, embedded tomcat 9 > > It appears to me that I need to make the call > "Class.forName("org.postgresql.Driver)" when the entry is in a > servlet. Is this expected, within a servlet, or is this just /post > hoc

Re: loading jdbc Driver in servlet

2018-12-16 Thread Rob Sargent
> On Dec 16, 2018, at 5:55 PM, Martin Gainty wrote: > > 99% of the problems with 'isolated classloader' are solved using the class > e.g. > Granted. But this seems to fly in the face of both Postgres docs and modern JDKs.

Re: loading jdbc Driver in servlet

2018-12-16 Thread Rob Sargent
> On Dec 16, 2018, at 12:12 PM, Dave Cramer wrote: > > So you are starting up tomcat yourself ? Perhaps that is the difference ? > I have no idea what the tomcat wrapper does, but I'd be curious if the same > thing happens when stared normally > > Dave Cramer > Whatever the is the

Re: new stored procedure with OUT parameters

2018-12-16 Thread Adrian Klaver
On 12/16/18 11:33 AM, Anton Shen wrote: Thanks for the thoughts. The part I'm missing is that why procedures with OUT param 'will not be called from SQL environments'? Pretty sure Pavel was referring to: https://www.postgresql.org/docs/11/xfunc-sql.html#XFUNC-OUTPUT-PARAMETERS "Notice that

Re: new stored procedure with OUT parameters

2018-12-16 Thread Pavel Stehule
ne 16. 12. 2018 v 20:33 odesílatel Anton Shen <4175geo...@gmail.com> napsal: > Thanks for the thoughts. The part I'm missing is that why procedures with > OUT param 'will not be called from SQL environments'? > PostgreSQL, Oracle has function/procedure overloading. The function signature - that

Re: new stored procedure with OUT parameters

2018-12-16 Thread Anton Shen
Thanks for the thoughts. The part I'm missing is that why procedures with OUT param 'will not be called from SQL environments'? Thanks, Anton On Sat, Dec 15, 2018 at 10:03 AM Pavel Stehule wrote: > Hi > > út 11. 12. 2018 v 7:20 odesílatel Anton Shen <4175geo...@gmail.com> > napsal: > >> Hi

Re: loading jdbc Driver in servlet

2018-12-16 Thread Dave Cramer
So you are starting up tomcat yourself ? Perhaps that is the difference ? I have no idea what the tomcat wrapper does, but I'd be curious if the same thing happens when stared normally Dave Cramer da...@postgresintl.com www.postgresintl.com On Sun, 16 Dec 2018 at 12:20, Rob Sargent wrote: >

Re: loading jdbc Driver in servlet

2018-12-16 Thread Rob Sargent
Tomcat version 9. Embedded in my main() > On Dec 16, 2018, at 9:30 AM, Dave Cramer wrote: > > My guess is it has something to do with your servlet classpath loader. Which > servlet engine are you using ? > Dave Cramer > > da...@postgresintl.com > www.postgresintl.com > > >> On Fri, 14 Dec

Re: loading jdbc Driver in servlet

2018-12-16 Thread Dave Cramer
My guess is it has something to do with your servlet classpath loader. Which servlet engine are you using ? Dave Cramer da...@postgresintl.com www.postgresintl.com On Fri, 14 Dec 2018 at 16:04, Rob Sargent wrote: > > > On Dec 14, 2018, at 2:02 PM, Rob Sargent wrote: > > > > On Dec 14, 2018,