Stack Overflow
Stack Overflow

Questions tagged [jdbc-postgres]

jbdc-postgres is the JBDC (Java Database Connectivity) driver for the PostgreSQL database system.

JDBC is a core API of Java 1.1 and later. It provides a standard set of interfaces to SQL-compliant databases.

PostgreSQL is an open source object-relational database system.

Helpful links:

See also

48 questions
0
votes
1 answer

Connection issues with fuse esb when connecting to postgresql database

I am trying to connect fuse esb with postgresql database. Postgresql database is the latest version (12.6) and the driver provided by fuse is "postgresql-9.1-901.jdbc4.jar" (osgi) under jdk 1.7. Bellow issues are seen. when checking the connection…
Nishantha Pradeep
  • 87
  • 1
  • 1
  • 9
0
votes
1 answer

Does jcs JDBC Disk Cache works with postgres?

Does jcs JDBC Disk Cache works with postgres? I saw in jcs documetation that jcs JDBC Disk Cache is supported with Oracle,MySQL and hsql, since its jdbc, does it support postgres? If yes does it support ssl enabled database connection?
rajukemburi
  • 31
  • 6
0
votes
0 answers

Can't connect to Postgres DB through Apache Tomcat?

I'm trying to set up Geoportal 1.2.4, running on Apache Tomcat 8.5.6, Postgres 9.0.6_1, JDK 6, and jdbc(postgresql-9.1-901.jdbc4.jar). I cannot log into the Geoportal, When I log in using admin details (),I get this error "A database communication…
Nisha
  • 1,783
  • 4
  • 18
  • 34
0
votes
1 answer

IBMCloud - Connecting to PostgreSQL DB through JDBC (SSL Enabled)

I am trying to connect to IBM Cloud PostgreSQL DB with Java (SSL Enabled. But while making a connection, i get the following error - [7/31/19 10:48:46:952 UTC] 0000007a id= R …
user1670771
  • 21
  • 1
0
votes
1 answer

Scala Slick: cannot get parameters in query

I have just spent hours on this. I'm trying to make a pretty complicated query in PostgreSQL through Slick in Scala, but Slick will NEVER take any of my parameters into account. If I try something as simple as: def get(location: String) = { val…
eje211
  • 2,385
  • 3
  • 28
  • 44
0
votes
0 answers

A ClassNotFundExxseption error occurs when the registration and initialization command is executed

I have java project JavaProject4. In folder lib, I added file postgresql-42.2.2.jre7.jar (postgres driver). Next, I execute the following command: Class.forName("org.postgresql.Driver").newInstance(); The command terminates with an error: type:…
Anton
  • 163
  • 2
  • 14
0
votes
1 answer

Add jdbc postgre driver to jar

I'm building a java server program that connects to a psql database with JDBC drivers. I need to compile the program in a .jar file, but when I try to do so and run it, I get this exception. (the program has to run on a linux…
Federico Taschin
  • 2,027
  • 3
  • 15
  • 28
0
votes
0 answers

JDBC and Postgresql exception on main

thank you for any input. I am getting the below error message. I am running JDBC with postgresql and attempting to run 9 queries on my query.txt file that I have. The tables were created and values inserted according to the console message below.…
AMMOTECH
  • 21
  • 6
0
votes
1 answer

Rows retrieved from Postgres using JDBC are all the same

Below is a function that loads rows into an array of Records. private static List LoadFromDb(String query, Connection connection, long take, long skip, Date minDate) { PreparedStatement preparedStatement = null; ResultSet resultSet =…
Keith Phillips
  • 1
0
votes
0 answers

Whole Batch aborted if any single record failed due to some restriction?

I am using Postgre sql as backend. I am connecting using postgre jdbc driver. I am executing batch of 5 records. I have put unique constartins in one column. Now after 5 record adding into batch, I am executing batch. Now when I am executing this…
Nikunj Patel
  • 104
  • 1
  • 7
0
votes
1 answer

schema.rb - dump errors - NoMethodError undefined method `default_function'

I went to look at my schema.rb file and found the following: ActiveRecord::Schema.define(version: 20140729164926) do # Could not dump table "account_services_indices" because of following NoMethodError # undefined method `default_function'…
mpipkorn
  • 153
  • 2
  • 9
0
votes
0 answers

JDBC issue reading ande writing Bytes

I am trying to migrate my java application from PostgreSQL 8.4 to latest release. I am facing an issue with reading the byte data from the db. I am inserting the IpAddress in bytes in to the table and trying to reconstruct it back in a different…
HSK
  • 55
  • 4
0
votes
2 answers

JRuby - jdbc-postgres no suitable driver found for jdbc:postgresql when running from JAR

I am getting a 'No suitable driver found' error when running my jar generated with warbler. However when I run it as ruby the code succeeds. The command to load the driver returns true, leading me to believe it can still load the driver while in the…
zack
  • 11
  • 3
0
votes
0 answers

PGSQL JDBC BLOB Update giving error

I have previously downloaded some files and stored them in a PGSQL database. I have used 'bytea' type for the 'content' column where I store the file content as a binary stream. Now, if the file has been updated (at the original source that hosts…
Rocky Inde
  • 1,511
  • 1
  • 20
  • 27
0
votes
1 answer

postgres 9 | jdk 7.45 | irregular "No results were returned by the query"

this thing is making me stupid for nothing since yesterday (googled a lot without finding any other developer with the same problem). I'm upgrading an application server written in java (jdk5), which uses postgresql 7, to jdk7 using postgresql…
Massimiliano Carli
  • 21
  • 7
1 2
3
4