[GENERAL] JDBC compile

2001-04-10 Thread Tony Grant
Can someone please point me to a precompiled jdbc driver for 7.1RC4 and JDK1.3 I just don't have the patience to figure out what is going wrong here. /usr/share/ant Ant install made a /usr/share/java withe the jar files in it. Java is installed on the machine as /usr/java/jdk1.3 [javac]

[GENERAL] JDBC problem with Postgres 7.0.3

2001-02-23 Thread Santosh Rau
Hello, I am using the postgres driver for my Java code (JDK 1.2.2) which came with the Postgres 7.0.3 tar file. I am trying get the name of a column which is essentially the primary key in this table. Unfortunately, the result set returned does not have any records(as shown below). This code wo

Re: [GENERAL] jdbc connection pool settings

2001-02-13 Thread Peter T Mount
Quoting Culley Harrelson <[EMAIL PROTECTED]>: > I'm in the process of implementing connection pooling > and the setup I'm using (http://www.javaexchange.com - > really slick!) has settings for min # connections and > max # connection. Any suggestions on where I should > set these values? min=2,

Re: [GENERAL] jdbc connection pool settings

2001-02-12 Thread Anand Raman
it depends on what kind of concurrent connections u will be getting.. For admin interfaces the kind of settingu mentioned might be OK but in case it is a heavily loaded site then u need to think.. Anand On Mon, Feb 12, 2001 at 02:55:08PM -0800, Culley Harrelson wrote: >I'm in the process of imp

[GENERAL] jdbc connection pool settings

2001-02-12 Thread Culley Harrelson
I'm in the process of implementing connection pooling and the setup I'm using (http://www.javaexchange.com - really slick!) has settings for min # connections and max # connection. Any suggestions on where I should set these values? min=2, max=6? My site will be outside the firewall, open to the

[GENERAL] [JDBC][INTERFACES][NOVICE] Postgresql inteface to Star Office using JDBC

2001-02-06 Thread R9Pilot
Has anyone had any luck interfacing StarOffice to PostgreSQL using JDBC? Here is what I have tried: 1. Created a pgsql database called test2 on our linux machine (rh 6.2/postgresql 7.0.3). 2. Placed the jdbc7.0-1.2.jar file in the class path on my windows machine and renamed it to postgresql.jar.

Re: [GENERAL] JDBC & geo objects

2001-02-01 Thread Peter T Mount
Quoting elein <[EMAIL PROTECTED]>: Redirecting to the jdbc list... > > I'm a Java novice and I would like to be able to > use JDBC to get Points and Paths into a Java > program as native Java objects. Note that the > binary form of Paths is more than a simple array. > > I know how to do thi

Re: [GENERAL] jdbc, use of nested ResultSet loops.(longish, interesting I hope)

2001-01-30 Thread Peter T Mount
Quoting "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>: > A few days ago I posted a query regarding a problem I had with errors I > was > incurring doing some nested queries with the jdbc driver. (having > recently > done a re-install my email history is in limbo for the moment) > > Found some of my

[GENERAL] jdbc, use of nested ResultSet loops.(longish, interesting I hope)

2001-01-28 Thread [EMAIL PROTECTED]
A few days ago I posted a query regarding a problem I had with errors I was incurring doing some nested queries with the jdbc driver. (having recently done a re-install my email history is in limbo for the moment) Found some of my problems were in messy ugly code, fixed some of the problems by

[GENERAL] JDBC connection failure

2001-01-27 Thread Culley Harrelson
Hi, I'm pulling my hair out trying to establish a jdbc connection to postgresql. The error I recieve is: unable to load class postgresql.Driver I can however import org.postgresql.util.* without generating an error through tomcat when I put the postgresql.jar directly in the /usr/local/tomcat/

Re: [JDBC] [GENERAL] JDBC: java.lang.ArrayIndexOutOfBoundsException: 256

2001-01-25 Thread Peter T Mount
Quoting Mirko Zeibig <[EMAIL PROTECTED]>: Redirecting to the jdbc only list as that's where all jdbc emails should now go. > Hello, > my system: > RedHat 7.0 > postgresql 7.1 (CVS) > IBMJava2-SDK-1.3-1.1 > > After having set JAVA_HOME "ant" is working like a charm, now it will > build > postgre

[GENERAL] JDBC org.postresql.Driver

2001-01-11 Thread Ian deSouza
Hi All, I'm wondering if there could be a problem in the JDBC driver. I'm calling: preparedStatement.setObject(i, value); where value is of type Boolean (with value false below)and created the column associated with that value as type BIT and I'm getting the following exception when the prepar

[GENERAL] JDBC DRIVER

2000-10-26 Thread Enrico Comini
I 'm triyng to use JDBC driver with PostgreSQL, but I don't see the Indexes of the tables. Why ?

Re: [GENERAL] JDBC

2000-09-05 Thread Zeljko Trogrlic
<http://petermount.com>http://petermount.com > PostgreSQL JDBC: > <http://www.retep.org.uk/postgres/>http://www.retep.org.uk/postgres/ > Java PDF Generator: <http://www.retep.org.uk/pdf/>http://www.retep.org.uk/pdf/ >> >> - Original Message - >> Fr

[GENERAL] JDBC and Unicode problem

2000-09-05 Thread Zeljko Trogrlic
Hello, I'm trying to store / retrieve data from UNICODE database, but without success. I installet PostgreSQL 7.02 binaries for RedHat Linux on RH 6.2 I created database with UNICODE as charset (createdb -E UNICODE name) I can establish JDBC connection and everything works fine when I use ASCII

Re: [GENERAL] JDBC

2000-09-05 Thread Peter Mount
-Postrges-general Sent: Tuesday, September 05, 2000 10:05 AM Subject: [GENERAL] JDBC Scuse me I am interesting in a COMPILED debugged version of JDBC driver for 7.02 (driver for J 1.2,1.2 and1.3). Thanks,     Enrico

[GENERAL] JDBC

2000-09-05 Thread Enrico Comini
Scuse me I am interesting in a COMPILED debugged version of JDBC driver for 7.02 (driver for J 1.2,1.2 and1.3). Thanks,     Enrico

[GENERAL] JDBC

2000-09-04 Thread Enrico Comini
HI,I'm having a strange problem connecting to postgres 7.02 using thejdbc driver.  After installing the driver in Jbuilder 3, I'm ableto connect to my database but can ONLY see the postgres system indexesin Jbuilder's JDBC Explorer GUI.  I'm unable to see my other databaseobjects (tables, v

Re: [GENERAL] JDBC

2000-08-24 Thread Peter Mount
AIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 25, 2000 2:32 AM Subject: [GENERAL] JDBC > Hi, > > I've installed PostgreSQL 7.02 RPM Version with it's JDBC package RPM, now i'm trying to run my java application that connects to postgresql.

VS: [GENERAL] JDBC

2000-08-24 Thread Janne Blomqvist
Hi, I've installed PostgreSQL 7.02 RPM Version with it's JDBC package RPM, now i'm trying to run my java application that connects to postgresql. driver: postgresql.Driverand connection: jdbc:postgresql:mydb I got errors saying class not found. i tried to check for the file po

[GENERAL] JDBC

2000-08-24 Thread Jackson Ching
Hi, I've installed PostgreSQL 7.02 RPM Version with it's JDBC package RPM, now i'm trying to run my java application that connects to postgresql. driver: postgresql.Driverand connection: jdbc:postgresql:mydb I got errors saying class not found. i tried to check for

[GENERAL] JDBC invoke of Postgres stored procs?

2000-07-11 Thread Randall Parker
Simple question: Can the functions created via CREATE FUNCTION be invoked via the JDBC driver?

AW: [GENERAL] JDBC and LOB

2000-07-11 Thread tna
Hi, > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]Im > Auftrag von Gabriel López Millán > Gesendet am: Montag, 10. Juli 2000 12:34 > An: postgres; postgres-ayuda > Betreff: [GENERAL] JDBC and LOB > > Hi,

[GENERAL] JDBC: Encrypted connections? SSL?

2000-07-07 Thread Randall Parker
With PostgreSQL is there any way to have encrypted connections to the database? Also, once the SSL patent expires in Sept or Oct of this year has any thought been given to SSL support? Could one easily implement this by picking up the source to the OpenBSD package that is for this purpose? The

[GENERAL] JDBC problem on Postgresql 7 beta 5

2000-05-02 Thread Jack Zhu
Hi, PostgreSQL 7 Beta 5 on Red hat Linux 6.0 JDBC 6.5-1.1 driver, Java 1.1.7B, download JDBC driver from http://www.retep.org.uk/postgres/ We have a a table which has a column col_a with 'timestamp' data type. When insert time value to this column, we use format which is 'MM/DD/ HH24:MI:SS'

Re: [GENERAL] jdbc access

2000-03-13 Thread Peter Eisentraut
Chris Gokey writes: > I am trying to connect via JDBC to the database. The database requires > authentification in the form of userid/password. Using psql, I > typed CREATE USER XXX IDENTIFIED BY YYY. But, the postmaster is till denying > access to the database. How do I create userid/passwo

Re: [GENERAL] jdbc access

2000-03-13 Thread Peter Eisentraut
Chris Gokey writes: > Funny though, I can't figure out what the purpose of CREATE USER from > the psql prompt is used for anymore? It seems all user creation is done > from the unix prompt. Actually createuser is a script that essentially calls psql -c "CREATE USER ...". -- Peter Eisentrau

Re: [GENERAL] jdbc question

2000-01-19 Thread Albert Loo
From: [EMAIL PROTECTED] (Micheal H.) >Here's the code.It compiles but never gets past "Failed to load >postgresql driver" your classpath setting might be wrong, it must includes the jar filename as well, such as : CLASSPATH = /usr/local/lib/postgresql.jar you might also want to try : //S

[GENERAL] jdbc small example

1999-10-20 Thread soundar rajan
Hi all, If someone can tell me how to start with, connecting java to postgresql. I suppose I'm right. But, I get some errors. import java.sql.*; public class jd{ public static void main(String[]a rgs){ Class.forName("postgresql.Driver"); String url = "j

[GENERAL] jdbc small example

1999-10-20 Thread soundar rajan
Hi all, If someone can tell me how to start with, connecting java to postgresql. I suppose I'm right. But, I get some errors. import java.sql.*; public class jd{ public static void main(String[]a rgs){ Class.forName("postgresql.Driver"); String url = "j

[GENERAL] jdbc small example

1999-10-20 Thread soundar rajan
Hi all, If someone can tell me how to start with, connecting java to postgresql. I suppose I'm right. But, I get some errors. import java.sql.*; public class jd{ public static void main(String[]a rgs){ Class.forName("postgresql.Driver"); String url = "j

Re: [GENERAL] jdbc driver problem

1999-10-17 Thread Peter Mount
On Fri, 15 Oct 1999, soundar rajan wrote: > Hi, > > I'm using postgresql under Linux with jdk1.2. When I > try to 'make' under /src/interfaces/jdbc to get the > jdbc driver, I get the java.version to be 1.0b4. But, > this output doesn't generate any driver, or in fact > the postgresql.jar file

Re: [GENERAL] jdbc problem

1999-10-16 Thread Jim Richards
>I am using postgresql under linux. Now that I need to >build up the jdbc driver for postgresql, when I make >under the directory /src/interfaces/jdbc.. I get an >error stating '(u' unexpected syntax... > >The version returned by the make is 1.0b4. The >makeVersion.java file returns jdbc0 as t

[GENERAL] jdbc problem

1999-10-15 Thread soundar rajan
Hi, I am using postgresql under linux. Now that I need to build up the jdbc driver for postgresql, when I make under the directory /src/interfaces/jdbc.. I get an error stating '(u' unexpected syntax... The version returned by the make is 1.0b4. The makeVersion.java file returns jdbc0 as the

Re: [GENERAL] JDBC

1999-08-16 Thread Peter Mount
On Sat, 7 Aug 1999 [EMAIL PROTECTED] wrote: > Does anyone know of a source for some sample code for using jdbc or an > online tutorial? There's an entire directory of examples included with the source code. Peter -- Peter T Mount [EMAIL PROTECTED] Main Homepage: http://www.retep.o

[GENERAL] JDBC and insert - stack overflow

1999-05-24 Thread Crispin Miller
Hi, I am afraid I am a newbie. Forgive me if this is a silly question- I'm trying to create a large database using JDBC to load the tables by calling executeUpdate with the statement "SQL INSERT INTO" + tableName + " VALUES (" etc... After 14 and a half thousand rows the java virtual machine cras

[GENERAL] JDBC and getPrimaryKey()

1999-03-22 Thread Lincoln Spiteri
Hello, I know that this has been discussed before but a definite answer has never really been given. When I use the JDBC getPrimaryKey call for a table nothing is returned. I have gone through the sources of the driver and manually tried the query issued in the getPrimaryKey function. No luck. It

Re: [GENERAL] jdbc + postgres

1998-10-21 Thread Przemyslaw Bak
On Tue, 20 Oct 1998, Peter T Mount wrote: > > Message:Connection failed: java.net.ConnectException: Connection refused > > This seems to be the most common problem ;-) > > You are not running the backend with the -i arg, which turns on tcp/ip. Thank you. Two characters more and everything work

[GENERAL] JDBC with POSTGRES

1998-08-25 Thread Gilles Darold
Hello, I have a little problem with connecting a Java standalone application and Postgresql 6.3.2. In fact it doesn't connect. Before sending you the error output, is anybody can tell me if I have to declare a user/password in the h_dba_conf if I want this to work? I ask this because I can't t

<    1   2   3   4