java.sql.SQLSyntaxErrorException: ORA-00904: "WFS_VERSION": invalid identifier

Oracle Community | 768358 | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Spatial Web Services on Weblogic

    Oracle Community | 7 years ago | 768358
    java.sql.SQLSyntaxErrorException: ORA-00904: "WFS_VERSION": invalid identifier
  2. 0

    Grails 1.3.7 GORM integration to Oracle 10g DB reults in "SQL Error: 932, SQLState: 42000" for domain class attribute mapping to Orable CLOB type

    Stack Overflow | 5 years ago | hbartling
    java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB
  3. 0

    anypoint studio database issue for expression

    Stack Overflow | 3 years ago | bekur
    java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    mule studio vs anypoint studio databse issue - MuleSoft

    mulesoft.com | 1 year ago
    java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
  6. 0

    When I use this query it works fine in anypoint studio in mule. But now in Anypoint studio it says that it is deprecated, so I used new db details config as given below, but it gives error message as given below with new query details. {code:xml} <jdbc-ee:outbound-endpoint exchange-pattern="one-way" queryKey="syncdb" queryTimeout="-1" connector-ref="auth-quickbooks_companies" doc:name="Database"> <jdbc-ee:query key="syncdb" value="MERGE INTO SIAS_ACCESS dest USING(SELECT '${companyName}' ACCT_SYSTEM_COMPANY_NAME, #[message.payload.accessToken] access_token, #[message.payload.accessTokenSecret] access_token_secret,#[message.payload.realmId] ACCT_SYSTEM_COMPANY_ID FROM dual ) src ON( dest.ACCT_SYSTEM_COMPANY_ID = src.ACCT_SYSTEM_COMPANY_ID ) WHEN MATCHED THEN UPDATE SET dest.access_token = src.access_token, dest.access_token_secret = src.access_token_secret, dest.ACCT_SYSTEM_COMPANY_NAME = src.ACCT_SYSTEM_COMPANY_NAME, ACCESS_TOKEN_LIFETIME = SYSDATE WHEN NOT MATCHED THEN INSERT( ACCESS_ID, ACCT_SYSTEM_COMPANY_NAME, ACCESS_TOKEN, ACCESS_TOKEN_SECRET, ACCT_SYSTEM_COMPANY_ID, ACCESS_TOKEN_LIFETIME) VALUES( SIAS_ACCESS_SEQ.nextval, src.ACCT_SYSTEM_COMPANY_NAME, src.access_token, src.access_token_secret, src.ACCT_SYSTEM_COMPANY_ID, SYSDATE )"/> </jdbc-ee:outbound-endpoint> {code} New db query: with Operation as Execute DDL {code:xml} <db:execute-ddl config-ref="Oracle_Configuration" doc:name="Database"> <db:dynamic-query><![CDATA[MERGE INTO SIAS_ACCESS dest USING(SELECT '${companyName}' ACCT_SYSTEM_COMPANY_NAME, #[message.payload.accessToken] access_token, #[message.payload.accessTokenSecret] access_token_secret,#[message.payload.realmId] ACCT_SYSTEM_COMPANY_ID FROM dual ) src ON( dest.ACCT_SYSTEM_COMPANY_ID = src.ACCT_SYSTEM_COMPANY_ID ) WHEN MATCHED THEN UPDATE SET dest.access_token = src.access_token, dest.access_token_secret = src.access_token_secret, dest.ACCT_SYSTEM_COMPANY_NAME = src.ACCT_SYSTEM_COMPANY_NAME, ACCESS_TOKEN_LIFETIME = SYSDATE WHEN NOT MATCHED THEN INSERT( ACCESS_ID, ACCT_SYSTEM_COMPANY_NAME, access_token, access_token_secret, ACCT_SYSTEM_COMPANY_ID, ACCESS_TOKEN_LIFETIME) VALUES( SIAS_ACCESS_SEQ.nextval, src.ACCT_SYSTEM_COMPANY_NAME, src.access_token, src.access_token_secret, src.ACCT_SYSTEM_COMPANY_ID, SYSDATE )]]></db:dynamic-query> </db:execute-ddl> {code} **ERROR:** Root Exception stack trace: java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) Instead of **Operation** DDL I have selected Insert(tried with select/update) with **Query Type** as **Parameterized**, it gives me error as: Query type must me '[INSERT, STORE_PROCEDURE_CALL]' but was 'DDL' http://stackoverflow.com/questions/25940345/mule-studio-vs-anypoint-studio-database-issue

    MuleSoft JIRA | 3 years ago | kasim bekur
    java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      ORA-00904: "WFS_VERSION": invalid identifier

      at oracle.jdbc.driver.SQLStateMapping.newSQLException()
    2. Oracle jdbc
      SQLStateMapping.newSQLException
      1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
      1 frame