Java Database Q&A Questions and Answers

1. Java Database Q&A

Blob /

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

cassandra /

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

column /

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

Connection /

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

Cursor /

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

dao /

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

Data Type /

Integer 56	timestamp 69

Database /

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

Database Product /

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

DataSource /

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

Date /

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

db2 /

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

derby /

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

Development /

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

Driver /

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

Exception /

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

file /

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

hadoop /

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

hbase /

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

hsqldb /

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

ibatis /

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

JDBC /

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

memcached /

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

mongodb /

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

MS Access /

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

mysql /

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

ODBC /

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

Operation /

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

oracle /

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

postgresql /

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

Record /

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

result /

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

Resultset /

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

Schema /

Schema 59

SQL /

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

sqlite /

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

SQLserver /

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

Statement /

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

stored procedure /

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

sybase /

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

Table /

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

Transaction /

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

Trigger /

Trigger 45