summaryrefslogtreecommitdiff
path: root/src/interfaces/jdbc
AgeCommit message (Collapse)Author
2002-07-23Initial restructuring to add jdbc3 support. There was a significant amountBarry Lind
of duplicated code between the jdbc1 and jdbc2. This checkin restructures the code so that the duplication is removed so that the jdbc3 support can be added without adding yet another copy of everything. Also many classes were renamed to avoid confusion with multiple different objects having the same name. The timestamp tests were also updated to add support for testing timestamp without time zone in addition to timestamp with time zone Modified Files: jdbc/Makefile jdbc/build.xml jdbc/example/ImageViewer.java jdbc/example/basic.java jdbc/example/blobtest.java jdbc/example/threadsafe.java jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/Field.java jdbc/org/postgresql/core/QueryExecutor.java jdbc/org/postgresql/fastpath/Fastpath.java jdbc/org/postgresql/jdbc1/CallableStatement.java jdbc/org/postgresql/jdbc1/DatabaseMetaData.java jdbc/org/postgresql/jdbc1/PreparedStatement.java jdbc/org/postgresql/jdbc2/Array.java jdbc/org/postgresql/jdbc2/CallableStatement.java jdbc/org/postgresql/jdbc2/DatabaseMetaData.java jdbc/org/postgresql/jdbc2/PreparedStatement.java jdbc/org/postgresql/jdbc2/UpdateableResultSet.java jdbc/org/postgresql/largeobject/LargeObjectManager.java jdbc/org/postgresql/largeobject/PGblob.java jdbc/org/postgresql/largeobject/PGclob.java jdbc/org/postgresql/test/jdbc2/BlobTest.java jdbc/org/postgresql/test/jdbc2/ConnectionTest.java jdbc/org/postgresql/test/jdbc2/DatabaseMetaDataTest.java jdbc/org/postgresql/test/jdbc2/TimestampTest.java jdbc/org/postgresql/test/jdbc2/UpdateableResultTest.java jdbc/org/postgresql/util/Serialize.java Added Files: jdbc/org/postgresql/PGConnection.java jdbc/org/postgresql/PGStatement.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc1/Jdbc1Connection.java jdbc/org/postgresql/jdbc1/Jdbc1ResultSet.java jdbc/org/postgresql/jdbc1/Jdbc1Statement.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Connection.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/jdbc2/Jdbc2Connection.java jdbc/org/postgresql/jdbc2/Jdbc2ResultSet.java jdbc/org/postgresql/jdbc2/Jdbc2Statement.java Removed Files: jdbc/org/postgresql/Connection.java jdbc/org/postgresql/ResultSet.java jdbc/org/postgresql/Statement.java jdbc/org/postgresql/jdbc1/Connection.java jdbc/org/postgresql/jdbc1/ResultSet.java jdbc/org/postgresql/jdbc1/Statement.java jdbc/org/postgresql/jdbc2/Connection.java jdbc/org/postgresql/jdbc2/ResultSet.java jdbc/org/postgresql/jdbc2/Statement.java
2002-07-16fixed bug in support for timestamp without time zone reported by Yuva ↵Barry Lind
Chandolu (ychandolu@ebates.com)
2002-07-12Changed getCrossReference to return information about each composite key ↵Dave Cramer
seperately It used to return them as a,b in one row, and now returns a in one row, and b in one row
2002-07-10fix bug in getTime() with fractional seconds reported by Laurette Cisneros ↵Barry Lind
(laurette@nextbus.com)
2002-07-05fixed bug reported by Michael, Dietrich (mdt@emdete.de) where a large object ↵Barry Lind
handle was being used after the end of the transaction and thus resulting in an error.
2002-06-27fixed build.xml to echo correct jdbc version under ant1.6Barry Lind
2002-06-27general cleanup of jdbc codeBarry Lind
2002-06-26translation patch submitted by Zhenbang Wei forth@mail.net.twBarry Lind
2002-06-26patch submitted by Jason Davies jason@netspade.com to provide proper java ↵Barry Lind
class name for a byte[]
2002-06-25fixed retrieval of foreign/primary keys in imported/exported keysDave Cramer
2002-06-24patch to add support for callable statements to the jdbc driver. The patch ↵Barry Lind
was submitted by Paul Bethe pmbethe@yahoo.com
2002-06-24patch to update zh_TW message file for jdbc submitted by Zhenband Wei ↵Barry Lind
(forth@mail.net.tw)
2002-06-24patch submitted by Jason Davies jason@netspade.com to improve ↵Barry Lind
ResultSetMetaData.getColumnClassName() support
2002-06-24fixed bug reported by Wolfgang Winter w.winter@logitags.com where historic ↵Barry Lind
timestamps which do not have timezone info were being interpreted in local timezone instead of GMT. Also added a check to support timestamp vs. timestamptz in this code
2002-06-20Improve COPY syntax to use WITH clause, keep backward compatibility.Bruce Momjian
2002-06-16implemented refresh rowDave Cramer
2002-06-14added empty result set testingDave Cramer
2002-06-14added empty result set testingDave Cramer
2002-06-13removed personal test parametersDave Cramer
2002-06-13Added test for newly implemented updateable result setsDave Cramer
2002-06-13changes to accomodate updateable resultset mostly just call setSqlQuery on ↵Dave Cramer
execute
2002-06-13Implemented updateable result sets based on raghu nidagal implementationDave Cramer
2002-06-13changed some commented out messages to use the Driver.debug and fixed first ↵Dave Cramer
to read the underlying data into rowbuffer
2002-06-13added messages for updateable result setsDave Cramer
2002-06-11The patch does the following:Barry Lind
Allows you to set the loglevel at runtime by adding ?loglevel=X to the connection URL, where 1 = INFO and 2 = DEBUG. Automatically turns on logging by calling DriverManager.setPrintWriter(new PrintWriter(System.out)) if one is not already set. Adds a Driver.info() message that prints out the version number Adds member variables logDebug and logInfo that can be checked before making logging methods calls Adds a build number to the version number string. This build number will need to be manually incremented when we see fit. ---------------------------------------------------------------------- Modified Files: org/postgresql/Connection.java org/postgresql/Driver.java.in org/postgresql/fastpath/Fastpath.java org/postgresql/jdbc1/DatabaseMetaData.java org/postgresql/jdbc2/Connection.java org/postgresql/jdbc2/DatabaseMetaData.java org/postgresql/largeobject/LargeObjectManager.java org/postgresql/util/PSQLException.java org/postgresql/util/Serialize.java ----------------------------------------------------------------------
2002-06-07fixed bug reported by cc.ais40@wanadoo.fr where getObject was returning an ↵Barry Lind
Integer for a smallint datatype instead of a Short
2002-06-06change table name to lower case in getColumnsDave Cramer
2002-06-05fixed getImported/ExportedKeys to be simpler, and return the correct number ↵Dave Cramer
of keys
2002-06-03fixed bug reported by Noel Rappin (nrappin@sockeye.com) java Array type ↵Barry Lind
handled Timestamps incorrectly
2002-05-30small fix to testExportedKeysDave Cramer
2002-05-30added imported/exported key testDatabaseMetaDataTest.javaDave Cramer
2002-05-17Merge the last few variable.c configuration variables into the genericTom Lane
GUC support. It's now possible to set datestyle, timezone, and client_encoding from postgresql.conf and per-database or per-user settings. Also, implement rollback of SET commands that occur in a transaction that later fails. Create a SET LOCAL var = value syntax that sets the variable only for the duration of the current transaction. All per previous discussions in pghackers.
2002-05-14fixed problem connecting to server with client_min_messages set to debug. ↵Barry Lind
The code was not expecting to receive notice messages during the connection handshake.
2002-04-24Update jdbc errors_zh_TW.properties.Bruce Momjian
Zhenbang Wei
2002-04-18Ant 1.4.1 now requires for jdbc. Mention in HISTORY release notes.Bruce Momjian
2002-04-16Added some rudimentary table and column testsDave Cramer
added a setup/teardown to create and drop the connection, and table
2002-04-16fixed getColumns as per Panu Outinen's email. At this point have only ↵Dave Cramer
repaired the bug, haven't made it caseInsensitive
2002-04-02Removed error message that was incorectly being issued. This fixes a ↵Barry Lind
problem reported a few months ago where a select in a rule was causing an insert statement to return a result set which the code was explicitly prohibiting.
2002-03-27applied patch from Liam Stewart fixing a message in the properties fileBarry Lind
also fixed a NPE when calling the next() method on a result set after the connection or resultset has been closed. (bug reported by Hans Deragon)
2002-03-26applied patch submitted by Florian (mailing-list@urbanet.ch) for BigDecimal ↵Barry Lind
support
2002-03-26Changed QueryExecutor.java to correctly read responses from the backend.Barry Lind
Fixed NPE when database name was not passed on the jdbc connection URL Fixed Connection.isClosed() to not hit the DB for every call
2002-03-21Two versions of QueryExecutor, currently only version 2 works 100%Dave Cramer
these versions adhere to the backend protocol better than previous version fixes problem when an error occurs on the backend, and the connection is still used previous versions were throwing an exception half way through the protocol, leaving it indeterminate. also removes empty query code, should speed things up a bit
2002-03-21modifications to the way the protocol is handled to be consistent withDave Cramer
QueryExecutor. This includes: 1) only exit after we receive a 'Z' packet 2) append error messages to a buffer and throw the exception at the end
2002-03-21Part of Anders Bengtsson's patch to clean up Connection.javaDave Cramer
2002-03-21Applied Anders patch to move the startup code out of Connection into ↵Dave Cramer
StartupPacket * Introduces a new class, StartupPacket. * Moves a lot of constants from Connection to StartupPacket. * Makes two instance variables in Connection into locals.
2002-03-19>Added ServerEncodingBruce Momjian
> Korean (JOHAB), Thai (WIN874), > Vietnamese (TCVN), Arabic (WIN1256) > >Added ClientEncoding > Simplified Chinese (GBK), Korean (UHC) > >Add PsqlODBC and document ...etc patch. "JDBC patch" is delivered, too. :-) Eiji Tokuya
2002-03-19applied patch from Liam StewartDave Cramer
If one is trying to compile a JDBC 1 driver and junit.jar is in the CLASSPATH, then the build fails as ant tries to build the JDBC 2 test classes. This patch fixes this problem by excluding the jdbc 2 files unless the jdk1.2+ property is set.
2002-03-18Fixes bug where query hangs if there is an error in the query, went back toDave Cramer
code before QueryExecutor class was created and copied behaviour
2002-03-16fixed QueryExecuter to deal with multiple errorsDave Cramer
previously it was throwing a SQLException as soon as the error message was received from the backend. This did not allow the protocol to finish properly now, simply collects error messages from the backend until the query is done and throws exception at the end Also added setLogLevel to Driver.java, and made the log levels public
2002-03-15patch from Alexey SlynkoDave Cramer
This patch solve problems with arrays in latest development JDBC driver