AW: error accessing database from servlet

["Mihael Knezevic" <m.knezevic@xxxxxxxx>]

ok. did that. it uses the . to separate the lib from the file. but i get
a cursor not valid error. what could possibly be wrong? what does the
error mean?

-----Ursprüngliche Nachricht-----
Von: Ducret, Gilles (CH) [mailto:Gilles.DUCRET@lloydsbank.ch]
Gesendet: Donnerstag, 13. Juni 2002 17:25
An: 'java400-l@midrange.com'
Betreff: RE: error accessing database from servlet


This message is in MIME format. Since your mail reader does not
understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
If you use the com.ibm.db package (the IBM databeans) to access
the database you can use a method on the connection to know
what separator using (. or /)

It is getCatalogSeparator()

-----Original Message-----
From: Mihael Knezevic [mailto:m.knezevic@porta.de]
Sent: jeudi, 13. juin 2002 17:18
To: java400-l@midrange.com
Subject: error accessing database from servlet


hi,

i got a problem accessing the database from a servlet. my problem lies
in the syntax of the sql statement.

if i write:

select * from lib/file

i get the error: class java.sql.SQLException SQL5016 Qualifizierter
Objektname <myfile> nicht gültig. (in english something like: Qualified
objectname <myfile> is not valid.)

else if i write:

select * from lib.file

then i get the error class java.sql.SQLException cursor position not
valid.

what am i doing wrong?
_______________________________________________
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


**********************************************************************
This E-mail and any files transmitted with it are confidential
and intended for the exclusive use of the addressee(s) only.
 You should not disclose its contents to any other person.
If you are not the intended recipient please notify the sender
immediately.
**********************************************************************
_______________________________________________
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.