oh, now I've got the picture. Really I didn't even know that James included a servlet-supported interface; I thought it had only a deamon listening on pop & smtp ports for gathering and distributing mails, and nothing else. My own installation is James 1.2 (deamon) which uses a db oracle 9i for repository - this is the only non-standard thing.
Sorry I can't help you more, I'm going to forward the message to James Users List, hoping someone more skilled may tell a word see you, d. -----Messaggio originale----- Da: Raghavender Rao [mailto:[EMAIL PROTECTED]] Inviato: marted� 5 febbraio 2002 2.55 A: [EMAIL PROTECTED] Oggetto: Re: R: Thanks for ur Reply!! forgot to tell u i did add users much before using telnet localhost 4555 the main problem is even though James is running or not i am getting this Exception .... javax.mail.MessagingException: Connection refused: no further information; nested exception is: java.net.ConnectException: Connection refused: no further information it means that the Application server is not recognising JAMES..... tell me what to do??? Rao >From: "daniele rizzi" >To: "Raghavender Rao" >Subject: R: Thanks for ur Reply!! >Date: Mon, 4 Feb 2002 14:21:25 +0100 > > >let's add up: >1/ james works for itself in your installation; that is you unzip & run >and it starts working; >2/ you are not concerned with db >3/ and you're not concerned with Application Servers and other stuff > >then: if you run it and add a user via the admin opt (ie telnet 4555 or >whatever) and config a mail client to read from it, shouldn't it work? > >after 5 messages, I still miss the point >(sorry)d. > > -----Messaggio originale----- > Da: Raghavender Rao [mailto:[EMAIL PROTECTED]] > Inviato: luned� 4 febbraio 2002 13.18 > A: [EMAIL PROTECTED] > Oggetto: Thanks for ur Reply!! > > > hi ther, > > 2Ans) presently not concerned abt Database Repo....(as i have done >this) > > what i want is? i want to view my INBOX using JAMES and JavaMail...... > > 3Ans)Oracle Application Server > > i hope i have solved all the Q's please solve my Problems..... > > > Rao > > > >From: "daniele rizzi" > >To: "Raghavender Rao" > >Subject: R: HI ther.... > >Date: Mon, 4 Feb 2002 12:34:40 +0100 > > > >ok, so step one is cleared: > >2/ what settings are you going to change? a DatabaseRepository (or >whatever > >it is called) > > or what else? > >3/ are you willing to make it run under oc4j (alias orionserver alias >j2ee > >container for java > > by oracle also known as 9iAs container for java)? > > > >d. > > > > > > > > -----Messaggio originale----- > > Da: Raghavender Rao [mailto:[EMAIL PROTECTED]] > > Inviato: luned� 4 febbraio 2002 12.19 > > A: [EMAIL PROTECTED] > > Oggetto: HI ther.... > > > > > > hi ther, > > > > thanks for ur reply.... > > > > James is working perfectly fine when james is running > > > > Avalon runner > > parser : org.apache.xerces.parsers.SAXParser > > configurationPath : ../conf/ > > logFile : ../logs/avalon.log > > libPath : ../lib/ > > blockPath : ./blocks/ > > > > Scanning jars for new Blocks... > > Reading configuration > > Avalon 2.2-dev > > > > > > 2002.02.04 07:13:02 425 Channel default opened > > > > i configured and checked the output with Outlook Express it is showing >all > >the mails..... > > > > what cd be the problem with JavaMail ..... > > > > please do help me as soon as possible... > > > > > > > > Rao > > > > >From: "daniele rizzi" > > >To: "Raghavender Rao" > > >Subject: R: HI ther.... > > >Date: Mon, 4 Feb 2002 08:57:45 +0100 > > > > > >sorry I still miss the point: > > >- does james work by itself? (unpack the original zip & launch run.bat > > >somewhere)? > > > > > >d. > > > > > > -----Messaggio originale----- > > > Da: Raghavender Rao [mailto:[EMAIL PROTECTED]] > > > Inviato: sabato 2 febbraio 2002 11.16 > > > A: [EMAIL PROTECTED] > > > Oggetto: HI ther.... > > > > > > > > > i have setup an email engine > > > > > > Mailserver IMAIL...which is working fine....(Sending and receiving > >mails) > > > > > > i want to do the same configuration with JAMES when i use java mail > >sample > > >program its not even connecting to JAMES wht cd be the problem > > > > > > do i need to add some jar files wht sd i do ...... > > > > > > my webserver is Oracle Application Server... > > > > > > please do mail me back as soon as possible... > > > > > > Thanks , > > > Rao > > > > > > >From: "daniele rizzi" > > > >To: "James Users List" > > > >CC: > > > >Subject: I: PLease Help Me!!! > > > >Date: Fri, 25 Jan 2002 09:21:53 +0100 > > > > > > > >I hope somebody put this in a faq or the like... > > > > > > > >Title: what happens when you implements a MailRepository under >OracleDb > > > >Refers to: James 1.2.*, Oracle Server 9i (perhaps 8i and others) > > > > > > > >Subtitle: something went wrong, but I can't put my finger on it... > > > > > > > >Step to replicate: > > > >- first install james 1.2* and test everything is ok; > > > >- then create the schema (lets say JAMES) and the table Message in >the > > >Db, > > > > as sketched with mySql example; > > > >- then change the repository def (I forgot the steps at home, but > >cutting > > >& > > > >pasting > > > > the mySql defs basically works); > > > >- finally rerun james: even though evrytng is ok, deamon crashed in a > > >weird > > > >way, > > > > with the weirder exception: > > > >2002.01.24 10:13:34 086 Channel default opened loading broker > >properties > > > >from file:/var/maildatabase 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 > > > > > > > >What happend?: > > > >James uses Town lib to serialize messages from / to db: Town knows > >there > > >is > > > >a table called > > > >"Messages" to analyze before operating: the analysis looks for: > > > >- the type and name of columns; > > > >- the primary key(s); > > > >Introspection is done via getDatabaseMetaData(), but the Oracle > > > >implementation is faulty: > > > > > > > >IF you CREATE TABLE MESSAGE(), then the catalog contains an entry > >MESSAGE > > > >and getDatabaseMetaData() returns data as expected; > > > > > > > >IF you CREATE TABLE Message(), then the catalog contains an entry > >MESSAGE > > > >and getDatabaseMetaData() doesn't find the table and returns empty > >data; > > > > > > > >IF at this point you're rather confused and thinks there's something > > >rotten, > > > >you should > > > >re-read the above sentences thrice and accept as a fact of life: > > > >according to Oracle Support this is *NOT* a bug, instead that's >exactly > > >the > > > >logical behaviour (and I'd known it better and not bugged people that > > > >works...). > > > > > > > >Finally the solution (by dany, which is me): > > > >you cannot change James and you cannot touch Town, and you > > > >cannot force Oracle to support logic, but you can: > > > > > > > >open sqlplus james/james@sid_your_db: > > > > > > > >CREATE TABLE MESSAGES(ETC); > > > > > > > >CREATE SYNONYM "Messages" FOR MESSAGES; > > > > > > > >SELECT * FROM CAT; > > > >-- you should see 2 entries: the first UPPERCASE, the second >MixedCase; > > > > > > > >COMMIT; -- it always helps; > > > > > > > >exit sqlplus; > > > > > > > >rerun all the testbed and james: it should work: > > > > > > > >hope it helps, > > > >d. > > > > > > > > > > > > > > > > > > > >-----Messaggio originale----- > > > >Da: Raghavender Rao [mailto:[EMAIL PROTECTED]] > > > >Inviato: gioved� 24 gennaio 2002 6.25 > > > >A: [EMAIL PROTECTED] > > > >Oggetto: PLease Help Me!!! > > > > > > > > > > > >hi ther, > > > > > > > > I am trying to install JAMES with users repositories stored in > > > >Oracle.Connection eshtablished successfully.But when i try to adduser > >or > > > >listusers it gives me following Exception.. > > > > > > > >-------------------------------------------- > > > > > > > >2002.01.24 10:13:34 086 Channel default opened > > > >loading broker properties from file:/var/maildatabase > > > >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.(TableDataSet.java:299) > > > > at com.workingdogs.town.TableDataSet.(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) > > > > > > > >----------------------------- > > > > > > > >table has primary keys but still error. > > > > > > > >still to add > > > > > > > > in com.workingdogs.town.ConnDefinition class and method getSchema(); > > > > > > > >------------------------------------------------------ > > > >1. KeyDef keydef = new KeyDef(); > > > >2. try > > > >3. { > > > >4. Connection connection1 = getConnection(); > > > >5. try > > > >6. { > > > >7. DatabaseMetaData databasemetadata = > > > >connection1.getMetaData(); > > > >8. ResultSet resultset1; > > > >9. for(resultset1 = > > > >databasemetadata.getPrimaryKeys(connection1.getCatalog(), null, s); > > > >resultset1.next(); > > >keydef.addAttrib(resultset1.getString("COLUMN_NAME"))); > > > >10. resultset1.close(); > > > >11. if(keydef.size() == 0) // this is the cause of > > > >the error..... > > > >12. throw new DataSetException("Unable to retrieve > > > >primary keys on table " + s); > > > >13. schema.setDefaultKeyDef(keydef); > > > >14. schemas.put(s, schema); > > > >15. } > > > >16. catch(Exception exception2) > > > >17. { > > > >18. throw new DataSetException("Error retrieving primary > > > >keys from table " + s + ": " + exception2.getMessage()); > > > >19. } > > > >20. releaseConnection(connection1); > > > >21. } > > > >22. catch(Exception exception1) > > > >23. { > > > >24. if(exception1 instanceof DataSetException) > > > >25. throw (DataSetException)exception1; > > > >26. else > > > >27. throw new DataSetException("Error retrieving schema > > > >info for table " + s + ": " + exception1.getMessage()); > > > >28. } > > > >29. } > > > >----------------------------------------------------- > > > > > > > > Line 11 is causing ERROR!!! the size of keydef is 0 > > > > and i wrote a small program to test this.... > > > >----------------------------------------------------- > > > > try { > > > > java.sql.DriverManager.registerDriver(new > > > >oracle.jdbc.driver.OracleDriver()); > > > > int i=0; > > > > java.lang.String s = "jamesusers"; > > > > java.sql.Connection connection = > > > > > > > > > >java.sql.DriverManager.getConnection("mydatabaseurl","username","password") > > >; > > > > java.sql.Statement statement = connection.createStatement(); > > > > java.sql.DatabaseMetaData databasemetadata = > > > >connection.getMetaData(); > > > > java.sql.ResultSet resultset; > > > > resultset = > > > >databasemetadata.getPrimaryKeys(connection.getCatalog(),null,s); > > > > java.lang.System.out.println("The Value of ResultSet is > > > >"+resultset.next()); > > > > > > > > /*while(resultset.next()){ > > > > > > > > java.lang.System.out.println("The coloums are > > > >"+resultset.getString("COLUMN_NAME")); > > > > > > > > }*/ > > > > }catch(java.lang.Exception exception){ > > > > > > > > exception.printStackTrace(); > > > > } > > > >----------------------------------------------------- > > > > > > > >The output of this program is : > > > > > > > > The Value of ResultSet is false > > > > > > > >I tried with different tables which has primary keys but the output >is > > > >same... > > > > > > > >Please help me to solve this problem as soon as possible. > > > > > > > >Rao > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >--------------------------------------------------------------------------- > > >- > > > >---- > > > >MSN Photos is the easiest way to share and print your photos: Click > >Here > > > > > > > > > > > > > > > >--------------------------------------------------------------------------- > >- > > >-- > > > Get your FREE download of MSN Explorer at http://explorer.msn.com. > > > > > > > > > >--------------------------------------------------------------------------- >- > >-- > > Get your FREE download of MSN Explorer at http://explorer.msn.com. > > > > >--------------------------------------------------------------------------- - >-- > Chat with friends online, try MSN Messenger: Click Here > ---------------------------------------------------------------------------- -- MSN Photos is the easiest way to share and print your photos: Click Here
