On Nov 15, 2011, at 8:47 AM, Pascal Robert wrote: > > Le 2011-11-15 à 11:39, Kevin Spake a écrit : > >> >> 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/webobjects-dev@lists.apple.com/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: > > wotaskd is a broker that talks to WO applications to check if they are > running or not, and to launch them. Make sure that > /Library/WebObjects/Configuration/ is writable by the "_appserveradm" group > and by your "_appserver", e.g. permissions should be like this: > > $ ls -l /Library/WebObjects > drwxrwxr-x 30 _appserver _appserveradm 1020 17 mai 2010 Configuration
Thanks. Ownership is now: ls -l /Library/WebObjects total 0 drwxrwxr-x 3 _appserver _appserveradm 102 Nov 9 00:07 Configuration The remaining error in system log is: Nov 15 11:12:30 Kevin-Spakes-iMac com.apple.launchd[1] (com.edb.launchd.apache[19773]): posix_spawn("/Library/PostgreSQL/EnterpriseDB-ApachePhp/apache/bin/httpd", ...): No such file or directory Nov 15 11:12:30 Kevin-Spakes-iMac com.apple.launchd[1] (com.edb.launchd.apache[19773]): Exited with exit code: 1 Nov 15 11:12:30 Kevin-Spakes-iMac com.apple.launchd[1] (com.edb.launchd.apache): Throttling respawn: Will start in 10 seconds And it's true, I don't have a "Library/PostgreSQL/EnterpriseDB-ApachePhp/apache/bin/httpd", .. file or directory. I don't think I'm using the EnterpriseDB version. I ran EOGenerate again and still no packages. I'm wondering if I should just install mysql and give that a shot. > >> 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 (Webobjects-dev@lists.apple.com) >>>>>> Help/Unsubscribe/Update your Subscription: >>>>>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net >>>>>> >>>>>> This email sent to ch...@global-village.net >>>>> >>>>> -- >>>>> 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 (Webobjects-dev@lists.apple.com) >>>> Help/Unsubscribe/Update your Subscription: >>>> http://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca >>>> >>>> This email sent to prob...@macti.ca >>> >> > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com