You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Tarek Aridi <ta...@cmguc.com> on 2003/08/13 16:12:11 UTC
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
RE: Jetspeed Mysql COFFEE Example: turbine user can't display COFFEE DB
Posted by Tarek Aridi <ta...@cmguc.com>.
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:taridi@cmguc.com]
Sent: Wednesday, August 13, 2003 10:12 AM
To: jetspeed-user@jakarta.apache.org
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: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
RE: Jetspeed Mysql COFFEE Example: turbine user can't display COFFEE DB
Posted by Tarek Aridi <ta...@cmguc.com>.
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:taridi@cmguc.com]
Sent: Wednesday, August 13, 2003 10:12 AM
To: jetspeed-user@jakarta.apache.org
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: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org