Re: Images in the database good or bad?
IMO there are times when it makes sense to store binary content in a database, and times when it does not. My rule of thumb is based on size and usage. If you expect the amount of binary content to grow tremendously, I would avoid storing binary content in the db. Otherwise, for small items such as profile photos, etc - it can make your life a lot easier. Also keep in mind that SQL Server 2008 includes a new "file stream" column type which is really the best of both worlds. http://blogs.msdn.com/rdoherty/archive/2007/10/12/getting-traction-with-sql-server-2008-filestream.aspx Dave Ross http://www.coldspringframework.org >> Now this is completely ridiculous: if you really need things >> like what's in EXIF, you extract it first and store it in an >> appropriate record about the file, just as well as width or >> height etc. >> This does not justify storing all pixels and colors as well >> in the database. > >Perhaps this feature alone doesn't justify storing binary data within the >database, but collectively, the advantages can outweigh the disadvantages. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Training: Adobe/Google/Paperthin Certified Partners >http://training.figleaf.com/ > >WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! >http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301899 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: LDAP
in general, no, I would say it's not a great idea, but sometimes requirements dictate that it has to be done. I've seen directories replicated out to a DMZ server to insulate things a bit, but I honestly don't see that as really improving security much, unless you are replicating non-sensitive information. for starters you should not open port 389 and instead open port 636 (and do LDAP over SSL/TLS). In addition, you could open a different port on the firewall (say 6636) and forward that to 636 on the inside. Also, if the rule is for traffic originating from a specific IP, that is much better than allowing anything in. I think a lot of this depends on how secure your LDAP servers are... in reality you shouldn't be able to do anything destructive without the necessary credentials. Even though the transmission of credentials will be encrypted, it doesn't change the fact that your server could be compromised and passwords sniffed before they go over the wire. I think there's a lot of variables to consider - if it *must* be done it tends to make admins more comfortable if the LDAP client is in a DMZ segment, thus under a bit more control (and can have IDS, etc) rather than a random server out on the Internet. Dave Ross http://www.coldspringframework.org > Have an app that is remote from a network that is your standard > LDAP/AD > dealthe client's folks really want the remote app to authenticate > back via LDAP. > > > > Now, I don't want to open up 389 in the firewall at all; so for you > great CF minds out thereis it even remotely advisable to setup a > firewall rule to accept 389 LDAP requests from a single IP > address.so this CF app can do its thing?? > > > > I always err on the side of no in these situationsbut limiting it > to > a specific IP is decent...but relies on that system being correct and > free of breachhas others seen this go on? > > > > Thanks > > > > Eric > > > > > Eric J. Hoffman > Managing Partner > 1940 Greeley Street South > Suite 102 > StillwaterMN55082 > mail: [EMAIL PROTECTED] > www: http://www.ejhassociates.com > tel: 651.717.4105 > fax: 651.717.4101 > mob: 651.245.2717 > Adobe Solutions Partner > Microsoft Certified Partner > > > > This message contains confidential information and is intended only > for [EMAIL PROTECTED] If you are not [EMAIL PROTECTED] > com you should not disseminate, distribute or copy this e-mail. Please > notify [EMAIL PROTECTED] immediately by e-mail if you have > received this e-mail by mistake and delete this e-mail from your > system. E-mail transmission cannot be guaranteed to be secure or > error-free as information could be intercepted, corrupted, lost, > destroyed, arrive late or incomplete, or contain viruses. Eric J. > Hoffman therefore does not accept liability for any errors or > omissions in the contents of this message, which arise as a result of > e-mail transmission. If verification is required please request a > hard-copy version. > ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Memory leak in CF7-based app, still trying to track it down
Post the code for how you are using OSCache. It looks like you are definitely ending up with too many references to internal CF classes on your CFCs. Remember - a CFC does not equate to a single Java object - thus caching concepts that work in the java world may not work exactly the same w/ CFCs. >I'm not sure if these are being sent to the list. Please let me know. Could >really use help in figuring out the memory leak caused by caching my CFC's >in application scope. Thanks - Dov > > > >http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:52111#281118 ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281230 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Scope Memory
There *is* away to see exactly how much space a given object (CFC, array, or otherwise) is taking up - perform a "Heap Dump". If you are running a JVM 1.4.2_12 and up, you can force a heap dump and thqen analyze the resulting bin file with jHat (a utility that comes w/ JDK6) to see what was in your heap, in terms of classes, number of instances, and size of each instance. It takes some digging, but if you need to find out the actual memory footprint of a CFC (in terms of bytes), you can do it this way. I talked a bit about this here (with links to info on doing heap dumps): http://www.d-ross.org/index.cfm?objectid=7DADADEF-1143-D861-4D62CCC08AB955CB The other way is to hook a profiler (like Borland's OptimizeIt) to a running jvm. Dave Ross http://www.coldspringframework.org >Is there any way (outside of getting CF8 in a few months) that I can >access the amount of memory that a given scope is using? > >Thanks, >Chris > >-- >http://cjordan.us ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: setters/getters - scalability issues?
Keep in mind those are actually inner classes. > Thanksthat cleared things up for me. > > I still cannot understand why CF would compile CFC methods into > individual Java classes and necessitate the shared function-class > references. Unless this is how Java does it as well internally > > > Joe > > >That's classes, not instances. There's a huge difference. Joe's > >description wasn't totally clear; here's what I think he was trying > to > >say (and I agree with): > > > >Each CFC instance has a reference to a shared singleton for each > >function. So the first CFC of a given type will create n+1 > instances > >(where n is the number of functions), and then all subsequent CFCs > >created for that type will only create 1 new instance and reference > >the preexisting instances of the functions. > > > >cheers, > >barneyb > > > >On 4/11/07, Steve Brownlee <[EMAIL PROTECTED]> wrote: > >> It is true that this happens. Here's a new of distinct classes > that > >> exist for an Email.cfc in our system. > >> > > > >-- > >Barney Boisvert > >[EMAIL PROTECTED] > >http://www.barneyb.com/ > > > >Got Gmail? I have 100 invites. ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275046 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Resetting Active Directory Password using CFLDAP ?
Basically you are attempting to change the password of your domain controller. "dn" means "distinguished name". Which means it's the full name of the account you are trying to modify. So it should be something like dn="uid=User,ou=Users,DC=domain,dc=co,dc=uk" >Am I not getting any value in the password field because I am not using >SSL or TLS ? So if I ran the same code over SSL or TLS the code below >would work ?? > >Sorry the dn should be set to dn="DC=domain,dc=co,dc=uk" shown below > > >action="modify" >modifyType="replace" >attributes="password=#password1#" >dn="DC=domain,dc=co,dc=uk" >server="server" >port="port" >username="username" >password="password"> > > >But I am now getting the error shown below ? > >An error has occured while trying to execute modify :[LDAP: error code >16 - 0057: LdapErr: DSID-0C090A85, comment: Error in attribute >conversion operation, data 0, vece]. > >One or more of the required attributes may be missing/incorrect or you >do not have permissions to execute this operation on the server ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268432 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Resetting Active Directory Password using CFLDAP ?
You have to connect via. SSL or TLS to change a pw in AD. The error you're getting is because you are refencing an unset variable: dn="#adresult.dn#" Where did adresult come from? Dave Ross http://www.coldspringframework.org >Hi > >Does anybody have any examples of using Coldfusion to reset a windows >users active directory account. > >Can it be done using Coldfusion ? > >The way I envisage this is an employee completes an online form entering >their active directory login ID and memorable data, and if correct they >can set another password for their account. > >This is what I have so far but how can I change it to allow the user to >change their password, because at present there seems to be no data in >the password field ? And I am getting the error 'Element DN is >undefined in ADRESULT. ' > >Any ideas ? > >Thanks > > login page snippet -- > > > >Windows Logon : >First Name : >Surname : >E-Mail : > >width="49" height="18"> > > >-- processing.cfm page snippet --- > > > > > > > > > > > > > > > >name="adresult" >attributes = "sAMAccountName,dn, cn,sn,givenName,password, mail,ou" >start="#StartOU#" >scope="subtree" >filter="#filter#" >server="servername" >port="port" >username="username" >password="password" >> > > > >Hello #cn# > > >Enter New Password >Confirm New Password >align="right" width="49" height="18"> > > > > >---changepassword.cfm page snippet-- > >action="modify" >modifyType="replace" >attributes="password=#password1#" >dn="#adresult.dn#" >server="server" >port="port" >username="username" >password="password"> > >Your Password has been changed ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268421 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What hw to use for loadbalancing
Look into CoyotePoint We use Cisco Netscalers which I think are cheaper than the F5 but I'm not completely sure about that. I know that CoyotePoint makes some nicer entry-level LBs Dave Ross http://www.coldspringframework.org >Hello, > >What (lower priced) options other than F5 Big IP LTM have I got when I >need to loadbalance 3 CFMX servers? > >3 x CFMX 7.x Enterprise on W2003 / IIS6 > >F5 is a bit expensive -18kUSD for Big-IP LTM 1500 > >What I basically need is something that works better than W2003 NLB. >(and not to difficult to establish/maintain) > >When JRun/CF dies behind the NLB cluster, the cluster is happily >continuing its loadbalancing as if nothing happened. > >I've been googling a bit but I'm not very much smarter.. > >Thanks, >Helge Hetland >WebSite AS ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Java Code Translation
http://java.sun.com/j2se/1.5.0/docs/guide/language/generics.html
> Jeff Chastain wrote:
> > I am trying to convert some Java code into ColdFusion and apparently
> my Java is a bit rusty. Can anybody explain the difference between
> the following two statements?
> >
> > public static IExpectationSetters expect(T value) {
> >
> > public static IExpectationSetters expectLastCall() {
> >
> > Specifically, I am trying to figure out what represents.
>
> I've never seen actual java code like that in my life.
>
> It looks more like tagged documentation of java code, and the just
>
> represents the tag for the data type, which in this case is
> "IExpectationSetters"
>
Rick
~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264326
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF-Moodle- Elearning Project
We've written some tools in CF that integrate with our Sakai deployment - see http://www.sakaiproject.org for info. Here is some ancient documentation I put up about some of the CF-Sakai integration options (webservices work great because both systems are using Apache AXIS) http://bugs.sakaiproject.org/confluence/display/ARCHIVE/Coldfusion Dave Ross http://www.coldspringframework.org >CF-Gurus, > >I have to opportunity to design an eLearning application and I am >considering weather to build using CF from the ground up! > >Question: Is any one open to work on a project of the nature? > >I have looked at moodle (moodle.org) as an alternate solution since I am >still in search of developers to undertake this development. > >I am hoping to get some suggestions on CF eLearning products that conform to >eLearning standards like SCORM or any other for that matter. > > >Aldon ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion and Maven
I use Maven on Java projects and it does make the build process a lot smoother. I've thought about using it for CF projects (especially for running unit tests during build), but I never took it further than just the idea. It would be cool if there was a maven repo for CF projects. Dave Ross http://www.coldspringframework.org > >We are interested in formalizing our deployment process from >development/staging/(pre-release)/production. I know Maven is really >popular for this in the Java world and was wondering if anyone had >experience using Maven to deploy ColdFusion applications. We have a lot >of ColdFusion and a good deal of Java library dependencies. I'd love to >hear from someone who has deployed a Maven implementation for >ColdFusion. > >Thanks, > >Leon ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Where can I download Coldspring for use in MG:U?
Sorry about the outage - we had a complete drive failure on the server last weekend and it took a few days to find a new home. http://www.coldspringframework.org should now be operational again. thanks, Dave >I'm back to trying to learn MG:U again and now I'm getting a different >error. So I've decided that instead of using the reactor and coldspring >installs from the MG:U zip, I'm going to download those two seperately. I've >got Reactor, but when I go to the Coldspring wbsite, it gives me a page not >found. Does anyone know where the new site is, or where I can grab the most >recent version of Coldspring? > > > >andy matthews >web developer >certified advanced coldfusion programmer >ICGLink, Inc. >[EMAIL PROTECTED] >615.370.1530 x737 >--//-> ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257605 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: passing arguments into a instantiated java object
>So I've instantiated my object like this... > > >and call the method like this... > > >How can I call a method on that Java object with named arguments? >From the caller perspective, Java doesn't have "named" arguments, they are >based on order. Thus: will work. Dave Ross http://www.coldspringframework.org ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251981 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion WS-Security (Digital Signature)
Don't write a wrapper until you're sure you need one. Grab the WSS4J here: http://ws.apache.org/wss4j/ Place the jar in CF's classpath. Then try to play with the api: http://ws.apache.org/wss4j/api.html Signing a document seems relatively straightforward. Dave Ross http://www.coldspringframework.org >Now I need to figure out how to do that. Has anyone done this before? > >>>help would be appreciated. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250650 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Arrays
>>Which ColdFusion version? >> >I have tested it on CFMX 7.0.1 and 7.0.2 All you need to know about CF(MX) arrays under the hood: http://java.sun.com/j2se/1.4.2/docs/api/java/util/Vector.html ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248981 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Limits on Blob Size in Datasource
I'm not sure if there's any limit on MSSQL/Oracle (I think CLOBS are capped at 2gb on MSSQL) - the bytes are actually stored on the filesystem just like a real file. This decision is all about tradeoffs - if your application deals with a lot of binary data, I would shy away from storing it in a database because frankly, filesystems are better at storing files. One of the main issues is getting consistent backups once the database becomes huge - when using a filesystem you can do incremental backups and it's a lot easier to restore individual files. I'd also want to save my JDBC traffic for real data, not just bytes of a file. So yes, if you store them on a filesystem you need shared storage for a cluster - but SATA NAS has become so cheap it's not as expensive as it used to be if you are lacking a SAN. Dave Ross http://www.coldspringframework.org >I've come up against a problem where I need to consider using SQL to >handle image storage. I know the positives and negatives of doing so >(File system might be a better choice, but SQL is easier to manage >across cluster nodes... etc etc.) > >I'm wondering, if I decide to do this, what are the possible downsides >from a server performance standpoint. I ask, because I assume that if >there was none, then the "Enable binary large object retrieval (BLOB)" >setting would be defaulted to TRUE instead of FALSE. > >Another way to do this would just to raise the Blob buffer size and >program in a limit to the application. > >Is there any common wisdom about this? Is there a preferred solution, >or has anyone had any nightmare experiences? > >Terrence Ryan >Senior Systems Programmer >Wharton Computing and Information Technology >E-mail: [EMAIL PROTECTED] ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248700 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RDS, Eclipse, CF5
been working fine against 6.1 for me Dave Ross http://www.coldspringframework.org >No RDS for eclipse requires CFMX7.02 and is clearly written this way on the >adobe website, and the labs site. > >Sorry for the bad news. > > >On 8/2/06, Mingo Hagen <[EMAIL PROTECTED]> wrote: >> ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248621 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Java 1.5 / 5 support.
Dave, I know I'm nitpicking - but since this bothers me on a weekly basis I thought I'd mention: in most cases LDAP-enabling an app does not constitute "single sign-on". I spend lots of time trying to explain the difference between a "federated logon" - e.g. using LDAP to authenticate users against a centralized directory, and "single sign-on", where users are separately authenticated by a centralized authority and apps never even so much as see a password (or present a login form). Web-based SSO like Yale's CAS or its commercial alternatives would be installed in a lot more places if people knew the how(s) + why(s). As a side note, those large enterprises will consider a platform that doesn't do federated logon or SSO if there's enough dog+pony shows to convince execs that you won't need it and maintaining "one more userbase" is lots of fun :) Dave Ross http://www.coldspringframework.org >> Does anyone use CFLDAP? Its one of those obscure things that >> 99% of people don't seem to use :-) > >The remaining 1% tend to be very large enterprises spending lots of money to >enable single sign-on functionality, and will not even consider a platform >for use if you can't talk to an LDAP server from it. I wouldn't be too >surprised if they purchase as many CF licenses as the other 99%. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246700 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldspring
Ok, I made a few changes in the site templates to make second-level pages display their navigation directly below the content. Hopefully that will make it easier to find everything! -Dave >It took me a few seconds to find it - navigation is traditionally on the left. > >On 7/11/06, Dave Ross <[EMAIL PROTECTED]> wrote: >> ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246086 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldspring
>Hmmm, I am sure when I went to the site, clicked the main nav for docs it >didn't take me to a doc site? H. Will need to look into this further! Maybe you didn't see the sub-navigation over on the right. This is the "Documentation" landing page: http://www.coldspringframework.org/index.cfm?objectid=B9D03AF1-EF2D-D8C3-3F3A7041016DE029 Let me know if you think people will go to this page and not think we have any documentation. thanks, Dave Ross http://www.coldspringframework.org ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246068 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldspring
>I have been reviewing Coldspring recently and to be honest - I don't get it >:-) even after reading all the necessary blog entries (NOT from the website >itself I may add, which is piss poor). Neil, Thanks for the excellent feedback. We'll make those improvements ASAP! Seriously, what exactly is "piss-poor" about our website? Are you unable to find what you are looking for? Are you specifically referring to the docs? > >What if, anything does it give me? What does it do which a good solid design >doesn't? I cannot find any solid examples which explain it all. > It gives you a way to implement your good solid design without introducing unneccessary coupling between your components. It doesn't generate your application model or really force anything upon you, but I would say it "suggests" that you to write better code because it makes you think of your CFCs as logical working entities that collaborate with other. Using ColdSpring will remove all the "create and configure" code from your system (because collaborating components are injected into one-another "ready to use"). ColdSpring then builds upon this foundation with a framework for aspect-oriented programming, extensions for remoting, and good integration with existing MVC front-end frameworks like Model-Glue and Mach-ii. Of course, as you mentioned, MG2 incorporates ColdSpring, and the inner-workings of the framework itself are actually wired together using ColdSpring (but that doesn't really matter to an end-user). As mentioned, Sean's presentation is a good starter, you can also pull my slides from CFUNITED here: http://www.d-ross.org/index.cfm?objectid=24CC1D9F-BD25-9A13-02D897961EE7EBEF HTH Dave Ross http://www.coldspringframework.org ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246023 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF and MYSQL 5
> >Well anyway, I guess it works thru odbc so I should move on to other problems. >lol! > Not in a production environment! I would use the JDBC-ODBC bridge only in dire circumstances - there is a lot of processing going on that would not be necessary with straight JDBC. So, a few questions: Are you sure you are running MySql on 3307 (you can confirm via. netstat on windows). The default MySql port is 3306 Have you granted rights to the database for your user, and can they connect from the host you are trying to connect from (even if you are connecting locally, the name of your computer will be the "host" in this case - easiest to just grant rights to user@'%')? If all else fails, you can download a generic SQL client (like SquirrelSql) to eliminate CF from the equation. I've had similar issues getting CF to connect to MSSQL locally over TCP/IP and each time it was related to the DBMS config. HTH, Dave Ross http://www.coldspringframework.org ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245475 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF crashing SQL 170K
It's a common problem to do pagination on the "client" (in this case CF)
instead of the database server - it's easier, but as your dataset grows it
becomes very performance intensive.
Pagination in MSSQL is diffucult because you don't have the flexible LIMIT
clause of MySql/Oracle. It's doable, just verbose. You basically do a
select top [endrow]
from (select top [startrow]
from table
order by [id] desc)
order by [id]
HTH,
Dave Ross
http://www.coldspringframework.org
> Hi all, I have a database with 170K records. What I'm doing is using
> CF to query this data with a blockfactor attribute.
>
> blockfactor="#arguments.maxRows#">
>
> I have my loop doing.
>
> endrow="#iif(not isDefined('form.goToPage') and url.startRow eq 1 or
> (isDefined('form.goToPage') and form.goToPage eq 1), de('#variables.
> maxRows#'), de('#(url.startRow+(variables.maxRows-1))#'))#">
>
> Now my query is in an application cached component.
>
> SQL in this case is on the same machine.
>
> What seems to be happening when it doesn't crash is that the
> connection from CF to the database (Driver?) is getting clogged up. CF
> returns the list immediatelly as soon as the data is retrieved.
>
> Does anyone have any ideas on how I can speed up the process? I have a
> feeling I need to do something in SQL but I don't know what to do. How
> come with the blockfactor it still seems to be trying to retrieve all
> the data?
>
>
> -
> Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great
> rates starting at 1¢/min.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245465
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: how to retrieve objectguid (LDAP) in a legible format
You'll probably have to use JLDAP for this - CFLDAP has many shortcomings that we've used JLDAP to work around. It's a very simple API and everything works from within CF. I've blogged a few of things we've done, so that should get you started: http://www.d-ross.org/index.cfm?objectid=9C65EEF0-508B-E116-6F30CA79F5BFDE07 http://www.d-ross.org/index.cfm?objectid=9C65EF0F-508B-E116-6F851C474448E08B http://www.d-ross.org/index.cfm?objectid=9C65ED79-508B-E116-6F81AF8F75FB40AD Terry Ryan used a lot of this work to create a CFC that you can use: http://www.numtopia.com/terry/code_java_ldap.cfm thanks, Dave Ross http://www.coldspringframework.org > Can anyone please explain how to get the objectguid binary attribute > from Active Directory using cfldap and store it in the database? > I need this so as to maintain a global unique id both in the AD and in > my database for the users. Thanks ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244807 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdSpring DTD (was: DW extensions for CF frameworks)
It's planned... right now you can use http://www.springframework.org/dtd/spring-beans.dtd not everything is implemented from J2EE spring (obviously), and we support a name="" attribute on , so we will have to make our own DTD soon. thanks, Dave Ross http://www.coldspringframework.org >I assembled Dreamweaver's tag libraries for: Model-Glue, Mach II and >Fusebox. They are all available under the Dreamweaver > ColdFusion section >of my website. > >Direct links: >http://www.massimocorner.com/dreamweaver/coldfusion/model-glue.mxp >http://www.massimocorner.com/dreamweaver/coldfusion/mach_ii.mxp >http://www.massimocorner.com/dreamweaver/coldfusion/fusebox.mxp > >Hope they could help > > >BTW Do anybody know if a DTD/Schema for ColdSpring is available or, at >least, planned? > > >Massimo Foti >Tools for ColdFusion and Dreamweaver developers: >http://www.massimocorner.com > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244431 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Where does everyone blog?
I think I'm still the only one using FarCry (an open-source ColdFusion CMS) as a blogging platform. FarCry's out-of-the-box "news" content type is perfectly suited to this - I just had to add the commenting mechanism, which took about an hour. I think it's cool because it allows me to build out a site in addition to having a blog. We are using FarCry for the ColdSpring site as well. http://www.d-ross.org Dave Ross http://www.coldspringframework.org > I know this comes up in the list every once in a while, but the search > isn't giving me really great results. > > What I want to know is where everone blogs at. Do most of you blog on > your own site, or use a centralized site to blog. > > I'm thinking of starting up a blog and I want to know where everyone > else is at. For now, my blog will be mostly CF related. > > PS - I'm not looking for blog software, just where everyone else is > blogging. > Steve ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244022 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF install on Win2003 dying on me
> I am firing up a new Windows 2003 server (win2k3 Standard) to replace > my existing win2k box. As a part of that I am doing what should be a > routine install of coldfusion-61-win.exe > > I start the installer, it runs for perhaps five seconds and then > closes without a peep. Keeping the task Manager open while this > happens shows the process opening and then exiting memory as well. > > I have the firewall shut clean off. IIS is installed and running. Has > anyone seen anything like this before? Am I missing something stupid? This happened to me, and when I rebooted the box I got the error message I should have gotten when it happened - basically the Data Execution Prevention in the OS was preventing the self-extractor from running. Go here: My Computer - Properties - Advanced - Performance Settings - Data Execution Prevention And add the CF installer to the exception list. Or reboot - and the dialog should ask if you want to do this. I could be wrong, but this is what it sounds like. thanks, Dave Ross http://www.coldspringframework.org ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243576 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF install on Win2003 dying on me
> I am firing up a new Windows 2003 server (win2k3 Standard) to replace > my existing win2k box. As a part of that I am doing what should be a > routine install of coldfusion-61-win.exe > > I start the installer, it runs for perhaps five seconds and then > closes without a peep. Keeping the task Manager open while this > happens shows the process opening and then exiting memory as well. > > I have the firewall shut clean off. IIS is installed and running. Has > anyone seen anything like this before? Am I missing something stupid? This happened to me, and when I rebooted the box I got the error message I should have gotten when it happened - basically the Data Execution Prevention in the OS was preventing the self-extractor from running. Go here: My Computer - Properties - Advanced - Performance Settings - Data Execution Prevention And add the CF installer to the exception list. Or reboot - and the dialog should ask if you want to do this. I could be wrong, but this is what it sounds like. thanks, Dave Ross http://www.coldspringframework.org ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243575 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Load testing tools
Why do you want it to be CF-based? (load-testing is a really a client-side activity) Anyways, check out Microsoft's Web Stress Tool or JMeter - both free tools that are widely used. Dave Ross http://www.coldspringframework.org >Hey all, > >What are some recommendations for CF-based server load testing tools, if any >exist? This is the first time I've needed to do any load testing so I'm >looking for something easy to implement, and that could simulate different >amounts of load. Our current site averages about 1.7 requests per second so >I'd like to be able to simulate that amount of load if possible, and have it >request a variety of pages on the site. > >-- Josh ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243551 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfopen?
I used to host ColdSpring on cfopen.org but I couldn't get the mailing lists to work, and there was absolutely NO contact info anywhere on the site. So after struggling for a while, I decided to build my own site and use some existing infrastructure I had kicking around. What would be really neat would be a shared open-source CF community server that used JIRA, Confluence, FishEye, and Subversion. Have you seen Apache's shared JIRA - it's impressive: http://issues.apache.org/jira Anyways, cfopen's problem (from my perspective) is lack of visible control/involvement from whoever set it up. Dave Ross http://www.coldspringframework.org > On Thursday 08 June 2006 19:22, Rick Root wrote: > > I think a lot of other "open source" people in the CF community out > > there would just as happily upload a zip file to their own web site... > > > Indeed. > It's only if your building something as huge as Reactor or ColdSpring > that you > can't just do what Ray does and upload a .zip to your blog, and take > bug > reports over email. > > -- > Tom Chiverton > > > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in > England and Wales under registered number OC307980 whose registered > office address is at St James's Court Brown Street Manchester M2 2JF. > A list of members is available for inspection at the registered office. > Any reference to a partner in relation to Halliwells LLP means a > member of Halliwells LLP. Regulated by the Law Society. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above > and may be confidential or legally privileged. If you are not the > addressee you must not read it and must not use any information > contained in nor copy it nor inform any person other than Halliwells > LLP or the addressee of its existence or contents. If you have > received this email in error please delete it and notify Halliwells > LLP IT Department on 0870 365 8008. > > For more information about Halliwells LLP visit www.halliwells.com. > > We are pleased to announce that Halliwells LLP has been voted AIM > Lawyer of the Year at the 2005 Growth Company Awards ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243114 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Working with user accounts in Active Directory
yes, it's called JLDAP - search my blog (http://www.d-ross.org) for some articles I wrote about leveraging from CF. Dave Ross http://www.coldspringframework.org >Ya I've queried for the usual properties (name, email, etc...). But >wondering if it's even possible to get at the password expiration. > >I wonder if there's a java class I could leverage. > >thx > > >Ian Skinner wrote: >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242990 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cflogin and load balancing
Win2k3 will do sticky sessions when clustered using NLB -Dave >A hardware load balancer that provides for sticky sessions will work, >if you can afford it. > >On 3/23/06, wolf2k5 <[EMAIL PROTECTED]> wrote: > >-- >CFAJAX docs and other useful articles: >http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241383 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MaxHeapSize + MaxPermSize
Dante, I'm pretty sure that MaxPermSize is actually *part* of the heap size - it's just a cap on the permanent generation space in the heap (as the name suggests). Regardless, for CF on Windows (assuming the box has more than 2gb of ram), I would keep Xmx=1024m and -XX:MaxPermSize=192m. Anything above that and I've found the 1.4.2 JVM to get unstable. Dave Ross http://www.coldspringframework.org >How large can the sum of the maximum heap size (-Xmx) and the maximum >permanent generation size (-XX:MaxPermSize) be for a JRun/CF process >on Windows? I'm aware of the 2GB limit for jvm processes on Windows, >but I would have thought that I could set max heap and max perm to any >combination as long as it was no bigger than 2GB (2048MB). Instead, >what I am finding is that CF will not start when (max heap + max perm) >is larger than 1.6GB, or 1640MB, to be precise. > >-dante ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241051 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Feed Aggregators
If you want something CF + web based (to run on your own) - we included a sample app with the ColdSpring distribution called "feedviewer" - it pretty much does what MXNA + Fullasagoog do. It's available within the 0.5.0 release on http://www.coldspringframework.org -Dave Ross >Slightly OT here, but I'm wondering a few things about feed aggregators that >you guys may be able to help me on. > >- What feed aggregators do you use, if any (either directly or via their >RSS)? >- Why do you use them? >- What don't they do which you'd like to see? >- If one of them was to potentially go open-source (I'll leave you to guess >which ;-), would there be any interest in the project? > >Cheers guys >-- >Neil Middleton > >Visit feed-squirrel.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240636 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Frameworks
I bet if you spent an afternoon working with the framework they expressed as a "requirement" it would be enough to say that you have "experience". I would also bet that what they really *don't* want is someone who's never heard of frameworks or doesn't understand the benefits. Regardless, I would tell them that in today's web-based application landscape, the web/controller framework you choose is hardly the biggest architectural concern. Mach-II/MG/FB make good controllers in an MVC app, but if you build a crap model or view all three will suck, and if you have any plans to do an Ajax/Flash/Flex front end they are pretty much irrelevant. -Dave Ross >My beef is with people who list it as a requirement. If you hire me to >maintain or enhance a site that is in fusebox3, I could maintain it in >fusebox3 - guaranteed - even though I have never used fusebox before in >my life. > >Now, I understand if you hire a short term contractor to do some >updates... say 20 hours or so of work, then yeah I get NEEDING someone >with fusebox experience. But not for a 3month or 6month contract. And >certainly not a full timer. > >Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240574 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF, OO, & Thread Safety
Rich, Exactly... each invocation of your DAO's read() would return a separate user instance, thus you wouldn't need to lock anything. thanks, Dave Ross http://www.d-ross.org http://www.coldspringframework.org >Dave, >I guess I did a bit too much snipping when I put my code in the email, >but I always var scope all variables. Next time I guess I'll just put >the full code in ;). > >You said that the only time I'd need a lock would be when I've got an >instance stored in shared scope. So considering that my user object in >this case is not stored in any shared scope, as long as I'm correctly >var'ing each query for the read / write operations, I won't have to >worry about any type of race conditions? > > >Rich Kroll >Application Developer > >|-Original Message- >|From: Dave Ross [mailto:[EMAIL PROTECTED] >|Sent: Saturday, April 29, 2006 10:42 PM >|To: CF-Talk >|Subject: Re: CF, OO, & Thread Safety >| >|Ouch, no!!! where/who told you to lock like that? You are making your >|application single-threaded by doing that! >| >|You need to var-scope the name of your query. This will make your DAO's >|read thread-safe without syncronizing the calls (making it single >|threaded). The ironic thing is that the read() method you posted ISN'T >|actually thread-safe, because you didn't local var scope the "user" >|variable, thus it becomes an instance variable of the DAO and then >could be >|overwritten by another request before your method gets a chance to >return >|it. Here's an example of thread-safe code: >| >|returntype="user"> >| >| >| >| >| >| -- query user >| >| >| >| >| >| >| >| >| >|So, no, you don't need to lock anywhere. The only reason to use a lock >is >|when you have a CFC instance stored in a shared scope (e.g. application >|scope) and that CFC has properties (aka members aka instance data) >which >|you need to read and write after the object has been created. You'd >need to >|syncronize the access to those properties and thus you would use a >named >|lock for the writes. This usually isn't the case with shared-scope >objects >|like gateways, DAOs, services, etc because their methods don't modify >|instance data, thus you hardly ever need locking in an OO CFC app. >| >|Also, I'm not sure why your "gateway" would be calling a DAO. While >it's >|just naming, it would confuse me if I was looking at your code. >Gateways >|provide aggregated access to data (e.g., they return queries or similar >|datasets), while DAOs provide persistance methods (CRUD) for individual >|objects. >| >|Hope that helps... >| >|Dave Ross >|http://www.d-ross.org >|http://www.coldspringframework.org ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239152 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF, OO, & Thread Safety
Ouch, no!!! where/who told you to lock like that? You are making your application single-threaded by doing that! You need to var-scope the name of your query. This will make your DAO's read thread-safe without syncronizing the calls (making it single threaded). The ironic thing is that the read() method you posted ISN'T actually thread-safe, because you didn't local var scope the "user" variable, thus it becomes an instance variable of the DAO and then could be overwritten by another request before your method gets a chance to return it. Here's an example of thread-safe code: -- query user So, no, you don't need to lock anywhere. The only reason to use a lock is when you have a CFC instance stored in a shared scope (e.g. application scope) and that CFC has properties (aka members aka instance data) which you need to read and write after the object has been created. You'd need to syncronize the access to those properties and thus you would use a named lock for the writes. This usually isn't the case with shared-scope objects like gateways, DAOs, services, etc because their methods don't modify instance data, thus you hardly ever need locking in an OO CFC app. Also, I'm not sure why your "gateway" would be calling a DAO. While it's just naming, it would confuse me if I was looking at your code. Gateways provide aggregated access to data (e.g., they return queries or similar datasets), while DAOs provide persistance methods (CRUD) for individual objects. Hope that helps... Dave Ross http://www.d-ross.org http://www.coldspringframework.org >Hello all, >I have a question about thread safety and some objects I'm developing. >Lets say for example that I've got 3 objects: user.cfc, userDAO.cfc, >userGateway.cfc. My user.cfc acts as a bean, only populated with data >from my userDAO object. The DAO object has basic querys to the db based >on a user_id. It has code something like this: > >returntype="user"> > > > > > > -- query user > > > > > "user").init(data)> > > > > > > > > >The gateway object has code similar to the following: > > > > > > > >If I put the gateway object into the application scope, I know that I'll >have to lock the query to get the user data from the userDAO, but is >there going to be any issues with thread safety from the userGateway >object when calling the getUser function? > >Rich Kroll >Application Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239124 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Storing Documents
I'd build the system to be able to store binary content in either the database OR a filesystem. Conceptually it's no different, and it allows more deployment flexibility. It really depends on the *amount* of binary data your system intends to store. While it's nice to have all data packaged in one place, if you plan on scaling to terabytes of files, you'd be crazy to physically store them in the database itself. The filesystem locations and paths should be private to your application, meaning you treat the filesystem as an extension to the database (and thus NO ONE EVER touches the filesystem where the content resides). -Dave Ross >I have never stored actual documents in SQL Server. I have stored the name >and location and put the document into a directory on the file server. >However, a new "contracts" application I am working on is very document >heavy, mainly for storage... not much retrieval will be done. > >Currently when a new contract comes to be, a directory is created for the >contract and a slew of sub directories are also created over the life of the >contract. Sometimes the sub directories are standard across contracts and >some times they are not. Sub directories can get pretty deep in terms of >nesting. > >It seems it would be much easier (conceptually) to store the documents >directly in the database and let the structure of the database dictate the >"hierarchy" and relationships instead of creating a new directory for each >contract and trying to figure out which subdirectories are needed or already >exist, etc. > >When needed, the documents would be accessed via the application... however >this would restrict direct access to the document outside the system. >Anyway, has anyone taken the approach of storing documents directly in a SQL >DB, and if so, how was performance etc... > >Thanks! > >Tango ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231985 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Nested Set Model
we hit similar issues with nested sets... the costs of inserts, moves and deletes became too great. We use a pushdown-stack (which mimics recursion) stored proc in MSSQL and it's pretty snappy depending on the number of nodes selected (actually more important is how deep the nodes are). In general I'm a fan of adjacency list over nested sets. I think the nested set model can quickly get out wack as systems grow. The *wow* factor of pulling any branch with a simple query quickly wears off. Either way, it's important to look at the hierarchical problem you are trying to solve rather than blindly choosing one approach over the other. -Dave Ross >If data isn't changing too frequently, aggressive caching can pretty >much >negate the cost of the adjacency list, but again, that's not >applicable in all situations either. > >Yeah, we used to have a lot of static data which accounted for a lot of >our database hits every page load (like security). We started caching >the whole query in the application scope and pulling out what we needed >with a q of q. That took about as long to retrieve the data, but the >database was freed up a whole lot in the process. > >~Brad ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230876 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion 7 on Tomcat
Neil, As I mentioned offlist, if your sole motivation for fronting Tomcat w/ Apache is performance, Tomcat now has the ability to use the native Apache libraries instead of the pure Java http connectors. All you have to do is place the APR (Apache Portable Runtime) somewhere in your system's path and Tomcat will use it. See here: http://tomcat.apache.org/tomcat-5.5-doc/apr.html -Dave >Well, think I have sorted it.as dave noted to me, I installed Java 1.4.2 >and the Tomcat compatibility kit and it all works AOK - on Tomcat.. > >Next step is to get Apache HTTP and Tomcat talkinganyone have any >success with that? > >N > > > > > >-Original Message- >From: Robertson-Ravo, Neil (RX) >[mailto:[EMAIL PROTECTED] >Sent: 16 January 2006 14:47 >To: CF-Talk >Subject: RE: ColdFusion 7 on Tomcat > >Log all fineno idea what the next step is here... > > > >-Original Message- >From: Dave Ross [mailto:[EMAIL PROTECTED] >Sent: 16 January 2006 12:25 >To: CF-Talk >Subject: Re: ColdFusion 7 on Tomcat > >What's in the logs? (tomcat/logs/stdout.log if you are on windows). I've >deployed CF7 on Tomcat no problem... it's pretty straightforward. > >-Dave > >>Hi All, >> >>I am having problems with CF7 on Tomcat 5.5.12. I have followed the >install >>instructions outlined here >>http://www.macromedia.com/support/coldfusion/j2ee/cfmx7j2ee_tomcat_deploy.h >t >the >>intended recipient(s). If you are not the intended recipient(s) please >note >>that any form of distribution, copying or use of this communication or the >>information in it is strictly prohibited and may be unlawful. If you have >>received this communication in error please return it to the sender or call >>our switchboard on +44 (0) 20 89107910. The opinions expressed within this >>communication are not necessarily those expressed by Reed Exhibitions. >>Visit our website at http://www.reedexpo.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229691 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion 7 on Tomcat
What's in the logs? (tomcat/logs/stdout.log if you are on windows). I've deployed CF7 on Tomcat no problem... it's pretty straightforward. -Dave >Hi All, > >I am having problems with CF7 on Tomcat 5.5.12. I have followed the install >instructions outlined here >http://www.macromedia.com/support/coldfusion/j2ee/cfmx7j2ee_tomcat_deploy.ht >ml > >But when I try to browse to >http://127.0.0.1:8080/cfusion/CFIDE/administrator/ I get Page Cannot be >Displayed. > >Anyone else got Tomcat up and running with CF7? Anything I have missed or >should be looking it? > >TIA > >Neil > > > >This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, >Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, >Registered in England, Number 678540. It contains information which is >confidential and may also be privileged. It is for the exclusive use of the >intended recipient(s). If you are not the intended recipient(s) please note >that any form of distribution, copying or use of this communication or the >information in it is strictly prohibited and may be unlawful. If you have >received this communication in error please return it to the sender or call >our switchboard on +44 (0) 20 89107910. The opinions expressed within this >communication are not necessarily those expressed by Reed Exhibitions. >Visit our website at http://www.reedexpo.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229660 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: reading/writing MS Word
I've used HWPF (part of POI) to extract content from word docs... I'm not sure how robust the library is for generating word docs though. I'm interested why you wer unable to gen large worksheets with POI though... I've had a few people tell me they gen sheets in excess of 100k rows with MX + POI. You may have a mem leak in your code... -Dave Ross > I have been asked to repair an old CF application that relies on rtf > templates to generate Word docs on the fly. The document flow is > something like this. A person creates a Word doc and manually inserts > a bunch of CF variables in the document, e.g. #f18#. Another person > takes that document, saves it as rtf, and then copies the rtf source > into a CF template with cfcontent and cfoutput so that the template > spits out an rtf doc with the variables replaced with their values. > > This method used to work ok, apparently, but when the group upgraded > to Word 2002 (or so I am told), all kinds of funny stuff started > happening with the rtf formatting and pound signs around the CF > variables in the rtf source. > > I would like to replace the whole rtf thing with a function that reads > the Word document directly, replaces the CF variables, and spits out > an actual Word file. I have not had to deal with Word in a while and > was wondering if anyone favored a particular method of reading/writing > Word files. I was just poking around on the Apache Jakarta POI site > and that looks like a decent option. Anyone using that API? > > Thanks for any thoughts. > > Rob ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227935 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Formatted Excel
I've used HSSF (part of the Apache POI project) for several years to accomplish what you're looking for. I have a few posts about it found here: http://www.d-ross.org/index.cfm?objectid=9C65ED5A-508B-E116-6F4F7F38C6AE167C and more here: http://www.d-ross.org/index.cfm?objectid=9C65ECEC-508B-E116-6F8A9F878188D7CA -Dave >I've been dumping data from CF/SQL to Excel for years but >have never had to make it show up formatted in an >automated fashion. I did some searching in the archives >and didn't see anything great. Am I in for some serious >pain here? (By formatted I mean page headers, specified >fonts, rows of data, sub totals and stand alone data >pieces not related to the rows and maybe even print >areas.) > >Lee ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226352 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: interacting with java and return a ColdFusion query
yes, Mark's correct. You can populate a coldfusion.sql.QueryTable with a java.sql.ResultSet (passed into the constructor). I usually only resort to a java wrapper class when there's a specific reason that the java calls cannot be coded in CFML. Is that the case here? >I think you need to use the class "coldfusion.sql.QueryTable" to do what >you want. It's in either cfx.jar or cfusion.jar. > Mark > >-Original Message- >From: George Abraham [mailto:[EMAIL PROTECTED] >Sent: Friday, December 02, 2005 9:17 AM >To: CF-Talk >Subject: interacting with java and return a ColdFusion query > >All, >I am working with CFMX and a set of Java libraries. I need to code a >Java class that can serve as the liaison between CFMX and Java. This >class will interact with the Java libraries and return the information >to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to >stress that I am not making a Java CFX tag, I am just using >com.allaire.cfx.Query. However I looked through this site ( >http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2. >htm#1142286) >for the methods available for the Query interface and I don't see any >way to actually add a query or to name its columns. This is possible >only through the Request interface. How can I name a CF query and its >columns in a Java class and then return it to CFMX? > >Hope that makes sense! > >TIA, >George ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225959 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF7 and 64-bit CPUs
You mean "supports" as "officially supported", correct? I think this thread is more about "Is it possible to run CFMX on a 64-bit jvm". >> Is JRun the problem or is CF? You could try running CF7 in >> J2EE config on top of Tomcat (which does run on J2SE 5.0 in >> 64bit mode nicely), or any other app server for that matter. > >JRun supports the 1.5 JVM, but CFMX doesn't. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225670 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF7 and 64-bit CPUs
Try CF on Tomcat on a 1.5 64-bit jvm, I'm really interested to hear if it works. >I'm on digest, BTW... > >Both are the problem. > >As you mentioned, CF7 by default, comes with it's 1.4.2_05 32-bit version. >So if I install that alone, it will run on 32-bit. If I separately install >1.5 64-bit, and point CF to that java.home, it will not start, complaining >about jvm.dll. > >If I install Jrun first, then upgrade to U6 (which "supports" 1.5), then >point it to 1.5 64-bit, it complains the same message. > >I have also gone so far as to install U6 into my >server-embedded-whatever-you-call-it install of CF's runtime folder, which >is the Jrun folder. > >Nothing produces the desired effect. There is just an inconsistency with >Jrun (standalone or embedded) responding to the 64-bit version of jvm.dll. >Without either digging into Jrun or digging into the dll, I am quitting. > >NAT > > >Subject: CF7 and 64-bit CPUs >From: Dave Ross <[EMAIL PROTECTED]> >Date: Tue, 29 Nov 2005 13:13:48 -0400 >Thread: >http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=43 >495&forumid=4#225589 > >Is JRun the problem or is CF? You could try running CF7 in J2EE config on >top of Tomcat (which does run on J2SE 5.0 in 64bit mode nicely), or any >other app server for that matter. > >If you get it to work, please allocate over 2gb of RAM to the JVM so I can >be jealous. > >Thanks! > >-Dave > >> p.s. I should say that I know MM states that it won't work, and a lot >> of people say it won't work, but I'm interested if anyone is under the >> radar and does have it working. >> >NAT ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225667 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF7 and 64-bit CPUs
The problem is that he's trying to run it on a 64-bit 5.0 JVM. I was asking whether it was CF or JRun that was causing the issue, because you can run CF on most J2EE app servers. The default install of CF will use a 32bit 1.4.2 JVM even if installed on a 64-bit OS. -Dave >I'm so close to grasping this conversation... > >Does the original question mean that a default installation of CFMX 7.01 >will not run on Windows Server 64-bit? Or is the problem simply because he >is trying to run it w/ a pre-installed JRun install? > >Thanks... > >-----Original Message- >From: Dave Ross [mailto:[EMAIL PROTECTED] >Sent: Tuesday, November 29, 2005 10:14 AM >To: CF-Talk >Subject: Re: CF7 and 64-bit CPUs > >Is JRun the problem or is CF? You could try running CF7 in J2EE config on >top of Tomcat (which does run on J2SE 5.0 in 64bit mode nicely), or any >other app server for that matter. > >If you get it to work, please allocate over 2gb of RAM to the JVM so I can >be jealous. > >Thanks! > >-Dave > >> p.s. I should say that I know MM states that it won't work, and a lot >> of people say it won't work, but I'm interested if anyone is under the >> radar and does have it working. >> >NAT ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225608 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF7 and 64-bit CPUs
Is JRun the problem or is CF? You could try running CF7 in J2EE config on top of Tomcat (which does run on J2SE 5.0 in 64bit mode nicely), or any other app server for that matter. If you get it to work, please allocate over 2gb of RAM to the JVM so I can be jealous. Thanks! -Dave > p.s. I should say that I know MM states that it won't work, and a lot > of people say it won't work, but I'm interested if anyone is under the > radar and does have it working. > NAT ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225589 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Cfmx 7.1 on 2.3k locking up once a day
One thing I noticed in your thread dumps were some threads waiting on a UUID to be generated (the code in question is line 81 of D:\www\com\gf\ad\ad.cfc). Does this code get run once or more per request? Take a peek at jrpp-100 thru jrpp-107 in the thread dumps. -Dave >We just rolled out mx 7.1 on win 2.3k, Fusebox 4.1. It's a simple >application, just content management with 150-200k views a day. > >Without fail that mx server hangs in under 24 hours. Here is the evidence we >have found. > >I started app. Server at the command line: > >When I peep'd in while it was hung it was dumping out the following: > >java.lang.RuntimeException: Request timed out waiting for an available >thread to run. You may want to consider increasing the number of active >threads in the thread pool. > >This is repeated, again and again. > >NOTE: found some articles suggesting ideas on this, turn of debug (done), >make sure db is responding (appears to be). Adjust some of the jrun.xml >settings (appears to already be done in 7.1) > >Perf Mon. >went back to before the crash, the only thing odd is the data seems to miss >a beat nearing the crash and some data seems off the chart. But when we >examine logs we see no burst of traffic. I exported the perf. Mon data and >don't see any bursts. > >Did a stack dump while it was hung found a ton of these: > >"jrpp-108" prio=5 tid=0x04430d60 nid=0x1b08 in Object.wait() >[c4af000..c4afdb8] > at java.lang.Object.wait(Native Method) > - waiting on <0x172c0fa8> (a jrunx.scheduler.ThreadPool$Throttle) > at jrunx.scheduler.ThreadPool$Throttle.enter(ThreadPool.java:107) > - locked <0x172c0fa8> (a jrunx.scheduler.ThreadPool$Throttle) > at >jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:423 >) > at >jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26 >4) > at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) > > >Whole log: http://icc.getfused.com/out.txt > > >We have tried moving app. To a 2nd 7.1 and win 2.3k server.. Same issue. We >moved the db to another machine, same issue. No other sites using the db >seem to be having any issues. > >Anyone have any thoughts? Im about to toss in the towel and call adobe and >burn 500.00 clams. Any help would be apprecaited, if it saves me the 500.00 >then a shopping spree at Amazon could be in your future. > >Thanks > >gabe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225527 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
