Here is a list of column types valid for SQL Server 2005:
ERXMicrosoftPlugInJDBCInfo.plist
Description: Binary data
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 >>>> [email protected] >>>> 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 ([email protected]) >>>>>>> Help/Unsubscribe/Update your Subscription: >>>>>>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net >>>>>>> >>>>>>> This email sent to [email protected] >>>>>> >>>>>> -- >>>>>> Chuck Hill Senior Consultant / VP Development >>>>>> >>>>>> Practical WebObjects - for developers who want to increase their overall >>>>>> knowledge of WebObjects or who are trying to solve specific problems. >>>>>> http://www.global-village.net/products/practical_webobjects >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> Do not post admin requests to the list. They will be ignored. >>>>> Webobjects-dev mailing list ([email protected]) >>>>> Help/Unsubscribe/Update your Subscription: >>>>> http://lists.apple.com/mailman/options/webobjects-dev/mhast%40desertsky.com >>>>> >>>>> This email sent to [email protected] >>>> >>>> -- >>>> 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 ([email protected]) >>>> Help/Unsubscribe/Update your Subscription: >>>> http://lists.apple.com/mailman/options/webobjects-dev/jeremy.deroyer%40ingencys.net >>>> >>>> This email sent to [email protected] >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list ([email protected]) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net >>> >>> This email sent to [email protected] >> >> -- >> Chuck Hill Senior Consultant / VP Development >> >> Practical WebObjects - for developers who want to increase their overall >> knowledge of WebObjects or who are trying to solve specific problems. >> http://www.global-village.net/products/practical_webobjects >> >> >> >> >> >> >> > -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
