Date? What Date?
I know this may be a little less JRUN related, however it's seemingly the only un-common denominator, between two different instances, which are behaving differently. Basically I have a CFM, running inside an application, on a JRUN 4 application server, hitting an Oracle database. The CFM has a cfquery in it, which has one parameter. The query is running, and returning a row, which the criteria of the query should be eliminating. I have run this query in numerous places, from numerous clients, and cannot replicate the behavior experienced on the cold-fusion server. To add an element to this, I have a local JRUN 4 server, same patch-level, which runs correctly, and does not return the additional row. The portion of the query i have narrowed it down to, is the line or somedate = '26-Jun-2004' (The record's date is Jan 1st 2001).. I've checked server settings, date formats, etc etc..and have come up blank..Both my local server, and the App server should be running the same versions of pretty much everything, yet the debug output, shows exactly the same query.. on exactly the same database, returning a recordcount=1 on my local server, and 2 on the application server. Has anyone run into this? ~ Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Date? What Date?
To start, if the record is Jan 1, 2001 it will not comply with your logic (that the date is after or on June 26, 2004)... -Original Message- From: Jon Austin [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 11:00 AM To: JRun-Talk Subject: Date? What Date? I know this may be a little less JRUN related, however it's seemingly the only un-common denominator, between two different instances, which are behaving differently. Basically I have a CFM, running inside an application, on a JRUN 4 application server, hitting an Oracle database. The CFM has a cfquery in it, which has one parameter. The query is running, and returning a row, which the criteria of the query should be eliminating. I have run this query in numerous places, from numerous clients, and cannot replicate the behavior experienced on the cold-fusion server. To add an element to this, I have a local JRUN 4 server, same patch-level, which runs correctly, and does not return the additional row. The portion of the query i have narrowed it down to, is the line or somedate = '26-Jun-2004' (The record's date is Jan 1st 2001).. I've checked server settings, date formats, etc etc..and have come up blank..Both my local server, and the App server should be running the same versions of pretty much everything, yet the debug output, shows exactly the same query.. on exactly the same database, returning a recordcount=1 on my local server, and 2 on the application server. Has anyone run into this? ~ Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Date? What Date?
I know this may be a little less JRUN related, however it's seemingly the only un-common denominator, between two different instances, which are behaving differently. Basically I have a CFM, running inside an application, on a JRUN 4 application server, hitting an Oracle database. I suspect you'd have better luck with this sort of question on the CF-Talk list, actually. The CFM has a cfquery in it, which has one parameter. The query is running, and returning a row, which the criteria of the query should be eliminating. ... The portion of the query i have narrowed it down to, is the line or somedate = '26-Jun-2004' You might have better luck if you use the to_date function with dates in Oracle: http://www.techonthenet.com/oracle/functions/to_date.htm Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Date? What Date?
- Original Message - From: Dave Watts [EMAIL PROTECTED] I suspect you'd have better luck with this sort of question on the CF-Talk list, actually. Thanks, I'll have to try it there.. You might have better luck if you use the to_date function with dates in Oracle: I have done that to resolve the problem already, however I'm curious as to why this is happening, incase it's a problem elsewhere in our app, where the results are not quite so obvious [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Date? What Date?
I have done that to resolve the problem already, however I'm curious as to why this is happening, incase it's a problem elsewhere in our app, where the results are not quite so obvious I suspect it has to do with the database drivers you're using. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Date? What Date?
One question: is there any reason why you can't change the date format? Have you tested it if it is in ODBC date format? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 2:09 PM To: JRun-Talk Subject: RE: Date? What Date? I have done that to resolve the problem already, however I'm curious as to why this is happening, incase it's a problem elsewhere in our app, where the results are not quite so obvious I suspect it has to do with the database drivers you're using. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Console Logger
Is there any way (in Jrun 4 for UNIX) to configure the LoggerService to send all standard-out to a file instead of the screen?I want the console messages to be captured in a {server.name}-out.log file. I presumed I needed to reconfigure something with the jrunx.logger.ConsoleLogEventHandler, but it's not creating a file. (I would like to avoid wrapper scripts if there's a better way). thanks -- Chris Boyce [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]