ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <larry.mead...@gmail.com>
Subject Re: Bea oracle drivers problem
Date Mon, 25 Feb 2008 18:20:15 GMT
It looks like you have to specify the SID as a connection parameter...

http://e-docs.bea.com/wls/docs81/jdbc_drivers/oracle.html#1066413

Same page, further down.

Larry


On Mon, Feb 25, 2008 at 11:01 AM,  <Bill.Spencer@cox.com> wrote:
> I agree, but when I remove the DB name. I get the message below. Is
>  there another place in the sqlmap properties to specify this?
>
>  java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-12505
>  Connection refused, the specified SID (ORCL) was not recognized
>  by the Oracle server.
>
>
>
>  -----Original Message-----
>  From: Larry Meadors [mailto:larry.meadors@gmail.com]
>  Sent: Monday, February 25, 2008 12:41 PM
>  To: user-java@ibatis.apache.org
>  Subject: Re: Bea oracle drivers problem
>
>  http://e-docs.bea.com/wls/docs81/jdbc_drivers/oracle.html#1066403
>
>  Looks like you want:
>
>  url=jdbc:bea:oracle://172.28.25.10:1521
>
>  Larry
>
>
>  On Mon, Feb 25, 2008 at 10:36 AM,  <Bill.Spencer@cox.com> wrote:
>  >
>  >
>  >
>  > Can anyone give me the driver and url properties using ibatis and the
>  bea
>  > oracle drivers? I keep getting the message below. I can connect fine
>  with
>  > the Oracle drivers.
>  >
>  > Cause: java.sql.SQLException: [BEA][Oracle JDBC Driver]Unable to
>  connect.
>  > Invalid URL.
>  >
>  > driver=weblogic.jdbc.oracle.OracleDriver
>  > url=jdbc:bea:oracle://172.28.25.10:1521:MYSID
>  > username=myname
>  > password=myword
>  >
>  > Thanks,
>  > Bill Spencer | Sr Software Engineer
>

Mime
View raw message