• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Stoared procedure & Type 4 driver

 
kedar parundekar
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
import java.sql.*;
class DemoCallable {
public static void main(String a[])
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");// Type 4 Driver
Connection conn = DriverManager.getConnection("jdbcracle:thin:@dbs:1521rcl","scott","tiger");


/*Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // to load Type1 driver
Connection conn=DriverManager.getConnection("jdbcdbc:mydsn","scott","tiger"); // for connection, mydsn is dsn , java is username, java is password*/


System.out.println("Connection : " + conn);
CallableStatement cstmt = conn.prepareCall(" {call sqr(?, ?)} ");
System.out.println("Callable Statement : " + cstmt);

cstmt.setInt(1,10);

cstmt.registerOutParameter(2,Types.INTEGER);

boolean b=cstmt.execute();

System.out.println(cstmt.getInt(2));

cstmt.close();
conn.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
};

Q )In above code,
If I am using Type 1 driver ,Then its properly working(Return me square of 10)
But when I am using Type4 driver , It will show me Null Pointer Exception.
Why?
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What does e.printStackTrace() say ?

Shailesh
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic