Hello, I am trying to make a port of faceCart http://facecart.com shopping platform for resin. Currently faceCart is working under JBoss.
I have configured the database driver. I also have persistence.xml everything looks fine except that it says that there is no such column after in the database there is!!! I try to rename the column but still it gives the same error. I tryed to change the default Open JP with hibernate but still the same error. Can you please help me? I am totaly lost. com.caucho.config.ConfigException: 'LANGUAGESID' is not a valid database column in table 'manufacturers_info'. Either the table needs to be created or the create-database-tables attribute must be set. [21:59:11.663] [21:59:11.663] select LANGUAGESID from manufacturers_info where 1=0 [21:59:11.663] [21:59:11.663] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'LANGUAGESID' in 'field list' [21:59:11.663] at com.caucho.amber.table.Column.error(Column.java:436) [21:59:11.663] at com.caucho.amber.table.Column.validateDatabase(Column.java:315) [21:59:11.663] at com.caucho.amber.table.Table.validateDatabaseTable(Table.java:430) [21:59:11.663] at com.caucho.amber.manager.AmberPersistenceUnit.initTables(AmberPersistenceUnit.java:1378) [21:59:11.663] at com.caucho.amber.manager.AmberPersistenceUnit.generate(AmberPersistenceUnit.java:956) [21:59:11.663] at com.caucho.amber.cfg.PersistenceUnitConfig.init(PersistenceUnitConfig.java:247) [21:59:11.663] at com.caucho.amber.manager.AmberContainer.addPersistenceRoot(AmberContainer.java:580) [21:59:11.663] at com.caucho.amber.manager.PersistenceEnvironmentListener.addLoader(PersistenceEnvironmentListener.java:76) [21:59:11.663] at com.caucho.loader.EnvironmentClassLoader.addLoaderListener(EnvironmentClassLoader.java:411) [21:59:11.663] at com.caucho.loader.Environment.addChildLoaderListener(Environment.java:180) [21:59:11.663] at com.caucho.loader.Environment.addChildLoaderListener(Environment.java:166) [21:59:11.663] at com.caucho.ejb.EJBServer.manualInit(EJBServer.java:738) [21:59:11.663] at com.caucho.ejb.EJBServer.init(EJBServer.java:670) [21:59:11.663] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [21:59:11.663] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [21:59:11.663] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [21:59:11.663] at java.lang.reflect.Method.invoke(Method.java:597) [21:59:11.663] at com.caucho.config.j2ee.PostConstructProgram.configureImpl(PostConstructProgram.java:62) [21:59:11.663] at com.caucho.config.BeanTypeStrategy.init(BeanTypeStrategy.java:382) [21:59:11.663] at com.caucho.config.NodeBuilder.configureChildNode(NodeBuilder.java:411) [21:59:11.663] at com.caucho.config.NodeBuilder.configureNode(NodeBuilder.java:296) [21:59:11.663] at com.caucho.config.NodeBuilder.configureBean(NodeBuilder.java:202) [21:59:11.663] at com.caucho.config.Config.configureBean(Config.java:296) [21:59:11.663] at com.caucho.config.Config.configureBean(Config.java:267) [21:59:11.663] at com.caucho.config.core.ResinImport.init(ResinImport.java:137) [21:59:11.663] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [21:59:11.663] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [21:59:11.663] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [21:59:11.663] at java.lang.reflect.Method.invoke(Method.java:597) [21:59:11.663] at com.caucho.config.j2ee.PostConstructProgram.configureImpl(PostConstructProgram.java:62) [21:59:11.663] at com.caucho.config.BeanTypeStrategy.init(BeanTypeStrategy.java:382) [21:59:11.663] at com.caucho.config.NodeBuilder.configureChildNode(NodeBuilder.java:411) [21:59:11.663] at com.caucho.config.NodeBuilder.configureAttribute(NodeBuilder.java:241) [21:59:11.663] at com.caucho.config.NodeBuilderChildProgram.configureImpl(NodeBuilderChildProgram.java:58) [21:59:11.663] at com.caucho.config.BuilderProgramContainer.configureImpl(BuilderProgramContainer.java:66) [21:59:11.663] at com.caucho.config.BuilderProgram.configure(BuilderProgram.java:68) [21:59:11.663] at com.caucho.server.deploy.EnvironmentDeployController.configureInstance(EnvironmentDeployController.java:388) [21:59:11.663] at com.caucho.server.deploy.EnvironmentDeployController.configureInstance(EnvironmentDeployController.java:61) [21:59:11.663] at com.caucho.server.deploy.DeployController.startImpl(DeployController.java:644) [21:59:11.663] at com.caucho.server.deploy.StartAutoRedeployAutoStrategy.startOnInit(StartAutoRedeployAutoStrategy.java:72) [21:59:11.663] at com.caucho.server.deploy.DeployController.startOnInit(DeployController.java:528) [21:59:11.663] at com.caucho.server.deploy.DeployContainer.start(DeployContainer.java:163) [21:59:11.663] at com.caucho.server.webapp.WebAppContainer.start(WebAppContainer.java:675) [21:59:11.663] at com.caucho.server.host.Host.start(Host.java:437) [21:59:11.663] at com.caucho.server.deploy.DeployController.startImpl(DeployController.java:646) [21:59:11.663] at com.caucho.server.deploy.StartAutoRedeployAutoStrategy.startOnInit(StartAutoRedeployAutoStrategy.java:72) [21:59:11.663] at com.caucho.server.deploy.DeployController.startOnInit(DeployController.java:528) [21:59:11.663] at com.caucho.server.deploy.DeployContainer.start(DeployContainer.java:163) [21:59:11.663] at com.caucho.server.host.HostContainer.start(HostContainer.java:479) [21:59:11.663] at com.caucho.server.cluster.Server.start(Server.java:1151) [21:59:11.663] at com.caucho.server.cluster.Cluster.startServer(Cluster.java:719) [21:59:11.663] at com.caucho.server.cluster.ClusterServer.startServer(ClusterServer.java:455) [21:59:11.663] at com.caucho.server.resin.Resin.start(Resin.java:694) [21:59:11.663] at com.caucho.server.resin.Resin.initMain(Resin.java:1114) [21:59:11.663] at com.caucho.server.resin.Resin.main(Resin.java:1316) [21:59:11.663] Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'LANGUAGESID' in 'field list' [21:59:11.663] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) [21:59:11.663] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) [21:59:11.663] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) [21:59:11.663] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) [21:59:11.663] at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) [21:59:11.663] at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) [21:59:11.663] at com.mysql.jdbc.Statement.executeQuery(Statement.java:1169) [21:59:11.663] at com.mysql.jdbc.jdbc2.optional.StatementWrapper.executeQuery(StatementWrapper.java:705) [21:59:11.663] at com.caucho.sql.UserStatement.executeQuery(UserStatement.java:132) [21:59:11.663] at com.caucho.amber.table.Column.validateDatabase(Column.java:311) [21:59:11.663] ... 53 more -- View this message in context: http://www.nabble.com/not-a-valid-database-column-tp14931618p14931618.html Sent from the Resin mailing list archive at Nabble.com. _______________________________________________ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest