I'm very likely going about this the wrong way but...
# luceeb
bhartsfield
10/31/2023, 11:39 AMI'm very likely going about this the wrong way but, I am trying to create a lucee extension to deploy the snowflake-provided JDBC jar file for creating Snowflake datasources. The extension is installing (I'm using commandbox) without error but it is only putting the .jar file in the server-context's lib directory. If I manually put the jar file in the lucee-web context lib folder, the datasources work fine but I cannot figure out how to make an extension do that automatically. Any ideas or better solutions than an extension?
bhartsfield
10/31/2023, 11:41 AMI put the jar in the application's class paths and loaded it through this.javasettings. I can use the class in createObject() fine that way but it doesn't work as a datasource class when I load it that way... you just get the dreaded "cannot load class through its string name, because no definition for the class with the specified name could be found"
That is why I started trying the lucee extension route
bhartsfield
10/31/2023, 11:42 AMThe extension is very basic. Just a META-INF/manifest.mf file and the .jar file placed inside a lib folder
d
dswitzer
10/31/2023, 1:32 PMIf you haven't already, read the following:
https://docs.lucee.org/guides/lucee-5/extensions.html
https://docs.lucee.org/guides/Various/tutorial-lucee/tutorial-extension-provider.html
And then look at one of the existing Datasource extensions:
https://github.com/lucee/extension-jdbc-mysql
b
bhartsfield
10/31/2023, 1:40 PMah ha!
Copy code
/webcontextsbhartsfield
10/31/2023, 1:41 PMI have made extensions for functions before. loading a jar like this is a first for an extension for me
bhartsfield
10/31/2023, 1:43 PMI was going off of the SQL server extension for examples but there's a lot in there. this mysql one looks like a smaller, cleaner example too
b
bdw429s
10/31/2023, 4:33 PM@bhartsfield If you want to test a jar as a JDBC driver, I've always needed to specify it via the
app.libDirsbdw429s
10/31/2023, 4:34 PMThe class loader the application.cfc's this.javaSettings uses is not "vislble" to the bits that load JDBC drivers
bdw429s
10/31/2023, 4:34 PMAs far as where the jar is going, is there a reason you need it in the web context dir? I assume you installed the extension into the server context, which should make the jar accessible to all web contexts.
b
bhartsfield
10/31/2023, 4:35 PMI just know that it works when I drop it (manually) into the web context lib dir. I have an extension that puts it in the server-context lib dir but, even with explicitly setting release-type: web or all, it never makes it into the web context dir
bhartsfield
10/31/2023, 4:36 PMI will give app.libdirs a shot!
b
bdw429s
10/31/2023, 4:37 PMCool- I don't have any experience using a "normal" jar for drivers. The Ortus cache extensions I wrote used an OSGI bundle which gets loaded a little differently than a traditional jar
bdw429s
10/31/2023, 4:37 PMAnd so far as I know, all the inbuilt Lucee JDBC drivers use OSGI bundles as well for the actual JDBC jar
b
bhartsfield
10/31/2023, 4:37 PMyeah, it LOOKs simpler with an OSGI bundle
bhartsfield
10/31/2023, 4:38 PMat least there are more examples of that
b
bdw429s
10/31/2023, 4:38 PMI don't know if I'd use the word "simple" and "OSGI" in the same sentence, but there is more prior art 😆
b
bhartsfield
10/31/2023, 4:39 PMheh
bhartsfield
10/31/2023, 4:49 PMapp.libDirs appears to be working!
bhartsfield
10/31/2023, 4:50 PMtalk about the wrong direction with this... app.libDirs is sooooo much simpler too
b
bdw429s
10/31/2023, 4:50 PMWell, if you want to distribute it, you'll need to figure out the extension
bdw429s
10/31/2023, 4:50 PMBut if this was just for you to use, then libDirs all the way 🙂
b
bhartsfield
10/31/2023, 4:51 PMIt was just for this one app and no one really responded to the previous snowflake question so I'm guessing it's not too popular with CFers
b
bdw429s
10/31/2023, 4:54 PMI saw the original question, but had never heard of it, lol
👍 1
b
bhartsfield
11/01/2023, 10:12 PMfor the record, little bobby two hands had to upgrade before libDirs worked 😛
bhartsfield
11/01/2023, 10:13 PMtechnically I was upgraded but prod was not heh
Thank you both for your help.
👍 1
2 Views