Re: Eclipse source of problems?
Re: Eclipse source of problems?
- Subject: Re: Eclipse source of problems?
- From: Pascal Robert <email@hidden>
- Date: Mon, 10 Sep 2012 10:23:22 -0400
Le 2012-09-10 à 02:53, Ângelo Andrade Cirino <email@hidden> 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@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden