Hi,
I have a problem with database connection. I am using Postgres SQL database. I create
a jetspeed database, the tables and the default role permissions.
At first, I create tables from the default turbine_postgres.sql file. But it looks
different field name from other sql file, like turbine-hypersonic.sql. So I used the
following whichi I created.
---------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------
-- TURBINE_PERMISSION
-----------------------------------------------------------------------------
drop sequence TURBINE_PERMISSION_SEQ;
drop table TURBINE_PERMISSION;
CREATE TABLE TURBINE_PERMISSION
(
PERMISSION_ID serial,
PERMISSION_NAME varchar (99) NOT NULL,
OBJECTDATA oid,
PRIMARY KEY(PERMISSION_ID),
UNIQUE (PERMISSION_NAME)
);
-----------------------------------------------------------------------------
-- TURBINE_ROLE
-----------------------------------------------------------------------------
drop sequence TURBINE_ROLE_SEQ;
drop table TURBINE_ROLE;
CREATE TABLE TURBINE_ROLE
(
ROLE_ID serial,
ROLE_NAME varchar (99) NOT NULL,
OBJECTDATA oid,
PRIMARY KEY(ROLE_ID),
UNIQUE (ROLE_NAME)
);
-----------------------------------------------------------------------------
-- TURBINE_GROUP
-----------------------------------------------------------------------------
drop sequence TURBINE_GROUP_SEQ;
drop table TURBINE_GROUP;
CREATE TABLE TURBINE_GROUP
(
GROUP_ID serial,
GROUP_NAME varchar (99) NOT NULL,
OBJECTDATA oid,
PRIMARY KEY(GROUP_ID),
UNIQUE (GROUP_NAME)
);
-----------------------------------------------------------------------------
-- TURBINE_ROLE_PERMISSION
-----------------------------------------------------------------------------
drop table TURBINE_ROLE_PERMISSION;
CREATE TABLE TURBINE_ROLE_PERMISSION
(
ROLE_ID integer NOT NULL,
PERMISSION_ID integer NOT NULL,
PRIMARY KEY(ROLEI_D,PERMISSION_ID),
FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID),
FOREIGN KEY (PERMISSION_ID) REFERENCES TURBINE_PERMISSION (PERMISSION_ID)
);
create INDEX ROLE_PERMISSION_INDEX (ROLE_ID, PERMISSION_ID);
-----------------------------------------------------------------------------
-- TURBINE_USER
-----------------------------------------------------------------------------
drop sequence TURBINE_USER_SEQ;
drop table TURBINE_USER;
CREATE TABLE TURBINE_USER
(
USER_ID serial,
LOGIN_NAME varchar (32) NOT NULL,
PASSWORD_VALUE varchar (32) NOT NULL,
FIRST_NAME varchar (99) NOT NULL,
LAST_NAME varchar (99) NOT NULL,
ADDRESS1 varchar (255),
ADDRESS2 varchar (255),
CITY varchar (255),
STATE varchar (32),
POSTALCODE varchar (32),
COUNTRY varchar (99),
CITIZENSHIP varchar (32),
PHONE varchar (32),
ALTPHONE varchar (32),
FAX varchar (32),
CELL varchar (32),
PAGER varchar (32),
EMAIL varchar (99),
MODIFIED timestamp,
CREATED timestamp,
LASTLOGIN timestamp,
PREFIX_NAME varchar (16),
MIDDLE_NAME varchar (99),
SUFFIX_NAME varchar (16),
COMPANY varchar (255),
CONFIRM_VALUE varchar (99),
OBJECTDATA oid,
PRIMARY KEY(USER_ID),
FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID),
UNIQUE (LOGIN_NAME)
);
-----------------------------------------------------------------------------
-- TURBINE_USER_GROUP_ROLE
-----------------------------------------------------------------------------
drop table TURBINE_USER_GROUP_ROLE;
CREATE TABLE TURBINE_USER_GROUP_ROLE
(
USER_ID integer NOT NULL,
GROUP_ID integer NOT NULL,
ROLE_ID integer NOT NULL,
PRIMARY KEY(USER_ID,GROU_PID,ROLE_ID),
FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID),
FOREIGN KEY (GROUP_ID) REFERENCES TURBINE_GROUP (GROUP_ID),
FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_USER_ROLE (ROLE_ID)
);
create INDEX USER_GROUP_ROLE_INDEX (USER_ID, GROUP_ID, ROLE_ID);
-----------------------------------------------------------------------------
-- TURBINE_JOBENTRY
-----------------------------------------------------------------------------
drop table TURBINE_JOBENTRY;
CREATE TABLE TURBINE_SCHEDULED_JOB
(
JOB_ID integer NOT NULL,
SECOND integer default -1 NOT NULL,
MINUTE integer default -1 NOT NULL,
HOUR integer default -1 NOT NULL,
WEEK_DAY integer default -1 NOT NULL,
DAY_OF_MONTH integer default -1 NOT NULL,
TASK VARCHAR (99) NOT NULL,
EMAIL VARCHAR (99),
PRIMARY KEY(JOB_ID)
);
---------------------------------------------------------------------------------------------
I also modified the TUbineRousouces.properties as the following.
database.default.driver=postgresql.Driver
database.default.url=jdbc:postgresql:jetspeed
database.default.username=postgres
database.default.password=postgres
Then I started tomcat and tried to login to Jetspeed. When we tried to login, the
following error message is appeard to the Web browser.
Please tell me the how to set up for PostgresSQL.
I am using Linux and JDK1.3, PostgresSQL6.5 .
Regards,
Hiroki,
-----------------------------------------------------------------------------------
- Error log
Exception: java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): Database
type postgresql.Driver not implemented.
at org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:227)
at org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:187)
at
org.apache.turbine.om.security.peer.TurbineUserPeer.<clinit>(TurbineUserPeer.java:167)
at
org.apache.turbine.services.security.DBUserManager.retrieve(DBUserManager.java:153)
at
org.apache.turbine.services.security.DBUserManager.retrieve(DBUserManager.java:230)
at
org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUser(BaseSecurityService.java:279)
at
org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUser(TurbineSecurity.java:193)
at org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:105)
at org.apache.turbine.modules.Action.perform(Action.java:91)
at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:121)
at
org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:224)
at org.apache.turbine.modules.Action.perform(Action.java:91)
at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:121)
at org.apache.turbine.Turbine.doGet(Turbine.java:326)
at org.apache.turbine.Turbine.doPost(Turbine.java:451)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
at org.apache.tomcat.core.Handler.service(Handler.java:286)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
at java.lang.Thread.run(Thread.java:484)
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/[email protected]/>
List Help?: [EMAIL PROTECTED]
