done https://issues.apache.org/jira/browse/OFBIZ-2432
BJ Freeman sent the following on 5/7/2009 4:50 PM: > got side tracked by trying to do something fancy. > guess I will just make it simple and put in the jira. > :D > > Jacques Le Roux sent the following on 5/7/2009 4:03 PM: >> Hi BJ, >> >> A bit late, sorry. Did you open a page for that finally ? >> >> Thanks >> >> Jacques >> >> From: "BJ Freeman" <[email protected]> >>> I don't believe it to be my error, Jacques. >>> I don't believe that one expects to have to view the source of a web >>> page to get their data. it was not displayed so you could see it. >>> >>> I have put such an explanation on the page that i am going to submit a >>> patch for. >>> >>> why the error I don't know, I was tracing code when i made the discovery >>> that the entities were generated but I had to do a view of the web page >>> source to see it. >>> >>> So I have not traced any farther. >>> >>> >>> Jacques Le Roux sent the following on 5/2/2009 3:53 PM: >>>> BJ, >>>> >>>> Could you more clear please ? Is it a bug of your own or... ? >>>> >>>> Thks >>>> >>>> Jacques >>>> >>>> From: "BJ Freeman" <[email protected]> >>>>> 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. >>>>> >>>> >>> -- >>> 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. >>> >> > -- 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.
