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 mike tazelaar <ta...@yahoo.com> on 2012/02/17 00:29:16 UTC
storing messages on oracle database
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>
Re: storing messages on oracle database
Posted by Eric Charles <er...@apache.org>.
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 <er...@u-mangate.com>
> *To:* James Users List <se...@james.apache.org>
> *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 <eric.charles@u-mangate.com
> <ma...@u-mangate.com>>
> > *To:* James Users List <server-user@james.apache.org
> <ma...@james.apache.org>>
> > *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: eric.charles@u-mangate.com
> <ma...@u-mangate.com> <mailto:eric.charles@u-mangate.com
> <ma...@u-mangate.com>>
> > >> To: server-user@james.apache.org
> <ma...@james.apache.org>
> <mailto:server-user@james.apache.org <ma...@james.apache.org>>
> > >> 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<eric.charles@u-mangate.com
> <ma...@u-mangate.com>
> > <mailto:eric.charles@u-mangate.com <ma...@u-mangate.com>>>
> > >>> *To:* James Users List<server-user@james.apache.org
> <ma...@james.apache.org>
> > <mailto:server-user@james.apache.org
> <ma...@james.apache.org>>>
> > >>> *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: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> > <mailto:server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>>
> > >>> <mailto:server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> > <mailto:server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>>>
> > >>> For additional commands, e-mail:
> server-user-help@james.apache.org <ma...@james.apache.org>
> > <mailto:server-user-help@james.apache.org
> <ma...@james.apache.org>>
> > >>> <mailto:server-user-help@james.apache.org
> <ma...@james.apache.org>
> > <mailto:server-user-help@james.apache.org
> <ma...@james.apache.org>>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>> ---------------------------------------------------------------------
> > >>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> > <mailto:server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>>
> > >>> For additional commands, e-mail:
> server-user-help@james.apache.org <ma...@james.apache.org>
> > <mailto:server-user-help@james.apache.org
> <ma...@james.apache.org>>
> > >>
> > >> --
> > >> eric | http://about.echarles.net | @echarles
> > >>
> > >> ---------------------------------------------------------------------
> > >> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> > <mailto:server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>>
> > >> For additional commands, e-mail: server-user-help@james.apache.org
> <ma...@james.apache.org>
> > <mailto:server-user-help@james.apache.org
> <ma...@james.apache.org>>
> > >>
> > >
> >
> > --
> > eric | http://about.echarles.net | @echarles
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> > <mailto:server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>>
> > For additional commands, e-mail: server-user-help@james.apache.org
> <ma...@james.apache.org>
> > <mailto:server-user-help@james.apache.org
> <ma...@james.apache.org>>
> >
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> > For additional commands, e-mail: server-user-help@james.apache.org
> <ma...@james.apache.org>
>
> --
> eric | http://about.echarles.net | @echarles
>
> --
> eric | http://about.echarles.net | @echarles
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> For additional commands, e-mail: server-user-help@james.apache.org
> <ma...@james.apache.org>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
--
eric | http://about.echarles.net | @echarles
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: storing messages on oracle database
Posted by mike tazelaar <ta...@yahoo.com>.
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 <er...@u-mangate.com>
To: James Users List <se...@james.apache.org>
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 <er...@u-mangate.com>
> *To:* James Users List <se...@james.apache.org>
> *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: eric.charles@u-mangate.com <ma...@u-mangate.com>
> >> To: server-user@james.apache.org <ma...@james.apache.org>
> >> 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<eric.charles@u-mangate.com
> <ma...@u-mangate.com>>
> >>> *To:* James Users List<server-user@james.apache.org
> <ma...@james.apache.org>>
> >>> *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: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> >>> <mailto:server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>>
> >>> For additional commands, e-mail: server-user-help@james.apache.org
> <ma...@james.apache.org>
> >>> <mailto:server-user-help@james.apache.org
> <ma...@james.apache.org>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> >>> For additional commands, e-mail: server-user-help@james.apache.org
> <ma...@james.apache.org>
> >>
> >> --
> >> eric | http://about.echarles.net | @echarles
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> >> For additional commands, e-mail: server-user-help@james.apache.org
> <ma...@james.apache.org>
> >>
> >
>
> --
> eric | http://about.echarles.net | @echarles
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> For additional commands, e-mail: server-user-help@james.apache.org
> <ma...@james.apache.org>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
--
eric | http://about.echarles.net | @echarles
--
eric | http://about.echarles.net | @echarles
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: storing messages on oracle database
Posted by Eric Charles <er...@u-mangate.com>.
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 <er...@u-mangate.com>
> *To:* James Users List <se...@james.apache.org>
> *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: eric.charles@u-mangate.com <ma...@u-mangate.com>
> >> To: server-user@james.apache.org <ma...@james.apache.org>
> >> 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<eric.charles@u-mangate.com
> <ma...@u-mangate.com>>
> >>> *To:* James Users List<server-user@james.apache.org
> <ma...@james.apache.org>>
> >>> *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: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> >>> <mailto:server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>>
> >>> For additional commands, e-mail: server-user-help@james.apache.org
> <ma...@james.apache.org>
> >>> <mailto:server-user-help@james.apache.org
> <ma...@james.apache.org>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> >>> For additional commands, e-mail: server-user-help@james.apache.org
> <ma...@james.apache.org>
> >>
> >> --
> >> eric | http://about.echarles.net | @echarles
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> >> For additional commands, e-mail: server-user-help@james.apache.org
> <ma...@james.apache.org>
> >>
> >
>
> --
> eric | http://about.echarles.net | @echarles
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> For additional commands, e-mail: server-user-help@james.apache.org
> <ma...@james.apache.org>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
--
eric | http://about.echarles.net | @echarles
--
eric | http://about.echarles.net | @echarles
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: storing messages on oracle database
Posted by mike tazelaar <ta...@yahoo.com>.
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 <er...@u-mangate.com>
To: James Users List <se...@james.apache.org>
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: eric.charles@u-mangate.com
>> To: server-user@james.apache.org
>> 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<er...@u-mangate.com>
>>> *To:* James Users List<se...@james.apache.org>
>>> *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: server-user-unsubscribe@james.apache.org
>>> <ma...@james.apache.org>
>>> For additional commands, e-mail: server-user-help@james.apache.org
>>> <ma...@james.apache.org>
>>>
>>>
>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>>> For additional commands, e-mail: server-user-help@james.apache.org
>>
>> --
>> eric | http://about.echarles.net | @echarles
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>> For additional commands, e-mail: server-user-help@james.apache.org
>>
>
--
eric | http://about.echarles.net | @echarles
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: storing messages on oracle database
Posted by Eric Charles <er...@u-mangate.com>.
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: eric.charles@u-mangate.com
>> To: server-user@james.apache.org
>> 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<er...@u-mangate.com>
>>> *To:* James Users List<se...@james.apache.org>
>>> *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: server-user-unsubscribe@james.apache.org
>>> <ma...@james.apache.org>
>>> For additional commands, e-mail: server-user-help@james.apache.org
>>> <ma...@james.apache.org>
>>>
>>>
>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>>> For additional commands, e-mail: server-user-help@james.apache.org
>>
>> --
>> eric | http://about.echarles.net | @echarles
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>> For additional commands, e-mail: server-user-help@james.apache.org
>>
>
--
eric | http://about.echarles.net | @echarles
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
RE: storing messages on oracle database
Posted by "Kendrick C. Wilson" <ke...@hotmail.com>.
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: eric.charles@u-mangate.com
> To: server-user@james.apache.org
> 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 <er...@u-mangate.com>
> > *To:* James Users List <se...@james.apache.org>
> > *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: server-user-unsubscribe@james.apache.org
> > <ma...@james.apache.org>
> > For additional commands, e-mail: server-user-help@james.apache.org
> > <ma...@james.apache.org>
> >
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> > For additional commands, e-mail: server-user-help@james.apache.org
>
> --
> eric | http://about.echarles.net | @echarles
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
Re: storing messages on oracle database
Posted by Eric Charles <er...@u-mangate.com>.
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 <er...@u-mangate.com>
> *To:* James Users List <se...@james.apache.org>
> *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: server-user-unsubscribe@james.apache.org
> <ma...@james.apache.org>
> For additional commands, e-mail: server-user-help@james.apache.org
> <ma...@james.apache.org>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
--
eric | http://about.echarles.net | @echarles
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: storing messages on oracle database
Posted by mike tazelaar <ta...@yahoo.com>.
I have attached the log. I am using 2.3.2.
________________________________
From: Eric Charles <er...@u-mangate.com>
To: James Users List <se...@james.apache.org>
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: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: storing messages on oracle database
Posted by Eric Charles <er...@u-mangate.com>.
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: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org