RE: Am I off base ?
In an ideal world there would be documentation... But I've yet to see that ideal world. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 10, 2006 2:02 PM To: CF-Talk Subject: Am I off base ? What's your opinion on this? Our Web hosting company built a few custom cf application for this company before I came on board. The Webhosting company developed these applications within a multi-application framework and not self contained application. I've done mostly MVC and Fusbox and I'm getting up to speed on ModelGlue, Cold Spring, etc. I asked the hosting company if they had any documentation. Not of the methodology, but just something that would layout some structure to their framework. Without any guidance, it will be an additional challenge to follow their application framework flow/process. They said they don't have any documentation, yet ehy've given me full acess to all the Cf code and the related tables. Shouldn't they provide some basic roadmap? It's been my experience that any good development team would have some documentation on large projects they create. Isn't it good development practice to leaves clues for developers replacing original coders or developers that want to scale an existing application? My thoughts are they're trying to protect their potential future revenue stream from the company. Granted, I'm not a seasoned CF-OO developer yet, but shouldn't they have discussed the this in more detail? Thanks D ~| 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:256158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Headers and Footers
You can even get really fancy and "extend" your application.cfc in each sub-folder to include slightly different headers / footers based upon where in the site the user is. We did that and it works awesome. -Original Message- From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 03, 2006 2:49 PM To: CF-Talk Subject: Re: Headers and Footers If you use Application.cfc, you can use the onRequest method to intercept your page loads. After the page has been intercepted, include your head, body and footer. Your header and footer would not be centralized and can recieve conditional logic if needs be. Teddy On 10/3/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I've seen developers wrap headers in footer in many different ways. > Some basic ideas just use includes, I've also seen custom tags that > take attributes and effect the way a page is displayed. > > I'm looking for any ideas that would allow me to centrally manage > header and footer content and still be able to use DreamWeaverMX2004 > to make some quick table/css adjustments. > > Any throughts or prebuilt solutions successfully used from Adobe Exchange? > > Thanks. > > D > > ~| 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:255248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Paired Custom Tags
This is exactly what I needed. I just didn't get that part of it. Thanks for the help. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 26, 2006 5:22 PM To: CF-Talk Subject: RE: Paired Custom Tags > I have created a tag with a start and stop which I think is pretty > good. When you call it it does generate an email like you'd expect, > but the content of the mail tag also displays on the screen which is a > little less than ideal. In the end execution mode section of your custom tag, after you've processed ThisTag.GeneratedContent, set ThisTag.GeneratedContent to an empty string. This is covered in some detail in the official Adobe Advanced CF Development course, for what that's worth. 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 and 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/groups/CF-Talk/message.cfm/messageid:254383 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Paired Custom Tags
Can anyone point me at a good resource for learning about writing a Paired
custom tag? I'm having a little trouble with the one I started on
yesterday.
Basically what we're trying to do is "overload" the cfmail tag so that we
can make it work differently on different servers.
I have created a tag with a start and stop which I think is pretty good.
When you call it it does generate an email like you'd expect, but the
content of the mail tag also displays on the screen which is a little less
than ideal. If anyone's got some pointers on how to get this working right
I'd appreciate it. I think it will work out pretty nice once I get over
this learning hump.
Jennifer Dodson.
---
Here's how I'm calling it:
Just wanted to see if this worked or not.
#CGI.PATH_INFO#
#DateFormat(Now(),"mm/dd/")#
And here's the code I'm using (keep in mind this is just the rough starting
point).
#ThisTag.GeneratedContent#
#ThisTag.GeneratedContent#
Jennifer Dodson
Sr. Development Analyst
Pioneer Services
4700 Belleview Suite 300
Kansas City, MO 64112
Phone 816-448-2391
Fax 816-756-0942
[EMAIL PROTECTED]
PIONEER SERVICES is a brand name and registered service mark of Pioneer
Licensing Services, Inc., where its use is duly licensed to affiliates and
partners of Pioneer Licensing Services, Inc.
Confidentiality Notice: The information contained in this e-mail transmission,
including any attachments, is confidential information, proprietary to the
sender and legally protected. Its purpose is intended for the sole use of the
individual(s) or entity named in the message header. If you are not the
intended recipient, you are hereby notified that any dissemination, copying or
taking any action in reliance on the contents of this information is strictly
prohibited. If you received this message in error, please notify the sender of
the error and delete this message and any attachments.
~|
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:254315
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Oracle JDBC Drivers vs. CF Oracle Drivers
If you use stored procs at all you're going to want to use the drivers that come with CFMX. The ones that come with Oracle won't let you process result sets, and they also have issues with varchar2 return types. I tried using the drivers that come with Oracle with CFMX professional and we actually upgraded to Enterprise just to get the Oracle drivers because we had so many issues with the JDBC drivers. -Original Message- From: Dave Hatz [mailto:[EMAIL PROTECTED] Sent: Thursday, September 21, 2006 5:46 PM To: CF-Talk Subject: Oracle JDBC Drivers vs. CF Oracle Drivers We are setting up a new box with CFMX 7.0.2, running on Windows 2003 Web Server Edition with IIS6. We have an Oracle 9i Database running on a W2K server. I am curious to the pros/cons of using Oracle Drivers that come with CFMX7 or use the Oracle JDBC drivers from Oracle? I am looking for performance issues only. Which is faster? Thanks, Dave Hatz ~| 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:253889 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Jsessionid causing 404s. Please help
Of course now my 404 page is not properly picking it up when the page doesn't exist. That's actually worse than the other problem was. -Original Message----- From: Jennifer Dodson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:42 PM To: CF-Talk Subject: RE: Jsessionid causing 404s. Please help I figured it out. I had the mapping in IIS set up to "verify that file exists". When I unchecked that box and restarted IIS it all started working OK. I guess that IIS was trying to find the file before it even let the Isapi filter have a shot at it. -Original Message- From: Steven Erat [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:06 PM To: CF-Talk Subject: RE: Jsessionid causing 404s. Please help Can you turn on connector logging in wsconfig's jrun.ini, restart IIS, and check the log for the extension to see if it got that far? The JRun connector will either report a match or no match when it examines the suffix. If you don't see the extension with jsessionid in the connector log at all then the connector was never even handed the request. Do you see the 404 in IIS's log instead? > -Original Message- > From: Jennifer Dodson [mailto:[EMAIL PROTECTED] > Sent: Monday, September 18, 2006 3:50 PM > To: CF-Talk > Subject: RE: Jsessionid causing 404s. Please help > > I guess I should have been more specific. It doesn't work with .cfm > or .jsp extensions either. Also, I do have the .do extension in the > web.xml. The ..do extension is working great, except when someone > bookmarked it with a > ;jsessionid on the end of it. It's basically like the > ignoresuffixmap is > just not being recognized which makes me think I got it into the wrong > file or something. > > Jennifer Dodson ~| 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:253457 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Jsessionid causing 404s. Please help
I figured it out. I had the mapping in IIS set up to "verify that file exists". When I unchecked that box and restarted IIS it all started working OK. I guess that IIS was trying to find the file before it even let the Isapi filter have a shot at it. -Original Message- From: Steven Erat [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:06 PM To: CF-Talk Subject: RE: Jsessionid causing 404s. Please help Can you turn on connector logging in wsconfig's jrun.ini, restart IIS, and check the log for the extension to see if it got that far? The JRun connector will either report a match or no match when it examines the suffix. If you don't see the extension with jsessionid in the connector log at all then the connector was never even handed the request. Do you see the 404 in IIS's log instead? > -Original Message- > From: Jennifer Dodson [mailto:[EMAIL PROTECTED] > Sent: Monday, September 18, 2006 3:50 PM > To: CF-Talk > Subject: RE: Jsessionid causing 404s. Please help > > I guess I should have been more specific. It doesn't work with .cfm > or .jsp extensions either. Also, I do have the .do extension in the > web.xml. The ..do extension is working great, except when someone > bookmarked it with a > ;jsessionid on the end of it. It's basically like the > ignoresuffixmap is > just not being recognized which makes me think I got it into the wrong > file or something. > > Jennifer Dodson ~| 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:253456 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Jsessionid causing 404s. Please help
I guess I should have been more specific. It doesn't work with .cfm or .jsp extensions either. Also, I do have the .do extension in the web.xml. The ..do extension is working great, except when someone bookmarked it with a ;jsessionid on the end of it. It's basically like the ignoresuffixmap is just not being recognized which makes me think I got it into the wrong file or something. Jennifer Dodson -Original Message- From: Steven Erat [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 2:39 PM To: CF-Talk Subject: RE: Jsessionid causing 404s. Please help You mention that you do some forwarding of .do to ColdFusion. The technote describes how to solve the problem when using default page extensions for ColdFusion/JRun servers, i.e. .cfm, .cfc, .jsp. When ignoresuffixmap is false, the JRun connector gets to take a look at the extension to look for an extension match before IIS does. If the .do extension (URL Pattern) is not mapped to a servlet in ColdFusion's web.xml, then the JRun connector will not make a match, and then IIS will inspect it unless some other connector makes a match. If .do gets all the way to letting IIS do the match, the jsessionid will confuse it. -Steven Erat > -Original Message- > From: Jennifer Dodson [mailto:[EMAIL PROTECTED] > Sent: Monday, September 18, 2006 3:29 PM > To: CF-Talk > Subject: Jsessionid causing 404s. Please help > > We just rolled out our new improved site on ColdFusion (rather than > the nasty java mess that we had before) and everything is going great > except for one small problem. To try and prevent issues with old URLs > I set up some redirectors with the old .do extensions. Unfortunately > what we're finding is that there are a lot of people who had > bookmarked urls that look like > http://www.pioneermilitaryloans.com/PMLcom/homepage.do;jsessio > nid=XX&que > ryString . I had hoped that these would work just fine, but instead > they're generating 404 errors. I found a tech note that talkes about > J2EE Session URL Identifies causes a 404 error when using IIS and have > tried to follow the instructions in that, but it didn't work. > > The technote says to modify the > cf_root/runtime/lib/wsconfig/1/jrun.ini > file. We don't have one of those. We have a > cf_root/runtime/lib/wsconfig/1/jrun_iis6_wildcard.ini file which I did > modify to include the "ignoresuffixmap" property. It didn't make any > difference at all even after I restarted IIS and ColdFusion both. Can > someone point me in the right direction for this. Those 404s are > really driving me nuts. > > We're running CFMX 7.0.2 Enterprise on IIS 6 > > Thanks, > > Jennifer Dodson ~| 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:253445 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Jsessionid causing 404s. Please help
We just rolled out our new improved site on ColdFusion (rather than the nasty java mess that we had before) and everything is going great except for one small problem. To try and prevent issues with old URLs I set up some redirectors with the old .do extensions. Unfortunately what we're finding is that there are a lot of people who had bookmarked urls that look like http://www.pioneermilitaryloans.com/PMLcom/homepage.do;jsessionid=XX&que ryString . I had hoped that these would work just fine, but instead they're generating 404 errors. I found a tech note that talkes about J2EE Session URL Identifies causes a 404 error when using IIS and have tried to follow the instructions in that, but it didn't work. The technote says to modify the cf_root/runtime/lib/wsconfig/1/jrun.ini file. We don't have one of those. We have a cf_root/runtime/lib/wsconfig/1/jrun_iis6_wildcard.ini file which I did modify to include the "ignoresuffixmap" property. It didn't make any difference at all even after I restarted IIS and ColdFusion both. Can someone point me in the right direction for this. Those 404s are really driving me nuts. We're running CFMX 7.0.2 Enterprise on IIS 6 Thanks, Jennifer Dodson Sr. Development Analyst Pioneer Services 4700 Belleview Suite 300 Kansas City, MO 64112 Phone 816-448-2391 Fax 816-756-0942 [EMAIL PROTECTED] PIONEER SERVICES is a brand name and registered service mark of Pioneer Licensing Services, Inc., where its use is duly licensed to affiliates and partners of Pioneer Licensing Services, Inc. Confidentiality Notice: The information contained in this e-mail transmission, including any attachments, is confidential information, proprietary to the sender and legally protected. Its purpose is intended for the sole use of the individual(s) or entity named in the message header. If you are not the intended recipient, you are hereby notified that any dissemination, copying or taking any action in reliance on the contents of this information is strictly prohibited. If you received this message in error, please notify the sender of the error and delete this message and any attachments. ~| 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:253441 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Could not generate stub objects for web service invocation
Definitely sounds like permissions. I had that error on a Windows box because I had NT Authentication enabled, obviously the Web service call didn't pass the credentials. I'm not sure what the equivalent of NT authentication is on Unix, but if it's not set so that everyone can read it that's probably part of your problem. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Friday, July 07, 2006 12:31 PM To: CF-Talk Subject: RE: Could not generate stub objects for web service invocation Do u have security sandboxing enabled. If so you may need to allow that port in the sandbox. You should also make sure there is no firewall blocking that port either. - snake -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: 07 July 2006 18:11 To: CF-Talk Subject: Could not generate stub objects for web service invocation repost due to error: I am having a hard time invoking the ws below in a Unix/CF7/Apache 2.0 environment. I can query the WSDL and it works successful in a windows dev environ. However when going to UNIX it is unsuccessful. I am thinking that it is a permissions issue or something. Further more I cannot even register other Webservices in the CF admin ( eg bable fish) Why? Has anyone come up with a solution? Thanks in advance for any help. My PAGE http://120.252.201.51:8200/test.cfc?wsdl"; method="getXML" returnvariable="foo"> #foo# MY WS: #XMLInput# ~| 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:245767 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DataDirect drivers and CFMX Standard
That is an option. We thought it was better to try out the drivers from Data Direct since we're more likely to buy the drivers than to buy Enterprise, but since they're not working maybe trying Enterprise is a good option. Can anyone tell me what it costs to upgrade from Standard to Enterprise? -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 22, 2006 5:31 PM To: CF-Talk Subject: Re: DataDirect drivers and CFMX Standard If you just wanted to try out the drivers and see if they solve your problem, perhaps you can install the CF7 Enterprise trial (on another machine or seperate J2EE instance) and try your app? Damon >The problem is I have CF Standard. So I can't use those. It is good >information to have though. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244601 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: DataDirect drivers and CFMX Standard
The problem is I have CF Standard. So I can't use those. It is good information to have though. -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 22, 2006 5:16 PM To: CF-Talk Subject: Re: DataDirect drivers and CFMX Standard >I did get them from DataDirect, Adobe won't give them to you. Hey guys, these are actually freely available (and properly "branded" as required by DataDirect so they'll work) for download for use with CF Enterprise here: (latest DD 3.4 build): http://www.adobe.com/go/1a3c2ad0 (latest DD 3.5 build) http://www.adobe.com/go/42dcb10a (latest 3.3 build) http://www.adobe.com/go/tn_18807 HTH Damon ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244587 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: DataDirect drivers and CFMX Standard
Yeah, Enterprise gives you lots of neat things.. Unfortunately we have no need for any of those things. We're a pretty small company and we don't run a heavy load, so the standard's fine for us. Except for the fact that we have to talk to the Oracle Enterprise Application that we bought. Why a company our size is running Oracle is often beyond me, we sure don't need the horsepower. -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 8:19 PM To: CF-Talk Subject: Re: DataDirect drivers and CFMX Standard Yes, that's why I originally suggested CF Enterprise as a workaround, because you get your money's worth that way. Enterprise gives you gateways, sandboxing, performance versions of cfmail and cfdocument, a full version of JRun on which you can deploy multiple instances of CF and Oracle drivers that work among other things. The Oracle Thin driver is a JDBC type 4 driver, so that's probably not going to help (http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#02 _01) On 6/22/06, Jennifer Dodson <[EMAIL PROTECTED]> wrote: > Thanks. That's not quite as bad as I was expecting actually. > > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 21, 2006 2:09 PM > To: CF-Talk > Subject: RE: DataDirect drivers and CFMX Standard > > > I'm trying to get a price quote on them and I think you're probably > > right that it's more cost efficient to buy Enterprise. > > They don't seem real eager to tell me the actual cost. > > ~4K$, last I checked. > > 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! > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244527 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: DataDirect drivers and CFMX Standard
Thanks. That's not quite as bad as I was expecting actually. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 2:09 PM To: CF-Talk Subject: RE: DataDirect drivers and CFMX Standard > I'm trying to get a price quote on them and I think you're probably > right that it's more cost efficient to buy Enterprise. > They don't seem real eager to tell me the actual cost. ~4K$, last I checked. 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! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244458 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: DataDirect drivers and CFMX Standard
No, I haven't tried the JDBC-OCI driver. The Thin client driver won't return ref-cursors as result sets, and I couldn't find any information on the JDBC driver. I will definitely look into it though. As to the DataDirect drivers I did get them from DataDirect, Adobe won't give them to you. I'm trying to get a price quote on them and I think you're probably right that it's more cost efficient to buy Enterprise. They don't seem real eager to tell me the actual cost. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 12:33 PM To: CF-Talk Subject: RE: DataDirect drivers and CFMX Standard > We're using the CF Standard version and trying to connect to an Oracle > Database (and actually use it in a meaningful way). > What we've discovered is this is pretty much down-right silly if you > want to use stored procs. Have you tried Oracle's own JDBC drivers? If I recall correctly, they have a type 4 JDBC driver and a JDBC-OCI driver. > In order to see if we can fix the problems I downloaded the DataDirect > drivers (which appear to be THE way to connect to Oracle). Drivers > are installed, I can test the connection using the tool that comes > wtih them, and you'd think everything would work... but NO, I get a > timeout error everytime I try to connect to my database. I'm assuming > that the problem is my connection string since it's obviously finding > the driver, but I can't figure it out. > > Has anyone else out there done this? I'm going to call Adobe in the > morning, but I thought maybe someone could just toss me the answer. > > Connection Information I'm using: > Driver Class: com.ddtek.jdbc.oracle.OracleDriver > URL: jdbc:datadirect:oracle://ASG2KDEVODB01:1521;ServiceName=DBKDEV1 > > CF Class Path: > c:/work/ColdFusion/drivers/lib/base.jar,c:/work/ColdFusion/dri > vers/lib/util.jar,c:/work/ColdFusion/drivers/lib/oracle.jar > > I had to configure it as a type "Other" since the Data Direct drivers > don't come wtih standard. Any help at all would be appreciated. Did you download the DataDirect drivers from Adobe, or from DataDirect? The Adobe version should not allow you to connect to Oracle from CF Standard - that's one of the big selling points for CF Enterprise, actually. If you get the drivers directly from DataDirect, they should work, but they're expensive enough that you'd be better off upgrading to CFMX Enterprise. 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! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:27 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: DataDirect drivers and CFMX Standard
Good thought, but no dice. -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 20, 2006 10:59 PM To: CF-Talk Subject: Re: DataDirect drivers and CFMX Standard Try SID instead of ServiceName (since that's what's in my neo-query.xml). On 6/21/06, Jennifer Dodson <[EMAIL PROTECTED]> wrote: > We're using the CF Standard version and trying to connect to an Oracle Database (and actually use it in a meaningful way). What we've discovered is this is pretty much down-right silly if you want to use stored procs. > > In order to see if we can fix the problems I downloaded the DataDirect drivers (which appear to be THE way to connect to Oracle). Drivers are installed, I can test the connection using the tool that comes wtih them, and you'd think everything would work... but NO, I get a timeout error everytime I try to connect to my database. I'm assuming that the problem is my connection string since it's obviously finding the driver, but I can't figure it out. > > Has anyone else out there done this? I'm going to call Adobe in the morning, but I thought maybe someone could just toss me the answer. > > Connection Information I'm using: > Driver Class: com.ddtek.jdbc.oracle.OracleDriver > URL: jdbc:datadirect:oracle://ASG2KDEVODB01:1521;ServiceName=DBKDEV1 > > CF Class Path: > c:/work/ColdFusion/drivers/lib/base.jar,c:/work/ColdFusion/drivers/lib > /util.jar,c:/work/ColdFusion/drivers/lib/oracle.jar > > I had to configure it as a type "Other" since the Data Direct drivers don't come wtih standard. Any help at all would be appreciated. > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244360 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: DataDirect drivers and CFMX Standard
We already tried the ODBC socket, it has a problem returning Varchar2 type output parameters. According to Adobe it's also a bad choice for heavy load applications since it has concurrency issues (that they don't put anywhere in the docs). In trying to fix the Varchar2 problem they've had me upgrade the ODBC version, downgrade the ODBC version, upgrade the client, downgrade the client, and jump through any other hoop they can find. End result this afternoon is that I can no longer use the ODBC socket to connect to Oracle at all... Regardless of if I want varchar2 output parameters or not. I figured time to give up and find a JDBC driver. -Original Message- From: Mark Mandel [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 20, 2006 10:54 PM To: CF-Talk Subject: Re: DataDirect drivers and CFMX Standard This is a post I made ges ago doing exactly this sorta thing: It may be slightly out of date, but it should push you in the right direction. http://www.compoundtheory.com/?action=displayPost&ID=15 There are a few comments at the bottom that also provide some ideas that I didn't cover. HTH Mark On 6/21/06, Jennifer Dodson <[EMAIL PROTECTED]> wrote: > We're using the CF Standard version and trying to connect to an Oracle Database (and actually use it in a meaningful way). What we've discovered is this is pretty much down-right silly if you want to use stored procs. > > In order to see if we can fix the problems I downloaded the DataDirect drivers (which appear to be THE way to connect to Oracle). Drivers are installed, I can test the connection using the tool that comes wtih them, and you'd think everything would work... but NO, I get a timeout error everytime I try to connect to my database. I'm assuming that the problem is my connection string since it's obviously finding the driver, but I can't figure it out. > > Has anyone else out there done this? I'm going to call Adobe in the morning, but I thought maybe someone could just toss me the answer. -- E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244357 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
DataDirect drivers and CFMX Standard
We're using the CF Standard version and trying to connect to an Oracle Database (and actually use it in a meaningful way). What we've discovered is this is pretty much down-right silly if you want to use stored procs. In order to see if we can fix the problems I downloaded the DataDirect drivers (which appear to be THE way to connect to Oracle). Drivers are installed, I can test the connection using the tool that comes wtih them, and you'd think everything would work... but NO, I get a timeout error everytime I try to connect to my database. I'm assuming that the problem is my connection string since it's obviously finding the driver, but I can't figure it out. Has anyone else out there done this? I'm going to call Adobe in the morning, but I thought maybe someone could just toss me the answer. Connection Information I'm using: Driver Class: com.ddtek.jdbc.oracle.OracleDriver URL: jdbc:datadirect:oracle://ASG2KDEVODB01:1521;ServiceName=DBKDEV1 CF Class Path: c:/work/ColdFusion/drivers/lib/base.jar,c:/work/ColdFusion/drivers/lib/util.jar,c:/work/ColdFusion/drivers/lib/oracle.jar I had to configure it as a type "Other" since the Data Direct drivers don't come wtih standard. Any help at all would be appreciated. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244354 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: Problems with Oracle Stored Procs and Varchar2 output parameters
Do you happen to know if we can just buy the drivers? -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 4:39 AM To: CF-Talk Subject: Re: Problems with Oracle Stored Procs and Varchar2 output parameters Ah, you need the DataDirect drivers that come with CF Enterprise for full Oracle functionality over JDBC. As for ODBC, sorry I can't help on that one. On 6/7/06, Jennifer Dodson <[EMAIL PROTECTED]> wrote: > We're using CF MX 7 with the jdbc driver from Oracle. When we tried > to use it we couldn't get the resultsets back in the curser output > parameters. We found several posts online stating the same problem. > All of them said to use the ODBC Socket connection to the Oracle ODBC > driver. It works great except for the problem with the varchar output types. > > I don't know what you mean when you ask about the updater version, but > if you tell me what it is I'd be glad to find out. > > -Original Message- > From: Tom Chiverton [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 07, 2006 2:59 AM > To: CF-Talk > Subject: Re: Problems with Oracle Stored Procs and Varchar2 output > parameters > > On Tuesday 06 June 2006 16:16, Jennifer Dodson wrote: > > We're using the ODBC Socket connection because the JDBC connection > > wouldn't let us get result sets back from Oracle. > > It won't ? Which version of CF ? What updater version ? > > -- > 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:242758 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: Problems with Oracle Stored Procs and Varchar2 output parameters
We're using CF MX 7 with the jdbc driver from Oracle. When we tried to use it we couldn't get the resultsets back in the curser output parameters. We found several posts online stating the same problem. All of them said to use the ODBC Socket connection to the Oracle ODBC driver. It works great except for the problem with the varchar output types. I don't know what you mean when you ask about the updater version, but if you tell me what it is I'd be glad to find out. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 2:59 AM To: CF-Talk Subject: Re: Problems with Oracle Stored Procs and Varchar2 output parameters On Tuesday 06 June 2006 16:16, Jennifer Dodson wrote: > We're using the ODBC Socket connection because the JDBC connection > wouldn't let us get result sets back from Oracle. It won't ? Which version of CF ? What updater version ? -- 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:242756 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
Problems with Oracle Stored Procs and Varchar2 output parameters
We're migrating a large quantity of CF 4.5 code to MX 7. It seemed like a good idea at the time, but we've hit a major hurdle. We have quite a few Oracle stored procs that have a VARCHAR2 output parameter. Everytime that parameter has a value we get the following error message: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Oracle][ODBC][Ora]ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "PFS.AFFILIATEMGMT", line 3421 ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 We're using the ODBC Socket connection because the JDBC connection wouldn't let us get result sets back from Oracle. Any help with this message would be very appreciated. I can provide sample procedure code if the problem seems to be on the Oracle side. Jennifer Dodson Programmer / Analyst Pioneer Services 4700 Belleview Suite 300 Kansas City, MO 64112 Phone 816-448-2391 Fax 816-756-0942 [EMAIL PROTECTED] PIONEER SERVICES is a brand name and registered service mark of Pioneer Licensing Services, Inc., where its use is duly licensed to affiliates and partners of Pioneer Licensing Services, Inc. Confidentiality Notice: The information contained in this e-mail transmission, including any attachments, is confidential information, proprietary to the sender and legally protected. Its purpose is intended for the sole use of the individual(s) or entity named in the message header. If you are not the intended recipient, you are hereby notified that any dissemination, copying or taking any action in reliance on the contents of this information is strictly prohibited. If you received this message in error, please notify the sender of the error and delete this message and any attachments. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242595 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
