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: Pascal Robert <email@hidden>
- Date: Tue, 15 Nov 2011 04:42:30 -0500
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).
> 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