Re: adding new records in database fails
Re: adding new records in database fails
- Subject: Re: adding new records in database fails
- From: Ramsey Gurley <email@hidden>
- Date: Tue, 25 Sep 2012 15:09:58 -0700
Last time I used it, Openbase didn't work with horizontal and vertical inheritance because the plugin generated the pks incorrectly.
On Sep 25, 2012, at 2:52 PM, Tim Worman wrote:
> I believe OpenBase has their own plugin for generating primary keys in WO (which you can alternately use). Check their docs.
>
> Tim
> UCLA GSE&IS
>
> On Sep 25, 2012, at 2:07 PM, Paul Yu <email@hidden> wrote:
>
>> Cretu
>>
>> Then I would guess that your sequence on the database table is messed up.
>>
>> Are you saying that EOF will catch up with the database after you attempt to insert some number of records and work? Then when you reboot the machine, then EOF and the Database gets out of synch and you can't insert records?
>>
>> This is OpenBase right?
>>
>> Paul
>> On Sep 25, 2012, at 4:41 PM, Cretu Catalin <email@hidden> wrote:
>>
>>> I did it, but still is not working.
>>>
>>> When I try to add a record the app is throwing this exception till the sequence is increasing enough to create the new primary key. When I'm adding a new record before I restart the computer it is working. The issue is starting again when I restart the computer and application. It takes the sequence again from beginning.
>>>
>>> Any ideas?
>>> Any help is much appreciated.
>>>
>>> Thanks
>>> Catalin
>>>
>>>
>>> From: Paul Yu <email@hidden>
>>> To: Cretu Catalin <email@hidden>
>>> Cc: WebObjects Development <email@hidden>; Patrick Robinson <email@hidden>
>>> Sent: Monday, September 24, 2012 10:06:26 PM
>>> Subject: Re: adding new records in database fails
>>>
>>> Cretu
>>>
>>> You need to delete the row associated with the ADDRESS EO. Once you do EOF will create a new one and give you the max.
>>>
>>> Paul
>>> On Sep 24, 2012, at 9:46 PM, Cretu Catalin <email@hidden> wrote:
>>>
>>>> Yes I do have, but I do not know how to reset sequence. The issue arise when I restart the computer.
>>>>
>>>> Thank you
>>>> Catalin
>>>>
>>>>
>>>> From: Paul Yu <email@hidden>
>>>> To: Cretu Catalin <email@hidden>
>>>> Cc: Patrick Robinson <email@hidden>; WebObjects Development <email@hidden>
>>>> Sent: Monday, September 24, 2012 9:12:57 PM
>>>> Subject: Re: adding new records in database fails
>>>>
>>>> Do you have a EO_PK_TABLE? Did you reset your sequence?
>>>>
>>>>
>>>> On Sep 24, 2012, at 9:05 PM, Cretu Catalin <email@hidden> wrote:
>>>>
>>>>> Hi Patrick,
>>>>>
>>>>> Now I have another issue. I imported the WebObjects project in eclipse with proper EOModel import. I can connect to the database, but after I add data into database, if I restart eclipse and try to add new records I got next error:
>>>>>
>>>>> EvaluateExpression failed: <com.webobjects.jdbcadaptor.OpenBasePlugIn$OpenBaseExpression: "INSERT INTO ADDRESS(EDIT_BY, STREET, STREET_NO, CITY_ID, IS_SHOWN, CREATE_TIME, PO_BOX, APT_NO, CREATE_BY, EDIT_TIME, POSTAL_CODE, RURAL_ADDRESS, ADDRESS_ID, TYPE_DATA_ID) VALUES (NULL, NULL, NULL, NULL, ?, ?, NULL, NULL, ?, NULL, NULL, NULL, ?, ?)" withBindings: 1:1(isShown), 2:2012-09-24 17:55:52(createTime), 3:"Cat"(createBy), 4:12(addressId), 5:1(typeDataId)>: Next exception:SQL State:42000 -- error code: 0 -- msg: ERROR - The primary key values are not unique. SQL: INSERT INTO ADDRESS(EDIT_BY, STREET, STREET_NO, CITY_ID, IS_SHOWN, CREATE_TIME, PO_BOX, APT_NO, CREATE_BY, EDIT_TIME, POSTAL_CODE, RURAL_ADDRESS, ADDRESS_ID, TYPE_DATA_ID) VALUES (NULL, NULL, NULL, NULL, 1, 370216552.788, NULL, NULL, 'Cat', NULL, NULL, NULL, 12, 1)
>>>>>
>>>>> It seems that the EOModel cannot generate proper sequence for database in creating primary key.
>>>>>
>>>>> I use OpenBase as database Selection from all tables is OK, editing OK, but addition is failing.
>>>>>
>>>>> Any ideea what's going on?
>>>>>
>>>>> Regards
>>>>> Catalin
>>>>>
>>>>>
>>>>> From: Patrick Robinson <email@hidden>
>>>>> To: Cretu Catalin <email@hidden>
>>>>> Cc: WebObjects Development <email@hidden>
>>>>> Sent: Friday, September 21, 2012 9:53:19 AM
>>>>> Subject: Re: WOTable class does not exist in Wonder and WOlips?
>>>>>
>>>>> I was afraid you were going to ask me that, and wasn't sure I had a good answer. :-)
>>>>>
>>>>> Look at your Build Path (ctrl-click on the project -> Build Path -> Configure Build Path. Click Add Library, select WebObjects Frameworks, then click Next. This will show you what frameworks have been added (and is where you can add others), and it shows the location where it's finding each framework, whether Project, Local, or System.
>>>>>
>>>>> It appears that WOLips prefers to find frameworks in Projects, then Local, then System. That is, if you have a JavaWOExtensions framework project open in Eclipse, then it'll use that. Otherwise, if it finds one in your "Local Frameworks" location (as defined by your WOLips properties file), it'll use that. Lastly, it'll look in the "System Frameworks" location.
>>>>>
>>>>> When you run your project, you can check the Console view (in Eclipse) for the value of java.class.path.
>>>>>
>>>>> - Patrick
>>>>>
>>>>> On Sep 21, 2012, at 7:46 AM, Cretu Catalin wrote:
>>>>>
>>>>>> Good Morning Patrick,
>>>>>>
>>>>>> How can this reference be done?
>>>>>>
>>>>>> Thank you,
>>>>>> Catalin
>>>>>>
>>>>>>
>>>>>> From: Patrick Robinson <email@hidden>
>>>>>> To: WebObjects Development <email@hidden>
>>>>>> Cc: Cretu Catalin <email@hidden>
>>>>>> Sent: Thursday, September 20, 2012 2:10:54 PM
>>>>>> Subject: Re: WOTable class does not exist in Wonder and WOlips?
>>>>>>
>>>>>> Also be aware that there's a WOTable component in both the Apple and the Wonder versions of the JavaWOExtensions framework, so make sure you're referencing the right one in your project.
>>>>>>
>>>>>> - Patrick
>>>>>>
>>>>>> On Sep 20, 2012, at 9:32 AM, Johann Werner wrote:
>>>>>>
>>>>>>> The component is inside the JavaWOExtensions project so if it is on your classpath WO should find it. You should create a new Wonder Application project from scratch and try to use the table component there. Then have a look at your project, check your classpath against the new project and correct/add. Though converting an old app to a Wonder app takes several additional steps. Those are probably written down somewhere in the wiki.
>>>>>>>
>>>>>>> Btw does anyone know why we have WOTable in JavaWOExtensions and ERExtensions (where it is missing the HTML template)? Seems really odd.
>>>>>>>
>>>>>>> jw
>>>>>>>
>>>>>>>
>>>>>>> Am 20.09.2012 um 15:18 schrieb Cretu Catalin <email@hidden>:
>>>>>>>
>>>>>>>> I install WOLips, Wonder, and after that I made a manual import. There is a way to set up or to check if I use Wonder?
>>>>>>>>
>>>>>>>> Thank you,
>>>>>>>> Catalin
>>>>>>>>
>>>>>>>>
>>>>>>>> From: Johann Werner <email@hidden>
>>>>>>>> To: Cretu Catalin <email@hidden>
>>>>>>>> Cc: "email@hidden" <email@hidden>
>>>>>>>> Sent: Thursday, September 20, 2012 9:07:39 AM
>>>>>>>> Subject: Re: WOTable class does not exist in Wonder and WOlips?
>>>>>>>>
>>>>>>>> Works for me. You do use Wonder?
>>>>>>>>
>>>>>>>>
>>>>>>>> Am 20.09.2012 um 13:43 schrieb Cretu Catalin <email@hidden>:
>>>>>>>>
>>>>>>>>> Hello JW,
>>>>>>>>>
>>>>>>>>> I tried again, but when I run the project I got this exception on browser:
>>>>>>>>>
>>>>>>>>> "Application: TMA
>>>>>>>>> Error: java.lang.ClassNotFoundException exception
>>>>>>>>> Reason:
>>>>>>>>> java.lang.ClassNotFoundException: Cannot find class or component named WOTable in runtime or in a loadable bundle
>>>>>>>>>
>>>>>>>>> Also on console I got this error:
>>>>>>>>>
>>>>>>>>> [2012-9-20 7:23:52 EDT] <WorkerThread0> WOBundle.lookForClassInAllBundles(WOTable) failed!
>>>>>>>>> [2012-9-20 7:23:52 EDT] <WorkerThread0> <com.webobjects.appserver._private.WOComponentRequestHandler>: Exception occurred while handling request:
>>>>>>>>> com.webobjects.foundation.NSForwardException [java.lang.ClassNotFoundException] Cannot find class or component named WOTable in runtime or in a loadable bundle:<com.webobjects.appserver._private.WOComponentDefinition: Error parsing template for Component : 'file:/Users/catacretu/Documents/workspace/TMA/build/TMA.woa/Contents/Resources/CalendarSchedule.wo':
>>>>>>>>> java.lang.ClassNotFoundException: Cannot find class or component named WOTable in runtime or in a loadable bundle
>>>>>>>>> [2012-9-20 7:23:52 EDT] <WorkerThread0> com.webobjects.foundation.NSForwardException [java.lang.ClassNotFoundException] Cannot find class or component named WOTable in runtime or in a loadable bundle:<com.webobjects.appserver._private.WOComponentDefinition: Error parsing template for Component : 'file:/Users/catacretu/Documents/workspace/TMA/build/TMA.woa/Contents/Resources/CalendarSchedule.wo':
>>>>>>>>> java.lang.ClassNotFoundException: Cannot find class or component named WOTable in runtime or in a loadable bundle
>>>>>>>>> at com.webobjects.appserver._private.WOComponentDefinition.template(WOComponentDefinition.java:375)
>>>>>>>>> at com.webobjects.appserver.WOComponent.template(WOComponent.java:499)
>>>>>>>>> at com.webobjects.appserver.WOComponent.appendToResponse(WOComponent.java:1112)
>>>>>>>>> at com.webobjects.appserver._private.WOComponentReference.appendToResponse(WOComponentReference.java:135)
>>>>>>>>> at com.webobjects.appserver._private.WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:126)
>>>>>>>>> at com.webobjects.appserver._private.WODynamicGroup.appendToResponse(WODynamicGroup.java:136)
>>>>>>>>> at com.webobjects.appserver.WOComponent.appendToResponse(WOComponent.java:1122)
>>>>>>>>> at com.webobjects.appserver.WOSession.appendToResponse(WOSession.java:1385)
>>>>>>>>> at com.webobjects.appserver.WOApplication.appendToResponse(WOApplication.java:1794)
>>>>>>>>> at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedPage(WOComponentRequestHandler.java:242)
>>>>>>>>> at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedSession(WOComponentRequestHandler.java:298)
>>>>>>>>> at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedApplication(WOComponentRequestHandler.java:332)
>>>>>>>>> at com.webobjects.appserver._private.WOComponentRequestHandler._handleRequest(WOComponentRequestHandler.java:369)
>>>>>>>>> at com.webobjects.appserver._private.WOComponentRequestHandler.handleRequest(WOComponentRequestHandler.java:445)
>>>>>>>>> at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1687)
>>>>>>>>> at com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:144)
>>>>>>>>> at com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:226)
>>>>>>>>> at java.lang.Thread.run(Thread.java:680)
>>>>>>>>> Caused by: java.lang.ClassNotFoundException: Cannot find class or component named WOTable in runtime or in a loadable bundle
>>>>>>>>> at com.webobjects.appserver.parser.WOHTMLWebObjectTag._componentReferenceWithClassNameDeclarationAndTemplate(WOHTMLWebObjectTag.java:168)
>>>>>>>>> at com.webobjects.appserver.parser.WOHTMLWebObjectTag._elementWithDeclaration(WOHTMLWebObjectTag.java:241)
>>>>>>>>> at com.webobjects.appserver.parser.WOHTMLWebObjectTag.dynamicElement(WOHTMLWebObjectTag.java:155)
>>>>>>>>> at com.webobjects.appserver.parser.WOBundleComponentTemplateParser.didParseClosingWebObjectTag(WOBundleComponentTemplateParser.java:68)
>>>>>>>>> at com.webobjects.appserver.parser.WOHTMLParser.didParseClosingWebObjectTag(WOHTMLParser.java:194)
>>>>>>>>> at com.webobjects.appserver.parser.WOHTMLParser.endOfWebObjectTag(WOHTMLParser.java:161)
>>>>>>>>> at com.webobjects.appserver.parser.WOHTMLParser.parseHTML(WOHTMLParser.java:68)
>>>>>>>>> at com.webobjects.appserver.parser.WOBundleComponentTemplateParser.parse(WOBundleComponentTemplateParser.java:109)
>>>>>>>>> at com.webobjects.appserver.parser.WOHTMLTemplateParser.parse(WOHTMLTemplateParser.java:40)
>>>>>>>>> at com.webobjects.appserver.parser.WOComponentTemplateParser.templateWithHTMLAndDeclaration(WOComponentTemplateParser.java:438)
>>>>>>>>> at com.webobjects.appserver._private.WOComponentDefinition.template(WOComponentDefinition.java:364)
>>>>>>>>> ... 17 more
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Any ideas?
>>>>>>>>>
>>>>>>>>> Regards
>>>>>>>>> Catalin
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> From: Johann Werner <email@hidden>
>>>>>>>>> To: Cretu Catalin <email@hidden>
>>>>>>>>> Cc: "email@hidden" <email@hidden>
>>>>>>>>> Sent: Tuesday, September 18, 2012 7:41:47 AM
>>>>>>>>> Subject: Re: WOTable class does not exist in Wonder and WOlips?
>>>>>>>>>
>>>>>>>>> Hi Catalin,
>>>>>>>>>
>>>>>>>>> don't bother with these warnings. Most of the time this is due to a bug in Eclipse/WOLips who knows. WOTable still exists so you should be fine.
>>>>>>>>>
>>>>>>>>> jw
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Am 18.09.2012 um 13:33 schrieb Cretu Catalin <email@hidden>:
>>>>>>>>>
>>>>>>>>>> Hi,
>>>>>>>>>>
>>>>>>>>>> I developed long time ago a WO application. For a calendar component I used a WOTable component. Now, I'm trying to migrate the WO app into Wonder/WOLips. One of the errors I get is "In the WOD, The class for 'WOTable' is either missing or does not extend WOElement."
>>>>>>>>>>
>>>>>>>>>> Can somebody help?
>>>>>>>>>>
>>>>>>>>>> Regards
>>>>>>>>>> Catalin Cretu
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> 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
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>>
>>>
>>>
>>
>> _______________________________________________
>> 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
>
>
> _______________________________________________
> 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
_______________________________________________
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