Re: [JDBC] JDBC driver implementation

[Barry Lind]

The jdbc driver does not support updateable result sets.  If you want to 
update the data you need to do it the old fashioned way (i.e. use update 
SQL statements).

thanks,
--Barry

Robinson wrote:

> Hello,
> 
> I have a situation where I just want the changes to be made temporarily 
> in the ResultSet.   I don't want to commit the changes to the 
> database.   When I use the ResultSet.updateString(...), 
> ResultSet.updateBoolean(...), or ResultSet.updateObject(...) methods;  I 
> get the message "This method is not yet implemented."  Looks like the 
> implementation for the above methods has not yet been provided in 
> version 7.1.2 
> 
> I don't know if I am alone in this situation.  Has anyone encountered 
> such a problem?  And how have you gotten around solving the it.
> 
> The problem:
> - Being unable to update an updatable resultset in PostgreSQL 7.1.2
> 
> Thanks
> 
> 
> 
> *Do You Yahoo!?*
> Make a great connection at Yahoo! Personals 
> .



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[JDBC] JDBC driver implementation

[Robinson]

Hello,
I have a situation where I just want the changes to be made temporarily in the ResultSet.   I don't want to commit the changes to the database.   When I use the ResultSet.updateString(...), ResultSet.updateBoolean(...), or ResultSet.updateObject(...) methods;  I get the message "This method is not yet implemented."  Looks like the implementation for the above methods has not yet been provided in version 7.1.2  
I don't know if I am alone in this situation.  Has anyone encountered such a problem?  And how have you gotten around solving the it.The problem:- Being unable to update an updatable resultset in PostgreSQL 7.1.2ThanksDo You Yahoo!?
Make a great connection at Yahoo! Personals.

[JDBC] JDBC driver in FFJ3.0

[Mihai Gheorghiu]

I installed FFJ3.0 on a RH7.0, jdk1.3.1 machine.
I followed the instructions for installing jdbc drivers and at the test
stage I got an error message: "Unable to perform action, null"
However, in the Output Window (on top of which the error window came up) I
have 4 lines that prove connection to the db:
Testing driver org.postgresql.Driver
Test getTables(): found 57 tables
Test getColumns(): Table addresses contains 20 columns
Test getPrimaryKeys(): Table addresses contains 1 primary keys
Does anyone know where the error might have come from? (including some
feature addresses table does not have).
Thank you all.


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Re: [JDBC] JDBC driver in pgsql 7.1 build problem

[Marko Kreen]

On Thu, May 03, 2001 at 11:35:23AM +0200, Rolf Schillinger wrote:
> Hi,
> I have strange problems trying to build the JDBC driver for postgresql
> 7.1:

try this patch:

  http://www.l-t.ee/marko/pgsql/ant12.diff

then 'make clean', 'make'

-- 
marko


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

[JDBC] JDBC driver in pgsql 7.1 build problem

[Rolf Schillinger]

Hi,
I have strange problems trying to build the JDBC driver for postgresql
7.1:
/usr/local/jakarta-ant-1.3/bin//ant -buildfile ../../../build.xml
-Dmajor=7 -Dminor=1 -Dfullversion=7.1 -Ddef_pgport=5432
Buildfile: ../../../build.xml

jar:

call:

prepare:

check_versions:

driver:
 [echo] Configured build for the JDBC2 edition driver.

compile:
[javac] Compiling 41 source files to
/usr/src/postgresql-7.1/src/interfaces/jdbc/build
[javac]
/usr/src/postgresql-7.1/src/interfaces/jdbc/org/postgresql/Driver.java:199: ';'
expected
[javac] return ${major};
[javac] ^
[javac]
/usr/src/postgresql-7.1/src/interfaces/jdbc/org/postgresql/Driver.java:209: ';'
expected
[javac] return ${minor};
[javac] ^
[javac]
/usr/src/postgresql-7.1/src/interfaces/jdbc/org/postgresql/Driver.java:199: cannot
resolve symbol
[javac] symbol  : variable $  
[javac] location: class org.postgresql.Driver
[javac] return ${major};
[javac]^
[javac]
/usr/src/postgresql-7.1/src/interfaces/jdbc/org/postgresql/Driver.java:209: cannot
resolve symbol
[javac] symbol  : variable $  
[javac] location: class org.postgresql.Driver
[javac] return ${minor};
[javac]^
[javac] Note: Some input files use or override a deprecated API.
[javac] Note: Recompile with -deprecation for details.
[javac] 4 errors

BUILD FAILED

/usr/src/postgresql-7.1/src/interfaces/jdbc/build.xml:99: Compile failed,
messages should have been provided.

Total time: 9 seconds
make: *** [all] Error 1

Any help would be greatly appreciated
bis bald, Rolf


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [JDBC] JDBC Driver under load

[Tom Lane]

What shows up in the postmaster's log when this happens?

(If you're not keeping a postmaster log, now would be a good time
to start.)

regards, tom lane

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[JDBC] JDBC Driver under load

[Mike Cannon-Brookes]

Has anyone used the JDBC driver under heavy load?

We're having a problem on one of our production machines that on some
occasions under heavy load Postgres JDBC connections seem to be dying /
locking up. Here's an example trace:

An I/O error occured while reading from backend - Exception:
java.net.SocketException: Connection reset by peer: Connection reset by peer
Stack Trace:
java.net.SocketException: Connection reset by peer: Connection reset by peer
at java.net.SocketInputStream.socketRead(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:86)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:186)
at java.io.BufferedInputStream.read(BufferedInputStream.java:204)
at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:181)
at org.postgresql.Connection.openConnection(Connection.java:160)
at org.postgresql.Driver.connect(Driver.java:122)

or

An I/O error occured while reading from backend - Exception:
java.net.SocketException: Broken pipe: Broken pipe
Stack Trace:
java.net.SocketException: Broken pipe: Broken pipe
at java.net.SocketInputStream.socketRead(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:86)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:186)
at java.io.BufferedInputStream.read(BufferedInputStream.java:204)
at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:181)
at org.postgresql.Connection.openConnection(Connection.java:160)
at org.postgresql.Driver.connect(Driver.java:122)
...
at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:184)
at org.postgresql.Connection.openConnection(Connection.java:160)
at org.postgresql.Driver.connect(Driver.java:122)

any ideas where to start looking?

-mike



---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

[JDBC] jdbc driver Multiple Resultsets

[Rajesh Balla]

Does the jdbc driver really support Multiple Resultsets?
If not, does the backend return multiple resultsets(for more than one query 
concatenated together)?

ie., For a query like
ResultSet rs = stmt.executeQuery("select * from table1; select * from table2;");
Does the resultset contain both the resultsets or only one result set. 

Note:
On Sat, 25 Apr 1998, Bruce Momjian wrote:

The JDBC spec allows for multiple ResultSet`s to be returned from a query, and our 
driver handles this already.
..
But when we tried doing the above query, the resultset had only the first resultset.

So,Does the jdbc driver really support Multiple Resultsets?
 
Thanks,
Rajesh


Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

Re: [JDBC] Jdbc driver

[Peter T Mount]

Quoting sugumar <[EMAIL PROTECTED]>:
> Connection con=DriverManager.getConnection
("jdbc:postgresql://192.168.230.148/meeting,postgres,postgres");

Your url is wrong, it should read

> Connection con=DriverManager.getConnection
("jdbc:postgresql://192.168.230.148/meeting","postgres","postgres");

Peter
-- 
Peter Mount [EMAIL PROTECTED]
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[JDBC] Jdbc driver

[sugumar]

sir ,
  i am using the 
following code for connecting postgresql,but this code did not to the other 
system database.please send the correct for the driver connection.
thanks,
regards 
sugumar
 
import java.sql.*;import java.io.*;import 
java.lang.*;import java.net.*;
 
class meeting123 {public static void 
main(String args[]) throws 
Exception{Class.forName("postgresql.Driver");Connection 
con=DriverManager.getConnection("jdbc:postgresql://192.168.230.148/meeting,postgres,postgres");Statement 
st=con.createStatement();ResultSet rs=st.executeQuery("select * from 
tbluser");while(rs.next()){System.out.println("StartHour:"+rs.getString(1)+"\tStartMin:"+rs.getString(2)+"\n");}} 
}
 

RE: [JDBC] JDBC Driver Trouble on Linux

[Michael Ansley]

Title: RE: [JDBC] JDBC Driver Trouble on Linux





;-) Don't ask how we found that out.
-Original Message-
From: Klaus Sonnenleiter [mailto:[EMAIL PROTECTED]]
Sent: 16 March 2001 16:43
To: Michael Ansley
Cc: [EMAIL PROTECTED]
Subject: RE: [JDBC] JDBC Driver Trouble on Linux



Yep, that did the trick - interesting...


At 03:55 PM 3/16/2001 +, you wrote:



Try unjarring the driver, and then jarring it back up again (making sure all the directories are correct) but WITHOUT compression.

$ jar -xvf postgresql.jar 
$ jar -cv0f postgresql.jar org 


The first command should unpack and unj(t)ar the jar file into an org directory with sub-directories.  The second command packs them all up again with no compression.

This has caused me problems in the past, although I have not gone into it in any depth, so I haven't identified the exact cause, or even exactly when it happens.

Let me know... 


MikeA 






>> -Original Message- 
>> From: Klaus Sonnenleiter [mailto:[EMAIL PROTECTED]] 
>> Sent: 16 March 2001 13:59 
>> To: [EMAIL PROTECTED] 
>> Subject: [JDBC] JDBC Driver Trouble on Linux 
>> 
>> 
>> I've installed Postgres on Linux and everything is working 
>> great with one 
>> exception: I can't get any JDBC drivers to work from a Linux 
>> client. I have 
>> a test program that connects and retrieves the content of a 
>> table. It works 
>> without any trouble on Windows and Solaris (connecting to 
>> the Linux box). 
>> But if I run it on the Linux machine that also has the 
>> Postgres database, I 
>> get a SQLException that says "No suitable driver". (And yes, the 
>> postgresql.jar is in the CLASSPATH, I also tried both binary 
>> versions from 
>> jdbc.postgresql.org and I tried JDKs 1.1.8_v3 and 1.2.2 with the 
>> corresponding driver versions). Did anybody see this before? 
>> 
>> TIA 
>> 
>> Klaus Sonnenleiter 
>> 
>> 
>> ---(end of 
>> broadcast)--- 
>> TIP 1: subscribe and unsubscribe commands go to 
>> [EMAIL PROTECTED] 
>> 



_
This e-mail and any attachments are confidential and may also be privileged and/or copyright 
material of Intec Telecom Systems PLC (or its affiliated companies). If you are not an 
intended or authorised recipient of this e-mail or have received it in error, please delete 
it immediately and notify the sender by e-mail. In such a case, reading, reproducing, 
printing or further dissemination of this e-mail is strictly prohibited and may be unlawful. 
Intec Telecom Systems PLC. does not represent or warrant that an attachment hereto is free 
from computer viruses or other defects. The opinions expressed in this e-mail and any 
attachments may be those of the author and are not necessarily those of Intec Telecom 
Systems PLC. 


This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses. 
__

RE: [JDBC] JDBC Driver Trouble on Linux

[Klaus Sonnenleiter]

Yep, that did the trick - interesting...

At 03:55 PM 3/16/2001 +, you wrote:

Try unjarring the
driver, and then jarring it back up again (making sure all the
directories are correct) but WITHOUT compression.

$ jar -xvf postgresql.jar 
$ jar -cv0f postgresql.jar org 

The first command should unpack and unj(t)ar the jar file
into an org directory with sub-directories.  The second command
packs them all up again with no compression.

This has caused me problems in the past, although I have not
gone into it in any depth, so I haven't identified the exact cause, or
even exactly when it happens.

Let me know... 

MikeA 





>> -Original Message- 
>> From: Klaus Sonnenleiter
[mailto:[EMAIL PROTECTED]]

>> Sent: 16 March 2001 13:59 
>> To: [EMAIL PROTECTED] 
>> Subject: [JDBC] JDBC Driver Trouble on Linux

>> 
>> 
>> I've installed Postgres on Linux and everything is working 
>> great with one 
>> exception: I can't get any JDBC drivers to work from a Linux 
>> client. I have 
>> a test program that connects and retrieves the content of a 
>> table. It works 
>> without any trouble on Windows and Solaris (connecting to 
>> the Linux box). 
>> But if I run it on the Linux machine that also has the 
>> Postgres database, I 
>> get a SQLException that says "No suitable driver". (And yes, the 
>> postgresql.jar is in the CLASSPATH, I also tried both binary 
>> versions from 
>> jdbc.postgresql.org and I tried JDKs 1.1.8_v3 and 1.2.2 with the 
>> corresponding driver versions). Did anybody see this before? 
>> 
>> TIA 
>> 
>> Klaus Sonnenleiter 
>> 
>> 
>> ---(end of 
>> broadcast)--- 
>> TIP 1: subscribe and unsubscribe commands go to 
>> [EMAIL PROTECTED] 
>> 


_
This e-mail and any attachments are confidential and may also be privileged and/or copyright 
material of Intec Telecom Systems PLC (or its affiliated companies). If you are not an 
intended or authorised recipient of this e-mail or have received it in error, please delete 
it immediately and notify the sender by e-mail. In such a case, reading, reproducing, 
printing or further dissemination of this e-mail is strictly prohibited and may be unlawful. 
Intec Telecom Systems PLC. does not represent or warrant that an attachment hereto is free 
from computer viruses or other defects. The opinions expressed in this e-mail and any 
attachments may be those of the author and are not necessarily those of Intec Telecom 
Systems PLC. 

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses. 
__

RE: [JDBC] JDBC Driver Trouble on Linux

[Michael Ansley]

Title: RE: [JDBC] JDBC Driver Trouble on Linux





Try unjarring the driver, and then jarring it back up again (making sure all the directories are correct) but WITHOUT compression.

$ jar -xvf postgresql.jar
$ jar -cv0f postgresql.jar org


The first command should unpack and unj(t)ar the jar file into an org directory with sub-directories.  The second command packs them all up again with no compression.

This has caused me problems in the past, although I have not gone into it in any depth, so I haven't identified the exact cause, or even exactly when it happens.

Let me know...



MikeA







>> -Original Message-
>> From: Klaus Sonnenleiter [mailto:[EMAIL PROTECTED]]
>> Sent: 16 March 2001 13:59
>> To: [EMAIL PROTECTED]
>> Subject: [JDBC] JDBC Driver Trouble on Linux
>> 
>> 
>> I've installed Postgres on Linux and everything is working 
>> great with one 
>> exception: I can't get any JDBC drivers to work from a Linux 
>> client. I have 
>> a test program that connects and retrieves the content of a 
>> table. It works 
>> without any trouble on Windows and Solaris (connecting to 
>> the Linux box). 
>> But if I run it on the Linux machine that also has the 
>> Postgres database, I 
>> get a SQLException that says "No suitable driver". (And yes, the 
>> postgresql.jar is in the CLASSPATH, I also tried both binary 
>> versions from 
>> jdbc.postgresql.org and I tried JDKs 1.1.8_v3 and 1.2.2 with the 
>> corresponding driver versions). Did anybody see this before?
>> 
>> TIA
>> 
>> Klaus Sonnenleiter
>> 
>> 
>> ---(end of 
>> broadcast)---
>> TIP 1: subscribe and unsubscribe commands go to 
>> [EMAIL PROTECTED]
>> 




_
This e-mail and any attachments are confidential and may also be privileged and/or copyright 
material of Intec Telecom Systems PLC (or its affiliated companies).  If you are not an 
intended or authorised recipient of this e-mail or have received it in error, please delete 
it immediately and notify the sender by e-mail.  In such a case, reading, reproducing, 
printing or further dissemination of this e-mail is strictly prohibited and may be unlawful. 
Intec Telecom Systems PLC. does not represent or warrant that an attachment hereto is free 
from computer viruses or other defects. The opinions expressed in this e-mail and any 
attachments may be those of the author and are not necessarily those of Intec Telecom 
Systems PLC. 

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses. 
__

[JDBC] JDBC Driver Trouble on Linux

[Klaus Sonnenleiter]

I've installed Postgres on Linux and everything is working great with one 
exception: I can't get any JDBC drivers to work from a Linux client. I have 
a test program that connects and retrieves the content of a table. It works 
without any trouble on Windows and Solaris (connecting to the Linux box). 
But if I run it on the Linux machine that also has the Postgres database, I 
get a SQLException that says "No suitable driver". (And yes, the 
postgresql.jar is in the CLASSPATH, I also tried both binary versions from 
jdbc.postgresql.org and I tried JDKs 1.1.8_v3 and 1.2.2 with the 
corresponding driver versions). Did anybody see this before?

TIA

Klaus Sonnenleiter


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[JDBC] JDBC driver

[Jarek]

Can you explain me class Serialize ?
I have found there ( I think so )  some bugs.

1. When method create recurses  down and finds class that have no fields, 
then it tries to execute query  that looks  somehow werid:

"create table java_lang_runtimepermission) "

"create table java_lang_object)"

2. On second thought I want to ask you, is class Serialize finished and 
working ? I have latest sources (7.0.3) and in file Serialize.java I found:
                 (...)
        if(type.isArray()) {
            // array handling
                } else {
         (...)

3. When or where can I get working version of this feature, I really need
it.
-- 
-- 
MS is not the answer.
MS is the question.
NO (or Linux) is the answer.

:) Jarek (:

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[JDBC] JDBC driver

[Jarek]

Can you explain me class Serialize ?
I have found there ( I think so )  some bugs.

1. When method create recurses  down and finds class that have no fields, 
then it tries to execute query  that looks  somehow werid:

"create table java_lang_runtimepermission) "

"create table java_lang_object)"

2. On second thought I want to ask you, is class Serialize finished and 
working ? I have latest sources (7.0.3) and in file Serialize.java I found:
 (...)
if(type.isArray()) {
// array handling
} else {
 (...)

3. When or where can I get working version of this feature, I really need
it.
-- 
MS is not the answer.
MS is the question.
NO (or Linux) is the answer.

:) Jarek (: