[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=85190

Alex Thurgood  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=99
   ||978

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

--- Comment #44 from Commit Notification 
libreoffice-comm...@lists.freedesktop.org ---
Stephan Bergmann committed a patch related to this issue.
It has been pushed to libreoffice-4-4-0:

http://cgit.freedesktop.org/libreoffice/core/commit/?id=a358461a5c266bec5148f89e7fbb4b4d7d0ce91eh=libreoffice-4-4-0

Related fdo#85190: Don't dress arbitrary Java Throwables as UNO Any values

It will be available in 4.4.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

Commit Notification libreoffice-comm...@lists.freedesktop.org changed:

   What|Removed |Added

 Whiteboard|| target:4.4.0

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

--- Comment #45 from Stephan Bergmann sberg...@redhat.com ---
(In reply to Alex Thurgood from comment #20)
 Console is showing possibly unrelated message with master 4500alpha
 
 dynamic_cast error 2: One or more of the following type_info's  has hidden
 visibility.  They should all have public visibility.   7SdrView,
 12SdrPaintView, 10FmFormView.

(Indeed unrelated, and incidentally addressed now with
http://cgit.freedesktop.org/libreoffice/core/commit/?id=b4f6b26b5a1a78fecfa95ec2eb7ac8b80495d8aa
SAL_DLLPUBLIC_RTTI for proper RTTI visibility for LLVM.)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

--- Comment #46 from Lionel Elie Mamane lio...@mamane.lu ---
(In reply to Stephan Bergmann from comment #43)
 (In reply to Lionel Elie Mamane from comment #42)
   catch (java.lang.IncompatibleClassChangeError e2)
  {
  LOGGER.error(Detected an IncompatibleClassChangeError);
  throw new com.sun.star.lang.WrappedTargetException(e2, caught a  +
  e2.getClass().getName(), this, new
  com.sun.star.uno.Exception(e2.getLocalizedMessage()));
  }
  
  to me looks like it will not work, trying to pass a
  java.lang.IncompatibleClassChangeError through UNO.
 
 No.  In UNO exception ctors, the optional leading Throwable argument ('e2')
 is only used to pass it as 'cause' argument into the underlying
 java.lang.Throwable ctor; it is not passed through UNO.

So it is thrown away when the Java exception is caught by the Java UNO bridge,
and the latter throws a UNO exception to whatever called that Java code through
UNO? I see. Thanks for the explanation.

 Anyway, I improved the message / throwing:
 http://cgit.freedesktop.org/libreoffice/core/commit/
 ?id=f4a2cff16ea546e7d0a135d4b061a65e783ab422

 That commit needlessly removes passing in the 'cause' argument.  Please
 revisit.

Readded in
http://cgit.freedesktop.org/libreoffice/core/commit/?cc376d87859a478b6cab348f0c96ea9fa7fe7a9a

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

--- Comment #39 from Commit Notification 
libreoffice-comm...@lists.freedesktop.org ---
Stephan Bergmann committed a patch related to this issue.
It has been pushed to master:

http://cgit.freedesktop.org/libreoffice/core/commit/?id=01fb1701c8a59dd023604492a117ea1a6cffcee9

Related fdo#85190: Don't dress arbitrary Java Throwables as UNO Any values

It will be available in 4.5.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

Commit Notification libreoffice-comm...@lists.freedesktop.org changed:

   What|Removed |Added

 Whiteboard|| target:4.5.0

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

--- Comment #36 from Alex Thurgood ipla...@yahoo.co.uk ---
(In reply to Lionel Elie Mamane from comment #29)
 With what version did it use to work?

That is a good question, unfortunately, the shift to all 64bit program stack,
including the connector extension, means that I can no longer test.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

Lionel Elie Mamane lio...@mamane.lu changed:

   What|Removed |Added

 Whiteboard| target:4.5.0 target:4.4.1  |

--- Comment #42 from Lionel Elie Mamane lio...@mamane.lu ---
(In reply to Stephan Bergmann from comment #40)
 (In reply to Commit Notification from comment #39)
  http://cgit.freedesktop.org/libreoffice/core/commit/
  ?id=01fb1701c8a59dd023604492a117ea1a6cffcee9
  
  Related fdo#85190: Don't dress arbitrary Java Throwables as UNO Any values
 
 ...addresses the sub-thread of comment 14, comment 31, comment 35

Thanks.

The

 catch (java.lang.IncompatibleClassChangeError e2)
{
LOGGER.error(Detected an IncompatibleClassChangeError);
throw new com.sun.star.lang.WrappedTargetException(e2, caught a  +
e2.getClass().getName(), this, new
com.sun.star.uno.Exception(e2.getLocalizedMessage()));
}

to me looks like it will not work, trying to pass a
java.lang.IncompatibleClassChangeError through UNO.

Anyway, I improved the message / throwing:
http://cgit.freedesktop.org/libreoffice/core/commit/?id=f4a2cff16ea546e7d0a135d4b061a65e783ab422

Feel free to cherry-pick to libreoffice-4-4.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

--- Comment #37 from Alex Thurgood ipla...@yahoo.co.uk ---
(In reply to Alex Thurgood from comment #36)
 (In reply to Lionel Elie Mamane from comment #29)
  With what version did it use to work?
 
 That is a good question, unfortunately, the shift to all 64bit program
 stack, including the connector extension, means that I can no longer test.

All I know is that it did, but that it would have been with an earlier version
of LO (3.x ?) 32bit, native connector 1.01 ?, plus 32bit Java and 32 bit mysql
- too many variables !

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

Commit Notification libreoffice-comm...@lists.freedesktop.org changed:

   What|Removed |Added

 Whiteboard| target:4.5.0   | target:4.5.0 target:4.4.1

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

--- Comment #41 from Commit Notification 
libreoffice-comm...@lists.freedesktop.org ---
Stephan Bergmann committed a patch related to this issue.
It has been pushed to libreoffice-4-4:

http://cgit.freedesktop.org/libreoffice/core/commit/?id=d5ff2e409d450d53ab0bed7cdc3de18841c5c7fbh=libreoffice-4-4

Related fdo#85190: Don't dress arbitrary Java Throwables as UNO Any values

It will be available in 4.4.1.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

--- Comment #40 from Stephan Bergmann sberg...@redhat.com ---
(In reply to Commit Notification from comment #39)
 http://cgit.freedesktop.org/libreoffice/core/commit/
 ?id=01fb1701c8a59dd023604492a117ea1a6cffcee9
 
 Related fdo#85190: Don't dress arbitrary Java Throwables as UNO Any values

...addresses the sub-thread of comment 14, comment 31, comment 35

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

--- Comment #38 from Alex Thurgood ipla...@yahoo.co.uk ---
(In reply to Lionel Elie Mamane from comment #34)
 Created attachment 112603 [details] [review]
 patch to transform zero dates to NULL
 
 Here's a patch to implement replacing zero dates by NULL unconditionally. If
 someone wants to add all the code and UI to make it optional, then we can do
 it.
 
 Else, I'll just consider it as a MySQL bug / misfeature.

This got me wondering how other Java report builders deal with this problem.

After all, they interface with a wide range of different dbs with varying
timestamp definitions. Will try and have a trawl to see what I can dig up.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

--- Comment #43 from Stephan Bergmann sberg...@redhat.com ---
(In reply to Lionel Elie Mamane from comment #42)
  catch (java.lang.IncompatibleClassChangeError e2)
 {
 LOGGER.error(Detected an IncompatibleClassChangeError);
 throw new com.sun.star.lang.WrappedTargetException(e2, caught a  +
 e2.getClass().getName(), this, new
 com.sun.star.uno.Exception(e2.getLocalizedMessage()));
 }
 
 to me looks like it will not work, trying to pass a
 java.lang.IncompatibleClassChangeError through UNO.

No.  In UNO exception ctors, the optional leading Throwable argument ('e2') is
only used to pass it as 'cause' argument into the underlying
java.lang.Throwable ctor; it is not passed through UNO.  What was problematic
about Noel's commit was that UNO exception css.lang.WrappedTargetException
takes a UNO Any argument containing a UNO exception value, and /that/ must not
be an arbitrary Java non-UNO exception (was erroneously 'e2', is now 'new
com.sun.star.uno.Exception(...)').

 Anyway, I improved the message / throwing:
 http://cgit.freedesktop.org/libreoffice/core/commit/
 ?id=f4a2cff16ea546e7d0a135d4b061a65e783ab422

That commit needlessly removes passing in the 'cause' argument.  Please
revisit.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

Lionel Elie Mamane lio...@mamane.lu changed:

   What|Removed |Added

 Status|ASSIGNED|RESOLVED
 Resolution|--- |NOTOURBUG
   Assignee|lio...@mamane.lu|libreoffice-b...@lists.free
   ||desktop.org

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

--- Comment #34 from Lionel Elie Mamane lio...@mamane.lu ---
Created attachment 112603
  -- https://bugs.freedesktop.org/attachment.cgi?id=112603action=edit
patch to transform zero dates to NULL

Here's a patch to implement replacing zero dates by NULL unconditionally. If
someone wants to add all the code and UI to make it optional, then we can do
it.

Else, I'll just consider it as a MySQL bug / misfeature.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 85190] REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=85190

--- Comment #35 from Lionel Elie Mamane lio...@mamane.lu ---
(In reply to Lionel Elie Mamane from comment #31)
 Noel, you cannot stick an arbitrary Java exception into a UNO exception,
 only a UNO exception... It will not pass the UNO barrier to C++. Please
 review your whole commit in this light.
 
 If you want to make that kind of throwing more useful, you can do something
 like:
 
   Writer result = new StringWriter();
   PrintWriter printWriter = new PrintWriter(result);
   e.printStackTrace(printWriter);
 throw new
 com.sun.star.lang.WrappedTargetException(e.toString() + '\n' +
 result.toString(), this, null)

You can also separate the case of catching a UNO exception, and in this case
store the original exception, from the case of an arbitrary Java exception, and
in this case do as above.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs