Java CAPS 6, Using MySQL with JDBC eWay (Repository) - Configuring MySQL Connectivity


In a number of blog entries I used Oracle 9i as the database against which solutions under
discussion were executed. This is dandy for people who have Oracle, which is a
payware piece and quite expensive. For these who don’t have Oracle the examples
would have been less useful. To remedy this situation, and take advantage of
availability of Sun MySQL Community Server as a Free, Open Source software, I
resolved to use My SQL in all blog notes, which require a database, which I
will be developing from now on. For these who care, MySQL is the third most
used RDBMS in the World. Some of the largest web sites in the World use it.See
my blog at http://blogs.sun.com/javacapsfieldtech/entry/mysql_community_server_and_gui
for discussion of how to obtain, install and configure MySQL Community Server
on Windows.


This note discusses how to configure the Java CAPS 6 JDBC eWay (Repository) to connect to
the MySQL Community Server both in XA and non-XA mode. In particular, the note points out an
additional, critical configuration item that is undocumented and is bound to
trip plenty of people. I hope this will save you the time and the trouble of
working out for yourself what the correct incantations are.


 The entire note is contained in Java CAPS 6 JDBC eWay _Repository_ MySQL Configuration.pdf

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

In this Blog I post abstracts of articles / writeups / notes on various aspects of Java CAPS and SOA Suite including solutions, discussions and screencasts. The links to the referenced material are included in the bodies of the abstracts.

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today