AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Oracle JDBC under heavy load          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message Aleksey Beregov Guest Posted: Sun Jan 04, 2004 11:42 pm    Post subject: Oracle JDBC under heavy load I am using Oracle 9i release 2 on Red Hat Linux 9. I have written a simple application, which inserts one millions rows into a single table. The application uses Oracle JDBC driver type 4. The problem is that after approximately 20 thousands inserts the broken pipe exception is thrown. I have checked the Oracle log and it says: "Exception signal 11 (SIGSEGV), code 1: (Address not mapped to object)". The application uses the prepared statement and does commit after every N (by default N is equal 1000) rows. Does anybody know how to resolve this issue or what a workaround is? Thank you Back to top Juha Laiho Guest Posted: Mon Jan 05, 2004 8:07 pm    Post subject: Re: Oracle JDBC under heavy load "Aleksey Beregov" <alekseyberegov (AT) comcast (DOT) net> said: Quote: I am using Oracle 9i release 2 on Red Hat Linux 9. I have written a simple application, which inserts one millions rows into a single table. The application uses Oracle JDBC driver type 4. The problem is that after approximately 20 thousands inserts the broken pipe exception is thrown. I have checked the Oracle log and it says: "Exception signal 11 (SIGSEGV), code 1: (Address not mapped to object)". "The Oracle log" being what? The Oracle instance alert log? Some trace log? Anything else there, f.ex. an ORA-00600 error message? If it's ORA-00600, you might be hitting an internal error on Oracle (and thus would need a patch from the Oracle support site -- I hope you have a valid support agreement). -- Wolf a.k.a. Juha Laiho Espoo, Finland (GC 3.0) GIT d- s+: a C++ ULSH++++$ P++@ L+++ E- W+$@ N++ !K w !O !M V PS(+) PE Y+ PGP(+) t- 5 !X R !tv b+ !DI D G e+ h---- r+++ y++++ "...cancel my subscription to the resurrection!" (Jim Morrison) Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.