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 Manigandan Shreetharan <ma...@rediffmail.com> on 2002/09/03 19:05:38 UTC
Noel --- How to use JDBC in James
hi noel,
I wnated to use JdbcOdbcDriver class as my driver and I have
specified it in the drver tag in the config.xml file and when I
try to configure my JdbcDatasource object it gives it is not a
valid driver. Help in this how can i use this driver.
regards
mani
On Tue, 03 Sep 2002 Noel J. Bergman wrote :
>What problem are you having? Have you looked at the instructions
>in the
>config.xml file?
>
> --- Noel
>
>-----Original Message-----
> From: Manigandan Shreetharan
>[mailto:manigandans@rediffmail.com]
>
>hi all,
>
>I want to configure James to use Database using JDBC ODBC
>Connection.
>
>with regards
>Mani
>
>
>--
>To unsubscribe, e-mail:
><ma...@jakarta.apache.org>
>For additional commands, e-mail:
><ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: How to use JDBC in James
Posted by Srinivasa Rao Katta <sk...@telegea.com>.
Noel ,
How are you ?.
Thanks for the info.
Srinivas.
> > How can I create the JAMES POP3 mailboxes under Oracle database ?
>
> If you look in config.xml you will see instructions telling you to comment
> out the sections that use file: protocol, and instructing you to use the db:
> protocol. You'll need a good Oracle JDBC driver, too.
>
> sqlResources.xml already has the necessary statements for Oracle's database,
> so the rest should be automatic.
>
> Basically:
>
> 1) Have your DBA creat a database that you can use,
> and a user with permissions to operate within
> that database.
>
> 2) Change config.xml to use the db: protocol. You'll
> need to modify the configuration data with the db
> name, user and password provided by your DBA.
>
> 3) Make sure that you have the correct JDBC driver.
>
> JAMES will create and manage its own tables. However, it doesn't migrate
> existing file based repositories. If someone wants a bit of a project, that
> might be one worth doing.
>
> --- Noel
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: How to use JDBC in James
Posted by "Noel J. Bergman" <no...@devtech.com>.
> How can I create the JAMES POP3 mailboxes under Oracle database ?
If you look in config.xml you will see instructions telling you to comment
out the sections that use file: protocol, and instructing you to use the db:
protocol. You'll need a good Oracle JDBC driver, too.
sqlResources.xml already has the necessary statements for Oracle's database,
so the rest should be automatic.
Basically:
1) Have your DBA creat a database that you can use,
and a user with permissions to operate within
that database.
2) Change config.xml to use the db: protocol. You'll
need to modify the configuration data with the db
name, user and password provided by your DBA.
3) Make sure that you have the correct JDBC driver.
JAMES will create and manage its own tables. However, it doesn't migrate
existing file based repositories. If someone wants a bit of a project, that
might be one worth doing.
--- Noel
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: How to use JDBC in James
Posted by Super-User <sk...@telegea.com>.
Noel,
How are you ?.
I have a question here.
How can I create the JAMES POP3 mailboxes under Oracle database ?.
Right now,James was creating mail boxes under //var/mail/inboxes wihout any
problem.
Could you please letme know,Where can I do make changes in the config.xml.
What are the things I need to get from Oracle database ?.
Please advice me.
Thanks,
Srinivas.
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: How to use JDBC in James
Posted by Danny Angus <da...@apache.org>.
> > No, [put] put it in james/lib.
>
> That is accurate for the current Phoenix?
Yes I put that in once I'd worked it out, so to speak.
> OK. Quick
> clarification, though.
> The config file says: ~james/lib/. Is ~james the root directory for the
> entire structure, including where our copy of Phoenix is located,
> as opposed
> to the james directory under apps? So you're talking about the directory
> otherwise known as $PHOENIX_HOME/lib, as in:
>
> JVM_OPTS="-Djava.ext.dirs=$PHOENIX_HOME/lib"
>
> Correct?
correct, but $PHOENIX_HOME may change to $JAMES_HOME soon, so that we can 1/
keep this phoenix just for James and 2/ have a better james startup/shutdown
script for use from anywhere not just within $PHOENIX_HOME/bin
d.
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: How to use JDBC in James
Posted by "Noel J. Bergman" <no...@devtech.com>.
> No, [put] put it in james/lib.
That is accurate for the current Phoenix? OK. Quick clarification, though.
The config file says: ~james/lib/. Is ~james the root directory for the
entire structure, including where our copy of Phoenix is located, as opposed
to the james directory under apps? So you're talking about the directory
otherwise known as $PHOENIX_HOME/lib, as in:
JVM_OPTS="-Djava.ext.dirs=$PHOENIX_HOME/lib"
Correct?
--- Noel
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: How to use JDBC in James
Posted by Danny Angus <da...@apache.org>.
No.
Read the comments in config.xml, put it in james/lib.
d.
> You can put it into the SAR file in the same location
> as the mysql
> driver.
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: How to use JDBC in James
Posted by "Noel J. Bergman" <no...@devtech.com>.
The driver is not available in your classpath, which is controlled by
Phoenix. You can put it into the SAR file in the same location as the mysql
driver.
>From searching the archives
(http://www.mail-archive.com/james-user@jakarta.apache.org) it appears that
the JDBC-ODBC bridge driver is not necessarily going to work. People have
had problems with it, and I didn't spot anyone having success (not that I
spent too much time looking).
People have had success with Oracle and a real JDBC driver, with MySQL, and
with Hypersonic SQL. I'm assuming that someone has had some success with
each of:
<dbMatcher db="mssql" databaseProductName="microsoft sql server"/>
<dbMatcher db="oracle" databaseProductName="oracle.*"/>
<dbMatcher db="mysql" databaseProductName="my.*"/>
<dbMatcher db="postgresql" databaseProductName="postgres.*"/>
<dbMatcher db="sapdb" databaseProductName="sap.*"/>
<dbMatcher db="hypersonic" databaseProductName="HypersonicSQL"/>
but I can't tell you which drivers worked. You can search the mail archives
to see what people have said, or you can tell people which database you are
using, and see which (if any) drivers people have had success using.
--- Noel
-----Original Message-----
From: Manigandan Shreetharan [mailto:manigandans@rediffmail.com]
Sent: Tuesday, September 03, 2002 13:06
To: James Users List
Subject: Noel --- How to use JDBC in James
hi noel,
I wnated to use JdbcOdbcDriver class as my driver and I have
specified it in the drver tag in the config.xml file and when I
try to configure my JdbcDatasource object it gives it is not a
valid driver. Help in this how can i use this driver.
regards
mani
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Noel --- How to use JDBC in James
Posted by Danny Angus <da...@apache.org>.
this is a bad idea for so many reasons.. but importantly its not production
quality code, it isn't thread-safe
d.
> -----Original Message-----
> From: Manigandan Shreetharan [mailto:manigandans@rediffmail.com]
> Sent: 03 September 2002 18:06
> To: James Users List
> Subject: Noel --- How to use JDBC in James
>
>
> hi noel,
>
> I wnated to use JdbcOdbcDriver class as my driver and I have
> specified it in the drver tag in the config.xml file and when I
> try to configure my JdbcDatasource object it gives it is not a
> valid driver. Help in this how can i use this driver.
>
> regards
> mani
>
>
>
> On Tue, 03 Sep 2002 Noel J. Bergman wrote :
> >What problem are you having? Have you looked at the instructions
> >in the
> >config.xml file?
> >
> > --- Noel
> >
> >-----Original Message-----
> > From: Manigandan Shreetharan
> >[mailto:manigandans@rediffmail.com]
> >
> >hi all,
> >
> >I want to configure James to use Database using JDBC ODBC
> >Connection.
> >
> >with regards
> >Mani
> >
> >
> >--
> >To unsubscribe, e-mail:
> ><ma...@jakarta.apache.org>
> >For additional commands, e-mail:
> ><ma...@jakarta.apache.org>
> >
>
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>