• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: SQLSERVER PlugIn for WebObjects
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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:09:44 +0100

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 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
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>
> --
> 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

  • Follow-Ups:
    • Re: SQLSERVER PlugIn for WebObjects
      • From: "Cheong Hee (Gmail)" <email@hidden>
    • Re: SQLSERVER PlugIn for WebObjects
      • From: Chuck Hill <email@hidden>
References: 
 >SQLSERVER PlugIn for WebObjects (From: Jérémy DE ROYER <email@hidden>)
 >Re: SQLSERVER PlugIn for WebObjects (From: Chuck Hill <email@hidden>)
 >Re: SQLSERVER PlugIn for WebObjects (From: Jérémy DE ROYER <email@hidden>)
 >Re: SQLSERVER PlugIn for WebObjects (From: Michael Hast <email@hidden>)
 >Re: SQLSERVER PlugIn for WebObjects (From: Jérémy DE ROYER <email@hidden>)
 >Re: SQLSERVER PlugIn for WebObjects (From: Chuck Hill <email@hidden>)
 >Re: SQLSERVER PlugIn for WebObjects (From: Jérémy DE ROYER <email@hidden>)
 >Re: SQLSERVER PlugIn for WebObjects (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: SQLSERVER PlugIn for WebObjects
  • Next by Date: Re: SQLSERVER PlugIn for WebObjects
  • Previous by thread: Re: SQLSERVER PlugIn for WebObjects
  • Next by thread: Re: SQLSERVER PlugIn for WebObjects
  • Index(es):
    • Date
    • Thread