Re: SQLSERVER PlugIn for WebObjects
Re: SQLSERVER PlugIn for WebObjects
- Subject: Re: SQLSERVER PlugIn for WebObjects
- From: Jérémy DE ROYER <email@hidden>
- Date: Wed, 1 Dec 2010 19:05:45 +0100
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@hidden 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@hidden)
>>>>>> Help/Unsubscribe/Update your Subscription:
>>>>>>
>>>>>> This email sent to email@hidden
>>>>>
>>>>> --
>>>>> 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@hidden)
>>>> Help/Unsubscribe/Update your Subscription:
>>>>
>>>> This email sent to email@hidden
>>>
>>> --
>>> 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@hidden)
>>> Help/Unsubscribe/Update your Subscription:
>>>
>>> This email sent to email@hidden
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>
> --
> 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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden