Adobe Community : All Content - All Communities

Finding the Oracle datasource...

forums_noreply@adobe.com — Thu, 09 Oct 2014 19:47:15 GMT

I've inherited a ColdFusion 10 application with an Oracle 11g backend; Windows server. I am mostly a DBA and not a ColdFusion expert. In the code for the application, they have the datasource hard coded. This means when I move it to Test I must change the datasource, upload the modules, and test. After a successful test, I have to change the datasource, yet again, upload and have it promoted to production. I seem to remember in the old application I used to support, the code was generic and the datasource depended on what server you were on; if on development, test, or production you didn't have to worry. I don't remember how this was done. What would be the best way to eliminate this hard coding and have it more automated? I know I'm probably missing something, but you all have been very helpful to me in the past few weeks, so hopefully, it's not a completely stupid question. Thank you.

Finding the Oracle data source (ColdFusion application)

forums_noreply@adobe.com — Fri, 24 Oct 2014 16:32:16 GMT

I inherited a ColdFusion 10 application with an Oracle 11g back end. Recently, I began receiving java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist error message when attempting to access the application on my Test server. Since it is a gov't application, I do not have direct access to CF Admin or the database. The gov't SysAdmin has verified the CF Admin connection is valid and connected. The DBA has verified the data source exists and the database is up and running. Thoroughly confused as to what is going on. I posted on the Adobe ColdFusion support forum and they suggested I post it here to get database eyes on the issue. The thread is here: https://forums.adobe.com/message/6854985#6854985

Thank you in advance.

ORA-00900: invalid SQL statement (ColdFusion/Java)

forums_noreply@adobe.com — Tue, 07 Oct 2014 18:54:49 GMT

I found a bunch of topics on this subject, but none seem to exactly be doing what is going on for me.

I have a ColdFusion/Java routine that displays funding requests that need to be approved. When you click on the action button, you can either approve or disapprove. When the user presses the button, I get the error message via e-mail with a copy of the trace. It shows me the statement that isn't valid. I copy it and run it in SQL*Plus on my Production database. It returns the row expected. How can that be? Confused.

Here is the trace [link]https://dl.dropboxusercontent.com/u/3594970/1244Err.txt

Oracle 11g on a Windows server

The getBuiltInScopes method was not found

forums_noreply@adobe.com — Thu, 25 Sep 2014 18:41:06 GMT

I have an application that has worked for quite a while. I have made no changes to the code since the last time I used it. Basically, the code creates a zip file with input for an involved report. I used it in March of this year it worked fine. I've been assured by the gov't sysadmins and DBAs that nothing has changed, but I still get the attached error. Any ideas? I have just heard from a friend who knows CF, that it could be a version issue. I am currently running 8 and I believe he is running 10. If this is an issue, is the solution somewhere on this site? I do minimal CF and am at a loss. The function that is throwing the error is when a button is clicked, a javascript routine is run which combines all the files requred for the zip file. Yesterday, another application started throwing the error. I haven't been through the code yet, but it is another button being clicked, and I'm sure, another javascript error.