Re: Problems configuring a JNDI JDBC pool to Postgres

2020-11-28 Thread Mark Thomas
On 27/11/2020 19:56, Hrafn Malmquist wrote: > Great. Thanks. > > Glad it was a simple fix. > > By the way, why would you choose DBCP2 over Tomcat? Intuitively, I would > assume a pool designed specifically for Tomcat would be more efficient than > a more generic Apache library? There is very lit

Re: Problems configuring a JNDI JDBC pool to Postgres

2020-11-27 Thread Hrafn Malmquist
Great. Thanks. Glad it was a simple fix. By the way, why would you choose DBCP2 over Tomcat? Intuitively, I would assume a pool designed specifically for Tomcat would be more efficient than a more generic Apache library? Hrafn On Fri, Nov 27, 2020 at 8:24 AM Mark Thomas wrote: > On 26/11/202

Re: Problems configuring a JNDI JDBC pool to Postgres

2020-11-27 Thread Mark Thomas
On 26/11/2020 22:52, Hrafn Malmquist wrote: > A > > How silly of me. It's right there staring me in the face nested inside the > host in server.xml, right? Right. The changes to GlobalResources look good. You'll probably want to revert the change you made to appBase. > So, best practice is

Re: Problems configuring a JNDI JDBC pool to Postgres

2020-11-26 Thread Hrafn Malmquist
A How silly of me. It's right there staring me in the face nested inside the host in server.xml, right? So, best practice is to remove contexts from host and place either under [engine]/[host] or directly in META-INF in app? On Thu, Nov 26, 2020 at 10:43 PM Hrafn Malmquist wrote: > Hello R

Re: Problems configuring a JNDI JDBC pool to Postgres

2020-11-26 Thread Hrafn Malmquist
Hello Rob and Mark and others Thanks for your input. > >2. In /home/lib/dspace/apache-tomcat-9.0.12/conf/server.xml I added the > >following Resource > > > > > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" > > type="javax.sql.DataSource" > >

Re: Problems configuring a JNDI JDBC pool to Postgres

2020-11-26 Thread Mark Thomas
On 26/11/2020 19:57, Hrafn Malmquist wrote: > I am running: > > CentOS Linux release 7.8.2003 > Tomcat 9.0.12 > PostgreSQL 9.5.23 > openjdk version "1.8.0_262" > OpenJDK Runtime Environment (build 1.8.0_262-b10) There are good reasons to update to a more recent Tomcat 9 release but I'm not awa

Re: Problems configuring a JNDI JDBC pool to Postgres

2020-11-26 Thread Mark Thomas
On 26/11/2020 21:01, Rob Sargent wrote: > Looks like you named your resource jdbc/dspaceWeb and dropped the Web in your > lookup Nope. You are confusing the global and local name. The config looks right on first glance. Mark > >> On Nov 26, 2020, at 12:58 PM, Hrafn Malmquist >> wrote: >> >>

Re: Problems configuring a JNDI JDBC pool to Postgres

2020-11-26 Thread Rob Sargent
Looks like you named your resource jdbc/dspaceWeb and dropped the Web in your lookup > On Nov 26, 2020, at 12:58 PM, Hrafn Malmquist > wrote: > > Good day fellow Apache Tomcat users > > I have recently had reason to set a Postgres DataSource via the Tomcat JNDI > api. My experiments have bee

Problems configuring a JNDI JDBC pool to Postgres

2020-11-26 Thread Hrafn Malmquist
Good day fellow Apache Tomcat users I have recently had reason to set a Postgres DataSource via the Tomcat JNDI api. My experiments have been largely unsuccessful, unfortunately I hope you are able to help me. I thank you in advance for taking the time to read this. I am coming to this problem in