For what it's worth, I also tried to make this work - and I think a key is that the
todolist portlet is using the default connection. Thus, I think you have the choice
of:
a) Inserting the todolist tables into your default database OR
b) Setting up a connection to your mySQL database and then changing the portlet code
to use the mySQL database.
I chose (b). I created the tables in a mySQL database (using the script that was
provided earlier in the thread). Then I configured the torque.properties to reference
this database with the name "todolist". I then changed the code in four places:
BasePortalTodolistCategoryPeer.java
BasePortalTodolistGroupPeer.java
BasePortalTodolistUserPeer.java
BasePortalTodolistPeer.java
This got me past errors like "Table does not exist". Of course, I would love to
report that it all worked in the end, but alas, I am stuck on a null pointer exception:
java.lang.NullPointerException
at org.apache.torque.util.BasePeer.createQuery(BasePeer.java:1209)
at org.apache.torque.util.BasePeer.createQueryString(BasePeer.java:927)
at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1321)
at
org.apache.jetspeed.om.todolist.BasePortalTodolistPeer.doSelectVillageRecords(BasePortalTodolistPeer.java:497)
at
org.apache.jetspeed.om.todolist.BasePortalTodolistPeer.doSelectVillageRecords(BasePortalTodolistPeer.java:433)
at
org.apache.jetspeed.om.todolist.BasePortalTodolistPeer.doSelect(BasePortalTodolistPeer.java:401)
at
org.apache.jetspeed.modules.actions.portlets.ToDoListPortlet.buildNormalContext(ToDoListPortlet.java:221)
...
The portlet shows up, I can click on the icon to add a new entry, but that entry does
not get added.
And I was having problems debugging this Jetspeed installation, so I haven't made any
progress tracking down this bug. I am running JBoss (started outside of Eclipse) and
trying to set a breakpoint inside Eclipse - but the breakpoints aren't working. (I
think I have done this with WebLogic, but I am not positive).
In any case, if I get it figured out, I will post here...
Good luck,
RB
Twenty Years | One Mission | Accelerating Business Processes
Richard Berger
Action Technologies, Inc.
VP, Product Management
510.748.1017 (Office)
510.769.0596 (Fax)
www.actiontech.com
NOTE: The opinions expressed herein are those of the writer and not necessarily those
of Action Technologies, Inc. or its employees or its affiliates.
-----Original Message-----
From: karthikeyan [mailto:[EMAIL PROTECTED]
Sent: Fri 1/16/2004 10:16 AM
To: Jetspeed Users List
Cc:
Subject: Re: Cone's To Do List portlet configuration problem
check this in build.properties (../todolist/build.properties)
configure db location (default is db)
torque.database.createUrl = jdbc:mysql://"yourserver"/yourdatabase
(todolist!)
"com.mysql.jdbc.Driver" instead of org.gjt.mm.mysql.Driver (I don't use
this...)
# -------------------------------------------------------------------
#
# D A T A B A S E S E T T I N G S
#
# -------------------------------------------------------------------
# JDBC connection settings. This is used by the JDBCToXML task that
# will create an XML database schema from JDBC metadata. These
# settings are also used by the SQL Ant task to initialize your
# Turbine system with the generated SQL.
#
# sameJavaName
# If true, the JDBC task will set the javaName attribute for the
tables
# and columns to be the same as SQL name.
# -------------------------------------------------------------------
torque.database.createUrl = jdbc:mysql://localhost/db
torque.database.buildUrl = jdbc:mysql://localhost/db
torque.database.url = jdbc:mysql://localhost/db
torque.database.driver = com.mysql.jdbc.Driver
torque.database.user =root
torque.database.password =
torque.database.host =localhost
torque.sameJavaName = false
--
M. Karthikeyan, Ph.D., Scientist
_| _| _|_|_| _|
_|_| _| _| _|
_| _| _| _| _|
_| _|_| _| _|
_| _| o _|_|_|o _|_|_|_|
National Chemical Laboratory
Pune - 411 008, INDIA
Ph: +91-(0)20-5893 457 FAX: 5893 973
http://www.ncl-india.org/
---------------------------------------------------------------------
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]
