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/archive%40mail-archive.com This email sent to [email protected]
