aspose file tools*
The moose likes JDBC and the fly likes Stoared procedure & Type 4 driver 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 "Stoared procedure & Type 4 driver" Watch "Stoared procedure & Type 4 driver" New topic
Author

Stoared procedure & Type 4 driver

kedar parundekar
Ranch Hand

Joined: May 10, 2006
Posts: 40
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

Joined: Aug 13, 2004
Posts: 1081

What does e.printStackTrace() say ?

Shailesh


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Stoared procedure & Type 4 driver
 
Similar Threads
urgent ->why to follow jdbc steps for getting conncetion
How to configure oracle xe thin driver in xp
Driver problem
Type-2 Driver
JDBC-Oracle