Re: Java 1.5 & WO?
Re: Java 1.5 & WO?
- Subject: Re: Java 1.5 & WO?
- From: "Jerry W. Walker" <email@hidden>
- Date: Wed, 19 Apr 2006 16:21:33 -0400
Hi, John,
On Apr 19, 2006, at 12:08 PM, John Andersson wrote:
Sorry for quoting myself. :-)
I "fixed" it by simply changing the symbolic link "CurrentJDK" in /
System/Library/Frameworks/JavaVM.framework/Versions back to 1.4.2.
Hmm, it would be interesting to know if someone else has this
problem. The DB / JDBC was OpenBase 9.1.5.
I did, using Java 1.5.0 and OpenBase 9.1.5.
I did the update to Java 1.5.0 this morning with Software Updater and
got a nearly identical problem. The interesting thing is that two
dates are used in my qualifier (as they are for yours), but the first
date compared fine and the second date was converted to the same kind
of floating point number that threw your exception.
Here is the exception from the log:
==========================================
com.webobjects.jdbcadaptor.JDBCAdaptorException: EvaluateExpression
failed: <com.webobjects.jdbcadaptor.OpenBasePlugIn
$OpenBaseExpression: "SELECT t0.ACCOUNT_ID, t0.CALENDAR_ID, t0.END,
t0.LAST_UPDATE_TIME, t0.OID, t0.START FROM MEETING_TIME t0 WHERE
(t0.START < ? AND t0.END > ? AND t0.CALENDAR_ID = ?) ORDER BY
t0.START ASC" withBindings: 1:2006-04-24 23:59:59(start),
2:2006-04-24 00:00:00(end), 3:17(calendarID)>:
Next exception:SQL State:42000 -- error code: 0 -- msg: SQL
ERROR - [position 204, near 'E' in ' > 1.67544E+8 AND t0.CALE'] (0)
and expected but not found at position 48.
SQL: SELECT t0.ACCOUNT_ID, t0.CALENDAR_ID, t0.END,
t0.LAST_UPDATE_TIME, t0.OID, t0.START FROM MEETING_TIME t0 WHERE
(t0.START < 167630399 AND t0.END > 1.67544E+8 AND t0.CALENDAR_ID =
17) ORDER BY t0.START ASC
[2006-04-19 15:46:45 EDT] <WorkerThread8>
com.webobjects.jdbcadaptor.JDBCAdaptorException: EvaluateExpression
failed: <com.webobjects.jdbcadaptor.OpenBasePlugIn
$OpenBaseExpression: "SELECT t0.ACCOUNT_ID, t0.CALENDAR_ID, t0.END,
t0.LAST_UPDATE_TIME, t0.OID, t0.START FROM MEETING_TIME t0 WHERE
(t0.START < ? AND t0.END > ? AND t0.CALENDAR_ID = ?) ORDER BY
t0.START ASC" withBindings: 1:2006-04-24 23:59:59(start),
2:2006-04-24 00:00:00(end), 3:17(calendarID)>:
Next exception:SQL State:42000 -- error code: 0 -- msg: SQL
ERROR - [position 204, near 'E' in ' > 1.67544E+8 AND t0.CALE'] (0)
and expected but not found at position 48.
==========================================
/John
19 apr 2006 kl. 16.40 skrev John Andersson:
I'm using it with WO 5.3 and it works great!
Not for me. But this is maybe something else. This worked nice
yesterday though:
NSMutableArray args = new NSMutableArray();
args.addObject (startdate);
args.addObject (enddate);
EOQualifier qual = EOQualifier.qualifierWithQualifierFormat
("enddate > %@ and startdate < %@", args);
EOSortOrdering byStartDate = EOSortOrdering.sortOrderingWithKey
("startdate", EOSortOrdering.CompareAscending);
NSMutableArray sortOrder = new NSMutableArray ();
sortOrder.addObject (byStartDate);
EOFetchSpecification fetchSpec = new EOFetchSpecification
("Reservation", qual, sortOrder);
NSMutableArray reservationList = new NSMutableArray
(ec.objectsWithFetchSpecification (fetchSpec));
The dates are NSTimestamp's.
Now I get a SQL error:
SQL ERROR - [position 483, near 'E' in ' > 1.71324E+8 AND
t0.star'] (0) and expected but not found at position 114.
The SQL at that position looks like this:
WHERE (t0.enddate > 1.71324E+8 AND t0.startdate < 1.741752E+8)
Why are the dates being inserted as "1.71324E+8" ? Is it normal?
It didn't help to set Java 1.4.2 as the preferred Java with the
"Java Preferences" application.
Does anyone know how to fix this?
/John
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40peekaboo.se
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40gmail.com
This email sent to email@hidden
--
__ Jerry W. Walker,
WebObjects Developer/Instructor for High Performance Industrial
Strength Internet Enabled Systems
email@hidden
203 278-4085 office
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden