Java Database Q&A Questions and Answers





Blob /

Blob 97byte 14
Clob 36column 13
convert 10db4o 2
file 17getBytes 3
image 21inputstream 5
Insert 28outputstream 4
PDF 4read 26
ResultSet 3retrieve 13
save 8serialize 4
sql 14store 16
stream 4string 24
Update 9

cassandra /

c 1cassandra 21
client 4concurrency 2
connect 3CQL 2
Hector 8Insert 5
nosql 10pelops 2
Row 2

column /

column 52index 7
Name 15NULL 3
number 7retrieve 5
row 9select 4
Type 8value 13

Connection /

applet 14bonecp 5
c3p0 8Cache 6
close 80commit 6
connect 1 100connect 2 100
connect 3 39Connection 1 100
Connection 2 100Connection 3 100
Connection 4 100Connection 5 100
Connection 6 100Connection 7 48
connectionpool 23databaseconnection 18
DBCP 19driver 42
DriverManager 10dsn 20
eclipse 5ejb 5
error 1 100error 2 9
Excel 9Exception 27
h2 44j2me 12
JavaDB 10JBoss 7
jdbcodbc 12jndi 17
jtds 5linux 6
Multiple connection 26MultipleThread 9
network 18NullPointerException 8
odbc 25password 9
performance 9pool 1 100
pool 2 100pool 3 100
pool 4 1PreparedStatement 17
Query 19reset 8
ResultSet 24rollback 7
server 51session 9
Sevlets 41Singleton 13
Socket 8sql 77
SQLException 18Statement 39
thread 15transaction 11
URL 17weblogic 14
websphere 6Windows 6

Cursor /

close 5Cursor 43
Error 13EVICT 1
exception 8invalid cursor state 13
maximum open Cursor exceeded 13position 5
procedure 8REF 8
SQLException 5

dao /

dao 77DTO 11
easymock 2Entity 5
Generic 8Interface 4
junit 3Layer 6
Manager 4model 5
mvc 4oop 4
pattern 16persist 4
service 8synchronized 2
test 6

Data Type /

Integer 56timestamp 69

Database /

connectivity 66Data 1 100
Data 2 96Entity 20
field 28grails 9
Image 53jdbc 1 100
jdbc 2 100jdbc 3 100
jdbc 4 100jdbc 5 100
jdbc 6 100jdbc 7 76
junit 12load 27
MultipleThread 16nosql 16
password 27performance 22
persist 30Quartz 21
retrieve 52row 31
save 38search 29
security 14server 52
thread 19xml 49

Database Product /

Berkeley 30couchdb 11
db4o 34H2 48
informix 19javadb 51
neo4j 29Redis 16

DataSource /

configuration 8Connection 29
Container 5context 10
dao 5datasource 1 100
datasource 2 100datasource 3 63
Driver 12DriverManager 15
eclipse 4ejb 6
encrypt 1ibatis 2
ireport 5jasperReport 11
jboss 16jetty 3
jndi 23jta 3
lookup 7name 8
oc4j 3ODBC 16
pool 24Quartz 8
Resource 5server 7
SQLException 4transaction 6
weblogic 8websphere 8
XAConnection 4

Date /

Calendar 7Cast 5
column 9compare 14
convert 17current 12
date 1 100date 2 51
datetime 8day 5
epoch 2extract 3
format 30gmt 2
grails 1hour 2
ibatis 1Insert 23
integer 2month 8
Parse 6pattern 3
PreparedStatement 6Primary Key 2
query 15resultset 7
Retrieve 10SELECT 6
SetDate 4simpledateformat 6
soap 1statement 8
String 16table 7
tapestry 1time 18
Timestamp 16timezone 6
year 5yyyyMMdd 4

db2 /

AS400 7Batch 5
BIT 2blob 5
CallableStatement 2character 7
clob 3COM 3
connect 27Connection 26
connectivity 5Cursor 5
Datasource 7date 11
db2 1 100db2 2 6
dbunit 1deadlock 3
driver 34encoding 3
Error 24exception 8
insert 5iSeries 7
jboss 2jcc 4
jndi 2join 4
linux 5lock 3
log 2mainframe 6
mybatis 1password 3
performance 4pool 6
preparedStatement 6Quartz 3
query 9ResultSet 6
retrieve 10row 3
schema 5sql 12
SQLCODE 5SQLException 5
SQLSTATE 2squirrel 1
standalone 2stored procedure 20
syntax 2SYSPROC 2
table 11teradata 1
timestamp 3transaction 2
trigger 1UDB 6
unicode 3weblogic 2
websphere 7Windows 4
xml 7zip 3

derby /

BLOB 4ClassNotFoundException 6
classpath 4column 8
connect 16connection 14
date 7Delete 6
derby 81driver 10
eclipse 9embed 17
error 11exception 8
insert 11jar 12
javadb 17jdo 3
Log 5memory 4
netbeans 28performance 3
platform 4query 12
schema 4SELECT 8
Server 10sql 12
SQLException 8Statement 7
Stored procedure 3table 13
Update 6

Development /

applet 57binding 19
classnotfoundexception 20executeUpdate 24
getConnection 10jndi 25
Linux 19Log 35
pagination 25sequence 25

Driver /

CLASSPATH 6dbf 4
Driver 1 100Driver 2 100
Driver 3 100Driver 4 28
Error 29excel 7
exception 10jar 14
jdbcodbc 15jtds 8
jts 2load 64
Microsoft 7msaccess 5
No suitable driver 14OCI 6
Performance 5register 8
solr 3sql 3
sqlexception 31Thin 17
TYPE 88

Exception /

applet 2connectivity 7
Error 1 100Error 2 100
Error 3 100Error 4 98
excel 1exception 1 100
exception 2 73file 1
Image 3jdbcodbc 4
sqlexception 1 100sqlexception 2 16

file /

file 1 100file 2 100
file 3 100file 4 81

hadoop /

algorithm 15cache 11
Cascade 4cassandra 9
cloudera 20cluster 22
DFS 13eclipse 14
hadoop 1 100hadoop 2 100
hadoop 3 82HDFS 61
hive 59jobs 28
join 13key 22
linux 14log 17
lucene 12mahout 23
map 45Mapper 17
mapreduce 1 100mapreduce 2 62
namenode 16nosql 6
nutch 13pig 35
piglatin 24plugin 9
process 25reduce 29
reducer 14Sort 13
stream 22task 14
wordcount 16

hbase /

BigTable 8cassandra 5
cluster 4couchdb 7
datanucleus 3Distribute 4
grails 6hbase 1 100
hbase 2 3hdfs 16
hive 9hypertable 7
install 5jdo 5
mapreduce 14master 5
mongodb 3mysql 6
nosql 9olap 4
Query 6row 24
scan 5schema 8
sql 6table 19
zookeeper 9

hsqldb /

ant 3blob 1
client 3CLOB 2
column 2connection 3
Datasource 2dbunit 1
derby 5driver 3
Eclipse 3embed 1
Error 3exception 2
firebird 1grails 1
h2 3hsqldb 34
insert 3jboss 2
jdbc 32jdbcDriver 3
JUnit 3memory 7
odbc 2persist 2
pool 1Quartz 1
query 3SELECT 2
sql 7statement 2
table 12unit test 2

ibatis /

c 6collection 2
column 4configuration 1
dao 3datamapper 2
ibatis 54iBATOR 3
inheritance 3iterate 5
jdbc 5map 6
mapper 4mybatis 11
nhibernate 4parameter 4
resultMap 4SqlMap 5
tutorial 3XML 4

JDBC /

batch 7Binding 5
CachedRowSet 42CallableStatement 76
char 4clause 4
close 11column 6
compile 7DriverManager 32
Error 24forName 64
Insert 21MultipleThread 3
null 11NullPointerException 6
Parameter 10performance 14
precompile 3PreparedStatement 1 100
PreparedStatement 2 100PreparedStatement 3 42
query 24resultset 1 100
resultset 2 16rowset 36
select 11setNull 5
setString 6sql 73
sqlexception 4sqlInject 1
Stored procedure 5string 9
Table 10Update 18
variable 3WHERE 8

memcached /

cdi 1Distribute 2
Distributecache 2ehcache 1
gigaspaces 1key 3
lock 1membase 2
memcached 18memory 2
nhibernate 1serialize 3
sharding 1spymemcached 5
Xmemcached 2

mongodb /

Array 2bson 3
c 2collection 5
connect 3connection 7
couchdb 1dbobject 1
driver 23embed 4
error 3Exception 5
field 2find 6
grails 3gridfs 3
groovy 1hadoop 4
ID 1insert 8
integration 2javascript 4
jersey 2json 5
key 2mapreduce 4
mongodb 31Morphia 12
nest 4nosql 5
pattern 1playframework 3
quartz 2query 25
RDBMS 1regex 2
REST 1retrieve 1
save 2search 2
sql 1

MS Access /

applet 5connect 33
connection 16connectivity 6
date 15Driver 16
dsn 11Error 8
excel 7file 7
Insert 20jdbcodbc 5
linux 5mdb 3
MS Access 1 100MS Access 2 42
msaccess2007 6odbc 14
OLE 4Preparedstatement 6
query 9sql 7
table 11unicode 2
unix 4update 9
Windows 4

mysql /

Applet 29array 16
arraylist 5backup 15
binding 2BLOB 18
bridge 2c3p0 6
character 31ClassNotFoundException 9
column 18connect 1 100
connect 2 100connect 3 18
connection 1 100connection 2 93
connectivity 19Connector 22
convert 17csv 13
datasource 23Date 71
datetime 7dbunit 5
derby 14desktop 14
Driver 1 100Driver 2 59
dsn 4eclipse 18
embed 10encoding 5
encrypt 6enum 5
Error 42excel 16
exception 40flex 5
grails 5hadoop 6
host 7hsqldb 3
ibatis 8Image 38
innodb 6Insert 83
install 19integrity 2
key 14ldap 2
linux 13login 8
lucene 7md5 3
MDB 1memcached 2
memory 12mongodb 2
mysql 1 100mysql 2 100
mysql 3 100mysql 4 100
mysql 5 100mysql 6 100
mysql 7 100mysql 8 100
mysql 9 14mysqldump 8
odbc 2password 13
pattern 2performance 12
postgresql 7PreparedStatement 23
primary key 5Query 1 100
Query 2 32record 15
regex 4relational 2
resultset 33Retrieve 34
row 50search 9
security 8Socket 6
solaris 5solr 6
sql 1 100sql 2 54
statement 17stored procedure 17
String 63table 80
timeout 10timezone 4
transaction 11trigger 11
tutorial 5unicode 13
update 50upload 9
web service 10windows 14

ODBC /

Access 33bridge 17
c 3cursor 8
driver 17JDBCODBC 2
JdbcOdbcDriver 7msaccess 7
ODBC 94oledb 2
Resultset 4sql 5
SQLException 5Windows 6

Operation /

batch 46Bulk 5
character 17column 28
concurrent 7delete 16
error 28excel 13
Exception 14execution 8
field 18file 21
h2 8ibatis 20
ID 9Image 23
insert 1 100insert 2 94
msaccess 17mybatis 9
parameter 13performance 18
Primary key 5query 1 100
query 2 100query 3 100
query 4 10Record 59
Result 44row 47
select 43session 5
sql 1 100sql 2 100
sql 3 77SQLException 9
String 21table 73
text 15update 1 100
update 2 39variable 14
xml 10

oracle /

adf 8applet 11
batch 9binding 7
blob 48bpel 7
callableStatement 11certification 13
Char 8character 16
ClassNotFoundException 19classpath 8
clob 35coherence 7
column 62connect 1 100
connect 2 9connection 98
connectivity 23csv 8
cursor 34DataSource 12
date 33datetime 10
db2 11DBMS 4
dbunit 5derby 3
driver 1 100driver 2 20
eclipse 21ejb 9
encoding 7Error 64
excel 9exception 27
fetch 13flex 1
form 12ibatis 20
Image 29import 17
insert 53ivy 1
jar 24jboss 10
jdeveloper 5jdk 26
jmeter 21jms 8
jndi 7jvm 14
Linux 9log 12
memory 10middleware 3
Migrate 20mysql 22
netbeans 56nls 12
oc4j 5oci 12
odbc 8ora 1
OracleDriver 14performance 25
plsql 47pool 26
Portlet 11postgresql 7
Prepared Statement 1PreparedStatement 27
quartz 15Query 45
resultset 34retrieve 23
Row 16security 9
sequence 22Sevlets 33
special 9SQL 1 100
SQL 2 100SQL 3 63
SQLException 8sqlldr 5
stored procedure 60string 53
thread 15timestamp 15
transaction 21trigger 10
unicode 5unix 8
URL 16user 25
Validation 3Web Service 42
weblogic 23websphere 14
windows 18

postgresql /

blazeds 2blob 4
classpath 2clojure 3
column 11connection 16
Cursor 4DataSource 1
Date 9Debug 2
derby 2driver 15
eclipse 3error 14
Grails 1hadoop 1
ibatis 4import 4
insert 11jboss 3
jdbctemplate 4jms 1
key 5LIKE 6
linux 5locale 1
lucene 3memory 6
odbc 2performance 5
postgis 3postgresql 1 100
postgresql 2 3Preparedstatement 13
query 13resultset 4
row 7schema 2
sql 10statement 5
Stored procedure 12timestamp 4
transaction 8trigger 2
Unicode 1

Record /

Count 6delete 16
display 10duplicate 5
Fetch 12find 7
lock 5move 1
multiple 6next 4
page 5previous 2
read 2Record 1 100
Record 2 10retrive 3
total 3

result /

column 2empty 5
huge 3loop 3
memory 4null 7
result 1 100result 2 17
retrieve 7row 7
Scrollable 5

Resultset /

array 22arraylist 13
cache 4close 36
column 21convert 17
csv 4cursor 9
empty 19Error 20
exception 24format 4
FORWARD 4getString 10
getTimeStamp 4Iterate 9
memory 6next 22
null 12operation 11
performance 10plsql 6
populate 4Query 29
read 11record 27
Resultset 1 100Resultset 2 100
Resultset 3 100Resultset 4 100
Resultset 5 100Resultset 6 11
retrieve 15row 45
SCROLL 8Scrollable 20
session 5size 18
sql 28SQLException 22
stored procdure 1String 13
table 16TYPE 18
updatable 11update 13
Updateable 6write 9

Schema /

Schema 59

SQL /

array 5arraylist 2
c 4clause 3
column 20convert 23
dao 2data 53
Editor 2Error 78
excel 2exception 99
execute 29Expression 4
file 39fitnesse 1
generator 2groovy 3
ibatis 19index 22
Inject 23integration 2
invalid 26jar 4
jdbc 1 100jdbc 2 100
jdbc 3 100jdbc 4 94
key 5Loader 5
mybatis 2Parameter 25
parse 6parser 4
performance 2result 32
row 23Script 21
Search 19security 2
select 20sort 4
SQL 1 100SQL 2 100
SQL 3 60SQLException 85
strategy 2string 29
syntax 23Time 18
xsd 2

sqlite /

birt 2blob 3
concurrency 5connect 6
connection 7datasource 1
date 4db4o 1
derby 3driver 12
eclipse 2encrypt 7
exception 2firefox 1
groovy 1HashMap 3
image 3insert 8
j2me 3jar 6
jdo 1key 6
midp 1netbeans 26
odbc 2ormlite 3
PreparedStatement 5query 9
Read 7resultset 4
row 6sqlexception 5
sqlite 76sqlite4java 3
sqlitejdbc 7statement 2
table 7update 6
wrapper 2

SQLserver /

connect 1 100connect 2 20
DATE 15driver 91
error 21exception 26
image 17insert 48
jtds 32mysql 20
odbc 22oracle 41
PreparedStatement 8sql 63
SQLserver 1 100SQLserver 2 100
SQLServer 2000 59SQLserver 2005 18
SQLServer 2008 26SQLserver 3 100
SQLserver 4 100SQLserver 5 2
SQLserver2005 33SQLserver2008 35
stored procedure 16

Statement /

Batch 9Callable 29
close 23column 7
DELETE 3Error 15
execute 15ibatis 6
Insert 33interface 7
join 4multiple 11
Parameter 10query 14
ResultSet 19select 28
setFetchSize 4SQLException 9
Statement 1 100Statement 2 68
syntax 13update 19
variable 10

stored procedure /

Array 8Call 41
OUT 4Parameter 4
retrieve 3return 8
stored procedure 1 100stored procedure 2 19

sybase /

column 5connect 7
connection 6datasource 3
Date 2dbcp 1
driver 4FILE 5
ibatis 3Insert 4
jconnect 3jtds 2
Powerbuilder 2Quartz 2
Query 4resultset 5
sql 7stored procedure 10
sybase 56websphere 1

Table /

Column 23Data 45
delete 12dynamic 4
excel 3fetch 14
field 16ibatis 2
Index 7JOIN 74
key 14lock 18
multiple 13Name 30
plsql 2read 18
Record 17Retrieve 20
row 15Select 16
SQL 43Table 1 100
Table 2 100Table 3 58
Temporary 9value 18

Transaction /

commit 10Distribute 16
EJB 21ejb3 23
JBoss 13jms 10
JTA 30rollback 44
timeout 13transaction 1 100
transaction 2 100transaction 3 100
transaction 4 46Web Service 21

Trigger /

Trigger 45