Re: SQLSERVER PlugIn for WebObjects
Re: SQLSERVER PlugIn for WebObjects
- Subject: Re: SQLSERVER PlugIn for WebObjects
- From: "Cheong Hee (Gmail)" <email@hidden>
- Date: Thu, 2 Dec 2010 12:09:16 +0800
Looks like you are still using FrontBase jdbc2Info. Look into
index.eomodeld, and try to change those to MSSQL jdbc2Info.
Cheers
Cheong Hee
----- Original Message -----
From: "Jérémy DE ROYER" <email@hidden>
To: "Chuck Hill" <email@hidden>
Cc: "WebObjects-Dev Mailing List List" <email@hidden>
Sent: Thursday, December 02, 2010 2:09 AM
Subject: Re: SQLSERVER PlugIn for WebObjects
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
_______________________________________________
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