Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!news.tele.dk!small.news.tele.dk!193.174.75.178!news-fra1.dfn.de!news-koe1.dfn.de!uni-muenster.de!not-for-mail
From: will@post.com
Newsgroups: comp.databases.oracle.misc
Subject: jdbc No result in resultset
Date: Mon, 04 Mar 2002 05:38:36 GMT
Organization: Westfaelische Wilhelms-Universitaet Muenster, Germany
Lines: 87
Sender: "Birger Fuehne" <fuhne@uni-muenster.de>
Message-ID: <3c830845.280005676@news.uni-muenster.de>
NNTP-Posting-Host: cpe-144-136-84-54.nsw.bigpond.net.au
X-Trace: redenix.uni-muenster.de 1015220168 20604 144.136.84.54 (4 Mar 2002 05:36:08 GMT)
X-Complaints-To: abuse@uni-muenster.de
NNTP-Posting-Date: 4 Mar 2002 05:36:08 GMT
X-Newsreader: Forte Free Agent 1.21/32.243
Xref: easynews comp.databases.oracle.misc:77577
X-Received-Date: Sun, 03 Mar 2002 23:15:21 MST (news.easynews.com)

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