*** rossand has quit IRC | 02:04 | |
*** mull__ has joined #ingres | 02:57 | |
*** rossand has joined #ingres | 03:06 | |
*** ChanServ sets mode: +o rossand | 03:06 | |
*** mull__ has quit IRC | 03:31 | |
*** toumi01 has quit IRC | 03:42 | |
*** rossand has quit IRC | 04:31 | |
*** Alex|off is now known as Alex| | 06:09 | |
*** Alex| is now known as Alex|off | 06:54 | |
*** pleemans has joined #ingres | 06:56 | |
*** Alex|off is now known as Alex| | 07:10 | |
*** Gerhard has joined #ingres | 07:46 | |
*** grantc_offline is now known as grantc | 08:03 | |
Alex| | Found terminating message type 27. when type 22. was necessary to complete an incomplete message | 08:20 |
---|---|---|
Alex| | aha... | 08:20 |
Alex| | An internal error prevents further processing of this query. | 08:20 |
Alex| | ... | 08:20 |
pboro | :D | 08:21 |
Alex| | An ADF internal coding error has been detected. <- that one is nice... | 08:21 |
grantc | what'ya doing? | 08:22 |
Alex| | select * from table where id = number | 08:23 |
Alex| | that's all | 08:23 |
grantc | what's in the table? | 08:23 |
Alex| | it's the salesforce account table - about 30-40 columns, many nvarchars, but nothing I would think casues a problem | 08:24 |
Alex| | count(*) works | 08:24 |
Alex| | but select * keeps crashing on two databases/copies | 08:25 |
grantc | I've not seen that table. do you have an offline copy somewhere? | 08:25 |
*** Gerhard has quit IRC | 09:29 | |
pboro | Hmmh... it looks like 9.2 \w p13300 allows certain ingresdates to be inserted into a column even there's a constraint which prohibits them | 10:14 |
pboro | when trying to insert/update from isql the constraint works as it should... time for a test case :) | 10:15 |
*** Alex| is now known as Alex|off | 10:40 | |
*** troal01 has left #ingres | 12:23 | |
*** troal01 has joined #ingres | 12:25 | |
*** toumi01 has joined #ingres | 12:42 | |
*** rossand has joined #ingres | 13:04 | |
*** ChanServ sets mode: +o rossand | 13:04 | |
*** mull__ has joined #ingres | 13:42 | |
*** DarylM has joined #ingres | 14:54 | |
*** pboro has quit IRC | 15:13 | |
*** pboro has joined #ingres | 15:14 | |
troal01 | DarylM: Yes, WoW :) | 15:28 |
DarylM | lol delayed reaction | 15:29 |
*** troal01 has quit IRC | 15:29 | |
*** troal01 has joined #ingres | 15:42 | |
*** pleemans has quit IRC | 15:54 | |
troal01 | Putty on Linux FTW | 16:04 |
*** rossand has quit IRC | 16:07 | |
*** rossand has joined #ingres | 16:08 | |
*** ChanServ sets mode: +o rossand | 16:08 | |
DarylM | Interesting, what does putty give you on LInux that "ssh hostname" does not? | 16:08 |
troal01 | Saves my connection info? :) | 16:09 |
troal01 | It's just like Putty on WIndows... except on Linux heh | 16:09 |
SlimeyPete | it works a little better with Ingres 2.6's standard termcaps than most Linux terminal emulators do (except xterm) | 16:12 |
*** pboro has quit IRC | 16:32 | |
*** pboro has joined #ingres | 16:44 | |
*** DerMeister has joined #ingres | 17:33 | |
*** pboro has quit IRC | 17:46 | |
*** pboro has joined #ingres | 17:51 | |
*** pleemans has joined #ingres | 18:06 | |
*** pboro has quit IRC | 18:21 | |
*** pboro has joined #ingres | 18:36 | |
vikram | troal01, you've heard of gnu 'screen' right? is that what you mean by saves connection info? | 18:45 |
pboro | screen can be used to leave a terminal-based program running on a unix server | 18:52 |
pboro | the program will keep running normally when you disconnect and you will be able to resume it later on | 18:53 |
vikram | well it can be a x11 program too, basically anything that needs to have its parent shell running | 18:56 |
troal01 | Yeah I know of screen, quite useful :) | 18:57 |
pboro | vikram, sure, tho' there's better ways for X programs | 18:58 |
vikram | so i dont get whats deal with using putty on linux? | 18:59 |
pboro | no idea... Putty is nice tho', the idea of graphical user interface is to make things easier :) | 19:00 |
*** pleemans has quit IRC | 19:26 | |
vikram | hmm the day i dont park the car in the garage, and it snows.... | 19:52 |
troal01 | Grats vikram! :P | 19:55 |
troal01 | Hey has anyone here actually used Pentaho with Ingres? | 19:55 |
troal01 | Pentaho Kettle/DI that is | 19:55 |
DarylM | yes | 19:55 |
troal01 | How the heck do I make it work? It keeps refusing my connection | 19:56 |
troal01 | Trying to use the spoon app | 19:56 |
DarylM | yea, cool app. | 19:56 |
troal01 | If it would work :) | 19:57 |
DarylM | Do your other JDBC connections work? SquirrelSQL for example? | 19:57 |
troal01 | How do I test SquirrelSQL? | 19:57 |
DarylM | Nice SQL query tool at http://www.squirrelsql.org/ | 19:57 |
troal01 | yaourt -S squirrel-sql :D | 19:59 |
DarylM | I apparently no longer have Pentaho installed after my experimentation was over. | 19:59 |
troal01 | Maybe it's so smart it knew you were done with it and uninstalled itself! | 19:59 |
DarylM | lol | 19:59 |
DarylM | Could have simply been afraid of me | 19:59 |
troal01 | Hehe! | 20:03 |
troal01 | I suck at Java, do I have to set CLASSPATH to ingres/lib? | 20:09 |
DarylM | Yes | 20:09 |
DarylM | no | 20:09 |
DarylM | $II_SYSTEM/ingres/lib/iijdbc.jar | 20:09 |
DarylM | ;) | 20:10 |
troal01 | Hm | 20:12 |
troal01 | Okay so the squirrel doesn't like me either, what should I put for URL if the DB is on localhost and db name is test? | 20:25 |
troal01 | Okay now I get this: com.ingres.gcf.util.SqlEx: Communications error while establishing connection. | 20:27 |
troal01 | (realized I had to have a proper connection str) | 20:28 |
DarylM | jdbc:ingres://localhost:II7/database | 20:28 |
DarylM | is the default URL style | 20:28 |
troal01 | Yeah got that now, now I have a communications error, same I get from Kettle | 20:28 |
DarylM | OK, this may seem like a dumb question, but the DAS server (iigcd) is running isn't it? | 20:29 |
troal01 | This one: ingres 3384 1 0 10:52 ? 00:00:00 /opt/Ingres/IngresAR/ingres/bin/iigcd AR gcd | 20:31 |
troal01 | ? | 20:31 |
DarylM | Your installation code is AR ? | 20:31 |
troal01 | Yeah, for Arch Linux heh | 20:32 |
DarylM | Then the default port number will be AR7 instead of II7 | 20:32 |
troal01 | Oh duh | 20:32 |
troal01 | god I feel stupid now | 20:32 |
DarylM | Everyone has done that one :) | 20:32 |
troal01 | Okay now it works | 20:33 |
troal01 | I built an Ingres package for Arch Linux so you can yaourt -S ingres , I named it AR instead of II | 20:34 |
troal01 | It came back to bite me in the ass | 20:34 |
troal01 | Thanks DarylM :) | 20:34 |
DarylM | I use a different installation ID all the time to keep things straight. | 20:34 |
*** DerMeister has quit IRC | 21:59 | |
troal01 | Hey DarylM did you ever get an error while trying to create a repository in Spoon? It tries to create a column varchar with 2 million characters | 22:04 |
DarylM | Can't remember exactly; I was definitely connecting to existing databases. | 22:31 |
DarylM | troal01: I was using it to migrate mysql databases to Ingres ;) | 22:31 |
troal01 | Hmm interesting, What version? | 22:32 |
DarylM | Not sure. I have a $HOME/.pentaho folder with a .vercheck file containing versionchk.PDI.3.0.3.0569 | 22:34 |
DarylM | Don't know if that means anything...... | 22:34 |
troal01 | Yeah, that's 3.0 I'm trying out 3.1 | 22:40 |
troal01 | Which part of it is actually used to migrate stuff? I'm trying to use spoon.sh but it needs me to create a repos and it fails | 22:42 |
troal01 | I'll try to get 3.0 instead, maybe 3.1 has issues with Ingres | 22:46 |
DarylM | I found these tools to be rather cool, but not at all obvious to the beginner | 22:47 |
troal01 | I agree, but I know I've done it right up until this point... When you see SQL using a varchar(2000000) you know something is wrong :P | 22:49 |
troal01 | No way in hell Ingres would let that through | 22:49 |
DarylM | Question: Why would anyone want varchar(2000000)? ANSWER: To hold the average politicians speech. | 22:50 |
troal01 | rofl | 22:50 |
DarylM | pwd | 22:50 |
troal01 | Meh does same thing with 3.0 | 22:54 |
*** DarylM has quit IRC | 23:34 | |
*** rossand has quit IRC | 23:37 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!