BorlandTalk.com

Christa Schneider · Guest

Hi,

I have a problem with ProcedureDataSet it doesn't work and I don't know
why?
I work with JBuilder 9 and Postgres 7.4 (Postgres 8.01)

Here is the Quellcode:

row.addColumn("ref", Variant.OBJECT, ParameterType.RETURN);
row.getColumn("ref").setSqlType(Types.OTHER);
row.addColumn("krit", Variant.STRING, ParameterType.IN);
row.setString("krit", "where value=15");

//Error!
db.setAutoCommit(false);
pr.setProcedure(new com.borland.dx.sql.dataset.ProcedureDescriptor(db, "{? =
call func(?)}", row, true, Load.ALL));
pr.executeQuery();

When I called it with ProcedureProvider it works fine, but I get a
NullPointerException by db.resultSetToDataSet

ProcedureProvider p = new ProcedureProvider();
p.callProcedure(db, "{:ref = call func(:krit)}", row);
ResultSet rs1 = (ResultSet) row.getObject("ref");

//Error! NullPointerException
StorageDataSet pd=new StorageDataSet();
db.resultSetToDataSet(ds,rs1); //or pd = db.resultSetToDataSet(rs1);

Can anybody help me?
Thanks
Christa Schneider

John Moore (TeamB) · Guest

Christa Schneider wrote:

Christa Schneider · Guest

Thank you for the answer, but it is only a type mistake.

THIS DOESN' T WORK, why?
StorageDataSet pd=new StorageDataSet();
db.resultSetToDataSet(pd,rs1); //or pd = db.resultSetToDataSet(rs1);

Thanks
Christa Schneider

"John Moore (TeamB)" <jbm (AT) microps (DOT) com> schrieb im Newsbeitrag
news:449c3030$1 (AT) newsgroups (DOT) borland.com...

John Moore (TeamB) · Guest

It should...

What errors are you getting.. (stacktrace.. please...)

John...

Christa Schneider wrote:

Christa Schneider · Guest

Here the exeption:
java.lang.NullPointerException
at
org.postgresql.jdbc2.AbstractJdbc2ResultSetMetaData.getColumnCount(AbstractJdbc2ResultSetMetaData.java:34)
at com.borland.dx.sql.dataset.RuntimeMetaData.a(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.a(Unknown Source)
at com.borland.dx.sql.dataset.Database.resultSetToDataSet(Unknown Source)
at tools.StoredTest.jbInit(StoredTest.java:73)
at tools.StoredTest.<init>(StoredTest.java:20)
at tools.StoredTest.main(StoredTest.java:29)

This is the code:
ResultSet rs1 = (ResultSet) row.getObject("ref");
StorageDataSet pd=new StorageDataSet();
db.resultSetToDataSet(pd,rs1);
while (pd.next()) {
System.out.println(pd.getString(3));
}
/*
//this works
while(rs1.next()) {
System.out.println(rs1.getString(3));
}
*/
Thanks
Christa

"John Moore (TeamB)" <jbm (AT) microps (DOT) com> schrieb im Newsbeitrag
news:449d80af$1 (AT) newsgroups (DOT) borland.com...

John Moore (TeamB) · Guest

Christa Schneider wrote:

Christa Schneider · Guest

Thank you very much, I will try it.

I think it is not the best way, but I know no other.

I have a problem with setProcedure too!
I haven't found any example that works.

Is there a way to run this?

Database db = new Database();
ProcedureDataSet pr = new ProcedureDataSet();
db.setAutoCommit(false);
row.addColumn("ref", Variant.OBJECT, ParameterType.OUT);
row.getColumn("ref").setSqlType(Types.OTHER);
row.addColumn("krit", Variant.STRING, ParameterType.IN);
row.setString("krit", "where k_kd_id=15");

// pr.addColumn("ref",Variant.OBJECT);
// pr.addColumn("krit",Variant.STRING);

pr.setProcedure(new com.borland.dx.sql.dataset.ProcedureDescriptor(db,
"{:ref = call func_tn_im_kurs(:krit) }", row, true,
Load.ALL));

//pr.open(); // Exeption: close the DataSet first.

pr.executeQuery(); //GET THE Exception

while (pr.next()) {
System.out.println(pr.getString(3));
}

See com.borland.dx.dataset.DataSetException error code: BASE+47
com.borland.dx.dataset.DataSetException: Chain of 2 or more Exceptions
occurred
at com.borland.dx.dataset.DataSetException.a(Unknown Source)
at com.borland.dx.dataset.DataSetException.throwExceptionChain(Unknown
Source)
at com.borland.dx.sql.dataset.JdbcProvider.c(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)
at com.borland.dx.sql.dataset.ProcedureDataSet.refresh(Unknown Source)
at com.borland.dx.sql.dataset.ProcedureDataSet.executeQuery(Unknown Source)
at tools.StoredTest.jbInit(StoredTest.java:6 Cool

at tools.StoredTest.<init>(StoredTest.java:20)
at tools.StoredTest.main(StoredTest.java:29)
Chained exception:
org.postgresql.util.PSQLException: Connection is closed. Operation is not
permitted.
at
org.postgresql.jdbc1.AbstractJdbc1ResultSet.next(AbstractJdbc1ResultSet.java:138)
at com.borland.dx.sql.dataset.JdbcProvider.a(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.c(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)
at com.borland.dx.sql.dataset.ProcedureDataSet.refresh(Unknown Source)
at com.borland.dx.sql.dataset.ProcedureDataSet.executeQuery(Unknown Source)
at tools.StoredTest.jbInit(StoredTest.java:6 Cool

at tools.StoredTest.<init>(StoredTest.java:20)
at tools.StoredTest.main(StoredTest.java:29)

Thanks
Christa

"John Moore (TeamB)" <jbm (AT) microps (DOT) com> schrieb im Newsbeitrag
news:44a023aa$1 (AT) newsgroups (DOT) borland.com...

John Moore (TeamB) · Guest

Christa,

The error appears to be in

org.postgresql.jdbc1.AbstractJdbc1ResultSet.next

Normally I would have used..

while (pr.inbounds()) {
System.out.println(pr.getString(3));
pr.next();
}

.... to walk the dataset..

Also your syntax for the procedure call may be off.. It looks like you
are using the function call not the procedure call syntax..

{ call ProcedureName (?,?,?)}

What I would suggest is to great a small "application" and use the
ProcedureDataSet property dialog to make these settings.. Then you can
use "Browse Procedures" and it will help write the code for the setup.

Sorry I'm not that much help.. I mostly use Interbase/Firebird and I
access store procedures using the select syntax

John...

Christa Schneider wrote: