RE: [Squirrel-sql-develop] Jdbc-Odbc bridge
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Caspar T. <Cas...@cw...> - 2002-04-12 13:43:48
|
Hi Col Finally I have localized the problem, it turns out that my choice of jvm (the IBM jvm) is rather unfortunate. I can't seem to get the bridge to work with it, whereas with the blackdown jvm it does work. Neither IBM java2 1.3.0 nor 1.3.1 do the trick, I will redirect the problem to IBM. Anyway, thanks for the help, cool application by the way! Greetings=A0Caspar On Fri, 12 Apr 2002, Colin Bell wrote: > Hi Caspar, >=20 > I've just tried using the ODBC MySQL driver and it works although it ha= s > issues with the metadata. I'm using MySQL 3.23.47 with the 2.50.39 ODBC > driver on Windows NT, Sun JDK 1.4.0 and Sun JDK 1.3.1. >=20 > Could you paste the full stack trace from the exception into an email a= nd > send it to the developers list and I'll try to work out whats happening. >=20 > Col >=20 > -----Original Message----- > From: Caspar Treijtel [mailto:Cas...@cw...] > Sent: Thursday, 11 April 2002 18:23 > To: Colin Bell > Subject: RE: [Squirrel-sql-develop] Jdbc-Odbc bridge >=20 >=20 > Hi Col, > Oh sorry, I use squirrel-sql-1.1beta2. The problem is > when I try to connect to the mysql db using the bridge, > I get a nullpointer exception (shown in the log). SQuirreL > suggests that I change my URL, but to my best knowledge > my URL is correct; it is "jdbc:odbc:mysqltest" where > mysqltest is the data source name as listed in ~/.odbc.ini. >=20 > The Mysql odbc driver seems to work, I can get a connection > using the odbctest program in the unixODBC package. > Greetings Caspar >=20 >=20 > On Thu, 11 Apr 2002, Colin Bell wrote: >=20 > > Hi Caspar, > >=20 > > The bridge works although with some issues with different DBMS's, mai= nly > in > > the metadata area. I haven't tried the MySQL ODBC driver as yet but t= he MM > > http://mmmysql.sourceforge.net/ type 4 JDBC driver works well. > >=20 > > What exactly is the problem that you get when trying open a MySQL dat= abase > > via the bridge and which version of SQuirreL are you using? > >=20 > > I'll try to get some time this weekend to have a look at the MySQL OD= BC > > driver. > >=20 > > Col > >=20 > > -----Original Message----- > > From: Caspar Treijtel [mailto:Cas...@cw...] > > Sent: Wednesday, 10 April 2002 23:06 > > To: squ...@li... > > Subject: [Squirrel-sql-develop] Jdbc-Odbc bridge > >=20 > >=20 > > Hi squirrel developers, I have been trying to get the Jdbc-odbc bridg= e > > to work with squirrel but my attempts have failed so far. Has the bri= dge=20 > > been tested? Sun's jdbc-site states it's better to use a native Jdbc=20 > > driver, but I cannot even make a connection using the bridge. > >=20 > > My setup is a 3.23.49 mysql db with (working) Myodbc driver version=20 > > 2.50.39, I use an IBM jvm version 1.3.0. > >=20 > > Thanks in advance, > > Caspar Treijtel > >=20 > >=20 > >=20 > >=20 > >=20 > > _______________________________________________ > > Squirrel-sql-develop mailing list > > Squ...@li... > > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > >=20 >=20 |