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

Oracle Community | 768358 | 7 years ago
  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 | 2 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 | 11 months 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 | 2 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