java.lang.ArrayIndexOutOfBoundsException: 2 [duplicate]

I’m trying to connect java to sql. Though I’m a newbie with javam I can’t seem to find out why.

java.lang.ArrayIndexOutOfBoundsException: 2

Can you help me and give me idea how to figure it out?

try{
       Connection con = dbConnection();

       String lname = this.last.getText();
       String fname = this.first.getText();
       String mname = this.mid.getText();
       String ad = this.add.getText();
       String bd = this.bday.getText();
       String ag = this.edad.getText();
       String nom = this.no.getText();
       String per = this.person.getText();

       String query = "INSERT INTO Personal Category    (Lastname,Firstname,Middle,Address,Birthday,Age,No,Person) VALUES (?,?)"; //to insert to database

       PreparedStatement pre;

       pre = con.prepareStatement(query);


       pre.setString(1, lname);
       pre.setString(2, fname);
       pre.setString(3, mname);
       pre.setString(4, ad);
       pre.setString(5, bd);
       pre.setString(6, ag);
       pre.setString(7, nom);
       pre.setString(8, per);


       pre.execute();//execute

       con.close();


    }catch (Exception e){

        System.out.println(e);

    }

}

Related Posts:

  1. Initialization of an ArrayList in one line
  2. Is there a Heap in java?
  3. What’s the difference between map() and flatMap() methods in Java 8?
  4. Why do we need copy constructor and when should we use copy constructor in java
  5. What are the -Xms and -Xmx parameters when starting JVM?
  6. How to match “any character” in regular expression?
  7. Cannot make a static reference to the non-static method fxn(int) from the type Two
  8. How to implement a tree data-structure in Java?
  9. Difference between StringBuilder and StringBuffer
  10. Iterate through a HashMap [duplicate]
  11. Non-static variable cannot be referenced from a static context
  12. JAVA invalid maximum heap size. The specified size exceeds the maximum representable size
  13. JDK9: An illegal reflective access operation has occurred. org.python.core.PySystemState
  14. A long bigger than Long.MAX_VALUE
  15. How to remove single character from a String
  16. Unsupported major.minor version 52.0 [duplicate]
  17. How do I limit the number of decimals printed for a double?
  18. Usage of @see in JavaDoc?
  19. Hadoop “Unable to load native-hadoop library for your platform” warning
  20. Unreported exception java.lang.Exception; must be caught or declared to be thrown
  21. How to clear the console?
  22. How to capitalize the first letter of a String in Java?
  23. Scanner vs. BufferedReader
  24. Raw use of parameterized class
  25. :: (double colon) operator in Java 8
  26. What does ‘0’ do in Java?
  27. Service will not start: error 1067: the process terminated unexpectedly
  28. Explain the use of a bit vector for determining if all characters are unique
  29. Rename a file using Java
  30. What is “String args[]”? parameter in main method Java
  31. “A java exception has occurred” when opening .jar
  32. How do I set environment variables from Java?
  33. Exception in thread “main” java.lang.ArrayIndexOutOfBoundsException: 0 error in Java
  34. What’s the advantage of load() vs get() in Hibernate?
  35. What Java ORM do you prefer, and why?
  36. Always Round UP a Double
  37. Using Enum values as String literals
  38. How to change a package name in Eclipse?
  39. Are arrays passed by value or passed by reference in Java?
  40. How do I get “Press any key to continue” to work in my Java code?
  41. What does “?” mean in Java? [duplicate]
  42. What is the difference between a local variable, an instance field, an input parameter, and a class field?
  43. Error: Selection does not contain a main type
  44. Java, “Variable name” cannot be resolved to a variable
  45. “Actual or formal argument lists differs in length”
  46. TreeMap sort by value
  47. Encrypt Password in Configuration Files?
  48. Could not find method compile() for arguments Gradle
  49. How can I get the current stack trace in Java?
  50. java.util.zip.ZipException: error in opening zip file
  51. paint() and repaint() in Java
  52. Good Hash Function for Strings
  53. Error – Illegal static declaration in inner class
  54. Bubble Sort Manually a Linked List in Java
  55. Checking Password Code
  56. java – how to create and manipulate a bit array with length of 10 million bits
  57. What is the difference between object-oriented languages and non object-oriented languages?
  58. Installing jdk8 on ubuntu- “unable to locate package” update doesn’t fix
  59. Java – Access is denied java.io.FileNotFoundException
  60. No appenders could be found for logger(log4j)?
  61. ArrayList<> cannot be resolved to a type
  62. Exception in thread “main” java.lang.StringIndexOutOfBoundsException: String index out of range: 0
  63. Error: Main method not found in class Calculate, please define the main method as: public static void main(String[] args) [duplicate]
  64. ArrayList<> cannot be resolved to a type
  65. Simple way to repeat a string
  66. Unreachable statement compile error in Java
  67. Reflection generic get field value
  68. error: incompatible types: char cannot be converted to String – Java
  69. mongoDB, connection refused
  70. Displaying Image in Java
  71. How to check the input is an integer or not in Java?
  72. How to read and write XML files?
  73. Efficient way to do batch INSERTS with JDBC
  74. wrong ELF class: ELFCLASS32
  75. Invalid signature file digest for Manifest main attributes exception while trying to run jar file
  76. JAVA + try catch(FileNotFoundException e) going in catch(Exception e)?
  77. Using a do-while loop to check a User’s input in Java
  78. What is the proper annotation since @SpringApplicationConfiguration, @WebIntegration, is deprecated in Spring Boot Framework?
  79. How to write a test class to test my code?
  80. How do I exit a while loop in Java?
  81. Java String import
  82. Printing array elements with a for loop
  83. How to implement a most-recently-used cache
  84. Cannot be resolved to a variable error in Eclipse
  85. JAVA_HOME is set to an invalid directory:
  86. Using JavaFX in JRE 8, “Access restriction” error
  87. Static Final Long serialVersionUID = 1L
  88. Which Eclipse IDE version to choose?
  89. Error: The processing instruction target matching “[xX][mM][lL]” is not allowed
  90. Unable to resolve host “” No address associated with host name
  91. Why int[] a = new int[1] instead of just int a?
  92. getOutputStream() has already been called for this response
  93. Pass object by reference in Java
  94. What is object serialization?
  95. How do I use StringUtils in Java?
  96. Error :- java runtime environment JRE or java development kit must be available in order to run eclipse
  97. How to set menu to Toolbar in Android
  98. How to implement Java “Scanner” in C++?
  99. How to convert java.util.Date to java.sql.Date?
  100. Can’t seem to disable Java Automatic Update

Leave a Comment