July 2009 - users-list

[MonetDB-users] merovingian/vaultkey
by dariuszs 14 Jul '09

14 Jul '09

Hi, How do I set vaultkey? Thanks. Dariusz.

2 4

[MonetDB-users] pcre.lib vs. pcred.lib
by Alex Bo. 13 Jul '09

13 Jul '09

Hi, I have built PCRE on windows with CMAKE as instructed by your documentation. Installing PCRE as instructed results in a "pcred.lib" file in the lib directory, and no "pcre.lib" file. When I try to build the MonetDB5 module, I get an linker error that pcre.lib wasn't found (even though I pointed the nmake command to pcred.lib with the LIB_PCRE flag). Why is it looking for pcre.lib if I defined pcred.lib in LIB_PCRE? What do I need to do to get PCRE and Monet work together on Windows? … [View More]

2 1

[MonetDB-users] Server only runs on machine it was built on.
by Alex Bo. 13 Jul '09

13 Jul '09

Hi, I successfully built the May2009 SP on Windows from CVS. However, when I copy the files and run MSQLserver.bat on other machines, I get the following error from the server which fails to start: #WARNING: LoaderException:loadLibrary:Loading errorThe application has failed to start because its side-by-side configuration is incorrect. Please see the appli cation event log for more detail. .pcre #WARNING: LoaderException:loadLibrary:Loading errorThe application has failed to start because … [View More]

1 0

[MonetDB-users] select count(*) not understood by squirrelsql
by Franck Routier 13 Jul '09

13 Jul '09

Hi, using squirrelsql to access Monetdb (so, via jdbc), the tool fails to display the result for select count(*) from table; Instead it will display <Other>. On the metadata tab, it says the result is seen as culumnType = 1111, columnTypeName = wrd Issuing the same command in montdb command line display the result. Any idea ? Franck

3 6

[MonetDB-users] mserver5/ubuntu crash
by dariuszs 12 Jul '09

12 Jul '09

Hi, mserver5 crashed on ubuntu 64bit while running this query select count(*) from table1 where c1 like 'New Y%'; root@monetdb:~# mserver5 --dbinit="include sql;" # MonetDB server v5.12.0, based on kernel v1.30.0 # Serving database 'svnp', using 8 threads # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved # Visit http://monetdb.cwi.nl/ for further information #… [View More]

3 5

[MonetDB-users] sql module of May2009 SP doesn't compile on windows
by Alex Bo. 12 Jul '09

12 Jul '09

Hi, When building the sql module of MonetDB May2009 SP from CVS on Windows, I get the following compilation errors: sql_gencode.c .\..\..\..\..\src\backends\monet5\sql_gencode.mx(1027) : error C2065: 'leftjoinR ef' : undeclared identifier .\..\..\..\..\src\backends\monet5\sql_gencode.mx(1027) : warning C4047: 'functio n' : 'char *' differs in levels of indirection from 'int' .\..\..\..\..\src\backends\monet5\sql_gencode.mx(1027) : warning C4024: 'newStmt 2' : different types for formal and … [View More]

2 6

[MonetDB-users] Is monetDB nativeXML or not?
by Mtekel 10 Jul '09

10 Jul '09

Hello, I have a question, whether MonetDB/XQuery is native XML database or not. To clarify what is native or not, http://en.wikipedia.org/wiki/XML_database : " Two major classes of XML database exist: XML-enabled: these map all XML to a traditional database (such as a relational database), accepting XML as input and rendering XML as output. This term implies that the database does the conversion itself (as opposed to relying on middleware). Native XML (NXD): the internal model of such … [View More]

3 2

[MonetDB-users] Jdbc error
by Franck Routier 08 Jul '09

08 Jul '09

Hi, I am trying to populate a table using jdbc and CloverETL, but I get the following message : Caused by: java.sql.SQLException: SQLException:sql.prepare:wrong argument for prepared statement (expected decimal instead of decimal) So, Monetdb is expecting decimal, but gets ... decimal :-) What can be the problem ? Thanks, Franck

2 4

Re: [MonetDB-users] PCRE
by idf＠synctrading.com 04 Jul '09

04 Jul '09

I can't get much to work on windows version of MonetDB. It is terribly documented. On Sat Jul 4 8:39 , 'Alex Bo.' <alex.bodinner(a)gmail.com> sent: > >Hi, > >I am trying to build the new May2009 SP from CVS on Windows64, however, >building the MonetDB5 module fails because of pcre. >I built pcre successfully, and have it in 'C:\PCRE'. Then I added >'LIBPCRE=C:\PCRE' and 'PCRE_LIBS=C:\PCRE\lib\pcre.lib' to my nmake command, >but I get the following errors: … [View More]

1 0

[MonetDB-users] PCRE
by Alex Bo. 04 Jul '09

04 Jul '09

Hi, I am trying to build the new May2009 SP from CVS on Windows64, however, building the MonetDB5 module fails because of pcre. I built pcre successfully, and have it in 'C:\PCRE'. Then I added 'LIBPCRE=C:\PCRE' and 'PCRE_LIBS=C:\PCRE\lib\pcre.lib' to my nmake command, but I get the following errors: Creating library lib_pcre.lib and object lib_pcre.exp pcre.obj : error LNK2019: unresolved external symbol __imp__pcre_compile referen ced in function _pcre_compile_wrap pcre.obj : error … [View More]

1 0