You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by daniele rizzi <da...@mail.largesys.it> on 2002/02/05 08:59:11 UTC
R: R: Thanks for ur Reply!!
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:sraghav_rao@hotmail.com]
Inviato: martedì 5 febbraio 2002 2.55
A: daniele.rizzi@www.largesys.it
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:sraghav_rao@hotmail.com]
> Inviato: lunedì 4 febbraio 2002 13.18
> A: daniele.rizzi@www.largesys.it
> 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:sraghav_rao@hotmail.com]
> > Inviato: lunedì 4 febbraio 2002 12.19
> > A: daniele.rizzi@www.largesys.it
> > 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:sraghav_rao@hotmail.com]
> > > Inviato: sabato 2 febbraio 2002 11.16
> > > A: daniele.rizzi@www.largesys.it
> > > 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:sraghav_rao@hotmail.com]
> > > >Inviato: giovedì 24 gennaio 2002 6.25
> > > >A: drizzi@largesys.it
> > > >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