Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Problem with connect properties (Bad design?)

3 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-05-27 19:10:44.0Z
Dirk Fromhein Posted on 1997-05-25 21:01:15.0Z
Message-ID: <3388A89B.1B6A@watershed.com>
Date: Sun, 25 May 1997 17:01:15 -0400
From: Dirk Fromhein <Dirk.Fromhein@watershed.com>
Organization: Watershed Technologies, Inc.
X-Mailer: Mozilla 3.01Gold (X11; U; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
Subject: Problem with connect properties (Bad design?)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 13
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:775
Article PK: 252528

It seems a rather severe limitation that the database name and the port
number must be placed in the URL.

Why not place them where they belong, in the Properties?

Our driver loader is completely JDBC generic and should require only the
base URL (jdbc:sybase:Tds) and the Driver class so that it can get the
required properties from the instantiated driver.

Thoughts on if this will be implemented?

Thans,
Dirk Fromhein
df@watershed.com
http://www.watershed.com


David Clegg Posted on 1997-05-27 19:10:44.0Z
Message-ID: <338B31B4.6ED7ACCF@sybase.com>
Date: Tue, 27 May 1997 12:10:44 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 2.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: Dirk Fromhein <Dirk.Fromhein@watershed.com>
Subject: Re: Problem with connect properties (Bad design?)
References: <3388A89B.1B6A@watershed.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 30
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:764
Article PK: 252515

The plan here is to put host/port# type information into a
network naming service (we would provide a simple tool for
maintaining this information), and then use JNDI (up to your
application to choose a JNDI implementation that knows about
your network naming service) to extract host/port# information
based on a "servername". The URL would indicate to use JNDI
for name resolution -- we could certainly look at adding a
property in which this servername could be stashed rather
than the URL -- I'll take this as a request for that.

No definite date for the JNDI support -- hope to have it available
in jConnect3.0 sometime around Labor Day.

dave

>
> It seems a rather severe limitation that the database name and the port
> number must be placed in the URL.
>
> Why not place them where they belong, in the Properties?
>
> Our driver loader is completely JDBC generic and should require only the
> base URL (jdbc:sybase:Tds) and the Driver class so that it can get the
> required properties from the instantiated driver.
>
> Thoughts on if this will be implemented?
>
> Thans,
> Dirk Fromhein
> df@watershed.com
> http://www.watershed.com


Lance Andersen Posted on 1997-05-27 13:49:12.0Z
Message-ID: <338AE658.6045@sybase.com>
Date: Tue, 27 May 1997 09:49:12 -0400
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 3.01Gold (X11; I; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: Dirk Fromhein <Dirk.Fromhein@watershed.com>
Subject: Re: Problem with connect properties (Bad design?)
References: <3388A89B.1B6A@watershed.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 52
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:771
Article PK: 252522

Dirk,

The database name is not required. The Syntax for the URL is(
the following is from the on-line docs):

Making a Connection to SQL Server


In your Java application, create a URL to connect to the jConnect
driver. There
are 3 acceptable syntaxes:


jdbc:sybase:Tds:host:port
jdbc:sybase:Tds:host:port/
jdbc:sybase:Tds:host:port/database

There is no difference in the function of the first and second
examples.

jdbc:sybase - identifies the driver.

Tds - the Sybase transfer protocol for SQL Server

host:port - the SQL Server host name and the SQL Server listening
port. See the
interfaces file $SYBASE/interfaces (on UNIX) or
%SYBASE%\ini\sql.ini (on
Windows) for the entry that your database or Open Server
application uses.
Obtain the hostname/port# from the "query" entry.

database - use named database (preceded by a slash '/')


This adheres to the JavaSoft 2.0 Specification dated 1/10/97.

Please see sections 6.3.2 thru 6.3.4

Regards,

-Lance

Dirk Fromhein wrote:
>
> It seems a rather severe limitation that the database name and the port
> number must be placed in the URL.
>
> Why not place them where they belong, in the Properties?
>
> Our driver loader is completely JDBC generic and should require only the
> base URL (jdbc:sybase:Tds) and the Driver class so that it can get the
> required properties from the instantiated driver.
>
> Thoughts on if this will be implemented?
>
> Thans,
> Dirk Fromhein
> df@watershed.com
> http://www.watershed.com

--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Technical Support Phone:(617) 564-6336
77 South Bedford Street Fax: (617) 564-6148
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================