Chris Staten

creating a ListServe with Java

I work for a state agency that works with a regulated community that must submit monthly, semi-annual, and annual reports. I have a J2EE program that allows for the reports to be submitted on line and my boss wants to do some kind of outreach to encourage more use of it. I was thinking about setting up an email ListServe but I wasn�t sure how hard it would be to create.

I�ve been looking on line a bit for information and I saw the following links from this thread here at JavaRanch.

Sending email using SMTP and Java
http://www.mckoi.com/database/

Of course I�ve also been to Sun�s JavaMail API page as well.

I guess what I�m looking for in this thread is any information from someone who may have already created a ListServe about how hard it was to create the program.

Thanks!

18 years ago

Java in General

.jar file question

Yeah, I went there to check it out and saw that it's a pay site. I don't have a problem with paying a few bucks if I really need the service. Although, right now I'm doing OK with un-jaring files and hunting for the class/package I need.

As for using google, well, I do that and all I can seem to come up with is the javadoc for the classes I need. As far as I can tell that still doesn't give me the .jar file that they can be found in.

Thanks for the suggestions though!

18 years ago

Beginning Java

.jar file question

If I know what class or package I need for a program, how do I find out what jar file that class is in? I'm not so worried about the classes from Sun, but what about other vendors like Oracle?

18 years ago

Beginning Java

Using JDBC for a remote call in Oracle

That worked great.

Thanks!

19 years ago

Using JDBC for a remote call in Oracle

Hey all, I�m about to try and figure something out with some code that I�m working on. However, before I get started I wanted to ask a question, just to make sure that I�m not on a wild goose chase.

Is it possible to use JDBC to make a remote call from inside a Java Stored Procedure in one Oracle database (on its own database server) to a procedure/function in another Oracle database on a completely different database server?

Right now I�m attempting to use a DB link to call a Java Stored Procedure on Database_B from a PL/SQL procedure on Database_A. This is causing an error. I want to try to make the PL/SQL procedure on Database_A call a Java Stored Procedure in the same schema on Database_A. Then that Java Stored Procedure will use JDBC to call a function on Database_B. That function will call a Java Stored Procedure in its schema.

19 years ago

OK, I've all but finished this build file! Here's what it looks like now:

<?xml version="1.0"?>
<project name="MoveFiles" default="all" basedir=".">
<property name="base" value="."/>
<property name="src" value="src"/>
<property name="current.version" value="currentdbversion"/>
<property name="lib" value="lib"/>
<property name="jarName" value="test.jar"/>
<property name="build" value="build"/>
<property name="logfile" value="log"/>//can't make the tstamp task work so I'm using this for now.
<property name="logDir" value="etc"/>
<property name="files.to.jar" refid="files.to.load"/>
<property name="username" value="scott"/>
<property name="password" value="tiger"/>
<property name="database" value="localhost:1522:TNSNAME"/>
<property name="JDBC.PATH" value="${lib}/classes12.jar"/>
<property name="SQL" value="sql"/>
<property name="timeStamp" refid="time.stamp"/>

<target name="all" depends="init">
<antcall target="loadjava"/>
</target>
<target name="init">
<echo>${timeStamp}</echo>
</target>
<target name="jar.up.files" depends="moveJava"
description="jars up the files to go to the database">
<jar destfile="${base}/${jarName}" basedir="${base}/${src}"/>
<copy file="${jarName}" tofile="${current.version}/${jarName}"/>
</target>
<target name="loadjava" depends="jar.up.files"
description="Uses the loadJava tool to move java files to the Oracle database.">

<exec executable="loadjava.bat" dir="${current.version}" output="${logfile}" append="true">
<arg value="-thin"/>
<arg value="-u"/>
<arg value="${username}/${password}@${database}"/>
<arg value="-v"/>
<arg value="-r"/>
<arg value="${jarName}"/>
</exec>
<antcall target="PLSQL"/>
</target>
<target name="moveJava" depends="dropjava"
description="moves all of the .java files into a 'java.files.to.jar' sub directory">
<copy todir="${current.version}">
<fileset dir="${src}">
<include name="**/*.java"/>
</fileset>
</copy>
</target>
<target name="cleanDirs" description="cleans out the directory that
holds the .java files needed in the build process.">
<delete dir="${current.version}"/>
<mkdir dir="${current.version}"/>
</target>
<target name="dropjava" depends="cleanDirs" description="drops all of the relevent rows in
CREATE$JAVA$LOB$TABLE and JAVA$CLASS$MD5$TABLE">

<exec executable="dropJavaFiles.bat" output="${logDir}/${timeStamp}.txt" />
</target>
<target name="PLSQL" description="Loads the PL/SQL Call Specifications into the database.">

<sql driver="oracle.jdbc.driver.OracleDriver"
url="jdbc :o racle:thin:@${database}"
userid="${username}"
password="${password}"
classpath="${JDBC.PATH}"
delimiter="/"
output="${logfile}" 
append="true"
keepformat="true">
<fileset dir="${SQL}" includes="pkg_test.sql"/>
</sql>
<sql driver="oracle.jdbc.driver.OracleDriver"
url="jdbc :o racle:thin:@${database}"
userid="${username}"
password="${password}"
classpath="${JDBC.PATH}"
delimiter="/"
output="${logfile}" 
append="true"
keepformat="true">
<fileset dir="${SQL}">
<include name="*.sql"/>
<exclude name="pkg_test.sql"/>
</fileset>
</sql>
</target>
<fileset dir="${src}" id="files.to.load">
<include name="**/*.java"/>
</fileset>

<tstamp id="time.stamp">
<format property="timeStamp" pattern="d-MMMM-yyyy" locale="en"/>
</tstamp>
</project>

A few things to note.

1. I may have a few more things in the build file than I need, this is because after I learned how to do them I wanted to find a way to use them

2. I may be doing the same type of thing two different ways, this is for the same reason as above.
3. I could not get Oracle's dropjava utility to work with ANT (you can see it commented out in the code above) so I created a batch file and I just call it from my build file. I don't like this implementation, but it's working for now.
4. I can't get the tstamp task to work right, I've read the manual and I just can't make it work. All I ever get is "org.apache.tools.ant.taskdefs.Tstamp@148aa23" as my time. If anyone has any idea what I'm doing wrong please let me know .

All in all I'm happy with my first time playing with ANT, these were my first steps into the world of build tools and it's amazing how much time they can save.
[ August 16, 2005: Message edited by: Chris Staten ]

19 years ago

Using loadjava in Oracle 9i

OK, I've got everything working just fine by jaring up the .java files and not the .class files. They get compiled and loaded into the DB just fine when I move the jar file over.

I'd still like to figure out why I can't directly put my class files over though.

19 years ago

Oracle/OAS

Using loadjava in Oracle 9i

Hey all, I have a quick question about java and Oracle 9i. I�m using Oracle�s loadjava utility to load java classes into my database and then calling them using PL/SQL. I read where the loadjava utility works with .java, .class, and .jar files, so I decided to compile all of my code and jar it up before moving it over to the database (seems cleaner to me).

This is where I run into a problem, all of my classes seem to have errors in them when I do this, but if I take the .java files and move them over using the loadjava utility then they compile just fine and all is good.

Any idea why my code only works when the source code is moved over?

19 years ago

Oracle/OAS

I think I may have found the right driver for using the SQL tag, I'm looking at using oracle.jdbc.driver.OracleSql.

Here's what my SQL tag will look like:

I'll have all of my PL/SQL wrappers in the sql.txt flat file.

Thanks!

19 years ago

OK, I�m getting a bit excited here with ANT so bear with me please

I�ve changed the way I�m going to build my java files and move them over to the database, here are my new steps:

I�m going to compile all of my .java files

Jar up the .class files

move the .jar file to the database using the loadjava utility

move the .jar file to a different directory

Then I�m going to use the SQL tag to create all of my PL/SQL wrappers (i.e. functions) in the database

I just need to figure out a few things. First thing I�m trying to figure out is which JDBC driver should I be using? In my datasource I link to Oracle�s classes12.jar for my JDBC classes, but I don�t link to a specific package or class. The way I read the SQL tag property for driver is that it requires a specific class. Anyone know how I can figure out just which class I need?

The other thing I�m looking into is if I will need to change the way my PL/SQL wrapper calls a java stored procedure when it�s in a jar file.

19 years ago

I anticipate your next question will be how do I loop in ant?

Very perceptive!

Thank you very much for your reply. I'm also thinking about getting a book on ANT. I know that the manuals are at the Apache site, but I think it would be nice to have a few more examples as well. I saw a review on slashdot about Ant: The Definitive Guide from O'Reilly, it seems like a good choice.

As for the batch file, you're right about me being set on learning ANT.

I do have a question that I can't seem to find even when searching online (although I may be over complicating this or reading right over the answer). How do you explicitly invoke a target? Do you just call the target from inside another target with an element? This didn't seem to intuitive to me when I followed a tutorial - the one that builds UKlights. It looked like every target was called via a dependency attribute; this works fine if you want the target called before the current target, but what if you want it called during a sequence of actions? I guess that I may be making this difficult for myself for no reason, but the confident feeling that comes with clarity feels so darn good

19 years ago

Hey all, I am trying to learn ANT and would love some help if there is any out there. I am trying to do something along the lines of moving every file that I have in a directory over to an Oracle database using the loadjava utility in Oracle. I am guessing that I will have to do this by:
1. looping through some kind of control statement while reading each .java file name in my directory

2. using the current value of some variable to specify what .java file I am moving (each loop through)

Here is what my load java command line argument looks like when I do it manually:

I�m not looking for a free answer to my problem, maybe just a point in the right direction. I�ve been to the manual at ant.apache.org to read up a bit. After what I�ve read so far I think I may want to use the <arg/> tag, but I don�t know how I�m going to dynamically get all of the file names in a directory or how to do the looping. Here�s where I�m stuck in my buildfile (this could be WAY off from what it should be):

<?xml version="1.0"?>
<project name="MoveFiles" default="Driver" basedir=".">
<property name="fileName" value="???how can I dynamicly get file names???"/>
<property name="finishedDir" valule="/loadedToDatabase"/>
<target name="Driver" description="Used as a driver to
control the project (like a main method">
<echo>Inside Driver</echo>
<
</target>
<target name="loop" description="Used to loop through filenames">
<echo>Inside loop</echo>

</target>
<target name="loadJava" depends="loop"
description="Uses the loadJava tool to move java files
to the Oracle database.">
<echo>Inside loadJava</echo>
<arg value="loadjava -thin -user scott/tiger@localhost:1522:TNSNAME
${fileName}.java"/>
</target>
<target name="clean" depends="loop, loadJava"
description="Removes files that have been moved
to the Oracle DB with the loadjava utility. Using
verbose to see each file being deleted.">
<echo>Inside clean</echo>
<copy file="${fileName}.java" todir="${finishedDri}/"/>
<delete verbose="true">
<fileset file="${fileName}"/>
</delete>
</target>
</project>

Any info would be great, Thanks!

EDIT:

I just saw the link at the top of the ANT, Maven and Other Build Tools forum page. I'll try looking there really quick.

[ July 25, 2005: Message edited by: Chris Staten ]
[ July 25, 2005: Message edited by: Bear Bibeault ]

19 years ago

java stored procedure problems

Here is the working PL/SQL wrapper, java stored procedure, and calling Servlet code:

PL/SQL wrapper:

NOTE: you need to create a REF CURSOR before you can use the above function.

Java stored procedure:

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "TEST_SELECT_ADDRESS" AS
import java.sql.*; // JDBC classes
import oracle.jdbc.driver.*;
public class TEST_SELECT_ADDRESS
{
public static ResultSet test_sELECT_ADDRESS ( String addrId,
String myType,
String entity ) throws SQLException, Exception
{
//declare variables
Connection con = null;
ResultSet rs = null;
try {
// Register Oracle JDBC driver
DriverManager.registerDriver(new OracleDriver());
//obtain the default connection
con = new OracleDriver().defaultConnection();
// Create any subsequent statements as a REF CURSOR
((OracleConnection)con).setCreateStatementAsRefCursor(true);
PreparedStatement stmt = null;
String sql;
sql = "SELECT"
+ " SCHEMA.TABLE_NAME.ADDR_1 AS ADDR_1,"
+ " SCHEMA.TABLE_NAME.ADDR_2 AS ADDR_2,"
+ " SCHEMA.TABLE_NAME.ADDR_3 AS ADDR_3,"
+ " SCHEMA.TABLE_NAME.CITY AS CITY,"
+ " SCHEMA.TABLE_NAME.STATE_ID AS STATE_ID,"
+ " SCHEMA.TABLE_NAME.ZIP AS ZIP,"
+ " SCHEMA.TABLE_NAME.ZIP_PLUS AS ZIP_PLUS"
+ " FROM"
+ " SCHEMA.TABLE_NAME "
+ " WHERE"
+ " ("
+ " ( SCHEMA.TABLE_NAME.ADDR_ID = ? )"
+ " AND ( SCHEMA.TABLE_NAME.ADDR_TYPE = ? )"
+ " AND ( SCHEMA.TABLE_NAME.ADDR_ENTITY = ? )"
+ " )";
stmt = con.prepareStatement( sql );
stmt.setString( 1, addrId );
stmt.setString( 2, myType );
stmt.setString( 3, entity );
rs = stmt.executeQuery();
return rs;
}catch (SQLException e) {
e.printStackTrace();
}
return null;
}
}
/

Servlet code (calling fragment):

[ July 07, 2005: Message edited by: Chris Staten ]

19 years ago