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

AltStyle によって変換されたページ (->オリジナル) /