Article View: borland.public.jbuilder.database
Article #209Re: ProcedureDataSet and resultSetToDataSet doesn't work
From: Christa Schneider
Date: Sat, 24 Jun 2006 22:00
Date: Sat, 24 Jun 2006 22:00
81 lines
3549 bytes
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
> ====================================================
>
Technical Details
Message-ID:
<449db611@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!news-out.nntp.be!sp6iad.superfeed.net!in2.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<449bca0b$1@newsgroups.borland.com> <449c3030$1@newsgroups.borland.com> <449c3946$1@newsgroups.borland.com> <449d80af$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 1073da,de14a88c3d1af0e4 X-Google-Attributes: gid1073da,public X-Google-Language: ENGLISH,ASCII-7-bit Subject: Re: ProcedureDataSet and resultSetToDataSet doesn't work From: "Christa Schneider" <csk@ignicon.de> Date: Sun, 25 Jun 2006 00:00:42 +0200 Message-ID: <449db611@newsgroups.borland.com> References: <449bca0b$1@newsgroups.borland.com> <449c3030$1@newsgroups.borland.com> <449c3946$1@newsgroups.borland.com> <449d80af$1@newsgroups.borland.com> Lines: 83 NNTP-Posting-Host: 85.181.118.125 Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!news-out.nntp.be!sp6iad.superfeed.net!in2.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail Newsgroups: borland.public.jbuilder.database X-Trace: newsgroups.borland.com 1151186449 85.181.118.125 (24 Jun 2006 15:00:49 -0700) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2869 X-RFC2646: Format=Flowed; Response X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869