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

[Denis Pointer]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090817/15df8dd7/attachment.html>