[CommandBox 3.0.0] Built-in Lucee server and new JDBC Driver

Communities ColdBox HMVC
1

Does anyone know where to place JDBC driver .jar files when using the built-in Lucee server within CommandBox? The one that starts up with server start. I’ve dropped it everywhere I’ve found a lib folder but haven’t struck gold just yet.

I’m trying to setup a new Datasource for an Intersystems Cache database. The JDBC driver works on ACF9 but I’m trying to get it going with Lucee.

Thanks!
Wes

2

On Windows 7 64-bit it needs to go in: *C:\Users<YourUsername>.CommandBox\lib* There are a lot of other libs in there as well you’ll see.

If you have CommandBox already open when you drop it in there you need to close and re-open CommandBox again so CommandBox is aware of the new lib. Simply restarting the built-in Lucee server will not find it if CommandBox was already running when you place the files in there.

3

Yep, that’s the directory. I’m surprised you needed to restart the CLI though-- the server runs in its own process.

For what it’s worth, there is also a server start param that additional lib directories to be loaded just for that server.

Thanks!

~Brad

ColdBox Platform Evangelist
Ortus Solutions, Corp

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

4

Confirmed you are right, Brad – sorry for the misinformation. If you issue a server stop followed by a server start then Lucee will pick up the new lib even if the CommandBox CLI was already open when you dropped the file in there.

I was restarting simply using the Services > Restart feature with the Lucee Server Administrator which does not pick up the new file. I didn’t check but I’m guessing because it doesn’t spawn a new process when you “restart” this way? I suppose that feature reads other config files but just doesn’t rescan that lib directory.

Anyway, all good here. Thanks for the tip on the server start param!

Wes

5

Just checked and confirmed the PID (process ID) stays the same when you use the “Restart” feature within the Lucee Server Administrator web page. A server stop and server start within CommandBox gets a new PID.

6

Ah yes, the restart button inside Lucee doesn’t destroy the servlet container, it just reloads the Lucee context in memory. CommandBox’s restart command actually runs “stop” followed by “start”.

https://github.com/Ortus-Solutions/commandbox/blob/development/src/cfml/system/modules/server-commands/commands/server/restart.cfc#L46-L53

Thanks!

~Brad

ColdBox Platform Evangelist
Ortus Solutions, Corp

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