RE: [JDBC] Unable to connect to database

2001-08-20 Thread Michael Ansley (UK)
Title: RE: [JDBC] Unable to connect to database -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Although, even if the problem is sorted, it appears that you have an erratic JVM problem.  Having -i off should not cause your JVM to dump core.  On RH7.1 I know that I have to set LD_ASSUME_KERNEL=

RE: [JDBC] Problem while using result set

2001-08-20 Thread Dave Cramer
Title: Message Ravi,   In order to help you; we will require more information;   The absolute best is a small snippet of code which reproduces the problem; but at the very least the code leading up to the rs.next, and following it   What version of postgres are you running? What version of

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 b

Re: [JDBC] select on multiple tables

2001-08-20 Thread Rene Pijlman
On Thu, 16 Aug 2001 10:02:27 -0500, you wrote: >This won't work because I don't know in advance of the SELECT which >tables I'm going to be selecting from. I'm not sure if I understand this correctly. Whenever you write the SELECT statement you have to know the names of the tables, that's requ

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, bu

[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" statem

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

Re: [JDBC] select on multiple tables

2001-08-20 Thread Rene Pijlman
On Mon, 20 Aug 2001 12:50:22 -0500, you wrote: >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("p

RE: [JDBC] select on multiple tables

2001-08-20 Thread Dave Cramer
Unfortunately id doesn't return A.c and B.c. Try it in psql... One way to solve this is to fix the backend to return fully qualified column names. Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rene Pijlman Sent: August 20, 2001 3:49 PM To: Carte