jdbc Questions

2

Im am trying to hit the secondary node on a sql server 2012 DB using "ApplicationIntent=readonly" in the connection string. It is still hitting the primary node, not sure why. I'm using s...
Shem asked 13/7, 2016 at 15:54

5

I use Spring-Boot and want to connect it to Hive by spring-data-hadoop 2.3.0.M1-hdp23. The problem is that my application doesn't start if I add hive-jdbc to my pom.xml. The errorlog (partly) is: ...
Forehand asked 11/8, 2015 at 13:18

2

I'm looking for a client jdbc driver that supports Spark SQL. I have been using Jupyter so far to run SQL statements on Spark (running on HDInsight) and I'd like to be able to connect using JDBC s...
Essie asked 9/6, 2016 at 18:27

7

Solved

at work we have to deal with several MS Access mdb files, so we use the default JdbcOdbcBridge Driver which comes with the Sun JVM and, for most cases, it works great. The problem is that when we ...
Karen asked 27/11, 2009 at 10:25

4

I'm trying to install the MS SQL JDBC driver on ubuntu to be used with sqoop for Hadoop. I'm totally new to java and linux, so I'm not sure where to extract everything to.
Therapist asked 15/3, 2011 at 3:0

3

Solved

I have now tried 2 days to connect to external DB2 database with SQuirreL. I always get error: [jcc][t4][2030][11211][3.58.82] A communication error occurred during operations on the connection's ...
Thermocouple asked 4/6, 2012 at 8:7

5

Solved

I'm having a hard time working out how I should be installing the JDBC driver for PostgreSQL on my debian 6.0 server. I have moved the driver .jar into the following directory: /usr/local/pgsql/sh...
Stripteaser asked 13/12, 2012 at 12:36

2

Solved

I'm now trying to decide which driver to use to create a DataSource from my JavaEE application to MS SqlServer. A couple of years ago I had good experience with JTDS, and SO answers suggest that J...
Davisdavison asked 27/12, 2011 at 8:59

4

We encounter an error when we go from 2.7.2 to 3.0.4 MariaDB JDBC driver with setFetchSize(Integer.MIN_VALUE) java.sql.SQLSyntaxErrorException: (conn=27489500) invalid fetch size So we switch to ...
Delgadillo asked 16/6, 2022 at 16:5

3

Solved

We are using the org.apache.commons.dbcp.BasicDataSource as parent class for our datasources in Spring. Is it possible to specify which schema to use in either the "url" or in another property in ...
Shogun asked 1/4, 2011 at 6:24

2

Solved

I'm looking for a stripped down (so NOT like squeryl, or anything that creates typesafe queries where I have to respecify the table just to get some data) wrapper for jdbc. i'm using scala 2.9 an...
Interlaken asked 3/2, 2012 at 18:34

13

Solved

I am a novice in hibernate world and facing, WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement org.hibernate.tool.schema.spi.CommandAcceptance...
Civilization asked 14/4, 2017 at 7:47

6

Solved

When executing batch queries via JDBC to pgbouncer, I get the following error: org.postgresql.util.PSQLException: ERROR: prepared statement "S_1" already exists I've found bug reports around the...
Mainspring asked 30/9, 2011 at 14:34

1

I am using Spring JPA with hibernate ORM project and want to integrate with ClickHouse. I found some references of ClickHouse JDBC which is working ClickHouseJDBCDemo ClickHouseJDBCDemo but was...
Roswald asked 2/3, 2018 at 13:41

14

Solved

We are using Oracle as the database for our Web application. The application runs well most of the time, but we get this "No more data to read from socket" error. Caused by: java.sql.SQLRecoverabl...
Rumble asked 20/10, 2011 at 17:38

3

My Java application needs to authenticate to Google cloud Mysql instance with SSL client authentication. Its client-key and certificate are provided by Google. I also need to setup JMX agent with S...
Bakehouse asked 20/10, 2015 at 5:13

7

Solved

When connecting to MySQL, I get an error (see below). Click here for code I get this output: run: Now connecting to databse... java.sql.SQLException: java.lang.ClassCastException: java.math.Big...
Skewer asked 9/9, 2017 at 13:37

14

I am new to Oracle, and am trying to run a simple example code with Java, but am getting this error when executing the code.. I am able to start up the listener via CMD and am also able to run SQL ...
Lumen asked 24/9, 2012 at 23:38

9

Solved

I am trying to develop web application using SpringBoot and Postgres Database. However, on connecting to the application, I am getting error "Failed to determine a suitable driver class" As per adv...
Bloom asked 18/7, 2018 at 13:59

4

Solved

I am trying to connect Sql Server Data Base using windows authentication from my application using JTDS driver but i got following error SSO Failed: Native SSPI library not loaded. Check the ja...
Immunoreaction asked 15/6, 2011 at 10:55

2

Solved

Im building a large database call using PreparedStatement that has 2000+ parameter markers. Im getting this error Caused by: java.sql.SQLException: Prepared or callable statement has more than 20...
Huihuie asked 31/1, 2013 at 17:10

3

Solved

I have a running local instance of PostgreSql on a linux machine. When I use psql command from the shell I success to log in without any problem. I need to connect to the PostgreSql via the JDBC, b...
Koheleth asked 30/12, 2010 at 12:11

12

Solved

I am using JDBC and new to it. but I keep getting this runtime exception: connecting to psysical database... com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'kholofel...
Kenton asked 5/4, 2013 at 10:53

3

I have csv file in Amazon s3 with is 62mb in size (114 000 rows). I am converting it into spark dataset, and taking first 500 rows from it. Code is as follow; DataFrameReader df = new DataFrameRead...
Baronetage asked 9/3, 2017 at 13:18

7

Solved

I'm currently in the process of enabling UTF-8 characters in some tables of a large database. These tables are already of MS-SQL type NVARCHAR. Additionally, I have several fields using VARCHAR a...
Prevention asked 8/3, 2011 at 19:28

© 2022 - 2024 — McMap. All rights reserved.