I've written a jsp ,a bean and a Interbase store procedure .Here is the content of my bean ---
---------------sql_data.java-------------------
package com.bigchina.jdbctest;
import java.sql.*;
public class sql_data
{
String sDBDriver = "interbase.interclient.Driver";
String sConnStr = "jdbc:interbase://localhost/D:/tomcat4/webapps/aaa/data/TEST2.gdb";
Connection conn = null;
ResultSet rs = null;
... ...
public void thetest(String pa1,String pa2,String pa3,String pa4)
{
System.out.println(pa1);
System.out.println(pa2);
try
{
conn = DriverManager.getConnection(sConnStr,"SYSDBA","masterkey"
;
CallableStatement cstmt = conn.prepareCall("{call TTT(?,?,?,?)}"
cstmt.setString(1,pa1);
cstmt.setString(2,pa2);
cstmt.setString(3,pa3);
cstmt.setString(4,pa4);
cstmt.executeUpdate();
}
catch(SQLException ex)
{
System.err.println("sql_data.executeUpdate: " + ex.getMessage());
}
}
------------------------------------------
Here is the content of my jsp page ---
------------------------test.jsp------------------
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="searchdb" class="com.bigchina.jdbctest.sql_data" scope="page"/>
<html>
<head>
<title>test</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
searchdb.thetest("2222","DDDD","DDDDDD","FFFF"
%>
------------------------------------------
Here is the content of my Interbase store procedure ---
------------------------TTT------------------
CREATE PROCEDURE "ttt" (
PBID VARCHAR(20),
PBNAME VARCHAR(36),
PBCITY VARCHAR(20),
PBTEL VARCHAR(30))
AS
BEGIN
Insert into phbook
VALUESPBID,BNAME,BCITY,BTEL);
SUSPEND;
END
------------------------------------------
When the jsp run ,Tomcat display----
sql_data.executeUpdate: [interclient][interbase] Dynamic SQL Error
SQL error code = -204
Procedure unknown
TTT
I don't know how to do.Please help me.Thank you!
PS:My english is poor ,sorry.^_^
---------------sql_data.java-------------------
package com.bigchina.jdbctest;
import java.sql.*;
public class sql_data
{
String sDBDriver = "interbase.interclient.Driver";
String sConnStr = "jdbc:interbase://localhost/D:/tomcat4/webapps/aaa/data/TEST2.gdb";
Connection conn = null;
ResultSet rs = null;
... ...
public void thetest(String pa1,String pa2,String pa3,String pa4)
{
System.out.println(pa1);
System.out.println(pa2);
try
{
conn = DriverManager.getConnection(sConnStr,"SYSDBA","masterkey"
;CallableStatement cstmt = conn.prepareCall("{call TTT(?,?,?,?)}"
;cstmt.setString(1,pa1);
cstmt.setString(2,pa2);
cstmt.setString(3,pa3);
cstmt.setString(4,pa4);
cstmt.executeUpdate();
}
catch(SQLException ex)
{
System.err.println("sql_data.executeUpdate: " + ex.getMessage());
}
}
------------------------------------------
Here is the content of my jsp page ---
------------------------test.jsp------------------
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="searchdb" class="com.bigchina.jdbctest.sql_data" scope="page"/>
<html>
<head>
<title>test</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
searchdb.thetest("2222","DDDD","DDDDDD","FFFF"
;%>
------------------------------------------
Here is the content of my Interbase store procedure ---
------------------------TTT------------------
CREATE PROCEDURE "ttt" (
PBID VARCHAR(20),
PBNAME VARCHAR(36),
PBCITY VARCHAR(20),
PBTEL VARCHAR(30))
AS
BEGIN
Insert into phbook
VALUES
PBID,BNAME,BCITY,BTEL);SUSPEND;
END
------------------------------------------
When the jsp run ,Tomcat display----
sql_data.executeUpdate: [interclient][interbase] Dynamic SQL Error
SQL error code = -204
Procedure unknown
TTT
I don't know how to do.Please help me.Thank you!
PS:My english is poor ,sorry.^_^