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