Hi Stefano Hi All > 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. I tried. Using ojdbc14.jar from Oracle10gR2 can connect! But I want to use as possible as ojdbc6.jar from Oracle11gR1...
Add user/pass to jdbcurl,I also tried, could not connect. >> Other clients software can connect same user. > They also use JDBC and they are connecting from the same machine? Yes.They use JDBC and same machine. >> Use DBCP only is successful. > What do you mean? DataSource uses classes commons-DBCP. ----- <data-source name="maildb" class="org.apache.james.util.dbcp.JdbcDataSource"> ----- Then I checked whether jdbc+dbcp can connect to Oracle. It was successful. But,james(avalon?)+jdbc+dbcp cannot connect. So, I said "DBCP only". Sorry. 2009/11/27 Stefano Bagnara <[email protected]>: > 2009/11/26 fujimoto hs <[email protected]>: >> 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: [email protected] >> For additional commands, e-mail: [email protected] >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
