pgsql/src/interfaces/jdbc/org/postgresql jdbc1 ...

pgsql/src/interfaces/jdbc/org/postgresql jdbc1 ...

Post by momj.. » Sun, 30 Sep 2001 12:08:38



CVSROOT:        /cvsroot
Module name:    pgsql

Modified files:
        src/interfaces/jdbc/org/postgresql/jdbc1: DatabaseMetaData.java
        src/interfaces/jdbc/org/postgresql/jdbc2: DatabaseMetaData.java

Log message:
        Per the recent discussion there's been some code changes in JDBC's
        DatabaseMetaData.getColumn(). I proposed a patch that would change the
        number of queries to find out all columns in a table from 2 * N + 1 to 1 (N
        being the number of columns reported) by using some outer joins. I also
        fixed the fact that getColumns() only returned columns that had a default
        defined. OTOH, I did not use to change the code required for obtaining a
        column's remarks (by using col_description() for 7.2  and requested by Tom
        Lane).

        Finally, I have found a way to get all the column details in a single query
        *and* use col_description() for 7.2 servers. A patch is attached. It
        overrules Ren? Pijlman's fix for this that was committed just today, but
        still used N + 1 queries (sorry Ren? ;-) )

        I also fixed the return values for TABLE_CAT and TABLE_SCHEM from "" to
        null, to be more standard compliant (and requested in Ren?'s mail found at
        http://fts.postgresql.org/db/mw/msg.html?mid=1034253).

        As always, the JDBC1 version has not been tested as I have no JDK 1.1

        Jeroen van Vianen

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly

 
 
 

pgsql/src/interfaces/jdbc/org/postgresql jdbc1 ...

Post by momj.. » Sat, 06 Oct 2001 00:59:03


CVSROOT:        /cvsroot
Module name:    pgsql

Modified files:
        src/interfaces/jdbc/org/postgresql/jdbc1: ResultSet.java
        src/interfaces/jdbc/org/postgresql/jdbc2: ResultSet.java

Log message:
        Attached is a patch which deals with

        select 'id' as xxx from table

        The issue is:

        When the driver gets a data type which does not map into the SQL.Types
        it attempts to load the object into a java object. Eventually throwing
        an exception indicating that the type "unknown" was not found.

        Since the backend defaults "unknown" types to text it was suggested that
        the jdbc driver do the same.

        This patch does just that.

        I have tested it on the above select statement as well as a small
        program that serializes, and deserializes a class

        Dave Cramer

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command


 
 
 

1. pgsql/src/interfaces/jdbc/org/postgresql jdbc1 ...

CVSROOT:        /home/projects/pgsql/cvsroot
Module name:    pgsql

Modified files:
        src/interfaces/jdbc/org/postgresql/jdbc1: DatabaseMetaData.java
        src/interfaces/jdbc/org/postgresql/jdbc2: DatabaseMetaData.java

Log message:
        Bring DatabaseMetaData feature tests up to date:

        * NULLs are sorted differently in 7.2
        * table correlation names are supported
        * GROUP BY, ORDER BY unrelated is supported since 6.4
        * ESCAPE/LIKE only supported since 7.1
        * outer joins only since 7.1
        * preferred term for procedure is "function"
        * preferred term for catalog is "database"
        * supports SELECT for UPDATE since 6.5
        * supports subqueries
        * supports UNION; supports UNION ALL since 7.1
        * update some of the max lengths to match reality
        * rearrange some functions to match the order in the spec
        for easier maintenance

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

2. Unload very slow... could that be a bug?

3. pgsql/src/interfaces/jdbc/org/postgresql/jdbc1 ...

4. Help me...please.....tutility.h and tutility.lib....

5. pgsql/src/interfaces/jdbc/org/postgresql jdbc1 ...

6. ::Oracle DBA's::Seattle, Washington:: dr001814

7. Restricted DB with no Password Dialog?

8. pgsql/src/interfaces/jdbc/org/postgresql/jdbc1 (PreparedStatement.java ResultSet.java)

9. pgsql/src/interfaces/jdbc/org/postgresql jdbc1 ...