What JDBC 3.0 features matter? Are many developers storing XML data directly in the database? On behalf of data connectivity company DataDirect Technologies, we recently emailed a small group of TSS subscribers to take part in a survey on their JDBC and XML usage habits. The results were interesting enough that we decided to publish them here for everyone's benefit. This is the first of many more surveys to come, which will hopefully be useful to the community.
If you have any ideas for surveys, please drop us a line and let us know!
Completed responses: 303
1. What relational databases are you using JDBC to connect with?
Option
Count
Percent
Cum. count
Cum. percent
Cum. sum
1. Oracle
227
37.46%
227
37.46%
227
2. SQL Server
90
14.85%
317
52.31%
407
3. DB2
82
13.53%
399
65.84%
653
4. Sybase
40
6.6%
439
72.44%
813
5. Progress
4
0.66%
443
73.1%
833
6. Informix
18
2.97%
461
76.07%
941
7. MySQL
101
16.67%
562
92.74%
1648
8. None
4
0.66%
566
93.4%
1680
9. Other
40
6.6%
606
100.0%
2040
Total
606
100%
606
100%
2040
Total responses:
299
2. If you're using MySQL, what would you like to see in a third-party driver that is not provided by the open source driver?
Option
Count
Percent
Cum. count
Cum. percent
Cum. sum
1. Yes
62
23.13%
62
23.13%
62
2. No
64
23.88%
126
47.01%
190
3. Not using MySQL
142
52.99%
268
100.0%
616
Total
268
100%
268
100%
616
Total responses:
268
3. What Java Virtual Machine version(s) are you using?
Option
Count
Percent
Cum. count
Cum. percent
Cum. sum
1. 1.2
37
8.51%
37
8.51%
37
2. 1.3
188
43.22%
225
51.72%
413
3. 1.4
210
48.28%
435
100.0%
1043
Total
435
100%
435
100%
1043
Total responses:
297
4. Are JDBC 3.0 features an important consideration when selecting a JDBC driver?
Option
Count
Percent
Cum. count
Cum. percent
Cum. sum
1. Yes
144
48.98%
144
48.98%
144
2. No
150
51.02%
294
100.0%
444
Total
294
100%
294
100%
444
Total responses:
294
5. If yes, then which JDBC 3.0 features are important?
Option
Count
Percent
Cum. count
Cum. percent
Cum. sum
1. Prepared Statement Pooling
117
20.0%
117
20.0%
117
2. BLOB and CLOB Updates
86
14.7%
203
34.7%
289
3. Multiple Open Resultsets
90
15.38%
293
50.09%
559
4. Savepoints
43
7.35%
336
57.44%
731
5. Parameter MetaData
40
6.84%
376
64.27%
931
6. Retrieval of Auto-Generated Keys
73
12.48%
449
76.75%
1369
7. ResultSet Holdability
70
11.97%
519
88.72%
1859
8. Named Parameters
66
11.28%
585
100.0%
2387
Total
585
100%
585
100%
2387
Total responses:
162
6. Are any of the following features important in selecting a JDBC driver?
Option
Count
Percent
Cum. count
Cum. percent
Cum. sum
1. OS Authentication
79
36.41%
79
36.41%
79
2. Encryption, SSL
138
63.59%
217
100.0%
355
Total
217
100%
217
100%
355
Total responses:
167
7. If you are planning on using a JDBC RowSet (JSR-114) implementation, which will you use?
Option
Count
Percent
Cum. count
Cum. percent
Cum. sum
1. Sun's RowSet Implementation
95
33.45%
95
33.45%
95
2. A third-party RowSet Implementation
28
9.86%
123
43.31%
151
3. I have no plans to use a RowSet implementation
161
56.69%
284
100.0%
634
Total
284
100%
284
100%
634
Total responses:
284
8. If you're using/planning to use J2EE Connector Architecture Resource Adapters to connect to databases, which will you use?
Option
Count
Percent
Cum. count
Cum. percent
Cum. sum
1. Sun's "JDBC Connector"
112
41.48%
112
41.48%
112
2. A third party JDBC Adapter
75
27.78%
187
69.26%
262
3. Neither
83
30.74%
270
100.0%
511
Total
270
100%
270
100%
511
Total responses:
270
9. Does your application use XML documents from data that originated in a relational database?
Option
Count
Percent
Cum. count
Cum. percent
Cum. sum
1. Yes
193
65.42%
193
65.42%
193
2. No
102
34.58%
295
100.0%
397
Total
295
100%
295
100%
397
Total responses:
295
10. Does your application process XML and then store it as data in a relational database?
Option
Count
Percent
Cum. count
Cum. percent
Cum. sum
1. Yes
204
69.39%
204
69.39%
204
2. No
90
30.61%
294
100.0%
384
Total
294
100%
294
100%
384
Total responses:
294
11. Do you think it is better to take a query-based approach to mixing XML with relational data, or do you think it is better to hand code?
Option
Count
Percent
Cum. count
Cum. percent
Cum. sum
1. Query-based approach
179
65.09%
179
65.09%
179
2. Hand-code
96
34.91%
275
100.0%
371
Total
275
100%
275
100%
371
Total responses:
275
12. Have you evaluated SQL/XML?
Option
Count
Percent
Cum. count
Cum. percent
Cum. sum
1. Yes, and I'm using it
30
10.24%
30
10.24%
30
2. Yes, I have some familiarity with it
33
11.26%
63
21.5%
96
3. No, but I've heard of it
122
41.64%
185
63.14%
462
4. Never heard of it
108
36.86%
293
100.0%
894
Total
293
100%
293
100%
894
Total responses:
293
13. Have you evaluated early editions of XQuery?
Option
Count
Percent
Cum. count
Cum. percent
Cum. sum
1. Yes, I plan to use it
18
6.16%
18
6.16%
18
2. Yes, I have some familiarity with it
31
10.62%
49
16.78%
80
3. No, but I've heard of it
139
47.6%
188
64.38%
497
4. Never heard of it
104
35.62%
292
100.0%
913
Total
292
100%
292
100%
913
Total responses:
292
14. What tools (if any) are you currently using to access the data and integrate it with a web publishing system:
Option
Count
Percent
Cum. count
Cum. percent
Cum. sum
1. JDBC/Java only
248
52.88%
248
52.88%
248
2. XSLT
149
31.77%
397
84.65%
546
3. SQL/XML
56
11.94%
453
96.59%
714
4. XQuery
16
3.41%
469
100.0%
778
Total
469
100%
469
100%
778
Total responses:
280
15. How complex is to transform your relational data to display on a web page?