Dan Jackson

Thank you for your reply,
Most of my database will be select statement processing, but how close is oracle syntax and mySQL syntax? If they are not very similar, does anyone know if there is a little program that can covert 1 syntax to another?

Hello,
I am planning on setting up a database server. I am wondering what the best solution maybe. This going to be very small scale running on a P200 /w 128meg, and i am planning on only about 50 user hits a day.
I have some idea of my options:
-BSD/unix, win2k/XP RC1
-mySQL, oracle
-tomcat, iSuites
I do have unix experiance (but never setup a server), i heard mySQL is not very good, and i dont want to use access. From experiance how hard is it to setup tomcat/oracle on unix?
Thank you for your time.

is there a way to let one column have two different forgein keys?
i dont think this is possible...
if this is not possible is it better that create two tables or just one table without the forigen key?
the table just a message table, and that message can either come from a user, or a group.
thank you

I am running windows 2000, and i have having some problems running this code. It work when for exec("ping"), or exec("ftp") but trying to run exec("dir") or exec("set") it breaks. Can anyone help??? I am guessing that i need to give java more rights to run system commands or something??? Thank you for any help...
import java.io.*;
public class RunOSCommand {
public RunOSCommand() {
}
public static void main(String[] args) {
System.out.println("in the main");
try
{
Runtime r = Runtime.getRuntime();
String cmd = ("set");
Process p = r.exec(cmd);
BufferedReader reader = new BufferedReader(new InputStreamReader(new
DataInputStream( new BufferedInputStream(p.getInputStream()))));
String lineRead =null;
while( (lineRead = reader.readLine() ) != null)
{
System.out.println(lineRead);
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
// --------------------------------------------------------
H:\java>java RunOSCommand
in the main
java.io.IOException: CreateProcess: set error=2
at java.lang.Win32Process.create(Native Method)
at java.lang.Win32Process.<init>(Win32Process.java:64)
at java.lang.Runtime.execInternal(Native Method)
at java.lang.Runtime.exec(Runtime.java:300)
at java.lang.Runtime.exec(Runtime.java:247)
at RunOSCommand.main(RunOSCommand.java, Compiled Code)

try something like this
String str[] = {"ftp", "-s:test.dat"};
Process proc = Runtime.getRuntime().exec( str );
i hope this helps (i know its a little late tho)

Win2000

Is there a way i can get java to read a system variable???
Like class_path or temp = "c:/temp" ???
I have tried the System.getProperties() but i need the system variables....