ODBC « ODBC « Java Database Q&A





1. ODBC to JDBC datatypes mapping    stackoverflow.com

Where can I find description of how to map ODBC datatypes to JDBC? Or maybe anybody knows where source code of a jdbc-odbc bridge driver can be downloaded?

2. Consistent method of inserting TEXT column to Informix database using JDBC and ODBC    stackoverflow.com

I have problem when I try insert some data to Informix TEXT column via JDBC. In ODBC I can simply run SQL like this:

INSERT INTO test_table (text_column) VALUES ('insert')
but this do not ...

3. Java can't find right ODBC-Datasource    stackoverflow.com

I created a BIRT report and deployed it to tomcat. It runs fine on localhost, but not on the server. The app doesn't find the right ODBC datasource. But the datasource ...

4. RETURN_GENERATED_KEYS doesn't work using JDBC ODBC    stackoverflow.com

I'm trying to get insert ID while after inserting some data in my database.

String sql = "INSERT INTO ADI.DUMMY(dummy_data) VALUES('from database logger')";
PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
int extUptReturn = ps.executeUpdate(sql);
But I got ...

5. Detect Database Currently in Use with Java    stackoverflow.com

Is there a way to detect the ODBC database currently being connected to with Java? For example, I would like to know whether an application is currently connected to Oracle 10g or ...

6. how to create a dsn for oracleinxe?    stackoverflow.com

i have oracle 10g express edition installed and i want to know how to create a system dsn for it.so that i can connect database to my java programs

7. JAVA - insert into DB problem    stackoverflow.com

I've got a problem where I'm inserting data into a database. It's returning that 1 row is being inserted, but when I actually check the database, nothing new has actually been ...

8. Java: cannot update Excel using JDBC ODBC    stackoverflow.com

I can read rows/columns just fine, but I can't update, insert or delete.

try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       ...

9. ODBC Error: Invalid String or Buffer Length--Microsoft Server 2008 32bit vs 2008 R2 64bit    stackoverflow.com

Attempting to connect from Java 6 console app to Microsoft SQL Server 2008 R2 on an Microsoft Windows Server 2008 R2 64bit system via an ODBC System DSN using SQL Server ...





10. JDBC and ODBC backend information    stackoverflow.com

If I am given the JDBC and ODBC from a site and they aren't giving me what database in the backend they're using (MySQL, PostgreSQL, SQLServer). Is there a way to ...

11. jdbc odbc connectivity    stackoverflow.com

am a newbie to java. I want to create a table in MYSQL and insert images into it.I have to write code in java to insert the images. can anyone tell ...

12. Error while executing Java code in RFT    stackoverflow.com

I am using RFT(Rational Functional Tester) 8.2 for my automation. I am getting error when I am doing the following steps

  1. I using Microsoft Excel ODBC Driver to connect to excel sheet ...

13. ODBC vs JDBC vs ADO.NET    stackoverflow.com

What exactly are ODBC, JDBC and ADO.NET? What are the links between them?

14. Get table names from lotus notes database    stackoverflow.com

I'm trying to write a program that would dump a whole lotus notes database to a file via NotesSQL driver. I'm connecting via jdbc:odbc and have I can execute selects and ...

15. How do I install an ODBC library in Jython    stackoverflow.com

In python is possible to install pyodbc fairly easy, but in jython you are supposed either to install django, and to instal jdbc and then I do not know what else. ...

16. Is there a standard for REST database connectivity?    stackoverflow.com

Is there a standard for REST database connectivity, or anyone hearing any whiffs of a plan? A standard similar to JDBC or ODBC for REST? I am not asking about some people ...





17. "[Microsoft][ODBC Driver Manager] Invalid string or buffer length" error    stackoverflow.com

When I run in eclipse it runs fine. But, through the command prompt, it throws the exception "[Microsoft][ODBC Driver Manager] Invalid string or buffer length". How to get over this? This is ...

18. "Solved" Query Excel date fields using ODBC return null    stackoverflow.com

I use the following configuration to run a java program to extract data from a excel file. Some of these columns have data with time-stamp context.

  • Platform: Win 7 (x64)
  • ODBC: Excel (x32) ...

19. jdbc to odbc    bytes.com

@r035198x That is not what the OP attempted to use it for; the first column of that table is an auto-increment column and the OP was trying to express ? as ...

20. JDBC ODBC in Netbeans 6.1    forums.netbeans.org

I connect to database via JDBC-ODBC bridge. My program does a lot of searching queries and I feel stored procedures can reduce the time. But My program gives the runtime exception ...

21. JDBC ODBC in Netbeans 6.1    forums.netbeans.org

I connect to database via JDBC-ODBC bridge. My program does a lot of searching queries and I feel stored procedures can reduce the time. But My program gives the runtime exception ...

22. I tried to drag&drop table + Ctrl from jdbc:odbc    forums.netbeans.org

I tried to drag&drop table + Ctrl from jdbc:odbc connection and everything hungs up. Also I tried it in netbeans 6.8 causes same result. How can I use this function? ...

23. ODBC and xBase    coderanch.com

24. JDBC:ODBC: DRIVINGMECRAZY    coderanch.com

Everything I read assumes I already know a bit about JDBC the fact is I don't.. I have Java 2 installed and it says that JDBC is included however when I run a JDBCtester I found on the net it states that class sun.jdbc.odbc.SunJdbcOdbcDriver could not be found... registerDriver().. failed Do I need to download something separate in order for JDBC ...

26. JDBC ODBC error    coderanch.com

27. ODBC error: COUNT field incorrect    coderanch.com

Hi. I am using VAJ 3.5 and am trying to update and insert a row into a table. I can run a select statement just fine, but on both the update and insert commands, I keep getting the following error: A database manager error occurred. SQL State: 07001 [Microsoft][ODBC SQL Server Driver]COUNT field incorrect Any ideas? I have a very limited ...

28. JDBC /ODBC connectivity    coderanch.com

If you are using Sun's JDBC-ODBC bridge driver, you will have to set up an ODBC DSN to your Oracle database, which will require that you have a driver present on your local machine. You would have that driver if you had the Oracle client installed. If you are saying that your machine is both the client and the server, then ...

29. ODBC, DNS, JDBC    coderanch.com

30. JDBC ODBC Concetivity    coderanch.com

31. JDBC ODBC host string    coderanch.com

32. Odbc    coderanch.com

33. jdbc:odbc issue under JRun    coderanch.com

I just wanted to post this here to see if someone else had run across this, or to help someone who is going to. Here's what I'm doing on a .jsp page in JRun (windows 2000 install) < %@ page import="javax.naming.*, javax.rmi.PortableRemoteObject, java.sql.*, javax.sql.*, java.io.*, javax.servlet.*, javax.servlet.http.*" % > < %
Connection m_connection = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
m_connection = ...

34. JDBC to ODBC to ODBC?    coderanch.com

This is an odd one.... I've got a Linux machine and I need to connect to a remote SQL Server database. From what I can tell, I'll have to use some type of ODBC bridge to contact the SQL Server, then use the JDBC->ODBC bridge on the Linux machine to talk to the ODBC bridge. That's far too many bridges to ...

35. Odbc problem help me    coderanch.com

hai all i am new to this section ,i have a problem with connecting to oracle by using odbc driver. First on windows 95 i installed oracle 7.3 and tryed to connect to it using odbc(Microsoft odbc driver for oracle) driver ,when i run my java application an window appears on the screen saying oracle client and network components where not ...

36. jdbc:odbc    coderanch.com

37. ODBC    coderanch.com

38. Help needed with JDBC ODBC    coderanch.com

Hi friends, I have created a servlet which connect with Access db and get data. When I run my servlet it throws me an error which says

SQL exception: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

My code is... url = "jdbc dbc:EmpDetails"; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); conn = DriverManager.getConnection(url,"",""); stmt = conn.createStatement(); rs = ...

39. ODBC DNS setting    coderanch.com

40. ODBC    coderanch.com

41. Setting up the ODBC settings    coderanch.com

42. ODBC authentication problem    coderanch.com

By using sessions u can handle this problem e.g. u create html file for login. There is 2 text boxes in it one is for user name and other for password,there names are id and p. In jsp file in scriplets tag <% id = request.getParameter("id"); pass=request.getParameter("p"); if((id.equals("salman"))&&(pass.equals("salman12"))) {session.putvalue("usr",id); In this way u can solve ur problem

44. jdbc:odbc Help    coderanch.com

45. executeUpdate ODBC Too few parameters    coderanch.com

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); java.sql.Connection con = null; java.sql.Statement stmt = null; java.sql.ResultSet rs = null; con = java.sql.DriverManager.getConnection("jdbc :-o dbc:Car","",""); stmt = con.createStatement(); // \" will put the quote into the string. String str = "INSERT INTO tblCars (Make,Name,Color,Price)"; str += " VALUES (\"" + carX.getMake() +" \",\" "+ carX.getName(); str += " \",\" "+ carX.getColor() +" \", "+carX.getPrice()+ ")"; int result = ...

46. jdbc:odbc problem    coderanch.com

47. jdbc:odbc insert error fails with code -3502    coderanch.com

I am calling a preparedstatement that performs inserts on a single table in an access database. However, the insert fails and I can't figure out why - any help is most appreciated. I also tried this as a batch, and that didn't work either. // code that inserts in to the database: PreparedStatement addFee = cnxn.prepareStatement("INSERT INTO RegistrationFee(meetingID,feeType,regularFee,earlyFee,description,order) VALUES("+meetingID+",?,?,?,?,?)"); // regFees ...

48. ODBC and JDBC!!!    coderanch.com

hi folks, i saw that i can connect to a database with ODBC(ie manking DSN) and also with JDBC.but what i can't see is that what circumstance requires to choose one over the other. could you please educate me with this? thanks. [ August 30, 2003: Message edited by: Namaste Sathi ]

49. updateDate using jdbc : odbc    coderanch.com

Hi I am trying to update a field of type Datetime on SQL Server using jdbc: odbc bridge and I am not able to do that. I get different errors like [Microsoft][ODBC SQL Server Driver]Invalid date format and sometimes I get just 'null' this is the code I am using... import java.sql.*; public class jdbc1{ public static void main(String[] args) { ...

50. JDBC or ODBC and Excel    coderanch.com

Joe, I looked at the article, but am confused about something: The name of the Excel file is qa.xls, but it often refers to qa-list. Why does it add the -list on the end? I am actually not working with Java code, but a tool instead that connects to a database and retreives it's structure. 1)It asks for a DB Connection ...

51. Problem with Like statement Using JDBC:ODBC    coderanch.com

Hi ranchers! I have a problem. I'm using JDBC DBC to connect to a MS ACCESS 2000 database. When I run the query in MS ACCESS I get correct results. When I run it in the javacode I get an empty resultset. I Dont have any problem with select , update , delete statements that doesn't use "LIKE". Here is an ...

52. Setup ODBC?    coderanch.com

53. jdbc:odbc password definition    coderanch.com

Hi I have a java application connecting to a MS SQL Server database. I set up an ODBC connection in "Windows ODBC Data Source Administrator" using its SQL Server driver. I have no problems connecting and all SQL executes fine. I use the following driverManager: "sun.jdbc.odbc.JdbcOdbcDriver" and connectionString: "jdbc dbc atasourcename" However, it only seems to work if I define the ...

54. ODBC call fail    coderanch.com

I have an Access database with a ms sql backend. This morning I was making some changes on the design of a table from the sql server.Then I linked the table on access to the one on the server. But when I try to open that table , all the fields are marked #Name? and I am havign the error odbc ...

55. ODBC DSN Programmically    coderanch.com

56. ODBC - too few parameters ??    coderanch.com

57. Applet JDBC.ODBC    coderanch.com

58. JDBC:ODBC Native Code errors,please help!    coderanch.com

Hi,im writing a system using tomcat. I connect to an ingres database using an ODBC bridge. Lately Tomcat has been crashing and generating the error report below.I think it says that the native odbc driver is crashing and causing tomcat to crash.It crashes outside the java VM so theres seems to be little i can do.Would anyone know how to fix ...

59. odbc    coderanch.com

60. JDBC vs ODBC    coderanch.com

61. difference between JDBC and ODBC    coderanch.com

62. odbc question    coderanch.com

64. jdbc_odbc equivalent in linux?    coderanch.com

65. C/ODBC and ODBC for Navision    coderanch.com

Dear all, I am trying to connect to Microsoft Navision database. I am having C/ODBC driver for Navision and I have created a DSN(using C/ODBC driver) in the system and tried to connect to database(Navision). I am not getting connected. But when I am trying to connect to other ODBC DSNs in the system, I am getting connected. Can anybody tell ...

66. configuring ODBC    coderanch.com

67. ODBC configuration.help    coderanch.com

hi, i have tried configuring my ODBC, but bcos their are so many option(user DSN, System DSN, File DSN, etc) and so many things in the ADD button, i am really confused as per which to use and each time i try any option my program gives an error. i dont know if this is the best forum for me to ...

69. I can't seem to get my ODBC url right    coderanch.com

70. configure an ODBC datasource----help    coderanch.com

71. Dynamically create ODBC source    coderanch.com

I am having difficulty finding the right Google query, so hopefully someone can steer me in the right direction. I am using a database to populate an excel file. Using JDBC:ODBC I am able to read and write from the excel file (and boy did it feel good to get that figured out), I can also create a workbook of n ...

72. Error in JDBC ODBC    coderanch.com

<%@ page language="java" session="true" errorPage="error.jsp" import="java.io.*,java.sql.*" %> <% Connection con = null; Statement st = null; ResultSet rs = null; String username = request.getParameter("id"); String password = request.getParameter("passwd"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:forum"); st = con.createStatement(); rs = st.executeQuery("select id,uname,password from users"); while(rs.next()) { if(username.equals(rs.getString(2)) && password.equals(rs.getString(3))) { session.setAttribute("uid",username); session.setAttribute("id",rs.getString("id")); response.sendRedirect("/examples/jsp/forum.jsp"); } } response.sendRedirect("login.html"); } catch(Exception e) { out.println(e); } ...

73. JDBC ODBC    coderanch.com

Okay, I'm a little confused as to why you want an ODBC driver for DB2, when DB2 ships with two very sexy drivers, the .net driver and the .app driver. Both of these drivers are in the db2java.zip file, and if you have db2java.zip on your Java classpath, you can connect very easily to db2. Using the JDBC-ODBC bridge with DB2 ...

74. Jdbc Odbc and bank transaction related question    coderanch.com

1. What is the difference between jdbc and odbc? 2. Please explain the 4 levels of jdbc drivers? 3. Consider the bank situation where the husband and wife are holding the joint account and there is a balance amount of 1000/-. Now the husband logs in through ATM also simultaneousl wife logs in through ATM. Both of them see the amount ...

75. Error messages using ODBC    coderanch.com

Hi , I'm having a problem with this code. I'm trying to connect to a locally stored access databank. I am running the Java application from within Eclipse.... can someone help me here? thank you! import java.awt.*; import java.awt.event.*; import java.sql.*; import java.util.*; public class test2 extends Frame { // GUI-Variable Label status = new Label("bereit ...", Label.LEFT); Panel panel = ...

76. What is ODBC    coderanch.com

When you are communicating with MSSql directly in an all-windows environment, ODBC may be faster. JDBC can't talk directly to ODBC and therefore needs a bridge, so then you have Java app -> JDBC -> JDBC-ODBC Bridge -> ODBC -> MSSql You don't need to talk via the bridge, and the JDBC-ODBC Bridge is not great - it was never meant ...

77. ODBC error    coderanch.com

Hi, I am using Oracle 10g, in Windows XP, ODBC database administrator list contains oracle in OraDb10g_home2 instance, version 10.02.00.01. When I try to add this an error is being thrown saying "ODBC driver could not be loaded due to system error 998". May I know how to solve this problm as soon as possible. thanks and regards, Rahul.

78. JDBC &ODBC    coderanch.com

79. JDBC:ODBC, Remote DSN and FoxPro (I am confused...)    coderanch.com

I am just in a design phase. I want to access dbase FoxPro free tables from jsp's pages. I found an application in my library which can serve the purpose properly after minor changes. But its been developed considering windows environment (VFP ODBC DSN connection). Now problem is currently I have only Linux server with apache tomcat 5 on it. I ...

80. JDBC or ODBC    coderanch.com

81. Mircrosoft Driver Manager Invalid String or Buffer Length JDBC ODBC    coderanch.com

This is for all those who have stuck on the same issue: Guys sincerely im really upset about the fact that I wasnt able to get any solution for this. Theres no update/ fix available for this issue. I have tried installed Visual Studio 2008/2010 all the sql servers since 2005 But i assume that problem exists in the Microsoft ODBC ...

82. ODBC names    coderanch.com

83. JDBC (ODBC) Concurrency confusion    coderanch.com

Hi Everyone. I'm a Computing Student and I'm working on some test code that will hopefully help in the construction of a new System for a friend of mine for some much needed cash over the summer. I'm fairly confident with most aspects of the requirements, but the one that has me stumped is safe concurrent access to a Database via ...

85. Java application crashes because of ODBC    coderanch.com

Hi all, I wrote a short java program that is suppose to print the column names of a certain table ("PrintHistory) in an Access database. This is the code: public class JdbcWithJre6 { /** * @param args */ public static void main(String[] args) { final String url = "jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=j://magic//WD_DEV3//lastprintout28102008.mdb"; Connection c = null; ResultSet rs = null; try ...

87. Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch    coderanch.com

public Customer getCustomerInfoFromDB(String nameId) { Customer cust = new Customer(); String url = "jdbc:odbc:CustomersDB"; String sqlQuery = "SELECT FirstName, LastName, Address, City, State, Zip FROM Customer where LastName =" + "\'"+ nameId + "\'"; Connection conn = null; Statement stmt = null; ResultSet rs = null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn = DriverManager.getConnection(url, "lexx", "java"); stmt = conn.createStatement(); rs = stmt.executeQuery(sqlQuery); // ...

88. Java: calling jdbc.odbc from browser    dbforums.com

I would like to have the browser call a java program which, among other things, executes database record retrievals. I have the following java code working correctly: import java.sql.*; public class db { public static void main (String[] args) { Connection conn; ResultSet res; Statement stat; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn = DriverManager.getConnection("jdbcdbc:test"); stat = conn.createStatement(); res = stat.executeQuery("Select field1 from table1"); ...

89. Looking for JDBC:ODBC and MDAC replacement    dbforums.com

I'm developing a java application which has to read and write a lot of different db file formats. All file handling is currently done through JDBC:ODBC and MDAC ODBC drivers. Our application supports: txt/csv (Comma Seperated Values), xls (MS Excel), mdb (MS Access) and dbf (MS FoxPro, dBase). However, we are not satisfied with the speed, stability of those drivers and ...

90. without ODBC    java-forums.org

91. jdbc and odbc    forums.oracle.com

Hi I am new to Java prog. What is the difference between OBDC and JDBC ? I am asking it as I encountered something like this in book The code fragment below illustrates creation of a connection for the JBDC driver for ODBC: import java.util.Properties; // ... String driverName = ?sun.jdbc.odbc.JdbcOdbcDriver?; String sourceURL = ?jdbc.odbc:technical_library?; try { Class.forName (driverName); Properties prop ...

92. JDBC odbc performance issue...    forums.oracle.com

Now, if i run this in a loop, in other words if this get calls multiple times, my cpu go crazy... almost 99% with 50 calls to this stored procedure if ran ||. I checked about caching it. I did cached it but still my cpu consumption is same. Any help is great. My connections are hopfully being closed or being ...

94. JDBC & ODBC    forums.oracle.com

Why are you using ODBC, when there is a very good JDBC driver for MS SQL Server? As you have the problem on Windows 64 bit, make sure that either 1) You are using 64 bit Java, 2) the 64 bit MS SQL ODBC driver and 3) the 64 bit odbcad32.exe (in C:\windows\system32(!)) to setup the DSN or 1) You are ...