[prev in list] [next in list] [prev in thread] [next in thread] 

List:       openoffice-discuss
Subject:    Re: [discuss] Database for OpenOffice
From:       Bernard <bht () actrix ! gen ! nz>
Date:       2002-03-16 8:31:07
Message-ID: pk069u4m48u3h44ij4ueq4jrdhai6jsjj9 () 4ax ! com
[Download RAW message or body]

Hi,

I am very excited about the possibilities shown by the datasources
interface. What this really means is that OpenOffice can directly
compete with MS Office Professional (includes MS Access) without
having to include a DB engine. And the users are getting accustomed to
a GUI frontend to tablees and queries without the hurdle they face
before committing to a "Database product" such as MS Access.

[snip]
> It is almost as big (source code wise) as the whole of OOo if not bigger,
> so I'm not sure how to go about including it. I'm not sure bundling
> something considerbaly smaller yet still quite full featured like
> PostgresQL (licence was also a plus last I looked) would in practice
> considearbly dis-advantage somebody. But I'd personaly much rather have it
> be something even smaller like say hsqldb and just integrate it really
> well...

JDBC looks very attractive and well supported.
hsqldb is open source.
I am sure Sun would not mind going in this direction and all major DB
engines have a JDBC driver.

I am keen to try this but so far I did not succeed.

Would someone please help me to get started with JDBC - I can't
connect to a JDBC datasource that works otherwise.

Is support for 3rd party JDBC drivers already included?
I even tried the JDBC-ODBC bridge with no luck.

The errors and some Info are as follows:

The server is running and I connect to it with other programs ok.

Error is: The connection to the data source "name here" could not be
established. SQL Status S1000 Description "No Java installed"
The path of the jar file with the driver is under Option|Security as a
single entry (locks up if I want to add another one).

I re-installed Java in OpenOffice multiple times.
Found a java.ini file:

[Install]
InstallationPath=.
CPLD=0
AdditionalClasspath=<OFFICE_CLASSDIR>\classes.jar;<OFFICE_CLASSDIR>\sandbox.jar;<OFFIC \
E_CLASSDIR>\ridl.jar;<OFFICE_CLASSDIR>\unoil.jar;<OFFICE_CLASSDIR>\jurt.jar;<OFFICE_CL \
ASSDIR>\juh.jar;<OFFICE_CLASSDIR>\swingall.jar;<OFFICE_CLASSDIR>\java_uno.jar;<OFFICE_CLASSDIR>\xt.jar;<OFFICE_CLASSDIR>\jaxp.jar;
 VerifiedVersion=1.3.1
RequiredVersion=1.3.0
ExcludeVersion=1.1.6 1.1.7b 1.1.7B 1.1.8 1.2.1

[Java]
Home=C:\Program Files\Java\j2re1.4.0
VMType=jre
Version=1.4.0
RuntimeLib=C:\Program Files\Java\j2re1.4.0\bin\hotspot\jvm.dll
SystemClasspath=C:\Program Files\Java\j2re1.4.0\lib\rt.jar;C:\Program
Files\Java\j2re1.4.0\lib\i18n.jar;C:\Program
Files\Java\j2re1.4.0\lib;C:\prog\STOFF\program\classes\classes.jar;C:\prog\STOFF\progr \
am\classes\sandbox.jar;C:\prog\STOFF\program\classes\ridl.jar;C:\prog\STOFF\program\cl \
asses\unoil.jar;C:\prog\STOFF\program\classes\jurt.jar;C:\prog\STOFF\program\classes\j \
uh.jar;C:\prog\STOFF\program\classes\swingall.jar;C:\prog\STOFF\program\classes\java_u \
no.jar;C:\prog\STOFF\program\classes\xt.jar;C:\prog\STOFF\program\classes\jaxp.jar; \
Java=1 JavaScript=1
Applets=1

That all looks quite good but what could be missing?
Is there an easy test to verify Java before I get into the driver
issue?
Any ideas? Many thanks.


I entered the class name "com.mckoi.JDBCDriver" in Data Souce
Administration JDBC tab. Results appear in DataAccess.XML:

   <DataSourceDescription state="replaced" cfg:name="GE2">
    <Bookmarks cfg:element-type="Bookmark"/>
    <DataSourceSettings cfg:element-type="DataSourceSetting">
     <DataSourceSetting cfg:name="CharSet">
      <Value cfg:type="string"/>
     </DataSourceSetting>
     <DataSourceSetting cfg:name="JavaDriverClass">
      <Value cfg:type="string">com.mckoi.JDBCDriver</Value>
     </DataSourceSetting>
    </DataSourceSettings>
    <IsPasswordRequired cfg:type="boolean">true</IsPasswordRequired>
    <LayoutInformation cfg:type="binary" cfg:nullable="false"
cfg:encoding="hex"/>
    <LoginTimeout cfg:type="int">0</LoginTimeout>
    <NumberFormatSettings cfg:type="binary" xsi:null="true"/>
    <Queries cfg:element-type="Query"/>
    <SuppressVersionColumns
cfg:type="boolean">true</SuppressVersionColumns>
    <TableFilter cfg:type="string"
cfg:derivedBy="list">%</TableFilter>
    <TableTypeFilter cfg:type="string" cfg:derivedBy="list"/>
    <Tables cfg:element-type="Table"/>
    <URL cfg:type="string">jdbc:mckoi://localhost:port number
here/</URL>
    <User cfg:type="string">user name here</User>
   </DataSourceDescription>
And the additional classpath shows in the file

user\config\registry\instance\org\openoffice\Office\Java.xml
as follows:

<Java state="modified" cfg:package="org.openoffice.Office"
xmlns="http://openoffice.org/2000/registry/components/Java"
xmlns:cfg="http://openoffice.org/2000/registry/instance"
xmlns:xsi="http://www.w3.org/1999/XMLSchema-instance">
  <VirtualMachine>
   <NetAccess cfg:type="int">0</NetAccess>
   <UserClassPath
cfg:type="string">C:\prog\mckoi\mkjdbc.jar;</UserClassPath>
  </VirtualMachine>
 </Java>


[prev in list] [next in list] [prev in thread] [next in thread]