On 23-06-2009 17:06:42 +0200, Sten Hjelmqvist wrote:

Hi Stefan,

I download "monetdb-1.10-jdbc.jar" from "May2009" and registered it in SQuirrel then I created a alias with : URL: jdbc:monetdb://localhost/demo User:monetdb Pw:monetdb

But I get the following error when I try to login: MonetDB: InvalidCredentialsException:checkCredentials:invalid credentials for user 'monetdb'

Any ideas?

do you also use an mserver from the May 2009 release? If you use an earlier version, use the corresponding driver from http://monetdb.cwi.nl/downloads/Java/Feb2009/

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'" Any ideas? /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

Hi Stefan, It works now. I believe it's cause was a mixup between Java 1.5 and 1.6, I had both versions installed. So, I uninstalled all java and re-installed 1.6. I'm using Pentaho/Kettle and it's built-in Bulk loader for MonetDB. The insert speed is 4000 records/sec. :-) Thanks for your help. /Sten -----Ursprungligt meddelande----- Från: Stefan Manegold [mailto:Stefan.Manegold@cwi.nl] Skickat: den 24 juni 2009 18:32 Till: Communication channel for MonetDB users Ämne: Re: [MonetDB-users] Missing JDBC-driver 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 | ------------------------------------------------------------------------------ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users