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]
