Skip site navigation (1) Skip section navigation (2)

RE: Re: Simple bug in JDBC interface

From: Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk>
To: "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>, elias(dot)ross(at)software(dot)com
Cc: PostgreSQL-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: RE: Re: Simple bug in JDBC interface
Date: 2000-06-06 07:45:54
Message-ID: 1B3D5E532D18D311861A00600865478CF1AEA7@EXCHANGE1 (view raw or flat)
Thread:
Lists: pgsql-interfaces
Found and fixed them.

I gave up trying to get a fresh cvs copy yesterday after 6 hours. Did it
from work this morning and it took about 10 minutes!

Any how, it's done.

peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council

> -----Original Message-----
> From:	Bruce Momjian [SMTP:pgman(at)candle(dot)pha(dot)pa(dot)us]
> Sent:	Saturday, June 03, 2000 2:41 AM
> To:	elias(dot)ross(at)software(dot)com
> Cc:	PostgreSQL-interfaces
> Subject:	[INTERFACES] Re: Simple bug in JDBC interface
> 
> Peter, can you please comment on this?
> 
> 
> > 
> > Sorry if I'm e-mailing the wrong person.
> > 
> > This is to do with loading "exotic types" through JDBC.
> > 
> > It has to do with how it tries to load the class: (perhaps under old
> > hierarchy?)
> > 	postgresql.geometric.PGpoint
> > when in fact it SHOULD be loading
> > 	ORG.postgresql.geometric.PGpoint
> >  	^^^
> > 
> > ///// EXAMPLE:
> > 
> > import java.io.*;
> > import java.sql.*;
> > 
> > /* 
> > This error:
> > 
> > Failed to create object for point java.lang.ClassNotFoundException:
> > postgresql.geometric.PGpoint
> >         at java.lang.Throwable.fillInStackTrace(Native Method)
> >         at java.lang.Throwable.<init>(Throwable.java:82)
> >         at java.lang.Exception.<init>(Exception.java:33)
> >         at java.sql.SQLException.<init>(SQLException.java:98)
> >         at
> > org.postgresql.util.PSQLException.<init>(PSQLException.java:53)
> >         at org.postgresql.Connection.getObject(Connection.java:624)
> >         at org.postgresql.jdbc2.ResultSet.getObject(ResultSet.java:741)
> >         at PostgresTest.<init>(PostgresTest.java:23)
> >         at PostgresTest.main(PostgresTest.java:31)
> > 
> > 
> > in psql:
> > 
> > testdb=# \d users
> >  minid     | char(15) |
> >  status    | char(3)  |
> >  location  | point    |
> > */
> > 
> > public class PostgresTest {
> > 
> >         public PostgresTest() 
> >                 throws Exception
> >         {
> >                 Class.forName("org.postgresql.Driver");
> >                 Connection c =
> > DriverManager.getConnection("jdbc:postgresql://beryl:5432/testdb",
> > "postgres", "");
> >                 Statement s = c.createStatement();
> >                 BufferedReader r = new BufferedReader(new
> > InputStreamReader(System.in));        
> >                 // while (true) {
> >                         // System.out.print("Enter query: ");
> >                         // System.out.flush();
> >                         String query;
> >                         //query = r.readLine();
> >                         query = "select * from users";
> >                         ResultSet res = s.executeQuery(query);
> >                         if (res != null) {
> >                                 while (res.next()) {
> >                                         System.out.println("" +
> > res.getString(1) + " " + res.getString(2) + " " + res.getObject(3));
> >                                 }
> >                         }
> >                 //}
> >         }
> > 
> >         public static void main(String args[]) {
> >                 try {
> >                         PostgresTest pt = new PostgresTest();
> >                 } catch (Exception e) {
> >                         e.printStackTrace();
> >                 }
> >         }
> > 
> > }
> > 
> 
> 
> -- 
>   Bruce Momjian                        |  http://www.op.net/~candle
>   pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-interfaces by date

Next:From: Peter MountDate: 2000-06-06 08:55:04
Subject: RE: Postgres 7.0 JDBC - update count for DELETE is always 1
Previous:From: Peter MountDate: 2000-06-06 07:20:46
Subject: RE: Long atributes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group