Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <23021611.post@talk.nabble.com>
Date: Mon, 13 Apr 2009 05:17:34 -0700 (PDT)
From: sivagururaja <sivagururaja@gmail.com>
To: derby-user@db.apache.org
Subject: Derby Stored Procedure Help!
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Hi All,

I am creating the stored procedure in Derby DB. Here it is,

CREATE PROCEDURE insertStud(IN RollNo Integer, in FirstName varchar(10))
PARAMETER STYLE JAVA MODIFIES SQL DATA LANGUAGE JAVA
EXTERNAL NAME 'javadbsp.DBClass.insertStud'

And the method is,

public class DBClass
{
    public static void insertStud(int rollno, String name)
    {
        try
        {
            Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); //or
ClientDriver
            Connection conn =
DriverManager.getConnection("jdbc:derby://localhost:1527/Test", "uname",
"passwd");
            PreparedStatement ps1 = conn.prepareStatement("insert into
SAM.STUD values(?,?)");
            ps1.setInt(1, rollno);
            ps1.setString(2, name);
            ps1.executeUpdate();
            conn.close();
        }
        catch (Exception ex)
        {
            System.out.println("Error: "+ex.getMessage());
        }
    }    
}

My table structure is,

create table "SAM".STUD
(
	ROLLNO INTEGER,
	FIRSTNAME VARCHAR(10)
)

My class is,

public class MyClass1
{
.......
..........
public void insert()
{
try
        {
            Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); // or
ClientDriver
            Connection Con1 =
DriverManager.getConnection("jdbc:derby://localhost:1527/Test", "uname",
"passwd");
            CallableStatement cst = Con1.prepareCall("call
insertStud(?,?)");
            cst.setInt(1, Integer.valueOf(jTextField1.getText().trim()));
            cst.setString(2, jTextField2.getText().trim());
            int i=cst.executeUpdate();
            System.out.println("Rows Updated: "+i);
        }
        catch (Exception ex)
        {
            System.out.println("Error: "+ex.getMessage());
        }
}
......
}

And i install the JAR files as per the document,
http://wiki.apache.org/db-derby/DerbySQLroutines
http://wiki.apache.org/db-derby/DerbySQLroutines 

I can able to run the application successful.
But nothing can be inserted.

Please let me know what could be the problem.
-- 
View this message in context: http://www.nabble.com/Derby-Stored-Procedure-Help%21-tp23021611p23021611.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.