Hi:
The key issue in JDBC connectivity is specifying the correct
connection string if you will.
I use the WebLogic Driver for SQLServer2000 without using the
application server.
By way of illustration here are two scenario(s):
a. Java Application - Type 4 driver -> MS SQL Server 2000
-------------------------------------------------------
public class SampleConnectionApp
{
public static void main( String[] args )
{
String url = "jdbc:weblogic:mssqlserver4:server-name-001:1433";
Properties prop = new Properties();
prop.put( "user", "sa" );
prop.put( "password", "sa" );
prop.put( "server", "server-name-001:1433" );
String message = "";
try
{
Driver driver =
(Driver)Class.forName("weblogic.jdbc.mssqlserver4.Driver").newInstance();
Connection con = driver.connect( url, prop );
con.close();
message = "Connection was opened with " + url;
System.out.println( message );
}
catch( java.lang.IllegalAccessException e )
{
e.printStackTrace();
}
catch( java.lang.ClassNotFoundException e )
{
e.printStackTrace();
}
catch( java.lang.InstantiationException e )
{
e.printStackTrace();
}
catch( java.sql.SQLException e )
{
e.printStackTrace();
}
}
}
b. Java app in App Server - Type 4 Driver -> MS SQL Server 2000
------------------------------------------------------------
# WEBLOGIC MS SQLSERVER 2000 CONNECTION POOL PROPERTIES
# ----------------------------------------------------
weblogic.jdbc.connectionPool.SQLPool=\
url=jdbc:weblogic:mssqlserver4:server-name-001:1433,\
driver=weblogic.jdbc.mssqlserver4.Driver,\
loginDelaySecs=1,\
initialCapacity=1,\
maxCapacity=10,\
capacityIncrement=1,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshTestMinutes=10,\
testTable=dual,\
props=user=sa;password=sa;server=server-name-001;\
weblogic.allow.reserve.weblogic.jdbc.connectionPool.SQLPool=\
guest,sa,dev
weblogic.allow.reset.weblogic.jdbc.connectionPool.SQLPool=\
sa,dev
weblogic.allow.shrink.weblogic.jdbc.connectionPool.SQLPool=\
sa,dev
HTH,
Thanks
EJT.
--- Stefan Haubold <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I want to use a SQL Server 2000 Database instead of Cloudscape with the
> Java 2 SDK Enterprise Edition 1.3 (Beta2). My first approach was using
> the JdbcOdbcDriver from Sun. I tried to configure the J2SDKEE1.3 to use
> this driver. It didn't work. Has anybody got this to work?
>
> Best Regards,
>
> Stefan
>
__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
