This list is for discussing issues of InterBase, other than support.

Please post this support question to one of the InterBase support
groups. For details of support lists available, please visit the Mail
Lists page at the site below.

Thank you.

Christian


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________

Community email addresses:
Post message: IBDI@onelist.com
Subscribe: IBDI-subscribe@onelist.com
Unsubscribe: IBDI-unsubscribe@onelist.com
List owner: IBDI-owner@onelist.com

Shortcut URL to this page:
http://www.onelist.com/community/IBDI

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello all,
>
> Anyone know what I have done wrong? I have tried IC1.6 and
> IC2.0 on a linux
> platform.
>
> This class fails. Enclosed is the SQL for the database and
> also a class that
> recreates the failure.
>
>
> package ibtemp;
>
> import java.sql.*;
>
> /**
> * This class does not work with a database as specified
> * in the sql code:
> *
> * CREATE GENERATOR "GEN_PART";
> *
> * SET TERM ^ ;
> * CREATE PROCEDURE "GET_PART_UID"
> * RETURNS
> * (UID INTEGER)
> * AS
> * BEGIN
> * UID = GEN_ID(get_part, 1);
> * END ^
> *
> * SET TERM ; ^
> *
> *
> * It creates an:
> *
> * interbase.interclient.SQLException:
> [interclient][interbase] Dynamic SQL
> Error
> * parameter mismatch for procedure GET_PART_UID
> * at
> interbase.interclient.PreparedStatement.remote_PREPARE_STATEME
> NT(Unknown
> Source)
> * at interbase.interclient.PreparedStatement.<init>(Unknown Source)
> * at interbase.interclient.CallableStatement.<init>(Unknown Source)
> * at interbase.interclient.Connection.prepareCall(Unknown Source)
> * at ibtemp.Untitled1.<init>(Untitled1.java:12)
> * at ibtemp.Untitled1.main(Untitled1.java:20)
> *
> */
>
> public class Untitled1 {
>
> public Untitled1() throws Exception {
> Class.forName("interbase.interclient.Driver");
> Connection dbConnection = DriverManager.getConnection(
> "jdbc:interbase://telaxian/opt/database/DFS.gdb", "SYSDBA",
> "masterkey");
>
> CallableStatement stmt = dbConnection.prepareCall("{call
> GET_PART_UID}");
> ResultSet rs = stmt.executeQuery();
>
> }
>
>
> public static void main(String[] args) {
> try {
> Untitled1 untitled11 = new Untitled1();
> } catch (Exception ex) {
> ex.printStackTrace();
> }
> }
> }
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.4 (GNU/Linux)
> Comment: For info see http://www.gnupg.org
>
> iD8DBQE6gpuzPmm0AnNwb5MRAvlXAJ9wxgIO3St3SFrknTdf9wqfhH1HCQCggKy+
> uoGvRCjgpJ+fLlE1hpVL8XA=
> =4Qec
> -----END PGP SIGNATURE-----
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>