Tagged Questions
0
votes
0answers
20 views
How to use same domain class for HBase and PostgreSQL
I have domain objects that are stored in both HBase and PostgreSQL.
While defining the class the annotations used for PostgreSQL are not applicable to HBase, so I end up defining two classes with the ...
0
votes
0answers
14 views
Use JDBI to get Postgres Array Data
I have a java program using JDBI (a JDBC wrapper) to access a PostgreSQL database. One of the columns is of the array data type (mycolumn integer[]).
What the heck to I use in my mapper class? I ...
0
votes
2answers
29 views
htop and top showing multiple instances of process?
I am currently running a java process with ant. I am running just one process.
When I use htop, I am seeing the following information:
scrolling right gives:
basically, the middle section is ...
0
votes
1answer
22 views
jdbc postgresql transaction error occurred
public class JDBC {
static Connection con;
static Statement stmt;
public static void main(String argv[]){
connect();
con.setAutoCommit(false);
// Statement s= conn.createStatement();
...
0
votes
1answer
30 views
JDBC ERROR: operator does not exist: date = integer
String checkAvailable_flight = String.format("SELECT Flightid, flightdate,"
+ " origin, destination FROM flight"
+ " WHERE Flightdate::Date = %s AND origin = %s"
...
0
votes
2answers
29 views
How to get large data with JDBC and PostgresSQL
I'm trying to fetch millions data from my table, and I'm using Java Play Framework 2.0 but there is some issue. When I set limit to my query it works well and if I ask for all the data it throws error ...
9
votes
2answers
52 views
JDBC what's the purpose of PreparedStatement#setNull
I did an experiment with a table having a VARCHAR column with null values trying to get the number of rows that have a specific column NULL. I used three forms:
form A
SELECT COUNT(*) FROM buyers ...
0
votes
2answers
12 views
Error connection to herokupostgresql locally
I am writing a struts2 app and using hibernate for persistence. I deploy may app on heroku and everything works ok, but when ever I run it locally I get:
org.postgresql.util.PSQLException: FATAL:no ...
heroku
0
votes
1answer
27 views
Transfer regex from Java to PostgreSQL
How can I transfer the following regex from Java to PostgreSQL syntax:
Pattern.compile("(?imu)(P\\W*Ř\\W*E\\W*D\\W*V\\W*O\\W*L\\W*Á\\W*N\\W*Í)"));
I have tried:
select regexp_matches('P Ř E D V O ...
3
votes
1answer
42 views
MyBatis special result when select returns no rows
My MyBatis select is
// result map that sub-selects a folder
<resultMap id="beanWithFolderMap" type="com.example.BeanWithFolder">
<id column .../>
<association ...
0
votes
1answer
29 views
Remove with entitymanager sometimes fails
I've a problem with removing persisted objects from my database.I have some tables with bidirectional relationships between them. I've a test for removing an object that is still referenced by an ...
0
votes
1answer
44 views
Add Social Functionality To Play App [closed]
I am creating the backend of my mobile application in Play. I have several different models and one of them is a Users model. I would like to have Users be able to add each other (similar to Facebook ...
1
vote
2answers
65 views
why does executeUpdate return 1 even if no new row has been inserted?
here is my very simple table (Postgres):
CREATE TABLE IF NOT EXISTS PERFORMANCE.TEST
(
test text NOT NULL UNIQUE
);
if I try to insert a String using the command below FROM the database,everything ...
0
votes
2answers
61 views
How to set postgres schema in play framework
We are using play framework 2.1 in our web application. We want to explicitly set the database schema(not public schema) in our postgresql database which will be used. How can set it ?
Thanks
2
votes
1answer
99 views
No Suitable Driver found Postgres JDBC
I am receiving a "no suitable driver found" error when I test my web service on tomcat. I have the JDBC .jar in the lib folder as various tutorials says to do. Here is my code:
public class ...
