Postgres Pro
Downloads
Home   >   mailing lists

Thread: which JDBC driver

which JDBC driver

From
Richard Emberson
Date:
As far as I can find there are two different JDBC drivers for
postgresql:

jxDBCon.jar
http://jxdbcon.sourceforge.net
http://sourceforge.net/projects/jxdbcon

and

postgresql.jar
http://jdbc.postgresql.org

Which is better, more mature, fastest, etc.?

Thanks

Richard

Re: which JDBC driver

From
"otisg"
Date:
Hello,

I need to chose a JDBC driver for PostgreSQL, too, and I was wondering if anyone has tried both and has any comments.
How about the authors of the official PostgreSQL JDBC driver?

Thanks,
Otis
_______________________________________________________________
Get your own FREE email account at iVillage.com!
http://webmail.ivillage.com/

<-----Original Message----->
>
> From: Richard Emberson
> Sent: 3/10/2002 11:22:36 AM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] which JDBC driver
>
> As far as I can find there are two different JDBC drivers for
> postgresql:
>
> jxDBCon.jar
> http://jxdbcon.sourceforge.net
> http://sourceforge.net/projects/jxdbcon
>
> and
>
> postgresql.jar
> http://jdbc.postgresql.org
>
> Which is better, more mature, fastest, etc.?
>
> Thanks
>
> Richard
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

Re: which JDBC driver

From
"Dave Cramer"
Date:
Not sure anyone on this list has tried the other driver. The original authors are not active in development anymore, however they may be on the list still.
 
I use the driver from the postgres site and it suits my purposes fine.
 
Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of otisg
Sent: Monday, March 11, 2002 7:33 PM
To: emberson@phc.net; pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] which JDBC driver

Hello,

I need to chose a JDBC driver for PostgreSQL, too, and I was wondering if anyone has tried both and has any comments.
How about the authors of the official PostgreSQL JDBC driver?

Thanks,
Otis
_______________________________________________________________
Get your own FREE email account at iVillage.com!
http://webmail.ivillage.com/

<-----Original Message----->
>
> From: Richard Emberson
> Sent: 3/10/2002 11:22:36 AM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] which JDBC driver
>
> As far as I can find there are two different JDBC drivers for
> postgresql:
>
> jxDBCon.jar
> http://jxdbcon.sourceforge.net
> http://sourceforge.net/projects/jxdbcon
>
> and
>
> postgresql.jar
> http://jdbc.postgresql.org
>
> Which is better, more mature, fastest, etc.?
>
> Thanks
>
> Richard
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

Problem with array ... help!

From
Alexey Slynko
Date:
I have a table with column type int[], for example:
CREATE TABLE test (
    id int[],
    description text
);

When I try to get some data from this table (i.e. SELECT * FROM test),
JDBC create an exception:
"Class names may not have _ in them. You supplied {0}."
What does it mean ? Can anyone post example for working with arrays in
JDBC ? Please, help...

Thanks,

                Alexey Slynko

Re: Problem with array ... help!

From
"Dave Cramer"
Date:
Alexey,

I believe there is has been a patch for this and the development driver
should solve this problem.


Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Alexey Slynko
Sent: Tuesday, March 12, 2002 4:50 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] Problem with array ... help!


I have a table with column type int[], for example:
CREATE TABLE test (
    id int[],
    description text
);

When I try to get some data from this table (i.e. SELECT * FROM test),
JDBC create an exception: "Class names may not have _ in them. You
supplied {0}." What does it mean ? Can anyone post example for working
with arrays in JDBC ? Please, help...

Thanks,

                Alexey Slynko



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: Problem with array ... help!

From
Alexey Slynko
Date:
> Alexey,
>
> I believe there is has been a patch for this and the development driver
> should solve this problem.

Well, I solve this problem. I've patched the latest development version of
JDBC. There is a patch:

*** src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java.orig
Tue Mar 12 14:49:59 2002
--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java     Tue Mar 12
14:50:22 2002
***************
*** 767,772 ****
--- 767,774 ----
                        case Types.BINARY:
                        case Types.VARBINARY:
                                return getBytes(columnIndex);
+                       case Types.ARRAY:
+                               return getArray(columnIndex);
                        default:
                                String type = field.getPGType();
                                // if the backend doesn't know the type
then coerce to String

>
>
> Dave
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Alexey Slynko
> Sent: Tuesday, March 12, 2002 4:50 AM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] Problem with array ... help!
>
>
> I have a table with column type int[], for example:
> CREATE TABLE test (
>     id int[],
>     description text
> );
>
> When I try to get some data from this table (i.e. SELECT * FROM test),
> JDBC create an exception: "Class names may not have _ in them. You
> supplied {0}." What does it mean ? Can anyone post example for working
> with arrays in JDBC ? Please, help...
>
> Thanks,
>
>                 Alexey Slynko
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>

                Alexey Slynko
                Stack Technology
                E-mail: slynko@stack.net
                Tel.: +7(095)939-85-86 (130)

Re: Problem with array ... help!

From
Bruce Momjian
Date:
Someone has applied this patch to CVS.  Thanks.

---------------------------------------------------------------------------

Alexey Slynko wrote:
>
> > Alexey,
> >
> > I believe there is has been a patch for this and the development driver
> > should solve this problem.
>
> Well, I solve this problem. I've patched the latest development version of
> JDBC. There is a patch:
>
> *** src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java.orig
> Tue Mar 12 14:49:59 2002
> --- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java     Tue Mar 12
> 14:50:22 2002
> ***************
> *** 767,772 ****
> --- 767,774 ----
>                         case Types.BINARY:
>                         case Types.VARBINARY:
>                                 return getBytes(columnIndex);
> +                       case Types.ARRAY:
> +                               return getArray(columnIndex);
>                         default:
>                                 String type = field.getPGType();
>                                 // if the backend doesn't know the type
> then coerce to String
>
> >
> >
> > Dave
> > -----Original Message-----
> > From: pgsql-jdbc-owner@postgresql.org
> > [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Alexey Slynko
> > Sent: Tuesday, March 12, 2002 4:50 AM
> > To: pgsql-jdbc@postgresql.org
> > Subject: [JDBC] Problem with array ... help!
> >
> >
> > I have a table with column type int[], for example:
> > CREATE TABLE test (
> >     id int[],
> >     description text
> > );
> >
> > When I try to get some data from this table (i.e. SELECT * FROM test),
> > JDBC create an exception: "Class names may not have _ in them. You
> > supplied {0}." What does it mean ? Can anyone post example for working
> > with arrays in JDBC ? Please, help...
> >
> > Thanks,
> >
> >                 Alexey Slynko
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> >
> >
> >
>
>                 Alexey Slynko
>                 Stack Technology
>                 E-mail: slynko@stack.net
>                 Tel.: +7(095)939-85-86 (130)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026