Hello
I use an utilities who use the method isnullable of field too more.
And this methods (and others) call directly Postgres to obtain the information.
When I see the log request of postgre I see 1000 request for this and
100 request for my apllication
This utilities are hibernate and jahia . see the web sites to see that is it!
But to enhnance I change the code of the postgre driver. But you
imagine I use less time to enhance, and the code is certainly not the
best result of a good reflexion. but it resolve my problem.
I add a simple cache manager to save the final result (not a resulset)
of queries and its parameters.
I add a cache manager in the cache directory
org/postgresql/cache/CacheManager.java
org/postgresql/cache/PropertyCacheManager.java
and
I change this file
org/postgresql/core/Field.java
org/postgresql/Driver.java
org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java
org/postgresql/jdbc2/AbstractJdbc2ResultSetMetaData.java
org/postgresql/jdbc2/TypeInfoCache.java
I send a diff of my code
Thanks for your help to enhance the driver