select * from xxx fails

Hi there,

I succesfully Installed the JBuilder 2005 Developer Trial version and an
underlaying JDBC driver from MS for MSSQL. I use the "Create a basic
database application" tutorial. When I want to use a 'select * from xxx'
alike statement I get always the following error message: "Underlying
input stream returned zero bytes", and nothing is shown in the JTable
component. What causes this? How to solve it?

Bye
Alex

Bolla,

There are a number of steps prior to that, of which you do not
indicate were successfull

1) Did you setup a connection to the correct JDataStore database and
test the connection?

2) How did you setup the QueryDataSet..?? Did you test it in the QDS
dialog?

I just repeated those steps for the JDataStore "employee.jds" and
queried the ADDRESS table successfully.

John..

--
=============================================
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
================================================== ==

Yes I successfully made the connecitons and what the tutorial describes.
I made a small application, that list's the results of the query I add
from a textbox. Every query that include only few columns works, but
when I give a query that includes the * statement except of the columns
fails the run.

Thx
alex

When you select the querydataset component and then select the "query"
property, you get a dialog.

You then set the "database" to your previously created database
connection (the one you tested and it worked)

Then you type in your SQL statement.

select * from ADDRESSES

Then you can click the Test button..

...this all worked for me..

John..

--
=============================================
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
================================================== ==

That's also a problem, this kind of Query does not work for me in this
test phase (designtime).

Thx anyway
Alex

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

3 3rd November 14:04 bolla_sándor External User Posts: 1	*select from xxx fails** Yes I successfully made the connecitons and what the tutorial describes. I made a small application, that list's the results of the query I add from a textbox. Every query that include only few columns works, but when I give a query that includes the * statement except of the columns fails the run. Thx alex

5 3rd November 14:05 bolla_sándor External User Posts: 1	*select from xxx fails** That's also a problem, this kind of Query does not work for me in this test phase (designtime). Thx anyway Alex