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!
On Fri, 12 Apr 2002, Colin Bell wrote:
> Hi Caspar,
> I've just tried using the ODBC MySQL driver and it works although it ha=
> 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 a=
> send it to the developers list and I'll try to work out whats happening.
> -----Original Message-----
> From: Caspar Treijtel [mailto:Caspar.Treijtel@...]
> 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, mai=
> > the metadata area. I haven't tried the MySQL ODBC driver as yet but t=
> > http://mmmysql.sourceforge.net/ type 4 JDBC driver works well.
> > What exactly is the problem that you get when trying open a MySQL dat=
> > 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 OD=
> > driver.
> > Col
> > -----Original Message-----
> > From: Caspar Treijtel [mailto:Caspar.Treijtel@...]
> > Sent: Wednesday, 10 April 2002 23:06
> > To: squirrel-sql-develop@...
> > Subject: [Squirrel-sql-develop] Jdbc-Odbc bridge
> > Hi squirrel developers, I have been trying to get the Jdbc-odbc bridg=
> > to work with squirrel but my attempts have failed so far. Has the bri=
> > 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.
> > 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.
> > Thanks in advance,
> > Caspar Treijtel
> > _______________________________________________
> > Squirrel-sql-develop mailing list
> > Squirrel-sql-develop@...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop