🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

🏠 Home 📰 News 🗂️ Usenet Search 🔑 Login 📝 Register
Thread View: borland.public.jbuilder.database
8 messages
[T] Back to Threads [V] Tree View [G] Group Articles
8 total messages Started by Christa Schneider Fri, 23 Jun 2006 11:01
ProcedureDataSet and resultSetToDataSet doesn't work
#204
Author: Christa Schneider
Date: Fri, 23 Jun 2006 11:01
33 lines
1975 bytes 
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
Re: ProcedureDataSet and resultSetToDataSet doesn't work
#206
Author: John Moore (TeamB)
Date: Fri, 23 Jun 2006 18:17
18 lines
1643 bytes 
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
====================================================
Re: ProcedureDataSet and resultSetToDataSet doesn't work
#207
Author: Christa Schneider
Date: Fri, 23 Jun 2006 18:56
30 lines
1964 bytes 
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
> ====================================================
>
Re: ProcedureDataSet and resultSetToDataSet doesn't work
#208
Author: John Moore (TeamB)
Date: Sat, 24 Jun 2006 18:13
51 lines
2406 bytes 
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
====================================================
Re: ProcedureDataSet and resultSetToDataSet doesn't work
#209
Author: Christa Schneider
Date: Sat, 24 Jun 2006 22:00
81 lines
3549 bytes 
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@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
> ====================================================
>
Re: ProcedureDataSet and resultSetToDataSet doesn't work
#210
Author: John Moore (TeamB)
Date: Mon, 26 Jun 2006 18:12
104 lines
4610 bytes 
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
====================================================
Re: ProcedureDataSet and resultSetToDataSet doesn't work
#211
Author: Christa Schneider
Date: Tue, 27 Jun 2006 08:19
173 lines
7162 bytes 
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
> ====================================================
>
Re: ProcedureDataSet and resultSetToDataSet doesn't work
#212
Author: John Moore (TeamB)
Date: Wed, 28 Jun 2006 21:19
211 lines
8678 bytes 
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
====================================================
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads