Hi!
I'm using Postgres, recently I started using ERXModelGroup to set connections
dictionaries for my eomodels. Looking at the connections in Postgres I noticed
several IDDLE IN TRANSACTION connections while I had specified
useBundledJdbcInfo=true in dbConnectURLGLOBAL
My dbConnectURLGLOBAL looks like this
dbConnectURLGLOBAL=jdbc:postgresql://localhost/databese?useBundledJdbcInfo=true&useUnicode=false&characterEncoding=UTF-8
Looking around in PostgresqlPlugIn.java I found the cause in method
shouldUseBundledJdbcInfo()
shouldUseBundledJdbcInfo = url.toLowerCase().matches(".*(\\?|\\?.*&)" +
PostgresqlPlugIn.QUERY_STRING_USE_BUNDLED_JDBC_INFO.toLowerCase() +
"=(true|yes)(\\&|$)");
The regex is only works for urls having one parameter (useBundledJdbcInfo)
I replaced it by a matcher and voila!
Matcher matcher =
Pattern.compile(PostgresqlPlugIn.QUERY_STRING_USE_BUNDLED_JDBC_INFO.toLowerCase()
+ "=(true|yes)").matcher(url.toLowerCase());
shouldUseBundledJdbcInfo = matcher.find();
Bonne journée
Benoit Havret
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
