[opencms-dev] OpenCms + Oracle working together!

[mfoley5 at csc.com.au]

Hi All,

An update on our WebLogic+Oracle+thin driver progress:

Everything has been running as stable as can be, but when we tried to
re-run the setup wizard we hit multiple ORA-01008 "not all variables bound"
errors when importing the workspace.   Research into this continues (sigh).
If anybody can explain why PreparedStatement.setBytes() works but
setBinaryStream() doesn't (this is the change I made) I would be pleased to
hear the explanation.

Regards,
Mark

Mark Foley
__________________________________________________
CSC
212 Northbourne Ave, Braddon, ACT 2612
Ph: +61-2-62468487    Email: mfoley5 at csc.com.au
----------------------------------------------------------------------------------------

This email, including any attachments, is intended only for use by the
addressee(s) and may contain confidential and/or personal information and
may also be the subject of legal privilege. Any personal information
contained in this email is not to be used or disclosed for any purpose
other than the purpose for which you have received it. If you are not the
intended recipient, you must not disclose or use the information contained
in it. In this case, please let me know by return email, delete the message
permanently from your system and destroy any copies.
----------------------------------------------------------------------------------------





mfoley5 at csc.com.au@www.opencms.org on 23/05/2002 07:42:09 PM

Please respond to opencms-dev at www.opencms.org

Sent by:    owner-opencms-dev at www.opencms.org


To:    opencms-dev at opencms.com
cc:
Subject:    [opencms-dev] OpenCms + Oracle working together!

Hi All,

Having beaten my head against non-OpenCms issues with WebLogic and the
Oracle Oci driver for too long I have re-visited the GenericSql option
using the 'thin' driver, and think I have a solution.

It appears the "date/time" issue reported earlier is related to the size of
the byte array passed to the *.setBytes() calls in
com.opencms.file.genericSql.CmsDbAccess.  I gather that the Oracle driver
has a limit of 2000 bytes here and this produces the (misleading) error.

I have replaced setBytes with setBinaryStream and have written a new class
which simply turns the byte array into an Object extending
java.io.InputStream.

I've run through about 5 test cases where the original genericsql fell over
and so far no problem.  Testing continues on WebLogic/Solaris, and I will
be running this later on WebLogic/Win2000 just to make sure.     So far I
have only modified CmsDbAccess, but I suspect it may be necessary to modify
CmsCallableStatement and CmsPreparedStatement as well.

If this is a truly useful change/finding, then I would like comments from
the OpenCms Group, please.       Also, if I have missed something Really
Important, then I'd like to hear that too.

Regards,
Mark

Mark Foley
__________________________________________________
CSC
212 Northbourne Ave, Braddon, ACT 2612
Ph: +61-2-62468487    Email: mfoley5 at csc.com.au
----------------------------------------------------------------------------------------


This email, including any attachments, is intended only for use by the
addressee(s) and may contain confidential and/or personal information and
may also be the subject of legal privilege. Any personal information
contained in this email is not to be used or disclosed for any purpose
other than the purpose for which you have received it. If you are not the
intended recipient, you must not disclose or use the information contained
in it. In this case, please let me know by return email, delete the message
permanently from your system and destroy any copies.
----------------------------------------------------------------------------------------