Thx for the log, the root cause is oracle.net.ns.NetException: Listener
refused the connection with the following error: ORA-12505, TNS:listener
does not currently know of SID given in connect descriptor
It seems like the JDBC URL to your database is not working.
The best is to take that URL literally and try to connect with it from
your favorite JDBC client (mine is SquirrelSQL). When you are sure your
URL is working, just retry with James.
Thx,
Eric
On 18/02/12 22:57, mike tazelaar wrote:
Here is the text file you requested. Reminder: I am trying to save
messages to Oracle db but James is not running because of a Listener
error from James.
------------------------------------------------------------------------
*From:* Eric Charles <[email protected]>
*To:* James Users List <[email protected]>
*Sent:* Friday, February 17, 2012 11:16 PM
*Subject:* Re: storing messages on oracle database
Hi, your log has been removed by the mailing list...
Please resend it with .txt extension (seems like the first one you sent
has not been removed), or open a JIRA and attach it there on
https://issues.apache.org/jira/browse/JAMES
Thx,
Eric
On 17/02/12 19:25, mike tazelaar wrote:
> Class not Found error fixed by adding jar files.
> I have attached a new log file. Appears that there is a Listener error.
> How can that be fixed?
>
> ------------------------------------------------------------------------
> *From:* Eric Charles <[email protected]
<mailto:[email protected]>>
> *To:* James Users List <[email protected]
<mailto:[email protected]>>
> *Sent:* Friday, February 17, 2012 8:23 AM
> *Subject:* Re: storing messages on oracle database
>
> everybody loves repackaging:)
>
> On 17/02/12 16:11, Kendrick C. Wilson wrote:
> >
> > oracle.jdbc.driver.OracleDriver was replaced by
oracle.jdbc.OracleDriver
> > https://forums.oracle.com/forums/thread.jspa?threadID=687175
> >
> > Kendrick C. Wilson
> >
> >
> >> Date: Fri, 17 Feb 2012 15:50:38 +0100
> >> From: [email protected]
<mailto:[email protected]> <mailto:[email protected]
<mailto:[email protected]>>
> >> To: [email protected]
<mailto:[email protected]>
<mailto:[email protected] <mailto:[email protected]>>
> >> Subject: Re: storing messages on oracle database
> >>
> >> Thx. I see in the log (Reason: java.lang.ClassNotFoundException:
> >> oracle.jdbc.driver.OracleDriver)
> >>
> >> Look at http://james.apache.org/server/2.3.0/using_database.html where
> >> you will read "To make these classes available to Phoenix, place the
> >> jar/zip files for the JDBC driver in the lib subdirectory of the James
> >> installation directory. Any additional libraries upon which the JDBC
> >> library depends that are not part of the standard Java distribution
> >> should also be added to this directory."
> >>
> >> Put the your oracle jdbc jar in the lib folder and (re)start server.
> >>
> >> Hope this helps.
> >> Eric
> >>
> >>
> >> On 17/02/12 15:23, mike tazelaar wrote:
> >>> I have attached the log. I am using 2.3.2.
> >>>
> >>>
> ------------------------------------------------------------------------
> >>> *From:* Eric Charles<[email protected]
<mailto:[email protected]>
> <mailto:[email protected] <mailto:[email protected]>>>
> >>> *To:* James Users List<[email protected]
<mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>>
> >>> *Sent:* Friday, February 17, 2012 2:06 AM
> >>> *Subject:* Re: storing messages on oracle database
> >>>
> >>> Hi, do you get any exceptions in the log files (I guess it is james
> 2.3) ?
> >>> Thx,
> >>> Eric
> >>>
> >>> On 17/02/12 00:29, mike tazelaar wrote:
> >>> > I want to store messages in oracle database instead of the files.
> >>> What information does James require in the<durl>?
> >>> > The jdbc I am using to connect my db to oracle works for my
> >>> application but doesn't connect with James.
> >>> >
> >>> > <data-source name="maildb"
> >>> class="org.apache.james.util.dbcp.JdbcDataSource">
> >>> > <driver>oracle.jdbc.driver.OracleDriver</driver>
> >>> > <dburl>jdbc:oracle:thin:@localhost:1521:nhind3</dburl>
> >>> > <user>someuser</user>
> >>> > <password>somepassword</password>
> >>> > <max>20</max>
> >>> > </data-source>
> >>>
> >>> --
> >>> eric | http://about.echarles.net | @echarles
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: [email protected]
<mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>
> >>> <mailto:[email protected]
<mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>>
> >>> For additional commands, e-mail:
[email protected] <mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>
> >>> <mailto:[email protected]
<mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: [email protected]
<mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>
> >>> For additional commands, e-mail:
[email protected] <mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>
> >>
> >> --
> >> eric | http://about.echarles.net | @echarles
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: [email protected]
<mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>
> >> For additional commands, e-mail: [email protected]
<mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>
> >>
> >
>
> --
> eric | http://about.echarles.net | @echarles
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
<mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>
> For additional commands, e-mail: [email protected]
<mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
<mailto:[email protected]>
> For additional commands, e-mail: [email protected]
<mailto:[email protected]>
--
eric | http://about.echarles.net | @echarles
--
eric | http://about.echarles.net | @echarles
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
<mailto:[email protected]>
For additional commands, e-mail: [email protected]
<mailto:[email protected]>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
--
eric | http://about.echarles.net | @echarles
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
