Skip to main content
A
Anonymous
October 24, 2014
Answered

Finding the Oracle data source (ColdFusion application)

  • October 24, 2014
  • 2 replies
  • 1384 views

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.

This topic has been closed for replies.
Correct answer

Always check and double check the code before you say it's correct  Thanx BKBK for finding the extra space in the data source.  I don't think that is the problem with Test, but will check again.  Thank you.

2 replies

A
Anonymous
Correct answer
November 24, 2014

Always check and double check the code before you say it's correct  Thanx BKBK for finding the extra space in the data source.  I don't think that is the problem with Test, but will check again.  Thank you.

A
Anonymous
November 17, 2014

I upgraded the ColdFusion on my development box from 8 to 10.   I've gone into CF10 Admin and verified the connection to the 10.2 database is correct (Data & Services > Data Sources >  Connected Data Sources > Verify All Connections or Verify my specific connection) and the status says "OK".  I still receive the error data source not found, when attempting to bring up the application.   What other things should I try?   Thank you in advance.

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
November 23, 2014

It is possible that the name of the datasource which Coldfusion cannot find is missing from the list of datasources in CF10 Admin.

A
Anonymous
November 24, 2014

That was my first thought.   On my development box, I checked and rechecked and everything is correct.  I've been told on my Test box that everything is correct.  The error on my Development box is Datasource Not Found.  The error on my Test box is [Macromedia][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist.   I have access to CF10 Admin on my Development box, I do not have it on Test.  When verifying in CF10 Admin, the datasource shows as OK on my Development box.  On Test, the SysAdmin sent me a screen shot that says the same thing.  Severely stumped.

Firefly Community Gallery
Adobe Firefly

Remix with Firefly Community Gallery

Thousands of free creations to fall in love with and remix in Firefly.

Explore now
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices