Tagged Questions

1
vote
2answers
57 views

Effective way of constructing MySQL query in Java

I am developing a portlet in which I access a database quite often. I have to specify the query in a way, that offers the possibility of filtering as a reaction on a user input. The parameters used ...
0
votes
1answer
32 views

sql query to insert rows from one record in one table into the same table with slight modifications [closed]

I have an sql server table in which i have 30 columns I need to know if the following can be done or not I need to write an sql qyery to copy records in the table into the same table with the 28 ...
0
votes
1answer
10 views

Connect Joomla and Java App

currently we are developing a JAVA APP that runs on TOMCAT and uses POSTGREE SQL And we have an introducting website (JOOMLA 2.5 based) that explains the app, and also have a register module, that ...
0
votes
1answer
35 views

Java MySQL Table

I have two java processes namely Ticket Creation and Billing Daemon. Both of these processes use same MySQL Innodb Table "Billing". Ticket Creation mainly creates billing ticket and it includes ...
1
vote
3answers
33 views

How to change inserted values to uppercase using MYSQL

For example I have a web page that inserts values in my MYsql database...then I have this kind of query in my java code insert into orgdetails values (?, ?, ?, ?, ?, ?, ?) I tried to put UPPER ...
-1
votes
1answer
23 views

Opening and closing DB connection when using multiple threads

i am updating my db from a couple of threads and i am not sure where exactly to close the connection from. i amusing java jdbc. Thread t= new Thread(new Runnable() { @Override public ...
2
votes
1answer
68 views

How to do inner looping in java collection?

My SQL returns the values as like below. enter code here studentid studentname playid gamename grade prizes --------- ------------ ----- ------------ ------ ...
0
votes
1answer
22 views

Ebean: @OneToMany to the same Entity

I have the following scenario where a User can make a Reservation on a Campaign. Eg. User wants to reserve a Campaign(eg 20% off on a book). I want the reservation table to look like this: ...
0
votes
1answer
26 views

Hibernate - One to many relation - foreign key always “null”

I have two really simple objects and one object should contain the other one in an "one-to-many" relation in a set. The objects get inserted correctly in the database, but the foreign key in the ...
0
votes
0answers
44 views

Build sql query with java

How to dynamically build this query every time the request parameters are entered? Here I have to retrieve data using only one request parameter, but user enters multiple parameters so I should ...
0
votes
1answer
23 views

java sql ResultSet.deleteColumn

Need to compare the rows in two ResultSets, and retain only the columns that differ. The ResultSet interface has a method deleteRow but there is nothing like deleteColumn. Any workaround? ...
0
votes
0answers
47 views

Can't avoid n+1 in this hql

I am having a trouble and can´t figure this out with hql. I have these entites Presentation: class Presentation{ private Integer presentationId; //ManyToOne private Product product; } ...
0
votes
0answers
58 views

Class cannot be cast

I'm writing a page that has me a login user. In the database I have a table admins: CREATE TABLE IF NOT EXISTS `ePrzychodnia`.`admins` ( `id` INT NOT NULL , `firstName` VARCHAR(45) NOT NULL , ...
0
votes
1answer
31 views

How to process data from large ResultSet without loading them all to memory?

My Database is hosting on mysql server & I'm using Java to analyze data. My issue: after execute 'Select' query will return a 2.5 GB result set. I don't want to load all the data to memory. So ...
0
votes
1answer
33 views

Using a distinct column value as JPA Entity Class Id

I have a situation where I have a join table defined in the database but not both of the single tables referenced in the join. For example: Student_Course -------------- studentID courseID Course ...

1 2 3 4 5 … 259
15 30 50 per page