Search Discussions

71 discussions - 261 posts

  • Hi !! I was trying to get a very nice FREE graphical db tool called DbVisualizer (http://www.ideit.com/products/dbvis/) to work with Postgresql and I found out the following bug: if database has ...
    Panu OutinenPanu Outinen
    May 3, 2001 at 3:31 pm
    May 16, 2001 at 4:41 pm
  • Morning folks ... Been wracking our brains on this one for too long now ... have a client that is trying to use JDBC to pull images stored in the database, and, from what we can gather, the images ...
    The Hermit HackerThe Hermit Hacker
    May 12, 2001 at 4:44 pm
    May 15, 2001 at 3:07 am
  • Can anyone please tell me wehere I can get the jdbc 7.1 jar .. <frustration I only seem to find the 7.0-1.2 jars .. </frustration Thanx Thys de Wet
    Thys De Wet@iCommerceThys De Wet@iCommerce
    May 8, 2001 at 6:10 pm
    May 9, 2001 at 4:24 pm
  • 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 ...
    Mark RosaMark Rosa
    May 8, 2001 at 7:53 am
    May 16, 2001 at 4:49 pm
  • Hi! I just got bitten by this too. I use type timestamp in the database, and often need the latest timestamp, but want to format it as a date. With 7.0.x, I just select ts from foo order by ts desc ...
    Palle GirgensohnPalle Girgensohn
    May 8, 2001 at 2:16 pm
    May 30, 2001 at 4:35 pm
  • After ./configure --with-java compilation (gmake) for 7.1.2 on RH 7.1 box failed with this error: [javac] /tmp/postgresql-7.1.2/src/interfaces/jdbc/example/blobtest.java:189: Class example.Blob not ...
    Laurentiu DrobLaurentiu Drob
    May 29, 2001 at 10:26 am
    May 30, 2001 at 5:52 am
  • 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 ...
    May 8, 2001 at 6:50 pm
    Aug 16, 2001 at 5:51 pm
  • Hello, Using JDBC, I was making a web access program for my postgres database. While the same code works in a Java program, when i convert it into a Java applet, i get a netscape security exception. ...
    B.N.V. RamanB.N.V. Raman
    May 15, 2001 at 6:35 am
    May 17, 2001 at 5:02 am
  • Hi again, it`s now offical, I found a bug in JDBC driver in pgsql 7.1 ;) I had the following problems: /usr/local/jakarta-ant-1.3/bin//ant -buildfile ../../../build.xml -Dmajor=7 -Dminor=1 ...
    Rolf SchillingerRolf Schillinger
    May 3, 2001 at 9:48 pm
    May 4, 2001 at 8:28 pm
  • Folks- I've got an idea on a possible extension to the jdbc driver. I want to submit a patch, but only if others think it makes sense. I want to add a 'clause' that would slightly change the return ...
    Ned WolpertNed Wolpert
    May 2, 2001 at 4:43 pm
    May 3, 2001 at 5:49 pm
  • Hi all, I'm trying to use the jdbc driver for postgresql to insert unicode values in my database. I've got a table : test(test_field varchar(50)). I'm trying to insert and compare unicode string in ...
    May 23, 2001 at 11:05 am
    May 23, 2001 at 1:41 pm
  • OK, now that we have started 7.2 development, I am going to go through the outstanding patches and start to apply them or reject them. They are at: http://candle.pha.pa.us/cgi-bin/pgpatches I could ...
    Bruce MomjianBruce Momjian
    May 8, 2001 at 7:57 pm
    May 12, 2001 at 9:39 pm
  • Hello! Assuming I have postgresql-jdbc-7.0.3-2 installed from an RPM on Red Hat 6.2 Do I have to follow the steps in http://jdbc.postgresql.org/docs/#install and start from sources ? Thanks in ...
    Evelio MartinezEvelio Martinez
    May 4, 2001 at 8:13 am
    May 7, 2001 at 6:06 pm
  • This timezone fix was applied to jdbc2 in 7.1.2 by Thomas. Do you want this in jdbc1 also? I am not recommending it, just asking to make sure it wasn't overlooked. ...
    Bruce MomjianBruce Momjian
    May 22, 2001 at 6:03 pm
    May 28, 2001 at 12:23 pm
  • Now that jdk 1.4 beta is out, are there any plans to port the jdbc driver? -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com
    Joseph ShraibmanJoseph Shraibman
    May 31, 2001 at 9:19 pm
    Jun 11, 2001 at 12:44 pm
  • I'm using the PostgreSQL 7.1.1 JDBC2 Enterprise driver, compiled myself on Solaris 8 with the 1.3 JDK. I'm trying to access a column of the PostgreSQL datatype 'inet'. When my program gets to the ...
    Larry MulcahyLarry Mulcahy
    May 30, 2001 at 5:22 pm
    May 30, 2001 at 8:56 pm
  • I have applied the following patch that fixes Druid to work with our jdbc driver. Applied to jdbc1 and jdbc2. [ Attachment, skipping... ] -- Bruce Momjian | http://candle.pha.pa.us ...
    Bruce MomjianBruce Momjian
    May 30, 2001 at 1:04 pm
    May 30, 2001 at 4:35 pm
  • Help ! I am trying to move from DB2 to Postgresql but.... Under Db2 , Linux and OS/2 and Windows I use VisualAge Java 3.0 ... VAJ includes a jdk of its own... Now it seems I will also have to add JDK ...
    May 26, 2001 at 3:26 pm
    May 28, 2001 at 12:24 pm
  • Hi all I installed postgresql successfully. But when i starting the server it is showing the server status differently DEBUG: CheckPoint record at (0, 1522288) DEBUG: Redo record at (0, 1522288); ...
    Subhramanya ShivaSubhramanya Shiva
    May 21, 2001 at 5:14 am
    May 22, 2001 at 2:05 pm
  • Is there a reason that getScale() and getPrecision() both return zero for NUMERIC fields? It seems like this shouldn't be the case. In the example fields below (generated by doing a \d on the table), ...
    David EspositoDavid Esposito
    May 2, 2001 at 4:55 pm
    May 16, 2001 at 5:08 pm
  • 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 ...
    Panu OutinenPanu Outinen
    May 8, 2001 at 2:03 pm
    May 11, 2001 at 12:27 pm
  • I apologize if this message appears in duplicate. The original was posted before the I received notice that an additional confirmation message would be needed to get onto the list. I recently ...
    Jerry ReidJerry Reid
    May 3, 2001 at 5:17 am
    May 4, 2001 at 12:24 am
  • Hello everybody ! I currently work on a project based on Java and PostgreSQL. This morning I "discovered" a bug in DatabaseMetaData.getColumns() that did not retrieve columns's informations when the ...
    Patrice Le GurunPatrice Le Gurun
    May 31, 2001 at 1:49 pm
    May 31, 2001 at 3:48 pm
  • It means it is probably good, waiting for approval from others, or in the standard one-delay before applying patches. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) ...
    Bruce MomjianBruce Momjian
    May 10, 2001 at 4:13 pm
    May 28, 2001 at 2:15 pm
  • Hi, I just used CVS to check out the JDBC code. A CVS log shows that no changes have been commited to the org/postgresql/util/Serialize.java since 10/09/2000. Does this sound about right or did I do ...
    Ken KKen K
    May 19, 2001 at 8:13 pm
    May 28, 2001 at 12:23 pm
  • Below are the patches for org.postgresql.util.Serialize.java There are a number of changes. The main ones are: return oid on insert handle all primitive data types handle single quotes and newlines ...
    Ken KKen K
    May 21, 2001 at 1:37 am
    May 24, 2001 at 3:49 pm
  • Hello, I'm writing to you because I've run out of options. I'm trying to write a java application to access a postgresql database here on our system, but I'm getting an error that I don't understand ...
    Mark D. ApolinskiMark D. Apolinski
    May 16, 2001 at 7:54 pm
    May 18, 2001 at 12:58 pm
  • Hi, Are there any guidelines for writing portable Java code using different SQL DBMS engines? Specifically, I'm writing code that will be ultimately deployed on Oracle. I don't really care for ...
    Laurent DupervalLaurent Duperval
    May 16, 2001 at 1:59 pm
    May 16, 2001 at 3:22 pm
  • 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 ...
    Larry MulcahyLarry Mulcahy
    May 8, 2001 at 11:34 pm
    May 9, 2001 at 4:26 pm
  • If you set a timestamp field to be 'current' as per http://www.ca.postgresql.org/docs/postgres/datatype-datetime.html#AEN322 jdbc chokes on selecting that value: Bad Timestamp Format at 0 in current ...
    Joseph ShraibmanJoseph Shraibman
    May 7, 2001 at 10:43 pm
    May 8, 2001 at 12:06 am
  • Hi, I`m having huge troubles using postgresql JDBC. I do the following: while (orderlines.next()) { PreparedStatement as_st=db.prepareStatement("SELECT nr,beschreibung, beschreibung_2,preis FROM ...
    Rolf SchillingerRolf Schillinger
    May 3, 2001 at 4:41 pm
    May 3, 2001 at 7:01 pm
  • I just upgraded from 7.0.3 to 7.1. I have a query like this: SELECT l, (SELECT COUNT(*) FROM ms WHERE ms.p = 4 AND ms.s = 2), COUNT(DISTINCT m.uid), COUNT(m.oid), AVG(m.msgs::int), SUM(m.msgs::int) ...
    Joseph ShraibmanJoseph Shraibman
    May 1, 2001 at 2:35 am
    May 1, 2001 at 2:46 am
  • hi, i do have problem while inserting a huge amount of data into postgres.I am reading a set of data from a existing table using a java program and inserting it in to another table . Postgress is ...
    May 11, 2001 at 12:26 pm
    May 28, 2001 at 12:23 pm
  • Hi all, Before I start working on this code I would like to get any feed back from others who have worked with the Serialize package or have created custom data types in Postgres. Two problems with ...
    Ken KKen K
    May 26, 2001 at 1:58 pm
    May 26, 2001 at 2:13 pm
  • I was wondering if anyone had any insight to a problem I am having with the setBinaryStream() function call. I am using Postgresql 7.1.1 running under Win 2000 via the Cygnus environment. The JDBC ...
    Brian JordanBrian Jordan
    May 24, 2001 at 5:58 pm
    May 24, 2001 at 8:42 pm
  • The following ANT patch prevents the JAR file from containing non-class files. I was occasionally getting the 'tags' file in the jar file, which clearly is wrong, and made the JAR file 20mb instead ...
    Bruce MomjianBruce Momjian
    May 23, 2001 at 7:30 pm
    May 23, 2001 at 8:14 pm
  • My RH 7 distribution came with a PG installation right out of the box. I've got my database with tables created and everything, but I haven't been able to find any documentation on how to interface ...
    Christopher ParentChristopher Parent
    May 21, 2001 at 4:05 am
    May 21, 2001 at 3:29 pm
  • I am about to apply this to 7.2. Does this get added to JDBC1 too? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe ...
    Bruce MomjianBruce Momjian
    May 15, 2001 at 11:47 pm
    May 16, 2001 at 2:36 am
  • Hello, I try to tune my postgresql server and I was asking me something: each time I do a DriverManager.getConnection (), I notice that a backend is opened. Do you confirm that the backend opening is ...
    Didier BretinDidier Bretin
    May 15, 2001 at 3:08 pm
    May 15, 2001 at 10:05 pm
  • hai, I am developing some projects using postgresql-jdbc in RedHat Linux 6.5.2. When I store date fields in a table, it is stored with the correct format I have specified, when we are viewing in ...
    May 13, 2001 at 12:58 am
    May 14, 2001 at 10:38 pm
  • I'm trying to create a data source as described in paragraph 5.5.1 of the JDBC 2.0 Standard Extension API (http://java.sun.com/products/jdbc/jdbc20.stdext.pdf). (Another example: paragraph 3.7.2 ...
    Larry MulcahyLarry Mulcahy
    May 9, 2001 at 9:09 pm
    May 14, 2001 at 10:30 pm
  • Hi, In my current development project, i would like to use the "moveToInsertRow()" method (JDBC 2.0). But i have with the code below an Exception : "'Method Not Implemented' error" Statement vInsert ...
    Olivier DenierOlivier Denier
    May 11, 2001 at 4:17 pm
    May 12, 2001 at 4:55 am
  • What version of java? -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com
    Joseph ShraibmanJoseph Shraibman
    May 8, 2001 at 12:59 am
    May 11, 2001 at 12:25 pm
  • Hello, I am brand new to this list. I looked through the mailing list archive, but couldn't determine if ResultSets are Updateable yet. I'm using some old drivers for pgsql-jdbc. Are there drivers ...
    Mike D'AgostaMike D'Agosta
    May 3, 2001 at 8:35 pm
    May 7, 2001 at 8:43 pm
  • hi all How to encrypt and decrypt a value which is kept as a password in a table. In mysql we r having encode and decode ... but in pgsql how to do this using Java. regards Shiva. -- Subhramanya ...
    Subhramanya ShivaSubhramanya Shiva
    May 4, 2001 at 5:38 am
    May 4, 2001 at 11:46 am
  • I apologize if this message appears in duplicate. The original was posted before the I received notice that an additional confirmation message would be needed to get onto the list. I recently ...
    Jerry ReidJerry Reid
    May 3, 2001 at 5:11 am
    May 3, 2001 at 4:41 pm
  • 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 ...
    Rolf SchillingerRolf Schillinger
    May 3, 2001 at 9:35 am
    May 3, 2001 at 1:53 pm
  • That enables C assertions at compile time. Not the same thing. -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com
    Joseph ShraibmanJoseph Shraibman
    May 31, 2001 at 7:55 pm
    May 31, 2001 at 7:55 pm
  • (I'm new to this list, I hope you will forgive me if this is old info.) It took me quite a while to figure it out, but I finally got JDBC support for Postgres working under MacOS X. All you need to ...
    Jan HeijmansJan Heijmans
    May 31, 2001 at 12:34 pm
    May 31, 2001 at 12:34 pm
  • Hello, I quote from Druid 2.5 changelog "The PostgreSQL driver doen't work. I made several attempts and works around but the driver lacks some methods and doesn't return proper values. Sorry." Maybe ...
    Tony GrantTony Grant
    May 29, 2001 at 9:08 am
    May 29, 2001 at 9:08 am
Group Navigation
period‹ prev | May 2001 | next ›
Group Overview
grouppgsql-jdbc @

74 users for May 2001

Bruce Momjian: 55 posts Dave Cramer: 20 posts Tom Lane: 14 posts Tony Grant: 12 posts Joseph Shraibman: 10 posts Barry Lind: 9 posts Mark Rosa: 7 posts Ned Wolpert: 7 posts Joe Shevland: 6 posts Larry Mulcahy: 6 posts Palle Girgensohn: 5 posts Marko Kreen: 4 posts Mike Cannon-Brookes: 4 posts Rolf Schillinger: 4 posts B.N.V. Raman: 3 posts Evelio Martinez: 3 posts Ho, Khanh: 3 posts Jani Averbach: 3 posts Jeremy Buchmann: 3 posts Jerry Reid: 3 posts
show more