Upgraded to 2.1 - Postgres Error

Communities CommandBox CLI
1

Hi,

I just upgraded my CommandBox to 2.1 and the CLI from 1.02 > 1.07

Previously my CFWHEELS app was successfully running on CommandBox and now doesn’t work due to a Postgresql error which I presume has to do with the version of Lucee in CB 2.1

Method org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is not yet implemented.

Is there a way to update the drivers used with the internal Lucee server and/or update Lucee itself?

2

Hi, you are correct that there is a bug in the newest version of Lucee we used that does not support the PostgreSQL driver it shipped with. The driver was updated to a new version that was incompatible. You can read more about it in this ticket:

https://luceeserver.atlassian.net/browse/LDEV-501

It appears Micha put in a fix in Lucee 4.5.2.008. That fix is available on the development update channel for Lucee already.

  1. Start an embedded CommandBox server (any one, doesn’t matter)
  2. Right click on the CommandBox icon in the system tray and choose “Open Server Admin”
  3. Use the regular Lucee update mechanism to update your local embedded server
  4. Test your PostgreSQL calls and let us know if it works

Thanks!

~Brad

ColdBox Platform Evangelist
Ortus Solutions, Corp

E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com

3

Hi Brad,

Thank you for the reply.

It worked and I’m operational again, much thanks and loving CommandBox :wink:

cheers,
Bill

4

That’s excellent and thanks for following up! Apologies for the troubles-- this is what we get for updating to a development version of Lucee that wasn’t fully tested :confused:

Thanks!

~Brad

ColdBox Platform Evangelist
Ortus Solutions, Corp

E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com