Issue 20397 - EnableSQL92Check= passed to the jdbc driver without value
Summary: EnableSQL92Check= passed to the jdbc driver without value
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC5
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-30 01:01 UTC by Unknown
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Trace from the Database server that shows the query strings received (23.78 KB, text/plain)
2003-09-30 01:03 UTC, Unknown
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-09-30 01:01:44 UTC
I am trying to create a DataSource using a proprietary JDBC driver. The problem 
I am encountering is that this driver (or to be more exact theserver side of the 
driver) is rejecting the request to show the tabledefinition because the request 
is malformed.It seems it doesn't like an attribute without a value. Here is the 
trace I get on the server side.  
The attribute EnableSQL92Check doesn't have a value regardless if it is checked 
or not. Note that I am not sure if this is what make it choke. This is a 
proprietary product and like with all of them it takes forever to get a straight 
answer. I am using OpenOffice.org1.1rc4 on Linux with Java 1.4.2-01. I tried with 
Java 1.3.1-09 and OpenOffice.org.1.0.1 just do be sure. 
 
>SQLDriverConnect(0x081e51bc, 
0x0000,"EnableSQL92Check=;UID=root;DSN=CRS;PWD=;AutoIncrementCreation=;",-3, 
0xbfffd348, 256, 0xbfffce54, 0)        >DrmBeginSession("root", "CRS")        
<DrmBeginSession returned 0 (SesID=1)        >DrmSetSessionOption(1, 
SetIniValue, "Catalog,/usr/lib/relativity/RelRM5.00/crs/rm/crs.rcg")        
<DrmSetSessionOption returned 0.        >DrmSetSessionOption(1, SetIniValue, 
"FileMgr,RM")        <DrmSetSessionOption returned 0.        
>DrmOpenDatabase(1, "CRS", DRM_bitDbShared)        >FMInit(081F02E4, 
081F02C8 (Task=0000170C), pErrorCode, pInfoCode)        <FMInit returned 1.        
<DrmOpenDatabase returned 0 (1)        >DrmCloseTable(1, 1)        
<DrmCloseTable returned 0.        >DrmSetTransact(1, DRM_AUTO_COMMIT)        
<DrmSetTransact returned 0.        <SQLDriverConnect returned 1.        
>SQLError(0x081e36dc, 0x081e51bc, 0x00000000, 0x081e4754, 0x081e475c, 
0x081e4760, 511, 0x00000000)          SqlState: "01S00"          NativeError: 0          
ErrorMsg: [Liant][Relativity RM Server]Invalid connection string attribute.        
<SQLError returned 0. 
 
This was copied directly from an email I wrote to the dba.openoffice.org list.  
Frank Schönheit <fs@openoffice.org> then responded 
 
this "EnableSQL92Check=" here in the connection string looks like the root 
cause: It's a parameter used internally in OOo, and it should never be passed to 
the system JDBC driver, but (at most) be evaluated by ourSDBC driver only.
Comment 1 Unknown 2003-09-30 01:03:39 UTC
Created attachment 9813 [details]
Trace from the Database server that shows the query strings received
Comment 2 Frank Schönheit 2003-09-30 08:32:41 UTC
confirming this: though I didn't test it in real life, the code
obviously misses to filter out this setting (and it seems it also
misses to filter all other OOo-specific properties)

fs->oj: is this perhaps automatically covered by the changes you
already did (drivers returning meta information about the supported
settings)?
Comment 3 ocke.janssen 2004-01-29 11:02:20 UTC
Fixed in cws oj08
Comment 4 hans_werner67 2004-02-02 12:47:41 UTC
change subcomponent to 'none'
Comment 5 ocke.janssen 2004-02-02 14:08:03 UTC
.
Comment 6 marc.neumann 2004-02-03 09:50:50 UTC
Hi,

this isn't really fixed. 

The property EnableSQL92Check is not passed anymore, however the property
AutoIncrementCreation is still passed to the driver.

Bye Marc
Comment 7 ocke.janssen 2004-02-10 14:34:47 UTC
fixed yet
Comment 8 ocke.janssen 2004-02-10 14:35:08 UTC
.
Comment 9 marc.neumann 2004-02-25 12:55:26 UTC
set to fixed
Comment 10 marc.neumann 2004-02-25 12:55:51 UTC
verified in CWS oj08
Comment 11 marc.neumann 2004-03-29 12:38:35 UTC
close -> works in src680m33