Slumber and variables Take 2

1 view
Skip to first unread message

Poarman

unread,
May 1, 2008, 4:13:13 PM5/1/08
to Sleep Developers
Hi Raph and Andreas,

Raph has it right as to what I am trying to do and it sounds like I
had it right that I would need to pack and or unpack. Actually the
code I had been trying to write is in a small test program included
in
the zip I uploaded called dbload.sl. And for you Raph, a question
about $ and % and @. When passing % to a function I should receive
it
in $ in the function. reason for the question I wrapped writeObject
in a function but seemed to have some issues serializing and de-
serializing to disk. made a separate wrapper for $, %, and @ and
that
seemed to fix the issue but should I have to do that? I should have
kept my problem code so as to show you what I was doing so you could
show me my silly mistakes but I have alerady changed so much getting
back to it is not possible(. Thanks for your time and Have a GREAT
weekend guys!


later,
poarman.

Andreas Ravnestad

unread,
May 1, 2008, 4:33:33 PM5/1/08
to sleep-de...@googlegroups.com
On 5/1/08, Poarman <pou...@twcny.rr.com> wrote:
>
> Hi Raph and Andreas,
>
> Raph has it right as to what I am trying to do and it sounds like I
> had it right that I would need to pack and or unpack. Actually the
> code I had been trying to write is in a small test program included
> in
> the zip I uploaded called dbload.sl.

Hi! Hmm, I can't seem to find that zip in my archives, could you
re-upload or give a link?

-Andreas

Poarman

unread,
May 2, 2008, 11:52:25 AM5/2/08
to Sleep Developers
Hi Andreas,

Sorry, the zip file is java.zip on this forum. the example sleep
script that shows what I am trying to do is dbload.sl. How is schoool
going? Done for the semester yet? Have a GREAT day!

later,
poarman.

On May 1, 4:33 pm, "Andreas Ravnestad" <andreas.ravnes...@gmail.com>
wrote:

Andreas Ravnestad

unread,
May 2, 2008, 11:58:00 AM5/2/08
to sleep-de...@googlegroups.com
Ah, you uploaded it to the google group :) Ok got it! I'll take a look
right away.

-Andreas

Poarman

unread,
May 29, 2008, 2:08:34 PM5/29/08
to Sleep Developers
Cool, thx. Also, with the array returning fetch calls, is there any
way of getting the column names from the function. I had been using
the function that returns a hash which gives me a way of getting the
column names. I am now ussing the function that returns a 2
dimensional array (I believe). I know that it is at least a one
dimensional array. this is so I can easily populate a JTable. The
problem is that so far I have had to populate the JTable using
hardcoded column headers which means I have to know column names,
number, and order versus doing it all on the run. I can upload my
code and will try to tonight. Have a GREAT day!

later,
poarman

On May 2, 11:58 am, "Andreas Ravnestad" <andreas.ravnes...@gmail.com>
wrote:
> Ah, you uploaded it to the google group :) Ok got it! I'll take a look
> right away.
>
> -Andreas
>
> On 5/2/08, Poarman <pour...@twcny.rr.com> wrote:
>
>
>
>
>
> >  Hi Andreas,
>
> >  Sorry, the zip file is java.zip on this forum.  the example sleep
> >  script that shows what I am trying to do is dbload.sl.  How is schoool
> >  going?  Done for the semester yet?  Have a GREAT day!
>
> >  later,
> >  poarman.
>
> >  On May 1, 4:33 pm, "Andreas Ravnestad" <andreas.ravnes...@gmail.com>
> >  wrote:
>
> > > On 5/1/08, Poarman <pour...@twcny.rr.com> wrote:
>
> >  > >  Hi Raph and Andreas,
>
> >  > >  Raph has it right as to what I am trying to do and it sounds like I
> >  > >  had it right that I would need to pack and or unpack.  Actually the
> >  > >  code I had been trying to write is in a small test program included
> >  > >  in
> >  > >  the zip I uploaded called dbload.sl.
>
> >  > Hi! Hmm, I can't seem to find that zip in my archives, could you
> >  > re-upload or give a link?
>
> >  > -Andreas- Hide quoted text -
>
> - Show quoted text -

Poarman

unread,
Jul 15, 2008, 1:40:58 PM7/15/08
to Sleep Developers
Hi Andreas,

Had an issue with slumber apparently exiting somewhere. Using
debug(15) I would see dBupdate( ...); Then dbAssign( ... ); Then
sleep xexited. I had error handlers in place that should have
provided feedback, but nothing. The sql statement being executed
successfully updated the db. The only problem being that the sql
statement was the first of many and only the first statement would
execute. I then took the sql statements generated, wrote them to a
file, then executed them through sqlplus and they all executed fine.
As soon as I get a chance, I will try to go through the slumber code
looking for exits. Have a GREAT day!

later,
poarman
> > - Show quoted text -- Hide quoted text -

Poarman

unread,
Jul 17, 2008, 9:48:06 AM7/17/08
to Sleep Developers
Found the issue. helps if you don't clobber a result set you are
cycling through by using the same handle to try to do db updates.
learned that once, but student forgot the lesson. oh well, maybe I
will not make that mistake again. Have a GREAT day!

later,
marty.

PS, also, with the array returning fetch calls, is there any
way of getting the column names from the function. I had been using
the function that returns a hash which gives me a way of getting the
column names. I am now using the function dbFetchBufferedArray (I
beleive) that returns a 2
dimensional array (I believe). This is so I can easily populate a
JTable. The
problem is that so far I have had to populate the JTable using
hardcoded column headers which means I have to know column names,
number, and order versus doing it all on the run. Dou you think I
should do a table describe each time or what? Trying to build a
generic minimalistic db viewer)
Reply all
Reply to author
Forward
0 new messages