I though this file was used to the plug in to "translate" the sql... like "prototypes".
Jérémy Le 1 déc. 2010 à 19:07, Chuck Hill a écrit : > Here is a list of column types valid for SQL Server 2005: > > <ERXMicrosoftPlugInJDBCInfo.plist> > > > On Dec 1, 2010, at 10:05 AM, Jérémy DE ROYER wrote: > >> I was only using Frontbase... from now >> >> And even if I am a early reader of your book. Prototypes are the thing I >> didn't use from now. I will have to change... all my models ! >> >> Hope it may help developpers who don't care about prototypes. >> >> Jérémy >> >> Le 1 déc. 2010 à 19:01, Chuck Hill a écrit : >> >>> You are doing two things wrong: >>> >>> 1. You are not using prototypes. This is foolish. >>> http://wiki.objectstyle.org/confluence/display/WO/EOF-Modeling-Prototypes >>> >>> >>> 2. The correct type is "int" not "INTEGER". >>> >>> >>> >>> Chuck >>> >>> >>> On Dec 1, 2010, at 9:44 AM, Jérémy DE ROYER wrote: >>> >>>> What I've done : >>>> - download the framework from chuck's website >>>> - copy in /Library/Frameworks >>>> - add it to the build path in wolips >>>> - create a new eomodel with Driver = >>>> "com.microsoft.sqlserver.jdbc.SQLServerDriver" and PlugIn = >>>> "com.webobjects.jdbcadaptor.ERXMicrosoftPlugIn" >>>> - create a simple table with id (integer) and title (varchar) >>>> { >>>> attributes = ( >>>> { >>>> columnName = ID; >>>> externalType = INTEGER; >>>> name = id; >>>> valueClassName = NSNumber; >>>> valueType = i; >>>> }, >>>> { >>>> columnName = TITLE; >>>> externalType = VARCHAR; >>>> name = title; >>>> valueClassName = NSString; >>>> width = 100; >>>> } >>>> ); >>>> attributesUsedForLocking = (id, title); >>>> className = TestTable; >>>> classProperties = (name); >>>> externalName = "TEST_TABLE"; >>>> fetchSpecificationDictionary = {}; >>>> internalInfo = {"_javaClientClassName" = TestTable; }; >>>> name = TestTable; >>>> primaryKeyAttributes = (id); >>>> } >>>> >>>> - generate sql >>>> (error) >>>> >>>> Anything else to set up ? >>>> >>>> Jérémy >>>> >>>> >>>> >>>> Le 1 déc. 2010 à 18:34, Michael Hast a écrit : >>>> >>>>> Hi : >>>>> >>>>> I am using Chucks SQLServer PlugIn. Below is from another email that I >>>>> have saved: >>>>> >>>>> On Apr 9, 2009, at 5:57 AM, David Avendasora wrote: >>>>> >>>>>>> Hi Chuck, >>>>>>> >>>>>>> I'm wondering if there is a more recent version of the >>>>>>> MicrosoftPlugin. I have a version you sent out on September 26th >>>>>>> last year. I'm upgrading to 5.4 finally, and it is still not in >>>>>>> Wonder (why, Anjo?). >>>>> >>>>> I keep it up to date here for now: >>>>> http://www.gvcsitemaker.com/chill/ms_sql_server_eof_plugin >>>>> >>>>> Also there is a probable explanation for why it is not in Wonder. >>>>> >>>>> 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 >>>>> ------------------------------------------------------------------------------ >>>>> This SF.net email is sponsored by: High Quality Requirements in a >>>>> Collaborative Environment. Download a free trial of Rational Requirements >>>>> Composer Now! http://p.sf.net/sfu/www-ibm-com >>>>> _______________________________________________ Wonder-disc mailing list >>>>> wonder-d...@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/wonder-disc >>>>> >>>>> On 12/1/2010 10:29 AM, Jérémy DE ROYER wrote: >>>>>> Hi, >>>>>> >>>>>> No reverse engineer, just create a new database and generate SQL from >>>>>> eomodeler. >>>>>> >>>>>> Jérémy >>>>>> >>>>>> Le 1 déc. 2010 à 18:24, Chuck Hill a écrit : >>>>>> >>>>>>> Are you trying to reverse engineer a database? I have not done >>>>>>> anything to get that to work. >>>>>>> >>>>>>> Chuck >>>>>>> >>>>>>> >>>>>>> On Dec 1, 2010, at 9:15 AM, Jérémy DE ROYER wrote: >>>>>>> >>>>>>>> Hello, >>>>>>>> >>>>>>>> I was asked if we could use SQL Server as database server. >>>>>>>> >>>>>>>> I've tried to set it up using MicrosoftPlugIn and ERXMicrosoftPlugIn >>>>>>>> and whatever I do or use, I get the error here after. >>>>>>>> >>>>>>>> I've seen a file called ERXMicrosoftPlugInJDBCInfo.plist that should >>>>>>>> solve to problem but don't know how to set it. >>>>>>>> >>>>>>>> Have someone succeded using SQL Server ? How ? >>>>>>>> >>>>>>>> Jérémy DE ROYER >>>>>>>> >>>>>>>> java.lang.RuntimeException: Failed to generate SQL. >>>>>>>> at >>>>>>>> org.objectstyle.wolips.eomodeler.core.sql.EOFSQLGeneratorFactory$ReflectionSQLGenerator.generateSchemaCreationScript(EOFSQLGeneratorFactory.java:67) >>>>>>>> at >>>>>>>> org.objectstyle.wolips.eomodeler.actions.GenerateSQLDialog.generateSql(GenerateSQLDialog.java:298) >>>>>>>> at >>>>>>>> org.objectstyle.wolips.eomodeler.actions.GenerateSQLDialog$1.run(GenerateSQLDialog.java:279) >>>>>>>> at java.lang.Thread.run(Thread.java:680) >>>>>>>> Caused by: java.lang.reflect.InvocationTargetException >>>>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>>>>>> at >>>>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>>>>>>> at >>>>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>>>>>>> at java.lang.reflect.Method.invoke(Method.java:597) >>>>>>>> at >>>>>>>> org.objectstyle.wolips.eomodeler.core.sql.EOFSQLGeneratorFactory$ReflectionSQLGenerator.generateSchemaCreationScript(EOFSQLGeneratorFactory.java:65) >>>>>>>> ... 3 more >>>>>>>> Caused by: com.webobjects.jdbcadaptor.JDBCAdaptorException: Unable to >>>>>>>> find type information for external type 'INTEGER' in attribute 'id' of >>>>>>>> entity 'TestTable'. Check spelling and capitalization. >>>>>>>> at >>>>>>>> com.webobjects.jdbcadaptor.JDBCExpression.columnTypeStringForAttribute(JDBCExpression.java:289) >>>>>>>> at >>>>>>>> com.webobjects.eoaccess.EOSQLExpression.addCreateClauseForAttribute(EOSQLExpression.java:2498) >>>>>>>> at >>>>>>>> com.webobjects.eoaccess.EOSynchronizationFactory.createTableStatementsForEntityGroup(EOSynchronizationFactory.java:318) >>>>>>>> at >>>>>>>> com.webobjects.eoaccess.EOSynchronizationFactory.createTableStatementsForEntityGroups(EOSynchronizationFactory.java:487) >>>>>>>> at >>>>>>>> com.webobjects.eoaccess.EOSynchronizationFactory.schemaCreationStatementsForEntities(EOSynchronizationFactory.java:951) >>>>>>>> at >>>>>>>> com.webobjects.jdbcadaptor.ERXMicrosoftPlugIn$ERXMicrosoftSynchronizationFactory.schemaCreationScriptForEntities(Unknown >>>>>>>> Source) >>>>>>>> at >>>>>>>> org.objectstyle.wolips.eomodeler.core.sql.EOFSQLGenerator53.generateSchemaCreationScript(EOFSQLGenerator53.java:483) >>>>>>>> ... 8 more >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> 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/mhast%40desertsky.com >>>>>> >>>>>> This email sent to mh...@desertsky.com >>>>> >>>>> -- >>>>> Tel: (520) 572-9410 >>>>> Desert Sky Software: www.desertsky.com >>>>> Specializing in the Development and Hosting of >>>>> e-Business Applications. >>>>> _______________________________________________ >>>>> 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/jeremy.deroyer%40ingencys.net >>>>> >>>>> This email sent to jeremy.dero...@ingencys.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: >>>> 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 >>> >>> >>> >>> >>> >>> >>> >> > > -- > 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
