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
Hi,  What is the standard BAPI for creating customer.  I need to create the customer with contact person details, what BAPI i can use for this, i was trying with 'BAPI_CUSTOMER_CREATEFROMDATA1' by populating structure personal data and copy reference [More]
Hi Gurus Is there any transaction for material document disply As I know two transaction are there ie.MB59 and MB51 when look at both of them Material list display if both have same functionality why SAP has developed same reports is there any differ [More]
Dear Experts Still No one help me, My problem is , automatic posting is not working, that is even no one G/L isl assigned during po creation and goods movement. we cann't find what is the problem,definitly we can say it is from SD and FI side, Pls he [More]
Dear experts, I have a situation that is hard to describe. We have SPM 5.2 - all set and working, now the problem is that for some of the FF sessions the tool is either not reporting the reason/activity fields (due to some technical problem that is o [More]
I have just bought the HP Photosmart 5510 B111a as my original HP printer was not compatible with the LION 10.7.2 Mac OS The problem im having is that im unable to maintain a connection to my new printer. I have installed the full and latest Software [More]
Hiya We are using Oracle Forms 10g 10.1.2.0.2 All our Forms and Reports are working well. We are using Java Script in Web.Show_Document so that when the report is displayed on the screen in the browser, the browser's toolbar and menubar should not be [More]
So i've had this issue ever since i installed windows 7 ultimate via bootcamp on my mac. When i go in games or even the browser, my ping sky rockets and the internet connections always drops every 3 minutes saying "Limited Access". I cant even b [More]
hi every one i am facing a problem with the quantity field (vbap-kwmeng) as per my requirement i need to display this quantity field along with some other item fields from VBAP in an alv grid. among all the fields displayed in the alv grid only this [More]
I realize there have been a couple similar questions regarding this, recently, and I have read the answers and the guides within help. The trouble is this: My hard drive on my PC died!! I had to replace it. So, the new hard drive has no music library [More]
G'day Forum, Please forgive my inexperience in advance. I need to alter the 'Reflection' theme in iDVD (beyond what iDVD allows... perspective, ect). Is it possible to edit / import iDVD menus in DVD Studio? Would it be difficult to recreate somethin [More]