[EMAIL PROTECTED] wrote:
> In "JAMES.conf.xml" type the name of the user table in UPPERCASE, e.g.
> <table>USERS</table>. This should fix your problem.
Thanks. It works now!
S.
>
>
>
>
>
>
> 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]
>
--
/*
* Sebastian Szuber, Poznan Supercomputing and Networking Center
* email: [EMAIL PROTECTED]
* phone: (+48 61) 858-20-34, fax: (+48 61) 852-59-54
*
*/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
