Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Purge Assignments with HDL

Jeroen v MeenenApr 23 2020 — edited Aug 7 2020

Hi guys,

If we try to purge (completely remove all date-effective rows) an Assignment via HDL it errors with:

"You supplied a DELETE instruction for the object component Assignment, which can't be deleted. (HRC-1035622)"

However from the front-end this action is allowed by removing all assignment date-effective rows one by one, starting with the most recent.

We have scenarios where assignments were created with the wrong effective start date, the only way is to purge and recreate the assignment.

Why is not allowed through HDL?

Regards

Jeroen

Comments

843835
which webserver are you using?
843835
hi,

Thanks for your reply. I am using tomcat server. I have installed jdk1.3.2 and that is the one the tomcat server is using.

It would be really helpful you can give me some suggestions.

niranjan maturi
which webserver are you using?
843835
Hi,
If you want to increase the maximum heap size for *SUN" JDK, it is wise to set TOMCAT_OPTS in the command line before starting the tomcat startup this way

[unix] export TOMCAT_OPTS=3D"-DXmx=3D512m"
[Windows] set TOMCAT_OPTS=3D"-DXmx=3D512m"


Hope that hepls.

Regards,
Senthil Babu
Developer Technical Support
SUN Microsystems
http://www.sun.com/developers/support/
843835
hi,

I tried setting TOMCAT_OPTS. The maximum I could go in my system is 1300M
i.e. set TOMCAT_OPTS="-DXmx=1300m".

Still I am having the problem that when some 5000 records are fetched from the database, the ResultSet object is not able to handle them. It is able to handle upto 2000 records. I am using windows2000, jdk1.3.2 and Filemaker Pro 5.0 databases.

I tried to set the maximum number of records that can be retrieved to 2000 so that the problem will be solved. But I am not able to set that as well. I did:
Class.forName("com.fmi.jdbc.JdbcDriver").newInstance();
Connection con = DriverManager.getConnection("standard statement");
PreparedStatement pstmt = con.prepareStatement("select id, pubyear, Checkedoutby, >>callnumber from mprrc_materials");
pstmt.setFetchSize(2000);
ResultSet rs3 = pstmt.executeQuery();
Its giving the error:
java.lang.AbstractMethodError at that setFetchSize() statement.

I guess the JDBC driver provided by Filemaker Pro does not support that. So what can be done to solve the problem.

Thanks,
Niranjan Maturi





1 - 4

Post Details

Added on Apr 23 2020
10 comments
3,267 views