Thursday, 2009-03-12

*** withdefault has quit IRC01:45
*** pboro has quit IRC01:45
*** withdefault has joined #ingres01:46
*** pboro has joined #ingres01:50
*** pboro__ has joined #ingres02:06
*** pboro has quit IRC02:08
*** toumi01 has quit IRC03:16
*** withdefault has left #ingres03:25
*** rossand has quit IRC05:24
*** pboro__ is now known as pboro05:52
*** Alex|off is now known as Alex|06:12
*** Alex| is now known as Alex|off06:46
*** Alex|off is now known as Alex|06:58
*** withdefault has joined #ingres07:44
*** grantc_offline is now known as grantc07:46
*** ChanServ sets mode: +o withdefault07:48
*** jeremypeel has joined #ingres07:53
Alex|welcome jeremypeel07:53
jeremypeelGood morning all!07:53
Alex|:)07:53
jeremypeelJust installed chat in my Eclipse instance.07:54
Alex|so it works :)07:55
jeremypeelThat is exactly what I was hoping you'd be able to confirm for me. Thanks!07:56
*** jeremypeel has quit IRC08:03
grantcmust resist...08:04
Alex|let it out08:04
grantc:)08:05
*** jeremypeel has joined #ingres08:09
grantc@uk peeps - is it mothering sunday this weekend?08:34
ii_loggrantc: Error: "uk" is not a valid command.08:34
grantc@ uk peeps - is it mothering sunday this weekend?08:34
ii_loggrantc: Error: "uk" is not a valid command.08:34
withdefaultno mothering sunday is 22nd09:45
grantcthanks withdefault09:45
*** toumi01 has joined #ingres10:55
troal01Gah Ingres source code is so cryptic12:41
troal01I love this comment: **This routine does stuff with locations -- I guess it checks them out.12:42
satanmalinhi everyone12:49
satanmalingrantc did you recieved my mail ?12:49
grantcyup12:49
satanmalinwith esy ingres link ?12:49
satanmalinoki12:49
satanmalinwhen you have time tell me what do ya think aboutir12:50
satanmalinabout it12:50
grantcyup i have downloaded it but i want to have a clean machine to install it to12:50
satanmalinoki LOL12:50
grantcI only have one XP box here and I use that to do my builds12:50
grantci cannot risk it being fscked up12:50
satanmalinyep im undesrtand12:51
satanmalinI underestand12:51
satanmalinI hope you 'll like it12:51
grantci have a vm I am trying to update so I can install the demo.12:51
satanmalinI have thought about sth telle me if Im wrong12:51
satanmalinsomething is strange with the demo12:52
satanmalinwhy the index is not the loggin page ?12:52
grantcI cannot answer that12:52
grantcit's based on a C# application - I don't know what the original design decisions where12:53
satanmalinbecause of course evry time i launch the demo i have a 500 error12:53
grantcwere even..12:53
satanmalinof course im not logged in12:53
grantcI did not see that on linux12:53
*** rossand has joined #ingres12:53
*** ChanServ sets mode: +o rossand12:53
satanmalinLOL oki12:54
satanmalinthat was only a quation i wondered12:54
satanmalinquestion12:54
satanmalinny logic the fist page might be the logging page12:55
grantci guess that the first page is the search since that gets you into the application12:55
satanmalinyes but quiet bizare how can you have a result without be logged12:56
satanmalin?12:56
satanmalinLOL12:56
satanmalinbeing12:56
grantcnot really12:57
grantcif apache and ingres are setup correctly you don't need to log in to ingres12:57
grantcdid you modify LocalSettings.php ?12:57
satanmalinnope12:57
grantcthat's your problem12:57
grantcthe application connects to ingres with the "ingres" account12:58
grantcyou either need to add the password for Ingres or change the account it uses (assuming that account has the correct access levels)12:58
satanmalini only yep but bruno told me that people wont agree to have their pasword recoverd to be "displyed into the demo"12:59
grantcthis problem is partly due to the logic the application uses to connect to ingres13:00
grantcif the apache process owner is a valid ingres user you can connect using ingres_connect($database), providing no login/password13:00
satanmalinthats why i thought it was better to have the index on the loggin page13:01
grantci guess you can change that for easy ingres if you wish?13:01
satanmalinIll try13:01
satanmalinwhat do ya think about my idea ?13:01
grantcsounds ok13:01
satanmalinAm i wrong ?13:01
grantcit's up to you13:04
satanmalinill do it (more logical according to myself LOL)13:05
grantcsure13:05
satanmalinsend me a maiil when you have tried easyingres and tell me your opinion ( it counts a lot cause you have supported me and helped me )13:06
*** rossand has quit IRC13:06
grantcok - the machine is now installing 40 patches so I don't know if i will get time today to look at it13:07
satanmalinno problem13:08
grantci need to go cook lunch13:08
satanmalinand a lot of thanks grant13:08
grantcno problem13:08
* grantc slopes off13:08
satanmalindont you have a wife to do it for you ?13:08
satanmalinLOL13:08
grantcyes but she also knows how to use a knife...13:08
satanmalinLOL oki13:09
*** DarylM has joined #ingres13:20
*** rossand has joined #ingres13:23
*** ChanServ sets mode: +o rossand13:23
DarylMmorning(or afternoon).  I have a picture from the EasyIngres install :(    http://files.me.com/monda07/s8rljo13:25
SlimeyPeteyou can get MSVCRT71.dll from various websites for free13:26
DarylMIt is supposed to be a self-contained package13:26
SlimeyPeteif you're desperate to get it working now13:26
SlimeyPeteyeah, so I hear.13:26
DarylMNot desperate.13:27
SlimeyPeteI think satanmalin is the one you need to highlight13:27
SlimeyPete^^ like so :D13:27
DarylMUsing absolutely clean VMs is a great testing strategy.13:27
DarylMMost of us keep so much crud on our systems it affects testing.13:28
* DarylM thinks testing is a variation of Heisenburg ....13:29
Alex|you either know where the bug is or how fast it is but never both at the same time :)13:30
troal01Anyone know what the uleFormat/uleFormatNV function does?13:30
*** mull_ has joined #ingres13:33
*** troal01 has quit IRC14:28
pborooops... pressing ctrl-c while createdb running doesn't seem to be a good idea14:50
*** troal01 has joined #ingres15:44
*** jeremypeel has quit IRC15:47
*** Alex| is now known as Alex|off16:37
*** troal01 has quit IRC16:39
*** troal01 has joined #ingres16:42
*** Alex|off is now known as Alex|16:47
troal01grantc: To build Ingres on Windows, what compilers can I use?16:55
grantcvisual studio 200316:55
troal01That's it? mingw32 won't work?16:56
grantcno16:56
grantcif you want to port the code base to mingw32 feel free16:56
grantcyou can download visual studio express and use that compliler16:57
troal01Will VS 2005 or 2008 work?16:57
troal01Or is it only 200316:57
grantcto be honest I don't know. withdefault might?16:57
grantci know that we will need to use 08 at some point16:58
troal01Is there a good wiki for setting up a build environment in VS 2003?16:59
withdefaultIngres builds on windows is certified with VS 2003, in addition VS 2005 is required if you need to build the .NET components.16:59
withdefaultThere is currently a project to get Ingres to build with VS 200816:59
grantcinternally there might be but it might also be dependant on you using piccolo17:00
troal01I find Viktoriya's wiki but it talks about installing cygwin etc17:02
troal01Found even17:02
grantchttp://wiki.ingres.prv/bin/view/Engineering/Opensauce/GrantsIngWinEnvironment - it might be out of date since i wrote that whilst we were at CA17:04
grantcthe most difficult part is the bootstrap - getting setup17:05
grantconce you have the tools and the code the rest kind of falls in to place...17:06
*** Alex| is now known as Alex|off17:08
troal01grantc: Okay so if I build with VS 2003, why do I need cygwin?17:11
grantcawk/grep/sed etc..17:11
grantcpreviously and perhaps even now we used the MKS toolkit17:12
grantcperhaps we need flex?17:12
troal01Ah so just for tools, not for the compiler17:13
grantcnot for the compiler, no17:13
troal01Okay does Ingres have a license for MKS Toolkit?17:14
troal01Because it's not free software17:14
grantcno you can use cygwin17:14
grantci had a personal copy that i managed to obtain from somewhere...17:15
troal01thepiratebay.org ? :D17:17
grantcyou don't need mks... cygwin will do just fine17:18
bonro011Try this for building on Windows: http://community.ingres.com/wiki/Building_Ingres_On_Windows17:23
troal01Thank you bonro011!17:23
bonro011aah, I got a extra 1 added to my id. :)17:23
*** bonro011 has quit IRC17:24
*** bonro01 has joined #ingres17:24
troal01Ah crap, will Ingres build on Vista 32bit?17:25
bonro01I've never tried it on Vista.17:26
bonro01the build is probably more dependant on the VS2003 compiler, it may work on Vista if you install VS2003 there.17:28
*** DerMeister has joined #ingres17:35
troal01I'll let everyone know how it goes, if it works I'll update the Wiki17:37
withdefaulttroa01, you may need to get the latest service pack for VS 2003 if you intend to try and install on Vista17:47
withdefaultdoh, missed the l, troal0117:48
troal01Alright I'll keep that in mind, thank you withdefault17:49
* troal01 is torrenting VS200317:50
satanmalinIm here17:54
satanmalinwhat is the problem ?17:54
satanmalinsorry i was out17:54
satanmalineh MSVCR71.dll is a System dll18:18
satanmalinhave'nt you a prob with shitdows /18:18
satanmalin?18:18
grantcno - your package must use it but you already have it installed from something elese18:19
SlimeyPeteyeah, it doesn't come installed with Windows18:20
SlimeyPeteit's just that it's quite common so many applications install it for you without you realising18:20
grantcyou can redistribute it but you must follow some rules...18:23
grantcthere is a file called redist.txt that comes with visual studio18:23
satanmalindamned so i have to dl it and to detect where is the system and to copy it into the system32 directory ?18:24
grantcno you can ship it with your application but  you cannot over-write someone else's18:24
grantchttp://msdn.microsoft.com/en-us/library/aa984372(VS.71).aspx18:24
SlimeyPeteyes, or put it in the directory that contains the program which requires it18:24
grantci guess you get it with ingres when you install .net18:25
satanmalinanf what program do i use needs MSVCR ??18:25
satanmalini dont have installes .net18:25
grantcthere may be ingres applications that depend on it.18:25
satanmalinso the simplest way todo is to dl this dll and to copy it where ?18:26
grantcsomewhere in the ingres path18:27
grantcingres\bin i guess18:27
satanmalinoki18:27
DarylMWhy with all the open source stuff do we need a specialized microsoft dll?18:27
grantceh ? it's not specialised18:29
DarylMIf it does not ship with the OS, it is special, IMHO :)18:29
satanmalinmay i take one on my computer to put it in the package ?18:30
grantci don't know, i don't have the redist.txt file to hand18:31
DarylMbeats me.  Why is it needed?18:31
grantcthe vm that will have it is shutdown right now18:31
grantcthe same reason we link to libc on unix18:32
satanmalinIs it possible that this ****ing dll is installes with update ?18:39
SlimeyPeteno.18:40
satanmalinyes installed with the .net framework18:41
SlimeyPeteif you need to figure out where to put it dynamically, you can interrogate the %WINDIR% environment variable to find the Windows directory and then just append '\system\' to that18:42
satanmalinlike a %WINDIR%18:44
satanmalinxcopy ****ing.dll %WINDIR%\system\****ing.dll ?18:45
SlimeyPeteyeah18:45
satanmalinill try it then18:46
satanmalinthe problem i have is that all my machine has still this dll LOL18:46
satanmalinso i think the best way is to install it first18:50
satanmalinand where i can find this dll surely18:50
*** grantc is now known as grantc_offline18:52
SlimeyPetehttp://www.dll-files.com/dllindex/dll-files.shtml?msvcr7118:52
satanmalini was on it18:53
satanmalini dll it on it18:53
satanmalinbut is it sure ?18:53
satanmalinand safe ?18:53
SlimeyPete*shrug* I've used it before. Seems safe enough.18:53
satanmalinoki18:53
satanmalinthabks18:53
*** Alex|off is now known as Alex|18:54
DarylMback from working another problem.18:58
satanmalini listen19:00
*** troal01 has quit IRC19:00
satanmalinwhat is the problem ?19:01
DarylMI was just observing that error message again.  Why does "iisetrex.exe" (an Ingres component) need MSVCR71,dll?  Is the .NET framework now a basic requirement to running Ingres?19:02
satanmalinstrangely when i run the intsll of ingres19:03
satanmalinthe first time with a response file19:03
DarylMDrat.  I forgot to take a snapshot of the VM image before starting19:03
*** troal01 has joined #ingres19:03
satanmalinit absolutely obiged me to install .et19:04
satanmalinobliged it forced me19:04
satanmalini go to lunch ill be back in more or less 30 minutes19:05
satanmalinim back19:40
satanmalinis someone there or am i alone ?19:42
satanmalinDarylM ?19:45
* DarylM is on a conference call19:45
satanmalinok19:46
satanmalinsorry19:46
DerMeisterI'm here but that won't help you much if you have any questions :)19:46
satanmalinLOL19:46
satanmalini; trying to solve the problem19:46
troal01Anyone tried building ingres with the gnuwin32 toolset instead of cygwin?19:47
satanmalinim really dumb19:48
satanmalinIm trying to copy a file that I have not copy my computer19:49
satanmalinDarylM do you have an ftp where i can up the new file ?20:01
satanmalindo you want my mail ? or even my amsn adress?20:02
satanmalinDarylM must I copy this f****in dll in system or system32 ?20:40
DarylMI do not know.  I use Windows only when I get bored pulling my finger nails out.20:42
satanmalinloooooooool20:42
satanmalinDo you have an FTP where i can up the file ?20:47
satanmalinor the source20:47
DarylMhummm20:52
satanmalin600 Mb the source + the file20:56
DarylMyikes.  Don't really want that much.20:58
satanmalinLOL20:58
DarylMI'm exploring a completely different Unix based technique using ISO imagese20:59
DarylMimages*20:59
DarylMand a "loopback" file system mount on Linux and OS/X20:59
satanmalincooool21:00
DarylMThat way no installers are involved.  The only restriction is that the mount point will be a pre-determined place.21:01
DarylMThat is trivial on Mac as the desktop (Finder) always mounts ISO images under /Volumes21:01
DarylMSo, I created /Volumes/EasyIngres (I hope you don't mind reusing the name)21:02
satanmalinThats cool because your doing one of project Idea21:02
satanmalinit was doing it on a stick21:02
*** Alex| is now known as Alex|off21:02
DarylMI did that too.  USB sticks are also mounted under /Volumes21:02
satanmalinyep21:02
satanmalinbut the problem will be on the worst OS21:02
satanmalinwindows21:02
satanmalinso indeed you are doing a easy ingres on linux21:03
DarylMjust use Q:21:03
DarylMlol21:03
satanmalinLOL21:03
* DarylM suddenly remembers Q was a bit of a malevolent figure in Star Trek21:03
satanmalinLOL21:03
satanmalinsatanmalin doesn't know star trek21:04
satanmalinLOL21:04
satanmalinso daryl if your gonna do easyingres on linux i dont have to do it myself LOL21:05
* DarylM picks himself up off the floor and sits back down.21:05
DarylMOS/X is easier; doing that first.  Well of course when paying clients give me a break......21:06
DarylM;)21:06
satanmalin;-)21:06
satanmalinjust as a question I must do it under linux will you be involved in the project with me ?21:06
DarylMSure21:07
satanmalinOS/X they told me that ingres doesnt run under os/x21:07
satanmalin?21:07
satanmalini wont say who told me that21:07
DarylMI have it running right now testing a Java properties system in Eclipse21:07
satanmalinis it new ??21:08
satanmalinor is it sth older than one year ?21:08
DarylMNot particularly.  I started quite some time ago.  Others better able to actually code the nuts and bolts took over and made it work.21:08
DarylMStarted in 200421:09
satanmalini have recompiled the file21:09
satanmalinoki21:09
satanmalinim a new one in the ingres database21:09
DarylMIt is community only.21:09
satanmalin(only this year LOL)21:09
DarylMThere is no "official" production version21:10
satanmalinah oki21:10
satanmalinthe only officials version are on linux and Q: ?21:10
DarylMThere are, in fact, several, uh, issues that would have to be fixed before it could be considered usable21:10
satanmalinoki21:10
satanmalinwhere can I upload the file ?21:11
satanmalinnow21:11
satanmalin?21:11
satanmalinif you wanan test it21:11
satanmalinwanna21:11
DarylMwhich one?21:12
satanmalinthe .exe21:12
satanmalin94.3 Mb21:12
DarylMftp://ftp.ingres.com/incoming/monda0721:12
satanmalinanonymous i supose ?21:13
DarylMyuppers21:13
* DarylM wonders why I typed "yuppers"21:13
satanmalinfor yup21:14
satanmalinand pers beacause its the superlative21:14
satanmalinLOL21:14
satanmalinits yupper yhan yup21:14
satanmalinyupper than yup21:14
satanmalinsatanmalin is really bloody stupid21:14
DarylMFYI I run the 2.6.27.7-53.fc9.i686 linux kernel (Fedora)21:15
satanmalinim connected21:16
satanmalinill send you the file21:17
DarylMgonna take a while at that pace21:18
satanmalinif anything all right in more or less 30 minute youll have the file21:18
satanmalinpace ?21:18
DarylMrate21:18
DarylMspeed21:18
satanmalinoki21:18
DarylMor lack thereof21:18
satanmalinI hope this time it will work21:19
satanmalinand daryl are you an activist of the ingres team (like bruno or stef in France) or are you only a community member21:21
satanmalinbecause bruno gave me a piece of the mail but dont tell me more about you LOL21:21
DarylMActivist21:21
satanmalinoki21:22
satanmalinso like bruno21:22
satanmalin?21:22
DarylMI was a customer for many many years (1989-2001) but now, yes, like Bruno21:22
satanmalinoki so you work for ingres (just to know who is who LOL)21:23
satanmalini; quiet lost21:23
satanmalinLOL21:23
DarylMyes21:23
satanmalinoki21:23
satanmalinthats great21:24
satanmalinthis project makes me love ingres more21:24
satanmalinits really intersting21:24
DarylMCool.21:24
satanmalin1989 ? so when ingres were still CA ?21:24
DarylMIngres was "Ingres Corp."21:25
satanmalin(if i remember what bruno told me)21:25
DarylMCan you say "Back to the Future"?21:25
satanmalinLOL21:25
satanmalina grea movie21:25
satanmalingreat movie21:25
satanmalinBack to the future21:25
DarylMRTI -> Ingres Corp -> Ask Corp -> Computer Associates -> Ingres Corp21:26
DarylM:)21:26
satanmalinoki ill try to remeber it21:26
satanmalinand where are you from are you in the USA ?21:27
satanmalinin the us team21:28
DarylMSuburb of Chicago, IL, USA21:28
satanmalinoki21:28
satanmalin(im not a spy LOL only to know21:29
DarylMI Google very well :)21:29
satanmalindont remember the name LOL21:29
satanmalini have made a mistake between DerMeister and your name LOOOL21:30
DarylMhttp://www.google.com/search?q=Daryl+Monge21:30
satanmalini find a site21:31
satanmalinState of the onion21:31
satanmalinLOL21:31
satanmalinrespect21:31
satanmalinsorry21:31
satanmalini have to call you Monsieur21:31
satanmalinor Mister21:33
satanmalinMe its easy im anonymous on google and anonymous everywhere21:34
DarylMI am a rather odd heritage of French, Italian, and German.  So almost anything works......21:34
satanmalinLOL21:34
satanmalinItalian ?21:34
satanmalinwhere ?21:34
DarylMYup21:34
DarylMCuneo21:34
satanmalinquindi parli italiano ?21:35
DarylMNein21:35
DarylM;)21:35
satanmalineuh ich habe deutsch gelernt aber ich spreche nicht deutsch21:35
satanmalindamned my german is NULL21:36
satanmalinLOL21:36
satanmalinet le francais ?21:36
DarylMMy wife has been (trying) to study Francais21:36
satanmalinLOL21:36
satanmalini tryed to learn english but too hard21:37
DarylMSince the US educational system does not support a 2nd language in the lower grades, it becomes very difficult to learn as an adult.21:37
DarylMWhich is too bad really.21:37
satanmalinwhy does he not support ?21:39
satanmalinlower grade it like the 4th grade ??21:41
DarylMyes21:41
DarylMage 5-11 really21:41
satanmalin(i know thw equivalent in france thanks to south park21:41
satanmalin:(21:41
satanmalinLOL21:41
DarylMhttp://www.southparkstudios.com/guide/1008/21:42
satanmalinyeasssss21:42
satanmalinyou like it ?21:42
DarylMThe World of Warcraft South Park episode was the funnies thing I have seen in many years.21:42
satanmalinYep21:42
satanmalinand the song Live to winn is made by Paul stanley21:43
satanmalinandi have dl the latest episode21:43
satanmalinwich was broadcasted yesterday in the US21:43
DarylMFYI:  Ingres 9.3 windows community edition installed fine without the .NET provider install on a completely fresh Windows system.21:43
satanmalinwho is FY ?21:44
DarylMFor Your Information (FYI)21:44
satanmalinits not a 9.3 i use a 9.221:44
satanmalinsorry21:44
satanmalini saw not a I but a | indeed i saw a pipe21:44
DarylMunlikely that there would be a difference with DLL dependencies21:44
satanmalinthe dile is upped21:45
satanmalinthe fileis yupped21:45
satanmalinupped21:45
satanmalindid you recieve it ?21:47
DarylM98963208 Mar 12 21:45 EasyIngres.exe21:47
satanmalincool21:47
satanmalinif you want the latest south park episode21:48
satanmalinhttp://rapidshare.com/files/208192385/South.Park.S13E01.DSR.XviD-0TV.rar21:48
DarylMWoot 900KBytes/sec download21:48
DarylM(Not south park, Easy Ingres :)21:49
*** satanmalin has quit IRC21:51
*** satanmalin has joined #ingres21:51
satanmalinsorry21:52
satanmalinreset by peer LOL21:52
satanmalinos soemone ther ?21:54
satanmalinor am I offline ?21:54
DarylMYou are offline.  Absolutely none of that came through21:55
* DarylM laughs an evil laugh21:55
satanmalinoki LOL21:55
satanmalinso ill restart LOOOOOOOOL21:55
satanmalinsatanmalin is restarting himslef21:55
satanmalindid you recieved the link for south park ?21:56
DarylMYes.  The new EasyIngres.exe worked perfectly21:56
DarylMI am multitasking as I am currently trying to figure out why my Java properties file containing Ingres JDBC trace settings is not being recognized.21:57
DarylM:(21:57
satanmalincoooooooooooooool21:58
satanmalinUNIX or Windows?22:00
DarylMUnix22:01
DarylMBut Eclipse and Java are pretty platform agnostic22:01
satanmalinah oki thought it was easyingres that broke sth22:01
DarylMI keep Windows carefully isolated in Virtual Machines.22:01
DarylM(Plus I can create as many experiments as I wish)22:02
satanmalinyour right22:02
satanmalinshame on me i have one machine per OS22:02
*** DerMeister has quit IRC22:02
satanmalintwo machine per os sorry22:03
DarylMI currently have 3 client support VMs, EasyIngres, Our new ECM appliance, a Fedora install, A Windows 7 install, and a Ubuntu install22:03
satanmalinWindows 7 ???22:03
satanmalinand how is it ?22:03
DarylMBeta22:03
DarylMDecent.22:03
satanmalinis it really better than vista ?22:03
DarylMI have no direct experience with Vista at all.22:03
satanmalin(i supposed yas worst cant be LOL)22:03
satanmalinoki22:04
satanmalinand how is 7 ?22:04
satanmalincompared to XP22:04
DarylMBut Win7 looks a lot like a Mac22:04
DarylMROFL22:04
satanmalinROFL ?22:04
DarylMA variation of LoL.  Rolling On the Floor Laughing22:04
satanmalinDont forget im a froggy22:04
satanmalinoki22:05
DarylMLike watching South Park is often a ROFL.  ;-)22:05
satanmalinYEP22:05
satanmalin(im watching all the seasons )22:05
satanmalinnot eaxclty watching22:06
satanmalinwathcing for 100 times would be more accurate LOL22:06
DarylMSo am I bleeding edge here with Java or has someone used the jdbc trace properties before?  (ingres.jdbc.trace.log)22:06
pboroI have22:07
pboroit's awful, I only use it as a last resort22:07
DarylMThe trace output is awful, or the mechanisms for setting it up are awful?22:07
DarylM(or both I suppose...)22:07
pborowell... a bit of both :D22:08
DarylMI used to use direct coding because I could get away with it  " d.setTraceLog("Trace.out");"  but I am trying to use a properties file now.22:09
pborois your properties file in the root of your classpath?22:11
DarylMYup.  In fact, I extract a URL from the properties file and that information is loaded fine.22:11
pborobut the driver does still not seem to be recognizing it?22:12
pborowhich version of iijdbc are you using?22:12
DarylMthe latest one from the SVN repository22:12
DarylMJust built it again today :)22:12
DarylMI suppose it could be broken, but it is much more likely I did something wrong22:13
pborohttp://code.ingres.com/ingres/main/src/common/gcf/gcj/ingres/IngConfig.java22:13
pborogetConfig() does loading of the properties file22:13
*** mull_ has quit IRC22:14
DarylMThanks.  saved me the trouble of searching for it22:14
pboroactually getConfig() only initiates it, http://code.ingres.com/ingres/main/src/common/gcf/gcj/util/ConfigFile.java is the real stuff22:15
DarylMMore object oriented programming fun22:16
DarylMA close friend once observed that Java,C++, et.al. made good programmers really great and mediocre programmers really really awful.22:17
pborohehe :D22:17
DarylMFortunately, we have really good developers.22:17
*** mull_ has joined #ingres22:18
pboroI wish iijdbc supported setDatabase method for switching database without explicitly reconnecting with a different jdbc url22:18
DarylMThat would be nice, but it would be a bit out of sync with the general Ingres paradigm of one db per connection.22:19
pboroyeah, but it would fulfill the jdbc specification22:20
pboroand many other requirements that are based on jdbc... :(22:20
withdefaultIf you use -Dingres.jdbc.property_file="property filespec" passed to the runtime you shouldn't need to rely on the file living somewhere in the class path22:20
pborowithdefault, does that take a file path or relative path inside classpath?22:20
withdefaultit can be an absolute file pth22:21
pborook22:21
withdefaultI've never tried a relative path22:21
withdefaultThe output is a bit difficult to follow but it is very informative once you are able to decipher it.22:22
withdefaultI have a python script that parses it into a set of db tables so that you can reconstruct the queries with all the parameters22:22
pboroI've used P6Spy mostly22:24
DarylMThat is pretty cool.  You should publish it on community.ingres.com22:25
pboroDarylM, btw grantc is going to implement database switching to the PHP driver (because it is a requirement by the driver framework or similar)22:26
pboroI don't know how he's going to make it happen, prolly doing disconnect & connect under the hood...22:27
DarylMIt is always good to meet requirements22:27
DarylMDisconn/conn would be the only way22:28
DarylMBut that sounds acceptable to me.22:28
* SlimeyPete wonders what practical purpose that would have22:28
SlimeyPetewe just connect to whichever database suits the query22:29
DarylMCompatibility most likely.  MySQL has "use database;"22:29
SlimeyPeteah, I see22:29
pboroactually... switching the db runtime is not as important as a possibility to give the database name with setDatabaseName instead of the jdbc url22:29
pborothis already would make Crystal Reports work a lot better with iijdbc :)22:30
pboroI guess I could dig up this a bit from PostgreSQL and MySQL jdbc drivers and make a SIR with some sensible ideas22:31
DarylMI am a bit surprised.  I was unaware there was such a facility in the JDBC specification22:31
pboroalso it's silly to require port in the jdbc url22:31
pboroif it is not described, then II7 should be the default22:32
DarylMYou mean like 80 is http, imaps is 993, etc?22:33
pboroyup22:33
DarylMjdbc:ingres: should be II722:33
pborojdbc url for iijdbc always require the user to describe the port, ie. the url must always be jdbc:ingres://host:port/dbname22:34
DarylM(a.k.a port 21071)22:34
DarylMHowever, what does the actual JDBC spec allow?22:34
pborolemme check22:35
pboro"The recommended syntax for a network address specified as part of a subname follows the standard URL naming convention for the subname:" -- "//hostname:port/subsubname"22:36
pborobut there are no restrictions22:37
DarylMURL naming convention would imply the :port is optional22:38
pboroyeah... and that's a common way in jdbc drivers22:38
pborobut the port thing is not a real problem, just a difference from majority of jdbc drivers22:39
satanmalinnow i have to go to sleep my head is killing me and my eyes are burning22:39
satanmalinbe backtomorrow22:39
DarylMbye22:39
pborosetDatabaseName support instead of dbname in the url would be much nicer fix :)22:39
satanmalinsatanmalin be back22:39
satanmalinbye22:40
pborobye satanmalin22:40
satanmalinand thank you daryl22:40
satanmalinby pboro22:40
*** mull_ has quit IRC22:41
*** DarylM has quit IRC22:42
withdefaultDarylM, I have an early attempt on the community wiki - I'll try to get round to publishing the new one.  I used jython stuff from clach04 so you can use jdbc or dbi with the same script.23:03
*** withdefault is now known as notdefault23:08
*** notdefault is now known as withdefault23:54

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!