Thanks Joe,
after communicating with Michael I am using another approach:
I uninstalled all driver extensions and just copied the matching driver jars to my lib Folder. (made a backup of my lucee-server/context/context/admin/dbdriver folder first)
Works like in Lucee 4.5 and is much easier to manage.
-HarryVon: lucee@googlegroups.com [mailto:lucee@googlegroups.com] Im Auftrag von Joseph Gooch
Gesendet: Dienstag, 26. Juli 2016 02:38
An: lucee@googlegroups.com
Betreff: Re: [Lucee] Re: org.lucee.postgresql JDBC driver dated - how would we update it?
I’ve never had any issues with JDBC-extension-factory. I’ve used it on several macs and linux machines.
The foreach error just means your environment doesn’t have ant-contrib installed.
I have no idea on the derby error - as I said, I’ve never encountered it.
You can roll lex files yourself, (they’re just ZIP files with a manifest)
Or you can look into using lucee - cfbundle comes to mind. I’ve never used it.
-G
On Mon, Jul 25, 2016 at 3:41 AM, Harry Klein <@Harry_Kleinmailto:Harry_Klein> wrote:
Thanks for the lexfile.
Unfortunately we have to update more drivers, and also build a new one for MariaDB.
This is not possible with the JDBC-extension-factory right now. Maybe it works only on Linux/Mac?
Should I create issues for the problems mentioned below?
-Harry
Von: lucee@googlegroups.commailto:lucee@googlegroups.com [mailto:lucee@googlegroups.commailto:lucee@googlegroups.com] Im Auftrag von Joseph Gooch
Gesendet: Freitag, 22. Juli 2016 18:51
An: lucee@googlegroups.commailto:lucee@googlegroups.com
Betreff: Re: [Lucee] Re: org.lucee.postgresql JDBC driver dated - how would we update it?
Interesting.
I’ve uploaded a github release:
https://github.com/goochjj/JDBC-extension-factory/releases/tag/MSSQL-6.0.7507
That should get you the lex file you need.
-G
On Fri, Jul 22, 2016 at 12:13 PM, Harry Klein <@Harry_Kleinmailto:Harry_Klein> wrote:
My colleague has another problem:
D:\contens\javaworkspace\JDBC-extension-factory\build.xml:260: Problem: failed to create task or type foreach
Cause: The name is undefined.
Action: Check the spelling.
Action: Check that any custom tasks/types have been declared.
Action: Check that any / declarations have taken place.
Am Freitag, 22. Juli 2016 17:24:17 UTC+2 schrieb Harry Klein:
Unfortunately I get an ant error:
dist:
[echo] F81ADA62-BB10-552D-9ACEE5D43F3FFC46
[echo] Apache Derby
[echo] Apache Derby, an Apache DB subproject, is an open source relational database implemented entirely in Java and available under the Apache License, Version 2.0.
[echo] D:\projekte_cf\lucee\JDBC-extension-factory\build\derby\derby.jar
[echo] D:\projekte_cf\lucee\JDBC-extension-factory\build\derby\Derby.cfc
[echo] Derby.cfc
[echo] D:\projekte_cf\lucee\JDBC-extension-factory\build\derby
[echo] D:\projekte_cf\lucee\JDBC-extension-factory\build\derby\build.properties
[unzip] Expanding: D:\projekte_cf\lucee\JDBC-extension-factory\build\derby\derby.jar into D:\projekte_cf\lucee\JDBC-extension-factory\temp
[echo] Driver class name:org.apache.derby.jdbc.AutoloadedDriver
[mkdir] Created dir: D:\projekte_cf\lucee\JDBC-extension-factory\temp\extension\derby-10.12.1000001.1704137
BUILD FAILED
D:\projekte_cf\lucee\JDBC-extension-factory\build.xml:260: The following error occurred while executing this line:
D:\projekte_cf\lucee\JDBC-extension-factory\build.xml:223: java.io.FileNotFoundException: D:\projekte_cf\lucee\JDBC-extension-factory\temp\extension\derby-10.12.1000001.1704137\META-INF\MANIFEST.MF (Das System kann den angegebenen Pfad nicht finden)
Am Mittwoch, 20. Juli 2016 16:56:00 UTC+2 schrieb Joseph Gooch:
9.4.1206 is in the JDBC extension factory repository… I’m not sure why it’s unavailable via the update provider or the website (http://preview.lucee.org/download/?type=extensions)
If you wanted to deploy it yourself:
git clone https://github.com/lucee/JDBC-extension-factory
cd JDBC-extension-factory
ant
In your dist folder, there should be a postgresql-9.4.1206.jdbc41.lex - copy that to your lucee-server/deploy/ folder.
In a minute or so it should disappear and your Lucee administrator should show the new version.
If you want 1209 specifically, it appears the jar from the maven repository does not include the OSGi items needed in the manifest. To fix:
- copy the build/postgresql-9.4.126 [sic] directory to a new one i.e. postgresql-9.4.1209
- Extract META-INF/MANIFEST.MF from the existing postgresql-9-4-1206-jdbc41.jar. Delete the jar.
- Change the Bundle-Version header in the MANIFEST.MF to 1209 (or 1209.jre7)
- Download the new v1209 jar
- Extract the jar to a temp folder
- Remove the existing META-INF/MANIFEST.MF from the temp folder, and any signatures if present (.RSA or .SF files in META-INF)
- Create a new jar from the temp folder, using the MANIFEST you created (i.e. cd tempfolder; jar cvmf …/MANIFEST.MF …/postgresql-9-4-1209-jre7.jar .)
- Run ant at the root of the JDBC-extension-factory dir
- Copy your postgresql-9-4-1209 lex file from the dist folder into the deploy folder
- Fork the repository, commit your new directory and issue a Pull Request. Create a JIRA ticket here https://luceeserver.atlassian.net/secure/Dashboard.jspa to have that PR processed. (Ideally, so others can benefit from your work!)
-G
On Tuesday, July 19, 2016 at 5:00:19 AM UTC-4, Markus Wollny wrote:
Hi,
The JDBC driver that comes with Lucee 5 is at 8.3.0.jdbc4. We’d like to use a more current version 9.4.1209 JDBC 4. There is a Maven Repo (see http://repo1.maven.org/maven2/org/postgresql/postgresql/9.4.1209.jre7/), but I couldn’t find any documentation whatsoever on how to exchange the 8.3 driver for the more current one. I did find a similar discussion for the MySQL driver here http://lang.lucee.org/t/lucee-5-osgi-and-changing-a-bundle/270 - but I couldn’t really make much of this. In Lucee 4.5 I would simply change the .jar file for the driver, now that there’s the OSGi magic in Lucee 5 it seems to be somewhat more complicated to customize the innards of Lucee.
Am I missing something here?
Kind regards
Markus
Get 10% off of the regular price for this years CFCamp in Munich, Germany (Oct. 20th & 21st) with the Lucee discount code Lucee@cfcamp. 189€ instead of 210€. Visit https://ti.to/cfcamp/cfcamp-2016/discount/Lucee@cfcamp
You received this message because you are subscribed to the Google Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+unsubscribe@googlegroups.commailto:lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.commailto:lucee@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/dba067d4-9596-4e2f-b5b0-be981c2f5dda%40googlegroups.comhttps://groups.google.com/d/msgid/lucee/dba067d4-9596-4e2f-b5b0-be981c2f5dda%40googlegroups.com?utm_medium=email&utm_source=footer.
For more options, visit https://groups.google.com/d/optout.
–
Get 10% off of the regular price for this years CFCamp in Munich, Germany (Oct. 20th & 21st) with the Lucee discount code Lucee@cfcamp. 189€ instead of 210€. Visit https://ti.to/cfcamp/cfcamp-2016/discount/Lucee@cfcamp
Get 10% off of the regular price for this years CFCamp in Munich, Germany (Oct. 20th & 21st) with the Lucee discount code Lucee@cfcamp. 189€ instead of 210€. Visit https://ti.to/cfcamp/cfcamp-2016/discount/Lucee@cfcamp
You received this message because you are subscribed to the Google Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+unsubscribe@googlegroups.commailto:lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.commailto:lucee@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/5834990a4c5247d6a40d97f4b8b31599%40srv-dc3.contens.localhttps://groups.google.com/d/msgid/lucee/5834990a4c5247d6a40d97f4b8b31599%40srv-dc3.contens.local?utm_medium=email&utm_source=footer.
For more options, visit https://groups.google.com/d/optout.
–
Get 10% off of the regular price for this years CFCamp in Munich, Germany (Oct. 20th & 21st) with the Lucee discount code Lucee@cfcamp. 189€ instead of 210€. Visit https://ti.to/cfcamp/cfcamp-2016/discount/Lucee@cfcamp
You received this message because you are subscribed to the Google Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+unsubscribe@googlegroups.commailto:lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.commailto:lucee@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAKY58c5Uh3VvVOVOb3%2B-4qGCm1uXn7de6imYHPuDfSAdOGLWqg%40mail.gmail.comhttps://groups.google.com/d/msgid/lucee/CAKY58c5Uh3VvVOVOb3%2B-4qGCm1uXn7de6imYHPuDfSAdOGLWqg%40mail.gmail.com?utm_medium=email&utm_source=footer.
For more options, visit https://groups.google.com/d/optout.