从excel导入1000多条数据到oracle数据库时,java内存溢出,tomcat报错

问题描述

tomcat错误日志如下:## An unexpected error has been detected by HotSpot Virtual Machine:## EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x7c930a19, pid=1168, tid=1936## Java VM: Java HotSpot(TM) Client VM (1.5.0_16-b02 mixed mode)# Problematic frame:# C [ntdll.dll+0x10a19]#--------------- T H R E A D ---------------Current thread (0x0082d500): JavaThread "Finalizer" daemon [_thread_in_native, id=1936]siginfo: ExceptionCode=0xc0000005, reading address 0x0030002dRegisters:EAX=0x0011a358, EBX=0x00080000, ECX=0x0030002d, EDX=0x00350045ESP=0x0ac8f77c, EBP=0x0ac8f788, ESI=0x0011a350, EDI=0x0011a2e0EIP=0x7c930a19, EFLAGS=0x00010246Top of Stack: (sp=0x0ac8f77c)0x0ac8f77c: 00080000 0011a2f0 00000000 0ac8f85c0x0ac8f78c: 7c93084c 00143898 0030002d 0ac8f8400x0ac8f79c: 00000000 00000880 0011a2f8 000000000x0ac8f7ac: 00000000 0082ec44 0ac8f7f0 001438980x0ac8f7bc: 0782de50 0782de50 0014f1f0 000000080x0ac8f7cc: 000801b8 769a2580 00000030 000000280x0ac8f7dc: 0011f1c8 0ac8f800 770f4a64 76ab50340x0ac8f7ec: 0011f1c8 00000008 00000020 00000003 Instructions: (pc=0x7c930a19)0x7c930a09: 85 92 00 00 00 8b 4e 0c 8d 46 08 8b 10 89 4d 0c0x7c930a19: 8b 09 3b 4a 04 89 55 14 0f 85 ea 0f 00 00 3b c8 Stack: [0x0ac50000,0x0ac90000), sp=0x0ac8f77c, free space=253kNative frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code)C [ntdll.dll+0x10a19]C [ntdll.dll+0x1084c]C [ole32.dll+0x12024]C [OLEAUT32.dll+0x2d424]C [OLEAUT32.dll+0x2c12c]C [OLEAUT32.dll+0x4f10]C [OLEAUT32.dll+0x4ea9]C [OLEAUT32.dll+0x4958]C [jacob.dll+0x15dc]j com.jacob.com.Variant.finalize()V+8v ~StubRoutines::call_stubV [jvm.dll+0x875fa]V [jvm.dll+0xdfe2c]V [jvm.dll+0x874cb]V [jvm.dll+0x8ca8e]C [java.dll+0x2006]j java.lang.ref.Finalizer.runFinalizer()V+45j java.lang.ref.Finalizer.access$100(Ljava/lang/ref/Finalizer;)V+1j java.lang.ref.Finalizer$FinalizerThread.run()V+11v ~StubRoutines::call_stubV [jvm.dll+0x875fa]V [jvm.dll+0xdfe2c]V [jvm.dll+0x874cb]V [jvm.dll+0x87228]V [jvm.dll+0xa2093]V [jvm.dll+0x111379]V [jvm.dll+0x111347]C [MSVCRT.dll+0x2a3b0]C [kernel32.dll+0xb699]Java frames: (J=compiled Java code, j=interpreted, Vv=VM code)j com.jacob.com.Variant.release()V+0j com.jacob.com.Variant.finalize()V+8v ~StubRoutines::call_stubj java.lang.ref.Finalizer.invokeFinalizeMethod(Ljava/lang/Object;)V+0j java.lang.ref.Finalizer.runFinalizer()V+45j java.lang.ref.Finalizer.access$100(Ljava/lang/ref/Finalizer;)V+1j java.lang.ref.Finalizer$FinalizerThread.run()V+11v ~StubRoutines::call_stub--------------- P R O C E S S ---------------Java Threads: ( => current thread ) 0x0c9823a0 JavaThread "Thread-28" daemon [_thread_blocked, id=2680] 0x0c913490 JavaThread "File Reaper" daemon [_thread_blocked, id=4368] 0x0c8fe390 JavaThread "AWT-Windows" daemon [_thread_in_native, id=2568] 0x0c8fc440 JavaThread "Java2D Disposer" daemon [_thread_blocked, id=1932] 0x0bf80470 JavaThread "http-8080-19" daemon [_thread_blocked, id=4280] 0x0bf4ee70 JavaThread "http-8080-18" daemon [_thread_blocked, id=4276] 0x0bf798b0 JavaThread "http-8080-17" daemon [_thread_blocked, id=4272] 0x0bf78470 JavaThread "http-8080-16" daemon [_thread_blocked, id=4268] 0x0bf773d0 JavaThread "http-8080-15" daemon [_thread_blocked, id=4264] 0x0bf77690 JavaThread "http-8080-14" daemon [_thread_blocked, id=4260] 0x0bf76e70 JavaThread "http-8080-13" daemon [_thread_blocked, id=4256] 0x0bf74020 JavaThread "http-8080-12" daemon [_thread_blocked, id=4248] 0x0bf69320 JavaThread "http-8080-11" daemon [_thread_blocked, id=1108] 0x0bf45100 JavaThread "http-8080-10" daemon [_thread_blocked, id=3744] 0x0bf56a70 JavaThread "http-8080-9" daemon [_thread_blocked, id=1836] 0x0bf55670 JavaThread "http-8080-8" daemon [_thread_blocked, id=4012] 0x0bf543a0 JavaThread "http-8080-7" daemon [_thread_blocked, id=456] 0x0bf52150 JavaThread "http-8080-6" daemon [_thread_blocked, id=616] 0x0bf523c0 JavaThread "http-8080-5" daemon [_thread_blocked, id=2848] 0x0bf52ca0 JavaThread "http-8080-4" daemon [_thread_blocked, id=1456] 0x0bf51e70 JavaThread "http-8080-3" daemon [_thread_blocked, id=3000] 0x0bf4f990 JavaThread "http-8080-2" daemon [_thread_blocked, id=888] 0x0becc770 JavaThread "http-8080-1" daemon [_thread_blocked, id=2136] 0x0bf02e70 JavaThread "TP-Monitor" daemon [_thread_blocked, id=3776] 0x0bf00470 JavaThread "TP-Processor4" daemon [_thread_in_native, id=3696] 0x0bef9ce0 JavaThread "TP-Processor3" daemon [_thread_blocked, id=2376] 0x0bef6980 JavaThread "TP-Processor2" daemon [_thread_blocked, id=2864] 0x0bef75d0 JavaThread "TP-Processor1" daemon [_thread_blocked, id=564] 0x008a7bd0 JavaThread "http-8080-Acceptor-0" daemon [_thread_in_native, id=924] 0x0089a170 JavaThread "ContainerBackgroundProcessor[StandardEngine[Catalina]]" daemon [_thread_in_native, id=3272] 0x008b75d0 JavaThread "Thread-1" daemon [_thread_blocked, id=1160] 0x008890a0 JavaThread "GC Daemon" daemon [_thread_blocked, id=2688] 0x00844cd0 JavaThread "Low Memory Detector" daemon [_thread_blocked, id=2444] 0x00842550 JavaThread "CompilerThread0" daemon [_thread_blocked, id=3820] 0x00840e20 JavaThread "Signal Dispatcher" daemon [_thread_blocked, id=3968] 0x008370f0 JavaThread "JDWP Command Reader" daemon [_thread_in_native, id=4052] 0x00836370 JavaThread "JDWP Event Helper Thread" daemon [_thread_blocked, id=2576] 0x00835cb0 JavaThread "JDWP Transport Listener: dt_socket" daemon [_thread_in_vm, id=1448]=>0x0082d500 JavaThread "Finalizer" daemon [_thread_in_native, id=1936] 0x0082c250 JavaThread "Reference Handler" daemon [_thread_blocked, id=2400] 0x00823120 JavaThread "main" [_thread_in_native, id=416]Other Threads: 0x0082b530 VMThread [id=2092] 0x00845360 WatcherThread [id=2060]VM state:not at safepoint (normal execution)VM Mutex/Monitor currently owned by a thread: NoneHeap def new generation total 3264K, used 73K [0x02bd0000, 0x02f50000, 0x030b0000) eden space 2944K, 2% used [0x02bd0000, 0x02be25c0, 0x02eb0000) from space 320K, 0% used [0x02eb0000, 0x02eb0000, 0x02f00000) to space 320K, 0% used [0x02f00000, 0x02f00000, 0x02f50000) tenured generation total 42212K, used 19496K [0x030b0000, 0x059e9000, 0x06bd0000) the space 42212K, 46% used [0x030b0000, 0x043ba330, 0x043ba400, 0x059e9000) compacting perm gen total 36608K, used 36359K [0x06bd0000, 0x08f90000, 0x0abd0000) the space 36608K, 99% used [0x06bd0000, 0x08f51dd8, 0x08f51e00, 0x08f90000)No shared spaces configured.Dynamic libraries:0x00400000 - 0x0040d000 C:javajre1.5.0_16binjavaw.exe0x7c920000 - 0x7c9b6000 C:WINDOWSsystem32ntdll.dll0x7c800000 - 0x7c91d000 C:WINDOWSsystem32kernel32.dll0x77da0000 - 0x77e49000 C:WINDOWSsystem32ADVAPI32.dll0x77e50000 - 0x77ee2000 C:WINDOWSsystem32RPCRT4.dll0x77fc0000 - 0x77fd1000 C:WINDOWSsystem32Secur32.dll0x77d10000 - 0x77d9f000 C:WINDOWSsystem32USER32.dll0x77ef0000 - 0x77f38000 C:WINDOWSsystem32GDI32.dll0x77be0000 - 0x77c38000 C:WINDOWSsystem32MSVCRT.dll0x76300000 - 0x7631d000 C:WINDOWSsystem32IMM32.DLL0x62c20000 - 0x62c29000 C:WINDOWSsystem32LPK.DLL0x73fa0000 - 0x7400b000 C:WINDOWSsystem32USP10.dll0x6d640000 - 0x6d7de000 C:javajre1.5.0_16binclientjvm.dll0x76b10000 - 0x76b3a000 C:WINDOWSsystem32WINMM.dll0x6d290000 - 0x6d298000 C:javajre1.5.0_16binhpi.dll0x76bc0000 - 0x76bcb000 C:WINDOWSsystem32PSAPI.DLL0x6d390000 - 0x6d3c5000 C:javajre1.5.0_16binjdwp.dll0x6d610000 - 0x6d61c000 C:javajre1.5.0_16binverify.dll0x6d310000 - 0x6d32d000 C:javajre1.5.0_16binjava.dll0x6d630000 - 0x6d63f000 C:javajre1.5.0_16binzip.dll0x6d220000 - 0x6d227000 C:javajre1.5.0_16bindt_socket.dll0x71a20000 - 0x71a37000 C:WINDOWSsystem32WS2_32.dll0x71a10000 - 0x71a18000 C:WINDOWSsystem32WS2HELP.dll0x719c0000 - 0x719fe000 C:WINDOWSSystem32mswsock.dll0x76ef0000 - 0x76f17000 C:WINDOWSsystem32DNSAPI.dll0x76f80000 - 0x76f88000 C:WINDOWSSystem32winrnr.dll0x76f30000 - 0x76f5c000 C:WINDOWSsystem32WLDAP32.dll0x64000000 - 0x64025000 C:Program FilesBonjourmdnsNSP.dll0x76d30000 - 0x76d48000 C:WINDOWSsystem32Iphlpapi.dll0x76f90000 - 0x76f96000 C:WINDOWSsystem32rasadhlp.dll0x60fd0000 - 0x61025000 C:WINDOWSsystem32hnetcfg.dll0x71a00000 - 0x71a08000 C:WINDOWSSystem32wshtcpip.dll0x6d4c0000 - 0x6d4c8000 C:javajre1.5.0_16binmanagement.dll0x6d190000 - 0x6d1bf000 C:javajre1.5.0_16bincmm.dll0x6d3d0000 - 0x6d3ef000 C:javajre1.5.0_16binjpeg.dll0x6d4d0000 - 0x6d4e3000 C:javajre1.5.0_16binnet.dll0x6d000000 - 0x6d16d000 C:javajre1.5.0_16binawt.dll0x72f70000 - 0x72f96000 C:WINDOWSsystem32WINSPOOL.DRV0x76990000 - 0x76acc000 C:WINDOWSsystem32ole32.dll0x5adc0000 - 0x5adf7000 C:WINDOWSsystem32uxtheme.dll0x736d0000 - 0x73719000 C:WINDOWSsystem32ddraw.dll0x73b30000 - 0x73b36000 C:WINDOWSsystem32DCIMAN32.dll0x6d240000 - 0x6d290000 C:javajre1.5.0_16binfontmanager.dll0x74680000 - 0x746cb000 C:WINDOWSsystem32MSCTF.dll0x73640000 - 0x7366e000 C:WINDOWSsystem32msctfime.ime0x6d4f0000 - 0x6d4f9000 C:javajre1.5.0_16binnio.dll0x0ffd0000 - 0x0fff8000 C:WINDOWSsystem32rsaenh.dll0x759d0000 - 0x75a7e000 C:WINDOWSsystem32USERENV.dll0x5fdd0000 - 0x5fe24000 C:WINDOWSsystem32netapi32.dll0x10000000 - 0x10018000 C:javajre1.5.0_16binjacob.dll0x770f0000 - 0x7717c000 C:WINDOWSsystem32OLEAUT32.dll0x76fa0000 - 0x7701f000 C:WINDOWSsystem32CLBCATQ.DLL0x77020000 - 0x770ba000 C:WINDOWSsystem32COMRes.dll0x77bd0000 - 0x77bd8000 C:WINDOWSsystem32VERSION.dll0x0cce0000 - 0x0cfa6000 C:WINDOWSsystem32msi.dll0x20000000 - 0x20549000 C:WINDOWSsystem32xpsp2res.dll0x0d070000 - 0x0d475000 D:dllPrnSheetDll.dll0x5d170000 - 0x5d207000 C:WINDOWSsystem32comctl32.dll0x7d590000 - 0x7dd83000 C:WINDOWSsystem32shell32.dll0x77f40000 - 0x77fb6000 C:WINDOWSsystem32SHLWAPI.dll0x76320000 - 0x76367000 C:WINDOWSsystem32comdlg32.dll0x77180000 - 0x77282000 C:WINDOWSWinSxSx86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2180_x-ww_a84f1ff9comctl32.dll0x5efe0000 - 0x5eff7000 C:WINDOWSsystem32olepro32.dll0x75e00000 - 0x75eae000 C:WINDOWSsystem32SXS.DLL0x4dd10000 - 0x4dd93000 C:Program FilesCommon FilesSystemadomsado15.dll0x75b50000 - 0x75b75000 C:WINDOWSsystem32MSDART.DLL0x1b5d0000 - 0x1b665000 C:WINDOWSsystem32MSWSTR10.DLL0x72d70000 - 0x72de7000 C:Program FilesCommon FilesSystemOle DBoledb32.dll0x74fa0000 - 0x74fb1000 C:Program FilesCommon FilesSystemOle DBOLEDB32R.DLL0x0d8e0000 - 0x0d94d000 D:oracleproduct10.2.0db_1binOraOLEDB10.DLL0x44100000 - 0x44120000 D:oracleproduct10.2.0db_1binOraOLEDBgmr10.dll0x61c20000 - 0x61e72000 D:oracleproduct10.2.0db_1binoraclient10.dll0x60870000 - 0x60953000 D:oracleproduct10.2.0db_1binoracore10.dll0x60a80000 - 0x60b44000 D:oracleproduct10.2.0db_1binoranls10.dll0x63690000 - 0x636a8000 D:oracleproduct10.2.0db_1binoraunls10.dll0x7c340000 - 0x7c396000 D:oracleproduct10.2.0db_1binMSVCR71.dll0x60eb0000 - 0x60eb7000 D:oracleproduct10.2.0db_1binorauts.dll0x636b0000 - 0x636b6000 D:oracleproduct10.2.0db_1binoravsn10.dll0x0d950000 - 0x0da42000 D:oracleproduct10.2.0db_1binoracommon10.dll0x60300000 - 0x60857000 D:oracleproduct10.2.0db_1binorageneric10.dll0x63430000 - 0x63457000 D:oracleproduct10.2.0db_1binorasnls10.dll0x0da50000 - 0x0dbb0000 D:oracleproduct10.2.0db_1binoraxml10.dll0x0dbb0000 - 0x0dbc1000 C:WINDOWSsystem32MSVCIRT.dll0x60960000 - 0x60a6d000 D:oracleproduct10.2.0db_1binoran10.dll0x62740000 - 0x6277d000 D:oracleproduct10.2.0db_1binoranl10.dll0x62790000 - 0x627a7000 D:oracleproduct10.2.0db_1binoranldap10.dll0x627f0000 - 0x628f9000 D:oracleproduct10.2.0db_1binorannzsbb10.dll0x62530000 - 0x62583000 D:oracleproduct10.2.0db_1binoraldapclnt10.dll0x62670000 - 0x6268b000 D:oracleproduct10.2.0db_1binorancrypt10.dll0x71a40000 - 0x71a4b000 C:WINDOWSsystem32WSOCK32.dll0x62920000 - 0x6296c000 D:oracleproduct10.2.0db_1binoranro10.dll0x626b0000 - 0x626b7000 D:oracleproduct10.2.0db_1binoranhost10.dll0x62660000 - 0x62666000 D:oracleproduct10.2.0db_1binorancds10.dll0x629c0000 - 0x629c8000 D:oracleproduct10.2.0db_1binorantns10.dll0x60b50000 - 0x60ea8000 D:oracleproduct10.2.0db_1binorapls10.dll0x0dbd0000 - 0x0dbd9000 D:oracleproduct10.2.0db_1binoraslax10.dll0x63080000 - 0x63284000 D:oracleproduct10.2.0db_1binoraplp10.dll0x61ed0000 - 0x61f5b000 D:oracleproduct10.2.0db_1binorahasgen10.dll0x62ab0000 - 0x62b1a000 D:oracleproduct10.2.0db_1binoraocr10.dll0x62b20000 - 0x62b60000 D:oracleproduct10.2.0db_1binoraocrb10.dll0x62980000 - 0x62990000 D:oracleproduct10.2.0db_1binorantcp10.dll0x0dbe0000 - 0x0dc7a000 D:oracleproduct10.2.0db_1binorasql10.dll0x44400000 - 0x44423000 D:oracleproduct10.2.0db_1binOraOLEDBrst10.dll0x44700000 - 0x44707000 D:oracleproduct10.2.0db_1binOraOLEDButl10.dll0x44300000 - 0x44306000 D:oracleproduct10.2.0db_1binOraOLEDB10zhs.dll0x44200000 - 0x44208000 D:oracleproduct10.2.0db_1binOraOLEDBpus10.dll0x75690000 - 0x757ca000 C:WINDOWSsystem32comsvcs.dll0x75050000 - 0x75063000 C:WINDOWSsystem32MTXCLU.DLL0x75090000 - 0x750a4000 C:WINDOWSsystem32colbact.DLL0x762a0000 - 0x762b1000 C:WINDOWSsystem32CLUSAPI.DLL0x75010000 - 0x75022000 C:WINDOWSsystem32RESUTILS.DLL0x71f00000 - 0x71f04000 C:WINDOWSsystem32security.dll0x77c40000 - 0x77c64000 C:WINDOWSsystem32msv1_0.dll0x76760000 - 0x7676c000 C:WINDOWSsystem32cryptdll.dll0x72df0000 - 0x72e41000 C:Program FilesCommon FilesSystemmsadcmsadce.dll0x0e590000 - 0x0e595000 C:Program FilesCommon FilesSystemmsadcmsadcer.dll0x0e5d0000 - 0x0e5d6000 C:Program FilesCommon FilesSystemadomsader15.dllVM Arguments:jvm_args: -agentlib:jdwp=transport=dt_socket,suspend=y,address=localhost:1666 -Dcatalina.home=D:tomcat-6.0.24 -Djava.endorsed.dirs=D:tomcat-6.0.24endorsed -Dcatalina.base=D:tomcat-6.0.24 -Djava.io.tmpdir=D:tomcat-6.0.24temp -Dfile.encoding=UTF-8java_command: org.apache.catalina.startup.Bootstrap startLauncher Type: SUN_STANDARDEnvironment Variables:JAVA_HOME=C:javajdk1.5.0_16CLASSPATH=.;C:javajdk1.5.0_16dt.jar; C:javajdk1.5.0_16libtools.jar; ;C:Program FilesJavajre6libextQTJava.zipPATH=C:/Program Files/Java/jre6/bin/client;C:/Program Files/Java/jre6/bin;D:oracleproduct10.2.0db_1bin;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;C:Program FilesATI TechnologiesATI.ACECore-Static;C:Program FilesThinkPad Wireless LAN Adapter Software;C:Program FilesCommon FilesThunder NetworkKanKanCodecs;C:Program FilesIntelWiFibin;C:javaJDK1.5.0bin;C:Program FilesTortoiseSVNbin;C:javajdk1.5.0_16bin;C:javajdk1.5.0_16jrebin;D:tomcat-6.0.24bin;C:Program FilesQuickTimeQTSystem;C:Program FilesStormIICodec;C:Program FilesStormIIUSERNAME=thinkOS=Windows_NTPROCESSOR_IDENTIFIER=x86 Family 6 Model 23 Stepping 10, GenuineIntel--------------- S Y S T E M ---------------OS: Windows XP Build 2600 Service Pack 2CPU:total 2 (cores per cpu 2, threads per core 1) family 6 model 7 stepping 10, cmov, cx8, fxsr, mmx, sse, sse2Memory: 4k page, physical 1958696k(57748k free), swap 3897560k(1530344k free)vm_info: Java HotSpot(TM) Client VM (1.5.0_16-b02) for windows-x86, built on May 28 2008 01:04:49 by "java_re" with MS VC++ 6.0

解决方案

把Tomcat的内存设大点 我博客有相关文章

时间: 2024-11-03 00:46:56

从excel导入1000多条数据到oracle数据库时,java内存溢出,tomcat报错的相关文章

JdbcTemplate插入一条数据到Oracle数据库并返回自增长ID

问题描述 我的需求就是需要循环插入一组数据,因为数据库是按照自增长ID关联的,所以每插入一条数据,都要返回自增长的ID,用来设置关联关系,我用JdbcTemplate可以实现一组数据的插入并返回ID,但是循环两次以上就出错了:org.springframework.jdbc.UncategorizedSQLException:PreparedStatementCallback;uncategorizedSQLExceptionforSQL[insertintoT_METADATA_ABSTRAC

spark从mysql数据库读取1000万条数据 运行速度很慢 如何优化

问题描述 spark从mysql数据库读取1000万条数据 运行速度很慢 如何优化 使用dataframe从mysql数据库中读取一张有1000万条记录的表 读取数据非常的慢 有什么办法能优化呢 求助啊 级 解决方案 http://book.51cto.com/art/201409/453045.htm 解决方案二: MySQL数据库运行状态数据的采集----------------------

mysql快速导入5000万条数据过程记录(LOAD DATA INFILE方式)

mysql快速导入5000万条数据过程记录(LOAD DATA INFILE方式) 首先将要导入的数据文件top5000W.txt放入到数据库数据目录/var/local/mysql/data/${db_name}/ 下,并确保导入用户拥有这个txt文件的权限,否则会报Error 13错误 1.${table_name}换myisam,我们的场景对事务没啥要求,innodb引擎速度太慢了,原来导入12个小时都没导完 2.导入前修改参数和禁止索引更新mysql> SET SESSION BULK_

将excel导入到一个dataset数据集中 如何删除其中我不想要的数据

问题描述 将excel导入到一个dataset数据集中如何删除其中我不想要的数据 解决方案 解决方案二:遍历dataset.Tables[0]这个,然后取出你想要的

探讨如何在有着1000万条数据的MS SQL SERVER数据库中实现快速的数据提取和数据分页

探讨如何在有着1000万条数据的MS SQL SERVER数据库中实现快速的数据提取和数据分页.以下代码说明了我们实例中数据库的一表的部分数据结构: CREATE TABLE [dbo].[TGongwen] (    --TGongwen是红头文件表名    [Gid] [int] IDENTITY (1, 1) NOT NULL ,--本表的id号,也是主键    [title] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,  --红头文件的

100万条数据存入mongo,通过java代码实现,要求时间在5秒之内,或者越快越好

问题描述 100万条数据存入mongo,通过java代码实现,要求时间在5秒之内,或者越快越好 通过java代码将oracle中的100万条数据查询出来,然后直接插入mongo数据库中,要求时间越短越好.我从oracle中将100万条数据查询出来花费了3秒左右.希望存入mongo的时间在5秒以内.请问各位大神有没有好的办法,谢谢. 解决方案 你可以买一个性能好一些的电脑,这样会比较快的. 解决方案二: 你把oracle查询到的数据分下类,优化时间在2秒内,存到Mongo可能会快点,最近公司也是遇

easyui-关于easyUI里面的Datebox ,新建一条数据并存入数据库,有一个字段关于时间

问题描述 关于easyUI里面的Datebox ,新建一条数据并存入数据库,有一个字段关于时间 关于easyUI里面的Datebox ,新建一条数据并存入数据库,有一个字段关于时间,用Datebox,但是在调用后台增加方法的时候,却显示获取不到Datebox中的值 该如何解决额 解决方案 http://blog.sina.com.cn/s/blog_866c5a5d01019zo3.html

ASP.NET中如何将decimal 类型的数据 存在 ORACLE数据库

问题描述 ASP.NET中如何将decimal类型的数据存在ORACLE数据库 解决方案 解决方案二:Oracle数据库中Number类型的参数的值可以用.NETdecimal或System.Data.OracleClient.OracleNumber类型指定:Integer类型的参数的值可以用.NETint或OracleNumber类型指定解决方案三:NUMBER12,7

Excel导入oracle数据,oracle数据库导出excel方法

导出 导出的话,在PL/SQL的SQL Window中查询结果中选中查询结果右单击就有 COPY TO EXCEL这个选择的 导入 方法一 以下的文章主要是介绍如何用SQL*Loader将Excel相关的数据导出到Oracle数据库,其主要的目的是实现往Oracle数据库里插入excel相关文件中的实际应用数据,以下就是文章的具体内容的介绍. 实现步骤: 1.打开MicroSoft Excel 2.文件(F)→新建(N)→工作簿→ 3.输入SQL*Loader将Excel数据后,存盘为test.