On Sep 21, 2010, at 1:17 PM, Daniel Beatty wrote: > 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?
My guess is that this is a Red Herring. It is just showing you 80 characters
(count them!) of context surrounding the error.
Some guesses:
- ID is a reserved word in MySQL
- one of the data types is wrong (wrong JDBC driver / version?)
Chuck
> 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/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
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ 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]
