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 protected]> 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 protected]> 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 protected]> >> To: Cretu Catalin <[email protected]> >> Cc: WebObjects Development <[email protected]>; Patrick >> Robinson <[email protected]> >> 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 protected]> 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 protected]> >>> To: Cretu Catalin <[email protected]> >>> Cc: Patrick Robinson <[email protected]>; WebObjects Development >>> <[email protected]> >>> 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 protected]> 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 protected]> >>>> To: Cretu Catalin <[email protected]> >>>> Cc: WebObjects Development <[email protected]> >>>> 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 protected]> >>>> > To: WebObjects Development <[email protected]> >>>> > Cc: Cretu Catalin <[email protected]> >>>> > 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 protected]>: >>>> > > >>>> > >> 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 protected]> >>>> > >> To: Cretu Catalin <[email protected]> >>>> > >> Cc: "[email protected]" <[email protected]> >>>> > >> 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 protected]>: >>>> > >> >>>> > >> > 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 protected]> >>>> > >> > To: Cretu Catalin <[email protected]> >>>> > >> > Cc: "[email protected]" >>>> > >> > <[email protected]> >>>> > >> > 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 protected]>: >>>> > >> > >>>> > >> > > 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 protected]) >>>> > > Help/Unsubscribe/Update your Subscription: >>>> > > https://lists.apple.com/mailman/options/webobjects-dev/pgr%40vt.edu >>>> > > >>>> > > This email sent to [email protected] >>>> > >>>> > >>>> > >>>> >>>> >>>> >>>> _______________________________________________ >>>> Do not post admin requests to the list. They will be ignored. >>>> Webobjects-dev mailing list ([email protected]) >>>> Help/Unsubscribe/Update your Subscription: >>>> https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com >>>> >>>> This email sent to [email protected] >>> >>> >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list ([email protected]) >>> Help/Unsubscribe/Update your Subscription: >>> https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com >>> >>> This email sent to [email protected] >> >> >> > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com > > This email sent to [email protected] _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
