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.

embedding ASA8 in java app

2 posts in General Discussion Last posting was on 2003-07-16 19:55:22.0Z
dreiger Posted on 2003-07-16 18:08:41.0Z
From: dreiger
Date: Wed, 16 Jul 2003 14:08:41 -0400
Newsgroups: ianywhere.public.general
Subject: embedding ASA8 in java app
Message-ID: <E26B0A97119B18900063AC0585256D65.0063AC2A85256D65@webforums>
Lines: 9
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1364
Article PK: 3598

I'm trying to use a personal database as an ASA 8.0.2 "embedded" database
in a java application. I specifically want to take advantage of the auto
start/stop feature to start and stop ASA when my application is started and
stopped.

It is not clear to me how to use the connection string with a jConnect JDBC
connection.

FYI, if the ASA is already started, I don't have any problems connecting to
it with jConnect.


Nick Elson Posted on 2003-07-16 19:55:22.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
References: <E26B0A97119B18900063AC0585256D65.0063AC2A85256D65@webforums>
Subject: Re: embedding ASA8 in java app
Date: Wed, 16 Jul 2003 15:55:22 -0400
Lines: 55
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <u2e5fV9SDHA.342@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: nicelson-xp.sybase.com 172.31.140.167
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1365
Article PK: 3601

Unfortunately, JConnect is more a product of the Enterprise family of
products where
there is no concept of a personal/standalone server, and that lack of
functionally is also
apparent in the TDS protocol that JConnect uses. As such, while you can
name
which database to connect to and even specify what database file to start on
a
running server +++, there is no way to start a server process through
JConnect
without shelling out to the OS somehow via the JVM.

If this is critical, or if you really want to take full advantage of ASA,
consider
switch to our ASA 'native' JDBC driver. It is available in 8.0.2 as our
'internal' JDBC-ODBC and that becomes our standard iAnywhere JDBC driver
in 9.0 and up.

To use the iAnywhere JDBC driver with ASA 8.0.2 and up reference the
on-line documents at this section

Adaptive Server Anywhere Programming Guide
5. Data Access Using JDBC

Using the JDBC-ODBC bridge




-------------------------------
+++ Reference: On-line documents
Adaptive Server Anywhere Programming Guide
5. Data Access Using JDBC
Using the jConnect JDBC driver
Supplying a URL for the server
"Specifying a database on a server"

<dreiger> wrote in message
news:E26B0A97119B18900063AC0585256D65.0063AC2A85256D65@webforums...
> I'm trying to use a personal database as an ASA 8.0.2 "embedded" database
> in a java application. I specifically want to take advantage of the auto
> start/stop feature to start and stop ASA when my application is started
and
> stopped.
>
> It is not clear to me how to use the connection string with a jConnect
JDBC
> connection.
>
> FYI, if the ASA is already started, I don't have any problems connecting
to
> it with jConnect.