java.lang.ArrayIndexOutOfBoundsException
Hi, I am getting the following error but no information as to where the error is occurring. java.lang.ArrayIndexOutOfBoundsException This is a massive function. I am prepared to walk through the code step by step to find the error but wondering why it wasn't giving me the line of code that is causing the error and if there is anyway to find out. Thanks, Richard ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355510 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: java.lang.ArrayIndexOutOfBoundsException
Have you checked the log files? Got a stack trace? On 19 April 2013 13:58, Richard White rich...@re-base.net wrote: Hi, I am getting the following error but no information as to where the error is occurring. java.lang.ArrayIndexOutOfBoundsException This is a massive function. I am prepared to walk through the code step by step to find the error but wondering why it wasn't giving me the line of code that is causing the error and if there is anyway to find out. Thanks, Richard ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: java.lang.ArrayIndexOutOfBoundsException
Hi Will, I just checked the log and it doesn't provide a message or stack trace. The only thing is says is: The specific sequence of files included or processed is: #url for file# Have you checked the log files? Got a stack trace? On 19 April 2013 13:58, Richard White rich...@re-base.net wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error 0 - java.lang.ArrayIndexOutOfBoundsException
Try dumping the query the the QoQ is using. I bet it's something in there. Just a guess. On 9/23/06, Loyd Campbell [EMAIL PROTECTED] wrote: When I comment out the display of the QoQ that throws the error, the report displays fine. That is essentially the same thing as dumping the initial query, along with 4 other QoQs. I didn't see any data that looked suspicious. Changing the dates for the report, as long as the cfif sets the TableName variable to SHIP_HIST_ARC the error occurs. Thus, I really don't think the problem is with the data in the _ARC table. Thanks for the try. Any other ideas? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254020 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Error 0 - java.lang.ArrayIndexOutOfBoundsException
In standard SQL, I know that when you do a SELECT COUNT() you ALWAYS get back a row. However, in ColdFusion query of queries, if you do a SELECT COUNT() on a table that has no rows, the query -of-queries table actually does not return any rows. It is possible that you are expecting a value of 0 (zero) as the count, but in fact, the query of queries has a record count of Zero?? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Loyd Campbell [mailto:[EMAIL PROTECTED] Sent: Saturday, September 23, 2006 3:02 PM To: CF-Talk Subject: Error 0 - java.lang.ArrayIndexOutOfBoundsException I'm querying data that is contained in either a current table, SHIP_HIST, or an archive table, SHIP_HIST_ARC. There is a view setup on the server, SHIP_HIST_VIEW, that does a union on both tables so if a user wants to query both old and new data they may. A nightly stored procedure moves records from current to archive tables based on age, so there is no duplication of records between the two tables. The current table is kept fairly small so most queries can be done quickly. The current version of the report I am working on always queries the view, regardless of what dates the user is looking for. This is a very slow process due to the large number of records in the view. In order to speed up the queries, I am running a quick query to determine the oldest date in the current table, and as a result of that I name a variable TableName. If the begin and end dates the user is looking for are entirely within the current table, TableName is SHIP_HIST. If the begin and end dates are both before the oldest date in the current table, the TableName variable is SHIP_HIST_ARC. If the begin and end dates span the oldest date in the current table, then I name TableName SHIP_HIST_VIEW. This query works fine every time. Then, I run queries against this initial query to get some subtotals and grand totals. My problem is that when the initial query is run against either SHIP_HIST or SHIP_HIST_VIEW, it runs fine. If the initial query is run against the SHIP_HIST_ARC table, ColdFusion throws an error; The header on the debug page is Error Occurred While Processing Request. The data is a single zero (0). Below that is the area that shows the filename where the error occurs and then show where this data is being called from. I have all the queries in separate files so the error is occurring in ShipHist5.qry. Here is the text of that query: CFQUERY NAME=#QueryName# DBType=query SELECT count(distinct mst_ship_num) AS mst_shp_tot_qty FROM ShipHist /CFQUERY As I said, it runs fine when the initial query is run against either the current table or the view, but not the archive table. It would make more sense to me if the error came from Oracle, but it is a CF error. Down in the Exceptions area of debug here is the error message: Exceptions 13:37:54.054 - java.lang.ArrayIndexOutOfBoundsException - in D:\inetpub\wwwroot\dev\DMPlusReports\queries\ShipHist5.qry : line 12 0 Can anyone make any sense of this error? I have used the same technique to speed up other reports that were originally written against the view and have had no problems. This one has me stumped. I'd sure appreciate anyone who might have an idea what is going on here. Thanks, Loyd Campbell Contract CF Programmer Plano, TX ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254034 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Error 0 - java.lang.ArrayIndexOutOfBoundsException
Nice shot Ben. Another longshot: with the underscore notation, fields ending like _date or _someOtherReserved extension can do weird stuff, because they're reserved in CF IIRC. -denny On 9/25/06, Ben Nadel [EMAIL PROTECTED] wrote: In standard SQL, I know that when you do a SELECT COUNT() you ALWAYS get back a row. However, in ColdFusion query of queries, if you do a SELECT COUNT() on a table that has no rows, the query -of-queries table actually does not return any rows. It is possible that you are expecting a value of 0 (zero) as the count, but in fact, the query of queries has a record count of Zero?? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Loyd Campbell [mailto:[EMAIL PROTECTED] Sent: Saturday, September 23, 2006 3:02 PM To: CF-Talk Subject: Error 0 - java.lang.ArrayIndexOutOfBoundsException I'm querying data that is contained in either a current table, SHIP_HIST, or an archive table, SHIP_HIST_ARC. There is a view setup on the server, SHIP_HIST_VIEW, that does a union on both tables so if a user wants to query both old and new data they may. A nightly stored procedure moves records from current to archive tables based on age, so there is no duplication of records between the two tables. The current table is kept fairly small so most queries can be done quickly. The current version of the report I am working on always queries the view, regardless of what dates the user is looking for. This is a very slow process due to the large number of records in the view. In order to speed up the queries, I am running a quick query to determine the oldest date in the current table, and as a result of that I name a variable TableName. If the begin and end dates the user is looking for are entirely within the current table, TableName is SHIP_HIST. If the begin and end dates are both before the oldest date in the current table, the TableName variable is SHIP_HIST_ARC. If the begin and end dates span the oldest date in the current table, then I name TableName SHIP_HIST_VIEW. This query works fine every time. Then, I run queries against this initial query to get some subtotals and grand totals. My problem is that when the initial query is run against either SHIP_HIST or SHIP_HIST_VIEW, it runs fine. If the initial query is run against the SHIP_HIST_ARC table, ColdFusion throws an error; The header on the debug page is Error Occurred While Processing Request. The data is a single zero (0). Below that is the area that shows the filename where the error occurs and then show where this data is being called from. I have all the queries in separate files so the error is occurring in ShipHist5.qry. Here is the text of that query: CFQUERY NAME=#QueryName# DBType=query SELECT count(distinct mst_ship_num) AS mst_shp_tot_qty FROM ShipHist /CFQUERY As I said, it runs fine when the initial query is run against either the current table or the view, but not the archive table. It would make more sense to me if the error came from Oracle, but it is a CF error. Down in the Exceptions area of debug here is the error message: Exceptions 13:37:54.054 - java.lang.ArrayIndexOutOfBoundsException - in D:\inetpub\wwwroot\dev\DMPlusReports\queries\ShipHist5.qry : line 12 0 Can anyone make any sense of this error? I have used the same technique to speed up other reports that were originally written against the view and have had no problems. This one has me stumped. I'd sure appreciate anyone who might have an idea what is going on here. Thanks, Loyd Campbell Contract CF Programmer Plano, TX ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Error 0 - java.lang.ArrayIndexOutOfBoundsException
I'm querying data that is contained in either a current table, SHIP_HIST, or an archive table, SHIP_HIST_ARC. There is a view setup on the server, SHIP_HIST_VIEW, that does a union on both tables so if a user wants to query both old and new data they may. A nightly stored procedure moves records from current to archive tables based on age, so there is no duplication of records between the two tables. The current table is kept fairly small so most queries can be done quickly. The current version of the report I am working on always queries the view, regardless of what dates the user is looking for. This is a very slow process due to the large number of records in the view. In order to speed up the queries, I am running a quick query to determine the oldest date in the current table, and as a result of that I name a variable TableName. If the begin and end dates the user is looking for are entirely within the current table, TableName is SHIP_HIST. If the begin and end dates are both before the oldest date in the current table, the TableName variable is SHIP_HIST_ARC. If the begin and end dates span the oldest date in the current table, then I name TableName SHIP_HIST_VIEW. This query works fine every time. Then, I run queries against this initial query to get some subtotals and grand totals. My problem is that when the initial query is run against either SHIP_HIST or SHIP_HIST_VIEW, it runs fine. If the initial query is run against the SHIP_HIST_ARC table, ColdFusion throws an error; The header on the debug page is Error Occurred While Processing Request. The data is a single zero (0). Below that is the area that shows the filename where the error occurs and then show where this data is being called from. I have all the queries in separate files so the error is occurring in ShipHist5.qry. Here is the text of that query: CFQUERY NAME=#QueryName# DBType=query SELECT count(distinct mst_ship_num) AS mst_shp_tot_qty FROM ShipHist /CFQUERY As I said, it runs fine when the initial query is run against either the current table or the view, but not the archive table. It would make more sense to me if the error came from Oracle, but it is a CF error. Down in the Exceptions area of debug here is the error message: Exceptions 13:37:54.054 - java.lang.ArrayIndexOutOfBoundsException - in D:\inetpub\wwwroot\dev\DMPlusReports\queries\ShipHist5.qry : line 12 0 Can anyone make any sense of this error? I have used the same technique to speed up other reports that were originally written against the view and have had no problems. This one has me stumped. I'd sure appreciate anyone who might have an idea what is going on here. Thanks, Loyd Campbell Contract CF Programmer Plano, TX ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253978 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error 0 - java.lang.ArrayIndexOutOfBoundsException
Try dumping the query the the QoQ is using. I bet it's something in there. Just a guess. On 9/23/06, Loyd Campbell [EMAIL PROTECTED] wrote: I'm querying data that is contained in either a current table, SHIP_HIST, or an archive table, SHIP_HIST_ARC. There is a view setup on the server, SHIP_HIST_VIEW, that does a union on both tables so if a user wants to query both old and new data they may. A nightly stored procedure moves records from current to archive tables based on age, so there is no duplication of records between the two tables. The current table is kept fairly small so most queries can be done quickly. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253981 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
java.lang.ArrayIndexOutOfBoundsException
Hi, I have a large amount of data which I am trying to insert in a Shopping cart array. The array is declared is _javascript_. I get the following runtime error. java.lang.ArrayIndexOutOfBoundsException at java.net.SocketInputStream.read(SocketInputStream.java:121) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.readPacketIntoPrimaryBuffer(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes(Unknown Source) at macromedia.util.UtilPagedTempBuffer.write(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.getColumnDataForRow(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplResultSet.getData(Unknown Source) at macromedia.jdbc.base.BaseResultSet.getObject(Unknown Source) at coldfusion.sql.QueryTable.populate(QueryTable.java:272) at coldfusion.sql.Executive.getRowSets(Executive.java:559) at coldfusion.sql.Executive.executeCall(Executive.java:814) at coldfusion.sql.Executive.executeCall(Executive.java:749) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:313) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:192) at cfshoppingCart2ecfm1340170321.runPage(D:\inetpub\CurtisCustomTags\shoppingCart.cfm:44) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:60) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:256) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1881) at cfitemDetails2ecfm1913841519._factor26(D:\inetpub\curtisdirect\ORDER\itemDetails.cfm:883) at cfitemDetails2ecfm1913841519._factor35(D:\inetpub\curtisdirect\ORDER\itemDetails.cfm:403) at cfitemDetails2ecfm1913841519._factor36(D:\inetpub\curtisdirect\ORDER\itemDetails.cfm:372) at cfitemDetails2ecfm1913841519.runPage(D:\inetpub\curtisdirect\ORDER\itemDetails.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfsteptwo2ecfm898332195.runPage(D:\inetpub\curtisdirect\ORDER\steptwo.cfm:151) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Here is the sample code.. cfoutput script language=_javascript_ var quantityList = new Array(); var costCenterList = new Array(); /script cfset myVar=0 cfloop from=1 to=#arrayLen(shoppingCart['Products'])# index=myIndex cfflush script language=_javascript_ quantityList[#myVar#]='quantity_#myIndex#'; costCenterList[#myVar#] = 'costCenter_#myIndex#'; /script can anybody suggest where I am going wrong and how to fix it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: java.lang.ArrayIndexOutOfBoundsException
You want arraylen -1 -dbk _ From: Ruben Ghosal [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 1:43 PM To: CF-Talk Subject: java.lang.ArrayIndexOutOfBoundsException Hi, I have a large amount of data which I am trying to insert in a Shopping cart array. The array is declared is _javascript_. I get the following runtime error. java.lang.ArrayIndexOutOfBoundsException at java.net.SocketInputStream.read(SocketInputStream.java:121) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.readPacketIntoP rimaryBuffer(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.util.UtilPagedTempBuffer.write(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.getColumnDataForRow(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplResultSet.getData(Unknown Source) at macromedia.jdbc.base.BaseResultSet.getObject(Unknown Source) at coldfusion.sql.QueryTable.populate(QueryTable.java:272) at coldfusion.sql.Executive.getRowSets(Executive.java:559) at coldfusion.sql.Executive.executeCall(Executive.java:814) at coldfusion.sql.Executive.executeCall(Executive.java:749) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:313) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:192) at cfshoppingCart2ecfm1340170321.runPage(D:\inetpub\CurtisCustomTags\shoppi ngCart.cfm:44) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.j ava:60) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:256) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1881) at cfitemDetails2ecfm1913841519._factor26(D:\inetpub\curtisdirect\ORDER\ite mDetails.cfm:883) at cfitemDetails2ecfm1913841519._factor35(D:\inetpub\curtisdirect\ORDER\ite mDetails.cfm:403) at cfitemDetails2ecfm1913841519._factor36(D:\inetpub\curtisdirect\ORDER\ite mDetails.cfm:372) at cfitemDetails2ecfm1913841519.runPage(D:\inetpub\curtisdirect\ORDER\itemD etails.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfsteptwo2ecfm898332195.runPage(D:\inetpub\curtisdirect\ORDER\steptwo.cf m:151) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java: 43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist enceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252 ) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527 ) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java: 192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j ava:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java :451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav a:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Here is the sample code.. cfoutput script language=_javascript_ var quantityList = new Array(); var costCenterList = new Array(); /script cfset myVar=0 cfloop from=1 to=#arrayLen(shoppingCart['Products'])# index=myIndex cfflush script language=_javascript_ quantityList[#myVar#]='quantity_#myIndex#'; costCenterList[#myVar#] = 'costCenter_#myIndex#'; /script can
RE: java.lang.ArrayIndexOutOfBoundsException
Can you please explain.the error occurs only when there is a lot of data..for small amount of data the code works fine. -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 2:44 PM To: CF-Talk Subject: RE: java.lang.ArrayIndexOutOfBoundsException You want arraylen -1 -dbk _ From: Ruben Ghosal [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 1:43 PM To: CF-Talk Subject: java.lang.ArrayIndexOutOfBoundsException Hi, I have a large amount of data which I am trying to insert in a Shopping cart array. The array is declared is _javascript_. I get the following runtime error. java.lang.ArrayIndexOutOfBoundsException at java.net.SocketInputStream.read(SocketInputStream.java:121) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.readPacketIntoP rimaryBuffer(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.util.UtilPagedTempBuffer.write(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.getColumnDataForRow(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplResultSet.getData(Unknown Source) at macromedia.jdbc.base.BaseResultSet.getObject(Unknown Source) at coldfusion.sql.QueryTable.populate(QueryTable.java:272) at coldfusion.sql.Executive.getRowSets(Executive.java:559) at coldfusion.sql.Executive.executeCall(Executive.java:814) at coldfusion.sql.Executive.executeCall(Executive.java:749) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:313) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:192) at cfshoppingCart2ecfm1340170321.runPage(D:\inetpub\CurtisCustomTags\shoppi ngCart.cfm:44) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.j ava:60) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:256) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1881) at cfitemDetails2ecfm1913841519._factor26(D:\inetpub\curtisdirect\ORDER\ite mDetails.cfm:883) at cfitemDetails2ecfm1913841519._factor35(D:\inetpub\curtisdirect\ORDER\ite mDetails.cfm:403) at cfitemDetails2ecfm1913841519._factor36(D:\inetpub\curtisdirect\ORDER\ite mDetails.cfm:372) at cfitemDetails2ecfm1913841519.runPage(D:\inetpub\curtisdirect\ORDER\itemD etails.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfsteptwo2ecfm898332195.runPage(D:\inetpub\curtisdirect\ORDER\steptwo.cf m:151) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java: 43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist enceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252 ) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527 ) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java: 192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j ava:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java :451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav a:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Here is the sample code.. cfoutput script language=_javascript_ var quantityList = new Array(); var costCenterList = new Array
RE: java.lang.ArrayIndexOutOfBoundsException
Sorry. I misread the question, and thought the loop used array values, etc. Please disregard that answer. As for the real answer, perhaps you should check out the technote below http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_sqlserv er_cpu.htm -Dov _ From: Ghosal, Ruben - HQ CD Consul [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 2:48 PM To: CF-Talk Subject: RE: java.lang.ArrayIndexOutOfBoundsException Can you please explain.the error occurs only when there is a lot of data..for small amount of data the code works fine. -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 2:44 PM To: CF-Talk Subject: RE: java.lang.ArrayIndexOutOfBoundsException You want arraylen -1 -dbk _ From: Ruben Ghosal [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 1:43 PM To: CF-Talk Subject: java.lang.ArrayIndexOutOfBoundsException Hi, I have a large amount of data which I am trying to insert in a Shopping cart array. The array is declared is _javascript_. I get the following runtime error. java.lang.ArrayIndexOutOfBoundsException at java.net.SocketInputStream.read(SocketInputStream.java:121) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.readPacketIntoP rimaryBuffer(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes (Unknown Source) at macromedia.util.UtilPagedTempBuffer.write(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.getColumnDataForRow(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplResultSet.getData(Unknown Source) at macromedia.jdbc.base.BaseResultSet.getObject(Unknown Source) at coldfusion.sql.QueryTable.populate(QueryTable.java:272) at coldfusion.sql.Executive.getRowSets(Executive.java:559) at coldfusion.sql.Executive.executeCall(Executive.java:814) at coldfusion.sql.Executive.executeCall(Executive.java:749) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:313) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:192) at cfshoppingCart2ecfm1340170321.runPage(D:\inetpub\CurtisCustomTags\shoppi ngCart.cfm:44) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.j ava:60) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:256) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1881) at cfitemDetails2ecfm1913841519._factor26(D:\inetpub\curtisdirect\ORDER\ite mDetails.cfm:883) at cfitemDetails2ecfm1913841519._factor35(D:\inetpub\curtisdirect\ORDER\ite mDetails.cfm:403) at cfitemDetails2ecfm1913841519._factor36(D:\inetpub\curtisdirect\ORDER\ite mDetails.cfm:372) at cfitemDetails2ecfm1913841519.runPage(D:\inetpub\curtisdirect\ORDER\itemD etails.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfsteptwo2ecfm898332195.runPage(D:\inetpub\curtisdirect\ORDER\steptwo.cf m:151) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java: 43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist enceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke