2 Replies Latest reply on Feb 20, 2009 3:03 AM by HowardTreisman

    i am getting error while accesssing Oracle database

    (MEHUL_PARESHBHAI_THAKOR)
      i am trying to learn by playing around with '

      MORTGAGE LOAN APPLICATION.

      in database i have taken oracle.

      when i try to fire following query:

      select * from customer where custId={$ /process_data/@custId $}

      i am getting following error:

      Exception: Internal error.. Cause: ALC-DSC-000-000: com.adobe.idp.dsc.DSCRuntimeException: Internal error.
        • 1. Re: i am getting error while accesssing Oracle database
          JoshDBoyle Level 1
          Mehul

          I've not worked with Oracle but I'll give this a shot. Try the following:

          1) If the database you are querying is transcational, add the text (without quotes) "WITH (NOLOCK)" as part of your FROM clause. It may be possible for your DBAs to have set that any queries run without this to be rejected since it would result in locking the table.

          2) I assume, by your query, that custId is of an integer type but if it is varchar (String) then make sure to put your single quotes around the parameter afte the '='.

          I would ask the following:

          Where are you firing the query from? Are you doing it as part of a webservice the form is connected to or are you doing it inside Workbench using one of the JDBC services (or another means)?

          Josh Boyle
          jboyle@cardinalsolutions.com
          Cardinal Solutions Group
          • 2. Re: i am getting error while accesssing Oracle database
            HowardTreisman Level 1
            Have you set up a data source in your application server for this database?
            Have you specified this data source in the SQL component?
            Howard
            http://www.avoka.com