🚀 go-pugleaf

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:
> 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:68)
>  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:68)
>  at tools.StoredTest.<init>(StoredTest.java:20)
>  at tools.StoredTest.main(StoredTest.java:29)
> 
> Thanks
> Christa
> 
> 
> "John Moore (TeamB)" <jbm@microps.com> schrieb im Newsbeitrag 
> news:44a023aa$1@newsgroups.borland.com...
>> Christa Schneider wrote:
>>> 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)
>>>
>>
>> Ok.. the problem is that your resultset has no metadata attached.. (it's 
>> null)  Notice "ResultSetMetaData.getColumnCount(...)"
>>
>> I have never used this syntax.. (row.getObject(..)) so I'm not familiar 
>> with what it returns. I would research this first.. It could be a jdbc 
>> implementation issue.. (contact Postgresql folks.. maybe..??)
>>
>> John...
>>
>>
>>> 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@microps.com> schrieb im Newsbeitrag 
>>> news:449d80af$1@newsgroups.borland.com...
>>>> It should...
>>>>
>>>> What errors are you getting.. (stacktrace.. please...)
>>>>
>>>> John...
>>>>
>>>>
>>>>
>>>>
>>>> Christa Schneider wrote:
>>>>> 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@microps.com> schrieb im Newsbeitrag 
>>>>> news:449c3030$1@newsgroups.borland.com...
>>>>>> Christa Schneider wrote:
>>>>>>
>>>>>>> StorageDataSet pd=new StorageDataSet();
>>>>>>> db.resultSetToDataSet(ds,rs1); //or pd = db.resultSetToDataSet(rs1);
>>>>>> Try...
>>>>>>
>>>>>> StorageDataSet pd=new StorageDataSet();
>>>>>> db.resultSetToDataSet(pd,rs1);
>>>>>>
>>>>>>
>>>>>> -- 
>>>>>> =============================================
>>>>>> TeamB are volunteer helpers.  Please DO NOT REPLY VIA EMAIL!
>>>>>> Post all questions and replies to this newsgroup ONLY
>>>>>> For papers on DataExpress, Applets, JSP, and Web Development go to:
>>>>>> http://www.microps.com/mps/paperFAQ.html
>>>>>> ====================================================
>>>>>>
>>>>>
>>>> -- 
>>>> =============================================
>>>> TeamB are volunteer helpers.  Please DO NOT REPLY VIA EMAIL!
>>>> Post all questions and replies to this newsgroup ONLY
>>>> For papers on DataExpress, Applets, JSP, and Web Development go to:
>>>> http://www.microps.com/mps/paperFAQ.html
>>>> ====================================================
>>>>
>>>
>>>
>>
>> -- 
>> =============================================
>> TeamB are volunteer helpers.  Please DO NOT REPLY VIA EMAIL!
>> Post all questions and replies to this newsgroup ONLY
>> For papers on DataExpress, Applets, JSP, and Web Development go to:
>> http://www.microps.com/mps/paperFAQ.html
>> ====================================================
>>
> 
> 
> 


-- 
=============================================
TeamB are volunteer helpers.  Please DO NOT REPLY VIA EMAIL!
Post all questions and replies to this newsgroup ONLY
For papers on DataExpress, Applets, JSP, and Web Development go to:
http://www.microps.com/mps/paperFAQ.html
====================================================