RE: reading Text file with the field positions

[Chiru Chiranjeevi]

I wanna read a text file from 1-10(positions in the text ) to a variable..I tried with the below code but I got an String BufferoutIndexException .help me on how to get the output.
Thanks in advance..


BufferedReader reader = new BufferedReader(new FileReader("C:/cf.txt"));
String line;
while ((line=reader.readLine()) != null )
{
System.out.println(line);
contact.setPid(line.substring(11,17).trim());
contact.setBirthDt(line.substring(18,43).trim());
contact.setEmailAddr(line.substring(44,143).trim());
//getting the fields to diefferenclass getback.data() method

[Jeff Verdegan]

Please copy/paste the exact, complete error message--with the full stack trace, and make it clear which line is causing it.

[Rob Spoor]

Do you really have a line with at least 143 characters?? Because that's what your code is doing - read the first line (until the first line break), then split that up.

[Jeff Verdegan]

Also please paste in the actual exception name. There is no such thing as "BufferoutIndexException" in the core API.

[Chiru Chiranjeevi]

public static void main(String[] args) throws SQLException {
			Connection conn = null;
			Statement statement = null;
			RefDataBean refDataBean = new RefDataBean();
    			String readFile = null;
	    		int flag=0,flag_file=0;
		 	
		 	// dataBase Connection
			try {

				   try {
					            Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
				       }               
				             catch (ClassNotFoundException e1) {
					                                    // TODO Auto-generated catch block
				                                          	e1.printStackTrace();
		                                                		}

				    try {
					// Driver drv = new COM.ibm.db2.jdbc.app.DB2Driver();

					                    String url = "jdbc:db2:CCANE";
					                    conn = DriverManager.getConnection(url, "navkum12", "mohan!@#");
					                    if (conn != null) {
						                              System.out.println("DB2 Database Connected");
					                                      } 
			                            else {
						                        System.out.println("Db2 connection Failed ");
					                         }
				         } 
						     catch (Exception e) {
					                            e.printStackTrace();
					                            System.out.println(e.getMessage());
					// TODO: handle exception
							                     }
		                ResultSet resultset;
				   try {
					   statement = conn.createStatement();
				       } catch (SQLException e2) {
					// TODO Auto-generated catch block
					e2.printStackTrace();
				                                 }
	     			try {

					resultset = statement.executeQuery("select REF_ROW_ID,REF_ID from cca.ref_data where ref_id in (43319,43318,43317) with ur");

					while (resultset.next()) {
						
						// String s = resultset.getString();

						// Get the data from the row using the column name
						System.out.println(resultset.getString(1));
						System.out.println(resultset.getString(2));
		        			}
				          } catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				                                    }

				// End of DataBase Connection
				// Configuration File Reader

				FileInputStream configstream = new FileInputStream("C:/cf.txt");
				DataInputStream inConfig = new DataInputStream(configstream);
				BufferedReader Configbr = new BufferedReader(new InputStreamReader(inConfig), 100);

				  try {
					readFile = Configbr.readLine();
				}    catch (IOException e1) {
					// TODO Auto-generated catch block
					System.out.println("File Config failed");
				                             }

				// End of Configuration File
				String strLine;
				// StringBuffer strBuffer=null;
				try {
					while ((strLine = Configbr.readLine()) != null) {
						strLine.substring(1,8);
						System.out.println(strLine.substring(48, 64).trim());

						refDataBean.setRefId(strLine.substring(0, 8).trim());
						refDataBean.setRefCatgId(strLine.substring(9, 14).trim());
						refDataBean.setLabelName(strLine.substring(15, 27).trim());
						refDataBean.setSortOrder(strLine.substring(28, 29).trim());
						refDataBean.setShortDesc(strLine.substring(30, 47).trim());
						refDataBean.setLongDesc(strLine.substring(48, 64).trim());
						refDataBean.setCreatedBy(strLine.substring(119, 125).trim());
						refDataBean.setLastUpdatedBy(strLine.substring(153, 160).trim());
						char[] refGenId = (char[]) strLine.substring(214, 215).trim().toCharArray();
						refDataBean.setRefgenId(refGenId[0]);
						refDataBean.setCacheCode(strLine.substring(216, 221).trim());
						refDataBean.setRestrictionInd(strLine.substring(222, 223).trim());
						refDataBean.setDmsInd(strLine.substring(224, 225).trim());
						int ref_id = Integer.parseInt(refDataBean.getRefId());
						int refCatgId = Integer.parseInt(refDataBean.getRefCatgId());
						String labelName = refDataBean.getLabelName();
						String shortDesc = refDataBean.getShortDesc();
						String date = "1900-01-01-12.12.00.000000";
						statement.execute("insert into cca.ref_data"
										+ "(REF_ID,REF_CATG_ID,LABEL_NAME,SORT_ORDER,SHORT_DESC,LONG_DESC,EFF_DT,TRMN_DT,CREATED_BY,LAST_UPD_TS,LAST_UPD_BY,CREATED_TS,REF_GEN_IND,CACH_CODE,RESTRICTION_INDICATOR,DMS_IND)"
										+ "values("
										+ ref_id
										+ ","
										+ refCatgId
										+ ","
										+ "'"
										+ labelName
										+ "'"
										+ ","
										+ Integer.parseInt(refDataBean.getSortOrder())
										+ ","
										+ "'"
										+ shortDesc
										+ "'"
										+ ","
										+ "'"
										+ refDataBean.getLongDesc()
										+ "'"
										+ ","
										+ "'"
										+ date
										+ "'"
										+ ","
										+ "'"
										+ date
										+ "'"
										+ ","
										+ "'"
										+ refDataBean.getCreatedBy()
										+ "'"
										+ ","
										+ "'"
										+ date
										+ "'"
										+ ","
										+ "'"
										+ refDataBean.getLastUpdatedBy()
										+ "'"
										+ ","
										+ "'"
										+ date
										+ "'"
										+ ","
										+ "'"
										+ refDataBean.getRefgenId()
										+ "'"
										+ ","
										+ Integer.parseInt(refDataBean.getCacheCode())
										+ ","
										+ Integer.parseInt(refDataBean.getRestrictionInd()) + ","
										+ Integer.parseInt(refDataBean.getDmsInd())
										+ ")");
						flag=1;
						System.out.println("record inserted");

					}

				} catch (IOException e) {
					// TODO Auto-generated catch block
					System.out.println("Error reading the file ");
				}
							} 
                                                                         
                                                                           catch (FileNotFoundException e) {
				// TODO Auto-generated catch block
				System.out.println("error may here");
			}

		}

output:

DB2 Database Connected
4824157
43319
4824158
43318
4824159
43317

Exception in thread "main" java.lang.StringIndexOutOfBoundsException
	at java.lang.String.substring(String.java:1088)
	at com.cigna.reporting.batchjobs.cpf.business.SaveBean.main(SaveBean.java:98)

cf file :
first line:
YesIamtestingtheworkingofthefunctionwhichmustprintsomeresultstomeanditisnotgivingtheresultssowhattodoihavetogetitbytodayhopesomeo

[Jeff Verdegan]

In the future, please UseCodeTags, so that your code will be readable.

The error message is telling you exactly what's wrong, and exactly where. At line 98 of SaveBean.java you're trying to access an index beyond the last index of the String in question. As rob suggested, you're probably assuming there are more characters present than there actually are.

Add println() statements at each step so you can see what each piece is, and also, before all that, print out the length of the line.

[Chiru Chiranjeevi]

Thanks for the quick response..Now this site becomes my homepage