Greetings Chuck,
Well, I decided to try going through WOLips as opposed to Hudson. I added the
MySQL plugin and got a lot farther, but I am still running into some trouble.
This time at the "Release" table. In particular, MySQL complains about:
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have
an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'RELEASE(DATE_DUE DATETIME NOT
NULL, ID INTEGER NOT NULL, IS_OPEN INTEGER NOT NUL' at line 1
Now the "NUL" looks suspicious, and the real question is how do I fix it?
Thank you,
Dan
On Sep 21, 2010, at 12:18 PM, Chuck Hill wrote:
> You need to add the plugin framework to the classpath file in
> App.woa/Contents/MacOs/something
>
>
>
> On Sep 21, 2010, at 12:04 PM, Daniel Beatty wrote:
>
>> Greetings David,
>> Looks like you are right. Here, I though I had it loaded with Hudson, but I
>> was mistaken. Now I have copied over to /Library/Frameworks. Of course,
>> that failed. I also tried copying my properties so that I have:
>> ( cd /Library/WebObjects/JavaApplications/BugTracker.woa ;
>> ./BugTracker \
>> -Der.javamail.centralize=false \
>> -Der.extensions.ERXApplication.developmentMode=true \
>> -DdbConnectURLGLOBAL=jdbc:mysql://localhost/bug?capitalizeTypenames=true \
>> -DdbConnectUserGLOBAL=bugUser \
>> -DdbConnectPasswordGLOBAL=password \
>> -DdbConnectPluginGLOBAL= \
>> -DdbConnectDriverGLOBAL= \
>> -DdbEOPrototypesEntityGLOBAL=EOJDBCMySQLPrototypes \
>> -Dbuild.root=/Volumes/wabbit/Hudson/Roots \
>>
>> -Dwonder.framework.install=/Volumes/wabbit/Hudson/Wonder/Library/Frameworks \
>>
>> -Dweb.framework.install.root=/Volumes/wabbit/Hudson/Wonder/Library/WebServer/Documents/WebObjects/Frameworks
>> \
>> -Dwo.woroot=/Volumes/wabbit/Hudson/Wonder
>>
>> wo.system.frameworks=/Volumes/wabbit/Hudson/Wonder/System/Library/Frameworks
>> \
>> -Dwo.local.frameworks=/Volumes/wabbit/Hudson/Wonder/Library/Frameworks
>> \
>> -Dwo.dir.system=/Volumes/wabbit/Hudson/Wonder/System \
>> -Dwo.dir.root=/Volumes/wabbit/Hudson/Wonder \
>> -Dwo.dir.local=/Volumes/wabbit/Hudson/Wonder \
>> -Dwo.dir.library=/Volumes/wabbit/Hudson/Wonder/System/Library \
>> -Dwo.dir.local.library=/Volumes/wabbit/Hudson/Wonder/Library \
>>
>> -Dwo.dir.library.frameworks=/Volumes/wabbit/Hudson/Wonder/System/Library/Frameworks
>> \
>>
>> -Dwo.dir.local.library.frameworks=/Volumes/wabbit/Hudson/Wonder/Library/Frameworks
>> \
>> -Dwo.dir.system=/Volumes/wabbit/Hudson/Wonder/System \
>>
>> -Dwo.extensions=/Volumes/wabbit/Hudson/Wonder/Library/WebObjects/Extensions \
>>
>> -Dwo.bootstrapjar=/Volumes/wabbit/Hudson/Wonder/System/Library/WebObjects/JavaApplications/wotaskd.woa/WOBootstrap.jar
>> \
>>
>> -Dwo.apps.root=/Volumes/wabbit/Hudson/Wonder/Library/WebObjects/Applications
>> )
>>
>> Thus I am trying to make sense of this. Any ideas?
>>
>> Dan
>>
>>
>> On Sep 21, 2010, at 10:40 AM, David LeBer wrote:
>>
>>>
>>> On 2010-09-21, at 1:33 PM, Daniel Beatty wrote:
>>>
>>>> Greetings David,
>>>> Just following up on one of these weirditiies. I am trying to follow the
>>>> Bug Tracker example, and I get a nasty SQL error when trying to run the
>>>> bug tracker. For example, I run a script containing the following:
>>>> #!/bin/sh
>>>> ( cd /Library/WebObjects/JavaApplications/BugTracker.woa ;
>>>> ./BugTracker \
>>>> -Der.javamail.centralize=false \
>>>> -Der.extensions.ERXApplication.developmentMode=true \
>>>> -DdbConnectURLGLOBAL=jdbc:mysql://localhost/bug?capitalizeTypenames=true \
>>>> -DdbConnectUserGLOBAL=bugUser \
>>>> -DdbConnectPasswordGLOBAL=changeIt \
>>>> -DdbConnectPluginGLOBAL= \
>>>> -DdbConnectDriverGLOBAL= \
>>>> -DdbEOPrototypesEntityGLOBAL=EOJDBCMySQLPrototypes )
>>>>
>>>> When I run this script I get stopped at :
>>>> 1401 [main] WARN er.extensions.eof.ERXModelGroup - Clearing previous
>>>> class descriptions
>>>> 1700 [main] INFO er.corebusinesslogic.audittrail.ERCAuditTrail -
>>>> Configuration : {}
>>>> 1810 [main] INFO com.thimbleware.jmemcached.MemCacheDaemon - Listening on
>>>> localhost:12345
>>>> 1811 [main] INFO er.caching.ERCaching - Server started: 127.0.0.1:12345
>>>> maxItems=0 maxMemory=128
>>>> 1811 [main] ERROR er.caching.ERCaching - No Servers found, set
>>>> er.caching.servers=server1:port1,server2:port2...
>>>> 1895 [main] WARN er.extensions.migration.ERXMigrator -
>>>> er.migration.modelNames is not set, defaulting to modelGroup.models()
>>>> order instead.
>>>> 4331 [main] INFO er.extensions.migration.ERXMigrator - Upgrading
>>>> ERAttachment to version 1 with migration
>>>> 'er.attachment.migrations.erattachme...@1a9db992'
>>>> 4343 [main] INFO er.extensions.jdbc.ERXJDBCUtilities - Executing alter
>>>> table ERAttachment null available VARCHAR(5) NOT NULL
>>>> 4354 [main] ERROR er.extensions.appserver.ERXApplication - BugTracker
>>>> failed to start.
>>>>
>>>>
>>>> The complaint that I get is that MySQL does not like the syntax being
>>>> applied. Any ideas?
>>>
>>> Are you running WO5.4 and MySQL without the MySQLPlugIn framework from
>>> Wonder?
>>>
>>>>
>>>> Thank you,
>>>> Dan
>>>>
>>>>
>>>>
>>>> On Sep 9, 2010, at 3:32 PM, David Holt wrote:
>>>>
>>>>> Hi David!
>>>>>
>>>>> On 2010-09-09, at 3:03 PM, David Avendasora wrote:
>>>>>
>>>>>> Hi all D2W Gurus,
>>>>>>
>>>>>> I'm starting a new D2W app, and one of the things it needs to do is
>>>>>> automatically pre-qualify all listings of of entities to filter down to
>>>>>> only the EOs that the user is allowed to see.
>>>>>
>>>>> Bug Tracker does stuff like this in the Factory class. You'll find that
>>>>> actions return different qualified lists of things and likely uses a
>>>>> different pageConfiguration for each one (I'm going from memory here). It
>>>>> also heavily leverages the clazz pattern. Take a look at the EO for Bug.
>>>>>
>>>>> The way I have been doing it is to set up a navigationRootChoice based on
>>>>> the logged in user (conditionally display tabs). Then when they further
>>>>> differentiate themselves I store that to ERXThreadStorage, and the tabs
>>>>> reconfigure based on this new layer of qualification. You could do this
>>>>> multiple times, I guess. Take a look at childrenChoices code in the
>>>>> NavigationMenu.plist for BugTracker
>>>>>
>>>>>> The logic to tell if a user is allowed will be somewhat complicated as a
>>>>>> user can belong to one or more organizations, and may have one or more
>>>>>> roles within each organization.
>>>>>
>>>>> Rules should handle it. See Bug.java for the different ways lists of Bugs
>>>>> are returned to the app.
>>>>>
>>>>>>
>>>>>> I want to add a qualifiers to all searches that they perform that take
>>>>>> their Organizations and Roles into account. Each entity that they search
>>>>>> on will have their own set of qualifiers to do this filtering.
>>>>>
>>>>> I think you may want to do this in your business logic. You will need to
>>>>> leverage ERXThreadStorage to do so, however.
>>>>>
>>>>>>
>>>>>> I'm figuring on adding the qualifiers to the session so I can grab them
>>>>>> from there.
>>>>>
>>>>> ERXThreadStorage. Then you can use them directly in your business logic.
>>>>> You can set fetch specifications that can be as complex as you wish using
>>>>> the qualifiers that you have stored.
>>>>>
>>>>>> There are hints of how to do this in this email chain from a couple
>>>>>> years ago:
>>>>>> http://lists.apple.com/archives/webobjects-dev/2007/Sep/msg00032.html
>>>>>> but I'm not sure where to start implementing this for my project, and I
>>>>>> didn't see any obvious examples in the BugTracker demo app.
>>>>>>
>>>>>> Any tips or pointers to other apps that do this?
>>>>>
>>>>> You can also do this in the navigation menu. Conditionally show or hide
>>>>> whole pageConfigurations based on some method. (see NavigationRootChoice
>>>>> method in BugTracker on the Session class)
>>>>> You can also hide and show attributes on a page with rules such as
>>>>> entity.name = 'Media' and 'session.user.isAdmin' = true =>
>>>>> displayPropertyKeys = ("x","y","z")
>>>>>
>>>>> I have found that out of the box the restricting object stuff worked
>>>>> reliably for one, but as soon as my needs got more complex, I had much
>>>>> better success moving what I wanted to do to business logic. If you step
>>>>> back, you'll probably agree it makes more sense to be there than in the
>>>>> component or controller anyway.
>>>>>
>>>>> BUT, there are many ways to skin this cat.
>>>>>
>>>>> HTH,
>>>>>
>>>>> d
>>>>>
>>>>>>
>>>>>> Thanks!
>>>>>>
>>>>>> Dave _______________________________________________
>>>>>> 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/programmingosx%40mac.com
>>>>>>
>>>>>> 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/danielbeatty%40mac.com
>>>>>
>>>>> 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/dleber_wodev%40codeferous.com
>>>>
>>>> This email sent to [email protected]
>>>
>>> ;david
>>>
>>> --
>>> David LeBer
>>> Codeferous Software
>>> 'co-def-er-ous' adj. Literally 'code-bearing'
>>> site: http://codeferous.com
>>> blog: http://davidleber.net
>>> profile: http://www.linkedin.com/in/davidleber
>>> twitter: http://twitter.com/rebeld
>>> --
>>> Toronto Area Cocoa / WebObjects developers group:
>>> http://tacow.org
>>>
>>>
>>>
>>>
>>
>>
>>
>> Dan Beatty, M.S. CS (B.S. EECS)
>> Ph.D. Student
>> Texas Tech University
>> [email protected]
>> http://web.me.com/danielbeatty/My_Home_Page/Welcome.html
>> (806)438-6620
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> 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
>
>
>
>
>
>
>
Dan Beatty, M.S. CS (B.S. EECS)
Ph.D. Student
Texas Tech University
[email protected]
http://web.me.com/danielbeatty/My_Home_Page/Welcome.html
(806)438-6620
_______________________________________________
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]
