jdbc No result in resultset

From: <will_at_post.com>
Date: Mon, 04 Mar 2002 05:38:36 GMT
Message-ID: <3c830845.280005676@news.uni-muenster.de>

Hi folks,

I have a Oracle 8i installation running on a windows 2k machine. I created a database someDB with several tables. All tables were created via the SQL+ Workbench. I'm connecting to that database from another computer (win 2k as well) via jdbc. Everything works ok that far, I can query the different tables from the database, except for one table that stores some 60,000 lines.

If i do the query on the SQL+ workbench on the machine that runs the oracle database, it works perfectly. But when running exactly the same query from via the thin (I have to use that one) driver from a remote computer (but in the lcoal network), it does not work. Again, this only affects the huge table, all the other work perfectly.

Here is the create Statement, maybe it helps you finding my problem: It is probably quite bad designed since I have not very much experience with oracle.

CREATE TABLE travel (
  NoFrom varchar(8),
  frnlc varchar(8),
  frpsu varchar(8),
  UA varchar(8),
  orig VARCHAR(80),
  NoTo varchar(8),

  tonlc varchar(8),
  topsu varchar(8),
  dest VARCHAR(80),

  FNo varchar(8),
  KM varchar(8),
  INTERCHANGE VARCHAR(30),
  AD VARCHAR(12),
  AR VARCHAR(12),
  AOP VARCHAR(12),
  A7 VARCHAR(30),
  A7X VARCHAR(30),

  ALA7F VARCHAR(12),
  ala7x VARCHAR(12),
  ALC7F VARCHAR(12),
  alc7x VARCHAR(12),

  A30X VARCHAR(30),
  ALA30 VARCHAR(12),
  A30 VARCHAR(30),
  A90X VARCHAR(30),
  ALA90 VARCHAR(12),
  A90 VARCHAR(30),
  A180X VARCHAR(30),
  ALA180 VARCHAR(12),
  A180 VARCHAR(30),
  A365X VARCHAR(30),
  ALA365 VARCHAR(12),
  A365 varchar(8),
  CS varchar(8),
  CR varchar(8),
  COPr varchar(8),
  COP varchar(8),
  C7 varchar(8),
  C30X varchar(8),
  ALC30 varchar(8),
  C30 varchar(8),
  C90X varchar(8),
  ALC90 varchar(8),
  C90 varchar(8),
  C180X varchar(8),
  ALC180 varchar(8),
  C180 varchar(8),
  C365X varchar(8),
  ALC365 varchar(8),
  C365 varchar(8),
  SS varchar(8),
  SR varchar(8),
  PSr varchar(8),
  PS varchar(8),
  PRr varchar(8),

  PR varchar(8),
  HS varchar(8),
  HR varchar(8),

  AVAILABLEFOR VARCHAR(100),
  CONDITIONS VARCHAR(100),
  CHA varchar(8),
  ACH varchar(8),
  AOPCH varchar(8),
  CCH varchar(8),
  COPCH varchar(8),
  PRIMARY KEY (NoFrom,NoTo)
) Received on Sun Mar 03 2002 - 23:38:36 CST