Sorry, I should also mention, we are running UCCX 7.01 SR3 with Premium Licence on an HA deployment, and we are able to do DB reads fine<br><br><div class="gmail_quote">On Mon, Aug 17, 2009 at 2:42 PM, Denis Pointer <span dir="ltr"><<a href="mailto:denis.mailer@gmail.com">denis.mailer@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hello,<div> We are trying to do a DBWRITE to an Oracle 10g database. As a test we set up a new table with a single column looking for a string, we put in the SQL statement: insert into CISCO_T(col1) VALUES('12345'); when we do the test it shows Number of Rows Altered: 1 However when we look in the database, nothing is there. Speaking with the DBA he thinks we need a commit statement. However when we add the commit statement, and end out with SQL statement "insert into CISCO_T(col1) VALUES('12345'); COMMIT;" when we do the test again the Number of Rows Altered is 0, and still nothing is in the database. </div>
<div><br></div><div>We have tried changing the "batch autocommit mode" in the ODBC settings from "commit only if all statements succeed", to "commit all successful statements" to see if that would make a difference or not, and still have the same results.</div>
<div><br></div><div>Does anyone have any idea what we are doing wrong? How do we get the DBWRITE to work with Oracle 10g?</div><div><br></div><div><br clear="all">Thank you for your assistance</div><div><br>-- <br>Denis Pointer, A. Sc. T.<br>
Customer Systems Analyst (Senior Design)<br><br>CCVP, CCNA, CCDA<br>Cisco Unified Contact Center Specialist<br>Cisco IP Telephony Design Specialist<br>Cisco Unity Design Specialist<br>Cisco Unity Support Specialist<br>Cisco IP Communications Express Specialist<br>
</div>
</blockquote></div><br><br clear="all"><br>-- <br>Denis Pointer, A. Sc. T.<br>Customer Systems Analyst (Senior Design)<br><br>CCVP, CCNA, CCDA<br>Cisco Unified Contact Center Specialist<br>Cisco IP Telephony Design Specialist<br>
Cisco Unity Design Specialist<br>Cisco Unity Support Specialist<br>Cisco IP Communications Express Specialist<br>