Re: loading jdbc Driver in servlet

2018-12-14 Thread Rob Sargent
> On Dec 14, 2018, at 2:02 PM, Rob Sargent wrote: > > > >> On Dec 14, 2018, at 1:30 PM, Dave Cramer > > wrote: >> >> Strange, I wouldn't think so, but then I haven't used a raw servlet for so >> long I have no idea. >> >> >> Dave Cramer >> >>

Re: loading jdbc Driver in servlet

2018-12-14 Thread Rob Sargent
> On Dec 14, 2018, at 1:30 PM, Dave Cramer wrote: > > Strange, I wouldn't think so, but then I haven't used a raw servlet for so > long I have no idea. > > > Dave Cramer > > da...@postgresintl.com > www.postgresintl.com > > On

Re: loading jdbc Driver in servlet

2018-12-14 Thread Dave Cramer
Strange, I wouldn't think so, but then I haven't used a raw servlet for so long I have no idea. Dave Cramer da...@postgresintl.com www.postgresintl.com On Fri, 14 Dec 2018 at 13:29, Rob Sargent wrote: > Using java 1.8, postgresql-42.1.4.jar, embedded tomcat 9 > > It appears to me that I

loading jdbc Driver in servlet

2018-12-14 Thread Rob Sargent
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 ergo propter hoc /at it finest and I changed something

Re: libpq PQexecParams & value placeholders

2018-12-14 Thread Oleg
On Fri, Dec 14, 2018 at 02:47:12PM +0300, Dmitry Igrishin wrote: > пт, 14 дек. 2018 г. в 14:33, Oleg : > > > > Hi, all. > > > > Do we really need a numeric value placeholders like $1 in command string? > It's a syntax defined at the backend side. >

Re: libpq PQexecParams & value placeholders

2018-12-14 Thread Dmitry Igrishin
пт, 14 дек. 2018 г. в 14:33, Oleg : > > Hi, all. > > Do we really need a numeric value placeholders like $1 in command string? It's a syntax defined at the backend side. (https://www.postgresql.org/docs/current/sql-prepare.html) > Construction of such string for complex non-static queries is very

libpq PQexecParams & value placeholders

2018-12-14 Thread Oleg
Hi, all. Do we really need a numeric value placeholders like $1 in command string? Construction of such string for complex non-static queries is very annoying. Why do we can't simply use $$ placeholder, which take the next value from an array of values? -- Олег Неманов (Oleg Nemanov)