[porting-issues] [Issue 84506] table database access fail s via jdbc to postgresql
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84506 --- Additional comments from johanhenselma...@openoffice.org Mon May 11 09:01:52 + 2009 --- I just found out what the culprit is: if you try the command as SELECT * FROM public.contacten WHERE ( public.contacten.achternaam LIKE '%ensel%' ) instead of SELECT * FROM public.contacten WHERE ( public.contacten.achternaam LIKE '%ensel%' ) it works. The root of the cause is that the schema catalog is not commented separately in the WHERE clause. The workaround is: In the advanced properties of the database settings, turn off Use schema name in SELECT statements Then there is no schema definition added to the created in the SQL statements and the error is not thrown. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@porting.openoffice.org For additional commands, e-mail: issues-h...@porting.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[porting-issues] [Issue 84506] table database access fail s via jdbc to postgresql
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84506 User fs changed the following: What|Old value |New value Assigned to|fs|dbaneedsconfirm --- Additional comments from f...@openoffice.org Thu May 7 06:13:46 + 2009 --- putting into needs confirmation pool, which scales better than waiting for /me to find the time to look into it ... - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@porting.openoffice.org For additional commands, e-mail: issues-h...@porting.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[porting-issues] [Issue 84506] table database access fail s via jdbc to postgresql
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84506 User pl changed the following: What|Old value |New value Assigned to|macport |fs --- Additional comments from p...@openoffice.org Thu May 7 05:50:44 + 2009 --- @fs: could you please have a look ? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@porting.openoffice.org For additional commands, e-mail: issues-h...@porting.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[porting-issues] [Issue 84506] table database access fail s via jdbc to postgresql
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84506 --- Additional comments from johanhenselma...@openoffice.org Mon Mar 30 09:06:22 + 2009 --- I just tested it on DEV300m45. It reappeared. It was gone during 3.0 and 3.0.1 (OOO300m15), but later updates seem to have managed to resurface this bug. This is what came up in the window, if I clicked more: SQL-status: 42P01 ERROR: missing FROM-clause entry for table public.contacten De SQL-opdracht die deze fout veroorzaakt is: SELECT * FROM public.contacten WHERE ( public.contacten.achternaam LIKE '%ensel%' ) I can send screendumps with the messages messages if you like to. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@porting.openoffice.org For additional commands, e-mail: issues-h...@porting.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[porting-issues] [Issue 84506] table database access fail s via jdbc to postgresql
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84506 User mechtilde changed the following: What|Old value |New value Keywords| |oooqa --- Additional comments from mechti...@openoffice.org Sun Mar 29 19:13:00 + 2009 --- Do you see the problem also in an actuall version? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@porting.openoffice.org For additional commands, e-mail: issues-h...@porting.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[porting-issues] [Issue 84506] table database access fail s via jdbc to postgresql
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84506 --- Additional comments from [EMAIL PROTECTED] Fri Oct 10 09:09:02 + 2008 --- Maybe logging the traffic between OOo and the JDBC driver (http://wiki.services.openoffice.org/wiki/Logging_JDBC_Activity) helps finding out where something goes wrong, or where there are differences between Mac and Windows. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[porting-issues] [Issue 84506] table database access fail s via jdbc to postgresql
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84506 User pl changed the following: What|Old value |New value CC|''|'fs' --- Additional comments from [EMAIL PROTECTED] Wed Oct 8 15:28:26 + 2008 --- @fs: any input on this ? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[porting-issues] [Issue 84506] table database access fail s via jdbc to postgresql
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84506 Issue #|84506 Summary|table database access fails via jdbc to postgresql Component|porting Version|680m239 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|MacOSX Assigned to|macport Reported by|johanhenselmans2 --- Additional comments from [EMAIL PROTECTED] Wed Dec 12 22:29:08 + 2007 --- In 232, carbon version and X11 versions, it is possible to connect to a postgresql database via JDBC. In m239 with aquavlc04 that is partly possible: connecting works, and running queries does also work. However, just looking at a table fails miserably, with the error popup: The data content could not be loaded Syntax error in SQL expression ()OK ()More If you click on the more, an error window with four crosses with Error behind it appears, which all say The data conect could not be loaded. I tested it on m239 on windows, there it works flawlessly. The difference between windows and OS X is perhaps the Java version: 1.5.13 on the mac, 1.6.03 on Windows - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]