| Query not processing by JDBC (Hanging on the executeQuery line) [message #645413] |
Sat, 05 December 2015 04:52  |
 |
deepak416
Messages: 63
Registered: January 2013
Location: Pune
|
Member |
|
|
My JAVA application are hanging when the its reached to executeQuery Line. Can anyone help why the below query are not executing by jdbc ?
Below are the query.
select RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY.RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY_ID as history,
RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY.INVOICE_NO, RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY.TOTAL_AMOUNT,RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY.PAID_AMOUNT,
RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY.RSOL_VENDOR_ACCOUNT_ID , (SELECT SUM(QUANTITY *purchased_price) from
RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY_WITH_STOCK_DETAILS where
RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY_WITH_STOCK_DETAILS.RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY_ID = history) as a from RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY
join RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY_WITH_STOCK_DETAILS ON
RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY.RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY_ID=
RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY_WITH_STOCK_DETAILS.RSOL_VENDOR_ACCOUNT_PAYMENT_HISTORY_ID group by history
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
