OpenBase with Wonder
Deleting JavaERJDBCAdaptor.framework seems to fix the error. Michael Kondratov Aspire Auctions, Inc. 216-231-5515 ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Openbase and wonder problem
We’ve just installed latest build of wonder and getting this error: Mar 09 13:48:15 auction[5] WARN NSLog - A fatal exception occurred: _obtainOpenChannel -- er.extensions.eof.ERXDatabaseContext er.extensions.eof.ERXDatabaseContext@1890516e: failed to open database channel. Check your connection dictionary, and ensure your database is correctly configured. [2016-3-9 13:48:15 EST] java.lang.IllegalStateException: _obtainOpenChannel -- er.extensions.eof.ERXDatabaseContext er.extensions.eof.ERXDatabaseContext@1890516e: failed to open database channel. Check your connection dictionary, and ensure your database is correctly configured. at com.webobjects.eoaccess.EODatabaseContext._obtainOpenChannel(EODatabaseContext.java:1967) at com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3054) at er.extensions.eof.ERXDatabaseContext._objectsWithFetchSpecificationEditingContext(ERXDatabaseContext.java:62) at com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EODatabaseContext.java:3195) at com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488) at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069) at com.webobjects.eocontrol.EOSharedEditingContext.bindObjectsWithFetchSpecification(EOSharedEditingContext.java:401) at auction.Application.(Application.java:153) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at java.lang.Class.newInstance(Class.java:442) at com.webobjects.appserver.WOApplication.main(WOApplication.java:547) at er.extensions.appserver.ERXApplication.main(ERXApplication.java:874) at auction.Application.main(Application.java:60) APPLICATION SHUTDOWN SEQUENCE COMPLETE Any ideas? Michael Kondratov Aspire Auctions, Inc. 216-231-5515 ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Wonder addition - updated openbase plugin
Hola from CA: Following up and looking for advice on this. I did follow this approach (below) for naming of the OpenBasePlugIn class. I’ve added some new expressions to the OpenBaseSynchronization factory to support functions that are missing for migrations. So, in a migration where you alter the column type, you’d call this: ERXMigrationColumn.setDataType(). In that method are these calls: EOSchemaSynchronization schemaSynchronization = (EOSchemaSynchronization) _table.database().synchronizationFactory(); NSArrayEOSQLExpression expressions = schemaSynchronization.statementsToConvertColumnType(_name, _table.name(), null, new _ColumnType(externalType, scale, precision, width), options); The sync factory that is returned is an instance of OpenBasePlugIn$OpenBaseSynchronizationFactory. However, the statementsToConvertColumnType that I added to the update OpenBaseSynchronizationFactory isn't called. This makes me think it is still referencing the OpenBasePlugIn that is part of the WO 5.4.3 distribution. App launch fails with: “Your EOSynchronizationFactory does not support the required 'convert column type' operation. Any thoughts on why the newer plugin with changes might not be getting called? Is it possible that migrations are running before the newer plugin is loaded into the classpath? Tim UCLA GSEIS On May 28, 2014, at 1:42 PM, Chuck Hill ch...@global-village.net wrote: The replacement plugins are in ERExtensions which is forced into the class path before any of the WO frameworks. As such any classes that they contain that have the same package and class names as in WO proper will render the original classes invisible to the JVM. Chuck On 2014-05-28, 1:13 PM, David Avendasora wrote: All of the other PlugIns (Oracle excluded) seem to use the same name as the one included in the WO binaries, but I do see your point about it possibly causing confusion for all the WO developers out there using OpenBase. … … … snk. snrk. cough. cough… Okay, seriously though, I think it would be best to use the expected name (OpenBasePlugIn) and use the same mechanisms that the other DB plugins use to keep there from being conflicts. Now, let me get back to my servlet-based D2JC project with vertical inheritance and sharedEC on SQLServer. Which reminds me, somewhere around here I have Chuck’s MicrosoftPlugIn… I should look at updating that and getting it into Wonder, too - as I promised I would … a couple years ago. :-) Dave On May 28, 2014, at 12:27 PM, Timothy Worman li...@thetimmy.com wrote: I received permission to include a modified OpenBasePlugIn into Wonder. Thought I’d open this up to a best practice discussion here. Since the original plugin was bundled with the WO frameworks, my assumption is that the plugin class should be renamed - sth like EROpenBasePlugIn? By doing so we could eliminate any possible confusion. It was communicated to me that the plugin was an enhanced version of the one that shipped with WO. I have modified it to correct immediate issues with migrations in Wonder (including updates to WO 5.4 synchronization classes). This would also make it somewhat dependent on a version of Wonder that has been updated in the same fashion - which I also have and, if it passes muster, could be pulled into Wonder as well. Tim UCLA GSEIS ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com This email sent to webobje...@avendasora.com — WebObjects - so easy that even Dave Avendasora can do it!™ — David Avendasora Senior Software Abuser Nekesto, Inc. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net This email sent to ch...@global-village.net ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Wonder addition - updated openbase plugin
This is solved. I had to make sure to order the newer, modified OpenBaseWOPKPlugIn framework above the EOAccess framework in the build path. Tim UCLA GSEIS On Jun 9, 2014, at 2:28 PM, Timothy Worman li...@thetimmy.com wrote: Hola from CA: Following up and looking for advice on this. I did follow this approach (below) for naming of the OpenBasePlugIn class. I’ve added some new expressions to the OpenBaseSynchronization factory to support functions that are missing for migrations. So, in a migration where you alter the column type, you’d call this: ERXMigrationColumn.setDataType(). In that method are these calls: EOSchemaSynchronization schemaSynchronization = (EOSchemaSynchronization) _table.database().synchronizationFactory(); NSArrayEOSQLExpression expressions = schemaSynchronization.statementsToConvertColumnType(_name, _table.name(), null, new _ColumnType(externalType, scale, precision, width), options); The sync factory that is returned is an instance of OpenBasePlugIn$OpenBaseSynchronizationFactory. However, the statementsToConvertColumnType that I added to the update OpenBaseSynchronizationFactory isn't called. This makes me think it is still referencing the OpenBasePlugIn that is part of the WO 5.4.3 distribution. App launch fails with: “Your EOSynchronizationFactory does not support the required 'convert column type' operation. Any thoughts on why the newer plugin with changes might not be getting called? Is it possible that migrations are running before the newer plugin is loaded into the classpath? Tim UCLA GSEIS On May 28, 2014, at 1:42 PM, Chuck Hill ch...@global-village.net wrote: The replacement plugins are in ERExtensions which is forced into the class path before any of the WO frameworks. As such any classes that they contain that have the same package and class names as in WO proper will render the original classes invisible to the JVM. Chuck On 2014-05-28, 1:13 PM, David Avendasora wrote: All of the other PlugIns (Oracle excluded) seem to use the same name as the one included in the WO binaries, but I do see your point about it possibly causing confusion for all the WO developers out there using OpenBase. … … … snk. snrk. cough. cough… Okay, seriously though, I think it would be best to use the expected name (OpenBasePlugIn) and use the same mechanisms that the other DB plugins use to keep there from being conflicts. Now, let me get back to my servlet-based D2JC project with vertical inheritance and sharedEC on SQLServer. Which reminds me, somewhere around here I have Chuck’s MicrosoftPlugIn… I should look at updating that and getting it into Wonder, too - as I promised I would … a couple years ago. :-) Dave On May 28, 2014, at 12:27 PM, Timothy Worman li...@thetimmy.com wrote: I received permission to include a modified OpenBasePlugIn into Wonder. Thought I’d open this up to a best practice discussion here. Since the original plugin was bundled with the WO frameworks, my assumption is that the plugin class should be renamed - sth like EROpenBasePlugIn? By doing so we could eliminate any possible confusion. It was communicated to me that the plugin was an enhanced version of the one that shipped with WO. I have modified it to correct immediate issues with migrations in Wonder (including updates to WO 5.4 synchronization classes). This would also make it somewhat dependent on a version of Wonder that has been updated in the same fashion - which I also have and, if it passes muster, could be pulled into Wonder as well. Tim UCLA GSEIS ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com This email sent to webobje...@avendasora.com — WebObjects - so easy that even Dave Avendasora can do it!™ — David Avendasora Senior Software Abuser Nekesto, Inc. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net This email sent to ch...@global-village.net ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com This email sent to li...@thetimmy.com ___ Do not post admin requests
Wonder addition - updated openbase plugin
I received permission to include a modified OpenBasePlugIn into Wonder. Thought I’d open this up to a best practice discussion here. Since the original plugin was bundled with the WO frameworks, my assumption is that the plugin class should be renamed - sth like EROpenBasePlugIn? By doing so we could eliminate any possible confusion. It was communicated to me that the plugin was an enhanced version of the one that shipped with WO. I have modified it to correct immediate issues with migrations in Wonder (including updates to WO 5.4 synchronization classes). This would also make it somewhat dependent on a version of Wonder that has been updated in the same fashion - which I also have and, if it passes muster, could be pulled into Wonder as well. Tim UCLA GSEIS ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Wonder addition - updated openbase plugin
All of the other PlugIns (Oracle excluded) seem to use the same name as the one included in the WO binaries, but I do see your point about it possibly causing confusion for all the WO developers out there using OpenBase. … … … snk. snrk. cough. cough… Okay, seriously though, I think it would be best to use the expected name (OpenBasePlugIn) and use the same mechanisms that the other DB plugins use to keep there from being conflicts. Now, let me get back to my servlet-based D2JC project with vertical inheritance and sharedEC on SQLServer. Which reminds me, somewhere around here I have Chuck’s MicrosoftPlugIn… I should look at updating that and getting it into Wonder, too - as I promised I would … a couple years ago. :-) Dave On May 28, 2014, at 12:27 PM, Timothy Worman li...@thetimmy.com wrote: I received permission to include a modified OpenBasePlugIn into Wonder. Thought I’d open this up to a best practice discussion here. Since the original plugin was bundled with the WO frameworks, my assumption is that the plugin class should be renamed - sth like EROpenBasePlugIn? By doing so we could eliminate any possible confusion. It was communicated to me that the plugin was an enhanced version of the one that shipped with WO. I have modified it to correct immediate issues with migrations in Wonder (including updates to WO 5.4 synchronization classes). This would also make it somewhat dependent on a version of Wonder that has been updated in the same fashion - which I also have and, if it passes muster, could be pulled into Wonder as well. Tim UCLA GSEIS ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com This email sent to webobje...@avendasora.com — WebObjects - so easy that even Dave Avendasora can do it!™ — David Avendasora Senior Software Abuser Nekesto, Inc. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Wonder addition - updated openbase plugin
The replacement plugins are in ERExtensions which is forced into the class path before any of the WO frameworks. As such any classes that they contain that have the same package and class names as in WO proper will render the original classes invisible to the JVM. Chuck On 2014-05-28, 1:13 PM, David Avendasora wrote: All of the other PlugIns (Oracle excluded) seem to use the same name as the one included in the WO binaries, but I do see your point about it possibly causing confusion for all the WO developers out there using OpenBase. … … … snk. snrk. cough. cough… Okay, seriously though, I think it would be best to use the expected name (OpenBasePlugIn) and use the same mechanisms that the other DB plugins use to keep there from being conflicts. Now, let me get back to my servlet-based D2JC project with vertical inheritance and sharedEC on SQLServer. Which reminds me, somewhere around here I have Chuck’s MicrosoftPlugIn… I should look at updating that and getting it into Wonder, too - as I promised I would … a couple years ago. :-) Dave On May 28, 2014, at 12:27 PM, Timothy Worman li...@thetimmy.commailto:li...@thetimmy.com wrote: I received permission to include a modified OpenBasePlugIn into Wonder. Thought I’d open this up to a best practice discussion here. Since the original plugin was bundled with the WO frameworks, my assumption is that the plugin class should be renamed - sth like EROpenBasePlugIn? By doing so we could eliminate any possible confusion. It was communicated to me that the plugin was an enhanced version of the one that shipped with WO. I have modified it to correct immediate issues with migrations in Wonder (including updates to WO 5.4 synchronization classes). This would also make it somewhat dependent on a version of Wonder that has been updated in the same fashion - which I also have and, if it passes muster, could be pulled into Wonder as well. Tim UCLA GSEIS ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.commailto:Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com This email sent to webobje...@avendasora.commailto:webobje...@avendasora.com — WebObjects - so easy that even Dave Avendasora can do it!™ — David Avendasora Senior Software Abuser Nekesto, Inc. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.commailto:Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net This email sent to ch...@global-village.netmailto:ch...@global-village.net ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
openbase
Anyone using OpenBase db system here? How is the reliability? Are you running on Mac or Linux? Michael Kondratov ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: openbase
Michael: I use OpenBase at UCLA and have for 10 years. Currently, our server uses version 11 I believe. OpenBase has always been very solid for us. We’ve always run it on Mac OS X (and have no experience with OB on Linux). On a side note, I’m currently working on addressing some issues with Wonder migrations and OpenBase. Tim UCLA GSES On May 27, 2014, at 8:50 PM, Michael Kondratov mich...@aspireauctions.com wrote: Anyone using OpenBase db system here? How is the reliability? Are you running on Mac or Linux? Michael Kondratov ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com This email sent to li...@thetimmy.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
failed to open database channel: Openbase
Hi All, I am trying to set up a new machine OSX 10.9 Openbase 12 Eclipse 3.8.2 Wonder Frameworks I have managed to import my existing application and it compile and build successfully, but when I run my application from eclipse the application is unable to connect to the database with the following log excerpt: ... 3621 [main] WARN NSLog - An exception occurred while trying to open a channel: N/A 3621 [main] INFO er.transaction.adaptor.Exceptions - Database Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open database channel. Check your connection dictionary, and ensure your database is correctly configured. OpenBasePlugIn is loaded... 3634 [main] INFO er.extensions.eof.ERXDatabaseContextDelegate - ams: {plugin = com.webobjects.jdbcadaptor.OpenBasePKPlugIn; username = admin; driver = com.openbase.jdbc.ObDriver; password = password deleted for log; URL = jdbc:openbase://127.0.0.1/Test; } 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer - Checking JDBC connection with information {plugin = com.webobjects.jdbcadaptor.OpenBasePKPlugIn; username = admin; driver = com.openbase.jdbc.ObDriver; password = password deleted for log; URL = jdbc:openbase://127.0.0.1/Test; } 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer - Trying to create JDBCAdaptor... 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer - Successfully created adaptor com.webobjects.jdbcadaptor.JDBCAdaptor 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer - Trying to create plugin... OpenBasePlugIn is loaded... 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer - Created plugin com.webobjects.jdbcadaptor.OpenBasePKPlugIn 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer - Trying to load JDBC driver com.openbase.jdbc.ObDriver... 3637 [main] INFO er.transaction.adaptor.ConnectionAnalyzer - Successfully loaded JDBC driver com.openbase.jdbc.ObDriver 3637 [main] INFO er.transaction.adaptor.ConnectionAnalyzer - JDBC driver and plugin are loaded, trying to connect... 3638 [main] INFO er.transaction.adaptor.ConnectionAnalyzer - Error: Exception thrown while connecting. Check exception message carefully. 3640 [main] ERROR er.transaction.adaptor.ConnectionAnalyzer - No connection. 3640 [main] WARN NSLog - A fatal exception occurred: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open database channel. Check your connection dictionary, and ensure your database is correctly configured. [2014-1-1 14:12:26 CST] main java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open database channel. Check your connection dictionary, and ensure your database is correctly configured. at com.webobjects.eoaccess.EODatabaseContext._obtainOpenChannel(EODatabaseContext.java:1967) at com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3054) . I have tried localhost and 127.0.0.1 combinations I have tried both restored database and a completely new database I can connect from the command line using openisql_ascii I have no knowledge of jdbc, nor how to test a jdbc connection Can anyone offer any suggestions? Thanks in advance Shelley ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Anybody have a running OpenBase server?
I need to deploy an existing db for some data forensics/recovery work that'll take about a day, tops. Willing to pay reasonable fees. Inbox me; thanks. Bill ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Anybody have a running OpenBase server?
Version? Sent from my iPhone On 01/giu/2012, at 00:06, William Hatch wkha...@me.com wrote: I need to deploy an existing db for some data forensics/recovery work that'll take about a day, tops. Willing to pay reasonable fees. Inbox me; thanks. Bill ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/amedeomantica%40me.com This email sent to amedeomant...@me.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11?
Thank you for your help Tim. I follow all steps, including the last one to install Project Wonder from the tutorials, but when I try to create a new Wonder Application project I still got these errors. I'm not sure what to do. Any thoughts? Any help is much appreciated. Thank you Catalin Cretu From: Tim Worman li...@thetimmy.com To: Cretu Catalin catacr...@yahoo.com Cc: Paul Yu p...@mac.com; jazz jazzsa...@me.com; webobjects-dev@lists.apple.com webobjects-dev@lists.apple.com Sent: Thursday, March 1, 2012 8:58:07 PM Subject: Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11? Catalin: It sounds as if you have Eclipse/WOLips installed but have not installed the Project Wonder frameworks. The New Wonder Application is going to require Wonder to be installed on your system whereas a generic WebObjects application does not. You definitely want to create a Wonder Application. In case you missed some steps, here are the instructions for installing the entire tool stack for developing Wonder applications. http://wiki.wocommunity.org/display/WONDER/Project+Wonder+Installation From that page - Overview of Steps: - install Eclipse (if necessary) - install WOLips Plugins for Eclipse - install WebObjects frameworks and configure WOLips - install Project Wonder and import into your workspace Tim On Mar 1, 2012, at 5:41 PM, Cretu Catalin catacr...@yahoo.com wrote: Hello Tim, I followed all instructions, but when I tried to create first Wonder Application project I got errors. But when I create a new WebObjects application project there are no error. What resins can be? Only when I create a new Wonder Application project I got these errors in console: Description Resource Path Location Type The project cannot be built until build path errors are resolved OneTester Unknown Java Problem Unbound classpath container: 'ERExtensions WebObjects Framework' in project 'OneTester' OneTester Build path Build Path Problem Unbound classpath container: 'ERJars WebObjects Framework' in project 'OneTester' OneTester Build path Build Path Problem Unbound classpath container: 'ERPrototypes WebObjects Framework' in project 'OneTester' OneTester Build path Build Path Problem Unbound classpath container: 'WOOgnl WebObjects Framework' in project 'OneTester' OneTester Build path Build Path Problem Any thoughts? Thank you in advance for your time and help. Catalin From: Tim Worman li...@thetimmy.com To: Cretu Catalin catacr...@yahoo.com Cc: Paul Yu p...@mac.com; jazz jazzsa...@me.com; webobjects-dev@lists.apple.com webobjects-dev@lists.apple.com Sent: Tuesday, February 28, 2012 2:15:26 PM Subject: Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11? Cretu: The instructions for installing the development tools are the same regardless of whether it is 10.6 or 10.7. http://wiki.wocommunity.org/display/WONDER/Getting+Started Tutorials for WOLips are here: http://wiki.wocommunity.org/display/WOL/Tutorials Tim On Feb 28, 2012, at 10:08 AM, Cretu Catalin catacr...@yahoo.com wrote: Hello Paul, Is there a tutorial for updating for Mac 10.7? Thank you Catalin Cretu From: Paul Yu p...@mac.com To: jazz jazzsa...@me.com Cc: webobjects-dev@lists.apple.com Sent: Tuesday, February 28, 2012 12:12:04 PM Subject: Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11? Bart You should upgrade to the latest WO and Wonder. I know it may not be easy, but life will be much better afterwards. The rest of us are already very nervous about being left behind by Apple at 5.4+, so you're not going to get a lot of love back there on 5.3... -- Paul Yu Sent with Sparrow On Tuesday, February 28, 2012 at 11:43 AM, jazz wrote: Hi, I am running Webobjects from Mac OS 10.4 using OpenBase 8. Importing large txt files into the database crash the application. Is it possible to update to OpenBase 11? Or will the compatibility with Xcode 2.1 / WebObjects 5.3 break? In general it would be nice to know who is developing for Webobjects in 10.4. I read a lot about Eclipse in the mailing list but not so much about the original Webobjects/Xcode environment. Thanks for your help! Best regards, Bart ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com This email sent to p...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription
Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11?
Hello Tim, I followed all instructions, but when I tried to create first Wonder Application project I got errors. But when I create a new WebObjects application project there are no error. What resins can be? Only when I create a new Wonder Application project I got these errors in console: DescriptionResourcePathLocationType The project cannot be built until build path errors are resolvedOneTesterUnknownJava Problem Unbound classpath container: 'ERExtensions WebObjects Framework' in project 'OneTester'OneTesterBuild pathBuild Path Problem Unbound classpath container: 'ERJars WebObjects Framework' in project 'OneTester'OneTesterBuild pathBuild Path Problem Unbound classpath container: 'ERPrototypes WebObjects Framework' in project 'OneTester'OneTesterBuild pathBuild Path Problem Unbound classpath container: 'WOOgnl WebObjects Framework' in project 'OneTester'OneTesterBuild pathBuild Path Problem Any thoughts? Thank you in advance for your time and help. Catalin From: Tim Worman li...@thetimmy.com To: Cretu Catalin catacr...@yahoo.com Cc: Paul Yu p...@mac.com; jazz jazzsa...@me.com; webobjects-dev@lists.apple.com webobjects-dev@lists.apple.com Sent: Tuesday, February 28, 2012 2:15:26 PM Subject: Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11? Cretu: The instructions for installing the development tools are the same regardless of whether it is 10.6 or 10.7. http://wiki.wocommunity.org/display/WONDER/Getting+Started Tutorials for WOLips are here: http://wiki.wocommunity.org/display/WOL/Tutorials Tim On Feb 28, 2012, at 10:08 AM, Cretu Catalin catacr...@yahoo.com wrote: Hello Paul, Is there a tutorial for updating for Mac 10.7? Thank you Catalin Cretu From: Paul Yu p...@mac.com To: jazz jazzsa...@me.com Cc: webobjects-dev@lists.apple.com Sent: Tuesday, February 28, 2012 12:12:04 PM Subject: Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11? Bart You should upgrade to the latest WO and Wonder. I know it may not be easy, but life will be much better afterwards. The rest of us are already very nervous about being left behind by Apple at 5.4+, so you're not going to get a lot of love back there on 5.3... -- Paul Yu Sent with Sparrow On Tuesday, February 28, 2012 at 11:43 AM, jazz wrote: Hi, I am running Webobjects from Mac OS 10.4 using OpenBase 8. Importing large txt files into the database crash the application. Is it possible to update to OpenBase 11? Or will the compatibility with Xcode 2.1 / WebObjects 5.3 break? In general it would be nice to know who is developing for Webobjects in 10.4. I read a lot about Eclipse in the mailing list but not so much about the original Webobjects/Xcode environment. Thanks for your help! Best regards, Bart ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com This email sent to p...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/catacretu%40yahoo.com This email sent to catacr...@yahoo.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com This email sent to li...@thetimmy.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11?
Catalin: It sounds as if you have Eclipse/WOLips installed but have not installed the Project Wonder frameworks. The New Wonder Application is going to require Wonder to be installed on your system whereas a generic WebObjects application does not. You definitely want to create a Wonder Application. In case you missed some steps, here are the instructions for installing the entire tool stack for developing Wonder applications. http://wiki.wocommunity.org/display/WONDER/Project+Wonder+Installation From that page - Overview of Steps: - install Eclipse (if necessary) - install WOLips Plugins for Eclipse - install WebObjects frameworks and configure WOLips - install Project Wonder and import into your workspace Tim On Mar 1, 2012, at 5:41 PM, Cretu Catalin catacr...@yahoo.com wrote: Hello Tim, I followed all instructions, but when I tried to create first Wonder Application project I got errors. But when I create a new WebObjects application project there are no error. What resins can be? Only when I create a new Wonder Application project I got these errors in console: Description ResourcePathLocationType The project cannot be built until build path errors are resolved OneTester Unknown Java Problem Unbound classpath container: 'ERExtensions WebObjects Framework' in project 'OneTester' OneTester Build path Build Path Problem Unbound classpath container: 'ERJars WebObjects Framework' in project 'OneTester' OneTester Build path Build Path Problem Unbound classpath container: 'ERPrototypes WebObjects Framework' in project 'OneTester' OneTester Build path Build Path Problem Unbound classpath container: 'WOOgnl WebObjects Framework' in project 'OneTester' OneTester Build path Build Path Problem Any thoughts? Thank you in advance for your time and help. Catalin From: Tim Worman li...@thetimmy.com To: Cretu Catalin catacr...@yahoo.com Cc: Paul Yu p...@mac.com; jazz jazzsa...@me.com; webobjects-dev@lists.apple.com webobjects-dev@lists.apple.com Sent: Tuesday, February 28, 2012 2:15:26 PM Subject: Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11? Cretu: The instructions for installing the development tools are the same regardless of whether it is 10.6 or 10.7. http://wiki.wocommunity.org/display/WONDER/Getting+Started Tutorials for WOLips are here: http://wiki.wocommunity.org/display/WOL/Tutorials Tim On Feb 28, 2012, at 10:08 AM, Cretu Catalin catacr...@yahoo.com wrote: Hello Paul, Is there a tutorial for updating for Mac 10.7? Thank you Catalin Cretu From: Paul Yu p...@mac.com To: jazz jazzsa...@me.com Cc: webobjects-dev@lists.apple.com Sent: Tuesday, February 28, 2012 12:12:04 PM Subject: Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11? Bart You should upgrade to the latest WO and Wonder. I know it may not be easy, but life will be much better afterwards. The rest of us are already very nervous about being left behind by Apple at 5.4+, so you're not going to get a lot of love back there on 5.3... -- Paul Yu Sent with Sparrow On Tuesday, February 28, 2012 at 11:43 AM, jazz wrote: Hi, I am running Webobjects from Mac OS 10.4 using OpenBase 8. Importing large txt files into the database crash the application. Is it possible to update to OpenBase 11? Or will the compatibility with Xcode 2.1 / WebObjects 5.3 break? In general it would be nice to know who is developing for Webobjects in 10.4. I read a lot about Eclipse in the mailing list but not so much about the original Webobjects/Xcode environment. Thanks for your help! Best regards, Bart ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com This email sent to p...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/catacretu%40yahoo.com This email sent to catacr...@yahoo.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com This email sent to li...@thetimmy.com ___ Do not post admin requests to the list
WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11?
Hi, I am running Webobjects from Mac OS 10.4 using OpenBase 8. Importing large txt files into the database crash the application. Is it possible to update to OpenBase 11? Or will the compatibility with Xcode 2.1 / WebObjects 5.3 break? In general it would be nice to know who is developing for Webobjects in 10.4. I read a lot about Eclipse in the mailing list but not so much about the original Webobjects/Xcode environment. Thanks for your help! Best regards, Bart ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11?
Bart You should upgrade to the latest WO and Wonder. I know it may not be easy, but life will be much better afterwards. The rest of us are already very nervous about being left behind by Apple at 5.4+, so you're not going to get a lot of love back there on 5.3... -- Paul Yu Sent with Sparrow (http://www.sparrowmailapp.com/?sig) On Tuesday, February 28, 2012 at 11:43 AM, jazz wrote: Hi, I am running Webobjects from Mac OS 10.4 using OpenBase 8. Importing large txt files into the database crash the application. Is it possible to update to OpenBase 11? Or will the compatibility with Xcode 2.1 / WebObjects 5.3 break? In general it would be nice to know who is developing for Webobjects in 10.4. I read a lot about Eclipse in the mailing list but not so much about the original Webobjects/Xcode environment. Thanks for your help! Best regards, Bart ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com (mailto:Webobjects-dev@lists.apple.com)) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com This email sent to p...@mac.com (mailto:p...@mac.com) ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11?
Hello Paul, Is there a tutorial for updating for Mac 10.7? Thank you Catalin Cretu From: Paul Yu p...@mac.com To: jazz jazzsa...@me.com Cc: webobjects-dev@lists.apple.com Sent: Tuesday, February 28, 2012 12:12:04 PM Subject: Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11? Bart You should upgrade to the latest WO and Wonder. I know it may not be easy, but life will be much better afterwards. The rest of us are already very nervous about being left behind by Apple at 5.4+, so you're not going to get a lot of love back there on 5.3... -- Paul Yu Sent with Sparrow On Tuesday, February 28, 2012 at 11:43 AM, jazz wrote: Hi, I am running Webobjects from Mac OS 10.4 using OpenBase 8. Importing large txt files into the database crash the application. Is it possible to update to OpenBase 11? Or will the compatibility with Xcode 2.1 / WebObjects 5.3 break? In general it would be nice to know who is developing for Webobjects in 10.4. I read a lot about Eclipse in the mailing list but not so much about the original Webobjects/Xcode environment. Thanks for your help! Best regards, Bart ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com This email sent to p...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/catacretu%40yahoo.com This email sent to catacr...@yahoo.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11?
+1 to what Paul said. The connection to the database is abstracted so as long as you have the appropriate driver I don't really see where there would be a compatibility issue between a version of OpenBase and your development tools. The question is, does OpenBase 11 run on Tiger. I don't know. It does run fine on 10.6+. Tim On Feb 28, 2012, at 9:12 AM, Paul Yu p...@mac.com wrote: Bart You should upgrade to the latest WO and Wonder. I know it may not be easy, but life will be much better afterwards. The rest of us are already very nervous about being left behind by Apple at 5.4+, so you're not going to get a lot of love back there on 5.3... -- Paul Yu Sent with Sparrow On Tuesday, February 28, 2012 at 11:43 AM, jazz wrote: Hi, I am running Webobjects from Mac OS 10.4 using OpenBase 8. Importing large txt files into the database crash the application. Is it possible to update to OpenBase 11? Or will the compatibility with Xcode 2.1 / WebObjects 5.3 break? In general it would be nice to know who is developing for Webobjects in 10.4. I read a lot about Eclipse in the mailing list but not so much about the original Webobjects/Xcode environment. Thanks for your help! Best regards, Bart ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com This email sent to p...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com This email sent to li...@thetimmy.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11?
Cretu: The instructions for installing the development tools are the same regardless of whether it is 10.6 or 10.7. http://wiki.wocommunity.org/display/WONDER/Getting+Started Tutorials for WOLips are here: http://wiki.wocommunity.org/display/WOL/Tutorials Tim On Feb 28, 2012, at 10:08 AM, Cretu Catalin catacr...@yahoo.com wrote: Hello Paul, Is there a tutorial for updating for Mac 10.7? Thank you Catalin Cretu From: Paul Yu p...@mac.com To: jazz jazzsa...@me.com Cc: webobjects-dev@lists.apple.com Sent: Tuesday, February 28, 2012 12:12:04 PM Subject: Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11? Bart You should upgrade to the latest WO and Wonder. I know it may not be easy, but life will be much better afterwards. The rest of us are already very nervous about being left behind by Apple at 5.4+, so you're not going to get a lot of love back there on 5.3... -- Paul Yu Sent with Sparrow On Tuesday, February 28, 2012 at 11:43 AM, jazz wrote: Hi, I am running Webobjects from Mac OS 10.4 using OpenBase 8. Importing large txt files into the database crash the application. Is it possible to update to OpenBase 11? Or will the compatibility with Xcode 2.1 / WebObjects 5.3 break? In general it would be nice to know who is developing for Webobjects in 10.4. I read a lot about Eclipse in the mailing list but not so much about the original Webobjects/Xcode environment. Thanks for your help! Best regards, Bart ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com This email sent to p...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/catacretu%40yahoo.com This email sent to catacr...@yahoo.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com This email sent to li...@thetimmy.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11?
There were instructions on porting from Xcode to WOLips on the web, but if I were to do the project, I would: 1) Create new WOnder based Frameworks and Application. 2) Manually move the EOModel, do the eogenerate thing; move the EO business logic into the new Models framework. 3) Manually move/copy the Components into the application. I would change the WOD bindings to be OGNL inline bindings. Something like that. -- Paul Yu Sent with Sparrow (http://www.sparrowmailapp.com/?sig) On Tuesday, February 28, 2012 at 2:15 PM, Tim Worman wrote: Cretu: The instructions for installing the development tools are the same regardless of whether it is 10.6 or 10.7. http://wiki.wocommunity.org/display/WONDER/Getting+Started Tutorials for WOLips are here: http://wiki.wocommunity.org/display/WOL/Tutorials Tim On Feb 28, 2012, at 10:08 AM, Cretu Catalin catacr...@yahoo.com (mailto:catacr...@yahoo.com) wrote: Hello Paul, Is there a tutorial for updating for Mac 10.7? Thank you Catalin Cretu From: Paul Yu p...@mac.com (mailto:p...@mac.com) To: jazz jazzsa...@me.com (mailto:jazzsa...@me.com) Cc: webobjects-dev@lists.apple.com (mailto:webobjects-dev@lists.apple.com) Sent: Tuesday, February 28, 2012 12:12:04 PM Subject: Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11? Bart You should upgrade to the latest WO and Wonder. I know it may not be easy, but life will be much better afterwards. The rest of us are already very nervous about being left behind by Apple at 5.4+, so you're not going to get a lot of love back there on 5.3... -- Paul Yu Sent with Sparrow On Tuesday, February 28, 2012 at 11:43 AM, jazz wrote: Hi, I am running Webobjects from Mac OS 10.4 using OpenBase 8. Importing large txt files into the database crash the application. Is it possible to update to OpenBase 11? Or will the compatibility with Xcode 2.1 / WebObjects 5.3 break? In general it would be nice to know who is developing for Webobjects in 10.4. I read a lot about Eclipse in the mailing list but not so much about the original Webobjects/Xcode environment. Thanks for your help! Best regards, Bart ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com (mailto:Webobjects-dev@lists.apple.com)) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com This email sent to p...@mac.com (mailto:p...@mac.com) ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com (mailto:Webobjects-dev@lists.apple.com)) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/catacretu%40yahoo.com This email sent to catacr...@yahoo.com (mailto:catacr...@yahoo.com) ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com (mailto:Webobjects-dev@lists.apple.com)) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com This email sent to li...@thetimmy.com (mailto:li...@thetimmy.com) ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11?
For the OS, you will have to upgrade from 10.4 to 10.6, and after to 10.7 (you better off re-installing the OS…). For the Xcode to Eclipse migration, which the vast majority of us did, you can look at the wiki: http://wiki.wocommunity.org/display/WOL/Upgrading+to+WOLips+from+Xcode+or+Project+Builder As for OpenBase, look like it can run on 10.4. http://www.openbase.com/index.php/products/whatsnew 32-bit versions of OpenBase SQL 11 are also provided for Mac OS X 10.4 compatibility. But really, you should move to at least OS X 10.6 and use Eclipse + WOLips. You might miss WO Builder first, but you will appreciate the workflow after a couple of weeks. And Eclipse is a much better Java IDE than Xcode. Hello Paul, Is there a tutorial for updating for Mac 10.7? Thank you Catalin Cretu From: Paul Yu p...@mac.com To: jazz jazzsa...@me.com Cc: webobjects-dev@lists.apple.com Sent: Tuesday, February 28, 2012 12:12:04 PM Subject: Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11? Bart You should upgrade to the latest WO and Wonder. I know it may not be easy, but life will be much better afterwards. The rest of us are already very nervous about being left behind by Apple at 5.4+, so you're not going to get a lot of love back there on 5.3... -- Paul Yu Sent with Sparrow On Tuesday, February 28, 2012 at 11:43 AM, jazz wrote: Hi, I am running Webobjects from Mac OS 10.4 using OpenBase 8. Importing large txt files into the database crash the application. Is it possible to update to OpenBase 11? Or will the compatibility with Xcode 2.1 / WebObjects 5.3 break? In general it would be nice to know who is developing for Webobjects in 10.4. I read a lot about Eclipse in the mailing list but not so much about the original Webobjects/Xcode environment. Thanks for your help! Best regards, Bart ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com This email sent to p...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/catacretu%40yahoo.com This email sent to catacr...@yahoo.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca This email sent to prob...@macti.ca ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11?
On Feb 28, 2012, at 11:54 AM, Tim Worman wrote: +1 to what Paul said. I'm not nervous :-) I just wish Apple would APSL the rest of the frameworks like they did with JavaWOExtensions, JavaMonitor, wotaskd, and the cgi adaptors. The connection to the database is abstracted so as long as you have the appropriate driver I don't really see where there would be a compatibility issue between a version of OpenBase and your development tools. The question is, does OpenBase 11 run on Tiger. I don't know. It does run fine on 10.6+. Tim If you are using horizontal or vertical inheritance, the OpenBase adaptor in WO 5.4 is busted. It doesn't use primaryKeyRootName when appropriate, so you end up with overlapping keys. I don't know if this was the case in WO 5.4.x. You're probably not even using entity inheritance, but I thought it worth mentioning. Ramsey On Feb 28, 2012, at 9:12 AM, Paul Yu p...@mac.com wrote: Bart You should upgrade to the latest WO and Wonder. I know it may not be easy, but life will be much better afterwards. The rest of us are already very nervous about being left behind by Apple at 5.4+, so you're not going to get a lot of love back there on 5.3... -- Paul Yu Sent with Sparrow On Tuesday, February 28, 2012 at 11:43 AM, jazz wrote: Hi, I am running Webobjects from Mac OS 10.4 using OpenBase 8. Importing large txt files into the database crash the application. Is it possible to update to OpenBase 11? Or will the compatibility with Xcode 2.1 / WebObjects 5.3 break? In general it would be nice to know who is developing for Webobjects in 10.4. I read a lot about Eclipse in the mailing list but not so much about the original Webobjects/Xcode environment. Thanks for your help! Best regards, Bart ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com This email sent to p...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com This email sent to li...@thetimmy.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com This email sent to rgur...@smarthealth.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WebObjects 5.3 on 10.4 compatible with OpenBase SQL 11?
Le 2012-02-28 à 14:48, Tim Worman a écrit : Sorry, my emails to the list were delivered out of order due to the up and down network at Starbucks. :-) That's not you, it's lists.apple.com who is delaying mail delivery, again... Tim On Feb 28, 2012, at 10:54 AM, Tim Worman li...@thetimmy.com wrote: +1 to what Paul said. The connection to the database is abstracted so as long as you have the appropriate driver I don't really see where there would be a compatibility issue between a version of OpenBase and your development tools. The question is, does OpenBase 11 run on Tiger. I don't know. It does run fine on 10.6+. Tim On Feb 28, 2012, at 9:12 AM, Paul Yu p...@mac.com wrote: Bart You should upgrade to the latest WO and Wonder. I know it may not be easy, but life will be much better afterwards. The rest of us are already very nervous about being left behind by Apple at 5.4+, so you're not going to get a lot of love back there on 5.3... -- Paul Yu Sent with Sparrow On Tuesday, February 28, 2012 at 11:43 AM, jazz wrote: Hi, I am running Webobjects from Mac OS 10.4 using OpenBase 8. Importing large txt files into the database crash the application. Is it possible to update to OpenBase 11? Or will the compatibility with Xcode 2.1 / WebObjects 5.3 break? In general it would be nice to know who is developing for Webobjects in 10.4. I read a lot about Eclipse in the mailing list but not so much about the original Webobjects/Xcode environment. Thanks for your help! Best regards, Bart ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com This email sent to p...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com This email sent to li...@thetimmy.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com This email sent to li...@thetimmy.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca This email sent to prob...@macti.ca ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Debugging db exception with Openbase and raw rows date type
Why did you upgrade the export app?? Can you write an OpenBase stored procedure to do the export? André On 2010-08-27, at 11:46 AM, William Hatch wrote: The app that inputs the data runs on an older version of wo; 5.3.x ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Debugging db exception with Openbase and raw rows date type
On Aug 26, 2010, at 12:14 PM, William Hatch wrote: I hope this is on topic enough; OB list seems to be dead. I've got a utility app using latest wo and wonder, openbase db, that performs raw fetches to then bulk export data in csv. Basically a simple data export/dumper thing. This had been working perfectly for a long time, but a recent run resulted in the following exception, thrown during the call to EOUtilities.rawRowsForSQL(...) : What exception happens here? at java.sql.Date.valueOf(Date.java:138) at com.openbase.jdbc.f.getDate(null:Unknown) at com.webobjects.jdbcadaptor.JDBCColumn._fetchCorrectObject(JDBCColumn.java:288) at com.webobjects.jdbcadaptor.JDBCColumn._fetchValue(JDBCColumn.java:384) at com.webobjects.jdbcadaptor.JDBCColumn.fetchValue(JDBCColumn.java:372) ... skipped 1 stack elements at com.webobjects.eoaccess.EOUtilities._rawRowsForSQL(EOUtilities.java:636) at com.webobjects.eoaccess.EOUtilities.rawRowsForSQL(EOUtilities.java:588) at com.imapp.eo.Judgement.rawRows(Judgement.java:53) at com.imapp.tasks.JudgementTask.performAction(JudgementTask.java:26) at er.extensions.ERXLongResponseTask$DefaultImplementation.run(ERXLongResponseTask.java:162) ... skipped 1 stack elements at er.extensions.ERXLongResponseTask$WorkerThread.run(ERXLongResponseTask.java:60) which to me, indicates a problem with a date column within the entity referred to. I got around this particular problem by doing some raw queries and identifying and deleting row with bad date values, and the problem vanished. Then it came up again on another table, again with a date type, but this time I'm unable to find any bad data via direct queries. I debugged around my action by setting a breakpoint in the catch block, but that's not helping much. I'm looking for some advice on how to determine and fix, or at least work around the real issue. Anybody else seen this before? Thanks. Is there old jdbc2info in the model? Is the JDBC driver current? Has it changed? Are you using prototypes? How are dates defined? What is the column type in the model? Chuck -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Debugging db exception with Openbase and raw rows date type
Hi Bill, On Aug 27, 2010, at 11:16 AM, William Hatch wrote: On Aug 27, 2010, at 10:52 AM, Chuck Hill wrote: On Aug 26, 2010, at 12:14 PM, William Hatch wrote: I hope this is on topic enough; OB list seems to be dead. I've got a utility app using latest wo and wonder, openbase db, that performs raw fetches to then bulk export data in csv. Basically a simple data export/dumper thing. This had been working perfectly for a long time, but a recent run resulted in the following exception, thrown during the call to EOUtilities.rawRowsForSQL(...) : What exception happens here? Ah sorry, cut it off. It's an IllegalArgumentException immediately above the following output at java.sql.Date.valueOf(Date.java:138) at com.openbase.jdbc.f.getDate(null:Unknown) at com.webobjects.jdbcadaptor.JDBCColumn._fetchCorrectObject(JDBCColumn.java:288) at com.webobjects.jdbcadaptor.JDBCColumn._fetchValue(JDBCColumn.java:384) at com.webobjects.jdbcadaptor.JDBCColumn.fetchValue(JDBCColumn.java:372) ... skipped 1 stack elements at com.webobjects.eoaccess.EOUtilities._rawRowsForSQL(EOUtilities.java:636) at com.webobjects.eoaccess.EOUtilities.rawRowsForSQL(EOUtilities.java:588) at com.imapp.eo.Judgement.rawRows(Judgement.java:53) at com.imapp.tasks.JudgementTask.performAction(JudgementTask.java:26) at er.extensions.ERXLongResponseTask$DefaultImplementation.run(ERXLongResponseTask.java:162) ... skipped 1 stack elements at er.extensions.ERXLongResponseTask$WorkerThread.run(ERXLongResponseTask.java:60) which to me, indicates a problem with a date column within the entity referred to. I got around this particular problem by doing some raw queries and identifying and deleting row with bad date values, and the problem vanished. Then it came up again on another table, again with a date type, but this time I'm unable to find any bad data via direct queries. I debugged around my action by setting a breakpoint in the catch block, but that's not helping much. I'm looking for some advice on how to determine and fix, or at least work around the real issue. Anybody else seen this before? Thanks. Is there old jdbc2info in the model? Is the JDBC driver current? Has it changed? Are you using prototypes? How are dates defined? What is the column type in the model? Not sure how to check for old jdbc2 info in the model Chuck. What should I look for? Look in index.plist (e.g. in a text editor) for the key jdbc2info. The thing is, it always worked, and the project itself hasn't changed. It's a pretty old app, actually. Has the OB version changed? I did upgrade local wonder somewhat recently, but not the other dependent frameworks. I inherited the model a long time ago, and it never used prototypes. It's at least nine years old. The column type in the model is date, Data Type is Date and class is NSTimestamp. Here's the entry for that column in the entities' .plist file: { allowsNull = Y; columnName = saleDate; externalType = date; name = saledate; valueClassName = NSCalendarDate; valueType = D; As in a Date only, no time? All of mine are: valueClassName = NSTimestamp; valueType = T; Using date only values in Java WO is problematic. }, So, I fixed it on one table by querying for bad date ranges after exploring revealed some crazy dates and formats. I did this from openbases's cli tool. But I'm not seeing any bad, or what would appear to be bad, data in the second table. Not sure if it's a data issue, or what. The app that inputs the data runs on an older version of wo; 5.3.x and I've been copying down the db locally every once in a while and running this exporter utility locally. It does sound like bad data, though not a helpful error messages. How does OB manage to get bad data in a date type column? Chuck -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Debugging db exception with Openbase and raw rows date type
On Aug 27, 2010, at 11:46 AM, William Hatch wrote: Hi Chuck, inline below. And more. On Aug 27, 2010, at 11:32 AM, Chuck Hill wrote: Hi Bill, On Aug 27, 2010, at 11:16 AM, William Hatch wrote: On Aug 27, 2010, at 10:52 AM, Chuck Hill wrote: On Aug 26, 2010, at 12:14 PM, William Hatch wrote: I hope this is on topic enough; OB list seems to be dead. I've got a utility app using latest wo and wonder, openbase db, that performs raw fetches to then bulk export data in csv. Basically a simple data export/dumper thing. This had been working perfectly for a long time, but a recent run resulted in the following exception, thrown during the call to EOUtilities.rawRowsForSQL(...) : What exception happens here? Ah sorry, cut it off. It's an IllegalArgumentException immediately above the following output at java.sql.Date.valueOf(Date.java:138) at com.openbase.jdbc.f.getDate(null:Unknown) at com.webobjects.jdbcadaptor.JDBCColumn._fetchCorrectObject(JDBCColumn.java:288) at com.webobjects.jdbcadaptor.JDBCColumn._fetchValue(JDBCColumn.java:384) at com.webobjects.jdbcadaptor.JDBCColumn.fetchValue(JDBCColumn.java:372) ... skipped 1 stack elements at com.webobjects.eoaccess.EOUtilities._rawRowsForSQL(EOUtilities.java:636) at com.webobjects.eoaccess.EOUtilities.rawRowsForSQL(EOUtilities.java:588) at com.imapp.eo.Judgement.rawRows(Judgement.java:53) at com.imapp.tasks.JudgementTask.performAction(JudgementTask.java:26) at er.extensions.ERXLongResponseTask$DefaultImplementation.run(ERXLongResponseTask.java:162) ... skipped 1 stack elements at er.extensions.ERXLongResponseTask$WorkerThread.run(ERXLongResponseTask.java:60) which to me, indicates a problem with a date column within the entity referred to. I got around this particular problem by doing some raw queries and identifying and deleting row with bad date values, and the problem vanished. Then it came up again on another table, again with a date type, but this time I'm unable to find any bad data via direct queries. I debugged around my action by setting a breakpoint in the catch block, but that's not helping much. I'm looking for some advice on how to determine and fix, or at least work around the real issue. Anybody else seen this before? Thanks. Is there old jdbc2info in the model? Is the JDBC driver current? Has it changed? Are you using prototypes? How are dates defined? What is the column type in the model? Not sure how to check for old jdbc2 info in the model Chuck. What should I look for? Look in index.plist (e.g. in a text editor) for the key jdbc2info. Yep, there's some entries in there, a bunch of stuff actually. jdbc2Info = { ANSI92_CONFORMANCE = ANSI92Intermediate; DBMS_NAME = OpenBase; DRIVER_NAME = OpenBase JDBC Driver; DRIVER_VER = 0.14; IDENTIFIER_QUOTE_STRING = ; NON_NULLABLE_COLUMNS = T; STRING_FUNCTIONS = ASCII,CHAR,CONCAT,DIFFERENCE,INSERT,LCASE,LEFT,LENGTH,LOCATE,LTRIM,REPEAT,REPLACE,RIGHT,RTRIM,SOUNDEX,SPACE,SUBSTRING,UCASE; typeInfo = { ... date = { createParams = 0; defaultJDBCType = (DATE); isNullable = T; isSearchable = T; maxScale = 0; minScale = 0; precision = 0; }; If that _is_ the problem (and I doubt that it is based on your other descriptions), deleting this will fix the issue as EOF will re-populate this on connection to the database. This is just an optimization cache. The thing is, it always worked, and the project itself hasn't changed. It's a pretty old app, actually. Has the OB version changed? No, neither on the production server, or my local instance. That would seem to rule out having an out of date jdbc2info. I did upgrade local wonder somewhat recently, but not the other dependent frameworks. I inherited the model a long time ago, and it never used prototypes. It's at least nine years old. The column type in the model is date, Data Type is Date and class is NSTimestamp. Here's the entry for that column in the entities' .plist file: { allowsNull = Y; columnName = saleDate; externalType = date; name = saledate; valueClassName = NSCalendarDate; valueType = D; As in a Date only, no time? All of mine are: Yeah, Date no time. I could change it with some alters maybe; if that might help. valueClassName = NSTimestamp; valueType = T; Using date only values in Java WO is problematic. Bummer...;-) }, So, I fixed it on one table by querying for bad date ranges after exploring revealed some crazy dates and formats. I did this from openbases's cli tool. But I'm not seeing any bad, or what would appear to be bad, data in the second table. Not sure if it's a data issue, or what. The app that inputs the data runs on an older version of wo; 5.3.x and I've
Re: Debugging db exception with Openbase and raw rows date type
Hi Chuck, inline below. Bill On Aug 27, 2010, at 11:32 AM, Chuck Hill wrote: Hi Bill, On Aug 27, 2010, at 11:16 AM, William Hatch wrote: On Aug 27, 2010, at 10:52 AM, Chuck Hill wrote: On Aug 26, 2010, at 12:14 PM, William Hatch wrote: I hope this is on topic enough; OB list seems to be dead. I've got a utility app using latest wo and wonder, openbase db, that performs raw fetches to then bulk export data in csv. Basically a simple data export/dumper thing. This had been working perfectly for a long time, but a recent run resulted in the following exception, thrown during the call to EOUtilities.rawRowsForSQL(...) : What exception happens here? Ah sorry, cut it off. It's an IllegalArgumentException immediately above the following output at java.sql.Date.valueOf(Date.java:138) at com.openbase.jdbc.f.getDate(null:Unknown) at com.webobjects.jdbcadaptor.JDBCColumn._fetchCorrectObject(JDBCColumn.java:288) at com.webobjects.jdbcadaptor.JDBCColumn._fetchValue(JDBCColumn.java:384) at com.webobjects.jdbcadaptor.JDBCColumn.fetchValue(JDBCColumn.java:372) ... skipped 1 stack elements at com.webobjects.eoaccess.EOUtilities._rawRowsForSQL(EOUtilities.java:636) at com.webobjects.eoaccess.EOUtilities.rawRowsForSQL(EOUtilities.java:588) at com.imapp.eo.Judgement.rawRows(Judgement.java:53) at com.imapp.tasks.JudgementTask.performAction(JudgementTask.java:26) at er.extensions.ERXLongResponseTask$DefaultImplementation.run(ERXLongResponseTask.java:162) ... skipped 1 stack elements at er.extensions.ERXLongResponseTask$WorkerThread.run(ERXLongResponseTask.java:60) which to me, indicates a problem with a date column within the entity referred to. I got around this particular problem by doing some raw queries and identifying and deleting row with bad date values, and the problem vanished. Then it came up again on another table, again with a date type, but this time I'm unable to find any bad data via direct queries. I debugged around my action by setting a breakpoint in the catch block, but that's not helping much. I'm looking for some advice on how to determine and fix, or at least work around the real issue. Anybody else seen this before? Thanks. Is there old jdbc2info in the model? Is the JDBC driver current? Has it changed? Are you using prototypes? How are dates defined? What is the column type in the model? Not sure how to check for old jdbc2 info in the model Chuck. What should I look for? Look in index.plist (e.g. in a text editor) for the key jdbc2info. Yep, there's some entries in there, a bunch of stuff actually. jdbc2Info = { ANSI92_CONFORMANCE = ANSI92Intermediate; DBMS_NAME = OpenBase; DRIVER_NAME = OpenBase JDBC Driver; DRIVER_VER = 0.14; IDENTIFIER_QUOTE_STRING = ; NON_NULLABLE_COLUMNS = T; STRING_FUNCTIONS = ASCII,CHAR,CONCAT,DIFFERENCE,INSERT,LCASE,LEFT,LENGTH,LOCATE,LTRIM,REPEAT,REPLACE,RIGHT,RTRIM,SOUNDEX,SPACE,SUBSTRING,UCASE; typeInfo = { ... date = { createParams = 0; defaultJDBCType = (DATE); isNullable = T; isSearchable = T; maxScale = 0; minScale = 0; precision = 0; }; The thing is, it always worked, and the project itself hasn't changed. It's a pretty old app, actually. Has the OB version changed? No, neither on the production server, or my local instance. I did upgrade local wonder somewhat recently, but not the other dependent frameworks. I inherited the model a long time ago, and it never used prototypes. It's at least nine years old. The column type in the model is date, Data Type is Date and class is NSTimestamp. Here's the entry for that column in the entities' .plist file: { allowsNull = Y; columnName = saleDate; externalType = date; name = saledate; valueClassName = NSCalendarDate; valueType = D; As in a Date only, no time? All of mine are: Yeah, Date no time. I could change it with some alters maybe; if that might help. valueClassName = NSTimestamp; valueType = T; Using date only values in Java WO is problematic. Bummer...;-) }, So, I fixed it on one table by querying for bad date ranges after exploring revealed some crazy dates and formats. I did this from openbases's cli tool. But I'm not seeing any bad, or what would appear to be bad, data in the second table. Not sure if it's a data issue, or what. The app that inputs the data runs on an older version of wo; 5.3.x and I've been copying down the db locally every once in a while and running this exporter utility locally. It does sound like bad data, though not a helpful error messages. How does OB manage to get bad data in a date type column? I don't know, and another fact that reinforces this theory is that the exceptions are getting thrown
Debugging db exception with Openbase and raw rows date type
I hope this is on topic enough; OB list seems to be dead. I've got a utility app using latest wo and wonder, openbase db, that performs raw fetches to then bulk export data in csv. Basically a simple data export/dumper thing. This had been working perfectly for a long time, but a recent run resulted in the following exception, thrown during the call to EOUtilities.rawRowsForSQL(...) : at java.sql.Date.valueOf(Date.java:138) at com.openbase.jdbc.f.getDate(null:Unknown) at com.webobjects.jdbcadaptor.JDBCColumn._fetchCorrectObject(JDBCColumn.java:288) at com.webobjects.jdbcadaptor.JDBCColumn._fetchValue(JDBCColumn.java:384) at com.webobjects.jdbcadaptor.JDBCColumn.fetchValue(JDBCColumn.java:372) ... skipped 1 stack elements at com.webobjects.eoaccess.EOUtilities._rawRowsForSQL(EOUtilities.java:636) at com.webobjects.eoaccess.EOUtilities.rawRowsForSQL(EOUtilities.java:588) at com.imapp.eo.Judgement.rawRows(Judgement.java:53) at com.imapp.tasks.JudgementTask.performAction(JudgementTask.java:26) at er.extensions.ERXLongResponseTask$DefaultImplementation.run(ERXLongResponseTask.java:162) ... skipped 1 stack elements at er.extensions.ERXLongResponseTask$WorkerThread.run(ERXLongResponseTask.java:60) which to me, indicates a problem with a date column within the entity referred to. I got around this particular problem by doing some raw queries and identifying and deleting row with bad date values, and the problem vanished. Then it came up again on another table, again with a date type, but this time I'm unable to find any bad data via direct queries. I debugged around my action by setting a breakpoint in the catch block, but that's not helping much. I'm looking for some advice on how to determine and fix, or at least work around the real issue. Anybody else seen this before? Thanks. Bill ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
OpenBase and Cannot update primary-key 'fooID' from '1364' to '1364' on object of entity Foo
Hi All, I searched Google first for similar problems and I found some but I could not figure out what the resolution was. These were old messages (2004 or 2006 I think). But anyways, I think I have a clue. EOF thinks that the primary key value has changed but it hasn't. So my guess is that the value in the snapshot of the EO and the value in the EO are not matching... not completely sure why. I have the primary key fooID turned on as a class property in my Foo entity. I'm thinking that may have something to do. Maybe if I turn it off will make it go away. fooID in OpenBase is a foo_id of type long. In my eomodel I used the id prototype from ERPrototype. Which it says the external type is an int. But like I said, in OpenBase it is really a long. Could this long in OpenBase vs. int in my eomodel cause a problem like this? Has anybody ran into this problem with OpenBase? Thanks, Ricardo ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: OpenBase and Cannot update primary-key 'fooID' from '1364' to '1364' on object of entity Foo
On Mar 24, 2009, at 5:19 PM, Ricardo J. Parada wrote: Hi All, I searched Google first for similar problems and I found some but I could not figure out what the resolution was. These were old messages (2004 or 2006 I think). But anyways, I think I have a clue. EOF thinks that the primary key value has changed but it hasn't. So my guess is that the value in the snapshot of the EO and the value in the EO are not matching... not completely sure why. I have the primary key fooID turned on as a class property in my Foo entity. I'm thinking that may have something to do. Maybe if I turn it off will make it go away. Exposing the PK, while generally considered naughty, will not cause this. Exposing a FK _will_. fooID in OpenBase is a foo_id of type long. In my eomodel I used the id prototype from ERPrototype. Which it says the external type is an int. But like I said, in OpenBase it is really a long. Could this long in OpenBase vs. int in my eomodel cause a problem like this? Has anybody ran into this problem with OpenBase? I think Mike is on this. Usually it is a Long vs Integer problem where the value is the same, but the class is not. Chuck -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: OpenBase and Cannot update primary-key 'fooID' from '1364' to '1364' on object of entity Foo
On Mar 24, 2009, at 8:28 PM, Chuck Hill wrote: Hi All, I searched Google first for similar problems and I found some but I could not figure out what the resolution was. These were old messages (2004 or 2006 I think). But anyways, I think I have a clue. EOF thinks that the primary key value has changed but it hasn't. So my guess is that the value in the snapshot of the EO and the value in the EO are not matching... not completely sure why. I have the primary key fooID turned on as a class property in my Foo entity. I'm thinking that may have something to do. Maybe if I turn it off will make it go away. Exposing the PK, while generally considered naughty, will not cause this. Exposing a FK _will_. Thanks Chuck.. I just went through my eomodel and turned off the class property icon on some foreign keys and primary keys that had it on. I DONT really need them on. fooID in OpenBase is a foo_id of type long. In my eomodel I used the id prototype from ERPrototype. Which it says the external type is an int. But like I said, in OpenBase it is really a long. Could this long in OpenBase vs. int in my eomodel cause a problem like this? Has anybody ran into this problem with OpenBase? I think Mike is on this. Usually it is a Long vs Integer problem where the value is the same, but the class is not. Hmm... maybe I can try changing the type in OpenBase for foreign keys and primary keys to use int to see if the problem goes away. Anyways, thanks for the info. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
What is the official plug-in for OpenBase?
Does anybody know what is the official plug-in for OpenBase? I use the OpenBaseJDBC.jar I downloaded from OpenBase months ago. And I removed the one in /Library/Java/Extensions. I noticed that when it obtains primary keys from the database it uses the select NEWID mechanism. But I also noticed that there are some frameworks in my system for OpenBase which I believe got installed when I installed OpenBase... and so I'm wondering if I should be using one of those instead for my WO application. In particular it seems like OpenBasePKPlugin.framework could be the one. $ ls -d /Library/Frameworks/OpenBase* /Library/Frameworks/OpenBaseAPI.framework /Library/Frameworks/OpenBaseAdmin.framework /Library/Frameworks/OpenBaseAdvancedAPI.framework /Library/Frameworks/OpenBaseCR.framework /Library/Frameworks/OpenBaseEOAdaptor.framework /Library/Frameworks/OpenBaseForms.framework /Library/Frameworks/OpenBaseLogin.framework /Library/Frameworks/OpenBaseManager.framework /Library/Frameworks/OpenBaseNet.framework /Library/Frameworks/OpenBasePKPlugin.framework Anwyas, maybe a question for openbase support. :-) ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: What is the official plug-in for OpenBase?
I think I may have found the answer... here's a page from openbase that talks about that: http://openbase.wikidot.com/connectivity-apis:web-objects On Mar 24, 2009, at 9:47 PM, Ricardo J. Parada wrote: Does anybody know what is the official plug-in for OpenBase? I use the OpenBaseJDBC.jar I downloaded from OpenBase months ago. And I removed the one in /Library/Java/Extensions. I noticed that when it obtains primary keys from the database it uses the select NEWID mechanism. But I also noticed that there are some frameworks in my system for OpenBase which I believe got installed when I installed OpenBase... and so I'm wondering if I should be using one of those instead for my WO application. In particular it seems like OpenBasePKPlugin.framework could be the one. $ ls -d /Library/Frameworks/OpenBase* /Library/Frameworks/OpenBaseAPI.framework /Library/Frameworks/OpenBaseAdmin.framework /Library/Frameworks/OpenBaseAdvancedAPI.framework /Library/Frameworks/OpenBaseCR.framework /Library/Frameworks/OpenBaseEOAdaptor.framework /Library/Frameworks/OpenBaseForms.framework /Library/Frameworks/OpenBaseLogin.framework /Library/Frameworks/OpenBaseManager.framework /Library/Frameworks/OpenBaseNet.framework /Library/Frameworks/OpenBasePKPlugin.framework Anwyas, maybe a question for openbase support. :-) ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/rparada %40mac.com This email sent to rpar...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: What is the official plug-in for OpenBase?
On Mar 24, 2009, at 6:47 PM, Ricardo J. Parada wrote: Does anybody know what is the official plug-in for OpenBase? I use the OpenBaseJDBC.jar I downloaded from OpenBase months ago. And I removed the one in /Library/Java/Extensions. I noticed that when it obtains primary keys from the database it uses the select NEWID mechanism. But I also noticed that there are some frameworks in my system for OpenBase which I believe got installed when I installed OpenBase... and so I'm wondering if I should be using one of those instead for my WO application. In particular it seems like OpenBasePKPlugin.framework could be the one. $ ls -d /Library/Frameworks/OpenBase* /Library/Frameworks/OpenBaseAPI.framework /Library/Frameworks/OpenBaseAdmin.framework /Library/Frameworks/OpenBaseAdvancedAPI.framework /Library/Frameworks/OpenBaseCR.framework /Library/Frameworks/OpenBaseEOAdaptor.framework /Library/Frameworks/OpenBaseForms.framework /Library/Frameworks/OpenBaseLogin.framework /Library/Frameworks/OpenBaseManager.framework /Library/Frameworks/OpenBaseNet.framework I am pretty sure those are all Obj-C frameworks. /Library/Frameworks/OpenBasePKPlugin.framework I am not sure about that one. See if it has Resources/Java/*.jar in it. WO comes with an OpenBase plugin bundled. Anwyas, maybe a question for openbase support. :-) That too. :-) Chuck -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: What is the official plug-in for OpenBase?
On Mar 24, 2009, at 10:09 PM, Chuck Hill wrote: /Library/Frameworks/OpenBasePKPlugin.framework I am not sure about that one. See if it has Resources/Java/*.jar in it. WO comes with an OpenBase plugin bundled. Yes it does... $ ls /Library/Frameworks/OpenBasePKPlugin.framework/Resources/Java/ openbasepkplugin.jar And that .jar has a single com.webobjects.jdbcadaptor.OpenBasePKPlugIn.class file which extends the JDBCPlugIn class. I know that initially my application was generating primary keys using the EO_PK_TABLE. And then I downloaded a newer OpenBaseJDBC.jar many months ago and my application started generating primary keys using the select NEWID scheme. But I have never used the OpenBasePKPlugin.framework in my classpath following the instructions on that page. But as soon as I did that I started running into a problem right away. I started getting exception fetching EOs that have a java enumerated types as one of their properties. So I removed the OpenBasePKPlugin.framework from my classpath and emptied back the Plugin text field in the entity modeler. And as soon as I did that the problem went away. So I'm just back to using just the updated OpenBaseJDBC.jar which already does the select NEWID for primary key generation. I don't think the OpenBasePKPlugin.framework is needed. That page has to be really old. It still talks about EOModeler. They need to update it to Eclipse/WOLips entity modeler. :-) Maybe scott keith will read this email and update that page since I had no luck subscribing to the openbase dev list. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: [Wonder-disc] OpenBase / boolean / ERPrototypes
please file a radar with the patch ... On Mar 9, 2009, at 12:38 AM, Ricardo J. Parada wrote: Thanks Mike... Well... I went inside EOJDBCOpenBasePrototypes.plist and I replaced the definition for the intBoolean by the one for FrontBase (which I know works), except that I changed the external type from INTEGER to int because that's what all other integer prototypes for OpenBase seem to use. And... NOW IT WORKS!!! Ok... so here's the definition I ended up using which finally works with OpenBase: { columnName = ; externalType = int; factoryMethodArgumentType = EOFactoryMethodArgumentIsNSString; name = intBoolean; valueClassName = NSNumber; valueType = c; }, By the way, this definition also works if I go into the OpenBaseManager and change the column type from integer to boolean. Should this be checked in back into Wonder? Otherwise next time I upgrade to the latest Wonder I'll have to patch it again. :-) Ricardo On Mar 8, 2009, at 11:17 PM, Mike Schrag wrote: Not sure I understood what you mean by flag. :-) there is a prototype named flag that maps onto whatever your database considers a bit type -- if your database natively supports a boolean type, this is the one you would use, though there are good odds the definition is wrong for OB Anyways, here's the boolean protototype from ERPrototypes as defined in EOJDBCOpenBasePrototypes.plist: yes, this is the varchar(5) boolean type that turns into the strings true or false in the database. and the intBoolean prototype is setup as follows: { adaptorValueConversionMethodName = toString; columnName = ; externalType = bool; factoryMethodArgumentType = EOFactoryMethodArgumentIsNSString; name = intBoolean; valueClassName = NSNumber; valueFactoryMethodName = valueOf; valueType = c; }, You're setting this up wrong .. you should look at the other databases versions of this in ERP ... you don't have/need a valueFactoryMethodName and a conversion method name for integer types .. it's much easier than that. I've been trying all kinds of things to get these booleans to work... And I just thought of one which might work. I'll change the type in openbase for those columns back to integer type. Then I'll use the intBoolean prototype from ERPrototypes. I assume that's what the intBoolean prototype is for: to have a boolean in your EO stored as an integer in the database. Right? yes, though again, if you're using the boolean type, you're probably not going to want intBoolean (though it may work by accident). ms -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H___ Wonder-disc mailing list wonder-d...@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wonder-disc -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H___ Wonder-disc mailing list wonder-d...@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wonder-disc ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: [Wonder-disc] OpenBase / boolean / ERPrototypes
Ricardo: I use OpenBase and have boolean columns. I have mine modeled like the first boolean prototype below. The prototype sets the valueType to String and uses toString() to convert the java boolean to a 5 character varchar in the database (for false). The result is that it actually writes true or false (String) to the database. So, your column type in OpenBase should not be boolean, it should be varchar, 5. I haven't used the approach of the intBoolean prototype. I am not using the WOnder prototypes but Practical WebObjects also describes modeling booleans in this fashion - which I like. Tim UCLA GSEIS On Mar 8, 2009, at 3:25 PM, Ricardo J. Parada wrote: Hi Mike, Not sure I understood what you mean by flag. :-) Anyways, here's the boolean protototype from ERPrototypes as defined in EOJDBCOpenBasePrototypes.plist: { adaptorValueConversionMethodName = toString; columnName = ; externalType = varchar; factoryMethodArgumentType = EOFactoryMethodArgumentIsNSString; name = boolean; valueClassName = java.lang.Boolean; valueFactoryMethodName = valueOf; valueType = S; width = 5; }, and the intBoolean prototype is setup as follows: { adaptorValueConversionMethodName = toString; columnName = ; externalType = bool; factoryMethodArgumentType = EOFactoryMethodArgumentIsNSString; name = intBoolean; valueClassName = NSNumber; valueFactoryMethodName = valueOf; valueType = c; }, I tried both and neither one works for me. Anybody out there using OpenBase 10.0.11 with and boolean properties in your columns and EOs? I've been trying all kinds of things to get these booleans to work... And I just thought of one which might work. I'll change the type in openbase for those columns back to integer type. Then I'll use the intBoolean prototype from ERPrototypes. I assume that's what the intBoolean prototype is for: to have a boolean in your EO stored as an integer in the database. Right? On Mar 8, 2009, at 10:20 AM, Mike Schrag wrote: boolean in erp = varchar, not boolean, intBoolean in erp = number, flag = probably what OB is calling boolean, but you'd have to check if the OB variant of erp declares this properly. ms On Mar 8, 2009, at 3:06 AM, Ricardo J. Parada wrote: Hi All, There seems to be something wrong with booleans when using OpenBase and ERPrototypes. In OpenBaseManager the column type for my column says boolean: Picture 2.png In openisql (command line) I can query like this: select count(*) from cliente where suspendido = true of like this: select count(*) from cliente where suspendido = 1 In entity modeler, if I configure my attribute using the boolean prototype from ERPrototypes as shown below, then the queries don't return the right number of rows. The update statements generated by EOF don't work either (even though they look right). If I model my attribute as an integer then the queries work okay and the update statements issued by EOF work too. By I don't like having an Integer in my accessor methods in my EO for a boolean column. I want to use boolean. Looking at the screenshot below, does this look like the boolean prototype is setting the fields correctly for a boolean column in OpenBase? Anybody wants to guess? Anybody using booleans in OpenBase and ERPrototypes? Picture 1.png -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H___ Wonder-disc mailing list wonder-d...@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wonder-disc -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H___ Wonder-disc mailing list wonder-d...@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wonder-disc ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http
Re: [Wonder-disc] OpenBase / boolean / ERPrototypes
boolean in erp = varchar, not boolean, intBoolean in erp = number, flag = probably what OB is calling boolean, but you'd have to check if the OB variant of erp declares this properly. ms On Mar 8, 2009, at 3:06 AM, Ricardo J. Parada wrote: Hi All, There seems to be something wrong with booleans when using OpenBase and ERPrototypes. In OpenBaseManager the column type for my column says boolean: Picture 2.png In openisql (command line) I can query like this: select count(*) from cliente where suspendido = true of like this: select count(*) from cliente where suspendido = 1 In entity modeler, if I configure my attribute using the boolean prototype from ERPrototypes as shown below, then the queries don't return the right number of rows. The update statements generated by EOF don't work either (even though they look right). If I model my attribute as an integer then the queries work okay and the update statements issued by EOF work too. By I don't like having an Integer in my accessor methods in my EO for a boolean column. I want to use boolean. Looking at the screenshot below, does this look like the boolean prototype is setting the fields correctly for a boolean column in OpenBase? Anybody wants to guess? Anybody using booleans in OpenBase and ERPrototypes? Picture 1.png -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H___ Wonder-disc mailing list wonder-d...@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wonder-disc ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: [Wonder-disc] OpenBase / boolean / ERPrototypes
Hi Mike, Not sure I understood what you mean by flag. :-) Anyways, here's the boolean protototype from ERPrototypes as defined in EOJDBCOpenBasePrototypes.plist: { adaptorValueConversionMethodName = toString; columnName = ; externalType = varchar; factoryMethodArgumentType = EOFactoryMethodArgumentIsNSString; name = boolean; valueClassName = java.lang.Boolean; valueFactoryMethodName = valueOf; valueType = S; width = 5; }, and the intBoolean prototype is setup as follows: { adaptorValueConversionMethodName = toString; columnName = ; externalType = bool; factoryMethodArgumentType = EOFactoryMethodArgumentIsNSString; name = intBoolean; valueClassName = NSNumber; valueFactoryMethodName = valueOf; valueType = c; }, I tried both and neither one works for me. Anybody out there using OpenBase 10.0.11 with and boolean properties in your columns and EOs? I've been trying all kinds of things to get these booleans to work... And I just thought of one which might work. I'll change the type in openbase for those columns back to integer type. Then I'll use the intBoolean prototype from ERPrototypes. I assume that's what the intBoolean prototype is for: to have a boolean in your EO stored as an integer in the database. Right? On Mar 8, 2009, at 10:20 AM, Mike Schrag wrote: boolean in erp = varchar, not boolean, intBoolean in erp = number, flag = probably what OB is calling boolean, but you'd have to check if the OB variant of erp declares this properly. ms On Mar 8, 2009, at 3:06 AM, Ricardo J. Parada wrote: Hi All, There seems to be something wrong with booleans when using OpenBase and ERPrototypes. In OpenBaseManager the column type for my column says boolean: Picture 2.png In openisql (command line) I can query like this: select count(*) from cliente where suspendido = true of like this: select count(*) from cliente where suspendido = 1 In entity modeler, if I configure my attribute using the boolean prototype from ERPrototypes as shown below, then the queries don't return the right number of rows. The update statements generated by EOF don't work either (even though they look right). If I model my attribute as an integer then the queries work okay and the update statements issued by EOF work too. By I don't like having an Integer in my accessor methods in my EO for a boolean column. I want to use boolean. Looking at the screenshot below, does this look like the boolean prototype is setting the fields correctly for a boolean column in OpenBase? Anybody wants to guess? Anybody using booleans in OpenBase and ERPrototypes? Picture 1.png -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H___ Wonder-disc mailing list wonder-d...@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wonder-disc -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H___ Wonder-disc mailing list wonder-d...@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wonder-disc ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: [Wonder-disc] OpenBase / boolean / ERPrototypes
Hmmm... I tried changing the column type in openbase to an integer and saved the change. Then I deleted my EOAttribute from my entity and added it back, this time using intBoolean. But as soon as I fetch my EO from the database it blows up with the following exception: er.transaction.adaptor.Exceptions - Database Exception occured: com.webobjects.foundation.NSForwardException [java.lang.NoSuchMethodException] Class java.lang.Number does not implement method valueOf:java.lang.NoSuchMethodException: Class java.lang.Number does not implement method valueOf The query looks right though. It just seems that the EOAttribute is having trouble converting the value from the database to the type used in the EO. [2009-3-8 18:42:3 EDT] WorkerThread0 com.webobjects.foundation.NSForwardException [java.lang.NoSuchMethodException] Class java.lang.Number does not implement method valueOf:java.lang.NoSuchMethodException: Class java.lang.Number does not implement method valueOf at com .webobjects .foundation .NSForwardException ._runtimeExceptionForThrowable(NSForwardException.java:41) at com.webobjects.eoaccess.EOAttribute.newValueForString(EOAttribute.java: 2003) at com .webobjects.jdbcadaptor.JDBCColumn._newValueForString(JDBCColumn.java: 675) at com .webobjects.jdbcadaptor.JDBCColumn._fetchCorrectObject(JDBCColumn.java: 334) at com.webobjects.jdbcadaptor.JDBCColumn._fetchValue(JDBCColumn.java: 384) at com.webobjects.jdbcadaptor.JDBCColumn.fetchValue(JDBCColumn.java: 372) at com.webobjects.jdbcadaptor.JDBCChannel.fetchRow(JDBCChannel.java: 1462) at com .webobjects .eoaccess.EODatabaseChannel._fetchObject(EODatabaseChannel.java:321) at com .webobjects .eoaccess .EODatabaseContext ._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java: 3071) at com .webobjects .eoaccess .EODatabaseContext .objectsWithFetchSpecification(EODatabaseContext.java:3195) at com .webobjects .eocontrol .EOObjectStoreCoordinator .objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488) at com .webobjects .eocontrol .EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java: 4069) at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java: 1114) at com .webobjects .eocontrol .EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java: ) at com.paradacafe.model._Cliente.fetchBusqueda(_Cliente.java:516) at com .paradacafe .webapps .admin.components.ClientesBusqueda.buscar(ClientesBusqueda.java:132) [...snip...] at er.extensions.components.ERXComponent.invokeAction(ERXComponent.java:92) at com.webobjects.appserver.WOSession.invokeAction(WOSession.java:1357) at com.webobjects.appserver.WOApplication.invokeAction(WOApplication.java: 1745) at er .extensions .appserver .ajax.ERXAjaxApplication.invokeAction(ERXAjaxApplication.java:49) at er .extensions.appserver.ERXApplication.invokeAction(ERXApplication.java: 1622) [...snip...] On Mar 8, 2009, at 6:25 PM, Ricardo J. Parada wrote: Hi Mike, Not sure I understood what you mean by flag. :-) Anyways, here's the boolean protototype from ERPrototypes as defined in EOJDBCOpenBasePrototypes.plist: { adaptorValueConversionMethodName = toString; columnName = ; externalType = varchar; factoryMethodArgumentType = EOFactoryMethodArgumentIsNSString; name = boolean; valueClassName = java.lang.Boolean; valueFactoryMethodName = valueOf; valueType = S; width = 5; }, and the intBoolean prototype is setup as follows: { adaptorValueConversionMethodName = toString; columnName = ; externalType = bool; factoryMethodArgumentType = EOFactoryMethodArgumentIsNSString; name = intBoolean; valueClassName = NSNumber; valueFactoryMethodName = valueOf; valueType = c; }, I tried both and neither one works for me. Anybody out there using OpenBase 10.0.11 with and boolean properties in your columns and EOs? I've been trying all kinds of things to get these booleans to work... And I just thought of one which might work. I'll change the type in openbase for those columns back to integer type. Then I'll use the intBoolean prototype from ERPrototypes. I assume that's what the intBoolean prototype is for: to have a boolean in your EO stored as an integer in the database. Right? On Mar 8, 2009, at 10:20 AM, Mike Schrag wrote: boolean in erp = varchar, not boolean, intBoolean in erp = number, flag = probably what OB is calling boolean, but you'd have to check if the OB variant of erp declares this properly. ms On Mar 8, 2009, at 3:06 AM, Ricardo J. Parada wrote: Hi All, There seems to be something wrong with booleans when using
Re: [Wonder-disc] OpenBase / boolean / ERPrototypes
Not sure I understood what you mean by flag. :-) there is a prototype named flag that maps onto whatever your database considers a bit type -- if your database natively supports a boolean type, this is the one you would use, though there are good odds the definition is wrong for OB Anyways, here's the boolean protototype from ERPrototypes as defined in EOJDBCOpenBasePrototypes.plist: yes, this is the varchar(5) boolean type that turns into the strings true or false in the database. and the intBoolean prototype is setup as follows: { adaptorValueConversionMethodName = toString; columnName = ; externalType = bool; factoryMethodArgumentType = EOFactoryMethodArgumentIsNSString; name = intBoolean; valueClassName = NSNumber; valueFactoryMethodName = valueOf; valueType = c; }, You're setting this up wrong .. you should look at the other databases versions of this in ERP ... you don't have/need a valueFactoryMethodName and a conversion method name for integer types .. it's much easier than that. I've been trying all kinds of things to get these booleans to work... And I just thought of one which might work. I'll change the type in openbase for those columns back to integer type. Then I'll use the intBoolean prototype from ERPrototypes. I assume that's what the intBoolean prototype is for: to have a boolean in your EO stored as an integer in the database. Right? yes, though again, if you're using the boolean type, you're probably not going to want intBoolean (though it may work by accident). ms ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: [Wonder-disc] OpenBase / boolean / ERPrototypes
Thanks Mike... Well... I went inside EOJDBCOpenBasePrototypes.plist and I replaced the definition for the intBoolean by the one for FrontBase (which I know works), except that I changed the external type from INTEGER to int because that's what all other integer prototypes for OpenBase seem to use. And... NOW IT WORKS!!! Ok... so here's the definition I ended up using which finally works with OpenBase: { columnName = ; externalType = int; factoryMethodArgumentType = EOFactoryMethodArgumentIsNSString; name = intBoolean; valueClassName = NSNumber; valueType = c; }, By the way, this definition also works if I go into the OpenBaseManager and change the column type from integer to boolean. Should this be checked in back into Wonder? Otherwise next time I upgrade to the latest Wonder I'll have to patch it again. :-) Ricardo On Mar 8, 2009, at 11:17 PM, Mike Schrag wrote: Not sure I understood what you mean by flag. :-) there is a prototype named flag that maps onto whatever your database considers a bit type -- if your database natively supports a boolean type, this is the one you would use, though there are good odds the definition is wrong for OB Anyways, here's the boolean protototype from ERPrototypes as defined in EOJDBCOpenBasePrototypes.plist: yes, this is the varchar(5) boolean type that turns into the strings true or false in the database. and the intBoolean prototype is setup as follows: { adaptorValueConversionMethodName = toString; columnName = ; externalType = bool; factoryMethodArgumentType = EOFactoryMethodArgumentIsNSString; name = intBoolean; valueClassName = NSNumber; valueFactoryMethodName = valueOf; valueType = c; }, You're setting this up wrong .. you should look at the other databases versions of this in ERP ... you don't have/need a valueFactoryMethodName and a conversion method name for integer types .. it's much easier than that. I've been trying all kinds of things to get these booleans to work... And I just thought of one which might work. I'll change the type in openbase for those columns back to integer type. Then I'll use the intBoolean prototype from ERPrototypes. I assume that's what the intBoolean prototype is for: to have a boolean in your EO stored as an integer in the database. Right? yes, though again, if you're using the boolean type, you're probably not going to want intBoolean (though it may work by accident). ms -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H___ Wonder-disc mailing list wonder-d...@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wonder-disc ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
OpenBase / boolean / ERPrototypes
Hi All,There seems to be something wrong with booleans when using OpenBase and ERPrototypes.In OpenBaseManager the column type for my column says boolean:In openisql (command line) I can query like this:select count(*) from cliente where suspendido = trueof like this:select count(*) from cliente where suspendido = 1In entity modeler, if I configure my attribute using the boolean prototype fromERPrototypes as shown below, then the queries don't return the right number of rows. The update statements generated by EOF don't work either (even though they look right). If I model my attribute as an integer then the queries work okay and the update statements issued by EOF work too. By I don't like having an Integer in my accessor methods in my EO for a boolean column. I want to use boolean.Looking at the screenshot below, does this look like the boolean prototype is setting the fields correctly for a boolean column in OpenBase? Anybody wants to guess? Anybody using booleans in OpenBase and ERPrototypes? ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: OpenBase WebObjects for scaling
Hi Joe, On Jan 13, 2009, at 10:11 AM, Joe Moreno wrote: Andrew, Another thing that's impressed me with OpenBase is the clustering failover. I doubt many people have used this feature. Any SQL written to any database in the cluster is automatically propagated to other OpenBase databases in that cluster within five seconds without any primary key collisions. Do you know how OpenBase handles that? This is usually quite the problem with clustering and replication. Does it need to have a GUID as the primary key, or does it work with integers? Additionally, if the master database fails your WebObjects app will automatically begin using another database in the cluster (no code needed to handle this case). Once the master database recovers, its SQL, from the other databases, is updated and it resumes handling the WO app's SQL. That sounds quite interesting. Chuck On Dec 30, 2008, at 00:39:27, Andrew Lindesay wrote: Hello Joe; I think this problem may be slightly different as it is not necessarily to do with PK's. My understanding is that OpenBasePKPlugIn is there to get EOF to use the OPENBASE PK- generation scheme rather than EO_PK_TABLE. cheers. I think I ran into the exact problem you mentioned about the deadlock in OpenBase 10 using the default primary key generation. Scott Keith advised me to compile the WO apps against the OpenBasePKPlugin.framework which uses the OpenBaseJDBC.jar and, even under heavy load, I've never had a problem using OB 10 with the plugin. I just had to add a single line to my Application.java: JDBCPlugIn .setPlugInNameForSubprotocol (com.webobjects.jdbcadaptor.OpenBasePKPlugIn, openbase); ___ Andrew Lindesay www.lindesay.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net This email sent to ch...@global-village.net -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: OpenBase WebObjects for scaling
Hello Chuck; Another thing that's impressed me with OpenBase is the clustering failover. I doubt many people have used this feature. Any SQL written to any database in the cluster is automatically propagated to other OpenBase databases in that cluster within five seconds without any primary key collisions. Do you know how OpenBase handles that? This is usually quite the problem with clustering and replication. Does it need to have a GUID as the primary key, or does it work with integers? As far as I can remember (Scott, you can correct me if I am wrong) it uses a ticker-tape style transaction log -- effectively log shipping. In this manner, transactions are written to a log and then re-played on the other members of the cluster. To avoid primary key conflicts, one employs the OB primary key generation plugin. By using this, one member of the cluster issues primary keys 10,20,30 and the next 11,21,31,41 etc... Off the top of my head, I can't remember how conflicts between logs get resolved -- again, perhaps somebody from Openbase can remind us. cheers. ___ Andrew Lindesay www.lindesay.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: OpenBase WebObjects for scaling
On Jan 14, 2009, at 11:08 AM, Andrew Lindesay wrote: Hello Chuck; Another thing that's impressed me with OpenBase is the clustering failover. I doubt many people have used this feature. Any SQL written to any database in the cluster is automatically propagated to other OpenBase databases in that cluster within five seconds without any primary key collisions. Do you know how OpenBase handles that? This is usually quite the problem with clustering and replication. Does it need to have a GUID as the primary key, or does it work with integers? As far as I can remember (Scott, you can correct me if I am wrong) it uses a ticker-tape style transaction log -- effectively log shipping. In this manner, transactions are written to a log and then re-played on the other members of the cluster. To avoid primary key conflicts, one employs the OB primary key generation plugin. By using this, one member of the cluster issues primary keys 10,20,30 and the next 11,21,31,41 etc... That is an interesting way of handling it. It would limit you to 10 copies, but that would be more than enough. Off the top of my head, I can't remember how conflicts between logs get resolved -- again, perhaps somebody from Openbase can remind us. Thanks Chuck -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: OpenBase WebObjects for scaling
Hi All, I want to comment on a few things in this thread. OpenBase generates globally unique keys by incrementing the key by a set multiple (either 10 or 100). When you setup a cluster, each database gets its own unique identifier (0-99) and that identifier is used to generate keys for that database which are globally unique. So for instance, db #1 would generate keys 1001,1011,1021,1031,etc. db #2 would generate keys 1002,1012,1022,1032. This way if the link between the databases ever goes down, the keys generated would still be guaranteed to be unique. Regarding the fix described at: http://homepage.mac.com/andrewlindesay/le/manuals/lewostuff/LEWOStuffOverview.pdf (Section 9: OPENBASE JDBC Adaptor, on page 119.) We are planning to compile this fix directly into the OpenBase Plugin. What the fix does is grab the locks at the beginning of the transaction so there will never be a case where the transaction needs to be aborted to avoid a deadlock with another transaction. This is essentially what it does at the SQL level: START TRANSACTION WRITE TABLE foo, bar INSERT INTO foo... INSERT INTO bar... COMMIT If you have not had a chance to try OpenBase 11 (beta), you can find it at http://www.openbase.com/beta. Other things that are going into OpenBase 11 include: incremental backups, PDF document value extraction, always-on encryption, improved handling of dynamic networks and a whole bunch of other features. A 64 bit version is also in the works. Best regards, Scott Keith OpenBase Begin forwarded message: From: Chuck Hill ch...@global-village.net Date: January 14, 2009 10:47:49 AM PST To: Joe Moreno joemor...@mac.com Cc: WebObjects-Dev Mailing List webobjects-dev@lists.apple.com Subject: Re: OpenBase WebObjects for scaling Hi Joe, On Jan 13, 2009, at 10:11 AM, Joe Moreno wrote: Andrew, Another thing that's impressed me with OpenBase is the clustering failover. I doubt many people have used this feature. Any SQL written to any database in the cluster is automatically propagated to other OpenBase databases in that cluster within five seconds without any primary key collisions. Do you know how OpenBase handles that? This is usually quite the problem with clustering and replication. Does it need to have a GUID as the primary key, or does it work with integers? Additionally, if the master database fails your WebObjects app will automatically begin using another database in the cluster (no code needed to handle this case). Once the master database recovers, its SQL, from the other databases, is updated and it resumes handling the WO app's SQL. That sounds quite interesting. Chuck On Dec 30, 2008, at 00:39:27, Andrew Lindesay wrote: Hello Joe; I think this problem may be slightly different as it is not necessarily to do with PK's. My understanding is that OpenBasePKPlugIn is there to get EOF to use the OPENBASE PK- generation scheme rather than EO_PK_TABLE. cheers. I think I ran into the exact problem you mentioned about the deadlock in OpenBase 10 using the default primary key generation. Scott Keith advised me to compile the WO apps against the OpenBasePKPlugin.framework which uses the OpenBaseJDBC.jar and, even under heavy load, I've never had a problem using OB 10 with the plugin. I just had to add a single line to my Application.java: JDBCPlugIn .setPlugInNameForSubprotocol (com.webobjects.jdbcadaptor.OpenBasePKPlugIn, openbase); ___ Andrew Lindesay www.lindesay.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net This email sent to ch...@global-village.net -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/george%40boxofficetickets.com This email sent to geo...@boxofficetickets.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: OpenBase WebObjects for scaling
That is correct. In the even there is a conflict, we do a synchronization pass to resolve it. - Scott On Jan 14, 2009, at 2:08 PM, Andrew Lindesay wrote: Hello Chuck; Another thing that's impressed me with OpenBase is the clustering failover. I doubt many people have used this feature. Any SQL written to any database in the cluster is automatically propagated to other OpenBase databases in that cluster within five seconds without any primary key collisions. Do you know how OpenBase handles that? This is usually quite the problem with clustering and replication. Does it need to have a GUID as the primary key, or does it work with integers? As far as I can remember (Scott, you can correct me if I am wrong) it uses a ticker-tape style transaction log -- effectively log shipping. In this manner, transactions are written to a log and then re-played on the other members of the cluster. To avoid primary key conflicts, one employs the OB primary key generation plugin. By using this, one member of the cluster issues primary keys 10,20,30 and the next 11,21,31,41 etc... Off the top of my head, I can't remember how conflicts between logs get resolved -- again, perhaps somebody from Openbase can remind us. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: OpenBase WebObjects for scaling
Andrew, Another thing that's impressed me with OpenBase is the clustering failover. I doubt many people have used this feature. Any SQL written to any database in the cluster is automatically propagated to other OpenBase databases in that cluster within five seconds without any primary key collisions. Additionally, if the master database fails your WebObjects app will automatically begin using another database in the cluster (no code needed to handle this case). Once the master database recovers, its SQL, from the other databases, is updated and it resumes handling the WO app's SQL. Ciao, Joe On Dec 30, 2008, at 00:39:27, Andrew Lindesay wrote: Hello Joe; I think this problem may be slightly different as it is not necessarily to do with PK's. My understanding is that OpenBasePKPlugIn is there to get EOF to use the OPENBASE PK- generation scheme rather than EO_PK_TABLE. cheers. I think I ran into the exact problem you mentioned about the deadlock in OpenBase 10 using the default primary key generation. Scott Keith advised me to compile the WO apps against the OpenBasePKPlugin.framework which uses the OpenBaseJDBC.jar and, even under heavy load, I've never had a problem using OB 10 with the plugin. I just had to add a single line to my Application.java: JDBCPlugIn .setPlugInNameForSubprotocol (com.webobjects.jdbcadaptor.OpenBasePKPlugIn, openbase); ___ Andrew Lindesay www.lindesay.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: OpenBase WebObjects for scaling
Hello Joe; I think this problem may be slightly different as it is not necessarily to do with PK's. My understanding is that OpenBasePKPlugIn is there to get EOF to use the OPENBASE PK- generation scheme rather than EO_PK_TABLE. cheers. I think I ran into the exact problem you mentioned about the deadlock in OpenBase 10 using the default primary key generation. Scott Keith advised me to compile the WO apps against the OpenBasePKPlugin.framework which uses the OpenBaseJDBC.jar and, even under heavy load, I've never had a problem using OB 10 with the plugin. I just had to add a single line to my Application.java: JDBCPlugIn .setPlugInNameForSubprotocol (com.webobjects.jdbcadaptor.OpenBasePKPlugIn, openbase); ___ Andrew Lindesay www.lindesay.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
OpenBase WebObjects for scaling
Hi all, Does anyone have any real world, recent, experience with OpenBase on a large scale? I've been using OpenBase for more than 10 years. During that time, I've also used Oracle, Sybase, FrontBase, and MySQL, to name a few. I've been extremely impressed with OpenBase's support of WebObjects - more so than any other database that I know of. Additionally, OpenBase supports bidirectional clustering with up to 100 computers and the latest release supports incremental backups. These certainly seem like high end features to me. Most recently, I've been using OpenBase to run in parallel with Amazon's SimpleDB. So far, both have written millions of rows of data to both database systems without any issues. But, SimpleDB is not a RDBMS; also SimpleDB has some other limitations. Your experiences are greatly appreciated. Cheers, Joe ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: OpenBase WebObjects for scaling
Hello Joe; In high-volume concurrent situations, there is an issue with EOF together with OPENBASE where concurrent transactions can get into a deadlock when writing into the same series of tables. Let me be very clear; not a problem with OPENBASE per se, but a specific problem with EOF and OPENBASE. To avoid this, I have created a simple subclass of the JDBC Adaptor (distributed in a self-contained Framework jar) specifically to address this issue. To find out more about this read the LEWOStuff PDF under; 9) OPENBASE JDBC Adaptor cheers. Does anyone have any real world, recent, experience with OpenBase on a large scale? ___ Andrew Lindesay www.lindesay.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: OpenBase WebObjects for scaling
Hi Andrew, I wanted to mention that OpenBase 11 addresses one issue related to deadlocks and WebObjects. We had a reproducible case and were able to isolate the problem and fix it for this upcoming release. If anyone would like to try the OpenBase 11 beta, we would welcome your input. Here is the download link: http://www.openbase.com/beta If you try the beta, here is a license which will enable the software: SN: OBWEBCDEVBETA-629 Authorization: D-2009.01.15-1000-11.0-04F-639-5A1 Finally, I want to also let everyone know that we have an OpenBase v11 64 bit build we are working on. The big advantage of 64 bit as it relates to scaling is that the OpenBase server is no longer limited to a 3.5GB memory footprint. That means we can make better use of available memory to provide faster performance. We will have details in January on how you can get your hands on an early copy of that, but I wanted to let you know that it is coming. Best regards, Scott Keith OpenBase From: Andrew Lindesay a...@lindesay.co.nz Date: December 29, 2008 1:14:31 PM PST To: Joe Moreno joemor...@mac.com Cc: WebObjects-Dev Mailing List webobjects-dev@lists.apple.com Subject: Re: OpenBase WebObjects for scaling Hello Joe; In high-volume concurrent situations, there is an issue with EOF together with OPENBASE where concurrent transactions can get into a deadlock when writing into the same series of tables. Let me be very clear; not a problem with OPENBASE per se, but a specific problem with EOF and OPENBASE. To avoid this, I have created a simple subclass of the JDBC Adaptor (distributed in a self- contained Framework jar) specifically to address this issue. To find out more about this read the LEWOStuff PDF under; 9) OPENBASE JDBC Adaptor cheers. Does anyone have any real world, recent, experience with OpenBase on a large scale? ___ Andrew Lindesay www.lindesay.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: OpenBase WebObjects for scaling
Hi Andrew, I think I ran into the exact problem you mentioned about the deadlock in OpenBase 10 using the default primary key generation. Scott Keith advised me to compile the WO apps against the OpenBasePKPlugin.framework which uses the OpenBaseJDBC.jar and, even under heavy load, I've never had a problem using OB 10 with the plugin. I just had to add a single line to my Application.java: JDBCPlugIn .setPlugInNameForSubprotocol (com.webobjects.jdbcadaptor.OpenBasePKPlugIn, openbase); Many thanks for the feedback. Cheers, Joe On Dec 29, 2008, at 13:14:31, Andrew Lindesay wrote: Hello Joe; In high-volume concurrent situations, there is an issue with EOF together with OPENBASE where concurrent transactions can get into a deadlock when writing into the same series of tables. Let me be very clear; not a problem with OPENBASE per se, but a specific problem with EOF and OPENBASE. To avoid this, I have created a simple subclass of the JDBC Adaptor (distributed in a self-contained Framework jar) specifically to address this issue. To find out more about this read the LEWOStuff PDF under; 9) OPENBASE JDBC Adaptor cheers. Does anyone have any real world, recent, experience with OpenBase on a large scale? ___ Andrew Lindesay www.lindesay.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Migrations and OpenBase
Gus, Can you turn on EOAdaptor Debugging so you can see what the actual SQL being sent to the DB is? Do this by creating the following property in your Resources/Properties file: log4j.logger.er.transaction.adaptor.EOAdaptorDebugEnabled=DEBUG The log you sent shows two conflicting things: Oct 16 18:32:57 ControlHorarios[1250] (ERXJDBCUtilities.java:588) INFO er.extensions.jdbc.ERXJDBCUtilities - Executing ALTER TABLE EMPLOYEETURN ADD CONSTRAINT EMPLOYEETURN_EMPLOYEE_ID_id_FK FOREIGN KEY (EMPLOYEE_ID) REFERENCES EMPLOYEE (id) and 2008-10-16 18:32:57 -0500: ScheduleControl:SQL ERROR - [position 24, near 'ADD' in 'PLOYEETURN ADD CONSTRAINT'] alter table command expected but not found.{ NSColor = NSCalibratedRGBColorSpace 0 0 1 1; } You can see that the SQL the migration is trying to send to the table looks properly formed (I am not an OpenBase developer) but the error says that it isn't, so we need to see the actual SQL sent by the EOAdaptor. Dave ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Migrations and OpenBase
I go this.. before the whole exceptions stack 7 09:56:35 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog - evaluateExpression: com.webobjects.jdbcadaptor.OpenBasePlugIn$OpenBaseExpression: UPDATE _dbupdater SET lockowner = NULL, updatelock = ? WHERE modelname = ? withBindings: 1:0(updateLock), 2:ScheduleControl(modelName) Oct 17 09:56:35 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog - === Commit Internal Transaction Oct 17 09:56:35 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog - === Begin Internal Transaction Oct 17 09:56:35 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog - === Rollback Internal Transaction Oct 17 09:56:35 ControlHorarios[1250] (ERXNSLogLog4jBridge.java:43) WARN NSLog - A fatal exception occurred: Migration failed. I have no idea if anyone has ever run migrations on OpenBase, but my guess is that this is failing because of the bizarre implementation of the 5.3 schema sync API's in 5.4. Most likely what is happening here is that migrations is calling the 5.3 API which is implemented as calling the generic 5.4 plugin schema sync instead of the OpenBase schema sync API's. Chalk this up to the schema sync classes basically completely insane in WO 5.4. ms So suggestion is to change to Mysql? :O. Chalk this up to the schema sync classes basically completely insane in WO 5.4. Am I supposed to do something here? Gus On Oct 17, 2008, at 6:36 AM, Mike Schrag wrote: Hello, I made a debug and it seems that the problem its occurring when adding the foreign key. :/:/: I have no idea if anyone has ever run migrations on OpenBase, but my guess is that this is failing because of the bizarre implementation of the 5.3 schema sync API's in 5.4. Most likely what is happening here is that migrations is calling the 5.3 API which is implemented as calling the generic 5.4 plugin schema sync instead of the OpenBase schema sync API's. Chalk this up to the schema sync classes basically completely insane in WO 5.4. ms ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/webobjectspicora%40gmail.com This email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Migrations and OpenBase
So suggestion is to change to Mysql? :O. I use FrontBase and Postgresql. They work. I don't know what went down with your FrontBase setup, but it's my primary database, so I can assure you that it works. ms ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Migrations and OpenBase
Ok I will give it a try, fortunately what I have in the db wasn't too much. like 9 records in a table so I think I can migrate it. Oh I remember that was a pain in the ass to try to execute the SQL that EOModeler generated, it was saying something about the connections. I will try again and see what's the error. This just works too, so there's something wrong with your config. But if you're using migrations, you shouldn't be executing SQL from entity modeler anyway. ms ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Migrations and OpenBase
On Oct 17, 2008, at 11:14 AM, Mike Schrag wrote: So suggestion is to change to Mysql? :O. I use FrontBase and Postgresql. They work. I don't know what went down with your FrontBase setup, but it's my primary database, so I can assure you that it works. I can't say this strongly enough: If you have control over what DB, Frameworks, Development and Deployment platforms you use, use whatever Mike uses. Your WO-Life will be so much more simple, you'll get more support on the lists and you can be reasonably confident that if you are running into problems, it is something you are doing wrong. Not that Mike is infallible, but he tends to fix his mistakes very quickly. :-) Dave ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Migrations and OpenBase
Not that Mike is infallible +1 ms ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Migrations and OpenBase
ok ok ok... no scold needed :P Gus On Oct 17, 2008, at 10:56 AM, Mike Schrag wrote: Not that Mike is infallible +1 ms ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/webobjectspicora%40gmail.com This email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: OpenBase (was:Webobjects-dev Digest, Vol 5, Issue 1018)
Very glad to see this! I've used OB on a number of projects and would truly love to see it in sync with Wonder. +1 On Oct 17, 2008, at 11:58 AM, Scott Keith wrote: Hi Gus, We'd like to work with you to get this working for you in OpenBase. Can you contact me off list at [EMAIL PROTECTED] to discuss the problem in more depth? We're in the process of updating all of our APIs over the next month so this is a good time for us to update our WebObjects connectivity so that it works seamlessly with Wonder. Best regards, Scott Keith OpenBase Begin forwarded message: Yes im (was) using the OpenBase plugin. Im chanign to FrontBase now. Im just in a learning phase so I can change whatever I want. I hope in real-work app I will be able to handle the errors Gus ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/joshpaul%40gmail.com This email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: OpenBase (was:Webobjects-dev Digest, Vol 5, Issue 1018)
On Oct 17, 2008, at 4:16 PM, Josh Paul wrote: Very glad to see this! I've used OB on a number of projects and would truly love to see it in sync with Wonder. +1 :-) ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Migrations and OpenBase
On Oct 17, 2008, at 6:03 AM, David Avendasora wrote: Gus, Can you turn on EOAdaptor Debugging so you can see what the actual SQL being sent to the DB is? Do this by creating the following property in your Resources/Properties file: log4j.logger.er.transaction.adaptor.EOAdaptorDebugEnabled=DEBUG The log you sent shows two conflicting things: Oct 16 18:32:57 ControlHorarios[1250] (ERXJDBCUtilities.java:588) INFO er.extensions.jdbc.ERXJDBCUtilities - Executing ALTER TABLE EMPLOYEETURN ADD CONSTRAINT EMPLOYEETURN_EMPLOYEE_ID_id_FK FOREIGN KEY (EMPLOYEE_ID) REFERENCES EMPLOYEE (id) and 2008-10-16 18:32:57 -0500: ScheduleControl:SQL ERROR - [position 24, near 'ADD' in 'PLOYEETURN ADD CONSTRAINT'] alter table command expected but not found.{ NSColor = NSCalibratedRGBColorSpace 0 0 1 1; } You can see that the SQL the migration is trying to send to the table looks properly formed (I am not an OpenBase developer) but the error says that it isn't, so we need to see the actual SQL sent by the EOAdaptor. The SQL that is being sent appears to be proper SQL for an Oracle database (and probably some others), but not for OpenBase (the two RDBMS systems I am most familiar with). It appears that based on the log information, the SQL that the DB received is the same, although truncated. For OpenBase, the SQL to add a foreign key constraint would be similar to that of adding the column (this is based on if the ID column in the EMPLOYEE table is a longlong or integer, or NUMBER of zero decimal precision): ALTER TABLE EMPLOYEETURN ADD COLUMN EMPLOYEE_ID longlong index REFERENCES EMPLOYEE.id Note that although the column EMPLOYEE_ID may already exist in the EMPLOYEETURN table, re-adding it will not result in any loss of data in OpenBase. Are you using the OpenBase plugin? Best Regards, Darryl Snover ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Openbase caching/time to live
Hi All, We are looking at reducing the number of queries made to our Openbase database. When you look at the Openbase sql log file it appears to repeat a number of queries. Openbase are suggesting we set an objects time to live to be 10 seconds to eliminate or reduce these extra queries. Does anyone know what this means in terms of WebObjects? A long time ago we unticked the caching checkbox in Java monitor as information was not being shared between instances, so I don't want to turn this back on. The only thing I can find is http://wiki.objectstyle.org/confluence/display/WO/EOF-Using+EOF-Caching+and+Freshness but in short I don't feel confident that this will actually solve our problem. One important thing to note is we use the session.defaultEditingContext virtually everywhere (except reports) Can anyone suggest a silver bullet? WebObjects 5.3 Openbase 10.0 Project Wonder Mac OSX 10.4 deployment Thanks and regards Shelley ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Openbase caching/time to live
On Aug 7, 2008, at 10:10 PM, Shelley Eitzen wrote: Hi All, We are looking at reducing the number of queries made to our Openbase database. When you look at the Openbase sql log file it appears to repeat a number of queries. Openbase are suggesting we set an objects time to live to be 10 seconds to eliminate or reduce these extra queries. Does anyone know what this means in terms of WebObjects? Not much, I'd guess. The default is 60 minutes... A long time ago we unticked the caching checkbox in Java monitor as information was not being shared between instances, so I don't want to turn this back on. I think that is only component template caching. The only thing I can find is http://wiki.objectstyle.org/confluence/display/WO/EOF-Using+EOF-Caching+and+Freshness but in short I don't feel confident that this will actually solve our problem. One important thing to note is we use the session.defaultEditingContext virtually everywhere (except reports) Can anyone suggest a silver bullet? I suspect this is what you are missing: http://wiki.objectstyle.org/confluence/display/WO/EOF-Modeling-EOModeler#EOF-Modeling-EOModeler-BatchFaulting Chuck -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
move from using EO_PK_TABLE to OpenBase plugin
HI All, Webobjects 5.3 Xcode 2.2 Openbase 10 Project Wonder last updated approx April. I am trying to move from using EO_PK_TABLE to using OpenbasePKPlugin I have: 1) added the OpenbasePKPlugin framework to the application 2) added the following to the adapter settings in the model Driver: com.openbase.jdbc.ObDriver Plugin: com.webobjects.jdbcadaptor.OpenBasePKPlugIn 3) added the following to the Application constructor JDBCPlugIn.setPlugInNameForSubprotocol(com.webobjects.jdbcadaptor.OpenBasePKPlugIn, openbase); 4) added the following to the application class import com.webobjects.jdbcadaptor.*; import com.openbase.jdbc.ObDriver.*; The application now does not start and gives the following error message. A fatal exception occurred: ERXExtensions have not been initialized. Please report the classpath and the rest of the bundles to the Wonder mailing list: Remaining frameworks: [OpenBasePKPlugIn] Any suggestions? The full run log: [Session started at 2008-06-26 16:57:09 +0930.] Reading MacOSClassPath.txt ... Launching AMSJava.woa ... java -XX:NewSize=2m -Xmx64m -Xms32m -DWORootDirectory=/System -DWOLocalRootDirectory= -DWOUserDirectory=/Users/shelleyeitzen/projects/advisered.net/AMSJava/build/Development -DWOEnvClassPath= -DWOApplicationClass=Application -DWOPlatform=MacOS -Dcom.webobjects.pid=13469 -Djava.vm.pid=$$ -Xms100m -Xmx700m -classpath WOBootstrap.jar com.webobjects._bootstrap.WOBootstrap -WOPort 12345 -databaseURL jdbc:openbase://localhost/Education1 -er.extensions.ERXRaiseOnMissingEditingContextDelegate NO -fontDirectory /Library/Fonts/ OpenBase10DLSFix Yes -ignoreWebPDF Yes appRoot is /Users/shelleyeitzen/projects/advisered.net/AMSJava/build/Development/AMSJava.woa/Contents Loading /Users/shelleyeitzen/projects/advisered.net/AMSJava/build/Development/AMSJava.woa/Contents/MacOS/MacOSClassPath.txt Generated classpath: /Users/shelleyeitzen/projects/advisered.net/AMSJava/build/Development/AMSJava.woa/Contents/Resources/Java/AMSJava.jar /Library/Frameworks/ERExtensions.framework/Resources/Java/ERExtensions.jar /Library/Frameworks/ERExtensions.framework/Resources/Java/src.jar /System/Library/Frameworks/JavaEOProject.framework/Resources/Java/javaeoproject.jar /System/Library/Frameworks/JavaWOExtensions.framework/Resources/Java/JavaWOExtensions.jar /System/Library/Frameworks/JavaXML.framework/Resources/Java/javaxml.jar /System/Library/Frameworks/JavaDirectToWeb.framework/Resources/Java/javadirecttoweb.jar /System/Library/Frameworks/JavaJDBCAdaptor.framework/Resources/Java/javajdbcadaptor.jar /System/Library/Frameworks/JavaEOControl.framework/Resources/Java/javaeocontrol.jar /System/Library/Frameworks/JavaEOAccess.framework/Resources/Java/javaeoaccess.jar /System/Library/Frameworks/JavaFoundation.framework/Resources/Java/javafoundation.jar /System/Library/Frameworks/JavaDTWGeneration.framework/Resources/Java/javadtwgeneration.jar /System/Library/Frameworks/JavaWebObjects.framework/Resources/Java/javawebobjects.jar /Library/Frameworks/ERPlot.framework/Resources/Java/ERPlot.jar /Library/Frameworks/ERPlot.framework/Resources/Java/jcommon-0.9.6.jar /Library/Frameworks/ERPlot.framework/Resources/Java/jfreechart-0.9.21.jar /Library/Frameworks/ERPlot.framework/Resources/Java/src.jar /Library/Frameworks/ERJars.framework/Resources/Java/ERJars.jar /Library/Frameworks/ERJars.framework/Resources/Java/erxservletadaptor.jar /Library/Frameworks/ERJars.framework/Resources/Java/erxwo54.jar /Library/Frameworks/ERJars.framework/Resources/Java/icu4j-3_8_1.jar /Library/Frameworks/ERJars.framework/Resources/Java/junit.jar /Library/Frameworks/ERJars.framework/Resources/Java/log4j-1.2.14.jar /Library/Frameworks/ERJars.framework/Resources/Java/slf4j-api-1.5.0.jar /Library/Frameworks/ERJars.framework/Resources/Java/slf4j-log4j12-1.5.0.jar /Library/Frameworks/ERJars.framework/Resources/Java/src.jar /Library/Frameworks/WOExamplesHarness.framework/Resources/Java/WOExamplesHarness.jar /Library/Frameworks/TWButils.1.1/TWButils.framework/Resources/Java/twbutils.jar /Library/Frameworks/RDMultipleDatePerspective.framework/Resources/Java/rdmultipledateperspective.jar /Library/Frameworks/Ajax.framework/Resources/Java/Ajax.jar /Library/Frameworks/Ajax.framework/Resources/Java/jabsorb-1.2.2.jar /Library/Frameworks/Ajax.framework/Resources/Java/src.jar /Library/Frameworks/ExcelGenerator.framework/Resources/Java/ExcelGenerator.jar /Library/Frameworks/ExcelGenerator.framework/Resources/Java/poi-3.0.1-FINAL-20070705.jar /Library/Frameworks/ExcelGenerator.framework/Resources/Java/src.jar /Library/Frameworks/CertificateGenerator.framework/Resources/Java/CertificateGenerator.jar /Library/Frameworks/CertificateGenerator.framework/Resources/Java/itext-1.4.2.jar /Library/Frameworks/OpenBasePKPlugIn.framework/Resources/Java/openbasepkplugin.jar /Users/shelleyeitzen/Library/Java /Library/Java/ /System/Library/Java/ /Network/Library/Java
Re: move from using EO_PK_TABLE to OpenBase plugin
Hello, if you have put plugin: com.webobjects.jdbcadaptor.OpenBasePKPlugIn in your model, then you should NOT add JDBCPlugIn .setPlugInNameForSubprotocol (com.webobjects.jdbcadaptor.OpenBasePKPlugIn in the Application constructor (remove the unnecessary imports too) Hope this helps Regards Amedeo On 26/giu/08, at 09:43, Shelley Eitzen wrote: HI All, Webobjects 5.3 Xcode 2.2 Openbase 10 Project Wonder last updated approx April. I am trying to move from using EO_PK_TABLE to using OpenbasePKPlugin I have: 1) added the OpenbasePKPlugin framework to the application 2) added the following to the adapter settings in the model Driver: com.openbase.jdbc.ObDriver Plugin: com.webobjects.jdbcadaptor.OpenBasePKPlugIn 3) added the following to the Application constructor JDBCPlugIn .setPlugInNameForSubprotocol (com.webobjects.jdbcadaptor.OpenBasePKPlugIn, openbase); 4) added the following to the application class import com.webobjects.jdbcadaptor.*; import com.openbase.jdbc.ObDriver.*; The application now does not start and gives the following error message. A fatal exception occurred: ERXExtensions have not been initialized. Please report the classpath and the rest of the bundles to the Wonder mailing list: Remaining frameworks: [OpenBasePKPlugIn] Any suggestions? The full run log: [Session started at 2008-06-26 16:57:09 +0930.] Reading MacOSClassPath.txt ... Launching AMSJava.woa ... java -XX:NewSize=2m -Xmx64m -Xms32m -DWORootDirectory=/System -DWOLocalRootDirectory= -DWOUserDirectory=/Users/shelleyeitzen/projects/advisered.net/ AMSJava/build/Development -DWOEnvClassPath= -DWOApplicationClass=Application - DWOPlatform=MacOS -Dcom.webobjects.pid=13469 -Djava.vm.pid=$$ -Xms100m -Xmx700m - classpath WOBootstrap.jar com.webobjects._bootstrap.WOBootstrap -WOPort 12345 -databaseURL jdbc:openbase://localhost/Education1 -er.extensions.ERXRaiseOnMissingEditingContextDelegate NO - fontDirectory /Library/Fonts/ OpenBase10DLSFix Yes -ignoreWebPDF Yes appRoot is /Users/shelleyeitzen/projects/advisered.net/AMSJava/build/ Development/AMSJava.woa/Contents Loading /Users/shelleyeitzen/projects/advisered.net/AMSJava/build/ Development/AMSJava.woa/Contents/MacOS/MacOSClassPath.txt Generated classpath: /Users/shelleyeitzen/projects/advisered.net/AMSJava/build/ Development/AMSJava.woa/Contents/Resources/Java/AMSJava.jar /Library/Frameworks/ERExtensions.framework/Resources/Java/ ERExtensions.jar /Library/Frameworks/ERExtensions.framework/Resources/Java/src.jar /System/Library/Frameworks/JavaEOProject.framework/Resources/Java/ javaeoproject.jar /System/Library/Frameworks/JavaWOExtensions.framework/Resources/ Java/JavaWOExtensions.jar /System/Library/Frameworks/JavaXML.framework/Resources/Java/ javaxml.jar /System/Library/Frameworks/JavaDirectToWeb.framework/Resources/Java/ javadirecttoweb.jar /System/Library/Frameworks/JavaJDBCAdaptor.framework/Resources/Java/ javajdbcadaptor.jar /System/Library/Frameworks/JavaEOControl.framework/Resources/Java/ javaeocontrol.jar /System/Library/Frameworks/JavaEOAccess.framework/Resources/Java/ javaeoaccess.jar /System/Library/Frameworks/JavaFoundation.framework/Resources/Java/ javafoundation.jar /System/Library/Frameworks/JavaDTWGeneration.framework/Resources/ Java/javadtwgeneration.jar /System/Library/Frameworks/JavaWebObjects.framework/Resources/Java/ javawebobjects.jar /Library/Frameworks/ERPlot.framework/Resources/Java/ERPlot.jar /Library/Frameworks/ERPlot.framework/Resources/Java/jcommon-0.9.6.jar /Library/Frameworks/ERPlot.framework/Resources/Java/ jfreechart-0.9.21.jar /Library/Frameworks/ERPlot.framework/Resources/Java/src.jar /Library/Frameworks/ERJars.framework/Resources/Java/ERJars.jar /Library/Frameworks/ERJars.framework/Resources/Java/ erxservletadaptor.jar /Library/Frameworks/ERJars.framework/Resources/Java/erxwo54.jar /Library/Frameworks/ERJars.framework/Resources/Java/icu4j-3_8_1.jar /Library/Frameworks/ERJars.framework/Resources/Java/junit.jar /Library/Frameworks/ERJars.framework/Resources/Java/log4j-1.2.14.jar /Library/Frameworks/ERJars.framework/Resources/Java/slf4j- api-1.5.0.jar /Library/Frameworks/ERJars.framework/Resources/Java/slf4j- log4j12-1.5.0.jar /Library/Frameworks/ERJars.framework/Resources/Java/src.jar /Library/Frameworks/WOExamplesHarness.framework/Resources/Java/ WOExamplesHarness.jar /Library/Frameworks/TWButils.1.1/TWButils.framework/Resources/Java/ twbutils.jar /Library/Frameworks/RDMultipleDatePerspective.framework/Resources/ Java/rdmultipledateperspective.jar /Library/Frameworks/Ajax.framework/Resources/Java/Ajax.jar /Library/Frameworks/Ajax.framework/Resources/Java/jabsorb-1.2.2.jar /Library/Frameworks/Ajax.framework/Resources/Java/src.jar /Library/Frameworks/ExcelGenerator.framework/Resources/Java/ ExcelGenerator.jar /Library/Frameworks/ExcelGenerator.framework/Resources/Java/ poi-3.0.1-FINAL-20070705.jar /Library/Frameworks/ExcelGenerator.framework/Resources
Re: move from using EO_PK_TABLE to OpenBase plugin
Thanks, but still no go. I have completed Amedeo suggestion, but still I get the same fatal exception. [2008-06-27 09:08:35 CST] main A fatal exception occurred: ERXExtensions have not been initialized. Please report the classpath and the rest of the bundles to the Wonder mailing list: Remaining frameworks: [OpenBasePKPlugIn] As soon as I add the openbase framework to the application, the app no longer runs. Shelley Hello, if you have put plugin: com.webobjects.jdbcadaptor.OpenBasePKPlugIn in your model, then you should NOT add JDBCPlugIn .setPlugInNameForSubprotocol (com.webobjects.jdbcadaptor.OpenBasePKPlugIn in the Application constructor (remove the unnecessary imports too) Hope this helps Regards Amedeo ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
move from using EO_PK_TABLE to OpenBase plugin
Hi All, WebObjects 5.3 XCode 2.x Openbase 10.x We currently have an application which utilises the EO_PK_TABLE in generating primary keys. We need to use the Openbase method of generating primary keys. Can anyone please tell me how to change this? Thanks in Advance Shelley ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: move from using EO_PK_TABLE to OpenBase plugin
Hello Shelly; You need to include the following framework in your project / build product; OpenBasePKPlugin.framework Then you need to add this bit of code to your Application's constructor; JDBCPlugIn .setPlugInNameForSubprotocol (com.webobjects.jdbcadaptor.OpenBasePKPlugIn, openbase); cheers. We currently have an application which utilises the EO_PK_TABLE in generating primary keys. We need to use the Openbase method of generating primary keys. Can anyone please tell me how to change this? ___ Andrew Lindesay www.lindesay.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: move from using EO_PK_TABLE to OpenBase plugin
Hi Shelley, add this to your application constructor JDBCPlugIn.setPlugInNameForSubprotocol (com.webobjects.jdbcadaptor.OpenBasePKPlugIn, openbase); and in your model's adaptor settings add this: Driver: com.openbase.jdbc.ObDriver Plugin: com.webobjects.jdbcadaptor.OpenBasePKPlugIn That should do it. Gordon On 25-Jun-08, at 3:28 AM, Shelley Eitzen wrote: Hi All, WebObjects 5.3 XCode 2.x Openbase 10.x We currently have an application which utilises the EO_PK_TABLE in generating primary keys. We need to use the Openbase method of generating primary keys. Can anyone please tell me how to change this? Thanks in Advance Shelley ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/gordon.belray% 40utoronto.ca This email sent to [EMAIL PROTECTED] Gordon Belray Information Architect and Imaging System Manager Information Technology Services Robarts Library 416.946.8617cell: 416.427.7007 [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Problem Connecting to OpenBase
Hello Timo, Bingo - your advice solved my problem, and I can now connect to OpenBase. When I compared the 2 OpenBaseJDBC.jar files - sure enough the one in /Library/Java/Extensions had a earlier date (9/12/2006 and 73,373 bytes) VERSUS the file in /Applications/OpenBase/Developer/Interfaces/JDBC/JDBC_10.9.2006 (10/9/2006 date and 74,235 bytes). And using the latter enabled a connection to the database. I'm can't be sure which update caused this problem (I did not keep a record), but I think it was an Xcode 2.4.1/WebObjects 5.3.2 update which I performed quite recently. Thanks very much for your help! Fred Timo Hoepfner wrote: Hi there, had a similar issue last week. The symptoms were the same. Either some update (WO 533?) replaces the OpenBase driver with a outdated or broken one, or the last java update makes the old one useless. When I did a System.out.println(ObDriver.class) at application startup, I would get something like incorrect class version. In my case, replacing the jar in /Library/Java/Extensions with the jar from the latest OpenBase distribution fixed it. Timo Am 26.02.2007 um 22:10 schrieb Fred Shurtleff: Checked Spotlight and it is ONLY in /Library/Java/Extensions (and of course - /Application/OpenBase/Developer). Also I looked further into the project Java Build Path and do see JRE System Library(JVM 1.4.2) which contains the item OpenBaseJDBC.jar - /Library/Java/Extensions/. So the error text stating Driver not found in Java Runtime! does not make any sense to me. Because my model specifies a URL: jdbc:OpenBase which somehow instructs to use the above .jar file. And I was connected to this database last week. So now I do not know what else to check! Thanks for your help. Chuck Hill wrote: Use Spotlight to find OpenBaseJDBC.jar. You probably have it also in /Library/WebObjects/Extensions or some other inappropriate place. It should ONLY be in /Library/Java/Extensions Chuck On Feb 26, 2007, at 11:20 AM, Fred Shurtleff wrote: Hello All, I am unable to connect to a localhost OpenBase database that I had previously connected to last week. The console error is: An exception occurred while trying to open a channel:com.webobjects.jdbcadaptor.JDBCAdaptorException: JDBC connection failed for driver :'com.openbase.jdbc.ObDriver'. Driver not found in Java Runtime! Please verify your CLASSPATH environment variable. The current CLASSPATH for your application is :/System/ Since I did NOT see OpenBaseJDBC.jar in any of these search paths, I tried to add a new classpath variable pointing to /Library/Java/Extensions/OpenBaseJDBC.jar, but when I try to add it to the project Java Build Path, it complained that it was a duplicate entry (and would not let me save it). So now I am totally confused! I have checked my connection dictionary/params (they are correct), and the database is started/running. Can anyone suggest what may be the problem? Thank You ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net This email sent to [EMAIL PROTECTED] --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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/th-dev%40onlinehome.de This email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Problem Connecting to OpenBase
Hello All, I am unable to connect to a localhost OpenBase database that I had previously connected to last week. The console error is: An exception occurred while trying to open a channel:com.webobjects.jdbcadaptor.JDBCAdaptorException: JDBC connection failed for driver :'com.openbase.jdbc.ObDriver'. Driver not found in Java Runtime! Please verify your CLASSPATH environment variable. The current CLASSPATH for your application is :/System/ Since I did NOT see OpenBaseJDBC.jar in any of these search paths, I tried to add a new classpath variable pointing to /Library/Java/Extensions/OpenBaseJDBC.jar, but when I try to add it to the project Java Build Path, it complained that it was a duplicate entry (and would not let me save it). So now I am totally confused! I have checked my connection dictionary/params (they are correct), and the database is started/running. Can anyone suggest what may be the problem? Thank You ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: Problem Connecting to OpenBase
Use Spotlight to find OpenBaseJDBC.jar. You probably have it also in /Library/WebObjects/Extensions or some other inappropriate place. It should ONLY be in /Library/Java/Extensions Chuck On Feb 26, 2007, at 11:20 AM, Fred Shurtleff wrote: Hello All, I am unable to connect to a localhost OpenBase database that I had previously connected to last week. The console error is: An exception occurred while trying to open a channel:com.webobjects.jdbcadaptor.JDBCAdaptorException: JDBC connection failed for driver :'com.openbase.jdbc.ObDriver'. Driver not found in Java Runtime! Please verify your CLASSPATH environment variable. The current CLASSPATH for your application is :/System/ Since I did NOT see OpenBaseJDBC.jar in any of these search paths, I tried to add a new classpath variable pointing to /Library/Java/ Extensions/OpenBaseJDBC.jar, but when I try to add it to the project Java Build Path, it complained that it was a duplicate entry (and would not let me save it). So now I am totally confused! I have checked my connection dictionary/params (they are correct), and the database is started/running. Can anyone suggest what may be the problem? Thank You ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chill% 40global-village.net This email sent to [EMAIL PROTECTED] -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: Problem Connecting to OpenBase
Checked Spotlight and it is ONLY in /Library/Java/Extensions (and of course - /Application/OpenBase/Developer). Also I looked further into the project Java Build Path and do see JRE System Library(JVM 1.4.2) which contains the item OpenBaseJDBC.jar - /Library/Java/Extensions/. So the error text stating Driver not found in Java Runtime! does not make any sense to me. Because my model specifies a URL: jdbc:OpenBase which somehow instructs to use the above .jar file. And I was connected to this database last week. So now I do not know what else to check! Thanks for your help. Chuck Hill wrote: Use Spotlight to find OpenBaseJDBC.jar. You probably have it also in /Library/WebObjects/Extensions or some other inappropriate place. It should ONLY be in /Library/Java/Extensions Chuck On Feb 26, 2007, at 11:20 AM, Fred Shurtleff wrote: Hello All, I am unable to connect to a localhost OpenBase database that I had previously connected to last week. The console error is: An exception occurred while trying to open a channel:com.webobjects.jdbcadaptor.JDBCAdaptorException: JDBC connection failed for driver :'com.openbase.jdbc.ObDriver'. Driver not found in Java Runtime! Please verify your CLASSPATH environment variable. The current CLASSPATH for your application is :/System/ Since I did NOT see OpenBaseJDBC.jar in any of these search paths, I tried to add a new classpath variable pointing to /Library/Java/Extensions/OpenBaseJDBC.jar, but when I try to add it to the project Java Build Path, it complained that it was a duplicate entry (and would not let me save it). So now I am totally confused! I have checked my connection dictionary/params (they are correct), and the database is started/running. Can anyone suggest what may be the problem? Thank You ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net This email sent to [EMAIL PROTECTED] -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: Problem Connecting to OpenBase
If it is in /Library/Java/Extensions, then it is on the classpath. Period. End of story. So the error must be something else. What have you done since it was last working? Think hard, _something_ has changed. Things to check: - are you explicitly including it on the classpath someplace else? - is the JavaJDBCAdaptor.framework part of the project? - does a reboot help? Chuck On Feb 26, 2007, at 12:57 PM, Fred Shurtleff wrote: Checked Spotlight and it is ONLY in /Library/Java/Extensions (and of course - /Application/OpenBase/Developer). Also I looked further into the project Java Build Path and do see JRE System Library(JVM 1.4.2) which contains the item OpenBaseJDBC.jar - /Library/Java/Extensions/. So the error text stating Driver not found in Java Runtime! does not make any sense to me. Because my model specifies a URL: jdbc:OpenBase which somehow instructs to use the above .jar file. And I was connected to this database last week. So now I do not know what else to check! Thanks for your help. Chuck Hill wrote: Use Spotlight to find OpenBaseJDBC.jar. You probably have it also in /Library/WebObjects/Extensions or some other inappropriate place. It should ONLY be in /Library/Java/Extensions Chuck On Feb 26, 2007, at 11:20 AM, Fred Shurtleff wrote: Hello All, I am unable to connect to a localhost OpenBase database that I had previously connected to last week. The console error is: An exception occurred while trying to open a channel:com.webobjects.jdbcadaptor.JDBCAdaptorException: JDBC connection failed for driver :'com.openbase.jdbc.ObDriver'. Driver not found in Java Runtime! Please verify your CLASSPATH environment variable. The current CLASSPATH for your application is :/ System/ Since I did NOT see OpenBaseJDBC.jar in any of these search paths, I tried to add a new classpath variable pointing to / Library/Java/Extensions/OpenBaseJDBC.jar, but when I try to add it to the project Java Build Path, it complained that it was a duplicate entry (and would not let me save it). So now I am totally confused! I have checked my connection dictionary/params (they are correct), and the database is started/running. Can anyone suggest what may be the problem? Thank You ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chill% 40global-village.net This email sent to [EMAIL PROTECTED] -- 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 -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: Problem Connecting to OpenBase
On 26-Feb-07, at 5:25 PM, Timo Hoepfner wrote: ... some update (WO 533?) replaces the OpenBase driver ... I've been looking at what's updated by the WebObjects5.3.3Update.pkg and I don't see any updates happening in /Library/Java/Extensions Mac OS X 10.4.8, Xcode 2.4.1 on ppc I've not tried it on intel but but I expect it's the same since the update package has been marked for both platforms. (See my earlier post today.) For the record, my machine has: $ ls -al /Library/Java/Extensions/OpenBaseJDBC.jar -rw-rw-r-- 1 root admin 75331 Jan 13 2005 /Library/Java/ Extensions/OpenBaseJDBC.jar $ sum /Library/Java/Extensions/OpenBaseJDBC.jar 65223 74 /Library/Java/Extensions/OpenBaseJDBC.jar And I have receipt which says that the OpenBaseJDBC.jar is from WebObjectsDevelopment.pkg Hope that helps! Mark __ Mark Ritchie Cocoa and WebObjects Developer Diamond Lake Consulting Inc. Toronto, Ontario, Canada ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
OPENBASE and Deadlocks
Hello; I'm not sure if I mentioned this before, but one of my projects was having deadlock problems with high-volume writes out of a WOA into OPENBASE. I developed a subclassed adaptor for this -- so if anybody is interested in this, I put something in the wiki about it... http://en.wikibooks.org/wiki/Programming:WebObjects/ Database_Compatibility_and_Comparisons/OpenBase#Deadlocks cheers. ___ Andrew Lindesay www.lindesay.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: OPENBASE and Deadlocks
Hi Andrew, I think I understand now. So I think you are saying that OpenBase is detecting a deadlock and aborting a transaction, right? The solution you have posted on this page will work fine. You could also resave the transaction. I've made a small edit to the wiki to make it more clear that we are talking about the problem of aborting transactions to avoid deadlocks rather than a deadlocked server. Please let me know if I have misunderstood. Thanks. Best regards, Scott Keith OpenBase On Jan 17, 2007, at 11:31 PM, Andrew Lindesay wrote: Hello; I'm not sure if I mentioned this before, but one of my projects was having deadlock problems with high-volume writes out of a WOA into OPENBASE. I developed a subclassed adaptor for this -- so if anybody is interested in this, I put something in the wiki about it... http://en.wikibooks.org/wiki/Programming:WebObjects/ Database_Compatibility_and_Comparisons/OpenBase#Deadlocks cheers. ___ Andrew Lindesay www.lindesay.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
RE: OPENBASE and Deadlocks - follow-up
Hello again; I'm not sure if I mentioned this before, but one of my projects was having deadlock problems with high-volume writes out of a WOA into OPENBASE. I developed a subclassed adaptor for this -- so if anybody is interested in this, I put something in the wiki about it... I just want to follow up this post by adding that the behavior exhibited by the OPENBASE product is 100% correct -- this is not an issue with the database server. This is a database client-end solution that integrates with WebObjects applications for specifically solving this issue in the development of WebObjects applications. cheers. ___ Andrew Lindesay www.lindesay.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Openbase released 10.0.4
this version FIX the a bug that prevented syncronization of EOModel schema. Amedeo ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: [External type] boolean vs bool / openbase vs mysql
Hi Benoit, If you think you will need to develop with MySQL, take a look at CocoaMySQL (http://cocoamysql.sourceforge.net/index.html). Its an open source application used to manage MySQL with a GUI, and its very easy to use. Good Luck! Jacky On 06-10-12, at 10:33, Cantin Benoit wrote: Robert Walker wrote: Cantin, While prototypes are the specific answer to your question; I was wondering what the benefit is in developing using OpenBase when your deployment database is MySQL. MySQL is a free download and a simple package install on Mac OS X. Isn't is more sensible to just develop and deploy using MySQL. You may have a very good reason for this, but I was just curious. Robert, It is just a matter of time. Openbase is convenient when developping since it is easier to change datas when using OpenBase Manager than writing command lines for Mysql. That's why, I am using OpenBase when developing. But I do not have OpenBase installed on the server used for deployment. You may say I should have installed Mysql to develop. The thing is that this is a temporary situation as we may install OpenBase in the near future on the server. That's why I keep developping with OpenBase. Of course, the situation is quite annoying. But I hope it won't be long. Cheers, -- Benoit ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/jgagnon% 40druide.com This email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
[External type] boolean vs bool / openbase vs mysql
Hi list, Currently I test my applications on openbase. I deploy my application on mysql on a different server. Each time I switch from test to deployment, I have to swith the external type of my boolean properties in order to generate sql code. For mysql, external type for boolean is bool. For openbase, external type for boolean is boolean. Is there a way to get round of this so that I would not have to switch external type ? Thank you for all your help. It is much appreciate :) -- Benoit ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: [External type] boolean vs bool / openbase vs mysql
Prototypes are the way to go for that. Look at: http://en.wikibooks.org/wiki/Programming:WebObjects/EOF/Modeling/Prototypes and chapters in nearly every WebObjects book. cug On 10/12/06, Cantin Benoit [EMAIL PROTECTED] wrote: Hi list, Currently I test my applications on openbase. I deploy my application on mysql on a different server. Each time I switch from test to deployment, I have to swith the external type of my boolean properties in order to generate sql code. For mysql, external type for boolean is bool. For openbase, external type for boolean is boolean. Is there a way to get round of this so that I would not have to switch external type ? Thank you for all your help. It is much appreciate :) -- Benoit -- PostgreSQL Bootcamp, Big Nerd Ranch Europe, Nov 2006 http://www.bignerdranch.com/news/2006-08-21.shtml ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: [External type] boolean vs bool / openbase vs mysql
Guido Neitzer wrote: Prototypes are the way to go for that. Look at: http://en.wikibooks.org/wiki/Programming:WebObjects/EOF/Modeling/Prototypes and chapters in nearly every WebObjects book. cug Thanks for your quick answer. I will have have a look my practical webobjects too looking for prototypes. -- Benoit ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: [External type] boolean vs bool / openbase vs mysql
Cantin,While prototypes are the specific answer to your question; I was wondering what the benefit is in developing using OpenBase when your deployment database is MySQL. MySQL is a free download and a simple package install on Mac OS X. Isn't is more sensible to just develop and deploy using MySQL.You may have a very good reason for this, but I was just curious.On Oct 12, 2006, at 4:22 AM, Cantin Benoit wrote:Guido Neitzer wrote: Prototypes are the way to go for that. Look at:http://en.wikibooks.org/wiki/Programming:WebObjects/EOF/Modeling/Prototypesand chapters in nearly every WebObjects book.cug Thanks for your quick answer. I will have have a look my practical webobjects too looking for prototypes.-- Benoit___Do not post admin requests to the list. They will be ignored.Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)Help/Unsubscribe/Update your Subscription:http://lists.apple.com/mailman/options/webobjects-dev/robertwalker1%40mac.comThis email sent to [EMAIL PROTECTED] --Robert Walker[EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: [External type] boolean vs bool / openbase vs mysql
Robert Walker wrote: Cantin, While prototypes are the specific answer to your question; I was wondering what the benefit is in developing using OpenBase when your deployment database is MySQL. MySQL is a free download and a simple package install on Mac OS X. Isn't is more sensible to just develop and deploy using MySQL. You may have a very good reason for this, but I was just curious. Robert, It is just a matter of time. Openbase is convenient when developping since it is easier to change datas when using OpenBase Manager than writing command lines for Mysql. That's why, I am using OpenBase when developing. But I do not have OpenBase installed on the server used for deployment. You may say I should have installed Mysql to develop. The thing is that this is a temporary situation as we may install OpenBase in the near future on the server. That's why I keep developping with OpenBase. Of course, the situation is quite annoying. But I hope it won't be long. Cheers, -- Benoit ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Problem with setting Date data in Openbase 9 with a D2W App
Hi all, when using the D2WApp, and trying to insert the date ( DD Apr ), i got this error message : Could not save you changes : Format.parseObject(String) failed [birthday = 31 Jan 1989] Any clue ? In my EOModel i set the birthday attribute like that : external Type = date / Value Class (Java) = NSTimestamp / Value Type = T Thanks ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: Problem with setting Date data in Openbase 9 with a D2W App
Gilles,What data formatter pattern string are you using?On Aug 9, 2006, at 10:49 AM, Gilles MATHURIN wrote:Hi all, when using the D2WApp, and trying to insert the date ( DD Apr ), i got this error message : Could not save you changes : Format.parseObject(String) failed [birthday = 31 Jan 1989]Any clue ?In my EOModel i set the birthday attribute like that : external Type = date / Value Class (Java) = NSTimestamp / Value Type = TThanks___Do not post admin requests to the list. They will be ignored.Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)Help/Unsubscribe/Update your Subscription:http://lists.apple.com/mailman/options/webobjects-dev/robertwalker1%40mac.comThis email sent to [EMAIL PROTECTED] --Robert Walker[EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: Problem with setting Date data in Openbase 9 with a D2W App
HiMake sure you have downloaded the latest openbase JDBC connection library from openbase website!is really important! the version installed by Xcode (also 2.4), is old, and contain a but in Timestamp format !!also Xcode 2.4 installler replaces the openbase JDBC, then you need to reinstall it !http://store.openbase.com/cgi-bin/WebObjects/OBWebSite.woa/wa/download?id=221RegardsAmedeoOn 09/ago/06, at 17:01, Robert Walker wrote:Gilles,What data formatter pattern string are you using?On Aug 9, 2006, at 10:49 AM, Gilles MATHURIN wrote:Hi all, when using the D2WApp, and trying to insert the date ( DD Apr ), i got this error message : Could not save you changes : Format.parseObject(String) failed [birthday = 31 Jan 1989]Any clue ?In my EOModel i set the birthday attribute like that : external Type = date / Value Class (Java) = NSTimestamp / Value Type = TThanks___Do not post admin requests to the list. They will be ignored.Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)Help/Unsubscribe/Update your Subscription:http://lists.apple.com/mailman/options/webobjects-dev/robertwalker1%40mac.comThis email sent to [EMAIL PROTECTED] --Robert Walker[EMAIL PROTECTED] ___Do not post admin requests to the list. They will be ignored.Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)Help/Unsubscribe/Update your Subscription:http://lists.apple.com/mailman/options/webobjects-dev/amedeo%40macintossicati.comThis email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: MP3 or audio file and Openbase
I thanks you for the method you gave me and for all the ressources links too. I managed to have the WOEmbeddedObject play the MP3 file in Safari, i had to add a Binding : type = audio/mpeg to it in WOBuilder. Now it works great in every browser, with {data mimetype} But i think i'll do it your way anyway, because of the changes in the way IE deals with embedded object since he has lost his lawsuit. So i'll be able to integrate the necessary Javascript in the WO components / HTML… well i think i'll be able to … :-) Thanks again. Great to have this mailing-list for newbie to this amazing tool WebObject is ! Le 29 juin 06 à 17:58, Chuck Hill a écrit : Yes, it is possible. I know many WO sites that do things like this. It is just hard to understand all the pieces the first time. You need two things: 1. The WO components / HTML to define the plugin in HTML 2. A direct action (this is easiest, I think) so you have a URL to dynamically return the MP3 data (see downloading below) Then use the direct action URL as the src (I think that is the one) in the EMBED tag. I think you can do this all in one step with WOEmbeddedObject, but this way is probably easier to understand. Chuck On Jun 29, 2006, at 2:48 PM, Gilles MATHURIN wrote: In fact, yes i'd like to use a plugin to play the MP3 files, which come from the database… i begin to think that it is not possible using a database… :-/ Début du message réexpédié : De : Gilles MATHURIN [EMAIL PROTECTED] Date : 29 juin 2006 17:29:17 GMT-04:00 À : Chuck Hill [EMAIL PROTECTED] Objet : Rép : MP3 or audio file and Openbase Thanx for the ressource adress, beside, when i clik on the link you provide me, the browser download an m3u.file launched by iTunes next, this i don't want, i would like to implement in a dynamic way the type of link you can see here : http://homepage.mac.com/golden.ears/SoftSite/Docs/Media.html Where the song extract come from the database and played in another window by the Quicktime plug-in or whatever plugin who deals with mp3 file. i hope being clear in my explanation. Gilles. Le 29 juin 06 à 17:02, Chuck Hill a écrit : Why are you using WOEmbeddedObject? Are you using a plugin to play the MP3 files? If so, the functionality from that will depend on the plugin you are using and the browser. If you want the users to click a link to play the music like here: http://www.amazon.com/gp/product/B000BG1PHA/104-7083027-7290363 Then you need to provide a link to download the MP3. Search for 'download' on http://wocode.com for code examples of how to do this. Chuck On Jun 29, 2006, at 1:45 PM, Gilles MATHURIN wrote: I am sorry for the mistake in my post , i clicked the wrong thread (Unable to find entity for object) :-( Here the message : Concerning my problem : i use a WOEmbeddedObject to show the mp3 files, and yes they all end in .mp3, i set the mime-type of the WOEmbeddedObject to audio/mpeg it supposes to work well this way, but apparently i am wrong :-/ I didn't specify a content-type header unless it's specifying a mime-type do so… Thanks for help. Gilles. -- Coming sometime... - an introduction to web applications using WebObjects and Xcode http://www.global-village.net/wointro 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
MP3 or audio file and Openbase
Hi, everyone I am working on a project of a little music label website driven by a database. I must add that i am new to WO and generally speaking to dynamic website conception. I have done only static website still and add a little base in OO programming and Java. So i have worked on it for about 3 weeks, and while i have made a pretty good EOModel, experiment it with D2W and the WOComponent thanx to the Apple tutorial and all of the great stuff i have found on the web (special thanxs to david.codeferous.com, http://homepage.mac.com/ kelleherk/iblog/ , and the WO wiki !!) i succeed in manipulate the textual information, and the pictures stored in my database, but i'm very frustrating with the audio file. I manage to upload them in the database but they won't display and play in the website, i only got the Quicktime Icon on Safari. Meanwhile the same code let me hear the sound on Camino. Anyone can give me some clue to deal with that ? Thanks for help. Yours. PS : i am a french native speaker, so the french WO Geek can adress me directly by mail :-) ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: MP3 or audio file and Openbase
On Jun 29, 2006, at 6:16 AM, Gilles MATHURIN wrote: Hi, everyone I am working on a project of a little music label website driven by a database. I must add that i am new to WO and generally speaking to dynamic website conception. I have done only static website still and add a little base in OO programming and Java. So i have worked on it for about 3 weeks, and while i have made a pretty good EOModel, experiment it with D2W and the WOComponent thanx to the Apple tutorial and all of the great stuff i have found on the web (special thanxs to david.codeferous.com, http:// homepage.mac.com/kelleherk/iblog/ , and the WO wiki !!) i succeed in manipulate the textual information, and the pictures stored in my database, but i'm very frustrating with the audio file. I manage to upload them in the database but they won't display and play in the website, i only got the Quicktime Icon on Safari. Meanwhile the same code let me hear the sound on Camino. Anyone can give me some clue to deal with that ? It sounds like the content-type header you are sending is not correct for the audio files or that the files are not recognized by the browser. Do the file names all end in .mp3 or something else? What is the code you are using to download the audio files? Chuck -- Coming sometime... - an introduction to web applications using WebObjects and Xcode http://www.global-village.net/wointro 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: Re: MP3 or audio file and Openbase
I am sorry for the mistake in my post , i clicked the wrong thread (Unable to find entity for object) :-( Here the message : Concerning my problem : i use a WOEmbeddedObject to show the mp3 files, and yes they all end in .mp3, i set the mime-type of the WOEmbeddedObject to audio/mpeg it supposes to work well this way, but apparently i am wrong :-/ I didn't specify a content-type header unless it's specifying a mime-type do so… Thanks for help. Gilles. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: MP3 or audio file and Openbase
Why are you using WOEmbeddedObject? Are you using a plugin to play the MP3 files? If so, the functionality from that will depend on the plugin you are using and the browser. If you want the users to click a link to play the music like here: http://www.amazon.com/gp/product/B000BG1PHA/104-7083027-7290363 Then you need to provide a link to download the MP3. Search for 'download' on http://wocode.com for code examples of how to do this. Chuck On Jun 29, 2006, at 1:45 PM, Gilles MATHURIN wrote: I am sorry for the mistake in my post , i clicked the wrong thread (Unable to find entity for object) :-( Here the message : Concerning my problem : i use a WOEmbeddedObject to show the mp3 files, and yes they all end in .mp3, i set the mime-type of the WOEmbeddedObject to audio/mpeg it supposes to work well this way, but apparently i am wrong :-/ I didn't specify a content-type header unless it's specifying a mime-type do so… Thanks for help. Gilles. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chill% 40global-village.net This email sent to [EMAIL PROTECTED] -- Coming sometime... - an introduction to web applications using WebObjects and Xcode http://www.global-village.net/wointro 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: MP3 or audio file and Openbase
or http://en.wikibooks.org/wiki/Programming:WebObjects/Web_Applications/ Development/Examples/Return_a_File and http://en.wikibooks.org/wiki/Programming:WebObjects/Web_Applications/ Development/Database_vs_Filesystem has some information that might be helpful On Jun 29, 2006, at 5:02 PM, Chuck Hill wrote: Why are you using WOEmbeddedObject? Are you using a plugin to play the MP3 files? If so, the functionality from that will depend on the plugin you are using and the browser. If you want the users to click a link to play the music like here: http://www.amazon.com/gp/product/B000BG1PHA/104-7083027-7290363 Then you need to provide a link to download the MP3. Search for 'download' on http://wocode.com for code examples of how to do this. Chuck On Jun 29, 2006, at 1:45 PM, Gilles MATHURIN wrote: I am sorry for the mistake in my post , i clicked the wrong thread (Unable to find entity for object) :-( Here the message : Concerning my problem : i use a WOEmbeddedObject to show the mp3 files, and yes they all end in .mp3, i set the mime-type of the WOEmbeddedObject to audio/mpeg it supposes to work well this way, but apparently i am wrong :-/ I didn't specify a content-type header unless it's specifying a mime-type do so… Thanks for help. Gilles. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chill% 40global-village.net This email sent to [EMAIL PROTECTED] -- Coming sometime... - an introduction to web applications using WebObjects and Xcode http://www.global-village.net/wointro 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/mschrag% 40mdimension.com This email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
Re: MP3 or audio file and Openbase
I was trying to find that migrated WODev content and could not. Is there a useful search (e.g. focused on this one wiki book) feature in that Wiki that I am missing? I used to use the Search in Pierre's site all the time! Chuck On Jun 29, 2006, at 2:09 PM, Mike Schrag wrote: or http://en.wikibooks.org/wiki/Programming:WebObjects/ Web_Applications/Development/Examples/Return_a_File and http://en.wikibooks.org/wiki/Programming:WebObjects/ Web_Applications/Development/Database_vs_Filesystem has some information that might be helpful On Jun 29, 2006, at 5:02 PM, Chuck Hill wrote: Why are you using WOEmbeddedObject? Are you using a plugin to play the MP3 files? If so, the functionality from that will depend on the plugin you are using and the browser. If you want the users to click a link to play the music like here: http://www.amazon.com/gp/product/B000BG1PHA/104-7083027-7290363 Then you need to provide a link to download the MP3. Search for 'download' on http://wocode.com for code examples of how to do this. Chuck On Jun 29, 2006, at 1:45 PM, Gilles MATHURIN wrote: I am sorry for the mistake in my post , i clicked the wrong thread (Unable to find entity for object) :-( Here the message : Concerning my problem : i use a WOEmbeddedObject to show the mp3 files, and yes they all end in .mp3, i set the mime-type of the WOEmbeddedObject to audio/mpeg it supposes to work well this way, but apparently i am wrong :-/ I didn't specify a content-type header unless it's specifying a mime-type do so… Thanks for help. Gilles. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chill% 40global-village.net This email sent to [EMAIL PROTECTED] -- Coming sometime... - an introduction to web applications using WebObjects and Xcode http://www.global-village.net/wointro 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/mschrag% 40mdimension.com This email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chill% 40global-village.net This email sent to [EMAIL PROTECTED] -- Coming sometime... - an introduction to web applications using WebObjects and Xcode http://www.global-village.net/wointro 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com