On Wed, Jun 24, 2009 at 06:03:41PM +0200, Sten Hjelmqvist wrote:
Hi Stefan, Disregard my previous mail. I think I answered the wrong thread :-)
The mclient.bat runs without any problems. The problem is when I want to connect to the server with SQuirrel or Pentaho/Kettle using a JDBC-driver.
However, I have created a database and I'm loading data into it from a ETL-tool called JitterBit and querying it from a ODBC-client called WinSQL. It works fine with small data sets but JitterBit runs out of memory when I try to load millions of rows.
So, I would rather use SQuirrel and Pentaho/Kettle but they both require JDBC. That I cannot connect to Kettle surprises me because Kettle has it's own MonetDB-driver. I even created a new schema (vi) and new user (vi) with password (vi). But still I get the message " MonetDB: InvalidCredentialsException:checkCredentials:invalid credentials for user 'vi'"
Does this happen with "our" MonetDB JDBC driver or with Kettel's own MonetDB-driver? In the former case, are both your server and client from the latest May2009 version of MonetDB? In the latter case, it could be that Kettel's own MonetDB-driver does not yet support the May2009 version of MonetDB. In this version, the protocol between client and server has changed slightly, which means you cannot use an old client with a new server; cf., http://monetdb.cwi.nl/projects/monetdb/Development/Releases/May2009/index.ht... (I actually was not aware that Kettle come with it's own MonetDB-driver --- good to know ... ;-))
Any ideas?
Not apart from the above ones --- maybe Fabian (our JDBC expert) does, or can guide you to get some more logging/debugging output to localize the problem ... Fabian will react as soon as he has time ... Stefan
/Sten
-----Ursprungligt meddelande----- Från: Stefan Manegold [mailto:Stefan.Manegold@cwi.nl] Skickat: den 23 juni 2009 14:08 Till: Communication channel for MonetDB users Ämne: Re: [MonetDB-users] Missing JDBC-driver
Hi Sten,
being platform-independedn by definition and design, the JDBC driver and client are not in any binary MonetDB package/installer.
You can download the *.jar files via the MonetDB web site from the MonetDB download area, i.e.,
http://monetdb.cwi.nl/ -> "Download" http://monetdb.cwi.nl/Download/ -> "Download area" http://monetdb.cwi.nl/downloads/ -> "Java/" http://monetdb.cwi.nl/downloads/Java/ -> "May2009/"
or directly from
http://monetdb.cwi.nl/downloads/Java/May2009/
Documentation of the JDBC interface can be found at http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/JDBC-Client.html#JD...
Hope this helps.
Stefan
On Tue, Jun 23, 2009 at 12:07:15PM +0200, Sten Hjelmqvist wrote:
Hello,
I've downloaded MonetDB5-SQL-Installer-i386-20090530.msi http://monetdb.cwi.nl/downloads/Windows/May2009/MonetDB5-SQL-Installer-i386-... for windows. However there was no JDBC-driver in the package. After some searching on Google I found one called "jdbcclient.jar".
But I still cannot connect to the database as I get a error message saying that the "demo"-database does not exist.
What am I missing?
Thanks in advance.
---------------------------------------
Sten Hjelmqvist
DataKonsult
MERdata AB
Sveavägen 33, 111 34 Stockholm
Mobil : 0708 305616
E-mejl : sten.hjelmqvist@merdata.se mailto:sten.hjelmqist@merdata.se
Webb : www.merdata.se http://www.main.se/
---------------------------------------
------------------------------------------------------------------------------ Are you an open source citizen? Join us for the Open Source Bridge conference! Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250. Need another reason to go? 24-hour hacker lounge. Register today! http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.o... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
------------------------------------------------------------------------------ Are you an open source citizen? Join us for the Open Source Bridge conference! Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250. Need another reason to go? 24-hour hacker lounge. Register today! http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.o... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |