Problem With JAMES!

[raghavender rao]

hi ther,
i have successfully eshtablished database connection with RDBMS(Oracle). But when i try to adduser or listusers it says....
-------------------------------------
com.workingdogs.town.DataSetException: Error retrieving primary keys from table
jamesusers: Unable to retrieve primary keys on table jamesusers
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(UsersT
ownRepository.java:171)
at org.apache.james.remotemanager.RemoteManager.parseCommand(RemoteManag
er.java:195)
at org.apache.james.remotemanager.RemoteManager.parseRequest(RemoteManag
er.java:117)
at org.apache.avalon.blocks.serversocket.ServerSocketAcceptor.run(Server
SocketAcceptor.java:77)
at org.apache.avalon.utils.recycle.pool.Worker.run(Worker.java:113)
-----------------------------------
i am sure it does have primary keys..but still the error wht could be the cause of the error please help me to solve this problem as soon as possible...

[raghavender rao]

hi all,
i have traced the bug and solved..
this is from JAMES.conf.xml properties file
<conn>file:///var/maildatabase</conn>;
<table>JAMESUSERS</table>
the problem was with case the table name should be
all upper case as JAMESUSERS not jamesusers
I have searched many sites and i cd nt find the answer but many have raised this question .
Hope this wd help many people...

[sobi wilson]

hi raghavender,
I tried to post this mail to the id given in this site. I need to develop a mail system with JAMES as server. But the problem is that Im a beginner in the world of mails. And also i couldnt find much help about its working and implementation from net also. Can u help me to solve some of my issue?
I have tried with some stuff i got from ibm site. Its a small program to send mail and list inbox. But my mail is there in the inbox but i couldnt list it. while fetching the number of msgs is shown as 0. If this was working it would have given me a starting.
Is it possible to connect james with any database. If so how is it possible? Will it be possible to add users without using the remote login?
Hope you will find sometime to solve atleast some of my problems and give me a start.It will be more useful if u can send me some sample codes or some useful links to [email protected]
Thanks in advance.
Regards
Sobi