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.

Transaction and Microsoft JVM

5 posts in JConnect version 3.0 Last posting was on 1999-04-26 14:23:22.0Z
Anders Wikholm Posted on 1999-04-26 12:33:31.0Z
Message-ID: <37245D1B.8C27332F@moulin-noir.com>
Date: Mon, 26 Apr 1999 14:33:31 +0200
From: Anders Wikholm <anders@moulin-noir.com>
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Transaction and Microsoft JVM
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: powersoft.public.powerj.database,sybase.public.jconnect30
Lines: 16
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub powersoft.public.powerj.database:1219 sybase.public.jconnect30:151
Article PK: 372263

I still can't get a PowerJ transaction object to work running in MS
Explorer 5. Mysteriously I get an ArrayIndexOutOfBoundsException from
the transaction object. I get the same behaviour running with the wiever
in Microsoft SDK-Java.31.

The problem is certainly some bug in the Microsoft JVM, since everything
works OK in Netscape 4.5, HotJava and Sun appletviewer.

I'm using an 1.1 applet made with PowerJ 2.5, 2.5.56 classes, JConnect
3.0, and connecting to ASA6.0.

I'd be very happy if someone at Sybase could work this out with
Microsoft, or find a workaround.

Regards
Anders Wikholm


Lance Andersen Posted on 1999-04-26 12:46:11.0Z
Message-ID: <37246013.A369A7A2@sybase.com>
Date: Mon, 26 Apr 1999 08:46:11 -0400
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 4.51 [en] (X11; I; SunOS 5.7 sun4m)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Transaction and Microsoft JVM
References: <37245D1B.8C27332F@moulin-noir.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: powersoft.public.powerj.database,sybase.public.jconnect30
Lines: 32
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub powersoft.public.powerj.database:1217 sybase.public.jconnect30:149
Article PK: 374193


Anders Wikholm wrote:
>
> I still can't get a PowerJ transaction object to work running in MS
> Explorer 5. Mysteriously I get an ArrayIndexOutOfBoundsException from
> the transaction object. I get the same behaviour running with the wiever
> in Microsoft SDK-Java.31.
>
> The problem is certainly some bug in the Microsoft JVM, since everything
> works OK in Netscape 4.5, HotJava and Sun appletviewer.
>
> I'm using an 1.1 applet made with PowerJ 2.5, 2.5.56 classes, JConnect
> 3.0, and connecting to ASA6.0.
>
> I'd be very happy if someone at Sybase could work this out with
> Microsoft, or find a workaround.
>
> Regards
> Anders Wikholm

Try jConnect 4.1 or the latest EBF for 4.0. We managed to workaround
the
bug you mention above in the MS JVM. We will not be fixing this in 3.0.

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

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


Eric Giguere Posted on 1999-04-26 12:38:00.0Z
From: "Eric Giguere" <giguere@sybase.com>
References: <37245D1B.8C27332F@moulin-noir.com>
Subject: Re: Transaction and Microsoft JVM
Date: Mon, 26 Apr 1999 08:38:00 -0400
Lines: 10
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <#KeQYH#j#GA.207@forums.sybase.com>
Newsgroups: powersoft.public.powerj.database,sybase.public.jconnect30
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub powersoft.public.powerj.database:1218 sybase.public.jconnect30:150
Article PK: 377102

Can you post the exact error message and the
call stack that gets printed to the console? I'm leery
about installing IE 5 on my machine right now. I just
need to know where the exception is occurring, there
are only a couple of spots in side the Transaction that
do anything with arrays.

Eric


Anders Wikholm Posted on 1999-04-26 13:59:20.0Z
Message-ID: <37247138.EDF90CFD@moulin-noir.com>
Date: Mon, 26 Apr 1999 15:59:20 +0200
From: Anders Wikholm <anders@moulin-noir.com>
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Transaction and Microsoft JVM
References: <37245D1B.8C27332F@moulin-noir.com> <#KeQYH#j#GA.207@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: powersoft.public.powerj.database,sybase.public.jconnect30
Lines: 73
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub powersoft.public.powerj.database:1216 sybase.public.jconnect30:148
Article PK: 372262


Eric Giguere wrote:

> Can you post the exact error message and the
> call stack that gets printed to the console? I'm leery
> about installing IE 5 on my machine right now. I just
> need to know where the exception is occurring, there
> are only a couple of spots in side the Transaction that
> do anything with arrays.
>
> Eric

Here's the console output.

Anders

-- Logging started 1999-apr-26 15:55:13
PowerJ component library (PJClass) version 2.5.56 (debug)
powersoft.powerj.db.java_sql.Transaction: logging enabled
powersoft.powerj.db.java_sql.Transaction: [in setDriverName] new driver
is com.sybase.jdbc.SybDriver
powersoft.powerj.db.java_sql.Transaction: [Form1.transaction_1 in
setName] new name is 'Form1.transaction_1', now registered in the global
name table
powersoft.powerj.db.java_sql.Transaction: [Form1.transaction_1 in
setDataSource] new URL is jdbc:sybase:Tds:poseidon:2638/backoffice_V6
powersoft.powerj.db.java_sql.Transaction: [Form1.transaction_1 in
setUserID] UserID is 'andersw'
powersoft.powerj.db.java_sql.Transaction: [Form1.transaction_1 in
setPassword] password is 'peg564st'
powersoft.powerj.db.java_sql.Transaction: [Form1.transaction_1 in
setAutoCommit] autocommit is true
powersoft.powerj.db.java_sql.Transaction: [Form1.transaction_1 in
setLoginTimeout] setting timeout to infinite timeout
powersoft.powerj.db.java_sql.Query: [Form1.query_1 in setName] new name
is 'Form1.query_1', now registered in the global name table
powersoft.powerj.db.java_sql.Query: [Form1.query_1 in
setTransactionObject] setting to 'Form1.transaction_1'
powersoft.powerj.db.java_sql.Transaction: [Form1.transaction_1 in
addQuery] adding query 'Form1.query_1'
powersoft.powerj.db.java_sql.Transaction: [Form1.transaction_1 in
connect] getting connection using
URL=jdbc:sybase:Tds:poseidon:2638/backoffice_V6
powersoft.powerj.db.java_sql.Transaction: [Form1.transaction_1 in
obtainConnection] obtaining connection using JDBC DriverManager
powersoft.powerj.db.java_sql.Transaction: [Form1.transaction_1 in
connect] connection could not be obtained on this thread, trying on
another thread
powersoft.powerj.db.java_sql.Transaction: [Form1.transaction_1 in
obtainConnection] obtaining connection using JDBC DriverManager
>> powersoft.powerj.db.java_sql.Transaction: [Form1.transaction_1 in
connect] exception: java.lang.ArrayIndexOutOfBoundsException
powersoft.powerj.db.java_sql.Transaction: [Form1.transaction_1 in
connect] java.lang.ArrayIndexOutOfBoundsException
powersoft.powerj.db.java_sql.Transaction: [Form1.transaction_1]
autoconnect failed
powersoft.powerj.db.java_sql.Query: [Form1.query_1 in setSQL] setting
SQL string to 'Select * from dba.I_Instrument_ANS'
powersoft.powerj.db.java_sql.Query: [Form1.query_1 in open] transaction
is not connected
powersoft.powerj.db.java_sql.Query: [Form1.query_1 in open] returns
false


Eric Giguere Posted on 1999-04-26 14:23:22.0Z
From: "Eric Giguere" <giguere@sybase.com>
References: <37245D1B.8C27332F@moulin-noir.com> <#KeQYH#j#GA.207@forums.sybase.com> <37247138.EDF90CFD@moulin-noir.com>
Subject: Re: Transaction and Microsoft JVM
Date: Mon, 26 Apr 1999 10:23:22 -0400
Lines: 11
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <h2$fQC$j#GA.314@forums.sybase.com>
Newsgroups: powersoft.public.powerj.database,sybase.public.jconnect30
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub powersoft.public.powerj.database:1215 sybase.public.jconnect30:147
Article PK: 277337

Ah, the exception is actually occurring in the JDBC driver,
not in the Transaction object. Lance posted a message
stating they have a workaround for jConnect 4.x, so I
would get that workaround. Other than that, there's really
nothing I can do to help you, because if the JDBC driver
doesn't connect, there's nothing the Transaction object
can do.

Eric