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, <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > Sent: Monday, February 25, 2008 12:41 PM > To: [email protected] > 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, <[EMAIL PROTECTED]> 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 >
