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

[Denis Pointer]

Thanks for your help guys, I confirmed today when I actually run through the
scripts my reads and writes are working,  MY problem was, as Ahbay and Jason
mentioned, I was assuming the "test" button would actually commit the
change. All Is good now thanks

On Tue, Aug 18, 2009 at 4:16 AM, Abhay Kumar (abhakuma)
<abhakuma at cisco.com>wrote:

>  Hi Denis,
>
>
>
>                 The test button on the db write step does not commit to the
> database. It just checks how many rows will get affected and then it rolls
> back. To commit to the database run the script with the insert command
> written under the  SQL tab for the db write step
>
>
>
> Regards,
>
> Abhay Kumar
>
>
>
> *From:* Denis Pointer [mailto:denis.mailer at gmail.com]
> *Sent:* Tuesday, August 18, 2009 3:19 AM
>
> *To:* Ask-icd-ivr-support at external.cisco.com; cisco-voip at puck.nether.net
> *Subject:* Re: 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>
> 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
>



-- 
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/20090818/c8957008/attachment.html>