In "JAMES.conf.xml" type the name of the user table in UPPERCASE, e.g.
<table>USERS</table>. This should fix your problem.
Sebastian Szuber <[EMAIL PROTECTED]> on 07.09.2001 15:11:34
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Oracle and users repository
I tried to set up users repository in Oracle database.
I created table as below:
create table jms_users (
username varchar2(200) not null,
password varchar2(200) not null,
constraint jms_us_pk primary key(username)
)
/
but Town wrote exception:
2001.09.07 02:51:27 522 Channel default opened
loading broker properties from file:/disk/home/james/mail/maildatabase
com.workingdogs.town.DataSetException: Error retrieving primary keys from
table jms_users:
Unable to retrieve primary keys on table jms_users
at
com.workingdogs.town.ConnDefinition.getSchema(ConnDefinition.java:227)
at com.workingdogs.town.TableDataSet.<init>(TableDataSet.java:299)
at com.workingdogs.town.TableDataSet.<init>(TableDataSet.java:280)
at
org.apache.james.userrepository.UsersTownRepository.countUsers(UsersTownRepository.java:171)
at
org.apache.james.remotemanager.RemoteManager.parseCommand(RemoteManager.java:195)
at
org.apache.james.remotemanager.RemoteManager.parseRequest(RemoteManager.java:117)
at
org.apache.avalon.blocks.serversocket.ServerSocketAcceptor.run(ServerSocketAcceptor.java:77)
at
org.apache.avalon.utils.recycle.pool.Worker.run(Worker.java:113)
What's wrong?
Sebastian.
---------------------------------------------------------------------
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]
