Oracle&&IVR CISCO

Natalia474 · ‎05-26-2010

Hi,

I am working with IVR CISCO Callcenter, and our custom has an Oracle Database. We know that when you want to insert some data in database, you must to do “insert” and then “commit”. IVR doesn’t allow us insert nothing, because we don’t know how to do “Commit”.

I hope you could help us.

Thanks very much

Best regards

geoff · ‎05-26-2010

You need to do this with Java code. Import the Oracle JAR into the CRS system correctly and use the Expression Editor. Write Java code to call the Oracle methods needed.

Regards,

Geoff

Natalia474 · ‎05-27-2010

Thanks!

Now i dont have the applilcation here, but...

Which is the way to import Oracle Jar?

Do you know which is the java's version CIsco IVR has?

Maybe it is a very stupid question.

Thanks very much!

Regards

Natalia

geoff · ‎05-27-2010

Now i dont have the applilcation here, but...

Expression Editor? Yes you do.

Which is the way to import Oracle Jar?

The same way that any JAR is imported. Described in the Cisco documents - you need to add it to the document repository and change the CLASSPATH so that the JAR is referred to. CRS needs to see the classes in the JAR through reflection so the Expression Editor can display the classes and the methods therein. If you haven't set it up correctly, you will know immediately - because the Expression Editor will not be able to show the methods of the class when you set it.

This takes a little experimentation, but it's worthwhile. There is a document on the Expression Editor.

Regards,

Geoff

Gergely Szabo · ‎05-27-2010

Now wait a second. Why commit?

The ODBC driver for Oracle has got AutoCommit enabled. Did you change it?

Is it a special requirement of the database?

What version of Oracle are you using? Did you try to run the update query against the database using a different tool, over JDBC or you-name-it (for example their sql CLI)? Were the table(s) not updated without explicitly saying COMMIT TRANSACTION?

G.

Natalia474 · ‎05-28-2010

HI!!!!!

The problem was that It had 10 conection to oracle database.Sometimes these conections block themselves.

We solved this problem yesterday with a procedure.

Thanks very much for all!

Regards

Natalia