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.

jConnect and Java Plug-in 1.2

4 posts in JConnect version 3.0 Last posting was on 1999-03-24 13:06:01.0Z
Brian Carter Posted on 1999-03-22 21:39:34.0Z
Message-ID: <36F6B896.6A9@bcbsal.org>
Date: Mon, 22 Mar 1999 15:39:34 -0600
From: Brian Carter <brcarter@bcbsal.org>
Reply-To: brcarter@bcbsal.org
Organization: BlueCross BlueShield of Alabama
X-Mailer: Mozilla 3.01 (WinNT; I)
MIME-Version: 1.0
Subject: jConnect and Java Plug-in 1.2
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jconnect30
Lines: 13
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.jconnect30:292
Article PK: 255704

There is a small group of users here that are using the Java Plug-in 1.2
... my db applet uses jConnect 2.2 and the applet uses jdk1.02 ... the
forms seem to be done correctly, but when it tries to load the jConnect
driver I get the "No suitable driver" message...

does anyone know if I am doing something wrong or is jConnect 2.2 and
Java Plug-in 1.2 not compatible?

Yes. There is a reason behind doing it this way, but it is rather
lengthy, so I won't go into that...

thanx for your help


Eric Giguere Posted on 1999-03-23 01:09:47.0Z
From: "Eric Giguere" <giguere@sybase.com>
References: <36F6B896.6A9@bcbsal.org>
Subject: Re: jConnect and Java Plug-in 1.2
Date: Mon, 22 Mar 1999 20:09:47 -0500
Lines: 15
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <aqLn7mMd#GA.212@forums.sybase.com>
Newsgroups: sybase.public.jconnect30
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.jconnect30:291
Article PK: 254595


Brian Carter wrote in message <36F6B896.6A9@bcbsal.org>...
>There is a small group of users here that are using the Java Plug-in 1.2
>... my db applet uses jConnect 2.2 and the applet uses jdk1.02 ... the
>forms seem to be done correctly, but when it tries to load the jConnect
>driver I get the "No suitable driver" message...

You are using the jdbc.sql package and not java.sql, correct? And
the jdbc.sybase.jdbc.SybDriver classname for the driver, not
com.sybase.jdbc.SybDriver? If you're not doing either of those
then you'll get that kind of message.

Eric


Brian Carter Posted on 1999-03-23 16:11:39.0Z
Message-ID: <36F7BD3B.5996@bcbsal.org>
Date: Tue, 23 Mar 1999 10:11:39 -0600
From: Brian Carter <brcarter@bcbsal.org>
Reply-To: brcarter@bcbsal.org
Organization: BlueCross BlueShield of Alabama
X-Mailer: Mozilla 3.01 (WinNT; I)
MIME-Version: 1.0
Subject: Re: jConnect and Java Plug-in 1.2
References: <36F6B896.6A9@bcbsal.org> <aqLn7mMd#GA.212@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jconnect30
Lines: 38
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.jconnect30:289
Article PK: 255756


Eric Giguere wrote:
>
> Brian Carter wrote in message <36F6B896.6A9@bcbsal.org>...
> >There is a small group of users here that are using the Java Plug-in 1.2
> >... my db applet uses jConnect 2.2 and the applet uses jdk1.02 ... the
> >forms seem to be done correctly, but when it tries to load the jConnect
> >driver I get the "No suitable driver" message...
>
> You are using the jdbc.sql package and not java.sql, correct? And
> the jdbc.sybase.jdbc.SybDriver classname for the driver, not
> com.sybase.jdbc.SybDriver? If you're not doing either of those
> then you'll get that kind of message.
>
> Eric

this is how i am setting up my transaction object:

prodTrans = new powersoft.powerj.db.jdbc_sql.Transaction();
prodTrans.setTraceToLog( false );
prodTrans.registerDriver( "jdbc.sybase.jdbc.SybDriver" );
prodTrans.setDriverName( "jdbc.sybase.jdbc.SybDriver" );
prodTrans.setName( "MainForm.prodTrans" );
prodTrans.setDataSource("jdbc:sybase:Tds:mydbsrvr:port/dbname");
prodTrans.setProperty("CHARSET", "cp850" );
prodTrans.setProperty("proxy", getCodeBase().getHost().concat(":8000")
);
prodTrans.setUserID(uid);
prodTrans.setPassword(pwd);
prodTrans.setAutoCommit(true);
prodTrans.setLoginTimeout( 0 );
prodTrans.connect();

this works with everything except plugin 1.2, so I believe that they are
not compatible, but was looking for some other confirmation...

I looked through my code and I do not reference java.sql anywhere...

thanx


Eric Giguere Posted on 1999-03-24 13:06:01.0Z
From: "Eric Giguere" <giguere@sybase.com>
References: <36F6B896.6A9@bcbsal.org> <aqLn7mMd#GA.212@forums.sybase.com> <36F7BD3B.5996@bcbsal.org>
Subject: Re: jConnect and Java Plug-in 1.2
Date: Wed, 24 Mar 1999 08:06:01 -0500
Lines: 7
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <O1oN4bfd#GA.116@forums.sybase.com>
Newsgroups: sybase.public.jconnect30
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.jconnect30:287
Article PK: 254596

Everything looks fine. Perhaps the plug-in can't find
the jdbc.sybase.* classes, I don't know what else would
cause that error.

Eric