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 protected]/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?
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 protected])
>> Help/Unsubscribe/Update your Subscription:
>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
>>
>> This email sent to [email protected]
>
> --
> 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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
