i am getting error while accesssing Oracle database

Avatar

Avatar

_MEHUL_PARESHBH

Avatar

_MEHUL_PARESHBH

_MEHUL_PARESHBH

02-02-2009

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.

Replies

Highlighted

Avatar

Avatar

JoshDBoyle-DVzR

Avatar

JoshDBoyle-DVzR

JoshDBoyle-DVzR

12-02-2009

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
Highlighted

Avatar

Avatar

HowardTreisman

Avatar

HowardTreisman

HowardTreisman

20-02-2009

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