Re: Problem Using JDBC Repositories.

[Stefano Bagnara]

2009/11/26 fujimoto hs <hs.fujimot...@gmail.com>:
> Hello all,
>
> I tried to use JDBC Repositories with Oracle11g.
> But connection can not get and error occured
> "ORA-01017: invalid username/password; logon denied".

I used James with Oracle 5 years ago, so I don't remember much, but it
worked and my customer is still using it.
Please try different jdbc drivers. Some oracle jdbc drivers require
the oracle client installed on the same machine.
Some of them require the user/pass to be specified as part of the jdbcurl.

> Other clients software can connect same user.

They also use JDBC and they are connecting from the same machine?

> Use DBCP only is successful.

What do you mean?

Stefano

> How can I get Connections?
> Please help me.
>
>
> config.xml(database-connections section only,Others default.)
> -------------------------------------------------------------
> <data-source name="maildb"
>  class="org.apache.james.util.dbcp.JdbcDataSource">
> <driver>oracle.jdbc.driver.OracleDriver</driver>
> <dburl>jdbc:oracle:thin:@XXX.XXX.XXX.XXX:1521:orcl</dburl>
> <user>username</user>
> <password>pass</password>
> <max>2</max>
> </data-source>
> -------------------------------------------------------------
>
> Env:
> -------------------------------------------------------------
> jdk 1.6.0_13
> Oracle 11.1.0.7.0
> JamesServer 2.3.2
> -------------------------------------------------------------
>
> P.S.
> Oracle "case sensitive" is FALSE.
> "org.apache.james.util.mordred.JdbcDataSource" can not connect too.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org
> For additional commands, e-mail: server-user-h...@james.apache.org
>
>

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