Re: do XA connections support SSL?

Kris,

thanks for your comments. I decided to try to patch the XA datasource
code. Luckily the datasource relies heavily on the pgjdbc driver which
already supports SSL. I'm no pgjdbc expert so I might have done
something wrong. In any case, the patch below works for me. I post it
here for anyone looking for XA with SSL support.

In the XA datasource descriptor you'll have to add:
<xa-datasource-property name="Ssl">true</xa-datasource-property>

Best regards,
Stefan

--- BaseDataSource.java Thu Apr 06 09:54:43 2006
+++ BaseDataSource.patched.java Thu Apr 06 09:51:39 2006
@@ -47,6 +47,7 @@
private String databaseName;
private String user;
private String password;
+ private boolean ssl = false;
private int portNumber;
private int prepareThreshold;
private int loginTimeout; // in seconds
@@ -262,13 +263,28 @@
}

/**
+ * Is SSL enabled?
+ */
+ public String isSsl() {
+ return ""+ssl;
+ }
+
+ /**
+ * Enable or disable SSL.
+ * @param ssl enable or disable SSL.
+ */
+ public void setSsl(String ssl) {
+ this.ssl = Boolean.valueOf(ssl).booleanValue();
+ }
+
+ /**
* Generates a DriverManager URL from the other properties supplied.
*/
private String getUrl()
{
return
"jdbc:postgresql://" + serverName + (portNumber == 0 ? "" :
":" + portNumber) + "/" + databaseName +
- "?loginTimeout=" + loginTimeout + "&prepareThreshold=" +
prepareThreshold;
+ "?loginTimeout=" + loginTimeout + "&prepareThreshold=" +
prepareThreshold + (ssl?"&ssl=true":"");
}

/**
@@ -301,6 +317,7 @@

ref.add(new StringRefAddr("prepareThreshold",
Integer.toString(prepareThreshold)));
ref.add(new StringRefAddr("loginTimeout",
Integer.toString(loginTimeout)));
+ ref.add(new StringRefAddr("ssl", Boolean.toString(ssl)));
return ref;
}

@@ -313,6 +330,7 @@
out.writeInt(portNumber);
out.writeInt(prepareThreshold);
out.writeInt(loginTimeout);
+ out.writeBoolean(ssl);
}

protected void readBaseObject(ObjectInputStream in) throws
IOException, ClassNotFoundException
@@ -324,6 +342,7 @@
portNumber = in.readInt();
prepareThreshold = in.readInt();
loginTimeout = in.readInt();
+ ssl = in.readBoolean();
}

}