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
> 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]