summaryrefslogtreecommitdiff
path: root/src/interfaces/jdbc
AgeCommit message (Collapse)Author
2003-09-23Fix to properly handle timezone offsets that are partial hours. If the offsetBarry Lind
was a partial hour and less than gmt (i.e. -02:30) the code would corrupt the minutes part. Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
2003-09-23A fix for jdbc regression test submitted yesterday by Kim Ho at RedhatBarry Lind
Modified Files: ResultSetTest.java
2003-09-22Additional jdbc regression tests submitted by Oliver Jowett. Some tests areBarry Lind
currently commented out, pending fixes for the bugs these tests uncovered. Modified Files: jdbc/org/postgresql/test/jdbc2/Jdbc2TestSuite.java jdbc/org/postgresql/test/jdbc2/ServerPreparedStmtTest.java Added Files: jdbc/org/postgresql/test/jdbc2/CursorFetchTest.java
2003-09-22Applied jdbc patch from Kim Ho at RedHat to improve boolean support, as wellBarry Lind
as some additional regression tests for this an other recent changes. Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/test/jdbc2/DateTest.java jdbc/org/postgresql/test/jdbc2/ResultSetTest.java jdbc/org/postgresql/test/jdbc2/TimeTest.java jdbc/org/postgresql/test/jdbc2/TimestampTest.java
2003-09-18Applied patch from Oliver Jowett to clean up some instances where the wrongBarry Lind
type was being reported for PREPAREs. Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/test/jdbc2/ServerPreparedStmtTest.java
2003-09-18Small jdbc patch from Kim Ho at RedHat to fix some boolean problemsBarry Lind
Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
2003-09-18A minor fix to jdbc regression testsBarry Lind
Modified Files: jdbc/org/postgresql/test/jdbc2/DatabaseMetaDataPropertiesTest.java
2003-09-17Applied patch to jdbc from Kim Ho at RedHat, fixing improper handling of ↵Barry Lind
empty queries under the V3 protocol Modified Files: jdbc/org/postgresql/core/QueryExecutor.java
2003-09-17Applied patch for jdbc from Kim Ho at RedHat to more correctly deal with ↵Barry Lind
boolean values Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
2003-09-17Fixed jdbc to correctly report that constraints are supportedBarry Lind
Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java
2003-09-17Applied patch from Fernando Nasser of RedHat to fix some error messagesBarry Lind
that would not get correctly looked up in the translation files for jdbc Modified Files: jdbc/org/postgresql/errors.properties jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
2003-09-17Applied patch from Kim Ho at redhat to improve boolean and bit handlingBarry Lind
in the jdbc driver Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc3/AbstractJdbc3Statement.java
2003-09-13More SQLState updates from Kim Ho at Redhat.Barry Lind
Also a patch from Kris Jurka to correctly report SQLState support. Modified Files: jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/core/QueryExecutor.java jdbc/org/postgresql/fastpath/Fastpath.java jdbc/org/postgresql/geometric/PGbox.java jdbc/org/postgresql/geometric/PGcircle.java jdbc/org/postgresql/geometric/PGline.java jdbc/org/postgresql/geometric/PGlseg.java jdbc/org/postgresql/geometric/PGpath.java jdbc/org/postgresql/geometric/PGpoint.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSetMetaData.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSetMetaData.java jdbc/org/postgresql/jdbc2/Array.java jdbc/org/postgresql/jdbc3/AbstractJdbc3DatabaseMetaData.java jdbc/org/postgresql/util/PGmoney.java jdbc/org/postgresql/util/PSQLState.java
2003-09-09Clean up some unused import warnings in the example jdbc codeBarry Lind
2003-09-09Additional SQLState work for JDBC - thanks to Kim Ho at Redhat for input on thisBarry Lind
Modified Files: jdbc/build.xml jdbc/org/postgresql/core/QueryExecutor.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/util/PSQLState.java
2003-09-08Opps, can't forget the new file. This is part of the last commit to applyBarry Lind
the redhat patch for SQLState support. Added Files: PSQLState.java
2003-09-08This set of changes applies a patch from KHO at redhat to add some SQLStateBarry Lind
support to the jdbc driver. That patch needed some work: it assumed the sqlcode in a server message was fixed in its position, the patch lost the ability to pass exceptions, and the patch missed a couple of places where server errors where being received. In addition to fixing the above, I also added full support for the V3 protocol error message syntax, I reversed the order of arguments in the PSQLException constructor to more closely follow the constructors for SQLException, I changed the new constructors that take PSQLState to take Object for additional parameters as the old ones did. Still todo are to add SQLState values to all existing exceptions thrown in the driver and add support for parsing the V3 protocol format for notices. Modified Files: jdbc/build.xml jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/errors.properties jdbc/org/postgresql/core/Encoding.java jdbc/org/postgresql/core/PGStream.java jdbc/org/postgresql/core/QueryExecutor.java jdbc/org/postgresql/fastpath/Fastpath.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/util/MessageTranslator.java jdbc/org/postgresql/util/PSQLException.java
2003-08-26Attempt to fix setMaxFieldSize() logic that was checked in yesterday.Barry Lind
I think this should fix the problem, but since I don't have a reproducable test case, I can't be sure. This problem is reported by Kim Ho of redhat, who will test this fix. This also includes a test case for the original functionality. Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/test/jdbc2/ResultSetTest.java
2003-08-24Applied patches from Oliver Jowett to fix the following bugs:Barry Lind
- adds a finalizer method to AbstractJdbc1Statement to clean up in the case of poor user code which fails to close the statement object - fix ant build file to correctly detect dependencies across jdbc1/jdbc2/jdbc3 - fix a coupld of server prepared statement bugs and added regression test for them Applied patch from Kim Ho: - adds support for get/setMaxFieldSize(). Also fixed build.xml to provide a better error message in the event that an older version of the driver exists in the classpath when trying to build.
2003-08-15Updated the blob regression test to actually use the getBlob/getClob methodsBarry Lind
and test them, in addition to testing the underlying LargeObject API methods. Modified Files: jdbc/build.xml jdbc/org/postgresql/test/jdbc2/BlobTest.java
2003-08-15Fixed improper message length for the connection termination message 'X' whenBarry Lind
using the V3 protocol. Modified Files: jdbc1/AbstractJdbc1Connection.java
2003-08-11Applied patch from Oliver Jowett to clean up the jdbc regression test buildBarry Lind
Modified Files: jdbc/build.xml jdbc/org/postgresql/test/jdbc3/Jdbc3TestSuite.java
2003-08-11Applied patch from Oliver Jowett to better handle invalid input for getArrayBarry Lind
(no longer throw an index out of range exception) Modified Files: jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
2003-08-11Applied patch from Oliver Jowett to clean up some aditional warning messagesBarry Lind
from ant. Modified Files: jdbc/build.xml
2003-08-11Applied patch from Oliver Jewett to fix a deprecation in newer versions of antBarry Lind
Modified Files: jdbc/build.xml
2003-08-11Applied patch from Oliver Jewett to clean up the testing README fileBarry Lind
Modified Files: jdbc/org/postgresql/test/README
2003-08-11Applied patch by Oliver Jowett to clean up some exception handlingBarry Lind
Modified Files: jdbc/org/postgresql/core/QueryExecutor.java jdbc/org/postgresql/util/PSQLException.java
2003-08-11Applied patch from Oliver Jowett to improve a buffer sizing.Barry Lind
Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
2003-08-11Applied patch from Kim Ho to fix a regression against a 7.4 server. The resultBarry Lind
of transaction isolation level changed from uppercase to lower case between 7.3 and 7.4. In testing, a regression was also fixed in this area when talking to a 7.2 server due to changes in how notice messages are processed in the current code. Modified Files: jdbc/build.xml jdbc/org/postgresql/core/BaseStatement.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java
2003-08-07Sometimes the third time is the charm. Third try to fix the sql injectionBarry Lind
vulnerability. This fix completely removes the ability (hack) of being able to bind a list of values in an in clause. It was demonstrated that by allowing that functionality you open up the possibility for certain types of sql injection attacks. The previous fix attempts all focused on preventing the insertion of additional sql statements (the semi-colon problem: xxx; any new sql statement here). But that still left the ability to change the where clause on the current statement or perform a subselect which can circumvent applicaiton security logic and/or allow you to call any stored function. Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
2003-08-06Applied patch from kho@redhat.com to fix a problem with trying to use a fetchBarry Lind
when a cursor wasn't being used. Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
2003-07-24Fixes additional sql injection vulnerabilities reported by Oliver JowettBarry Lind
and Dmitry Tkach. Specifically the previous fix still allowed the statement termination character through in unquoted places in the sql statement, and the driver never correctly handled someone passing a value of \0 in a string which under the v2 protocol would end the statement causing the following text to possibly be treated as a new sql statement Modified Files: jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
2003-07-22Fix to prevent SQL injection attacks for code calling setObject(int,Object,int)Barry Lind
where Object is a user supplied String and the type is a numeric type (i.e. INTEGER,LONG,etc). Also applied a patch from Kim Ho that fixes compile problems under jdk1.2 Modified Files: jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
2003-07-21Applied patch from dmitry@openratings.com to fix parsing of array valuesBarry Lind
Modified Files: jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/jdbc2/Array.java
2003-07-09Applied patch from Kim Ho @ redhat.com to make support for setObject() moreBarry Lind
spec complient with regards to various data/time/timestamp objects Modified Files: jdbc/org/postgresql/errors.properties jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
2003-06-30patches by Kim Ho to fixDave Cramer
getByte, getSort if input has decimal or whitespace setObject if object is a BIT boolean not on list of SQLKeywords
2003-06-30Patches applied:Barry Lind
1) Patch from Kris Jurka to fix IPv6 parsing of the jdbc URL 2) Patch from Kris Jurka to fix an ArrayIndexOutOfBounds error when calling moveToCurrentRow while currentRow is "beforeFirst" 3) Patch from Kim Ho to fix add some bounds checking in setMaxRows(), setQueryTimeout(), setFetchSize() Modified Files: jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/errors.properties jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java
2003-05-29one more change to correctly support the removeall of autocommitBarry Lind
2003-05-29Applied patch from Fernando Nasser to fix up small type errorBarry Lind
2003-05-29Applied patch from Fernando Nasser to improve buffer sizes to avoid ↵Barry Lind
unnecessary resizing.
2003-05-29clean up warnings produced by EclipseBarry Lind
2003-05-29Adding .cvsignore files for Eclipse IDEBarry Lind
2003-05-29Up the build number to reflect the changes for V3 protocol supportBarry Lind
2003-05-29Initial attempt to integrate in V3 protocol support. This is still a work inBarry Lind
progress, although all RTs pass using the V3 protocol on a 7.4 database and also pass using the V2 protocol on a 7.3 database. SSL support is known not to work. Modified Files: jdbc/org/postgresql/PGConnection.java jdbc/org/postgresql/errors.properties jdbc/org/postgresql/core/BaseConnection.java jdbc/org/postgresql/core/Encoding.java jdbc/org/postgresql/core/Field.java jdbc/org/postgresql/core/PGStream.java jdbc/org/postgresql/core/QueryExecutor.java jdbc/org/postgresql/core/StartupPacket.java jdbc/org/postgresql/fastpath/Fastpath.java jdbc/org/postgresql/fastpath/FastpathArg.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/test/jdbc2/BlobTest.java jdbc/org/postgresql/test/jdbc2/CallableStmtTest.java jdbc/org/postgresql/test/jdbc2/MiscTest.java jdbc/org/postgresql/test/jdbc3/Jdbc3TestSuite.java
2003-05-07Fixed bug with Warnings. Warnings are not added to the Statement instead ofBarry Lind
the connection when appropriate. This checkin also adds the type map for jdbc3, however currently it is identical to the jdbc2 mapping. Modified Files: jdbc/org/postgresql/core/BaseStatement.java jdbc/org/postgresql/core/QueryExecutor.java jdbc/org/postgresql/jdbc3/AbstractJdbc3Connection.java
2003-05-03Patch to fix up LONGVARBINARY support submitted by Amit GollapudiBarry Lind
(agollapudi@demandsolutions.com). Also applied the RefCursor support patch by Nic Ferrier. This patch allows you too return a get a result set from a function that returns a refcursor. For example: call.registerOutParameter(1, Types.OTHER); call.execute(); ResultSet rs = (ResultSet) call.getObject(1); Modified Files: jdbc/org/postgresql/core/BaseStatement.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc1/Jdbc1CallableStatement.java jdbc/org/postgresql/jdbc1/Jdbc1PreparedStatement.java jdbc/org/postgresql/jdbc1/Jdbc1Statement.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/jdbc2/Jdbc2CallableStatement.java jdbc/org/postgresql/jdbc2/Jdbc2PreparedStatement.java jdbc/org/postgresql/jdbc2/Jdbc2Statement.java jdbc/org/postgresql/jdbc3/Jdbc3CallableStatement.java jdbc/org/postgresql/jdbc3/Jdbc3PreparedStatement.java jdbc/org/postgresql/jdbc3/Jdbc3Statement.java Added Files: jdbc/org/postgresql/PGRefCursorResultSet.java jdbc/org/postgresql/jdbc1/Jdbc1RefCursorResultSet.java jdbc/org/postgresql/jdbc2/Jdbc2RefCursorResultSet.java jdbc/org/postgresql/jdbc3/Jdbc3RefCursorResultSet.java jdbc/org/postgresql/test/jdbc2/RefCursorTest.java
2003-04-17Applied patches from Kris Jurka fixing a string tokenizing problem andBarry Lind
fixing an order by problem for index metadata results. Also includes removing some unused code as well as a fix to the toString method on statement. Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
2003-04-14exposed the addDataType method to the PGConnection, allows users to add ↵Dave Cramer
datatypes
2003-04-13Applied patch submitted by Nic Ferrier with some cleanups of his previousBarry Lind
patch to add cursor based queries. Modified Files: jdbc/org/postgresql/core/BaseConnection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
2003-03-25patch to notify listeners on error from Csaba NagyDave Cramer