Db config issue with oracle

[Marcello Marangio <m....@tno.it>]

Hi all.
I'm trying to set up a jdbc connection with my oracle DB, to use
JDBCVirtualUserTable
That's my config.xml bit:
...
...
<mailet match="All" class="JDBCVirtualUserTable">
<table>db://scateldb/virtualusertable</table>
</mailet>
...
...
<database-connections>
<data-source name="scateldb"
class="org.apache.james.util.dbcp.JdbcDataSource">
<driver>oracle.jdbc.driver.OracleDriver</driver>
<dburl>jdbc:oracle:thin:@scatel.csata.tno.it:1521:scatel</dburl>
<user>scatel</user>
<password>scatel</password>
<max>20</max>
</data-source>

Oracle driver jar file is in <phoenix_home>/lib

What i get is:
org.apache.excalibur.containerkit.lifecycle.LifecycleException: Component
named "spoolmanager" failed to pass through th
e Initialization stage. (Reason: javax.mail.MessagingException: Error
initializing JDBCVirtualUserTable;
...
...
Caused by: javax.mail.MessagingException: Error initializing
JDBCVirtualUserTable;
  nested exception is:
        org.apache.avalon.framework.component.ComponentException: Unable to
provide DataSourceComponent for scateldb

Any clue?
Thanks
Marcello


---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org

Re: Db config issue with oracle

[Serge Knystautas <se...@lokitech.com>]

Marcello Marangio wrote:
> <database-connections>
> <data-source name="scateldb"
> class="org.apache.james.util.dbcp.JdbcDataSource">
> <driver>oracle.jdbc.driver.OracleDriver</driver>
> <dburl>jdbc:oracle:thin:@scatel.csata.tno.it:1521:scatel</dburl>
> <user>scatel</user>
> <password>scatel</password>
> <max>20</max>
> </data-source>
> 
> Oracle driver jar file is in <phoenix_home>/lib
> 
> What i get is:
> org.apache.excalibur.containerkit.lifecycle.LifecycleException: Component
> named "spoolmanager" failed to pass through th
> e Initialization stage. (Reason: javax.mail.MessagingException: Error
> initializing JDBCVirtualUserTable;
> ...
> ...
> Caused by: javax.mail.MessagingException: Error initializing
> JDBCVirtualUserTable;
>   nested exception is:
>         org.apache.avalon.framework.component.ComponentException: Unable to
> provide DataSourceComponent for scateldb

You should be able to find elsewhere in the logs where it will give an 
error of trying to create the scateldb.  Either can't find the driver 
class, or some oracle error message or something.

-- 
Serge Knystautas
Lokitech >> software . strategy . design >> http://www.lokitech.com
p. 301.656.5501
e. sergek@lokitech.com

---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org