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
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 textAs 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:
Show quoted text
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?
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/