Skip to main content
307 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
87 views

I am linking to tables in Snowflake from Access and running the following query: SELECT SIMS_CLAIMANTLOG.LOGID , Sum(IIf([processeddate] Is Not Null And [reservetypeid] In ("2","3&...
Mimi Bhattacharjee's user avatar
  • 9
1 vote
0 answers
238 views

I am attempting to connect to an MS Access database via DBeaver and wanted to know if there is a way to view the SQL code behind my Access queries. I have hundreds of SQL codes so it would be a hassle ...
Malikah's user avatar
  • 11
0 votes
0 answers
268 views

I have tried to connect to DB2 with python using JDBC with the code below but somehow it shows me the error My code: import jaydebeapi import jpype jaydebeapi.connect('com.ibm.db2.jcc.DB2Driver','jdbc:...
Rutvij Dave's user avatar
  • 3
0 votes
1 answer
151 views

My database path name has an ampersand in it. "...\mthly calcs & projections...". Unfortunately, the path name cannot be changed. How do I deal with this case? Is there a way to specify ...
user13892's user avatar
  • 284
5 votes
1 answer
6k views

i have newly added a below dependency into my project implementation 'org.jdbi:jdbi3-oracle12:3.29.0' these are the dependencies which i already have in my project. dependencies { implementation 'org....
saravana kumar ramasamy's user avatar
  • 151
0 votes
0 answers
315 views

If I run this SQL via SSMS (Sql Server Management Studio) there is no issue. IF NOT EXISTS ( SELECT * FROM sys.columns WHERE object_id = OBJECT_ID(N'[dbo].[MyTableName]') AND name = 'Created' ) ...
Dudeman3000's user avatar
  • 611
1 vote
0 answers
326 views

Apart from MongoDB ODBC Connector I found some third party connectors CData: https://www.cdata.com/drivers/mongodb/odbc/ devart: https://www.devart.com/odbc/mongodb/ EasySoft: https://www.easysoft....
usmansharif shaik's user avatar
  • 75
0 votes
0 answers
3k views

I have created a c# windows service and want to Connect to Databricks Delta table from c# code using JDBC/ODBC connection with below host for updating/inserting in couple of databricks delta tables. ...
V J's user avatar
  • 77
0 votes
1 answer
361 views

I have a requirement. The technology is quite old doesn't support spring at all . It is pure java application with jdbc connection. Requirement is : Suppose select * from employee where empid = <&...
Sakura's user avatar
  • 7
1 vote
0 answers
2k views

Sorry to reach out, I searched for an answer but I didn't see anything relating to my specific issue, sorry if I missed it. I used to connect fine to Snowflake using Datagrip with JDBC driver 3.13.5. ...
NicolasK's user avatar
  • 11
0 votes
1 answer
1k views

I working on upgrade the oracle jdbc driver from 11g (ojdbc6.jar) to 19c (ojdbc8.jar) in my java application, driver used is Instant Client (instantclient-basiclite-nt-19.11) with JRE1.8.0_271. After ...
user1121201's user avatar
  • 1
1 vote
0 answers
222 views

I am trying to access Excel as a database using the groovy.sql package, which is a GDK extension to JDBC. I am aware that Excel is not a database and that for most tasks Apache POI works better. I am ...
qwerty's user avatar
  • 830
0 votes
0 answers
131 views

private static final String GET_OBJECT_WITH_PREFIX = " SELECT OBJECT_KEY, OBJECT_VALUE, LAST_UPDATE_DATE from TEST_TABLE " + " where OBJECT_KEY like ? " + &...
santosh jk's user avatar
  • 171
4 votes
1 answer
1k views

While calling SimpleJdbcCall.withFunctionName I get java.sql.SQLException: Missing IN or OUT parameter at index:: 1 SimpleJdbcCall simpleJdbcCall = new SimpleJdbcCall(myDataSource) .withCatalogName(&...
user435421's user avatar
  • 971
0 votes
0 answers
209 views

My data is too big and it's around 19M and it takes too long to execute this query. So, I introduced chunks but still, I am not sure if this is the right way to do it. Is there a way to read large ...
KSp's user avatar
  • 1,239
0 votes
1 answer
2k views

In SQL Navigator(Oracle) the following three queries are working SELECT * FROM some_table a where TO_DATE (A.CREATE_DATE, 'dd/mm/yyyy') BETWEEN TO_DATE ('01/01/1980','mm/dd/yyyy') AND TO_DATE ('01/01/...
Thiagarajan Ramanathan's user avatar
  • 1,144
0 votes
1 answer
124 views

I try to connect my JavaEE to the Oracle database. If I test the connection from any IDE like DBeaver or from a command prompt there is no problem. I use Eclipse for IDE and Windows 10 for OS. What I ...
user avatar
1 vote
0 answers
43 views

My company is using WebToGo for managing our Service Requests. I had written a program to extract a list of our service requests in a more faster, more user-friendly way than is otherwise available. ...
David D.'s user avatar
  • 25
0 votes
0 answers
18 views

I'm using DbVisualizer Free 11.0 [Build #3077] OS: Windows 10 OS Arch: amd64 Java Version: 1.8.0_242 Java VM: OpenJDK 64-Bit Server VM Trying to create UCanAccess driver using the following theme:...
Dennis S.'s user avatar
  • 47
-1 votes
1 answer
2k views

I'm trying to make a program that connects to an Oracle database for the ultimate purpose of creating a few tables and running commands on them for a course I am taking. I'm currently trying to make ...
Sulfurous1980's user avatar
  • 11
-1 votes
1 answer
228 views

My Program runs successfully but gives an exception at the runtime. I have followed all the 8 steps to make a JDBC program. The code and image showing the exception are given. I have also created my ...
AliakbarETH's user avatar
  • 35
1 vote
1 answer
361 views

I am writing a java program which connects with Ms Access using ODBC-JDBC Driver. The Select and Insert Into Statement are working correctly but delete and update statement are showing syntax error. I ...
Kushagra's user avatar
  • 99
0 votes
1 answer
984 views

CREATE GLOBAL TEMPORARY TABLE "TEMP_TABLE" ( COLUMNS... ) ON COMMIT PRESERVE ROWS ; I am calling the global temp table from java jdbc innser sql Global temporary table clears on commit ...
Sruthi's user avatar
  • 61
-3 votes
1 answer
2k views

I have to export data from database to excel sheet by using java.I have around 500+ column in DB, so need help in code where i need not to put the column name. I got some code from internet, but its ...
Piyush's user avatar
  • 11
2 votes
2 answers
19k views

I has db in MS SQL Server 2005 I has java project write on java 8. My project is on Windows 7 Professional's machine (64 bit). I use this jar: sqljdbc4.jar to connect to MS SQL Server 2005. But ...
Alexei's user avatar
  • 16k
0 votes
2 answers
1k views

I get an error when using the following JDBC driver to retrieve BigQuery data in KNIME The Error Message is in the Database Connection Table Reader node as follow: Execute failed: " Simba ...
Guido Stut's user avatar
  • 1
0 votes
1 answer
241 views

Here is my code where i am running my query and adding result set into ArrayList . Modified code private ArrayList<String> getEventsFromShares() throws SQLException { Statement eventStmt = ...
Shailendra's user avatar
  • 141
-1 votes
1 answer
2k views

Why should I get incompatible data types error? int blockSize = 100; String city="London"; " select * from"+ "(" + " select l.* from lottotable as l where l.city='"+city+"' and l.date< cast('"+...
Micky's user avatar
  • 29
0 votes
0 answers
1k views

I've got a legacy project which runs some queries every minute to an Access database. All the queries work fine but after a certain amount of time (multiple weeks) and then all of a sudden Internal ...
Rodin10's user avatar
  • 337
0 votes
1 answer
71 views

I am trying to select records and view it in a JTable. My records are in Ms Access database locally in my computer. While trying to run the program i am getting an Null point Exception error, pointing ...
Thiv's user avatar
  • 9
0 votes
1 answer
541 views

I am getting ORA-12505 whenever trying to create a connection when pc is on the server. If I disconnect pc from the server then connection creating. but when I connect pc to the server then I am ...
Pritesh kumar shanu's user avatar
  • 23
0 votes
1 answer
5k views

I am facing "Missing artifact oracle:ojdbc6:jar:11.2.0.3" issue. I went through a lot of blogs but was not successfull. I tried with ojdbc14, ojdbc7 as well and I am not able to proceed further. POM ...
PreetiG's user avatar
  • 1
0 votes
1 answer
413 views

Title : Java - SonarLint Detect the Blocker - Close this "PreparedStatement" in a "finally" clause. Question : I have multiple PreparedStatement in one method (example), then I have done close the ...
fndong's user avatar
  • 81
1 vote
0 answers
737 views

Is it possible to connect to the derby database through odbc on a windows 10 machine? I have the jdbc-odbc bridge from Java 7. Found this: Derby network server The Derby network server provides ...
DCR's user avatar
  • 15.8k
-1 votes
1 answer
678 views

I'm getting run time error java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified when I tried to login using the code given. Below is ...
Ashish Kumar's user avatar
  • 29
-1 votes
1 answer
626 views

I'm using this code to get 1000 records at a time. It works fine but how do I stop at the 1st 1000 run my job, then pick up where I left off and get the next set 1001 - 2000, run the next job and so ...
Gee's user avatar
  • 197
1 vote
0 answers
84 views

Usually, we connect ODBC driver using BI applications on our local machine, Just imagine I created an ODBC driver for PostgreSQL in the remote machine at my home (Windows 10), I want to connect that ...
Mani Kkr's user avatar
  • 105
8 votes
3 answers
15k views

In my application I use 20 threads for a job. Each thread calls a remote web service and updates the Oracle DB. After Jboss restart , the job fails in updating the db, with the exception that I find ...
Joby Wilson Mathews's user avatar
  • 11.2k
0 votes
0 answers
75 views

I want to run my JDBC application jdk(1.7) with jdbcOdbc Bridge Driver(Type - 1 Driver). I am using Oracle 12C and windows 10 OS. I am getting this error massage when I am trying to register DSN. ...
RiDev's user avatar
  • 31
0 votes
3 answers
115 views

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //System.out.println("Driver loaded"); String url = "jdbc:ucanaccess://"+path; con = (Connection) DriverManager.getConnection(url)...
DevBia's user avatar
  • 1
0 votes
1 answer
402 views

I'm using the code below: JButton btnEdit = new JButton("Edit"); btnEdit.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent arg0) { try{ String ...
Kamran Ashiq's user avatar
  • 159
0 votes
1 answer
586 views

I need to upgrade sqljdbc4.jar to sqljdbc41.jar. Microsoft website has the following information: sqljdbc41.jar class library provides support for JDBC 4.0 API. It includes all of the features of ...
Aishwarya Radhakrishnan's user avatar
  • 159
1 vote
1 answer
173 views

My Java application works well on two of my colleague's computers, however it will not run on mine. The application reads a spreadsheet, creates tables in access from it and then compares them. The ...
Tourtelot's user avatar
  • 137
0 votes
1 answer
266 views

I am using WLS 12.1.3 and oracle is 10.2.0, I am using weblogic datasource to get connection This is the code, CallableStatement cst = null; try { cst = conn ....
user3428736's user avatar
  • 912
2 votes
1 answer
1k views

I'm using NetBeans IDE 8.2 and would like to make a connection with UCanAccess to access my database files. Initially I was using jdbc:odbc but I found that Java 8 onward no longer supports this ...
Question asker's user avatar
  • 45
0 votes
0 answers
888 views

While Opening instantclient_12_1 in Windows 7, from Excel it shows the following error. "The specified DSN contains an architecture mismatch between the Driver and Application" I will provide the ...
Dona Susan Issac's user avatar
  • 170
0 votes
0 answers
32 views

I am trying to create a link to my Microsoft Access Database, but I get the error: Exception : java.lang.ClassNotFoundException Here is my code: import java.sql.Connection; import java.sql....
A. Bhatnagar's user avatar
  • 45
0 votes
0 answers
184 views

I am currently doing standalone application, to traverse to all its parent table and traverse till child table has no parent. example Table1 |_ Table 2 |_ Table 2.1 |_ Table 2.2 ...
Ganesh's user avatar
  • 307
0 votes
1 answer
2k views

I am trying to connect to database in tibco bw 5.12.0. In test connection i am getting below error in popup "AEADB-800064: Connection test failed. ([tibcosoftwareinc][Oracle JDBC Driver]No more data ...
user2160158's user avatar
  • 29
0 votes
1 answer
721 views

While installing instantclient_12_1 in Windows 10 it shows the following error. I will provide the Image of the error after we select the from instantclient_12_1 from Data Source (ODBC) it was the ...
Dona Susan Issac's user avatar
  • 170

1
2 3 4 5
…
7