[Monetdb-developers] Another Question about use Aqua Datastudio
When I use Aqua Data Studio 4.7 as a SQL client,I must register a database first. If I want to connect a remote server,I must fill in all the blank in the Server Properties . For example:I must fill in the following information Name: Remote-monet-server Type: Production Login Name: monetdb Password:monetdb Datasource: this field I don not know how to write :( Can you tell me how to fill in this field? When I use "MonetDB",I can only connect localhost server, if I want to connetct the remote server, how to write the Datasource? "MonetDB@10.78.90.17" is right??
Davy China
The latest documentation is shown below. I'm trying out version 4.7 to see if there are changes we should know about.
regards, Martin
2.8.1 Aqua Data Studio
Aqua Data Studio is a graphical user interface to interact with MonetDB/SQL. It is available on Windows, Linux, and MacOS platforms from the distribution site. Download the Version 4.5 executable and install the software.
The first step to make Aqua Data Studio aware of MonetDB is to register the database server . Go to the Server->Register Server panel and select the Generic- JDBC RDBMS theme. It requires the following additional field settings:
Name: MonetDB SQL Type: Whatever you want Login Name: monetdb Password: monetdb URL jdbc:monetdb://localhost/database Driver: nl.cwi.monetdb.jdbc.MonetDriver Driver Location: C:\Program Files\CWI\MonetDB\share\MonetDB\lib\monetdb-1.3-jdbc.jar
The location of the JDBC driver under Linux and OSX is by default /usr/share/MonetDB/lib/monetdb-1.3-jdbc.jar.
Once the settings has been completed, start the MonetDB server and try to connect. If necessary extend the heap size of your java engine, e.g. use -Xmx1024M .
china-davy wrote:
When I use Aqua Data Studio 4.7 as a SQL client,I must register a database first. If I want to connect a remote server,I must fill in all the blank in the Server Properties . For example:I must fill in the following information Name: Remote-monet-server Type: Production Login Name: monetdb Password:monetdb Datasource: this field I don not know how to write :( Can you tell me how to fill in this field? When I use "MonetDB",I can only connect localhost server, if I want to connetct the remote server, how to write the Datasource? "MonetDB@10.78.90.17" is right??
Davy China
Downloaded AquaDataStudio 4.7 and installed next to my already running version 4.5 There are no unexpected problems with this setup using MonetDB 4.12.0 on Windows XP here. I have not tried using a client/server machine setup.
Martin Kersten wrote:
The latest documentation is shown below. I'm trying out version 4.7 to see if there are changes we should know about.
regards, Martin
I am using vserion 4.7 as the client,it is runnig on machine-1(say,10.78.90.1),and the server is running on another manchine-2(say,10.78.90.2).Have you tried this ?If I want to connect the MonetDB server via odbc,how to do then ?That is just the question I asked before.
Thank you best regards Davy China
On 16-07-2006 08:11:15 -0700, china-davy wrote:
I am using vserion 4.7 as the client,it is runnig on machine-1(say,10.78.90.1),and the server is running on another manchine-2(say,10.78.90.2).Have you tried this ?If I want to connect the MonetDB server via odbc,how to do then ?That is just the question I asked before.
Unless you have a good reason for that, you should not try to use ODBC from Java. JDBC is the preferred way to access data resources in Java.
ok,you are right.Aqua Datastudio can connect the MonetDB via jdbc,I have tried it ,there is no problem. Let me describe the background of my question I asked before. I have a TPC-C benchmark test program,it is used for testing the performance of a DBMS. I have use this program tested some DBMS(say,ORA,DB2,Postgres,and so on),all the DBMS were connected via the odbc driver,and all these DBMS odbc driver can be configured easily.I only need tell the odbc some connect information,say,destanation host name,database name,login name,and so on. So,I want to connect the remote MonetDB server.That is why i ask so many question about odbc driver and connect to a remote MonetDB server.
Davy China
The author of the ODBC code will definitely look at this discussion tomorrow morning (Dutch Time ;-)) and may give you some more targeted hints.
china-davy wrote:
ok,you are right.Aqua Datastudio can connect the MonetDB via jdbc,I have tried it ,there is no problem. Let me describe the background of my question I asked before. I have a TPC-C benchmark test program,it is used for testing the performance of a DBMS. I have use this program tested some DBMS(say,ORA,DB2,Postgres,and so on),all the DBMS were connected via the odbc driver,and all these DBMS odbc driver can be configured easily.I only need tell the odbc some connect information,say,destanation host name,database name,login name,and so on. So,I want to connect the remote MonetDB server.That is why i ask so many question about odbc driver and connect to a remote MonetDB server.
Davy China
There is currently no way to configure MonetDB/ODBC through a configuration dialog. On the other hand, there would be very little to configure. There is currently only one user (monetdb) with a fixed password (monetdb), and there is only one database available (MonetDB). The only choices you have are the host and the port. The server, by default, only accepts connections from the localhost, and on a fixed port (50000).
However, you can use the SQLDriverConnect function to specify the necessary parameters. E.g.:
SQLDriverConnect(dbc, NULL, "DSN=Monetdb;UID=monetdb;PWD=monetdb;host=10.78.90.17;PORT=50000", SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT);
As to using Aqua Studio, I don't know whether that uses SQLDriverConnect (in which case it might be possible to have it use the above form), or SQLConnect (in which case it is not possible to specify a different host name).
On 2006-07-16 17:32, Martin Kersten wrote:
The author of the ODBC code will definitely look at this discussion tomorrow morning (Dutch Time ;-)) and may give you some more targeted hints.
china-davy wrote:
ok,you are right.Aqua Datastudio can connect the MonetDB via jdbc,I have tried it ,there is no problem. Let me describe the background of my question I asked before. I have a TPC-C benchmark test program,it is used for testing the performance of a DBMS. I have use this program tested some DBMS(say,ORA,DB2,Postgres,and so on),all the DBMS were connected via the odbc driver,and all these DBMS odbc driver can be configured easily.I only need tell the odbc some connect information,say,destanation host name,database name,login name,and so on. So,I want to connect the remote MonetDB server.That is why i ask so many question about odbc driver and connect to a remote MonetDB server.
Davy China
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&da... _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
participants (4)
-
china-davy -
Fabian Groffen -
Martin Kersten -
Sjoerd Mullender