Re: ColdFusion 5 and Stored Procedures Issue
Gentlepersons: A bump and a few additional data points. A call to cfusion_dbconnections_flush() seems to clear up the issue, except: a) Macromedia doesn't recommend flushing manually. b) because we have multiple SPs on one page, we'd need to flush after each one to avoid hitting the connection limit with multiple concurrent users. Still doesn't explain why ColdFusion is not automatically releasing the connections. We've tried unchecking Maintain Database Connections and have set the Connection Timeout very low, but neither seems to help as much as not using Stored Procedures at all. I'll also note that most of our Stored Procedures select record sets and return them through REFCURSORS. Many of them return only a few rows ( 10). Thanks in advance for your time. ~| 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:197994 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
ColdFusion 5 and Stored Procedures Issue
Greetings, CF-Talkers. We've recently been migrating a lot of our SQL code to our Oracle 8.1.7 database in the form of Stored Procedures. We currently run ColdFusion 5. Everything seemed to be going swimmingly. Yesterday, we began noticing significant performance slowdowns. Apparently, the maximum number of Oracle connections specified in the server had been reached, and inactive connections were not being released automatically. We reverted to an older codebase without Stored Procedures, and restarted the server, but that's removed quite a bit of functionality. It seems as though every time we call (certain?) stored procedures, the oracle connection is **never** considered inactive and closes/releases, as it should. Changing the Connection Timeout to a lower number has no effect -- the inactive connections stay open to our Oracle Server indefinitely. We've searched extensively, through Macromedia and CF-Talk archives, but have found no mention of this occuring elsewhere. Have no idea which procedures are causing the problem, much less why ColdFusion would leave the connections open for good. Any suggestions? Thanks in advance. Barrett ~| 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:197925 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
ColdFusion 5 and Java Object Instantiation
Hi gang. We've got a ColdFusion 5.1 server, and we're trying to add some functionality using Java objects and the CFOBJECT tag. Now, I've got two classes that I've written, and seem to work fine. If I execute them as Java Applications on my localhost, they run ***perfectly***. On the CF server, though, the Java Object is created successfully, but as soon as I try to execute a method, I get the following error: java.lang.NullPointerException. Java exception occurred in call to method. Now the Java class itself has full Exception handling and passes error messages back in it's result String, so clearly the method isn't able to run at all. However, I don't understand why this would be occuring at all -- it won't even tell me, for example, that the signature of the method I'm trying to execute doesn't match the class. (Which might make sense, but I have no idea how to tell which and how. I have checked the parameters a hundred times, and they should, as far as I know, match. Whether Java agrees is another matter.) I've torn out what little hair I had left. If anyone has advice as to how to debug this application further, it would be appreciated more than you'll ever be able to know. Thanks in advance. Barrett ~| 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:191901 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 5 and Java Object Instantiation
Thanks for the response, Barney. Instantiation of Java objects happens at the first method call, NOT at the createObject call. I misspoke. I'm instantiating with createObject, and then it barfs when I perform the method call. Now that that's out of the way, I bet the problem you're having is that your class isn't being found. It must be added to the CF class path, as configured in the JVM settings page of the CF admin. CreateObject is running successfully, though, and other classes (Hello, World-type stuff) runs fine in the same directory. I wrangled for some time with a ClassNotFound error. This is definitely NOT that. Barrett ~| 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:191908 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