| 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)>:
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.
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 |