February 2008 - users-list

[MonetDB-users] Accessing MonetDB with MAL through JBDC
by Michael 06 Feb '08

06 Feb '08

Hi folks, I just installed MonetDB. I tried to run the simplest examples and failed. :-( The MAL Reference does not semm really helpful though to me. My questions is, is it possible to use the DB as an embedded server with a Java application? The exampled displayed a C example only. Is it possible to communicate to the server with MAL? I want to write a backend for the Apache Directory Server. I want MonetDB to be it. I want to transform LDAP requests to MAL and get results back form the server. Is this possible at all with this DB? FYI: I am a C illiterate Mike -- <NO> OOXML - Say NO To Microsoft Office broken standard http://www.noooxml.org

5 10

Re: [MonetDB-users] (MonetWeb) monetweb/Docs manual.texi, Stable_2008-02-03, 1.37.2.3, 1.37.2.4
by Martin Kersten 04 Feb '08

04 Feb '08

This is not good and a remnant of Peter's attempt to get the Xquery stuff in. I did not have the time to correct it in a way that all intended results are available. Stefan Manegold wrote: > Update of /ufs/monet/repository/monetweb/Docs > In directory corona.ins.cwi.nl:/tmp/cvs-serv22830/Docs > > Modified Files: > Tag: Stable_2008-02-03 > manual.texi > Log Message: > > since I do not know, whether all these .texi files are supposed to exist, > or whether the reference to them are just legacy, > I (try to) comment them out, > to hope fully get (at least) a tiny step further with building the web site ... > > XQuery/Apache.texi > XQuery/POSIX.texi > XQuery/Windows.texi > XQuery/intro.texi > XQuery/Overview.texi > XQuery/DocMgmt.texi > XQuery/ListDoc.texi > XQuery/AddDoc.texi > XQuery/DelDoc.texi > XQuery/DocOther.texi > XQuery/Xquery.texi > XQuery/Functions.texi > XQuery/xrpc.texi > XQuery/FAQ.texi > > > Index: manual.texi > =================================================================== > RCS file: /ufs/monet/repository/monetweb/Docs/manual.texi,v > retrieving revision 1.37.2.3 > retrieving revision 1.37.2.4 > diff -u -d -r1.37.2.3 -r1.37.2.4 > --- manual.texi 4 Feb 2008 17:58:15 -0000 1.37.2.3 > +++ manual.texi 4 Feb 2008 18:21:05 -0000 1.37.2.4 > @@ -258,14 +258,15 @@ > @include MonetDB/iSQL-Viewer.texi > > @node Apache Configuration, CGI Interface, iSQL-Viewer, Client Interfaces > +@c @include XQuery/Apache.texi > @include XQuery/Security.texi > > @node CGI Interface, POSIX Interface, Apache Configuration, Client Interfaces > @include XQuery/CGI.texi > @node POSIX Interface, Windows Interface, CGI Interface, Client Interfaces > -@include XQuery/POSIX.texi > +@c @include XQuery/POSIX.texi > @node Windows Interface , SQL Reference, POSIX Interface, Client Interfaces > -@include XQuery/Windows.texi > +@c @include XQuery/Windows.texi > > @c ---------------------- SQL PART > @node SQL Reference, SQL Core, Windows Interface , Top > @@ -286,13 +287,13 @@ > > @node XQuery Reference, XQuery Overview, External Functions , Top > @chapter XQuery > -@include XQuery/intro.texi > +@c @include XQuery/intro.texi > > @node XQuery Overview, Database Scaleability, XQuery Reference , XQuery Reference > -@include XQuery/Overview.texi > +@c @include XQuery/Overview.texi > > @node Document Management, Document Collection, Pathfinder Project,XQuery Reference > -@include XQuery/DocMgmt.texi > +@c @include XQuery/DocMgmt.texi > @menu > * Document Collection:: > * Add Document:: > @@ -302,20 +303,20 @@ > @end menu > > @node Document Collection , Add Document, Document Management, Document Management > -@include XQuery/ListDoc.texi > +@c @include XQuery/ListDoc.texi > @node Add Document, Remove Document, Document Collection, Document Management > -@include XQuery/AddDoc.texi > +@c @include XQuery/AddDoc.texi > @node Remove Document, Cache Policy, Add Document, Document Management > -@include XQuery/DelDoc.texi > +@c @include XQuery/DelDoc.texi > @node Cache Policy, Miscellaneous, Remove Document, Document Management > @include XQuery/Cache.texi > @node Miscellaneous, Supported Functions, Cache Policy, Document Management > -@include XQuery/DocOther.texi > +@c @include XQuery/DocOther.texi > > @node Supported Functions, Prepared Queries , Miscellaneous , XQuery Reference > @section Supported Functions > -@include XQuery/Xquery.texi > -@include XQuery/Functions.texi > +@c @include XQuery/Xquery.texi > +@c @include XQuery/Functions.texi > > @node Prepared Queries, StandOff Extensions , Supported Functions ,XQuery Reference > @include XQuery/PreparedQueries.texi > @@ -325,10 +326,10 @@ > @include XQuery/Standoff.texi > > @node XRPC Extention, XQuery FAQ, Why StandOff Extensions?, XQuery Reference > -@include XQuery/xrpc.texi > +@c @include XQuery/xrpc.texi > > @node XQuery FAQ, Design Overview, SOAP Protocol, Top > -@include XQuery/FAQ.texi > +@c @include XQuery/FAQ.texi > > @c ---------------------- MAL Design PART > > >

1 0

[MonetDB-users] embedded SQL server under Windows
by Grigorio V. Moshkin 04 Feb '08

04 Feb '08

Hi, I've installed MonetDB/SQL/32bit under Windows, but I can't find DLL or LIB for embedded server. Although, MonetDB documentation mentioned embedded libraries for UNIX-like system: http://monetdb.cwi.nl/projects/monetdb/MonetDB/Documentation/A-Simple-Examp… But, what about Windows? Can I use MonetDB under Windows in embedded mode?

6 12

[MonetDB-users] MonetDB - backup, restore, transaction logs?
by Артур Суилин 04 Feb '08

04 Feb '08

I have a questions regarding MonetDB readiness for 24h per day production server usage: 1. Does it have any method for online (hot) full backup? Manual says about database dumps via mclient. Are they intended only for database transporation? Can I perform online backup via dump? What about data modifications/uncommited transactions during dump? 2. What about incremental backups? It seems MonetDB have some kind of transaction logs? How can I use them? 3. Does it have any defence against unexpected server crash? Manual says that checkpoint/recovery facility exists, but still not completely implemented/tested? 4. In the case of server crash and database corruption - how can I return database to consistent state? Does it have any tool like myisamchk for MySQL? Thank you. -- Arthur Suilin

1 0

[MonetDB-users] How to reset the password for a DB Insatnce
by sateesh 01 Feb '08

01 Feb '08

Hi All, How can i reset the password for a given DB Instance. Some how the default password monetdb is not getting accepted.. Thanks Sateesh -- View this message in context: http://www.nabble.com/How-to-reset-the-password-for-a-DB-Insatnce-tp1519457… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] JDBC Driver Problem with the new Build..
by sateesh 01 Feb '08

01 Feb '08

HI All, We got the latest build and the JDBC Driver seems to be giving lot of problems.. When i try to view the tables for a given schema it doesn't show any even if there are tables. ( if i execute a select query it returns the results..) Also when i execute a query i am getting the following Error after the results.. [ERROR] Exception in ResultSet for "MYSCHEMA" java.sql.SQLException: Method not implemented yet, sorry! at nl.cwi.monetdb.jdbc.MonetResultSet.getCharacterStream(MonetResultSet.java:294) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.quantum.util.proxy.ProxyFactory$InvocationHandlerImpl.invoke(ProxyFactory.java:37) at $Proxy3.getCharacterStream(Unknown Source) at com.quantum.sql.SQLStandardResultSetResults.getStringFromCharacterSteam(SQLStandardResultSetResults.java:250) at com.quantum.sql.SQLStandardResultSetResults.parseResultSet(SQLStandardResultSetResults.java:147) at com.quantum.sql.SQLStandardResultSetResults.create(SQLStandardResultSetResults.java:69) at com.quantum.sql.MultiSQLServer.execute(MultiSQLServer.java:139) at com.quantum.sql.MultiSQLServer.execute(MultiSQLServer.java:91) at com.quantum.actions.BaseExecuteAction.getSQLResults(BaseExecuteAction.java:202) at com.quantum.actions.BaseExecuteAction.execute(BaseExecuteAction.java:174) at com.quantum.actions.ExecuteAction.execute(ExecuteAction.java:98) at com.quantum.actions.BaseExecuteAction.execute(BaseExecuteAction.java:125) at com.quantum.actions.BaseExecuteAction.run(BaseExecuteAction.java:111) at org.eclipse.ui.actions.BaseSelectionListenerAction.runWithEvent(BaseSelectionListenerAction.java:168) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490) at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:443) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1101) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3319) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2971) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:153) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:504) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:443) at org.eclipse.equinox.launcher.Main.run(Main.java:1169) [/ERROR] thanks sateesh -- View this message in context: http://www.nabble.com/JDBC-Driver-Problem-with-the-new-Build..-tp15205660p1… Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

[MonetDB-users] Running multiple mserver5 processes, Merovingian port allocation
by McKennirey.Matthew 01 Feb '08

01 Feb '08

2 1