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.

Package jdbc.sql not found (java 1.02)

4 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-04-22 13:22:14.0Z
Steve Pringle Posted on 1997-04-16 23:45:25.0Z
Message-ID: <33556495.684F@livemedia.com>
Date: Wed, 16 Apr 1997 16:45:25 -0700
From: Steve Pringle <pringle@livemedia.com>
Reply-To: pringle@livemedia.com
Organization: LiveMedia LLC
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
CC: pringle@livemedia.com
Subject: Package jdbc.sql not found (java 1.02)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 34
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:985
Article PK: 252737

I'm using java 1.02 on windows 95 and am having problems compiling. The
complier is unable to locate the jdbc.sql package.

Everything seems to be inorder - classpath, etc.

Any clues?

thanks,
Steve Pringle

Output from compile:

compiling: SimpleSelect.java
SimpleSelect.java:4: Package jdbc.sql not found in import.
import jdbc.sql.*;
^
SimpleSelect.java:6: Package jdbc.sybase.jdbc not found in import.
import jdbc.sybase.jdbc.*;
^

my classpath: (it's one line...)

D:\JDBC\dev\select>echo %CLASSPATH%
.;C:\Program
Files\sybase\jConnect\syb102.zip;D:\visualCafe\JAVA\LIB\CLASSES.ZIP

D:\JDBC\dev\select>echo %JDBC_HOME%
C:\Program Files\sybase\jConnect


source code fragment:

import java.io.*;
// Get the JDBC package.
// import jdbc.sql for JDK1.0.2
import jdbc.sql.*;
import jdbc.sybase.jdbc.*;
import java.util.*; // Properties

public class SimpleSelect
{
public static void main(String args[])
{
try
{
/*
* Open the connection. May Throw a SQLException.
* Parameters:
* url - "jdbc:sybase:Tds:host:port num"
* user - user login id
* password - user login password
*/
Connection con = DriverManager.getConnection(
"jdbc:sybase:Tds:kew:2048", "dba", "sql");


David Clegg Posted on 1997-04-17 21:48:41.0Z
Message-ID: <33569AB9.35B67CF0@sybase.com>
Date: Thu, 17 Apr 1997 14:48:41 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 2.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: pringle@livemedia.com
Subject: Re: Package jdbc.sql not found (java 1.02)
References: <33556495.684F@livemedia.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 41
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:972
Article PK: 252723

I don't think that Cafe looks at CLASSPATH environment, you have
to drill-down from some menu to add additional paths to the
CLASSPATH which cafe uses.

dave

>
> I'm using java 1.02 on windows 95 and am having problems compiling. The
> complier is unable to locate the jdbc.sql package.
>
> Everything seems to be inorder - classpath, etc.
>
> Any clues?
>
> thanks,
> Steve Pringle
>
> Output from compile:
>
> compiling: SimpleSelect.java
> SimpleSelect.java:4: Package jdbc.sql not found in import.
> import jdbc.sql.*;
> ^
> SimpleSelect.java:6: Package jdbc.sybase.jdbc not found in import.
> import jdbc.sybase.jdbc.*;
> ^
>
> my classpath: (it's one line...)
>
> D:\JDBC\dev\select>echo %CLASSPATH%
> .;C:\Program
> Files\sybase\jConnect\syb102.zip;D:\visualCafe\JAVA\LIB\CLASSES.ZIP
>
> D:\JDBC\dev\select>echo %JDBC_HOME%
> C:\Program Files\sybase\jConnect
>
> source code fragment:
>
> import java.io.*;
> // Get the JDBC package.
> // import jdbc.sql for JDK1.0.2
> import jdbc.sql.*;
> import jdbc.sybase.jdbc.*;
> import java.util.*; // Properties
>
> public class SimpleSelect
> {
> public static void main(String args[])
> {
> try
> {
> /*
> * Open the connection. May Throw a SQLException.
> * Parameters:
> * url - "jdbc:sybase:Tds:host:port num"
> * user - user login id
> * password - user login password
> */
> Connection con = DriverManager.getConnection(
> "jdbc:sybase:Tds:kew:2048", "dba", "sql");


Steve Pringle Posted on 1997-04-17 22:55:33.0Z
Message-ID: <3356AA65.7A0F@livemedia.com>
Date: Thu, 17 Apr 1997 15:55:33 -0700
From: Steve Pringle <pringle@livemedia.com>
Reply-To: pringle@livemedia.com
Organization: LiveMedia LLC
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
To: David Clegg <davec@sybase.com>
Subject: Re: Package jdbc.sql not found (java 1.02)
References: <33556495.684F@livemedia.com> <33569AB9.35B67CF0@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 47
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:964
Article PK: 252719

Actually I was using javac from a dos prompt, not Visual Cafe. Any
other thoughts on the matter?

thanks,
Steve

David Clegg wrote:
>
> I don't think that Cafe looks at CLASSPATH environment, you have
> to drill-down from some menu to add additional paths to the
> CLASSPATH which cafe uses.
>
> dave
> >
> > I'm using java 1.02 on windows 95 and am having problems compiling. The
> > complier is unable to locate the jdbc.sql package.
> >
> > Everything seems to be inorder - classpath, etc.
> >
> > Any clues?
> >
> > thanks,
> > Steve Pringle
> >
> > Output from compile:
> >
> > compiling: SimpleSelect.java
> > SimpleSelect.java:4: Package jdbc.sql not found in import.
> > import jdbc.sql.*;
> > ^
> > SimpleSelect.java:6: Package jdbc.sybase.jdbc not found in import.
> > import jdbc.sybase.jdbc.*;
> > ^
> >
> > my classpath: (it's one line...)
> >
> > D:\JDBC\dev\select>echo %CLASSPATH%
> > .;C:\Program
> > Files\sybase\jConnect\syb102.zip;D:\visualCafe\JAVA\LIB\CLASSES.ZIP
> >
> > D:\JDBC\dev\select>echo %JDBC_HOME%
> > C:\Program Files\sybase\jConnect
> >
> > source code fragment:
> >
> > import java.io.*;
> > // Get the JDBC package.
> > // import jdbc.sql for JDK1.0.2
> > import jdbc.sql.*;
> > import jdbc.sybase.jdbc.*;
> > import java.util.*; // Properties
> >
> > public class SimpleSelect
> > {
> > public static void main(String args[])
> > {
> > try
> > {
> > /*
> > * Open the connection. May Throw a SQLException.
> > * Parameters:
> > * url - "jdbc:sybase:Tds:host:port num"
> > * user - user login id
> > * password - user login password
> > */
> > Connection con = DriverManager.getConnection(
> > "jdbc:sybase:Tds:kew:2048", "dba", "sql");


Lance Andersen Posted on 1997-04-22 13:22:14.0Z
Message-ID: <335CBB86.1718@sybase.com>
Date: Tue, 22 Apr 1997 09:22:14 -0400
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 3.01Gold (X11; I; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: pringle@livemedia.com
Subject: Re: Package jdbc.sql not found (java 1.02)
References: <33556495.684F@livemedia.com> <33569AB9.35B67CF0@sybase.com> <3356AA65.7A0F@livemedia.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 67
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:952
Article PK: 252705

Steve,

Not sure if you are still encountering the problem, but
try specifying -classpath when you compile.

Also, I would suggest using jconnect\classes instead of the
zip file in your CLASSPATH.

-lance

Steve Pringle wrote:
>
> Actually I was using javac from a dos prompt, not Visual Cafe. Any
> other thoughts on the matter?
>
> thanks,
> Steve
>
> David Clegg wrote:
> >
> > I don't think that Cafe looks at CLASSPATH environment, you have
> > to drill-down from some menu to add additional paths to the
> > CLASSPATH which cafe uses.
> >
> > dave
> > >
> > > I'm using java 1.02 on windows 95 and am having problems compiling. The
> > > complier is unable to locate the jdbc.sql package.
> > >
> > > Everything seems to be inorder - classpath, etc.
> > >
> > > Any clues?
> > >
> > > thanks,
> > > Steve Pringle
> > >
> > > Output from compile:
> > >
> > > compiling: SimpleSelect.java
> > > SimpleSelect.java:4: Package jdbc.sql not found in import.
> > > import jdbc.sql.*;
> > > ^
> > > SimpleSelect.java:6: Package jdbc.sybase.jdbc not found in import.
> > > import jdbc.sybase.jdbc.*;
> > > ^
> > >
> > > my classpath: (it's one line...)
> > >
> > > D:\JDBC\dev\select>echo %CLASSPATH%
> > > .;C:\Program
> > > Files\sybase\jConnect\syb102.zip;D:\visualCafe\JAVA\LIB\CLASSES.ZIP
> > >
> > > D:\JDBC\dev\select>echo %JDBC_HOME%
> > > C:\Program Files\sybase\jConnect
> > >
> > > source code fragment:
> > >
> > > import java.io.*;
> > > // Get the JDBC package.
> > > // import jdbc.sql for JDK1.0.2
> > > import jdbc.sql.*;
> > > import jdbc.sybase.jdbc.*;
> > > import java.util.*; // Properties
> > >
> > > public class SimpleSelect
> > > {
> > > public static void main(String args[])
> > > {
> > > try
> > > {
> > > /*
> > > * Open the connection. May Throw a SQLException.
> > > * Parameters:
> > > * url - "jdbc:sybase:Tds:host:port num"
> > > * user - user login id
> > > * password - user login password
> > > */
> > > Connection con = DriverManager.getConnection(
> > > "jdbc:sybase:Tds:kew:2048", "dba", "sql");

--
===============================================================================
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!!!
===============================================================================