RE: [Squirrel-sql-develop] Jdbc-Odbc bridge

[Colin B. <Col...@as...>]

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
>