Thread: 7.1 RPM has old JDBC driver - SQL statement too long
I just wanted to pass this along to everyone checking out the new 7.1 release. The jdbc jars that are included with the current RPM's are from the 7.0.3 release. So if you try to take advantage of the new unlimited size text fields, you will get the familiar "SQL statement too long" error when you try to do an insert of text greater then 8k. To get the new 7.1 jdbc driver, the only place I have been able to find it is in the source tarball. You have to make the jar using the instructions in the jdbc readme. Once you get a proper make, the new jar will allow large text inserts and selects. Finally, no more limitations! I hope this helps someone. - Adam -- Adam Rossi President, PlatinumSolutions, Inc. adam.rossi@platinumsolutions.com http://www.platinumsolutions.com P.O. Box 31 Oakton, VA 22124 PH: 703.471.9793 FAX: 703.471.7140
Adam Rossi wrote: > I just wanted to pass this along to everyone checking out the new 7.1 > release. The jdbc jars that are included with the current RPM's are from the > 7.0.3 release. So if you try to take advantage of the new unlimited size text As soon as I can get either pre-built 7.1 JDBC jars to ship as part of the RPM, or get time to install the pieces necessary to build JDBC on RH6.2, RH7.0, and RH7.1. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
Re: 7.1 RPM has old JDBC driver - SQL statement too long
From
teg@redhat.com (Trond Eivind Glomsrød)
Date:
Lamar Owen <lamar.owen@wgcr.org> writes: > Adam Rossi wrote: > > I just wanted to pass this along to everyone checking out the new 7.1 > > release. The jdbc jars that are included with the current RPM's are from the > > 7.0.3 release. So if you try to take advantage of the new unlimited size text > > As soon as I can get either pre-built 7.1 JDBC jars to ship as part of > the RPM, or get time to install the pieces necessary to build JDBC on > RH6.2, RH7.0, and RH7.1. I'll create some jars and mail them to you. -- Trond Eivind Glomsrød Red Hat, Inc.
Trond Eivind Glomsrød wrote: > Lamar Owen <lamar.owen@wgcr.org> writes: > > As soon as I can get either pre-built 7.1 JDBC jars to ship as part of > > the RPM, or get time to install the pieces necessary to build JDBC on > > RH6.2, RH7.0, and RH7.1. > I'll create some jars and mail them to you. Ok. Thanks. I guess I'll be releasing a -2 set early next week, or maybe even by the weekend. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
So what you're saying is that if I upgrade from self built 7.1RC4 to 7.1 RPM-version I actually will be downgraded with the jdbc driver??? Peter Adam Rossi wrote: > > I just wanted to pass this along to everyone checking out the new 7.1 > release. The jdbc jars that are included with the current RPM's are from the > 7.0.3 release. So if you try to take advantage of the new unlimited size text > fields, you will get the familiar "SQL statement too long" error when you try > to do an insert of text greater then 8k. > > To get the new 7.1 jdbc driver, the only place I have been able to find it is > in the source tarball. You have to make the jar using the instructions in the > jdbc readme. Once you get a proper make, the new jar will allow large text > inserts and selects. Finally, no more limitations! > > I hope this helps someone. > > - Adam > -- > Adam Rossi > President, PlatinumSolutions, Inc. > adam.rossi@platinumsolutions.com > http://www.platinumsolutions.com > P.O. Box 31 Oakton, VA 22124 > PH: 703.471.9793 FAX: 703.471.7140 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl
Quoting Adam Rossi <adam.rossi@platinumsolutions.com>: > I just wanted to pass this along to everyone checking out the new 7.1 > release. The jdbc jars that are included with the current RPM's are from > the > 7.0.3 release. So if you try to take advantage of the new unlimited size > text > fields, you will get the familiar "SQL statement too long" error when > you try > to do an insert of text greater then 8k. > > To get the new 7.1 jdbc driver, the only place I have been able to find > it is > in the source tarball. You have to make the jar using the instructions > in the > jdbc readme. Once you get a proper make, the new jar will allow large > text > inserts and selects. Finally, no more limitations! Hopefully I'll have the precompiled .jar's online soon... Peter -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
Quoting Adam Rossi <adam.rossi@platinumsolutions.com>: > I just wanted to pass this along to everyone checking out the new 7.1 > release. The jdbc jars that are included with the current RPM's are from > the > 7.0.3 release. So if you try to take advantage of the new unlimited size > text > fields, you will get the familiar "SQL statement too long" error when > you try > to do an insert of text greater then 8k. > > To get the new 7.1 jdbc driver, the only place I have been able to find > it is > in the source tarball. You have to make the jar using the instructions > in the > jdbc readme. Once you get a proper make, the new jar will allow large > text > inserts and selects. Finally, no more limitations! Hopefully I'll have the precompiled .jar's online soon... Peter -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/