﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>BlogJava-天道酬勤-最新评论</title><link>http://www.blogjava.net/snoopy/CommentsRSS.aspx</link><description>没有成功，说明努力还不够！</description><language>zh-cn</language><pubDate>Thu, 27 Jan 2005 02:15:16 GMT</pubDate><lastBuildDate>Thu, 27 Jan 2005 02:15:16 GMT</lastBuildDate><generator>cnblogs</generator><item><title>re: 关于ORACLE游标的问题(ORA-01000: maximum open cursors exceeded)</title><link>http://www.blogjava.net/snoopy/archive/2007/01/11/744.html#93071</link><dc:creator>子圆</dc:creator><author>子圆</author><pubDate>Thu, 11 Jan 2007 01:55:00 GMT</pubDate><guid>http://www.blogjava.net/snoopy/archive/2007/01/11/744.html#93071</guid><description><![CDATA[啊~!~`我刚也犯了这种错误!!``看到这里的贴子,小妹又明白了:&quot;哦!``原来conn.createStatement()和conn.prepareStatement()的时候实际上都是相当与在数据库中打开了一个cursor。!!&quot;明白了这点过后,我就在循环里新建一个prepareStatement对象,操作完一次,成功过后就马上关掉!这样,循环里每次一个insert都新new 一个prepareStatement 操作成功完成之后再马上关闭.嘎嘎.~这样,cursor就不会溢出拉.<img src ="http://www.blogjava.net/snoopy/aggbug/93071.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/snoopy/" target="_blank">子圆</a> 2007-01-11 09:55 <a href="http://www.blogjava.net/snoopy/archive/2007/01/11/744.html#93071#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>re: 关于ORACLE游标的问题(ORA-01000: maximum open cursors exceeded)</title><link>http://www.blogjava.net/snoopy/archive/2006/06/18/744.html#53611</link><dc:creator>JXPROVINCE</dc:creator><author>JXPROVINCE</author><pubDate>Sun, 18 Jun 2006 09:42:00 GMT</pubDate><guid>http://www.blogjava.net/snoopy/archive/2006/06/18/744.html#53611</guid><description><![CDATA[我也是同样的问题，但我开发语言是用ＤＥＬＰＨＩ，使用组件是ＡＤＯＱＵＥＲＹ，游标超过最大数困扰我好久了，如果有谁知道，请告之jxprovince@mail.china.com<img src ="http://www.blogjava.net/snoopy/aggbug/53611.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/snoopy/" target="_blank">JXPROVINCE</a> 2006-06-18 17:42 <a href="http://www.blogjava.net/snoopy/archive/2006/06/18/744.html#53611#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>re: 关于ORACLE游标的问题(ORA-01000: maximum open cursors exceeded)</title><link>http://www.blogjava.net/snoopy/archive/2006/06/01/744.html#49384</link><dc:creator>sheen </dc:creator><author>sheen </author><pubDate>Wed, 31 May 2006 19:58:00 GMT</pubDate><guid>http://www.blogjava.net/snoopy/archive/2006/06/01/744.html#49384</guid><description><![CDATA[不是将查询结果一次性放到ResultSet中, 而是分批放入ResultSet中,一般情况下是每次10条记录.<br>当通过ResultSet.next()，移动结果集指针时，此时还会与数据库发生交互.<br><br>导致maximum open cursors exceeded这个问题一般是代码本身的问题.<br>比如执行一个查询没有关闭游标，或是在存储过程中打开了游标而没有关闭．<br>特别是出现异常情况是没有关闭游标．严重时会导致系统崩掉<img src ="http://www.blogjava.net/snoopy/aggbug/49384.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/snoopy/" target="_blank">sheen </a> 2006-06-01 03:58 <a href="http://www.blogjava.net/snoopy/archive/2006/06/01/744.html#49384#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>re: 关于ORACLE游标的问题(ORA-01000: maximum open cursors exceeded)</title><link>http://www.blogjava.net/snoopy/archive/2006/05/18/744.html#46833</link><dc:creator>顺哥</dc:creator><author>顺哥</author><pubDate>Thu, 18 May 2006 07:51:00 GMT</pubDate><guid>http://www.blogjava.net/snoopy/archive/2006/05/18/744.html#46833</guid><description><![CDATA[一搜索这个问题竟然到了你的blog，真是冤孽啊。。：）<img src ="http://www.blogjava.net/snoopy/aggbug/46833.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/snoopy/" target="_blank">顺哥</a> 2006-05-18 15:51 <a href="http://www.blogjava.net/snoopy/archive/2006/05/18/744.html#46833#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>re: 关于ORACLE游标的问题(ORA-01000: maximum open cursors exceeded)</title><link>http://www.blogjava.net/snoopy/archive/2006/05/18/744.html#46831</link><dc:creator>顺哥</dc:creator><author>顺哥</author><pubDate>Thu, 18 May 2006 07:50:00 GMT</pubDate><guid>http://www.blogjava.net/snoopy/archive/2006/05/18/744.html#46831</guid><description><![CDATA[晕。。。。。。。。。<img src ="http://www.blogjava.net/snoopy/aggbug/46831.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/snoopy/" target="_blank">顺哥</a> 2006-05-18 15:50 <a href="http://www.blogjava.net/snoopy/archive/2006/05/18/744.html#46831#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>re: 关于ORACLE游标的问题(ORA-01000: maximum open cursors exceeded)</title><link>http://www.blogjava.net/snoopy/archive/2006/05/12/744.html#45840</link><dc:creator>感谢</dc:creator><author>感谢</author><pubDate>Fri, 12 May 2006 07:00:00 GMT</pubDate><guid>http://www.blogjava.net/snoopy/archive/2006/05/12/744.html#45840</guid><description><![CDATA[非常感谢!<img src ="http://www.blogjava.net/snoopy/aggbug/45840.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/snoopy/" target="_blank">感谢</a> 2006-05-12 15:00 <a href="http://www.blogjava.net/snoopy/archive/2006/05/12/744.html#45840#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>re: 关于ORACLE游标的问题(ORA-01000: maximum open cursors exceeded)</title><link>http://www.blogjava.net/snoopy/archive/2006/05/08/744.html#44947</link><dc:creator>阿黑</dc:creator><author>阿黑</author><pubDate>Mon, 08 May 2006 01:27:00 GMT</pubDate><guid>http://www.blogjava.net/snoopy/archive/2006/05/08/744.html#44947</guid><description><![CDATA[白是对的。<img src ="http://www.blogjava.net/snoopy/aggbug/44947.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/snoopy/" target="_blank">阿黑</a> 2006-05-08 09:27 <a href="http://www.blogjava.net/snoopy/archive/2006/05/08/744.html#44947#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>re: 关于ORACLE游标的问题(ORA-01000: maximum open cursors exceeded)</title><link>http://www.blogjava.net/snoopy/archive/2006/03/17/744.html#35785</link><dc:creator>白</dc:creator><author>白</author><pubDate>Fri, 17 Mar 2006 02:44:00 GMT</pubDate><guid>http://www.blogjava.net/snoopy/archive/2006/03/17/744.html#35785</guid><description><![CDATA[交互，如果1个查询有10000条记录，resultset中只有fetchsize条，当next时还会在一定时机去交互<img src ="http://www.blogjava.net/snoopy/aggbug/35785.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/snoopy/" target="_blank">白</a> 2006-03-17 10:44 <a href="http://www.blogjava.net/snoopy/archive/2006/03/17/744.html#35785#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>re: 关于ORACLE游标的问题(ORA-01000: maximum open cursors exceeded)</title><link>http://www.blogjava.net/snoopy/archive/2006/03/15/744.html#35359</link><dc:creator>jing</dc:creator><author>jing</author><pubDate>Wed, 15 Mar 2006 02:26:00 GMT</pubDate><guid>http://www.blogjava.net/snoopy/archive/2006/03/15/744.html#35359</guid><description><![CDATA[当通过ResultSet.next()，移动结果集指针时，此时是否还与数据库发生交互？<br><br>不发生交互，数据库执行完查询后，已经把查询结果交给ResultSet了，以后的操作，和数据库无关。<img src ="http://www.blogjava.net/snoopy/aggbug/35359.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/snoopy/" target="_blank">jing</a> 2006-03-15 10:26 <a href="http://www.blogjava.net/snoopy/archive/2006/03/15/744.html#35359#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>re: 关于ORACLE游标的问题(ORA-01000: maximum open cursors exceeded)</title><link>http://www.blogjava.net/snoopy/archive/2006/03/14/744.html#35175</link><dc:creator>白</dc:creator><author>白</author><pubDate>Tue, 14 Mar 2006 01:42:00 GMT</pubDate><guid>http://www.blogjava.net/snoopy/archive/2006/03/14/744.html#35175</guid><description><![CDATA[首先结果集resultset在你的java程序处。其中有个fetchsize设置，这个表示每次从数据库处取多少条记录到resultset.<img src ="http://www.blogjava.net/snoopy/aggbug/35175.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/snoopy/" target="_blank">白</a> 2006-03-14 09:42 <a href="http://www.blogjava.net/snoopy/archive/2006/03/14/744.html#35175#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>