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/[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).
>>
>>
>>
>> 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 ([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]
