No. It defines what the database server understands. This information is from the MS SQL Server JDBC driver.
Chuck On Dec 1, 2010, at 10:09 AM, Jérémy DE ROYER wrote: > 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 >> >> >> >> >> >> >> > -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (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
