[dba-issues] [Issue 80803] postgresql sdbc driver 0.7 .4 does not work with build OOG680_m1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80803 --- Additional comments from [EMAIL PROTECTED] Wed Sep 12 00:09:15 + 2007 --- I'm having no luck with postgresql-sdbc-0.7.5.zip with OpenOffice.org 2.3 Release Candidate 2 (build OOG680_m4) either. After I install the extension using the extensions manager, there is no entry for the Postgres sdbc driver in the "Connect to an existing database" list when I first open Base. I deleted my prefs in my Application Data folder, and have reinstalled again, but the problem persists. Maybe I should try on another computer. - 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]
[dba-issues] [Issue 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=78988
--- Additional comments from [EMAIL PROTECTED] Fri Aug 24 20:55:45 +
2007 ---
CAST ( expression AS type )
CAST ( '2005-08-20' AS Date )
is valid ANSI SQL.
to_date('2005-08-20','-MM-DD') may also be valid SQL.
The brace format {D '2006-01-01' } being generated by OpenOffice is not valid
SQL.
-
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]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User eeka1234 changed the following: What|Old value |New value Status|CLOSED|REOPENED Resolution|FIXED | --- Additional comments from [EMAIL PROTECTED] Fri Aug 24 00:21:35 + 2007 --- A per database or per form setting to address this issue is not ideal. If the software can't be made smart enough to figure out when a field is NOT NULL with a default value, it would be much better if the check could be disabled per field instead of per form or per database. It's perfectly reasonable for a database to have some fields that are specified as NOT NULL with a default value and have other fields which are specified as NOT NULL with no default value. - 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]
[dba-issues] [Issue 80803] postgresql sdbc driver 0.7 .4 does not work with build OOG680_m1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80803 --- Additional comments from [EMAIL PROTECTED] Thu Aug 23 21:49:49 + 2007 --- How can the 0.7.4a driver work on Windows when there are no .dll files in the zip archive? It seems pretty clear that you are not using the 0.7.4a driver from the website. So which driver are you using? - 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]
[dba-issues] [Issue 80803] postgresql sdbc driver 0.7 .4 does not work with build OOG680_m1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80803 --- Additional comments from [EMAIL PROTECTED] Sat Aug 18 06:23:53 + 2007 --- By the way, if I expand the entry for the 0.7.4a driver in the Extensions Manger, there is only 1 file: DataAccess.xcu There are no .dll files listed. - 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]
[dba-issues] [Issue 80803] postgresql sdbc driver 0.7 .4 does not work with build OOG680_m1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80803 --- Additional comments from [EMAIL PROTECTED] Sat Aug 18 06:21:45 + 2007 --- The platform column for postgresql-sdbc-0.7.4a.zip says "ONLY Linux x86". It does not list Windows. But I just tried it anyway per your recommendation. I get the same exact error. - 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]
[dba-issues] [Issue 80803] postgresql sdbc driver 0.7 .4 does not work with build OOG680_m1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80803 Issue #|80803 Summary|postgresql sdbc driver 0.7.4 does not work with build |OOG680_m1 Component|Database access Version|680m100 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|eeka1234 --- Additional comments from [EMAIL PROTECTED] Sat Aug 18 05:31:15 + 2007 --- The latest postgresql sdbc driver (v 0.7.4) that I see at http://dba.openoffice.org/drivers/postgresql/index.html doesn't work with OOo-Dev 2.3 Developer Snapshot (build OOG680_m1) I open my OpenOffice Base document with a Postgres table that works fine in OpenOffice 2.2.0 Tools->Extension Manager... Add... Choose the file postgresql-sdbc-0.7.4.zip Click "Close" Double click on my Postgres table Enter in my password Click OK I then receive the following error message: The connection to the data source "New Sample Database2" could not be established. SQL Status: HY000 The connection to the external data source could not be established. No SDBC driver was found for the given URL. A connection for the following URL was requested: sdbc:postgresql:dbname=mydb host=myhost.foo.edu One thing I noticed is that no TCP connection is even initiated. The connection works fine in the same document with OpenOffice 2.2.0 - 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]
[dba-issues] [Issue 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 --- Additional comments from [EMAIL PROTECTED] Fri Jun 29 23:25:41 + 2007 --- This is Open Office 2.1 running on Windows XP with postgresql SDBC Driver 0.7.4 connecting to Postgres 8.2 running on Red Hat Enterprise Linux 5.0 - 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]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 --- Additional comments from [EMAIL PROTECTED] Fri Jun 29 19:52:31 + 2007 --- This is Open Office 2.1 running on Windows XP with postgresql SDBC Driver 0.7.4 connecting to Postgres 8.2 running on Red Hat Enterprise Linux 5.0 - 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]
[dba-issues] [Issue 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 --- Additional comments from [EMAIL PROTECTED] Fri Jun 29 02:21:56 + 2007 --- According to the Mimer SQL-2003 Validator at http://developer.mimer.com/validator/parser200x/index.tml, the query being generated by OpenOffice Base is not valid SQL-2003 either. - 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]
[dba-issues] [Issue 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=78988
--- Additional comments from [EMAIL PROTECTED] Fri Jun 29 02:18:02 +
2007 ---
The SQL-99 Validator at http://developer.mimer.com/validator/parser99/index.tml
says that the SQL generated by OpenOffice
SELECT * FROM "public"."yaf" WHERE ( ( "event_date" > {D '2006-01-01' } ) )
is not valid SQL 99. So maybe the problem is entirely with OpenOffice Base
generating invalid SQL, and not with the Postgres driver specifically.
-
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]
[dba-issues] [Issue 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=78988
Issue #|78988
Summary|Date queries add braces around dates, causing an error
Component|Database access
Version|OOo 2.2.1
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|jbu
Reported by|eeka1234
--- Additional comments from [EMAIL PROTECTED] Fri Jun 29 01:54:15 +
2007 ---
Postgres or the Postgres driver doesn't like the braces that are added around
dates when making a query in query Design View.
In OpenOffice.org Base, if I create a query in Design View
with a criteria such as
> '2007-01-01'
for a date field, when I try to execute the query I get the following error:
Error code: 1
pq_driver: [PGRES_FATAL_ERROR]ERROR: syntax error at or near "{" at character
55
(caused by statement 'SELECT * FROM "public"."yaf" WHERE ( ( "event_date" > {D
'2006-01-01' } ) )')
If I go in and edit the SQL by hand by changing the query to 'SELECT * FROM
"public"."yaf" WHERE ( ( "event_date" > '2006-01-01' ) )') the query works okay.
-
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]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 Issue #|78987 Summary|Can't insert records with NOT NULL fields with DEFAULT | values Component|Database access Version|OOo 2.2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|jbu Reported by|eeka1234 --- Additional comments from [EMAIL PROTECTED] Fri Jun 29 01:29:21 + 2007 --- I have a field in PostgreSQL 8.2 of the type timestamptz with a Default Value of now() I also have the field set to NOT NULL This is the exact defintion: creation_timestamp timestamp with time zoneNOT NULLDEFAULT now(), I cannot create a form that will allow me to succesfully insert a record. I get this message: Error writing data to database Input required in field "creation_timestamp". Please enter a value. I have experimented setting the control to Read-Only: Yes and Empty string is NULL: Yes, but I still get the error. If I remove the NOT NULL from the field's table definition, I can insert records as desired and the field is populated with now() on the server... but I would prefer to be able to keep the NOT NULL constraint. - 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]
