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
I have used a jar file "poi-scratchpad-3.2-FINAL-20081019.jar" and "poi-3.2-FINAL.jar" to read text from a .DOC file. I used the "getParagraphText()" function of the class "org.apache.poi.hwpf.extractor.WordExtractor&quo [More]
In ios 7, when I set various settings under Restrictions (In General-Settings-Restrictions), all of my settings keep getting lost whenever I disable and then enable Restrictions. Is there some other way to 'toggle' restrictions on and off? I want to [More]
--When I start up, I have a gray screen with the apple icon and a spinning wheel. I am not getting to the log in screen. What can I do?Hi... Maybe this support article will help >  Mac OS X: Gray screen appears during startup One of the suggestions a [More]
I get this error when trying to export a slide show from iphoto '08 to a .mov file. Does anyone have any ideas how to fix this? Thanks. OSStatus error -9459 KevinSystemPreferences > Energy Saver, set the machine to never sleep. Regards TDRead other 4 [More]
Hi gurus. How can I define a multi language roadmap in Solution Manager? I'm defining a roadmap using the RMAUTH transaction, but I've just defined the roadmap in English.  I need to have the roadmap in two more languages...   What is the procedure t [More]
I have a Mac mini that is connected to a cable modem by ethernet, and then broadcasts a wireless network to share that connection. It seems silly to buy a wireless router when one of my computers can be the router. The mini's firewall is enabled, and [More]
Hi, I have Windows 2008 R2 acting as a DHCP server. I'd like to push a custom option (created under Scope/Predefined Options and Values/DHCP Standard options) during DHCP Offer. Currently options in DHCP Offer are: 53, 1, 58, 59, 51, 54, 6, 255. The [More]
Hi everybody! I'm trying to implement a pre-generated MDM Web Service as an automated task in BPM process. I'm making settings exactly as described in the guide http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/50d7ad1f-6b27-2d10-448e-9c115ce7f5 [More]
Hi, I need to exclude cache folders from backup and am using java.util.regex for this. I am reading the regex like D:\test\b\cache.*? from a simple text file using BufferedReader. I Thought the problem was related to the backslash escapes but I am no [More]
I'm trying to connect to a WPA2 AP with hidden ssid via wpa_supplicant (tried NM also, don't say that please). I have two machines: 1) rt61pci driver, wifi works, can connect to open APs, can't connect to WPA2 hidden ssid AP This machine used to be a [More]