Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

jdbc sql

2
votes
3 answers
43 views

Can not issue data manipulation statements with executeQuery()

I use com.mysql.jdbc.Driver I need insert and get id. My query: INSERT INTO Sessions(id_user) VALUES(1); SELECT LAST_INSERT_ID() FROM Sessions LIMIT…
java mysql sql database jdbc
asked June 23, 2011 8:16 am CDT
simply denis
0
votes
0 answers
33 views

MySQL query, merge two rows and add another colum as output result

i want to merge two rows and add a column to show the count of similar rows. I don't want to update the table, i just want this as part of select…
mysql sql jdbc
asked June 12, 2011 9:25 pm CDT
Johnydep
0
votes
1 answer
42 views

Building Select Query Using IN(...) Clause

I need to do select * based on a list of input ids, what's the best way of batch select? here's what I have StringBuilder inClause = new…
java mysql sql select jdbc
asked June 8, 2011 8:41 pm CDT
user775187
0
votes
3 answers
52 views

Jdbc connection with java, singleton connection object or spring jdbc connection?

I manipulate postgresql database with java , please help me to choose a development way, Must I create a jdbc singleton object ? create a new…
java sql spring postgresql jdbc
asked June 7, 2011 8:13 am CDT
Florito
1
vote
3 answers
33 views

MySQL syntax error

I have method: @Override public Group getGroupByStudentId(Long studentId) throws SQLException { // TODO Auto-generated method stub Group gr = null;…
java mysql sql jdbc mysql-error-1064
asked May 25, 2011 8:47 pm CDT
BILL
0
votes
3 answers
46 views

Generating a dymamic sql SELECT statement

Hi all I'm having some small trouble trying to dynamicall generate an SQL SELECT statement generated from an entry from a webpage. Basically i have…
java mysql sql jdbc
asked April 19, 2011 9:18 am CDT
JBoy
1
vote
2 answers
40 views

Matcher.quoteReplacement versus preparedstatement

Hi, In my project I have to create insert statements based on the tables passed. So I have two options 1)Write preparedstatement and run it in batch…
java mysql sql jdbc injection
asked March 13, 2011 1:41 pm CDT
Shashwat
0
votes
1 answer
74 views

Map database type to concrete Java class

Background Map a column data type to its corresponding Java class. Problem A query returns meta information from a database: SELECT…
java sql postgresql jdbc metadata
asked March 9, 2011 1:31 pm CST
Dave Jarvis
0
votes
5 answers
64 views

PostgreSql - integer[] best practice

Working on a web app lately I decided to use integer[] in the data model. Having 2 tables, one with articles' data ad second with tags (tad id and…
java sql postgresql jdbc ibatis
asked January 25, 2011 12:20 pm CST
vector
0
votes
1 answers
154 views

Java + sqlite: how to open database as read-only?

I have a large database that I want to open in read-only mode... I'm using SQLiteJDBC and am not sure what to use to get it to work as read-only.…
java sql sqlite jdbc read-only
asked January 1, 2011 8:08 am CST
Jason S
10

jdbc sql

Tagged: jdbc + sql
Related Tags
mysql × 3105
php × 642
postgresql × 429
database × 399
sqlite × 333
query × 290
join × 157
database-design × 96
c# × 91
sql-server × 85
select × 72
query-optimization × 70
asp.net × 66
regex × 55
android × 54
sqlite3 × 53
aggregate-functions × 51
insert × 51
update × 50
phpmyadmin × 50
java × 49
ruby-on-rails × 48
performance × 47
order-by × 47
oracle × 46
html × 44
group-by × 43
database-queries × 42
optimization × 42