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.
