Hello everyone,
We are currently migrating our application towards ADF 12.2.1.3.0.
While doing this we encounter an issue while trying to insert LOB's that are larger than 2MB.
For small LOB's we do not encounter any issues, but for larger ones (while I personally do not agree 2,3MB is large) we get an error: No data to read from socket, or a broken pipe error.
I have created a sample application that tries to insert a specific file (an xml document of 2,3MB) into the database.
This test case can insert the desired record without any problem in an oracle database 11.2.0.1.0
However when I try to execute the same testcase but pointing to another version of the database (12.1.0.2.0) we get the error mentioned above.
So the issue is not related to the used source code, project, or weblogic JDBC driver alone.
I also do not think the problem lies in the network; because we can insert the same file in the 12.1.0.2.0 database using our previous application (ADF 12.1.3.0.0).
So my questions to you are:
1) Are there any colleagues that have experienced the same/similar issues while their migration towards ADF - Weblogic - 12.2.1.3.0.
2) Does anyone have any suggestion I can try to solve our issue please?
I think I have already tried all combinations of the datasource configuration settings, but without success so far.
Any ideas, suggestions or solutions would be very useful,
thanks a lot in advance!
Kind regards,
Rob Lefebvre