jdbc Questions
4
Solved
I've got a set of rows in a database, and I'd like to provide an interface to spin through them like this:
def findAll: Iterable[MyObject]
Where we don't require having all the instances in memo...
5
Solved
Can anyone help me out? I have small utility application that uses the Jt400-6.7.jar to connect to an AS400 server.
Please see the following code
private Connection buildConnection(String url, St...
7
Solved
Question: Is it possible to create a new DB in a migration script and then connect to it? How?
My Scenario:
I'm trying to use flyway in my Java project (RESTful application using Jersey2.4 + tomca...
Stilt asked 5/11, 2013 at 14:12
2
Solved
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 work i...
34
Solved
The following code:
Class.forName("com.mysql.jdbc.Driver");
Connection m_connection = DriverManager.getConnection("jdbc:mysql://localhost","root","root");
Throws this exception on getConnection(...
Sacrilegious asked 12/8, 2012 at 12:51
3
Solved
I'm using PgSQL 9.1.
SELECT 5.1::text
is working fine with output '5.1' in PgAdmin3, but with JDBC Prepared statement EXEC SQL, the result always as '5.0999999'.
Of source SELECT to_char(5.1...
Suburbia asked 17/2, 2015 at 2:36
3
Solved
I am trying to connect to a Postgresql database from Java using the JDBC Driver and would like to use pgpass to authenticate.
My Postgresql server is correctly setup for password authentication an...
Grabble asked 12/1, 2014 at 11:53
8
Solved
As the ResultSet contains the data returned from the dynamic SQL, if there are any method to determine if the ResultSet contains a particular column name?
For example , if I run rs.getString("...
22
Solved
I want to add the oracle jdbc driver to my project as dependency (runtime scope) - ojdbc14.
In MVNrepository site the dependency to put in the POM is:
<dependency>
<groupId>com.oracle...
5
Solved
I am trying to use a MapSqlParameterSource to create a query using a Like clause.
The code is something like this. The function containing it receives nameParam:
String namecount = "SELECT count(...
9
I have this really big table with some millions of records every day and in the end of every day I am extracting all the records of the previous day. I am doing this like:
String SQL = "select col...
Prehistoric asked 23/8, 2009 at 11:34
16
Solved
Shouldn't this be a pretty straightforward operation? However, I see there's neither a size() nor length() method.
Unicellular asked 10/10, 2008 at 16:12
23
I'm trying to add a database-enabled JSP to an existing Tomcat 5.5 application (GeoServer 2.0.0, if that helps).
The app itself talks to Postgres just fine, so I know that the database is up, user...
Shippy asked 15/12, 2009 at 23:33
4
I don't understand why the code doesn't works on Android, it's the same code in Java and it's works on my laptop. I've already search on Google, Stackoverflow, and Youtube, but I didn't find the re...
Gretel asked 3/8, 2020 at 9:26
4
i have a really hard time setting up JDBC river mysql connector with my elasticsearch installation
first i follow all the https://github.com/jprante/elasticsearch-river-jdbc howto
diffrence is wh...
Blaze asked 7/6, 2014 at 15:18
3
I have downloaded MySQL Workbench for my database, and IntelliJ for the JDBC. However, while watching a tutorial, it was mentioned that I need the MySQL dependency in a pom.xml file. Any idea on ho...
Dreda asked 26/4, 2021 at 4:39
19
Solved
I am trying to run my Spring Boot backend with two profiles, one using H2 in memory database and the second one using MySQL. H2 database works just fine, but when I switch to MySQL I get
APPLICATIO...
Floccose asked 14/10, 2018 at 15:26
3
Solved
I got an error
Loading class com.mysql.jdbc.Driver. This is deprecated. The new
driver class is com.mysql.cj.jdbc.Driver. The driver is
automatically registered via the SPI and manual loading of t...
4
Solved
I am trying to write a database independant application with JDBC. I now need a way to fetch the top N entries out of some table. I saw there is a setMaxRows method in JDBC, but I don't feel comfor...
Leopoldeen asked 16/4, 2012 at 14:1
5
Solved
I'm trying to connect to a postgresql database which is in localhost:5432 but I keep getting the error:
FATAL: Ident authentication failed for user "".
I installed Postgres11 on virtual machine r...
Nitrate asked 14/2, 2020 at 14:59
8
I am using Android Studio [Android Studio Arctic Fox | 2020.3.1 Patch 1]
My room library version is [2.3.0]
Used Gradle version [7.0.1]
Also added kapt 'org.xerial:sqlite-jdbc:3.36.0.1'
Caused by...
Cushy asked 22/8, 2021 at 19:37
2
Anyone ever seen this? I'm using MS SQL Server 2008, and I've tried it with two different JDBC drivers (jtds, and Microsoft's). I run a simple statement to update a row, and it does update it, but ...
Blain asked 13/2, 2014 at 14:36
3
Our gRPC need to handle 1000 QPS and each request requires a list of sequential operations to happen, including one which is to read data from the DB using JDBC. Handling a single request takes at ...
Subcritical asked 8/12, 2022 at 18:18
2
Solved
I am running through the tutorial.example on https://developer.ibm.com/tutorials/spring-with-db2-via-jdbc/
but cannot get it to work, i keep getting the below error and am unsure how to fix.
No q...
Folderol asked 4/9, 2019 at 13:50
10
Solved
Is it possible? Can i specify it on the connection URL? How to do that?
Capernaum asked 12/11, 2010 at 20:15
© 2022 - 2024 — McMap. All rights reserved.