MySQL Bugs: #23835: data modifications (updates,deletes and inserts) from oracle forms failed

Bug #23835	data modifications (updates,deletes and inserts) from oracle forms failed
Submitted:	1 Nov 2006 12:44	Modified:	30 May 2013 6:56
Reporter:	Sainudheen k	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	3.51	OS:	Windows (windows xp)
Assigned to:	Bogdan Degtyariov	CPU Architecture:	Any

Description:
I am using Oracle D2K Forms 6i, OCA for ODBC 6.0.5.35.0, MySQL community server 5.0.26 & MySQL ODBC driver 3.51.

Connection to the server from Oracle forms and reports using oracle reports works fine. Howerver, any data modifications (updates,deletes and inserts) from oracle forms to the Mysql tables fails. When updating/inserting/deleting from Oracle forms I get the correct message. After re-query I found the updated data but after closing the session, when I log-in again or restart the forms I found the old un-updated data. Any idea, please help.

PS: I tried to connect from Oracle forms through MS Access linked tables to the same data source and using the same ODBC connection, the update succeeded.

Thanks

How to repeat:
created odbc DSN
Connected to MySQL from Oracle forms 6i <user name>/<password>@ODBC:<the dsn>
query data = OK
data modifications (updates,deletes and inserts)
Requery = result shows updated data
close the forms session 
restart the forms
Connected to MySQL from Oracle forms 6i <user name>/<password>@ODBC:<the dsn>
query data = still old data. previous modificaitons not effected

Thank you for a problem report. What exact version of Connector/ODBC do you use? It is 3.51.x, and x is important. have you tried to enable general query log on MySQL server to check what statements are sent from Oracle Forms?

ODBC Trace Log file

Attachment: SQL.zip (application/zip, text), 10.82 KiB.

Connector/ODBC VERSION IS 3.51.12
SQL Trace log in zip format attached

Hi Sainudheen. 
It's very hard to say what each ODBC implementation will do and how it will behave. For example, in your you have:
XLADMIN@XLERP   e84-e8c	ENTER SQLExecDirect 
		HSTMT               04AE1CC0
		UCHAR *             0x048A8DE4 [      36] "SELECT 1 FROM ALL_TABLES WHERE 1 = 2"
		SDWORD                    36
which works on Oracle Data Dictionary implementation (it's predefined view) but throwing error on MySQL server:
DIAG [S0002] [MySQL][ODBC 3.51 Driver][mysqld-5.0.26-community-nt]Table 'mysql.all_tables' doesn't exist (1146) 

Second important thing is that Oracle tool / MS Access bridge is working correctly which means your tool "sniffs" out MS Access and behaves more to the liking of MyODBC. Therefore I can't realy tell what's happening nor can I solve this for you (don't have Oracle code) but I can suggest to set autocommit on your server to 1 and test again.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Hi Sainudheen, what's the status of this problem? Did you tried my suggestions?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.