File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes JDBC require EE? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC require EE?" Watch "JDBC require EE?" New topic
Author

JDBC require EE?

Kevin Cary
Ranch Hand

Joined: Jan 24, 2001
Posts: 53
Hi Bill nice to see your name as moderater. I was away developing a desktop tool and now I'm back with my previous challenge. You may recall I'm was having trouble connecting with mSQL database. Currently I'm using JDK1.3 SE, should I be using JDK1.3 EE?
Best to all,
bill bozeman
Ranch Hand

Joined: Jun 30, 2000
Posts: 1070
You will need JDK1.3EE if you are using servlets. However, the java.sql package in JDK1.3 SE is all you need to connect to the database. If you still can't connect, try using a simple TestConnection class and see if you can get in. If you can't show us your code and report any error messages you are getting.
Bill
Kevin Cary
Ranch Hand

Joined: Jan 24, 2001
Posts: 53
Hey Bill,
I still can't get my database. There are no class files in directory with driver. Compiling using: javac *.java produces 66 errors. The first complaint is:
MsqlQueryData.java:4: cannot resolve symbol
symbol: class Encoder
location: package util
import com.imaginary.util.Encoder;
I've searched my hd and I don't have a class named Encoder. Below is the class I'm trying to run. Which doesn't run because it can't find the MsqlDriver. Any ideas?

import java.sql.*;
public class Test
{
public static void main( String args[] )
{
Connection mSQLcon = null;
try
{
Class.forName("com.imaginary.sql.msql.MsqlDriver").newInstance();
}
catch ( InstantiationException ie )
{
ie.printStackTrace ();
}
catch( ClassNotFoundException cfe )
{
System.err.println("Test.java:main:couldn't find driver");
cfe.printStackTrace();
}
catch( Exception e )
{
e.printStackTrace( );
}
finally
{
if( mSQLcon != null )
{
try
{
mSQLcon.close()
}
catch( Exception e )
System.err.println("Test.java:main method:finally");
}
}
}
}
}
Kevin Cary
Ranch Hand

Joined: Jan 24, 2001
Posts: 53
I have since sent an email to imaginary.com. I'll let you know if I get a response.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC require EE?