jython and java exceptions

[Jan Gregor]

Hello

I found that jython catches exact java exceptions, not their
subclasses. Is there some way to get around this limitation (or error) ?

My program has class representing database source and specialed classes
for particulars databases. Now there are two options - to include
exception (subclasses of SQLException) for every db in except (so
all drivers has to be present) or to move methods to subclasses.
Jan

[Alan Kennedy]

[Jan Gregor]

I found that jython catches exact java exceptions, not their
subclasses. Is there some way to get around this limitation (or error) ?
Hmm, not sure what you mean here. Consider the following code

############### ##
from java.io import FileInputStream
from java.io import IOException
from java.io import FileNotFoundExc eption; # Subclasses IOException

dud_file_name = "does_not_exist .txt"

def open_file(filen ame):
return FileInputStream (filename)

# For this function, we expect the FileNotFoundExc eption clause
# to be executed, because it is listed first, and matches the
# exception precisely

def catch_subclass( ):
try:
f = open_file(dud_f ile_name)
f.close()
except FileNotFoundExc eption, fnfx:
print "Caught expected FileNotFoundExc eption: %s" % str(fnfx)
except IOException, iox:
print "Error: should not have reached IOException clause"

# For this function, we expect the IOException clause to be
# executed, because it is listed first, and matches the exception,
# because FileNotFoundExc eption is a subclass of IOException

def catch_superclas s():
try:
f = open_file(dud_f ile_name)
f.close()
except IOException, iox:
print "Caught expected IOException: %s" % str(iox)
except FileNotFoundExc eption, fnfx:
print "Error: should not have reached FileNotFoundExc eption clause"

if __name__ == "__main__":
catch_subclass( )
catch_superclas s()
############### #########

AFAICT, the above code demonstrates the correct behaviour for java
exception handling in jython, and contradicts your statements above.

Perhaps you can post a code sample that shows what you mean?
My program has class representing database source and specialed classes
for particulars databases. Now there are two options - to include
exception (subclasses of SQLException) for every db in except (so
all drivers has to be present) or to move methods to subclasses.

You should be able to catch all exceptions using code like this

try:
# database operations
except java.sql.SqlExc eption:
# This will catch all SQLExceptions and subclasses.

--
alan kennedy
------------------------------------------------------
check http headers here: http://xhaus.com/headers
email alan: http://xhaus.com/contact/alan

[Jan Gregor]

Hello

I tried it again with SQLException only but my main loop ends with
uncatched com.sybase.jdbc 2.jdbc.SybSQLEx ception. This is extract from my code, exception is thrown by self.db.execute Sql(iline),
def run (self):
while (1):
gr_mode= 0
iline= Readline.readli ne(":", 0)
if iline==None:
continue
iline= strip(iline)
if iline=='\q':
try:
Readline.writeH istoryFile(self .rl_history.get Name())
except:
print ("Error writing history file!")
System.exit(0)
break
if iline=='\gr':
continue Readline.addToH istory(iline) if re.match(r'^\+ ', iline):
gr_mode= 1
iline= strip(iline[2:])

try:
type, result= self.db.execute Sql(iline)
if result==None:
continue
if type=='resultSe t':
self.process(re sult)
elif type=='table':
if gr_mode:
wnd = swingWnd.Simple Swing(result.to _html())
wnd.size= (600,600)
wnd.setVisible( 1)
else:
self._print_tab le(result)
elif type=='viewSour ce' or type=='procSour ce':
self.println(re sult)
elif type=='tableDes c':
self._print_tab le(result)
elif type=='error':
self.println(re sult)
# except (SQLException, PSQLException, SybSQLException ), e:
except java.sql.SQLExc eption, e:
self.println(e. getMessage())
# except:
# pass

Jan

[Alan Kennedy]

[Jan Gregor]

I tried it again with SQLException only but my main loop ends with
uncatched com.sybase.jdbc 2.jdbc.SybSQLEx ception.

Strange indeed. The only explanation I can think of offhand for the
exception not being caught is if com.sybase.jdbc 2.jdbc.SybSQLEx ception
is not a subclass of java.sql.SQLExc eption.

Unfortunately, I can't seem to find the javadoc for the Sybase JDBC
driver online (which is poor performance from Sybase).

Try code of the following form to see what the nature of the exception is

import java.lang.Excep tion
import java.sql.SQLExc eption

try:
# Insert your exception generating code here
except java.lang.Excep tion, jlx: # Catch every possible java exception
if isinstance(jlx, java.sql.SQLExc eption):
print "Exc %s is subclass of java.sql.SQLExc eption" % jlx.toString()
else:
print "Exc %s != subclass of java.sql.SQLExc eption!" % jlx.toString()

Run that and let us know what the output is.

--
alan kennedy
------------------------------------------------------
email alan: http://xhaus.com/contact/alan

[Jan Gregor]

There's result - i put aa on input to force error:

Exc com.sybase.jdbc 2.jdbc.SybSQLEx ception: Stored procedure 'aa' not
found. Specify owner.objectnam e or use sp_help to check whether the
object exists (sp_help may produce lots of output).
!= subclass of java.sql.SQLExc eption!
Problem is that SybSQLException IS subclass of SQLException - verified
by Eclipse IDE (type hierarchy). Similar effects were with jdbc driver
for PostgreSQL.

There's result:
Exc org.postgresql. util.PSQLExcept ion: ERROR: syntax error at or near
"aa"
!= subclass of java.sql.SQLExc eption!
Jan

[Alan Kennedy]

[Jan Gregor]

There's result - i put aa on input to force error:
What execution environment are you running it in when you have this
problem? A servlet container? Eclipse? From the command line?

I'm beginning to suspect some form of classloader/classpath issue.
Exc com.sybase.jdbc 2.jdbc.SybSQLEx ception: Stored procedure 'aa' not
found. Specify owner.objectnam e or use sp_help to check whether the
object exists (sp_help may produce lots of output).
!= subclass of java.sql.SQLExc eption!
So your jython code finds that the exception raised does not subclass
the base exception it is trying to catch. Which could mean that the
definitions of the base exception class may be different between the
code trying to catch the exception (your jython) and the code trying to
raise it (Sybase jdbc).

Try the following experiments to see if you get behaviour that is different

1. Try this jython

import java.sql

try:
raise java.sql.SQLWar ning() # known subclass of SQLException
except java.sql.SQLExc eption:
print "Successful ly caught"
else:
print "Big trouble in Little China"

2. Write some similar code to the above in java, raising an SQLWarning
when an object is created, e.g.

TestSubclassExc eptions.java <---------->
import java.sql;

public TestSubclassExc eptions
{
public TestSubclassExc eptions ( )
throws SQLWarning
{
throw new SQLWarning();
}
}
<-------------------------------------->

Making sure that the class definition is on your classpath, instantiate
a TestSubclassExc eptions object inside a jython try..catch as in #1, and
see what happens.

3. Write a version of the above class that raises
com.sybase.jdbc 2.jdbc.SybSQLEx ception instead. Make sure to run this one
from the command line, so that you know that the jython classloader is
the one loading the class and exception definitions.

If you're running inside some form of "enterprise container", you may be
tripping over a classloader issue, where base classes/exceptions are
being loaded by different classloaders, possibly with different security
settings. Solving these problems is almost always a case of finding the
right library directory to put your jython.jar, etc, in. This can
sometimes require extensive documentation delving.

Final sanity check: are you setting the "python.hom e" property if/when
you are embedding jython? There are some minor complexities associated
with caching of "compiled" java packages. These can cause odd behaviour
if you are executing your code from two different execution
environments, e.g. debugging on a command line, and then also running in
a servlet container.

If none of the above sheds any light, please post back with the details
of the software you're using, and the locations in which you've placed
your jython.jar, your sybase jdbc jars, etc.
Problem is that SybSQLException IS subclass of SQLException - verified
by Eclipse IDE (type hierarchy). Similar effects were with jdbc driver
for PostgreSQL.

There's result:
Exc org.postgresql. util.PSQLExcept ion: ERROR: syntax error at or near
"aa"
!= subclass of java.sql.SQLExc eption!

So it's definitely not a Sybase specific problem.

--
alan kennedy
------------------------------------------------------
email alan: http://xhaus.com/contact/alan

[Jan Gregor]

All tests passed ok, but problem is still there. I didn't mentioned that
mysql works fine.

My system is debian, something between woody and testing version. At
home I have similiar debian upgraded moved so far from potato to woody
to sarge - same behaviour.

Application runs from command line by 'jython TextConsole.py' . Jython is
version 2.1, running on java 1.4.2_05 (at home 1.4.1). PostgreSQL
(7.4.3) and jdbc driver (as jython) from debian testing distribution.
Jan

[Alan Kennedy]

[Jan Gregor]

All tests passed ok, but problem is still there. I didn't mentioned that
mysql works fine.

My system is debian, something between woody and testing version. At
home I have similiar debian upgraded moved so far from potato to woody
to sarge - same behaviour.

Application runs from command line by 'jython TextConsole.py' . Jython is
version 2.1, running on java 1.4.2_05 (at home 1.4.1). PostgreSQL
(7.4.3) and jdbc driver (as jython) from debian testing distribution.

I have one more thing to suggest, and that only applies if you are
"embedding" , i.e. calling jython created classes from java, as opposed
to calling java classes from jython.

If you are embedding, then you are initializing the jython runtime
yourself, as opposed to having jython do that for you. In these cases,
names of java packages are not always picked up from the jython package
cache (although the class definitions are picked up if the jar is
present on the classpath).

Try adding a line like this to the top of your jython module

import sys ; sys.add_package ('com.sybase.jd bc2.jdbc')

This can also be done outside jython, in the java embedding environment,
through a PySystemState object, as described here

http://sourceforge.net/mailarchive/f...&forum_id=5586

If that doesn't help, I'm afraid I'll be too busy for the next few days
to help out, though there are other people here who might be able to
contribute.

The day I've been waiting for for 7 years has finally arrived: proof
that the US retail milk supply is contaminated with a bacterium known as
Mycobacterium avium subspecies paratuberculosi s. I expect to be very
busy with this, especially if the US media reacts to the story the same
way that the British and Irish media did. If you see an article on
paratuberculosi s and Crohn's Disease in the media in the next few days,
you'll be happy to know that python is an essential part of the
management of two of the main related web sites: www.crohns.org and
www.paratuberculosis.org

More info on paratuberculosi s in US retail food from

http://www.johnes.org/newsfiles/109216471862392.html

my-world-is-tumbling-ly y'rs

--
alan kennedy
------------------------------------------------------
email alan: http://xhaus.com/contact/alan