Joe
Your example, does, in fact work.
Of course, I needed to modify the Java code to specify a different
database --
none of the MS databases appear to work on Mac OS X (or and non-win
platform) :)
This is enough to get me started -- I will add the flexibility to the
interface so it
will work with any JDBC driver, and any MetaData request.
Thanks
I have never written a wrapper for a Java program & it helps to start
with a
working example, and concise instructions.
You, likely, saved me several hours of frustration.
I think that implementing and deploying this example is a good
illustration of the
value of inline Java.
Someone new to Java, like myself, could take your example and drop it
into a simpleCF template,
between <cfjava,,,/> tags. Then they could add the CFML portion in the
same template. More likely,
you would have provided a complete, standalone CF Template with the
Java code, inline.
Then they could save and test the template without concern for:
1) Separating your file into its Java and CFML component parts.
2) Where to put the Java source
3) How to compile the Java class
4) Which Java compiler options to use and their proper settings --
things such as:
Usage: javac <options> <source files>
where possible options include:
-g Generate all debugging info
-g:none Generate no debugging info
-g:{lines,vars,source} Generate only some debugging info
-O Optimize; may hinder debugging or
enlarge class file
-nowarn Generate no warnings
-verbose Output messages about what the
compiler is doing
-deprecation Output source locations where
deprecated APIs are used
-classpath <path> Specify where to find user class
files
-sourcepath <path> Specify where to find input source
files
-bootclasspath <path> Override location of bootstrap
class files
-extdirs <dirs> Override location of installed
extensions
-d <directory> Specify where to place generated
class files
-encoding <encoding> Specify character encoding used by
source files
-target <release> Generate class files for specific
VM version
5) Figuring out the command line interface or some Java IDE, just to
be able to compile the Java program.
6) Where to put the Java class
7) Where to get a Java compiler if one isn't installed on their
platform (Mac OS X comes,
standard, with a JDK, but many platforms do not).
Sure, these are things that the new Java person will need to learn
eventually. But, is it necessary to
overload the new Java user with all this minutiae, just to try a simple
Java example -- I think not!
Is there value to the Java developer (new or experienced) to inline
code -- Yes, I've noted some
advantages to the lay person. But, Joe, who is experienced with Java,
could have benefitted from
inline Java too. I suspect he would have saved time preparing/testing
his example and the instructions
how to deploy it :
1) He, simply, could have provided a single CF template with the
Java inline; rather than a Java
program and a separate CF template.
2) He could have avoided typing the instructions to compile and
deploy the Java program
3) The flow of the example, likely, would be better, better
understood, and easier
to explain and document within the code (both CF and Java
Comments)
4) He'd have a single file, a complete example, with no special
instructions --
Just "Save it and Run it" as you would any other CF template.
Is there significant [enough] value, that MM should consider
implementing inline Java --
I think so -- what it boils down to is this: inline Java is an
improved interface to
many Java programs -- much the way that <cfquery> (and the associated
<cfoutput>, <cfloop>, etc.) tags
are an improvement to many SQL databases. Here are some advantages to
MM.
1) The CFMX product could have another productivity advantage for
developers, and
resellers... hmm... I wonder if IBM could use this feature....
2) Macromedia could more easily, and more effectively include many
Java examples
in the code they distribute,
3) Inline Java could facilitate writing, testing and documenting
wrappers for many
Java programs (whether deployed inline or not).
4) It could be easier to reconcile Java constructs of strong typing,
nulls, etc, with the absence
these constructs in CFML. In fact. inline Java, could provide a
very nice means to help
pass data between CFML and Java -- something like <cfjavaparam>
where you could
specify typing, nulls, etc. in a way meaningful to both CFML and
Java.
5) If MM were to implement <cfjavaparam>, they could delay (or
postpone indefinitly) the
request to add these features to CF (requiring major
reengineering of CF, according to some).
this could be a placeholder, preserving MM's options, while
deferring revision of CFML!
6) If MM did decide to add typing, nulls, etc to a later version
CFML, they would have an existing standard
(the cfjavaparam placeholder) that would make it easier to
implement compatibility.
OK, I was careful to use words like "many, could, etc.". Do the
benefits of inline Java apply to all -- Nah!
But, here is a feature that "could" be of use to "many" -- Macromedia,
Resellers, Developers, end users,
As Phil Costa said at the beginning of this thread, MM did consider it,
and it wasn't a "cut and dried" decision.
It may be worth reconsidering!
Dick
P.S. Thanks, again, Joe!
On Monday, November 25, 2002, at 02:32 PM, Joe Eugene wrote:
> Dick,
> Here is an Example that works with CFMX. The Java file should be
> compiled
> under WEB-INF/classes/
> and you can invoke it with CFObject. Note i am using Macromedia
> drivers to
> connect to Sql-Server.
> This is rough sketch..if you want.. i can improvise this later..to be
> generic.
> Dont forget to substitute your Database Name,server name, userid and
> password.
> The method call returns a list of table names.
>
> /*Java File*/
>
> import java.sql.*;
> import java.util.*;
>
> public class MetaData{
>
> String driverName="macromedia.jdbc.MacromediaDriver";
> String url="jdbc:macromedia:sqlserver://SqlServer:1433";
> String userid="YourUserid";
> String pwd="YourPassword";
> private String cat,schPattern,tblNPattern;
> private String tblTypes[];
>
> public void setParms(String c,String s, String t){
> if(c.equalsIgnoreCase("null")) cat=null; else cat=c;
> if(s.equalsIgnoreCase("null")) schPattern=null; else schPattern=s;
> if(t.equalsIgnoreCase("null")) tblNPattern=null; else tblNPattern=t;
> tblTypes=null;
> }
> /*String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
> //String url="jdbc:microsoft:sqlserver://SqlServer:1433";
> */
>
> public String getTablesOnly(){
> StringBuffer sb = new StringBuffer();
> try{
> Class.forName(driverName);
> Connection con = DriverManager.getConnection(url,userid,pwd);
> DatabaseMetaData md = con.getMetaData();
> //System.out.println(md.getSQLKeywords()+"\n\n");
> //System.out.println(md.getNumericFunctions());
>
> //String tbTypes[]={"TABLE","User"};
> ResultSet rs = md.getTables(cat,schPattern,tblNPattern,tblTypes);
>
> while(rs.next()){
> sb.append(rs.getString("TABLE_NAME")+',');
> }
> rs.close();
> con.close();
> return sb.toString();
> }catch(Exception e){
> return e.toString();
> }
>
> }//end getTablesOnly
>
> /*
> public static void main(String argv[]){
> MetaData m = new MetaData();
> System.out.println(m.getTablesOnly());
> }
> */
> }
>
> <!--- CF Code to get the tables --->
> <cfobject action="create" class="MetaData" name="tables" type="JAVA">
> <!---
> Parm1:Catalog
> Parm2:SchemaPattern
> Parm3:tblNPattern
> I am not currently passsing any types.. but u can add them
> --->
> <cfset tables.setParms("DBName","null","null")>
> <cfdump var="#tables.getTablesOnly()#">
>
> Hope this gives you an idea.
> Joe
>
>
>
> On Mon, 25 Nov 2002 10:56:57 -0800 Dick Applebaum <[EMAIL PROTECTED]>
> wrote:
>
>> Joe
>>
>> Below is the Java source, originally caalled
>> DBViewer.
>>
>> This is working code that I modified to use the
>> CFMX cfsnippets db (The
>> PointBase
>> database shipped with the Linux distro).
>>
>> I want to accomplish the same thing within
>> CFMX, and generalize it a
>> bit so it will
>> work with any JDBC driver and database,
>> remote or local, on any platform.
>>
>> For remote dbs, there will be a stub program
>> that determines the
>> platform, CF
>> version, etc. and Uses COM objects or the Java
>> interface as needed.
>> Requests and data are exchanged via WDDX
>> packets.
>>
>> For local dbs the function could be included
>> inline (for performance)
>> or via the
>> stub (for convenience)
>>
>> The problem statements are shown at: 30, 38,
>> and 45.
>>
>> It is fairly easy to program equivalent CF
>> code, but you can't pass
>> nulls from CF.
>>
>> Given more time, I would probably do this:
>>
>> Use a Java program (similar to this) to do
>> the actual manipulation
>> of the JDBC driver.
>>
>> Use a CF routine to interface the Java
>> program: providing input
>> paramaters for the desired db request; and
>> presentation of the
>> results
>>
>> Use an alias (such as 'MyNull'), to exchange
>> psuedo nulls between
>> CF and Java, as necessary
>>
>> Any help will be greatly appreciated.
>>
>> TIA
>>
>> Dick
>>
>>
>>
>> 1 // public abstract ResultSet
>> getIndexInfo(String catalog, String
>> schema, String table, boolean unique,
>> boolean approximate)
>> throws SQLException;
>> 2 // public abstract ResultSet
>> getColumns(String catalog, String
>> schemaPattern, String tableNamePattern, String
>> columnNamePattern)
>> throws SQLException;
>>
>> 3
>> 4 import java.sql.*;
>> 5 import java.util.StringTokenizer;
>>
>> 6 public class DBViewerPB {
>>
>> 7 final static String jdbcURL =
>> "jdbc:pointbase:cfsnippets,database.home=/opt/coldfusionmx/db";
>> 8 final static String jdbcDriver =
>> "com.pointbase.jdbc.jdbcUniversalDriver";
>> 9 final static String username = "PBPUBLIC";
>> 10 final static String password = "PBPUBLIC";
>>
>> 11 public static void main(java.lang.String[]
>> args) {
>>
>> 12 System.out.println("--- Database Viewer
>> ---");
>> 13
>> 14 try {
>> 15 Class.forName(jdbcDriver);
>> 16 Connection con =
>> DriverManager.getConnection(jdbcURL,
>> username, password);
>>
>> 17 DatabaseMetaData dbmd =
>> con.getMetaData( );
>>
>> 18 System.out.println("Driver Name: " +
>> dbmd.getDriverName( ));
>> 19 System.out.println("Database Product:
>> " +
>> dbmd.getDatabaseProductName( ));
>> 20 System.out.println("Database Version:
>> " +
>> dbmd.getDatabaseProductVersion( ));
>> 21 System.out.println("SQL Keywords
>> Supported:");
>> 22 //StringTokenizer st = new
>> StringTokenizer(dbmd.getSQLKeywords( ), ",");
>> 23 //while(st.hasMoreTokens( ))
>> 24 // System.out.println(" " +
>> st.nextToken( ));
>> 25
>> 26 // Get a ResultSet that contains all
>> of the tables in this
>> database
>> 27 // We specify a table_type of "TABLE"
>> to prevent seeing system
>> tables,
>> 28 // views and so forth
>> 29 String[] tableTypes = { "TABLE" };
>> 30 ResultSet allTables =
>> dbmd.getTables(null,null,null,tableTypes);
>> 31 while(allTables.next( )) {
>> 32 String table_name =
>> allTables.getString("TABLE_NAME");
>> 33 System.out.println("Table Name: " +
>> table_name);
>> 34 System.out.println("Table Type: " +
>>
>> allTables.getString("TABLE_TYPE"));
>> 35 System.out.println("Indexes: ");
>>
>> 36 // Get a list of all the columns for
>> this table
>> 37 ResultSet columnList =
>> 38
>> dbmd.getColumns(null,null,table_name,null);
>> 39 while(columnList.next( )) {
>> 40 System.out.println(" Column Name:
>>
>> "+columnList.getString("COLUMN_NAME"));
>> 41 }
>> 42 columnList.close( );
>>
>> 43 // Get a list of all the indexes for
>> this table
>> 44 ResultSet indexList =
>> 45
>> dbmd.getIndexInfo(null,null,table_name,false,false);
>> 46 while(indexList.next( )) {
>> 47 System.out.println(" Index Name:
>> "+indexList.getString("INDEX_NAME"));
>> 48 System.out.println(" Column Name:
>>
>> "+indexList.getString("COLUMN_NAME"));
>> 49 }
>> 50 indexList.close( );
>> 51 }
>>
>> 52 allTables.close( );
>> 53 con.close( );
>> 54 }
>> 55 catch (ClassNotFoundException e) {
>> 56 System.out.println("Unable to load
>> database driver class");
>> 57 }
>> 58 catch (SQLException e) {
>> 59 System.out.println("SQL Exception: " +
>> e.getMessage( ));
>> 60 }
>> 61 }
>> 62 }
>>
>>
>> On Monday, November 25, 2002, at 08:42 AM, Joe
>> Eugene wrote:
>>
>>> Dick,
>>> Can we see your code? Cant you have a method
>> that converts CF String
>>> "null" to
>>> Java String=null?
>>>
>>>> tried to invoke it with cfobject. We could
>> not
>>>> make the interface work
>>>> because we could not pass Nulls between CF
>> and
>>>> Java.
>>>
>>> Here is an example
>>>
>>> public class StringType{
>>> private String str;
>>> public String getString(String s){
>>> String val="";
>>> str=s;
>>> if(str.equals("null")){
>>> val="Your String was null, setting to null
>> now";
>>> str = null;
>>> val= val+ " " +"Now Java value is : "+ str
>> +"";
>>> }
>>> return val;
>>> }
>>> }
>>>
>>> You can invoke it with
>>> type="JAVA">
>>>
>>> #chkNull.getString("null")#
>>>
>>>
>>> if you can post your code, we can try figure
>> it out. Let me know.
>>>
>>> Joe
>>>
>>> On Mon, 25 Nov 2002 06:54:03 -0800 Dick
>> Applebaum
>>> wrote:
>>>
>>>> On Monday, November 25, 2002, at 01:43 AM,
>>>> Jochem van Dieten wrote:
>>>>
>>>>> Quoting Dave Carabetta :
>>>>>>
>>>>>> While I understand this isn't a feature
>> that
>>>> everybody would use, I
>>>>>> would personally like to see MM focus on
>>>> encapsulating some more Java
>>>>>> features into easy-to-use black-box CF
>> tags
>>>> rather than having to code
>>>>>> my own Java.
>>>>>
>>>>> I agree. For instance, it would be far
>> better
>>>> if CF had a tag to get at
>>>>> the DatabaseMetaData interface instead of
>>>> making it marginally easier
>>>>> to
>>>>> write it yourself by allowing inline Java.
>>>>
>>>> This is an excellent example & I expect that
>>>> this will be one of the
>>>> most-requested capabilities -- to be able to
>>>> get DatabaseMetaData into
>>>> CF. I tried to do this, with help from Sean
>>>> Corfield -- without
>>>> success. I found a working Java program that
>>>> extracts metadata, and
>>>> tried to invoke it with cfobject. We could
>> not
>>>> make the interface work
>>>> because we could not pass Nulls between CF
>> and
>>>> Java.
>>>>
>>>> This is for a general-purpose developer
>> utility
>>>> that I use to
>>>> manipulate databases. It is especially
>> useful
>>>> on remote (shared) sites
>>>> where you don't have administrative
>>>> privileges.
>>>>
>>>> I have been doing this a long time with CF
>> 4.5
>>>> and CF 5 on win
>>>> platforms using cfobject to manipulate COM
>>>> objects.
>>>>
>>>> But, I would like to be able to do the same
>>>> thing with CFMX on
>>>> non-windows platforms.
>>>>
>>>> Here's the difficulty:
>>>>
>>>> With CFMX:
>>>>
>>>> I can get at the equivalent of
>> DatabaseMetaData
>>>> on a remote windows
>>>> box, using cfobject and COM objects.
>>>>
>>>> But, I can't get at the DatabaseMetaData on
>> my
>>>> local Unix (Mac OS X)
>>>> developer machine -- you can't use COM
>> objects
>>>> and can't pass the Nulls
>>>> to the Java program that gets the
>>>> DatabaseMetaData.
>>>>
>>>> I suppose there is a way to circumvent the
>> need
>>>> to pass Nulls between
>>>> CF and Java, but I have not had time to
>>>> investigate this.
>>>>
>>>>> And especially from the point of view of
>>>> security built-in tags are
>>>>> better. All those JSP tags and Java classes
>>>> are nice, but on a shared
>>>>> server you need to disable them anyway
>>>> because the same mechanism that
>>>>> is used to access them can be used to break
>>>> out of the sandbox.
>>>>>
>>>>
>>>> Is this true for CFMXJ2ee on JRun, Websphere
>> or
>>>> whatever?
>>>>
>>>> I thought that one of the advantages of
>>>> CFMXJ2ee on a J2ee-compliant
>>>> app server, is the ability to interoperate
>>>> between CF and Java programs.
>>>>
>>>> Will this be possible with Java access
>>>> disabled?
>>>>
>>>> For the DatabaseMetaData example, I would
>>>> prefer the CF tag approach.
>>>>
>>>> But, I still think it is valid to use Java,
>>>> where warranted, on a
>>>> developer machine.
>>>>
>>>>
>>>> Dick
>>>>
>>>>
>>>>> Jochem
>>>>>
>>>>
>>>
>>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
