Hi Cretu, please use EOAdaptorDebugEnabled=true to get SQL Logging. See if the jdbc driver generates NEWID commands, or if it creates automatic keys using the UNIQUE INDEX DERIVED clause.
You do have a unique index on the key id column, right? If you don't care *why* the sequence is messed up, you could just try and set the seed value: SET ID SEED (select max(address_id)+1 from address) FOR address.address_id If the inner query doesn't work with that clause, use it separately to retrieve the value and put it literally into the set id command. Maik Am 25.09.2012 um 22:41 schrieb Cretu Catalin <[email protected]>: > 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/maik%40selbstdenker.ag > > 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]
