Can I access datasource properties programmatically?

[mate of the state]

I had an idea recently to include a description of the database within my
application's XML config file. The idea being that upon initialization of the
app, I could check the datasource to make sure it's setup how it needs to be
for the app to work.

So, I'm wondering if, given a datasource name and a defined datasource (I know
you can't create those programmatically) if I could check the properties of the
datasource to determine things like the database's name, type, etc.

[tzimmerman]

You could use the java.sql.DatabaseMetaData interface to access that
information. The following example gets the version of the database using
Oracle:

<cfscript>
Class = createObject("java","java.lang.Class");
DriverManager = CreateObject("java", "java.sql.DriverManager");
Class.forName("oracle.jdbc.driver.OracleDriver");
con = CreateObject("java", "java.sql.Connection");
con = DriverManager.getConnection("jdbc:oracle:thin:@ser vername:1521:orcl",
"scott", "tiger");
DatabaseMetaData = con.getMetaData();
majorversion = DatabaseMetaData.getDatabaseMajorVersion();
minorversion = DatabaseMetaData.getDatabaseMinorVersion();
writeoutput("Database Version is " & majorversion &"." & minorversion);
</cfscript>

See the java.sql api at
[url]http://brak/SoftwareLib/Trinity/Java/JavaSoft/J2SDK/Docs/1.4/api/index.html[/url].

Ted Zimmerman

[mate of the state]

Sounds neat, but your link is broken. It seems to be lacking a domain name... or appropriate domain suffix...

[tzimmerman]

Sorry about that. Try [url]http://java.sun.com/j2ee/1.4/docs/api/index.html[/url] instead.

Ted Zimmerman

[mate of the state]

Could you guide me towards how to set this code up for a MySQL database? I've been looking around the JAVA documentation most of the morning, but I'm not a JAVA programmer.

[tzimmerman]

Basically you would just have to substitue the mySQL driver and url information
for the ones I used for Oracle:

Class.forName("com.mysql.jdbc.Driver ");
con = DriverManager.getConnection("jdbc:mysql://[host]:[port]/[database] ",
"[username]", "[password]");

HTH

Ted Zimmerman