Other JDBC driver

[batch4j]

Hi,

do you know it is possible to use HQL o other generic JDBC Driver.

I want ot use http://sourceforge.net/projects/record-editor/ that use HSQL Server

Thanks

[Serge]

Of course, you can use DBeaver with any JDBC driver.
Just use driver manager to define new driver.

However it is not clear how it can it help in case of 3rd party software like RecordEditor..

[Bruce_Martin]

To look at the RecordEditor Database with a product like DBeaver you will need the
1) JDBC Driver HsqlDBMain.jar On Windows, it will probably be in one of
C:\Program Files\RecordEdit\HSQL\lib
C:\Program Files (x86)\RecordEdit\HSQL\lib Windows 7 64 bit

2) The DB connection string will be
jdbc:hsqldb:hsql://localhost/recordedit

[batch4j]

Hi Bruce,

Regards from Spain. My name is Juan P and I receive a great course about "Java and Net".

We like RecordEditor, but we need a tool that could work in a grid with the row. Too we need only a tool to access to several databases and files.

Thanks

JuanP

[batch4j]

Hi Bruce,

I send to you the field that need the dbeaver if it is possible that you config. Please see the attachament.

Serge and Bruce, It could be possible that you use RecordEditor like a predefinided jdbc driver similar to Oracle, Db2 or MySQL.

Thanks in avance

JuanP

[batch4j]

Hi,

I confused about the use of HQL that made RecordEditor. I thougth that you could see the field like a database using JDBC, but I see that the use of HQL is only for parametrization and metadata.

Could be some Big Idea the follwoing features, for a 3.0 version :

. JDBC driver that enable access to file , local and remote using JDBC similar to this non opensource product http://www.hxtt.com/cobol.html, both local or using a Server that send only some rows.

. See using layout a binary field. This could be a plugin from RecordEditor to dbeaver.

Thanks

Juanp

[Serge]

Hi Juan,

DBeaver already has driver configuration for HSQL (I believe you may use "HSQLDDB Server" driver for Recordedit).

I don't think it would be a great idea to add config for all existing in the world JDBC drivers and their modifications. Because there are too many of them (houndreds) and thus driver management will be too confusing. I hope standard HSQLDB driver is enough. You may just copy it's config and make another very similar driver config in DBeaver.

Thanks

[Bruce_Martin]

Seg, what Juan wants is a JDBC Driver to read cobol files. The RecordEditor uses a Database
(i.e. HSQLDB) to store file meta data (ie Field Sales-Qty is a 4 byte big-endian binary integer)
which is used to display File details on the screen (i.e. http://record-editor.sourceforge.net/Record04.htm).
The HSQLDB driver is not much use to him.

Both HsqlDb and H2 have support for Csv Tables, Either could be adapted to use
Cobol Files using JRecord (http://jrecord.sourceforge.net/JRecord04.html#Header_10
- reading Cobol Files using a Cobol copybook).

Not sure what the Demand is though, Most large firms have the money/prefer
comercially supported products

I Could write a Cobol-to-Csv file program for single record files

[batch4j]

Hi Bruce,

Now, I understood recordeditor and the use of HSQL driver.

I have wrong and I think that you use a cobol 4 jdbc mapping similar to made Oracle with files as external tables.

I think that you are correct and most large firms have the money/prefer comercially supported products.

Thanks

JuanP

[batch4j]

Solved,