Re: (no subject)
Re: (no subject)
- Subject: Re: (no subject)
- From: Clark Mueller <email@hidden>
- Date: Sun, 8 Apr 2007 22:40:41 -0600
Dan,
That looks like a very large, very negative, very wrong value to me,
considering the column it belongs to is "birthday". What does other
data look like in that column in the database? Are there any problems
reading this record type from WebObjects? Where is that data coming
from (e.g. user provided)? What is the database column type? Some
other information that would be helpful:
- What DBMS are you using, and what version?
- What OS are you deployed on?
- What version of WebObjects and Java are you using?
And as Jerry says, definitely get your hands on the code!
Clark
On 8 Apr 07, at 10:05 PM, Jerry W. Walker wrote:
Hi, John,
I presume that you are using an OpenBase database. If so, I think
your problem can be resolved (this time) by simply downloading the
latest OpenBase JDBC driver from the OpenBase website and
installing it.
However, you are at some risk by running a WebObjects based web
site in production without the source code. The next problem may
not be so easy to fix, so I suggest starting negotiations now to
get hold of the code before the next emergency.
Regards,
Jerry
On Apr 8, 2007, at 11:30 PM, Daniel John Brateris wrote:
Hey Guys,
So I took over as web manager for a company. And I have a problem
with a web objects site. I understand the problem but have no
idea how to fix it. I also dont have any of the original xcode
files.
So here are my questions:
Is there a way to reconstruct a project from the files that are on
the web server?
Does anyone know how to fix this problem?
================================================
com.webobjects.eoaccess.EOGeneralAdaptorException:
EvaluateExpression failed: : Next exception:SQL State:42000 --
error code: 0 -- msg: SQL ERROR - [position 525, near 'E' in ',
-4.85208E+8, 'dj Dan')'] insert error: comma expected but not
found in data. SQL: INSERT INTO NoRiskSubscriber(notes, zipCode,
newsletterFid, customerName, formatFid, reference, state, country,
suscribeDate, title, source, alert, fax, entityId, orgTypeFid,
endDate, city, keyCode, phone, address, receivedWelcomeEmail,
email, birthday, company) VALUES (NULL, '07719', 7, 'Daniel John
Brateris', 2, NULL, 'NJ', 'United States', 197782355.515, 'Mr.',
'Health Resources Publishing', NULL, '908-692-7166', 1043, 1,
NULL, 'South Belmar', NULL, '908-692-7166', '313 19th Ave.', 'no',
'email@hidden', -4.85208E+8, 'dj Dan')
================================================
-to me it seems that there should be ' ' around the -4.85208E+8 in
the insert statement.
-I tried making this change and executing the statement from an
SQL terminal and it worked. so how do I get the EOAdapter to put
' ' around that value and why is it not doing it in the first place.
-I also believe that -4.85208E+8 is not the correct value even if
the ' ' were around it
I should also point out that this application was working and all
of a sudden stopped, apparently for no reason
Any help would be greatly appreciated,
Thanks,
Dan
_______________________________________________
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:
40mac.com
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:
This email sent to email@hidden