Re: Eclipse source of problems?
Re: Eclipse source of problems?
- Subject: Re: Eclipse source of problems?
- From: Chuck Hill <email@hidden>
- Date: Mon, 10 Sep 2012 10:16:32 -0700
On 2012-09-09, at 11:53 PM, Ângelo Andrade Cirino wrote:
> 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.
I don't think that Eclipse is to blame for all of them (UTF-8 in the path excepted). I think you are just blaming Eclipse for problems whose source lies elsewhere.
> For instance, one application with ERAttachments that was working, after I experimented some changes in the database with migrations,
Did you change the model?
> 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)>:
That looks like a model / MySQL problem, not something caused by Eclipse.
> 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,
Because the reason is not apparent to you, does not mean that the reason is Eclipse. Most of us here use it on a daily basis and we don't have these problems. If we did, we would fix it.
> 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)
See java.lang.NoClassDefFoundError: com/webobjects/_eoproject/_WBInterfaceDescriptor. That means that the JavaEOProject framework needs to be added to the project you are generating SQL from. I think this may only be added to Application projects by default. Or perhaps you removed it?
> 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.
Without seeing the full log, I can't guess why. But differences in the frameworks included in each project could be the reason. Frameworks used by a Framework project are NOT available to an Application project. They need to be added to the Application project as well.
> 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.
Something is different. :-)
> 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.
No, Eclipse is not the cause of these problems.
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/gvc/practical_webobjects
_______________________________________________
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