'Re: [discuss] Database for OpenOffice'

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

List:       openoffice-discuss
Subject:    Re: [discuss] Database for OpenOffice
From:       Hermann Kienlein <hermann () kienlein ! com>
Date:       2002-03-17 8:37:10
Message-ID: 3C9455B6.E1918C61 () kienlein ! com
[Download RAW message or body]

Hi Bernard,

Bernard schrieb:
> 
> 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.

take a look at http://dba.openoffice.org/#howto , how to connect to
mysql via jdbc

> 
> 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;<OFF \
> ICE_CLASSDIR>\ridl.jar;<OFFICE_CLASSDIR>\unoil.jar;<OFFICE_CLASSDIR>\jurt.jar;<OFFIC \
> E_CLASSDIR>\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\pro \
> gram\classes\sandbox.jar;C:\prog\STOFF\program\classes\ridl.jar;C:\prog\STOFF\progra \
> m\classes\unoil.jar;C:\prog\STOFF\program\classes\jurt.jar;C:\prog\STOFF\program\cla \
> sses\juh.jar;C:\prog\STOFF\program\classes\swingall.jar;C:\prog\STOFF\program\classe \
> s\java_uno.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?

I miss the Classpath-setting for your JDBC-Driver class like:
C:\prog\mckoi\mkjdbc.jar;

> Is there an easy test to verify Java before I get into the driver
> issue?

take jvmsetup.exe in your program-directory of OOo, like:
C:\prog\STOFF\program\jvmsetup.exe 

> Any ideas? Many thanks.
> 
> I entered the class name "com.mckoi.JDBCDriver" in Data Souce
> Administration JDBC tab. Results appear in DataAccess.XML:

bevore you have to put the right classpath to you JDBC-Driver class as I
mentioned before.
 
> 
> <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>
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: discuss-unsubscribe@openoffice.org
> For additional commands, e-mail: discuss-help@openoffice.org


-- 
mfg
Hermann Kienlein
---------------------------------------------------------
EDV-Systeme Kienlein GdbR           FON:   +49-9184-80040
Pfarrer-Zinckel-Str. 10             FAX:   +49-9184-80041
D-92364 Deining               email: hermann@kienlein.com
                http://www.kienlein.com       
=========================================================


[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic