Sitemap

Amicuk Programming Answers

JDBC ODBC bridge connections using 2.1.1

-0001-11-30   Views:0

Advertisement

Hi, I have reviewed a lot of postings related to JDBC and third party drivers and understand how to connect to the packaged drivers such as MySQL and MS SQL Server/Sybase. Where I'm stuck is the reference in the Connections help to JDBC. We have a OD

Hi,
I have reviewed a lot of postings related to JDBC and third party drivers and understand how to connect to the packaged drivers such as MySQL and MS SQL Server/Sybase. Where I'm stuck is the reference in the Connections help to JDBC. We have a ODBC system DSN that's not part of the existing JDBC drivers. The help implies it's possible to create a JDBC:ODBC bridge connection and that JDBC:ODBC bridge functionality is part of the JDK therefore should not require additional jar files. However, the JDBC tab is not an available connection type by default. I traced the JDBC ODBC bridge to the rt.jar and tried adding that to the third party extensions but that has not resulted in the JDBC tab becoming available.
Is the JDBC tab only available when using commercial JDBC ODBC bridge drivers ?
For all other connections (DB2, TimesTen, Teradata etc) the help is very specific about which jar files you need and any other requirements but the JDBC section it is unclear how you enable JDBC connectivity.
Thanks
Steven
Edited by: slisint on 14-Jan-2011 18:07

The replay answer
Advertisement
We are using the JDBC-ODBC bridge to do a prepared
statement. I have seen other bugs that suggest this
is problematic with older version of JRE, but was
supposedly fixed in later versions.
java.sql.SQLException: General errorIf it is not too late, check the following link:
http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/GettingStartedTOC.fm.html
Sections 6.1.3 and 8 (especially tables at the end).
I had the same case, and the problem was that the field in the Oracle database was defined as NUMBER(4), witch is equivalent to INTEGER in JDBC types, and function setInt should be used with INTEGER, instead of setLong.
This is explained in sections I mentioned.

Go to See the other 3 answers

JDBC ODBC bridge connections using 2.1.1

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have reviewed a lot of postings related to JDBC and third party drivers and understand how to connect to the packaged drivers such as MySQL and MS SQL Server/Sybase. Where I'm stuck is the reference in the Connections help to JDBC. We have a OD[More]

Jdbc-odbc-bridge connection pool

Category:DefaultRelease time:-0001-11-30Views:130

I got a problem with odbc connection pool in my Sun App Server 7. When i try to connect to the odbc database (msaccess or conzept16), i got a SQLException : com.sun.enterprise.repository.J2EEResourceException java.lang.NoSuchMethodException: setdatab[More]

Jdbc-odbc bridge connection error

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Please help me to create a jdbc-odbc connection from Jdev10g to a TSM server database. I have created a database connection with the following parameters: Connection name: tsm1a Connection type: jdbc-odbc bridge Username: admin Password: *** Data[More]

JDBC-ODBC-Bridge connection to SQL Database

Category:DefaultRelease time:-0001-11-30Views:130

Hi guys I have a problem. I've made a little game which I want to put on my website. It has a highscore-list which I want to connect to my web host's database server to get the current list. I tried this with JDBC and got it to work locally but when[More]

JDBC-ODBC bridge connection failure.

Category:DefaultRelease time:-0001-11-30Views:130

I'm new to JDBC and JDeveloper and am having some difficulty getting through the database applet tutorial. I'm trying to connect to a Microsoft Access database using the JDBC-ODBC Bridge. This is an interim stage before using a Linux Oracle database[More]

Problem With Jdbc-Odbc BRidge Connection

Category:DefaultRelease time:-0001-11-30Views:130

I get The following error SQLException:[Microsoft][ODBC Driver Manager] Invalid cursor state when using the code whats the problem with it import java.sql.*; public class Employee { String DBurl; Connection con; public Employee(String url) DBurl=url;[More]

JDBC-ODBC Bridge Performance To MS Access

Category:DefaultRelease time:2015-10-11Views:130

Hey all, I'm running a Java app that extracts an entire table (set of tables) from Oracle and copies them into Access. The easiest implementation has been to use a DSN-less Type 1 JDBC-ODBC bridge connection to Access, but unfortunately the inserts a[More]

What's the URL in a JDBC-ODBC bridge driver connection?

Category:DefaultRelease time:-0001-11-30Views:130

I'm trying to use a JDBC-ODBC bridge driver but I don't know what is the URL I need to put inside a the "getConnection (String URL, String userid, String passwd)" method. Connection conn = DriverManager.getConnection(URL, user, passwd); Can anyb[More]

Connecting remote FoxPro dbf file using jdbc odbc bridge driver?

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I am new to this topic, (even I read some threads) I need to access some FoxPro tables (dbf files) and select some data and save to an oracle table. what is the best method to do this? If I use java as development tool. which other drivers or[More]

To run a report from command line, when using jdbc-odbc bridge

Category:DefaultRelease time:2015-10-11Views:130

Hi, How to run a report from command line, when using jdbc-odbc bridge? Usually with tns, we do by "rwrun module=<> userid=<user>/<passwd>@tns". with odbc, we do by "rwrun module=<> userid=<user>/<passwd>[More]

JDBC-ODBC bridge

Category:DefaultRelease time:2015-10-11Views:130

Hello, I'm using JDK1.5 and have a working connection to MySQL using JDBC. I now need to connect to Interbase database using ODBC and that's where I'm completely lost. Could somebody please tell me if I have to download a JDBC-ODBC bridge or if it's[More]

Hot
If I watch my Library on TV it shows my list with movies that I've downloaded. After I've watched it, I delete the movie on my computer (so I thought), but it still shows in the Library. I've tried to search the Playing list on my computer to remove [More]
Can any one help to list out only empty users in system schema? Edited by: leen on Jul 24, 2012 11:34 PMOsama-mustafa wrote: EdStevens wrote: Osama-mustafa wrote: thank you in this case if i use count like below : select 'select ''' || table_name || [More]
Hi there, I would like to install Solaris 10 x86 on a server which uses an ATA-RAID-controller from 3ware (Escalade 7006-2). I haven't found any information on Solaris support for this controller so my question is if anyone of you has some experience [More]
I have read the following documentation about error handling in mediator projects. http://download.oracle.com/docs/cd/E12839_01/integration.1111/e10224/med_faulthandling.htm What was not obvious to me was how I could receive emails on notification of [More]
If you have a flex application and access it using https and the site certificate is invalid for some reason the browser gives a warning about the site and an option to continue to the site, if you choose to continue the application loads and runs as [More]
Hello, Has anyone managed to get Forms and Reports 6i (running on 9iAS web) to run succesfully on Windows Server 2003? If so would you mind sharing what you needed to do to get it to work. I don't care about any of the other components of 9iAS other [More]
Sorry, we don't really provide source for those classes right now. On 2/25/09 2:47 AM, "JabbyPanda" < [email protected]> wrote: A new discussion was started by JabbyPanda in General Discussion --   Is it possible to get source code of  Aut [More]
My brand new HP x451dw only prints blank pages. I have never seen a drop of ink on a page since I have had and set up this printer, even during the set-up process. All indications suggest that I have configured the printer correctly. I have communica [More]
Hi, Is it possible to use all the outlook controls (e.g. Body control, Send button) in custom form region created in Visual studio.  Thanks & Regards, VijayHi Vijay, Which control you are not able to use? Based on my understanding, there are two ways [More]
The hard disk on my three-year old G550 just crashed. Since the one-button recovery was not an option, I used an MS-Recovery image for the new disk. It turns out that, using this recovery method, the Windows OS becomes "not genuine". After spend [More]