aspose file tools*
The moose likes JDBC and the fly likes Exception in thread Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Exception in thread "main" java.sql.SQLException" Watch "Exception in thread "main" java.sql.SQLException" New topic
Author

Exception in thread "main" java.sql.SQLException

vicky verma
Greenhorn

Joined: Jan 04, 2007
Posts: 5
import java.sql.DriverManager;
import java.sql.*;
import java.io.*;
public class DataConnect {
public static void main(String[] args) throws SQLException,ClassNotFoundException,UnsupportedClassVersionError{

Connection con=null;
Statement st=null;
ResultSet rs=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc racle:thin:@sun:1521:roshan","vikas","verma");

st=con.createStatement();
rs=st.executeQuery("select emp_id,f_name,l_name from emp");
while(rs.next()){

System.out.println("Emp_id"+rs.getInt(1));
System.out.println("First_name"+rs.getInt(2));
System.out.println("Last_name"+rs.getInt(3));

}
rs.close();
con.close();

}

}
Will this program run or not.if not then what is the reason please explain me.

emp_id is of type number.
f_name,l_name is of type varchar.

before answering ,please read this paragraph carefully

[URL=For example, the method getInt can be used to retrieve any of the numeric or character types. The data it retrieves will be converted to an int; that is, if the SQL type is VARCHAR , JDBC will attempt to parse an integer out of the VARCHAR. The method getInt is recommended for retrieving only SQL INTEGER types, however, and it cannot be used for the SQL types BINARY, VARBINARY, LONGVARBINARY, DATE , TIME, or TIMESTAMP.]For example, the method getInt can be used to retrieve any of the numeric or character types. The data it retrieves will be converted to an int; that is, if the SQL type is VARCHAR , JDBC will attempt to parse an integer out of the VARCHAR. The method getInt is recommended for retrieving only SQL INTEGER types, however, and it cannot be used for the SQL types BINARY, VARBINARY, LONGVARBINARY, DATE , TIME, or TIMESTAMP.[/url]
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2477
    
    7

Vikas,

Please show us the error message.
Upon first review, I think first_name and Last_name are Strings:Regards, Jan


OCUP UML fundamental and ITIL foundation
youtube channel
Rahul Bhattacharjee
Ranch Hand

Joined: Nov 29, 2005
Posts: 2308
Post the exception stacktrace.

As your exception is going out of main method , the main thread would be killed once exception is thrown.


Rahul Bhattacharjee
LinkedIn - Blog
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Exception in thread "main" java.sql.SQLException
 
Similar Threads
How to know the Data-type of column?
mySQL INTEGER == LONG in Java and ....???
Using reflection to get the value of a final static field
javax.jms.JMSSecurityException: User null is NOT authenticated
stuck up in the problem