Thread: RE: [Squirrel-sql-develop] Jdbc-Odbc bridge
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Colin B. <Col...@as...> - 2002-04-10 23:18:43
|
Hi Caspar, The bridge works although with some issues with different DBMS's, mainly in the metadata area. I haven't tried the MySQL ODBC driver as yet but the MM http://mmmysql.sourceforge.net/ type 4 JDBC driver works well. What exactly is the problem that you get when trying open a MySQL database via the bridge and which version of SQuirreL are you using? I'll try to get some time this weekend to have a look at the MySQL ODBC driver. Col -----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 Hi squirrel developers, I have been trying to get the Jdbc-odbc bridge to work with squirrel but my attempts have failed so far. Has the bridge been tested? Sun's jdbc-site states it's better to use a native Jdbc driver, but I cannot even make a connection using the bridge. My setup is a 3.23.49 mysql db with (working) Myodbc driver version 2.50.39, I use an IBM jvm version 1.3.0. Thanks in advance, Caspar Treijtel _______________________________________________ Squirrel-sql-develop mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop |
From: Colin B. <Col...@as...> - 2002-04-12 01:22:12
|
Hi Caspar, I've just tried using the ODBC MySQL driver and it works although it has 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. Could you paste the full stack trace from the exception into an email and send it to the developers list and I'll try to work out whats happening. Col -----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 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. The Mysql odbc driver seems to work, I can get a connection using the odbctest program in the unixODBC package. Greetings Caspar On Thu, 11 Apr 2002, Colin Bell wrote: > Hi Caspar, > > The bridge works although with some issues with different DBMS's, mainly in > the metadata area. I haven't tried the MySQL ODBC driver as yet but the MM > http://mmmysql.sourceforge.net/ type 4 JDBC driver works well. > > What exactly is the problem that you get when trying open a MySQL database > via the bridge and which version of SQuirreL are you using? > > I'll try to get some time this weekend to have a look at the MySQL ODBC > driver. > > Col > > -----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 > > > Hi squirrel developers, I have been trying to get the Jdbc-odbc bridge > to work with squirrel but my attempts have failed so far. Has the bridge > been tested? Sun's jdbc-site states it's better to use a native Jdbc > driver, but I cannot even make a connection using the bridge. > > My setup is a 3.23.49 mysql db with (working) Myodbc driver version > 2.50.39, I use an IBM jvm version 1.3.0. > > Thanks in advance, > Caspar Treijtel > > > > > > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > |
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 |