freelanceprogrammers.org Forum Index » Java

View previous topic :: View next topic

java threads & oracle database --problem

kingshuk_c Posted: Sun Feb 10, 2002 8:10 pm

Joined: 10 Feb 2002

Posts: 15

java threads & oracle database --problem

Hi , I tried concurrent access to a Oracle
database using the same connection object and ran into
some errors as java.sql.SQLException Bigger Type
Length Than Maximum java.sql.SQLException Bigger
Protocol Violation java.sql.SQLException Not in
Streaming Mode You can simulate the problem by
say having two threads say T1 and T2 you start
T1 and T2 simultaneously and execute say 12
queries from both T1 and T2. Use the same connection
object for T1 and T2. you will get the above
errors. If you can solve the problem plz post it
. thanks kingshuk etc.

mcconnell_stephen Posted: Mon Feb 11, 2002 11:21 pm

Joined: 01 Feb 2002

Posts: 73

java threads & oracle database --problem

Is your Oracle Database on a big server that your
company is paying for or the Oracle Personal edition that
you can download for free? If it is the
personal edition, then you can`t have concurrent access
(at least that is what I was told...) Stephen
McConnell

kingshuk_c Posted: Wed Feb 13, 2002 6:53 pm

Joined: 10 Feb 2002

Posts: 15

java threads & oracle database --problem

Hi there ! I am using oracle 8i
enterprise edition which is a licensed version. It does not
have this concurrent access problem... as u say
it.. can there be any other problem
... kingshuk

mcconnell_stephen Posted: Wed Feb 13, 2002 8:27 pm

Joined: 01 Feb 2002

Posts: 73

java threads & oracle database --problem

The only time I have had the concurrency problem
with a licensed version of Oracle 8i was when we were
using the Connection Manager to pass the connection
through a firewall. Unbeknown to us, client had set up
the max number of concurrent connections to 8 in the
configuration. They swore the problem was our code; and we
debugged this for three weeks. I checked out the OTN
(Oracle Technology Network) and low and behold they
described the problem and the solution. The client
was a little red-faced; and a little put out at
having to pay for the hours of debugging that THEY had
caused. I did check and the Personal edition limits the
number of current connections, also. But, that`s why the
call it the Personal edition... it`s for developers to
test with. Letting developers download it is a great
way for them to get to know Oracle (IBM does this
with DB2/UDB, also). If developers learn a DB, then
they are likely to recommend it to clients (because
they are familiar with it). Most developers are not
aquainted with the license costs... They just want to
CODE!!! Stephen McConnell <a href=http://www.crosslogic.com
target=new>http://www.crosslogic.com</a>

freelanceprogrammers.org Forum Index » Java

All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help