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 All, I am getting the below error when i try to activate any message mapping in the IR. Any ideas? " Starting compilation  Source code has syntax error:  java.lang.NoClassDefFoundError: com/sun/tools/javac/Main Exception in thread "main" [More]
Everytime I want to forward an email that has say cartoons in it or multiple images, like a joke - it recipient gets the images as individual attachments. How can I avoid this? I want the reciepient to get the email looking EXACTLY as I see it. With [More]
I'm moving from CF8 to CF10 and having some issues. My CF10 install is a clean install on brand new server running Windows Server 2008 R2 64bit IIS 7.5. I've upgraded to CF version 10,0,11,285437. Out of the 50 or so Apps on the server almost everyth [More]
Kia ora, After the latest security update, on reboot, all my services that pointed to the server name rather than the ip address are broken. I can use ical if i reconfigured the accounts to connect using the server ip address but not the name. Wiki b [More]
Hi, in my repository fact table is there "service request". in that fact i have created one column and i havent given aggrigation. And i havent given levels also. But if i create report by using this column, it is throwing error. how to create m [More]
Hi, I need to select WBS element (PRPS-PSPNR) Based on the following fields on the selection screen Project PSPID WBS element POSID Network/order AUFNR Activity  ACT01-VORNR Materials in network  AFVC-ISTRU . Help needed urgently . High Points will b [More]
Hi all, We are also having a similar setup, except that we are using WebLogic Server 5.1. We had this problem when the traffic in our production site is high. We thought we had solved the problem when we applied Service Pack 5. But after behaving for [More]
I want to display images from a SQL database. The images are in a table under a specific column and are stored as a link to the image. How would I display the images from the column in LabVIEW? I'm using LabVIEW 2013 version 13 and SQL Server 2012 Pa [More]
i've tried so many times but the problem still exists! please help!!Could you describe what your problem is, please?Read other 2 answers [More]
Hi, I am doing web project for the saudia arabia where user enters their information in the arabic text. So how do i get this information in unicode in the action class. I am using struts framework for the web application. Please suggest me some step [More]