Adobe Community : All Content - All Communities

Executing the SQL statement is not allowed - Error

forums_noreply@adobe.com — Wed, 03 Mar 2010 18:20:09 GMT

I am getting "Executing the SQL statement is not allowed" for an INSERT cfquery that I'm running. I checked the usual suspects:

- DSN allows INSERT

- I've seen reports online where certain field names or values are considered key words, so for protection CF blocks the query in this way (it would be nice if there was a different error message when it gets blocked this way vs. the DSN doesn't allow INSERT error message). The field names and values were all benign strings, so it didn't seem like that.

I took the same string for the query and ran it on another page and it ran fine (same DSN, too).

Not maintaining connection

forums_noreply@adobe.com — Thu, 17 Dec 2009 19:21:56 GMT

ColdFusion v8.01 on Windows 2003

Our database is Oracle 10.1. We connect using a "thin" connection (oracle.jdbc.OracleDriver)

We have "Maintain Connections" selected in the driver, but it looks like the connections are always regenerated and not maintained. It's starting to cause us to have occasional "IO exception: The Network Adapter could not establish the connection" errors. Occasional but still disruptive.

The last time we paid close attention to our connections in Oracle (maybe 15 months ago), they stayed alive for a long time (e.g. all day), at least during the day since our site is pretty busy. Now when we look at the connections, they are created within minutes or seconds of now, they are not being maintained.

Any ideas on why they wouldn't maintain and how we get them back to actually maintaining those connections?

Thanks a lot.

I must be missing something

forums_noreply@adobe.com — Sat, 16 Jan 2010 00:03:34 GMT

I've jumped in and tried using BrowerLab (the online one). The pages display fine, but the links and form buttons don't work. Is that how it's supposed to behave? How do you test form post pages? Sorry if I'm missing something obvious. Thanks a lot.