[JDBC] Jbuilder Question..

2001-05-08 Thread Thys De [EMAIL PROTECTED]
Anybody have some sort of fix for jbuilder4 enterprise not displaying the tables in my db.. I'm using postgres 7.1 and the 7.0-1.2 jar file .. Please help .. Thanx Thys de Wet [mailto:[EMAIL PROTECTED]] ---(end of broadcast)--- TIP 5: Have you

[JDBC] AGAIN: still no answer ... peter, or anybody knowledgeable, please ....

2001-05-08 Thread Mark Rosa
dear all, unfortunately the jdbc1 driver can't be compiled. there are several errors popping up when compiling --with-java and also when i try to compile the jdbc interface individually: i already figured out two mistypings in the Statement.java file in src/interfaces/jdbc/org/postgresql/jdbc1

Re: [JDBC] AGAIN: still no answer ... peter, or anybodyknowledgeable, please ....

2001-05-08 Thread Tony Grant
On 08 May 2001 09:52:47 +0200, Mark Rosa wrote: > ps: btw. i tried this both on redhat-linux7.1 (java version "1.1.8") and > irix6.5.9m (java version "3.2 (Sun 1.1.8)") Can youn upgrade to JDK1.3.0_2? I can send you a .jar file but it will be for that JDK Cheers Tony Grant -- RedHat Linux

[JDBC] Why?? executeQuery() & exception: "No results were returned by the query."

2001-05-08 Thread Panu Outinen
Hi there ! Can anyone explain why does executeQuery() throws an exception "No results were returned by the query." when result set is empty ??? In my opinion (and also e.g. Oracle's JDBC driver's opinion) that this is just normal and user can check the number of rows (=0) that none was ret

[JDBC] Re: AGAIN: still no answer ... peter, or anybody knowledgeable,please ....

2001-05-08 Thread Michael Stephenson
> The current CVS sources look wrong to me. It has: > > if (result != null) && ((org.postgresql.ResultSet)result.reallyResultSet()) > > Shouldn't this be: > > if (result != null && ((org.postgresql.ResultSet)result.reallyResultSet())) > > Not sure if the extra parens are needed for: > > if

[JDBC] JDBC Download.

2001-05-08 Thread Thys De [EMAIL PROTECTED]
Can anyone please tell me wehere I can get the jdbc 7.1 jar .. I only seem to find the 7.0-1.2 jars .. Thanx Thys de Wet ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[JDBC] "No results" exception on insert

2001-05-08 Thread Brian_Williams
Hello, I have some code which is essentially doing the following: Statement stmt; ResultSet rs = stmt.executeQuery("insert into users values ( 'joe', 'blow' )"); The values are inserted into the table correctly. I verified this using psql: "select * from users". The problem is that the execut

Re: [JDBC] "No results" exception on insert

2001-05-08 Thread Mike D'Agosta
>Statement stmt; >ResultSet rs = stmt.executeQuery("insert into users values ( 'joe', 'blow' >)"); > >The problem is that the executeQuery throws an Exception. The message >is "No results were returned by the query": Try executeUpdate() for insert, create and delete. Mike ---

Re: [JDBC] "No results" exception on insert

2001-05-08 Thread Jeremy Buchmann
[EMAIL PROTECTED] wrote: > Hello, > > I have some code which is essentially doing the following: > > Statement stmt; > ResultSet rs = stmt.executeQuery("insert into users values ( 'joe', 'blow' > )"); > > The values are inserted into the table correctly. I verified this using > psql: > "selec

[JDBC] Is DataSource implemented?

2001-05-08 Thread Larry Mulcahy
Referring back to http://fts.postgresql.org/db/mw/msg.html?mid=82946, I tried to use [org.]postgresql.PostgresqlDataSource but could not find it in /usr/local/pgsql/share/java/postgresql.jar, created today by compiling PostgreSQL 7.1.1 from the sources. When I list postgresql.jar with jar tvf

Re: [HACKERS] MULTIBYTE and SQL_ASCII (was Re: [JDBC] Re: A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars?)

2001-05-08 Thread Tom Lane
Tatsuo Ishii <[EMAIL PROTECTED]> writes: >> Tom also mentioned that it might be possible for the server to support >> setting the character set for a database even when multibyte wasn't >> enabled. That would then allow clients like jdbc to get a value from >> non-multibyte enabled servers tha