Change Lucee to 32bit Java

[pfef...@gmail.com]

My box is a Windows 2012 R2 (64bit) and I installed Lucee with the Windows installer from the downloads section on lucee.org.  How can I change Lucee to use a 32bit java instead of 64bit?

Thanks,
Chris

[AJ Mercer]

Is it not just a matter of downloading a 64 bit JVM?

My set up

Configuration File	C:\websites\lucee-5-express\lucee-server\context\lucee-server.xml
OS	Windows 8.1 (6.3) 64bit
Remote IP	0:0:0:0:0:0:0:1
Host Name	localhost
Servlet Container	Apache Tomcat/8.0.15
Java	1.8.0_40 (Oracle Corporation) 64bit
Architecture	64bit

--
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+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/a9c1ad05-bfb7-47d7-8dd2-2182878fb0c9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

AJ Mercer
<webonix:net strength="Industrial" /> | <webonix:org community="Open" />
http://twitter.com/webonix

[AJ Mercer]

Oh, sorry, you want to go the other way

[pfef...@gmail.com]

Thanks AJ.  I might have found a work around for my issue and may be able to keep 64 bit JVM.  I was just wondering if it's just a matter of replacing what is in the JDK folder with a 32-bit version?

Chris

[Sean Corfield]

I’m curious: why would you want to run a 32-bit JVM on a 64-bit machine?

Sean

[Chris]

<Cough><Cough> To connect to Access <Cough><Cough>

Chris

[Sean Corfield]

On Apr 16, 2015, at 9:27 AM, Chris <pfef...@gmail.com> wrote:

<Cough><Cough> To connect to Access <Cough><Cough>

Sorry :)

I guess you did something like this:

http://www.selikoff.net/2011/07/26/connecting-to-ms-access-file-via-jdbc-in-64-bit-java/

Sean Corfield -- (904) 302-SEAN
An Architect's View -- http://corfield.org/

"Perfection is the enemy of the good."
-- Gustave Flaubert, French realist novelist (1821-1880)

[Chris]

I did look at that, but the access 64bit driver is very buggy.  I would get [Microsoft][ODBC Driver Manager] Invalid string or buffer length.

I'm testing http://www.easysoft.com/products/data_access/jdbc-access-gateway/index.html#section=tab-1 and it seems to be working good.

I can't wait to not have to deal with Access anymore.  :)

Chris

[Igal Sapir]

Lucee's bytecode is the same for 32b and 64b.  simply run a 32b JVM to get it in 32b.

the startup script can be easily modified to point to a different JRE, or use the Tomcat applet to specify the JVM path in the Java tab.

also, you might want to convert the database once to something like H2 and do away with Access once and for all.

--
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+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/61bcf4f2-3d02-46bc-8992-c8da0ddf3de7%40googlegroups.com.

[Mehdi B]

Check in folder:

lucee\tomcat\bin

you will find a tool "Luceew.exe" it will allow you to change JVM used by tomcat. That would do the trick easily or allow you to upgrade JDK, or even use the same as Coldfusion if you have them on the same box like I did ;-).

More over JRE change here:

http://www.codejava.net/servers/tomcat/4-ways-to-change-jre-for-tomcat

M B

[lu...@lesener.de]

Dear all,

I have to support a legacy application that imports data from Access databases. Today I had to move the application to a server running Windows 2012 R2 and ran of course into the JDBC issue mentioned here. 

I'm happy to report that I managed to use the UCanaccess project driver (http://sourceforge.net/projects/ucanaccess/) with Lucee. Requires no ODBC object and connects nicely to the MDB files. 

Having to support MDBs is actually the only reason why the server in question is running Windows, so I'll see if UCanaccess is also usable with *nix boxes. Thought I'd share this in case somebody else has MDB pains, too...

Rgds

Lutz

[Jordan Michaels]

That's pretty sweet. Have you used UCanAccess with a Linux system yet?
Can you access MDB files on Linux then?

Thank you for letting the community know!

Warm Regards,
Jordan Michaels

> <http://lucee.org>. How can I change Lucee to use a 32bit java

> instead of 64bit?
>
> Thanks,
> Chris
>

> --
> See Lucee at CFCamp Oct 22 & 23 2015 @ Munich Airport, Germany - Get
> your ticket NOW - http://www.cfcamp.org/
> ---

> 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+un...@googlegroups.com

> <mailto:lucee+un...@googlegroups.com>.

> To post to this group, send email to lu...@googlegroups.com

> <mailto:lu...@googlegroups.com>.

> To view this discussion on the web visit

> https://groups.google.com/d/msgid/lucee/762b9ef4-93a0-4c64-a856-f3c5f916806c%40googlegroups.com
> <https://groups.google.com/d/msgid/lucee/762b9ef4-93a0-4c64-a856-f3c5f916806c%40googlegroups.com?utm_medium=email&utm_source=footer>.

[Jordan Michaels]

Ha. In my excitement I didn't fully comprehend your last statement. I'll just eagerly wait to hear how it goes for you on Linux. ;)

Thanks again!

-Jordan

To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/55E5FADD.7050600%40viviotech.net.

[lu...@lesener.de]

Works for me on OS X: No problems to access an MDB file with Lucee Express and UCanaccess running under Yosemite. Will try Debian tomorrow.

rgds

Lutz

[Kim Bélanger]

"I'm happy to report that I managed to use the UCanaccess project driver (http://sourceforge.net/projects/ucanaccess/) with Lucee"

Do you have a quick tutorial on how you managed it please ?
Or maybe a link. Thanks.

[lu...@lesener.de]

On Thursday, 10 December 2015 05:51:28 UTC+1, Kim Bélanger wrote:

Do you have a quick tutorial on how you managed it please ?
Or maybe a link. Thanks.

1. Copy the JARs from the archive at http://sourceforge.net/projects/ucanaccess/files/  to the /lib folder of your Lucee installation. You will need at least ucanaccess-x.x.x.jar, jackcess-x.x.x.jar, and hsqldb.jar. Commons-lang-x.x.jar and commons-logging-x.x.x.jar are also required, but they might already be in /lib, I'd make sure I keep the latest version.

2. Restart Lucee.

3. Create a new datasource (either in code or in Lucee Admin) with these settings: 

this.datasources["mdb"] = {
 class: 'net.ucanaccess.jdbc.UcanaccessDriver'
 , connectionString: 'jdbc:ucanaccess://d:/datapool/example.mdb'
 
 // optional settings
 , connectionTimeout: // default: 1; unit: seconds
};

The location of the MDB file in the example connection string refers to a Windows machine. If you're on Linux or OS X, it will look like this:

connectionString: 'jdbc:ucanaccess:///Users/lutz/datapool/example.mdb'

HTH,

Lutz

[Kim Bélanger]

Oh nice thanks a lot. That works well with a standard mdb.
But did you also managed to make it work with a secured MDB + MDW database ?
I read a lot on jacksess/jackcessencrypt and can't find a way to do it with connection strings.
Maybe you have an idea ?

Merci beaucoup !

[lu...@lesener.de]

Hi Kim,

glad you got it working.

I haven't tried it with encrypted MDBs, sorry. I'd recommend you try the forum of the UCanAccess project (https://sourceforge.net/p/ucanaccess/discussion/).

-- Lutz

[Kim Bélanger]

Thanks, i posted this to this end: https://sourceforge.net/p/ucanaccess/discussion/help/thread/b202c71e/