[JDBC] Problem while using result set

2001-08-20 Thread RaviShankar K
Hello, I am getting the following error sometimes, while using resultset.next() . (As the OS is Linux Japanese vesrion , there are some specialchars in the message.) An I/O error occured while reading from backend - Exception: java.net.SocketException:

Re: [JDBC] select on multiple tables

2001-08-20 Thread Ben Carterette
This won't work because I don't know in advance of the SELECT which tables I'm going to be selecting from. The SELECT is done in a servlet that determines the tables based on request parameters. I tried SELECT table1.*, table2.* FROM table1, table2, but it still can't tell the difference

RE: [JDBC] select on multiple tables

2001-08-20 Thread Carterette, Ben
The SELECT is in a servlet, something like this: rs = stmt.executeQuery(SELECT * FROM + request.getParameter(table1) + , + request.getParameter(table2)); session.setAttribute(result, rs); request.sendRedirect(request.getParameter(page2)); that's a simplification of what it does, but it's good

[JDBC] Accessing multiple Databases at the same time

2001-08-20 Thread Lucas, Fred
Title: Accessing multiple Databases at the same time Hi, Is there a way to SELECT tables or create JOINs from multiple databases through psql? I have read through Mr. Momjian's book and looked at the online documentation and cannot find a reference to it. I have been using the USE

Re: [JDBC] Accessing multiple Databases at the same time

2001-08-20 Thread Rene Pijlman
On Mon, 20 Aug 2001 16:08:31 -0600, you wrote: Is there a way to SELECT tables or create JOINs from multiple databases through psql? [...] would this have to be handled programmatically with multiple database connections? Yes, you need multiple connections for that. By the way, if you really