I followed Dave Meurer's demo on scaffolding & deploying to GAE pretty much verbatim found - http://www.youtube.com/watch?v=logAmwRMTiQ
Only differences is that I am connecting to Google Cloud SQL not amazon cloud db. My database connects fine within MyEclipse connection wizard. But the scaffolding wizard fails in last step with following stack trace: java.lang.RuntimeException: Error invoking function: initializeCrud with parameters: [Ljava.lang.Object;@71bfa007 at org.skyway.core.generate.snippet.function.FunctionInvoker.invoke(FunctionInvoker.java:102) at org.skyway.core.generate.snippet.function.FunctionSnippetExpression.evaluate(FunctionSnippetExpression.java:26) at org.skyway.core.generate.snippet.SnippetRegistry.evaluate(SnippetRegistry.java:88) at org.skyway.core.generate.snippet.SnippetRegistry.getObjectAttribute(SnippetRegistry.java:99) at org.skyway.core.generate.generator.invoke.InvokeSnippetGenerator.generate(InvokeSnippetGenerator.java:24) at org.skyway.core.generate.generator.DescendantGenerator.generateChild(DescendantGenerator.java:28) at org.skyway.core.generate.generator.DescendantGenerator.generateChildren(DescendantGenerator.java:21) at org.skyway.core.generate.generator.DescendantGenerator.generate(DescendantGenerator.java:14) at org.skyway.core.generate.generator.control.ResourceGenerator.generate(ResourceGenerator.java:19) at org.skyway.core.generate.execute.GenerationJob.generate(GenerationJob.java:115) at org.skyway.core.generate.execute.GenerationJob$1.run(GenerationJob.java:59) at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2344) at org.skyway.core.generate.execute.GenerationJob.run(GenerationJob.java:55) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) Caused by: java.lang.RuntimeException: Unable to load data type from table(s): [org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@3a749623, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@3c2cf1d0] at org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInputProvider.generateDataTypes(TableDataTypeInputProvider.java:222) at org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInputProvider.getDataTypes(TableDataTypeInputProvider.java:73) at com.skyway.scaffolding.crud.datatype.FilteredDataTypeInputProvider.getDataTypes(FilteredDataTypeInputProvider.java:33) at com.skyway.scaffolding.crud.util.ContextAwareCrudFunctions.getDataTypes(ContextAwareCrudFunctions.java:181) at com.skyway.scaffolding.crud.util.ContextAwareCrudFunctions.initializeCrud(ContextAwareCrudFunctions.java:55) 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.skyway.core.generate.snippet.function.FunctionInvoker.invoke(FunctionInvoker.java:94) ... 13 more Caused by: org.hibernate.exception.GenericJDBCException: Could not get list of tables from database. Probably a JDBC driver problem. Configured schema:null Configured catalog:null Available schemas: Available catalogs: information_schema example guestbook mysql performance_schema at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect.getTables(OracleMetaDataDialect.java:257) at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:476) at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:74) at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:860) at org.hibernate.cfg.JDBCBinder.readDatabaseSchema(JDBCBinder.java:121) at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:94) at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:42) at org.skyway.integration.data.persistence.importer.hibernate.HibernateModelGenerator.createJDBCConfiguration(HibernateModelGenerator.java:227) at org.skyway.integration.data.persistence.importer.hibernate.HibernateModelGenerator.generateModel(HibernateModelGenerator.java:96) at org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInputProvider.generateDataTypes(TableDataTypeInputProvider.java:208) ... 22 more Caused by: java.sql.SQLException: No database selected at com.google.cloud.sql.jdbc.internal.Exceptions.newSqlException(Exceptions.java:208) at com.google.cloud.sql.jdbc.internal.SqlProtoClient.check(SqlProtoClient.java:198) at com.google.cloud.sql.jdbc.internal.SqlProtoClient.executeSql(SqlProtoClient.java:87) at com.google.cloud.sql.jdbc.internal.SqlProtoClient.executeSql(SqlProtoClient.java:76) at com.google.cloud.sql.jdbc.Connection.executeSql(Connection.java:520) at com.google.cloud.sql.jdbc.PreparedStatement.executeSqlImpl(PreparedStatement.java:141) at com.google.cloud.sql.jdbc.Statement.executeImpl(Statement.java:154) at com.google.cloud.sql.jdbc.Statement.executeQuery(Statement.java:327) at com.google.cloud.sql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:128) at com.google.cloud.sql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:57) at org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect.getTableResultSet(OracleMetaDataDialect.java:667) at org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect.getTables(OracleMetaDataDialect.java:221) ... 31 more Basically, on the select database tables dialog of this wizard The Dialect is 'Auto Detect' and MetaData Dialect is set to Default. This is true for the video as well. It fails on my end. After retrying and selecting dialect as hibernate mysql or mysql 5 still fails. Retrying with metadata dialect as only option org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect. fails again. I'm assuming that the dialects and MetaDAta Dialects support for google cloud mysql 5.5 are not currently available in version 10 of myeclipse and this is the reason for the failure. Please validate, provide thoughts. Clearly integration to google cloud sql for GAE / J is going to be an important feature moving forward. Any help would be appreciated at this point. Best paul -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-appengine-java/-/wpUlPNBp040J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
