Stack Overflow
Stack Overflow

Questions tagged [jdbc-odbc]

The JDBC-ODBC Bridge enables Java applications to access ODBC data sources through the JDBC interface.

The JDBC-ODBC Bridge enables Java applications to access ODBC data sources through the JDBC interface. It was created to allow access to data sources that had an ODBC driver but did not have a native JDBC driver.

Important note (from Oracle's Java SE documentation):

The JDBC-ODBC Bridge should be considered a transitional solution; it will be removed in JDK 8.

307 questions
0
votes
1 answer

Is it possible to access ODBC over the network from Java client?

I'm looking for a way to access the ODBC API on a Windows machine from a Java application running on a different machine, over the network. Is this possible? Some notes... I am not trying to connect directly to the ODBC API and use it to access a…
Archie
  • 4,959
  • 1
  • 30
  • 36
0
votes
1 answer

How to aviod duplicate entries into the DB tables using java JDBC

I am inserting rows into the columns of oracle table that I created manually on the DB with the number of column names and order that in the XML file. The XML is considered as a config file,so the users can manage the columns and update them as per…
aaradhya
  • 1
  • 3
0
votes
2 answers

java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

The below code: public void insertNewStudent(int id, String pass, String fname, String lname, String street, String city, String state, int Zip, String Email, double GPA) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn =…
drowningincoffee
  • 93
  • 2
  • 3
  • 11
0
votes
4 answers

Unable to connect to MS Access Database

This is my code: public class ConnectDB { Connection conn; Scanner kb=new Scanner(System.in); public String ID; public ConnectDB() { try { Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); System.out.println ("Driver successfully…
user2340779
  • 1
  • 1
  • 1
0
votes
7 answers

Insert value into database using jdbc

I am using MS-Access and Java with connection of JDBC-ODBC driver. As the code below, I'm trying to create a registration textbox but when I add the values, I only get the result "null" in the database. How do I get the real value I'm inserting ?…
Baba Dass
  • 1
  • 1
  • 1
  • 2
0
votes
1 answer

Autonumber comparision in JDBC

I have an Auto Number(Random number) field in access database. Now i want to compare the input i have got from user with that autonumber field using JDBC. Which datatype i should use for comparing?
user2226774
  • 1
0
votes
0 answers

no data inserted to MS Access database from java GUI

Every other button is working fine only problem is with the save button. I am doing project in netbeans and it is not showing any errors eighter yet data is not getting into database from java GUI b1.addActionListener(new ActionListener(){ …
Ojas Kale
  • 2,067
  • 2
  • 24
  • 39
0
votes
3 answers

ClassNotFound Exception in JDBC Programming with Eclipse Juno

All Active folks of StackOverFlow, Greetings for holi (Indian Festival) I created a simple JDBC program in Eclipse JUNO : import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class Connect { static…
Mavrick
  • 505
  • 1
  • 7
  • 27
0
votes
1 answer

How to show MS Access DB in JTable with my own column names?

I'm trying to input one table to a JTable, but not using Vector(), because it takes the column names which I inputed in DB(short names), now I want to change column names, but I don't understand how to do that. JTable table = new JTable(data,…
usr999
  • 157
  • 2
  • 7
  • 20
0
votes
2 answers

how to convert Java String to MS access code standard

I am a java coder and in my project, I would like to store specific font to microsoft access database. But in database their is only show "????" sign. For detail, I was used JTextField to get the String and then insert into the MS database table.…
user2095528
  • 1
  • 1
0
votes
1 answer

What exactly is a data source? What difference does it make?

When I tried to establish a connection with the Oracle Database, I had to write Connection CON = DriverManager.getConnection("jdbc:odbc:Dan", "system", "noodles"); Here, Dan is the data source name, isn't it? What if I created a table called cBC…
Daniel Victor
  • 649
  • 2
  • 7
  • 11
0
votes
2 answers

Adding com.jdbc.odbc.Driver via terminal

when i try to run a project java -jar test.jar i get the following exception java.lang.ClassNotFoundException: com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver how to add…
akash
  • 1,801
  • 7
  • 24
  • 42
0
votes
1 answer

How to getGeneratedKeys() of a table in java

I have a java web project.I have database in Sql Server 2008 with tables person and customer.I am inserting values(username ,paswword,role) in to table person and then take the generated id value 'pid' and insert this with other attributes into…
dany
  • 1,801
  • 7
  • 27
  • 40
0
votes
1 answer

Jdbc-odbc query issue

I'm getting syntax error in insert into statement. java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957) at…
user441978
  • 831
  • 9
  • 17
  • 28
0
votes
2 answers

How to get value from resultset column name in java?

I'm reading value from Excel using jdbc-odbc in java ? One of the column name start with . how to read the from that column ? Im getting error unknown column while reading.. //String filesend = resultset.getString(".file send"); Please help me..
user441978
  • 831
  • 9
  • 17
  • 28
1 2 3
…
20 21