CFEverywhere with CFMX7

[dfgrumpy]

I am just starting with CFEverywhere and I think it is a very cool
concept. I would like to use CFMX7 and not use bluedragon. However,
all the documentation I can find does not cover this. Does anyone know
how I can get this to run using CFMX7?

Thanks,

--Dave

[Phil Cruz]

I haven't done it.  Mainly because MM is not as flexible with their licensing options for CFMX7.  That being said, it should be possible to use CFMX7 and the steps would be very similar.  "Just" deploy CFMX7 onto the J2EE server instead of BD.  If you do try this please report back your results to the list.

-Phil

[dfgrumpy]

Ok.. I got it to work. Here is how I did it. First I used Jetty
v4.2.23. Apparently this is an issue with 5.1.3 that makes it not work
with CFMX7. The CF part is a little complex. First, use the cfmx7
installer to create a war install of cf. Once you have the war rename
it to .zip and then extract it. Place the extracted zip in the
jetty/webapps directory. Add the web application to your startup xml
file. I removed all the others and just have this one left.

<Call name="addWebApplication">
<Arg>/</Arg>
<Arg><SystemProperty name="jetty.home"
default="."/>/webapps/cfusion</Arg>
</Call>

After this is done start jetty. After jetty starts go to the cfadmin
page to complete it's setup process.
http://localhost:8080/CFIDE/administrator/index.cfm

You should now be able to process and run cfm pages.

Hope this helps.

--Dave

[Yvan]

Dave -- I followed the instructions you gave, but can not get the
administrator url to come up. Instead I get a 404 error:

HTTP ERROR: 404 Not Found
RequestURI=/CFIDE/administrator/index.cfm

What I did is I named my Jetty folder "CFMX7", .. and created a folder
named "CFUSION" inside the "D:\CFMX7\webapps" folder, and placed the
CFIDE, META-INF, and WEB-INF folders (extracted from the WAR file)
inside this folder ("D:\CFMX7\webapps\CFUSION").

I then edited my startup xml file ( D:CFMX7\etc\demo.xml ) by adding
the the same section you indicated:

<Call name="addWebApplication">
<Arg>/</Arg>
<Arg><SystemProperty name="jetty.home"
default="."/>/webapps/cfusion</Arg>
</Call>

Jetty loads without any problems -- and I see lines indicating that the
Cold Fuiosn service has been started sucessfully. But obviously
something isn't set up correctly, since I can't access the admin url to
finish the setup process. I suspect that it might have something to do
with either my having placed the files in the incorrect webapps folder,
.. or I need to use a different startup XML file besides demo.xml.

Any idea as to what the problem might be?

Thanks,
- yvan

[Dave Ferguson]

Hi,

Make sure that you are browsing to the correct port. The default
port for Jetty is port 8080. Also, make sure that you do not have 2
addWebapplications that have the arg set to "/".
--Dave

[Yvan]

>> Also, make sure that you do not have 2
addWebapplications that have the arg set to "/".

That seemed to do it. I can now access the Administrator, and I've
figured out how and where to run my CF apps. Thanks!

So what kind of database are you interfacing with, if any? I was
wondering if I might be able to create a dsn-less connection using an
Access database under CF7. They used to have this feature in earlier
versions of CF, but the feature was removed for whatever reason. But
Do you know if this can still be achieved somehow?

- yvan

[Yvan]

Actually, - I just researched this topic, and apparently you can have a
dsn-less connection by setting up a "passthrough datasource" in
CFAdmin. However, .. the J2EE version of CFMX7 does not automatically
install the necessary ODBC component for this. It is possible to
configure a JDBC driver to communicate with Access, only I haven't yet
figured out where I can obtain this JDBC driver (anyone here know, by
any chance?)

Surely there must be a way to communicate with Access databases
directly (without the need for any kind of ODBC connection) under
CFMX7. Derby seemed promising, only my experiments with it have led me
to believe that the JRE would need to be bundled with the distributed
application in order to ensure 100% portability. And aside from that,
I'm finding that Derby databases are extremely awkward to create /
design, since the graphical clients that are available for them are
somewhat lacking and bug-ridden.

Anyone have any other possible database solutions? Preferably something
that doesn't rely on JAVA/JRE, and that doesn't require
re-configuration whenever the the physical location of the application
has changed?

Thanks in advance,
- yvan

[megan]

HI - you can find all kinds of jdbc drivers (including one for ms
access) at http://developers.sun.com/product/jdbc/drivers

hth ~megan

[Yvan]

Thanks Megan. The choices are somewhat overwhelming. Is there any
particular one you'd reccomend out of these? Also, .. where would I
need to place this driver within my directory structure in order for
Cold Fusion to be able to locate it when I reference it?

- yvan

[megan]

Sorry, can't help you - I'm playing with the railo setup and using the
included hsqldb - however their documentation says if I wanted to
install a driver to a different db to put in in /WEB-INF/lib/

Megan

[Yvan]

Thanks - you are correct. I've got cfmx7 working with derby right now,
and derby's jdbc driver resides in the same path you indicated. So
I'll assume that this is the location for jdbc drivers. I might have
to continue using Derby, however, since the Access jdbc drivers are
priced out of the park (at a glance - $495 - $1495). I'll need to
research it more thoroughly before I make up my mind, but so far, it
doesn't look good.

- yvan

[Ron Mast]

Hi Yvan,
Have you looked at xmldb by Nate?
You can download it at www.webclarity.com
I got it to work with Jetty and BD.
I just now have to figure out how to get the dang application on a CD
and run it.
Still waiting for Part 3.