Other JDBC driver

Note: please leave bug reports and feature requests on

Other JDBC driver

Postby batch4j » Thu Nov 08, 2012 3:57 pm

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
batch4j
 
Posts: 28
Joined: Tue Oct 30, 2012 2:23 pm

Re: Other JDBC driver

Postby Serge » Thu Nov 08, 2012 5:44 pm

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..
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Other JDBC driver

Postby Bruce_Martin » Thu Nov 08, 2012 10:07 pm

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
Bruce_Martin
 
Posts: 2
Joined: Thu Nov 08, 2012 9:57 pm

Re: Other JDBC driver

Postby batch4j » Mon Nov 12, 2012 8:43 am

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
 
Posts: 28
Joined: Tue Oct 30, 2012 2:23 pm

Re: Other JDBC driver

Postby batch4j » Mon Nov 12, 2012 9:53 am

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
Attachments
dbeaver.driverconfig.zip
Screen for config driver
(14.38 KiB) Downloaded 1347 times
batch4j
 
Posts: 28
Joined: Tue Oct 30, 2012 2:23 pm

Re: Other JDBC driver- version 3.0

Postby batch4j » Wed Nov 14, 2012 10:06 am

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
batch4j
 
Posts: 28
Joined: Tue Oct 30, 2012 2:23 pm

Re: Other JDBC driver

Postby Serge » Thu Nov 15, 2012 9:32 am

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
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Other JDBC driver

Postby Bruce_Martin » Fri Nov 16, 2012 2:41 am

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
Bruce_Martin
 
Posts: 2
Joined: Thu Nov 08, 2012 9:57 pm

Re: Other JDBC driver

Postby batch4j » Fri Nov 16, 2012 1:34 pm

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
 
Posts: 28
Joined: Tue Oct 30, 2012 2:23 pm

Re: Other JDBC driver

Postby batch4j » Mon Dec 10, 2012 11:39 am

Solved,
batch4j
 
Posts: 28
Joined: Tue Oct 30, 2012 2:23 pm


Return to Support



Who is online

Users browsing this forum: Google [Bot] and 4 guests