Retrieving and display *small* Oracle BLOBs in browser....

2002-11-08 Thread Arthur Chan



Hi.
I use JDBC to retrieve an Oracle BLOB of either gif 
or jpg or tif
Some of the BLOBs are fairly big e.g. 
40+KBytes.
However most are smaller, around 
10+KBytes.
I found that I can retrieve and display the "big" 
blobs or write to to a file in a temp dir, but I cannot display the smaller 
blobs.
When I try writing the small blobs to a temp dir, 
the file handle will be created, but the file length is zero !
Can anyone help ???
Any hints, tips, suggestions 
???


Re: Setting SEMNMI etc.

2002-09-30 Thread Arthur Chan

You need both :
A startup script for Oracle and setting the global system parameters.
In /etc/sysctl.conf ,  I set kernel.shmmax=
Hope that helps
- Original Message - 
From: "Robert Monical" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 30, 2002 07:12 PM
Subject: Setting SEMNMI etc.


> Preparing to install Oracle 9i on a new RH 7.2 system.
> 
> The installation guide wants me to set a number of kernel parameters.
> I tells me to write a script to set these at system startup.
> I'm thinking there is a configuration file that contains these initial 
> values but am striking out.
> 
> TIA
> 
> 
> 
> 
> -- 
> redhat-list mailing list
> unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
> https://listman.redhat.com/mailman/listinfo/redhat-list



-- 
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/redhat-list



Re: /tmp/orbit-root ???

2002-09-30 Thread Arthur Chan

There has been quite a lot of discussions about that.
They are default ORBit files, an open source CORBA.

- Original Message -
From: "Robert Monical" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 30, 2002 07:15 PM
Subject: /tmp/orbit-root ???


> This is a new install of Redhat 7.2.
> Installed-subscribed to RHN and let it update overnight.
> Today, working on the Oracle install and see this orbit-root directory in
tmp.
>
> Some of the files cannot be deleted.  Any idea what it is?
>
>
> TIA
>
>
>
>
> --
> redhat-list mailing list
> unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
> https://listman.redhat.com/mailman/listinfo/redhat-list



-- 
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/redhat-list



JAVA accessing BLOBS and CLOBS

2002-09-29 Thread Arthur Chan



Hi All.
A bit out of context here, but this is one of the 
most knowledgeable and helpful forum ...
I have an Oracle table , each row has one CLOB and 
one BLOB.
I have been able to stream documents into and 
out of the BLOB's incl. MS .doc Also I have been able to get the content from 
BLOB and write it to a target directory.However I am having odd problems 
with CLOB, a simple text file. My servlet attempts to read the CLOB and does 
create the output file in the target directory, but does not copy the content 
over. It also returns 0 for clobLength - here is where the troubles start !?! 
Here is the stub-code :...ResultSet clobRS = thisStmt.executeQuery 
("SELECT ATextMsg " +"FROM ... " +"WHERE ... " 
);clobRS.next();// CLOB thisCLOB = ((OracleResultSet) 
clobRS).getCLOB("ATextMsg");int chunkSize = 
thisClob.getChunkSize();System.out.println("chunkSize is " + chunkSize); // 
default us 8132...char [] textBuffer = new char[chunkSize];String 
targetFile = targetDir + "retrieved_" + fileName; File thisFile = new 
File(targetFile); // it does create an empty target file...// read content 
as ASCII (text) content...FileOutputStream thisFileOutputStream = new 
FileOutputStream(thisFile);OutputStreamWriter thisWriter = new 
OutputStreamWriter(thisFileOutputStream);BufferedWriter thisBufferedWriter = 
new BufferedWriter(thisWriter);//long clobLength = thisClob.length(); // 
things go very wrong here, returns length of 0, why 
?!?System.out.println("clobLength is " + clobLength); flush to 
targetFile, but nothing gets copied over due to clobLength=0 ...for 
(position=1; position<=clobLength; position+=chunkSize){ int 
charsRead = thisClob.getChars(position, chunkSize, 
textBuffer);thisBufferedWriter.write(testBuffer);}...Since the 
clobLength is 0, obviously it will not copy from the database CLOB to the 
file.Manually change the clobLength = 8132, recompile and run, then it 
copies some junk to the targetFile, certainly not the textual data in the CLOB 
itself.
The BLOB is fine...Can someone comment on this 
please and if possible, give me a hint on where I might have gone wrong with a 
simple text file ???
 
 
 
 


Re: Is this a virus : "/tmp/orbit-"

2002-09-27 Thread Arthur Chan

There they are again, always with a user's owner.group and filesize 0.
Just because I keep looking over my shoulder to check if anyone's following
me doesn't mean I am paranoided...

- Original Message -
From: "Gordon Messmer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 07:17 PM
Subject: RE: Is this a virus : "/tmp/orbit-"


> On Fri, 2002-09-27 at 10:26, Ward William E DLDN wrote:
> > Gordon, while you're right that it's PROBABLY
> > ORBit (an Open Source CORBA implementation),
> > it seems to me whenever someone asks that question
> > the answer can NEVER be "No".  It's always got
> > to be "YES!", "Possibly" or "Probably not", since
> > most root kits are going to attempt to install
> > some service or device which masquerades as an
> > innocuous, or even required, program.
>
> Good point.  It could be a worm or trojan that creates the files, but I
> haven't heard of one that behaves like ORBit yet.  :)
>
> > He might be able to check RPM to see what he has
> > installed which required ORBit, and see if he's
> > using those programs.  In this case, perhaps
> > he should do an
> >
> > rpm -q ORBit | xargs rpm -q --whatrequires
>
> He'll get better results with:
> rpm -q ORBit --provides | awk '{print $1}' | xargs rpm -q --whatrequires
>
>
>
>
> --
> redhat-list mailing list
> unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
> https://listman.redhat.com/mailman/listinfo/redhat-list



-- 
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/redhat-list



Re: Is this a virus : "/tmp/orbit-"

2002-09-27 Thread Arthur Chan

Hi again.
I have j2sdk, Apache, Tomcat etc talking with one another. I even have JNDI
and ANT installed, but I do not recall installing CORBA.
How did that come about, be fault when installing one of the other packages
?
- Original Message -
From: "Gordon Messmer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 12:13 PM
Subject: Re: Is this a virus : "/tmp/orbit-"


> On Fri, 2002-09-27 at 08:08, Arthur Chan wrote:
> > Hi All.
> > I have these strange sub-dirs in /tmp/orb-
> >   , and in these sub-dirs , hundreds of files names like this :
> > "srwxr-xr-x orb-29348673785".
> > In the /tmp directory itself, many hundreds of files with names
> > similar to this :  "file-fdhfgv878r"
> > Never seen them before, propagate faster than rabbits
> > Is this a virus ?
>
> No.  `rpm -qi ORBit`
>
>
>
> --
> redhat-list mailing list
> unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
> https://listman.redhat.com/mailman/listinfo/redhat-list



-- 
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/redhat-list



Is this a virus : "/tmp/orbit-"

2002-09-27 Thread Arthur Chan



Hi All.
I have these strange sub-dirs in 
/tmp/orb-  , and in these sub-dirs , hundreds of files 
names like this : "srwxr-xr-x orb-29348673785".
In the /tmp directory itself, many hundreds 
of files with names similar to this :  "file-fdhfgv878r"
Never seen them before, propagate faster than 
rabbits
Is this a virus ?
 


Re: From LILO to GRUB

2002-09-12 Thread Arthur Chan

Hi all!
At the moment I have reached my pain barrier, so I do not intend to download
and install any beta software. On the other hand I have heard no complains
about grub.
Anyway here is the download site. Maybe after Christmas, when I plan to
update my kernel...
http://www.gnu.org/software/grub/grub-download.html
Aly is unusually reticent on this.
Cheers.

- Original Message -
From: "Brian Ashe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 12, 2002 10:49 AM
Subject: Re: From LILO to GRUB


> Ted Gervais,
>
> On Thursday September 12, 2002 10:12, Ted Gervais wrote:
> > Do you have to remove LILO now that grub is installed?  Will there be a
> > conflict?
>
> If you mean the /sbin/lilo program and /etc/lilo.conf file, then no, you
don't
> have to remove them.
>
> But grub will overwrite lilo on the MBR.
>
> > And I presume you will have to input all your LILO data in GRUB to get
> > things going?  Or does the installtion process pick up all the LILO
> > information in the transfer process.
>
> Grub actually doesn't require you to edit anything as far as picking up
> kernels. You will need to modify the conf file if you want to change the
menu
> timeout or if you have a particularly strange lilo configuration. But it
will
> pick up your current setup rather well with very few exceptions.
>
> > At 05:31 PM 9/10/2002 -0400, you wrote:
> > >Arthur Chan,
> > >
> > >On Tuesday September 10, 2002 02:43, Arthur Chan wrote:
> > > > Hi All .
> > > > Hi Aly.
> > > > Is there any painless and easy way to move from lilo to grub ???
> > >
> > >Step 1 : Verify grub is installed.
> > > # rpm -q grub
> > >
> > >Step 1a : If not install it from the CDs
> > >
> > >Step 2 : Make it work.
> > > # grub-install /dev/hda
> > >
> > >Done.
> > >
> > >--
> > >Brian Ashe CTO
> > >Dee-Web Software Services, LLC.  [EMAIL PROTECTED]
> > >
> > >
> > >
> > >--
> > >redhat-list mailing list
> > >unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
> > >https://listman.redhat.com/mailman/listinfo/redhat-list
> >
> > ---
> > Ted Gervais,
> > Coldbrook, Nova Scotia, Canada
>
> --
> Brian Ashe CTO
> Dee-Web Software Services, LLC.  [EMAIL PROTECTED]
>
>
>
> --
> redhat-list mailing list
> unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
> https://listman.redhat.com/mailman/listinfo/redhat-list



-- 
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/redhat-list



Need some ideas about configuring gateways and routers (other than buying them)...

2002-09-10 Thread Arthur Chan



Hi all.
I just built a gateway machine : eth0 to DSL 
with NAT and eth1 is internal. 
DSL does forwarding with single static ip supplied 
by ISP. That part is fine.
Now I want to have a firewall on the gateway 
machine, up pops ipchains.rules for input,  output and forwarding. That's 
when issues arise.
Yes, it protects the machines behind the firewall, 
but I seem to lose the ability to browse the net. Mind you, selectively we can 
even telnet/ssh to various sites and vice versa. 
The questions are : 
(1) best way to build a secure firewall 
(relatively speaking) n yet allows users to browse the net - seems 
contradictory ???
(2) are there any other solutions than to 
stick several nic's into the gateway and assign each a different address or 
address range where each range has a different ipchain-scheme for 
input/output/forwarding ???  
 
 


Re: Circular argument installing BIND-9.2.1 over Bind-9.1.0

2002-09-10 Thread Arthur Chan



Okay, many of u may be familiar with this circular 
dependencies >
Bind-9.1.0 requires libdns.so.4  and 
libisc.so.3 , therefore I have to freshen with Bind-utils-9.2.1, this 
won;t work because the so-files are required by 
bind-9.1.0
In a nutshell a circular dependency. Nice ! 
How do I get around that ? Manually removing the objects 
??? 
 

  - Original Message - 
  From: 
  Arthur Chan 
  
  To: [EMAIL PROTECTED] 
  Sent: Tuesday, September 10, 2002 05:12 
  PM
  Subject: Circular argument installing 
  BIND-9.2.1 over Bind-9.1.0
  
  Hi
  I had bind-9.1.0 installed which I want to 
  replace with the downloaded bind-9.2.1 from ISC
  Using "rpm -Uvh bind-9.2.1" I got the error 
  message that it failed dependencies test , missing "libdns.so.5" and 
  "libisc.so.5".
  So I applied "rpm -Uvh bind-utils-9.2.1" and it 
  reported a conflict with existing files from "bind-utils-9.1.0"
  And so it goes on and on.
  Where do I find these fabulous xxx.so files 
  ???
  What's going on 
???


Circular argument installing BIND-9.2.1 over Bind-9.1.0

2002-09-10 Thread Arthur Chan



Hi
I had bind-9.1.0 installed which I want to 
replace with the downloaded bind-9.2.1 from ISC
Using "rpm -Uvh bind-9.2.1" I got the error message 
that it failed dependencies test , missing "libdns.so.5" and 
"libisc.so.5".
So I applied "rpm -Uvh bind-utils-9.2.1" and it 
reported a conflict with existing files from "bind-utils-9.1.0"
And so it goes on and on.
Where do I find these fabulous xxx.so files 
???
What's going on ???


From LILO to GRUB

2002-09-10 Thread Arthur Chan



Hi All .
Hi Aly.
Is there any painless and easy way to move from 
lilo to grub ???


Linux looks for hda, hdb etc when there are none ...

2002-09-10 Thread Arthur Chan



Hi all.
One of my boxes uses SCSI. On the ASUS m/b I 
toggled EIDE h/d off.  This is fine for the 
BIOS on booting up, it fines the Adaptec and proceeds happily. 
However when RH7.1 loads, it starts looking for 
hda, hdb etc when in fact they are sda, sdb etc and RH7.1 throws these 
error messages :
hda : IRQ probe failed (...)
hda : IRQ probe failed (...)
hda : noresponse, resetting drive
hdb : IRQ probe failed (...)
and so on ...
then continues loading successfully.
It is *annoying*, can someone tell me how to get 
rid of these spurious error messages ?


Where to put ipchain-rules ?

2002-09-09 Thread Arthur Chan



Hi
I am unsure where to put my ipchain rules. It is 
also a matter if timing.
As I understand it , on booting RH :
(1) init runs /etc/inittab
(2)  then /etc/rc.d/rc.sysinit
(3) then /etc/rc.d/rc.local
Then at some point in time,  init recognises 
the runlevel and run the links in rc(n).d   e.g. rc2.d which has got 
"S08ipchains" and "S08iptables". I further 
assumed the ascii-order the links appear in will be the order in which they are 
loaded.
What is the best time to fire up my own 
ipchain rules ??? 
If I was running rc2.d, would a link like 
S09ipchains.myrules be a good time ???
The actual rules are in 
/etc/rc.d/init.d/ipchains.myrules


Configuring font with lilo

2002-09-09 Thread Arthur Chan



Hi !
I have this old m/b with integrated graphics 
controller. The box boots to command line and has only the bare RH 
essentials.
The default font is very bad for eyes, so I 
added "VGA=ASK"  to lilo.conf.
On rebooting, I can either specify the listed 
display options (all low-res) or type in "scan", which allows me to choose the 
hi-res options.
However, all the hi-res options have a blue line 
above the blue directory names. When I use "vi", the empty lines have a 
continuous blue underscore ???
Is this a peculiar pronlem with the onboard 
graphics controller or is it lilo ?


Font size (again) at cmd line level ?

2002-09-08 Thread Arthur Chan



Hi.
I know this has been asked before.
I have a RH7.1 box that boots to command line and 
has only the vrey bare essential ie no X11 , Gnome , whatever... 
The font size at command line level is very bad for 
eyes .
Are there any ways that can be changed ? I know the 
onboard AGP can support that ???
THX


DLink DFE-530TX+ on RH7.1 ???

2002-09-07 Thread Arthur Chan



Hi
I usually use Realtek , but this time I picked up 
some DLink TFE-530+ nic's
Seems okay, modules.conf  has the entries eth0 
8139.too and eth1 8139.too
Looks okay on "ifconfig -a", but then when I do a "route" it takes a long time to recognise 
the default route and I don't seem to be able to join the internal 
network.
I remember some talk about DLink not being really 
compatible on earlier versions of RH.
Has anyone been able to make them work of RH7.1 
using 8139.too ???


Does RH7.3 Apache httpd comes with DSO support ?

2002-09-06 Thread Arthur Chan



Hi all !
I am being pre-emptive here.
I am using RH7.1 and have to make Apache-1.3.19-5 
httpd talk with Tomcat 4.0.4 , to this end, I will be using mod_jk!
Does anyone know wether there are any problems with 
this version configuration ???
How do I find out whether my Apache is DSO-enabled 
?
THX


BSD vs Linux ?

2002-08-15 Thread Arthur Chan



Hi !
Recently there was some chat about "real 
Unix".
Was there any seminal comparative studies 
between FreeBSD (or even NetBSD) and Linux ?
BSD has been around a long time.
Why Linux ? Why not BSD ? Drivers ? Platforms and 
chipsets ?
Are there anything one can do with Linux which 
one cannot do with BSD ? 
Does BSD manage kernel memory better and does 
Linux swap more "aggressively" ?
Is there a JVM for BSD ?  Does the Apache 
staple  run on BSD ?
Questions upon questions...
The truth is out there 
somewhere.


Another question about enabling SMP

2002-08-11 Thread Arthur Chan



Hi !
Is there anyway to enable SMP without doing a full 
install again ?
I recall seeing a search engine for the archive 
database, just can't remember where. 
How do I search the archive for the emails 
?
Thx


JNDI portability...

2002-08-02 Thread Arthur Chan



Hi !
I am creating DataSources for Ora 
ConnectionPools (JAVA servlets) and it seems I need to create a "context object" 
first.LDAP was mentioned and appealed to me.Reading up on Oracle, JNDI 
was explicitly recommended.Also, JNDI seems to be used only on J2EE, but I 
have J2SDK standard edtion installed.I take it I need to upgrade to 
J2EE?
Would someone share their experience 
?
thx.