Issue 3332 - my jdbc-driver crashes oo641b
Summary: my jdbc-driver crashes oo641b
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 641
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords: needhelp
Depends on:
Blocks:
 
Reported: 2002-03-04 22:45 UTC by Unknown
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
experimental jdbc/http/perl-dbi jdbc driver (75.22 KB, application/octet-stream)
2002-03-04 22:48 UTC, Unknown 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-03-04 22:45:33 UTC 
hi!

for reading data from mysql-databases i have started to write a (very experimental) jdbc-
driver, which connects to mysql-databases via http and a server-side perl/cgi-script. the 
reason, why i started this project is, that webspace-providers usually don't allow direct 
access to mysql-databases. the driver already works with the isql database client 
(isql.sf.net).

you can test my driver (jdbchttp.jar) with the following 
parameters:

JDBC-Driver-Class:  net.nfrese.jdbchttp.DriverImpl

URL:  
jdbc:http:pldbi:www.scheinwelt.at/cgi-
bin/testjdbcgate/jdbcgate.cgi#DBI:mysql:dynlinks

user: test
passwd: 
testpw

as soon as i execute a sql-query like 'select * from linktab' oo641c crashes 
with:

"an unrevoverable error has occured..."

it seems, that openoffice has problems 
displaying the resultset. 

i know that my jdbc-implementation is still very simple and 
buggy, but it should not crash openoffice... ;-)

norbert
Comment 1 Unknown 2002-03-04 22:48:23 UTC 
Created attachment 1147 [details]
experimental jdbc/http/perl-dbi jdbc driver
Comment 2 marc.neumann 2002-03-05 08:40:20 UTC 
I can't reproduced this problem, but some other problems with this
driver. Saying with other words, I have found some problems(crashes)
with a driver which doesn't implement all functions correct.

So it's more a general problem. The dba component expected that all
works correct, but sometimes it isn't ;-).
Comment 3 Unknown 2002-03-05 11:16:37 UTC 
oh! openoffice is not a good jdbc-driver debugging suite? ;-)

you are right. my 
driver does not implement all functions correctly yet (it's about one week old). 
there are lots of things missing... the problem is, that every jdbc-client behaves 
differently and i only want to implement the 'really necessary' subset of the jdbc-
functions.

it would help to see more verbous error-messages than 
'unrecoverable error...'. i'd like to know where the crash happens. but maybe i'm 
spoilt with the comforts of java-exception handling... ;-
)

greetings

norbert
Comment 4 Frank Schönheit 2002-09-25 14:21:53 UTC 
adding "needhelp" keyword - perhaps external developers do want to
have a look at this?
Comment 5 ocke.janssen 2002-10-10 14:25:07 UTC 
Hi,

I made the code a little bit more error tolerant so that we should GPF
now. The problem with your driver is that it doesn't support
PreparedStatements. Another points is the DatabaseMetaData.getColumns
method which should return something.

Best regards,
Ocke
Comment 6 hans_werner67 2004-02-02 12:53:22 UTC 
change subcomponent to 'none'
Comment 7 ocke.janssen 2004-02-10 11:07:28 UTC 
closed