• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC require EE?

 
Kevin Cary
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1070
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have since sent an email to imaginary.com. I'll let you know if I get a response.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic