Multitasker Akash

Greenhorn
+ Follow
since Sep 09, 2016
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Multitasker Akash

Hi ,

I am getting error org.apache.poi.EmptyFileException: The supplied file was empty (zero bytes long) after 4 lakh records in excel file writing.

I am using apache poi and i have 10 million records to write. I am running a job to write to the excel file. the chunk size is 1000.

The file gets created on drive but after reaching 4 lakh rows, the xlsx file shows its corrupt.

Please help.
Hibernate is not fetching the required field mediaid from joined table ...... with underlined code.





Current Table structure is following:

SELECT DISTINCT brand0_.id AS id1_26_,
   brand0_.CREATED_BY         AS CREATED_BY2_26_,
   brand0_.CREATED_DATE       AS CREATED_DATE3_26_,
   brand0_.IS_DELETED         AS IS_DELETED4_26_,
   brand0_.MODIFIED_BY        AS MODIFIED_BY5_26_,
   brand0_.MODIFIED_DATE      AS MODIFIED_DATE6_26_,
   brand0_.VERSION            AS VERSION7_26_,
   brand0_.OWNER_ID           AS OWNER_ID14_26_,
   brand0_.MEDIAOCEAN_ID      AS MEDIAOCEAN_ID8_26_,
   brand0_.NAME               AS NAME9_26_,
   brand0_.PARENT_ID          AS PARENT_ID15_26_,
   brand0_.SHORT_NAME         AS SHORT_NAME10_26_,
   brand0_.STATUS             AS STATUS11_26_,
   brand0_.THIRD_PARTY_ID     AS THIRD_PARTY_ID12_26_,
   brand0_.TYPE_ID            AS TYPE_ID13_26_,



AND AIM IS TO MAKE FOLLOWING IN JPA....

SELECT DISTINCT brand0_.id,media3_.id AS id1_26_,
   brand0_.CREATED_BY         AS CREATED_BY2_26_,
   brand0_.CREATED_DATE       AS CREATED_DATE3_26_,
   brand0_.IS_DELETED         AS IS_DELETED4_26_,
   brand0_.MODIFIED_BY        AS MODIFIED_BY5_26_,
   brand0_.MODIFIED_DATE      AS MODIFIED_DATE6_26_,
   brand0_.VERSION            AS VERSION7_26_,
   brand0_.OWNER_ID           AS OWNER_ID14_26_,
   brand0_.MEDIAOCEAN_ID      AS MEDIAOCEAN_ID8_26_,
   brand0_.NAME               AS NAME9_26_,
   brand0_.PARENT_ID          AS PARENT_ID15_26_,
   brand0_.SHORT_NAME         AS SHORT_NAME10_26_,
   brand0_.STATUS             AS STATUS11_26_,
   brand0_.THIRD_PARTY_ID     AS THIRD_PARTY_ID12_26_,
   brand0_.TYPE_ID            AS TYPE_ID13_26_,
7 years ago