Le 2012-09-10 à 02:53, Ângelo Andrade Cirino <[email protected]> a écrit :
> Hi, > > I am very concerned about the reliability of Eclipse. It seems to be the > cause of my four days of work lost in last week and it keeps causing me > problems. For instance, one application with ERAttachments that was working, > after I experimented some changes in the database with migrations, started to > throw exceptions regarding the primary keys. Now I am trying to insert some > very simple data in postUpgrade and I have a PK not being incremented: > > Set 10 03:11:25 AdministraAgencia[56667] DEBUG NSLog - evaluateExpression: > <com.webobjects.jdbcadaptor._MySQLPlugIn$MySQLExpression: "INSERT INTO > uf(nome, uf_id, sigla) VALUES (?, ?, ?)" withBindings: 1:"Amazonas"(nome), > 2:1(ufID), 3:"AM"(sigla)> > Set 10 03:11:25 AdministraAgencia[56667] DEBUG NSLog - evaluateExpression: > <com.webobjects.jdbcadaptor._MySQLPlugIn$MySQLExpression: "INSERT INTO > uf(nome, uf_id, sigla) VALUES (?, ?, ?)" withBindings: 1:"Amapá"(nome), > 2:1(ufID), 3:"AP"(sigla)> > Set 10 03:11:25 AdministraAgencia[56667] INFO > er.transaction.adaptor.Exceptions - Database Exception occured: > com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: > <com.webobjects.jdbcadaptor._MySQLPlugIn$MySQLExpression: "INSERT INTO > uf(nome, uf_id, sigla) VALUES (?, ?, ?)" withBindings: 1:"Amapá"(nome), > 2:1(ufID), 3:"AP"(sigla)>: > Next exception:SQL State:23000 -- error code: 1062 -- msg: Duplicate > entry '1' for key 'PRIMARY' > Set 10 03:11:25 AdministraAgencia[56667] ERROR > er.extensions.appserver.ERXApplication - AdministraAgencia failed to start. > EOGeneralAdaptorException: EvaluateExpression failed: > <com.webobjects.jdbcadaptor._MySQLPlugIn$MySQLExpression: "INSERT INTO > uf(nome, uf_id, sigla) VALUES (?, ?, ?)" withBindings: 1:"Amapá"(nome), > 2:1(ufID), 3:"AP"(sigla)>: What do you have in the EO_PK_TABLE table? And this part of a migration? > Besides this, I had several different problems during the weekend that forced > me to create new workspaces and projects several times. Sometimes a working > project will cease to work for no apparent reason, sometimes EOModeler will > not generate SQL for a connection that works for a project: > > java.lang.NoClassDefFoundError: > com/webobjects/_eoproject/_WBInterfaceDescriptor > at java.lang.Class.forName0(Native Method) > at java.lang.Class.forName(Class.java:169) > at > com.webobjects.foundation._NSUtilities._classWithPartialName(_NSUtilities.java:350) > > I have my models and connections in a framework that is currently being used > by three applications. In one project EOModeler will not generate the SQL for > this framework, as shown above. In another project EOModeler will generate > the SQL but the application will not connect to the database due to a > connection problem. I even used Practical Web Objects' > EOFJDBCConnectionAnalyzer to debug the connection with no luck in finding the > problem. The third application will connect to the database but ERAttachments > will raise PK exceptions. All based on the same framework. Do you have the JDBC properties set with the same values in all 3 apps? > One of the problematic applications I was able to start from scratch by > deleting the project and its files, copying a different working one and > modifying it with the classes and user interface I started developing for the > former. My feeling is that Eclipse is the cause of the problems and I am > starting to hate it. > > Angelo > _______________________________________________ > 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/probert%40macti.ca > > 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]
