Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Problem With JAMES!  RSS feed

 
raghavender rao
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 sobigwilson@yahoo.com
Thanks in advance.
Regards
Sobi
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!