Re: DBD::Oracle 1.25 and DRCP

2011-10-14 Thread Rob Fries
Hey Cliff and John, on Sept 22, 2010 you posted about issues you were having with getting Oracle DRCP working using the ora_drcp_class. I am running into similar issues and was wondering if you got DRCP to work and have it share the connection. We are using oracle 11.2.0.2 and I have perl v5.8.8,

Re: DBD::Oracle 1.25 and DRCP

2011-10-14 Thread Rob Fries
Hey John, I had to trim out some data ( mostly just Environment Variables ). let me know if there are any specific you would like to know the value of if I did not provide below. here is the rest of the output: ORACLE_HOME=/app/oracle/product/current /app/oracle/product/curren

Re: DBD::Oracle 1.25 and DRCP

2011-10-15 Thread Rob Fries
Thanks John! that seems to have fixed it: charset id=1, name=US7ASCII, ncharset id=1, name=US7ASCII (csid: utf8=871 al32utf8=873) Useing DRCP Connection dbd_st_prepare'd sql ALTER (pl1, auto_lob1, check_sql1) dbd_describe skipped for ALTER dbd_st_execute ALTER (out0

Re: DBI: For speed-critical forking server, is DB reconnection in each child required? And prepared statements?

2012-05-14 Thread Rob Fries
Hey James, I was running into a similar situation but for a backend system that ran multiple quick scripts to check state for automation. I was working on building a daemon that would hold the connections, adding as needed and destroying excess using some POE modules. while working on it though,