google-code-export / ords

Automatically exported from code.google.com/p/ords
1 stars 0 forks source link

Can't add records to new database tables #600

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Go to the DHOxSS project on the dev server, and view the Mondial database 
(Mark is already a project member; if anyone else needs access, let me know)
2. Attempt to add a new record to either newtable or anothernewtable
3.

What is the expected output? What do you see instead?
There seems to be a problem adding new records to these tables (or to other new 
tables created in this database). This doesn't happen with new tables in other 
databases, so something seems to have gone wrong with this specific database. 
(The table in this database created by importing a CSV file (mondial) seems 
fine; it's only tables created in ORDS that are problematic.)

Trying to add a new record produces an error message like this:

HTTP Status 500 - An exception occurred processing JSP page 
/includes/newTableRowForm.jsp at line 13 10: if ( 
(fullTableData.getOriginalDbType() != null) && 
(fullTableData.getOriginalDbType().equals(DataTypesSupported.CSV))) { 11: isCsv 
= true; 12: List<String> primaryKeys = fullTableData.primaryKeys; 13: 
indexColName = primaryKeys.get(0); 14: } 15: 16: for (OrdsTableColumn otc : 
fullTableData.getColumnsByIndex()) { Stacktrace:

type Exception report

message An exception occurred processing JSP page /includes/newTableRowForm.jsp 
at line 13 10: if ( (fullTableData.getOriginalDbType() != null) && 
(fullTableData.getOriginalDbType().equals(DataTypesSupported.CSV))) { 11: isCsv 
= true; 12: List<String> primaryKeys = fullTableData.primaryKeys; 13: 
indexColName = primaryKeys.get(0); 14: } 15: 16: for (OrdsTableColumn otc : 
fullTableData.getColumnsByIndex()) { Stacktrace:

description The server encountered an internal error (An exception occurred 
processing JSP page /includes/newTableRowForm.jsp at line 13 10: if ( 
(fullTableData.getOriginalDbType() != null) && 
(fullTableData.getOriginalDbType().equals(DataTypesSupported.CSV))) { 11: isCsv 
= true; 12: List<String> primaryKeys = fullTableData.primaryKeys; 13: 
indexColName = primaryKeys.get(0); 14: } 15: 16: for (OrdsTableColumn otc : 
fullTableData.getColumnsByIndex()) { Stacktrace:) that prevented it from 
fulfilling this request.

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page 
/includes/newTableRowForm.jsp at line 13

10:     if ( (fullTableData.getOriginalDbType() != null) && 
(fullTableData.getOriginalDbType().equals(DataTypesSupported.CSV))) {
11:         isCsv = true;
12:         List<String> primaryKeys = fullTableData.primaryKeys;
13:         indexColName = primaryKeys.get(0);
14:     }
15:     
16:     for (OrdsTableColumn otc : fullTableData.getColumnsByIndex()) {

Stacktrace:
    org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause

java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
    java.util.ArrayList.rangeCheck(ArrayList.java:635)
    java.util.ArrayList.get(ArrayList.java:411)
    org.apache.jsp.addNewTableRow_jsp._jspService(addNewTableRow_jsp.java:442)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
note The full stack trace of the root cause is available in the Apache 
Tomcat/7.0.28 logs.

Please use labels and text to provide additional information.
v. 1.0.6 on dev

Original issue reported on code.google.com by meriel.p...@gmail.com on 5 Jan 2015 at 5:54