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:01:47 +0100
Thank's. Work's great !
As both "INT" "INTEGER" work with Frontbase I thought "INTEGER" was universal...
Let's dance with prototypes now (Chuck's book page 45) !
Jérémy
Le 1 déc. 2010 à 18:50, David Avendasora a écrit :
> I believe that the problem is that you are using "INTEGER" as the external type. I belive that SQLServer doesn't have a datatype called "INTEGER" - try "int"
>
> Dave
>
> On Dec 1, 2010, at 12:15 PM, 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
>>
>>
>
_______________________________________________
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