Link to home
Start Free TrialLog in
Avatar of gudii9
gudii9Flag for United States of America

asked on

java stored proc example

Hi,

I am working on below

http://www.gokhanatil.com/2009/07/how-to-develop-java-stored-procedures.html

import java.sql.*;
import oracle.jdbc.*;
 
public class JavaSample {
	public static void main(String[] args) throws ClassNotFoundException {
		JavaSample js=new JavaSample();
		js.insert_into_table(100, "gp", "gp@gp.com");
	}
 
  public static void insert_into_table(int ID, String Name, String Email) throws ClassNotFoundException {
 
    try {
 
    	
    	  String driver = "oracle.jdbc.driver.OracleDriver";
    	    String url = "jdbc:oracle:thin:@localhost:1521:XE";
    	    String username = "sample";
    	    String password = "admin";
    	    Class.forName(driver);
    	    Connection conn = DriverManager.getConnection(url, username, password);
    	   // return conn;
    	    
     //Connection DB = DriverManager.getConnection("jdbc:default:connection:");
 
      String SQL ="INSERT INTO sampletable VALUES (?,?,?)";
 
      PreparedStatement cmd = conn.prepareStatement(SQL);
 
      cmd.setInt(1, ID);
      cmd.setString(2, Name );
      cmd.setString(3, Email );
      cmd.executeUpdate();
      cmd.close();
    }
    catch(SQLException e) {
      System.err.println( "Error: " + e.getMessage());
      }
  }
}

Open in new window


storedproc code is as below

CREATE PROCEDURE TestForJava
( id NUMBER, name VARCHAR2, email VARCHAR2 )
AS LANGUAGE JAVA
NAME 'JavaSample.insert_into_table( int,
java.lang.String, java.lang.String )';
/

Open in new window

how to improve my code. I wonder why two times ClassNotFoundException

please advise
proc.png
ASKER CERTIFIED SOLUTION
Avatar of gurpsbassi
gurpsbassi
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gudii9

ASKER

Do we need throws twice
Avatar of CEHJ
The stored procedure and your code are entirely unrelated
Do we need throws twice


what do you mean?
Avatar of gudii9

ASKER

from both methods i mean as below bolded      

public static void main(String[] args) throws ClassNotFoundException {

 
 public static void insert_into_table(int ID, String Name, String Email) throws ClassNotFoundException {
Of course if one calls the other.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I don't see why my post is the accepted solution?
Did I provide a solution?