Re: Error: table "eof_tmp_table" does not exist.
Re: Error: table "eof_tmp_table" does not exist.
- Subject: Re: Error: table "eof_tmp_table" does not exist.
- From: Kevin Spake <email@hidden>
- Date: Tue, 15 Nov 2011 08:39:51 -0800
On Nov 15, 2011, at 1:42 AM, Pascal Robert wrote:
>
> Le 2011-11-14 à 23:52, Kevin Spake a écrit :
>
>>
>> On Nov 14, 2011, at 8:33 PM, Chuck Hill wrote:
>>
>>> Hi Kevin,
>>>
>>>
>>> On 2011-11-14, at 8:25 PM, Kevin Spake wrote:
>>>
>>>> Trying now to go through the "WO Tutorial: creating a model" screencast. At 19 minutes in, the instructions say to generate the SQL. At first, I was getting errors that said the problem started around "user". Eventually, I realized that the tutorial involves naming a table "user", but "user" is a reserved word in postgresql. I changed the entity name to T_User and the table name to T_USER.
>>>
>>> You don't need to change the entity name, just the table name. They don't need to be the same, and User is way easier to read in Java. Name a table User was a rather unfortunate choice for a tutorial...
>>>
>>>
>>>> BTW, "password" is also a keyword, but it's not reserved. I changed that column name to "pass_word" anyway.
>>>>
>>>> I'm no longer getting the "user" error, however, I now get:
>>>>
>>>> "Failed to generate SQL. ERROR: table "eof_tmp_table" does not exist.
>>>>
>>>> There was an error, do you want to cancel the rest of the script?"
>>>>
>>>>
>>>> i chose to continue and it looks like the SQL completed. Below is the info for the wowodc09 db:
>>>>
>>>> The only reference I found to this error message is here: http://www.mail-archive.com/email@hidden/msg08878.html
>>>>
>>>> Is this a bug, or do I need to do something different, or both?
>>>
>>> I am not sure, I don't have any current postgres projects. Does the project include the PostgresqlPlugIn.framework from Project Wonder?
>>
>> I think so. I have pretty much all of project wonder imported into the workspace. The PostgresqlPlugin.framework is in the build path under "libraries". I'm using the EOJDBPostgresqlPrototypes. But I'm obviously doing something wrong, because the next step is to run EOGenerator, which I did. Only none of the appropriate java files were created. My Sources folder contains:
>> Sources:
>> your.app
>> Application.java
>> DirectAction.java
>> Session.java
>> your.app.components
>> Main.java
>> main
>>
>> The "com.wowodc.east.jobmanager.eo." package files were not created. I entered the class names in EOModeler. Do I need to create the package separately first?
>
> EOGenerator should create the classes and the packages, so no need to create the package first. Check in /var/log/system.log to see if Eclipse is sending exceptions in this log (you can view this log with the Console app in /Applications/Utilities).
I opened system log, cleared the display, then ran EOGenerate from eclipse, and copied the log entries. The results are below. I don't know exactly what I am looking for, but I don't see anything specific to EOGenerate. However, there seems to be a problem with wotaskd. It keeps repeating the same attempts to launch something:
Tuesday, November 15, 2011 8:25:44 AM America/Los_Angeles
Nov 15 08:25:41 Kevin-Spakes-iMac com.apple.launchd[1] (com.edb.launchd.postgresql-9.0): Throttling respawn: Will start in 10 seconds
Nov 15 08:25:47 Kevin-Spakes-iMac com.apple.launchd[1] (com.apple.webobjects.wotaskd[2852]): Suspicious setup: User "appserver" maps to user: _appserver
Nov 15 08:25:47 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: Reading MacOSClassPath.txt ...
Nov 15 08:25:47 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: Checking network services....
Nov 15 08:25:47 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: Launching wotaskd.woa ...
Nov 15 08:25:47 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: java -XX:NewSize=2m -Xmx64m -Xms32m -DWORootDirectory="/System" -DWOLocalRootDirectory="" -DWOUserDirectory="/" -DWOEnvClassPath="" -DWOApplicationClass=Application -DWOPlatform=MacOS -Dcom.webobjects.pid=2852 -Dcom.sun.management.jmxremote=false -classpath WOBootstrap.jar com.webobjects._bootstrap.WOBootstrap -WOPort 1085
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: Loading /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/MacOS/MacOSClassPath.txt
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: Generated classpath:
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Resources/Java/wotaskd.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Resources/Java/
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/JavaWebObjects.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/JavaFoundation.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/JavaEOControl.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/JavaEOAccess.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/JavaJDBCAdaptor.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/JavaXML.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /var/empty/Library/Java
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /Library/Java/
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/Java/
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /Network/Library/Java
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/Frameworks/JavaVM.framework/Classes/classes.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/Frameworks/JavaVM.framework/Classes/ui.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/avalon-framework-4.1.2.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/axis-ant.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/axis.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/commons-discovery-0.2.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/commons-logging-1.0.4.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/derby.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/derbyclient.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/ejb-1.0.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/JavaEOAccess.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/JavaEOControl.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/JavaFoundation.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/JavaMonitorSupport.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/JavaWebObjects.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/JavaWOExtensions.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/JavaXML.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/jaxrpc.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/log4j-1.2.14.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/logkit.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/saaj.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/serializer.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/servlet.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/wsdl4j-1.5.1.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/xalan.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/xercesImpl.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/xml-apis.jar
Nov 15 08:25:48 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: /System/Library/WebObjects/JavaApplications/wotaskd.woa/Contents/Extensions/
Nov 15 08:25:49 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: [2011-11-15 8:25:49 PST] <main> WebObjects version = 5.4.3
Nov 15 08:25:49 Kevin-Spakes-iMac com.apple.webobjects.wotaskd[2852]: [2011-11-15 8:25:49 PST] <main> Don't have permission to write to Configuration Directory /Library/WebObjects/Configuration/ as this user; please change the permissions.
Nov 15 08:25:49 Kevin-Spakes-iMac com.apple.launchd[1] (com.apple.webobjects.wotaskd[2852]): Exited with exit code: 1
Nov 15 08:25:49 Kevin-Spakes-iMac com.apple.launchd[1] (com.apple.webobjects.wotaskd): Throttling respawn: Will start in 8 seconds
Nov 15 08:25:51 Kevin-Spakes-iMac com.apple.launchd[1] (com.edb.launchd.apache[2882]): posix_spawn("/Library/PostgreSQL/EnterpriseDB-ApachePhp/apache/bin/httpd", ...): No such file or directory
Nov 15 08:25:51 Kevin-Spakes-iMac com.apple.launchd[1] (com.edb.launchd.apache[2882]): Exited with exit code: 1
Nov 15 08:25:51 Kevin-Spakes-iMac com.apple.launchd[1] (com.edb.launchd.apache): Throttling respawn: Will start in 10 seconds
Nov 15 08:25:51 Kevin-Spakes-iMac com.apple.launchd[1] (com.edb.launchd.postgresql-9.0[2883]): posix_spawn("/Library/PostgreSQL/9.0/bin/postmaster", ...): No such file or directory
Nov 15 08:25:51 Kevin-Spakes-iMac com.apple.launchd[1] (com.edb.launchd.postgresql-9.0[2883]): Exited with exit code: 1
Tuesday, November 15, 2011 8:25:52 AM America/Los_Angeles
>
>> Thanks,
>>
>>>
>>>
>>> Chuck
>>>
>>>
>>>>
>>>> wowodc09=> \d
>>>> List of relations
>>>> Schema | Name | Type | Owner
>>>> --------+---------------------+----------+--------
>>>> public | job_description | table | wowodc
>>>> public | job_description_seq | sequence | wowodc
>>>> public | t_user | table | wowodc
>>>> public | t_user_seq | sequence | wowodc
>>>> (4 rows)
>>>>
>>>> wowodc09=> SELECT * FROM job_description;
>>>> jobdesc_fulldesc | id | jobdesc_lastmodifdate | jobdesc_pubdate | jobdesc_title | jobdesc_user_id_fk
>>>> ------------------+----+-----------------------+-----------------+---------------+--------------------
>>>> (0 rows)
>>>>
>>>>
>>>>
>>>> wowodc09=> \dwowodc09=> SELECT * FROM t_user;
>>>> user_first_name | id | user_lastname | user_password | user_title | user_username
>>>> -----------------+----+---------------+---------------+------------+---------------
>>>> (0 rows)
>>>>
>>>> _______________________________________________
>>>> 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
>>>
>>> --
>>> 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/products/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
>
_______________________________________________
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