Re: SQLSERVER PlugIn for WebObjects
Re: SQLSERVER PlugIn for WebObjects
- Subject: Re: SQLSERVER PlugIn for WebObjects
- From: Chuck Hill <email@hidden>
- Date: Wed, 1 Dec 2010 10:36:56 -0800
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 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
>>
>>
>>
>>
>>
>>
>>
>
--
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
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
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