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 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?
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 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/probert%40macti.ca > > This email sent to [email protected] _______________________________________________ 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]
