Ok it recovers the one thing not made clear is you have to view source t see the output. so all I saw was ERRORS: Error getting column meta data for Error was: [java.sql.SQLException: Table 'automation.PHPBB3_ACL_GROUPS' doesn't exist]. Not checking columns. None Copyright 2001-2008 The Apache Software Foundation None 1.0
after tracing thru the code and runing it against the default db. I said I was missing something. so thought of doing view source, what do you know there it is. so updating the page including the virtual year for copy right. :D BJ Freeman sent the following on 5/1/2009 8:12 PM: > here is the log file > 2009-05-01 19:29:22,023 (TP-Processor3) [ > DatabaseUtil.java:1334:ERROR] > ---- exception report > ---------------------------------------------------------- > Error getting column meta data for Error was: [java.sql.SQLException: > Table 'automation.PHPBB3_ACL_GROUPS' doesn't exist]. Not checking columns. > Exception: java.sql.SQLException > Message: Table 'automation.PHPBB3_ACL_GROUPS' doesn't exist > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Table 'automation.PHPBB3_ACL_GROUPS' doesn't exist > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847) > com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531) > com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) > com.mysql.jdbc.Connection.execSQL(Connection.java:2370) > com.mysql.jdbc.Connection.execSQL(Connection.java:2297) > com.mysql.jdbc.Statement.executeQuery(Statement.java:1183) > com.mysql.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:2404) > org.ofbiz.entity.jdbc.DatabaseUtil.getColumnInfo(DatabaseUtil.java:1325) > org.ofbiz.entity.jdbc.DatabaseUtil.induceModelFromDb(DatabaseUtil.java:681) > org.ofbiz.entity.datasource.GenericDAO.induceModelFromDb(GenericDAO.java:1096) > org.apache.jsp.entity.ModelInduceFromDb_jsp._jspService(ModelInduceFromDb_jsp.java:101) > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) > javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337) > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) > javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630) > org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535) > org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472) > org.ofbiz.webapp.view.JspViewHandler.render(JspViewHandler.java:76) > org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:781) > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:533) > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:201) > org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:77) > javax.servlet.http.HttpServlet.service(HttpServlet.java:710) > javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568) > org.ofbiz.catalina.container.CrossSubdomainSessionValve.invoke(CrossSubdomainSessionValve.java:44) > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) > org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) > org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) > org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) > org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) > java.lang.Thread.run(Thread.java:636) > > > BJ Freeman sent the following on 5/1/2009 8:09 PM: >> I have a database i tried to use >> webtools/control/view/ModelInduceFromDb >> on. >> The db tables are like phpbb3_acl_groups when viewed through phpmyadmin. >> I would expect ofbiz to convert it to Phpbb3AclGroups >> I am getting this message. >> ERRORS: Error getting column meta data for Error was: >> [java.sql.SQLException: Table 'automation.PHPBB3_ACL_GROUPS' doesn't >> exist]. Not checking columns. None Copyright 2001-2008 The Apache >> Software Foundation None 1.0 >> using release 9.04 >> >> any ideas? > -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator.
