[cisco-voip] DB Write Oracle 10g how do we commit?

[Fuermann, Jason]

If you are using the test button it will not affect the DB, you have to actually run, or debug the script. The test button only verifies that it is a valid statement (per the docs I read, and experience)

From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Denis Pointer
Sent: Monday, August 17, 2009 4:49 PM
To: Ask-icd-ivr-support at external.cisco.com; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] DB Write Oracle 10g how do we commit?

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
On Mon, Aug 17, 2009 at 2:42 PM, Denis Pointer <denis.mailer at gmail.com<mailto:denis.mailer at gmail.com>> wrote:
Hello,
   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.

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.

Does anyone have any idea what we are doing wrong?  How do we get the DBWRITE to work with Oracle 10g?


Thank you for your assistance

--
Denis Pointer, A. Sc. T.
Customer Systems Analyst (Senior Design)

CCVP, CCNA, CCDA
Cisco Unified Contact Center Specialist
Cisco IP Telephony Design Specialist
Cisco Unity Design Specialist
Cisco Unity Support Specialist
Cisco IP Communications Express Specialist



--
Denis Pointer, A. Sc. T.
Customer Systems Analyst (Senior Design)

CCVP, CCNA, CCDA
Cisco Unified Contact Center Specialist
Cisco IP Telephony Design Specialist
Cisco Unity Design Specialist
Cisco Unity Support Specialist
Cisco IP Communications Express Specialist
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090817/fda00f49/attachment.html>