JDBC unwrapping doesn't work about pyjnius

[tito]

Hi,

Ok, i didn't tried the example, but a fast research on the internet show that DriverManager.getConnection(url) return a Connection from java.sql.Connection on which the method prepareOlapStatement doesn't exist. What you need is an OlapConnection.

The difference here is that we guess the type from the signature. DriverManager.getConnection have no indication about the OlapConnection. And since you don't declare the type of the variable... You need to cast.

Try:

connection = DriverManager.getConnection(url)
connection = cast('org.olap4j.OlapConnection', connection)
result = connection.prepareOlapStatement(mdx).executeQuery()

This might work, not tested. Try and report here :)

[apalala]

I think that the problem is that Jnius handles objects returned from Java as JavaObject instead of registering their class an returning a proper JavaClass descendant instance.

I'm sorry I have so much to say, and so little time to contribute right now.

[tito]

Can you do a "print connection" and give the result ?

[tito]

Try to:

connection = DriverManager.getConnection(url)
print 'before', connection
connection = cast(OlapConnection, connection)
print 'after', connection

[imd]

OK, the Jython worked by a fluke; the equivalent Java wasn't correct.