summaryrefslogtreecommitdiff
path: root/src/interfaces/jdbc
AgeCommit message (Collapse)Author
2001-06-01The following patch for JDBC fixes an issue with jdbc running on aBruce Momjian
non-multibyte database loosing 8bit characters. This patch will cause the jdbc driver to ignore the encoding reported by the database when multibyte isn't enabled and use the JVM default in that case. Barry Lind
2001-05-30I just got bitten by this too. I use type timestamp in theBruce Momjian
database, and often need the latest timestamp, but want to format it as a date. With 7.0.x, I just select ts from foo order by ts desc limit 1 and in java: d = res.getDate(1); but this fails everywhere in my code now :( http://java.sun.com/j2se/1.3/docs/guide/jdbc/spec/jdbc-spec.frame7.html says The ResultSet.getXXX methods will attempt to convert whatever SQL type was returned by the database to whatever Java type is returned by the getXXX method. Palle Girgensohn
2001-05-30Fix for Druid. We did not support some PROCEDURE queries.Bruce Momjian
Dave Cramer
2001-05-28Attached is a patch to fix the problem Thomas mentions below. The JDBCBruce Momjian
driver now correctly handles timezones that are offset fractional hours from GMT (ie. -06:30). Barry Lind
2001-05-25Mention failure of ANT to delete directories on clean.Bruce Momjian
2001-05-25The following patch corrects a make install problem when buildingBruce Momjian
under Cygwin. The root cause of this problem is that (Sun) java is a native Win32 app and hence does not understand Cygwin Posix style paths. The solution is to use Cygwin's cygpath utility to convert the Posix style JDBC installation directory path into a Win32 one before invoking ant. I'm not sure if my patch is the best way to correct this issue but my goal was to confine the Cygwin specific constructs to Jason Tishler
2001-05-24There are a number of changes. The main ones are:Bruce Momjian
return oid on insert handle all primitive data types handle single quotes and newlines in Strings handle null variables deal with non public and final variables (not very well, though) Ken K
2001-05-23Fix ANT for *.properties files.Bruce Momjian
2001-05-23Fix ANT so it only has '*.class' files, not the 'tags' file.Bruce Momjian
2001-05-22Back out timezone fix. Not needed in jdbc1.Bruce Momjian
2001-05-19Prevent ANT from recreating the JAR files just because theBruce Momjian
errors.properties files were being copied.
2001-05-17Fix pg_index statistics query to join proper relation.Bruce Momjian
2001-05-17Included is a patch that fixes a bug introduced in the lastest versionBruce Momjian
(1.22) of interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java. That change removed a line that set the variable s to the value of the stringbuffer. This fix changes the following if checks to check the length of the stringbuffer instead of s, since s no longer contains the string the if conditions are expecting. The bug manifests itself in getTimestamp() loosing the timezone information of timestamps selected from the database, thereby causing the time to be incorrect. Barry Lind
2001-05-17Cleanup of backpatch of jdbc2 improvements to jdbc1:Bruce Momjian
Here's what I came up with. The biggest difference api between JDK1.x and later versions is the support for collections. The problem was with the Vector class; in jdk1.x there is no method called add, so I changed the calls to addElement. Also no addAll, so I rewrote the method slightly to not require addAll. While reviewing this I notices some System.out.println statements that weren't commented out. So I commented them out in both versions. The upshot of all of this is that I have clean compile, but no idea if the code works ;( Dave Cramer
2001-05-17Fix 'make clean' with jdbc and ant by using filesets.Bruce Momjian
2001-05-17Mark column as not used.Bruce Momjian
2001-05-16Fix for HASH for index lookups in ODBC.Bruce Momjian
2001-05-16This patch fixes a bug which occurs when setObject(1,obj) is called and objBruce Momjian
is of type Object, and is null Dave Cramer
2001-05-16Add NUMERIC tests to jdbc code.Bruce Momjian
David Esposito
2001-05-16I was trying to get a very nice FREE graphical db tool called DbVisualizerBruce Momjian
(http://www.ideit.com/products/dbvis/) to work with Postgresql and I found out the following bug: if database has views then getTables() gets the null pointer exception ('order by relname' makes the listing tree in DbVisualizer a lot useful !!) This patch should propably be applied to the the jdbc1's DatabaseMetaData.java, too. Panu Outinen
2001-05-16Change the line:Bruce Momjian
return ((c == 't') || (c == 'T')); int the getBoolean function on line 184:ish to: return ((c == 't') || (c == 'T') (c == '1')); Hunter Hillegas
2001-05-16Backpatch jdbc2 fixes to jdbc1, ANT fixes, from Peter EisentrautBruce Momjian
2001-05-16Backpatch getImportedKeys to jdbc1.Bruce Momjian
2001-05-16Backpatch ORDER BY fix to jdbc1.Bruce Momjian
2001-05-16Here's an easy patch for todays snapshot to sort the result of theBruce Momjian
public ResultSet getTables(String catalog, String schemaPattern, String Jeroen van Vianen
2001-05-16jdbc2 implementation of getImportedKeys.Bruce Momjian
Ola Sundell
2001-05-16The current implementation of BlobInputStream doesBruce Momjian
not properly handle 8-bit unsigned data as it blindly casts the byte to an int, which java most helpfully promotes to a signed type. This causes problems when you can only return -1 to indicated EOF. The following patch fixes the bug and has been tested locally on image data. Chad David
2001-05-11Stamp CVS as 7.2. Update all interface version numbers. This is theBruce Momjian
time to do it, not during beta because people are using this stuff in production sometimes.
2001-05-09that's just me again, here's normal patch for KOI8_U toBruce Momjian
jdbc/Connection.java Andy P.S. in Connection.java if encoding=="WIN" then dbEncoding is set to "Cp1252". What if it's Cyrillic "WIN"? Than it should be "Cp1251". Is there any way to fix that without making different "WIN" encodings in PostgreSQL? Andy Rysin
2001-05-09Mention new jdbc mailing list instead of interfaces list.Bruce Momjian
2001-05-08Fix paren typo in java.Bruce Momjian
2001-03-19Update Peter Mount's email address in README.Bruce Momjian
2001-03-14We're way past 6.3 ...Peter Eisentraut
2001-03-14Update. Things are now build through 'make'.Peter Eisentraut
2001-03-11Add uninstall target to Java build.Peter Eisentraut
Respect default port setting in JDBC driver. Pick up version number from Makefile.global. Change installation directory to share/java/. Document.
2001-03-06Tue Mar 06 12:05:00 GMT 2001 peter@retep.org.ukPeter Mount
- Removed org.postgresql.xa.Test from the JDBC EE driver as it's an old test class and prevented it from compiling.
2001-03-05Ok, I've split todays commit into three, the first two already done had somePeter Mount
bits in JDBC & the first set of tools into contrib. This is the third, and deals with enabling JDBC to be compiled with the main source. What it does is add a new option to configure: --with-java This option tells configure to look for ant (our build tool of choice) and if found, it then compiles both the JDBC driver and the new tools as part of the normal make. Also, when the postgresql install is done, all the .jar files are also installed into the ${PGLIB}/java directory (thought best to keep then separate) Now I had some conflicts when this applied so could someone please double check that everything is ok? Peter
2001-03-05Minor fixes...Peter Mount
2001-02-16Some more updates...Peter Mount
Fri Feb 17 15:11:00 GMT 2001 peter@retep.org.uk - Reduced the object overhead in PreparedStatement by reusing the same StringBuffer object throughout. Similarly SimpleDateStamp's are alse reused in a thread save manner. - Implemented in PreparedStatement: setNull(), setDate/Time/Timestamp using Calendar, setBlob(), setCharacterStream() - Clob's are now implemented in ResultSet & PreparedStatement! - Implemented a lot of DatabaseMetaData & ResultSetMetaData methods. We have about 18 unimplemented methods left in JDBC2 at the current time.
2001-02-14Web Feb 14 17:29:00 GMT 2001 peter@retep.org.ukPeter Mount
- Fixed bug in LargeObject & BlobOutputStream where the stream's output was not flushed when either the stream or the blob were closed. - Fixed PreparedStatement.setBinaryStream() where it ignored the length
2001-02-13Some more including the patch to DatabaseMetaData backed out by Bruce.Peter Mount
Tue Feb 13 16:33:00 GMT 2001 peter@retep.org.uk - More TestCases implemented. Refined the test suite api's. - Removed need for SimpleDateFormat in ResultSet.getDate() improving performance. - Rewrote ResultSet.getTime() so that it uses JDK api's better. Tue Feb 13 10:25:00 GMT 2001 peter@retep.org.uk - Added MiscTest to hold reported problems from users. - Fixed PGMoney. - JBuilder4/JDBCExplorer now works with Money fields. Patched Field & ResultSet (lots of methods) for this one. Also changed cash/money to return type DOUBLE not DECIMAL. This broke JBuilder as zero scale BigDecimal's can't have decimal places! - When a Statement is reused, the previous ResultSet is now closed. - Removed deprecated call in ResultSet.getTime() Thu Feb 08 18:53:00 GMT 2001 peter@retep.org.uk - Changed a couple of settings in DatabaseMetaData where 7.1 now supports those features - Implemented the DatabaseMetaData TestCase. Wed Feb 07 18:06:00 GMT 2001 peter@retep.org.uk - Added comment to Connection.isClosed() explaining why we deviate from the JDBC2 specification. - Fixed bug where the Isolation Level is lost while in autocommit mode. - Fixed bug where several calls to getTransactionIsolationLevel() returned the first call's result.
2001-02-13Remove postgresql jdbc files, per Peter.Bruce Momjian
2001-02-13Remove postgresql jdbc files, per Peter Mount.Bruce Momjian
2001-02-13Back out *inv* changes for this file. Peter want to handle it.Bruce Momjian
2001-02-09Remove last code that assumed xinv/xinx are large object files.Bruce Momjian
2001-02-07Some updates prior to retrieving a fresh cvs copy:Peter Mount
Tue Feb 06 19:00:00 GMT 2001 peter@retep.org.uk - Completed first two TestCase's for the test suite. JUnit is now recognised by ant.
2001-01-31Wed Jan 31 08:46:00 GMT 2001 peter@retep.org.ukPeter Mount
- Some minor additions to Statement to make our own extensions more portable. - Statement.close() will now call ResultSet.close() rather than just dissasociating with it.
2001-01-31Tue Jan 30 22:24:00 GMT 2001 peter@retep.org.ukPeter Mount
- Fixed bug where Statement.setMaxRows() was a global setting. Now limited to just itself. - Changed LargeObject.read(byte[],int,int) to return the actual number of bytes read (used to be void). - LargeObject now supports InputStream's! - PreparedStatement.setBinaryStream() now works! - ResultSet.getBinaryStream() now returns an InputStream that doesn't copy the blob into memory first! - Connection.isClosed() now tests to see if the connection is still alive rather than if it thinks it's alive.
2001-01-25Added an alternative constructor to PGSQLException so that debuggingPeter Mount
some more osteric bugs is easier. If only 1 arg is supplied and it's of type Exception, then that Exception's stacktrace is now included. This was done as there's been a report of an unusual bug during connection. This will make this sort of bug hunting easier from now on.
2001-01-25This patch fixes an arrayindexoutofbounds exception that was justBruce Momjian
introduced into the code. The fix is a fix to org.postgresql.core.ByteArrayDim1.java. Barry Lind