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 (Webobjects-dev@lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com >> >> This email sent to webobje...@avendasora.com >> >> > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com