Found the problem. Apparently unlike Hypersonic, mySQL is case sensitive. Since the sample table is called COFFEES, "select * from coffees" does not work. It needs to be "select * from COFFEES"
-----Original Message----- From: Tarek Aridi [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 10:12 AM To: [EMAIL PROTECTED] Subject: Jetspeed Mysql COFFEE Example: turbine user can't display COFFEE DB Your Help would be immensely appreciated. I'm Trying to configure mysql with jetspeed for user authentication as well as for custom data access, retrieval and display. This configuration in Torque.properties works fine except it does not display the COFFEE data base example. In Torque.prporties torque.dsfactory.default.factory= org.apache.torque.dsfactory.TorqueDataSourceFactory torque.dsfactory.default.pool.defaultMaxConnections=10 torque.dsfactory.default.pool.maxExpiryTime=3600 torque.dsfactory.default.pool.connectionWaitTimeout=10 ### MySQL torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver torque.dsfactory.default.connection.url = jdbc:mysql://localhost:3306/upower1 torque.dsfactory.default.connection.user = root torque.dsfactory.default.connection.password = I saw in one of the FQA this recommendation: torque.dsfactory.default.factory= org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory torque.dsfactory.default.pool.defaultMaxActive=10 torque.dsfactory.default.pool.testOnBorrow=true torque.dsfactory.default.pool.validationQuery=SELECT 1 torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver torque.dsfactory.default.connection.url = jdbc:mysql://localhost:3306/upower1 torque.dsfactory.default.connection.user = root torque.dsfactory.default.connection.password = But this generates the following Error: org.apache.turbine.util.TurbineException: Error rendering Velocity template: /controllers/html/multicolumn.vm: Invocation of method 'getContent' in class org.apache.jetspeed.portal.controls.VelocityPortletControl threw exception class java.lang.Error : Error in BasePeer.initTableSchema(TURBINE_USER): There was no DataSourceFactory configured for the connection default Can some one please point in the right direction, by either helping me getting to the data with the first configuration or getting the second config to work. Best regards Rick Aridi --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
