Srikanth Ravuri

Rob Spoor wrote:Don't reinvent the wheel, and use an existing CSV library. You can find some in our AccessingFileFormats FAQ, under Excel. I myself have used opencsv successfully quite a few times.

Thanks Rob

I am new to java and don't have much knowledge in CSV library. I will study more into it and try to excel myself. Thank you once again.

Campbell Ritchie wrote:Why are you still using StringTokenizer?

You need some debugging information. Get rid of the tokenising for the time being (comment it out), and print each line as you read it.
Why are you reusing the file name to read into? Why haven't you got a separate local for the String read?

Thank you campbell for your imput. I am new to Java and trying to get into phase. I will look more into string methods available and move forward.

Mohamed Sanaulla wrote:

Srikanth Ravuri wrote:

I don't want the 1st line i.e. ID FNAME LNAME DEPTID. Thats where I am stuck.

In that case- You just have to do-
if(linenumber==0) continue;
But suggestion is to use the libraries suggested by Rob. I also mentioned a small glitch in the code in my first post. Also Campbell suggested not using StringTokenizer- You can achieve it by using the split() method of the String class.

Thank you Mohamed

I will keep your inputs in mind and proceed for the next time.

Srikanth Ravuri wrote:

Sreelatha Sankaranarayanan wrote:This is what will help what you want , note the first 2 lines after the while loop starts -----------

try { BufferedReader br = new BufferedReader( new FileReader(fileName)); StringTokenizer st = null; int lineNumber = 0, tokenNumber = 0; while( (fileName = br.readLine()) != null) { if(lineNumber++ == 0) continue; //break comma separated line using "," st = new StringTokenizer(fileName, ","); while(st.hasMoreTokens()) { //display csv values tokenNumber++; System.out.print(st.nextToken() + '\t'); } //new line System.out.println(" "); //reset token number tokenNumber = 0; } } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); }

I am missing in between lines

Output

101 XXXXXX XXXXX 1
103 XXXXXX XXXXX 2
105 XXXXXX XXXXX 3


missing 102 and 104.....

I am sorry. It is perfect.

Thank you,

Mohamed Sanaulla wrote:

Prakash Krsihnan wrote:Inside while check for linenumber is zero then ignore the operation, else proceed as usuals

In the code- linenumber is used only at two places-To declare and to increment. It doesn't really affect the CSV parsing process.

This is my output when I execute my program

ID FNAME LNAME DEPTID
106 XXXX XXXX 1
107 XXXX XXXX 2
108 XXXX XXXX 2
109 XXXX XXXX 3
110 XXXX XXXX 3


I don't want the 1st line i.e. ID FNAME LNAME DEPTID. Thats where I am stuck.

Sreelatha Sankaranarayanan wrote:This is what will help what you want , note the first 2 lines after the while loop starts -----------

try { BufferedReader br = new BufferedReader( new FileReader(fileName)); StringTokenizer st = null; int lineNumber = 0, tokenNumber = 0; while( (fileName = br.readLine()) != null) { if(lineNumber++ == 0) continue; //break comma separated line using "," st = new StringTokenizer(fileName, ","); while(st.hasMoreTokens()) { //display csv values tokenNumber++; System.out.print(st.nextToken() + '\t'); } //new line System.out.println(" "); //reset token number tokenNumber = 0; } } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); }

I am missing in between lines

Output

101 XXXXXX XXXXX 1
103 XXXXXX XXXXX 2
105 XXXXXX XXXXX 3


missing 102 and 104.....

Prakash Krsihnan wrote:Inside while check for linenumber is zero then ignore the operation, else proceed as usuals

I didn't quit get your point. can you please brief it more.

Thank you,

Hi

I want to extract data from .csv file eliminating the 1st line. I tried to put code any number of fashion but couldn't make it happen. Any suggestion on where I been wrong.

Here is my code.


import java.io.BufferedReader; import java.io.FileNotFoundException; import java.io.FileReader; import java.io.IOException; import java.util.StringTokenizer; public class DBcvsdataextractor { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub String fileName="C:/workspace/tibcobw/files/in/empdata.csv"; try { BufferedReader br = new BufferedReader( new FileReader(fileName)); StringTokenizer st = null; int lineNumber = 0, tokenNumber = 0; while( (fileName = br.readLine()) != null) { lineNumber++; //break comma separated line using "," st = new StringTokenizer(fileName, ","); while(st.hasMoreTokens()) { //display csv values tokenNumber++; System.out.print(st.nextToken() + '\t'); } //new line System.out.println(" "); //reset token number tokenNumber = 0; } } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }

As well I want to insert the data extracted from .csv file into my SQL table. Any suggestion on it. I taught of inputing by reading each element as an array or by reading it as a readLine method.

Thank you,

Anand Bhatt wrote:You are on track now:

This error is thrown if a user wants to log on a database but lacks the create session system privilege.
In order to give someone this privilege, use:
grant create session to the_user;

Thanks Anand for quick response.

I have a new problem now. I can print 1st row of the data and the rest it stops with an error message


java.sql.SQLException: ORA-01002: fetch out of sequence at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:622) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:179) at oracle.jdbc.driver.T4CCallableStatement.fetch(T4CCallableStatement.java:841) at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:264) at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:196) at com.srikanth.bank.dao.EmpDAO.main(EmpDAO.java:43)


Here is my new java code.


package com.srikanth.bank.dao; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; //import Oracle.jdbc.driver.OracleDriver; public class EmpDAO { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub try { // DriverManager.registerDriver(new OracleDriver()); Class.forName("oracle.jdbc.driver.OracleDriver"); } catch (ClassNotFoundException ex) { ex.printStackTrace(); } Connection con = null; CallableStatement cstmt = null; try { con = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:XE", "SYS", "nani123"); cstmt = con.prepareCall("{call Net_Pay(?, ?, ?, ?, ?, ?, ?, ?)}"); cstmt.setInt(1, 501); cstmt.setInt(2, 0); cstmt.registerOutParameter(2, java.sql.Types.INTEGER); cstmt.registerOutParameter(3, java.sql.Types.VARCHAR); cstmt.registerOutParameter(4, java.sql.Types.INTEGER); cstmt.registerOutParameter(5, java.sql.Types.INTEGER); cstmt.registerOutParameter(6, java.sql.Types.INTEGER); cstmt.registerOutParameter(7, java.sql.Types.INTEGER); cstmt.registerOutParameter(8, java.sql.Types.INTEGER); ResultSet rs = cstmt.executeQuery(); // System.out.println("in while " + rs.getFetchSize()); while(rs.next()) { // System.out.println("in while " + rs.getRow()); int e_id = cstmt.getInt(2); // System.out.println(e_id); String e_n = cstmt.getString(3); int b_salary = cstmt.getInt(4); int hra = cstmt.getInt(5); int ob = cstmt.getInt(6); int tax = cstmt.getInt(7); int net = cstmt.getInt(8); System.out.println("Employee id: " + e_id + "Name: " + e_n + "Base Salary: " + b_salary + "HRA: " + hra + "Other Benifits:" + ob + "Tax: " + tax + "Net Salary:" + net); } } catch (SQLException ex) { ex.printStackTrace(); } finally { try { if (cstmt != null) // close the callablestatement { cstmt.close(); cstmt = null; } } catch (SQLException ex) { ex.printStackTrace(); } try { if (cstmt != null) // close the connection { cstmt.close(); cstmt = null; } } catch (SQLException ex) { ex.printStackTrace(); } } } }

Any comments or suggestions on where I went wrong.

Thank you,

Tom Reilly wrote:Actually, it's:
1. Right click on the project
2. Select Properties
3. Select Java Build Path
4. Select the Libraries tab
5. Click the Add External JARs button
6. Navigate to, and select classes12.jar

Thank you Tom

I got hold up with DB connectivity error saying:
java.sql.SQLException: ORA-01045: user SRIWORK lacks CREATE SESSION privilege; logon denied at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271) at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:644) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:298) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:343) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:147) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.srikanth.bank.dao.EmpDAO.main(EmpDAO.java:31)

any suggestion at to keep me on a right track.

Thank you

Anand Bhatt wrote:Do you have classes12.jar file in your application path?

Thanks Anand for the reply.

I am new to java. I am using eclipse to call the stored procedures. As you said I downloaded classes12.jar file and uploaded my java lib folder and still I couldn't see that on eclipse. Any suggestion of where I am doing the mistake.

Please help.

Thank you,

Hi

I am new to java. I am trying to call data from Oracle using java code but got few errors. Can you please help me where I am going wrong.

Thanks in advance.

Code:

package com.srikanth.bank.dao; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; public class EmpDAO { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub try { Class.forName("oracle.jdbc.driver.OracleDriver"); } catch(ClassNotFoundException ex) { ex.printStackTrace(); } Connection con=null; CallableStatement cstmt=null; try { con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "SYS", "nani123"); cstmt=con.prepareCall("{call Net_Pay(d_id, e_id, e_n, b_salary, hra, ob, tax, net}"); //called the procedure cstmt.setInt(1, 501); cstmt.setInt(2, 0); cstmt.registerOutParameter(2,java.sql.Types.INTEGER); cstmt.registerOutParameter(3,java.sql.Types.VARCHAR); cstmt.registerOutParameter(4,java.sql.Types.INTEGER); cstmt.registerOutParameter(5,java.sql.Types.INTEGER); cstmt.registerOutParameter(6,java.sql.Types.INTEGER); cstmt.registerOutParameter(7,java.sql.Types.INTEGER); cstmt.registerOutParameter(8,java.sql.Types.INTEGER); ResultSet rs = cstmt.executeQuery(); while(rs.next ()) { int e_id = cstmt.getInt(2); String e_n = cstmt.getString(3); int b_salary = cstmt.getInt(4); int hra = cstmt.getInt(5); int ob = cstmt.getInt(6); int tax = cstmt.getInt(7); int net = cstmt.getInt(8); System.out.println("Employee id: " + e_id + "Name: " + e_n + "Base Salary: " + b_salary + "HRA: " + hra + "Other Benifits:" + ob + "Tax: " + tax + "Net Salary:" + net); }} catch(SQLException ex) { ex.printStackTrace(); } finally { try { if(cstmt!=null) //close the callablestatement { cstmt.close(); cstmt=null; } } catch(SQLException ex) { ex.printStackTrace(); } try { if(cstmt!=null) //close the connection { cstmt.close(); cstmt=null; } } catch(SQLException ex) { ex.printStackTrace(); } } } }



Error:

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.srikanth.bank.dao.EmpDAO.main(EmpDAO.java:19)
java.sql.SQLException: No suitable driver found for jdbc:oracle:thin @localhost:1521:XE
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.srikanth.bank.dao.EmpDAO.main(EmpDAO.java:29)


Please help me where I am going wrong.