SQLBase usage in a Java Application

Question

I am trying to connect to a Grupta SQLBase Database via my Java application.

I searched through the web but all I could find is that there is a need of an SQlBaseJDBC jar that works as a bridge but I am unable to download it.

Can you provide any alternatives or a place where I can download this driver? Has someone worked with this driver in the past and can comment on it?

Also, can I use the JdbcToODBC driver provided by sun to connect to this database? Grupta provides a guide where there is the option to connect to their database through an ODBC driver.

Thanks.

Answer 1

SQLBaseJDBC.jar ships with SQLBase as standard ( At least for v12.1 ). You dont need to download it - it will already be in the run-time folder for SQLBase. If you are running SQLBase 9 or v10 you can download a Driver pack here: SQLbase driver Packs v9 or v10 Alternatively connect to SQLBase using ODBC no-problem. What specifically do you want to know.

Answer 2

Mike Rather than give loads of bits here that may not be relevant to you, you may be best to either: 1) Search the old Gupta User Group forum for 'JDBC' or similar here: Old Gupta User Group Forum ( there is about 10 pages of info. relating to this ) OR 2) Search and/or Post on the New Gupta User Group forum here: New Gupta User Group Forum

Note you can't post questions on the Old site, but you can on the New site, if you cant find what you need, and would like to communicate with other Java bodies.

Answer 3

Normally the SQLBaseJDBC.jar is an installation option - you choose to instal it or not when SB is installed. You actually now need an OpenText support contract to be able to download bits like this if it isnt installed already ( I know - they dont make it easy ) . Here is a link to the online SQLBase manual for v9 - See Chapter 9 SQLBase Connectivity v9 , which details where to find it if installed ( it still apllies to v11 - although the driver has been upgraded a lot since then ) and also other info that may be relevant. Alternatively here is a link directly to the driver SQLBase JDBC Driver. I do have a v11 manual detailing lots of JDBC info. , but its not online so can't get it to you here. Or , you can download a trial version of SQLBase 11.7 and get the Documentation and driver here: SQLBase Trial Version with documentation / JDBC driver