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.

Connecting through DirectConnect

5 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-06-23 19:14:23.0Z
Jeff Gallimore Posted on 1997-06-11 15:37:17.0Z
Message-ID: <339EC62D.8C6ADC3D@perspect.com>
Date: Wed, 11 Jun 1997 11:37:17 -0400
From: Jeff Gallimore <jgallimo@perspect.com>
Reply-To: jgallimo@perspect.com
Organization: Perspective Technology Corporation
X-Mailer: Mozilla 4.0b5 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Connecting through DirectConnect
X-Priority: 3 (Normal)
Content-Type: multipart/mixed; boundary="------------F26298720D51042E1F73D637"
Newsgroups: sybase.public.jdbcconnect
Lines: 38
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:704
Article PK: 252455

I am trying to get an applet to connect to an Oracle database using
jConnect (the 1.02 classes) and DirectConnect running on a Unix server.
I can get the applet to connect (at least that's what it tells me), but
when I try to execute a query using the executeQuery method, I get some
Oracle errors --

jdbc.sql.SQLException: ORA-06550: line 1, column 28:
PLS-00103: Encountered the symbol "FOR" when expecting one of the
following:
:= . ( @ % ; not null range renames default

This tells me that I have connected into the database, but the SQL
statement is malformed. Any suggestions?

Jeff Gallimore


Download VCard vcard.vcf


Lance Andersen Posted on 1997-06-23 19:14:23.0Z
Message-ID: <33AECB0F.682F@ysbase.com>
Date: Mon, 23 Jun 1997 15:14:23 -0400
From: Lance Andersen <lancea@ysbase.com>
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
To: jgallimo@perspect.com
Subject: Re: Connecting through DirectConnect
References: <339EC62D.8C6ADC3D@perspect.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 42
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:647
Article PK: 252399

Hi Jeff,

Let me try typing this in 1 more time (sorry for the garbage in
the previous notes). I managed to get a hold of some oracle docs
and the declare cursor syntax within pl/sql does not match the
standard declare cursor syntax (though it appears that oracles embedded
sql does support the standard syntax). So what this means
currently is that you will not be able to use cursors
with DirectConnect to Oracle via jConnect. We are working with our
DirectConnect engineering group on a means of providing this and the
scripts that are needed to support other platform specific information
(this is needed for DatabaseMetaData support).

Regards,

-Lance

Jeff Gallimore wrote:
>
> I am trying to get an applet to connect to an Oracle database using
> jConnect (the 1.02 classes) and DirectConnect running on a Unix server.
> I can get the applet to connect (at least that's what it tells me), but
> when I try to execute a query using the executeQuery method, I get some
> Oracle errors --
>
> jdbc.sql.SQLException: ORA-06550: line 1, column 28:
> PLS-00103: Encountered the symbol "FOR" when expecting one of the
> following:
> := . ( @ % ; not null range renames default
>
> This tells me that I have connected into the database, but the SQL
> statement is malformed. Any suggestions?
>
> Jeff Gallimore
>
> ---------------------------------------------------------------
>
> Name: vcard.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Jeff Gallimore

H


Lance Andersen Posted on 1997-06-23 19:08:51.0Z
Message-ID: <33AEC9C3.32F6@ysbase.com>
Date: Mon, 23 Jun 1997 15:08:51 -0400
From: Lance Andersen <lancea@ysbase.com>
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
To: jgallimo@perspect.com
Subject: Re: Connecting through DirectConnect
References: <339EC62D.8C6ADC3D@perspect.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:648
Article PK: 252400

Hi Jeff,

I wanted to get back to you on this matter so you know where things
stand. I managed to get ahold of some oracle docos. The pl/sql
syntax within Oracle differs from the traditional declare cursor

systJeff Gallimore wrote:
>
> I am trying to get an applet to connect to an Oracle database using
> jConnect (the 1.02 classes) and DirectConnect running on a Unix server.
> I can get the applet to connect (at least that's what it tells me), but
> when I try to execute a query using the executeQuery method, I get some
> Oracle errors --
>
> jdbc.sql.SQLException: ORA-06550: line 1, column 28:
> PLS-00103: Encountered the symbol "FOR" when expecting one of the
> following:
> := . ( @ % ; not null range renames default
>
> This tells me that I have connected into the database, but the SQL
> statement is malformed. Any suggestions?
>
> Jeff Gallimore
>
> ---------------------------------------------------------------
>
> Name: vcard.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Jeff Gallimore


Lance Andersen Posted on 1997-06-23 19:06:56.0Z
Message-ID: <33AEC950.4224@ysbase.com>
Date: Mon, 23 Jun 1997 15:06:56 -0400
From: Lance Andersen <lancea@ysbase.com>
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
To: jgallimo@perspect.com
Subject: Re: Connecting through DirectConnect
References: <339EC62D.8C6ADC3D@perspect.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 25
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:649
Article PK: 252401

Hi Jeff,

I thought I would Jeff Gallimore wrote:
>
> I am trying to get an applet to connect to an Oracle database using
> jConnect (the 1.02 classes) and DirectConnect running on a Unix server.
> I can get the applet to connect (at least that's what it tells me), but
> when I try to execute a query using the executeQuery method, I get some
> Oracle errors --
>
> jdbc.sql.SQLException: ORA-06550: line 1, column 28:
> PLS-00103: Encountered the symbol "FOR" when expecting one of the
> following:
> := . ( @ % ; not null range renames default
>
> This tells me that I have connected into the database, but the SQL
> statement is malformed. Any suggestions?
>
> Jeff Gallimore
>
> ---------------------------------------------------------------
>
> Name: vcard.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Jeff Gallimore


Mary Peek Posted on 1997-06-11 20:42:16.0Z
Message-ID: <339F0DA8.5002@sybase.com>
Date: Wed, 11 Jun 1997 13:42:16 -0700
From: Mary Peek <maryp@sybase.com>
Reply-To: maryp@sybase.com
Organization: Sybase
X-Mailer: Mozilla 3.01Gold (Win95; I)
MIME-Version: 1.0
Subject: Re: Connecting through DirectConnect
References: <339EC62D.8C6ADC3D@perspect.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 14
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:703
Article PK: 252454


Jeff Gallimore wrote:
> I am trying to get an applet to connect to an Oracle database using
> jConnect (the 1.02 classes) and DirectConnect running on a Unix server.
> I can get the applet to connect (at least that's what it tells me), but
> when I try to execute a query using the executeQuery method, I get some
> Oracle errors --

What is the statement you are using with executeQuery? DirectConnect
does not do any translation of SQL so you would need to be sending it a
correct SQL statement.

Regards,
Mary Peek, Sybase