I have download a couple of MS SQL Server trial JDBC2.0 drivers including
the free one from freetds.org.

The data source I am trying to use looks like:

<data-source
  class="com.evermind.sql.DriverManagerDataSource"
  name="MyDatabase"
  location="jdbc/MyDatabase"
  xa-location="jdbc/xa/MyDatabase"
  ejb-location="jdbc/MyDatabase"
  connection-driver="com.internetcds.jdbc.tds.Driver"
  username="mydbuser"
  password=""
  url="jdbc:freetds:sqlserver://mydbserver:1433/mydatabase"
  inactivity-timeout="30"
  schema="database-schemas/ms-sql.xml"
 />

    <data-source
        class="com.evermind.sql.DriverManagerDataSource"
        name="MYDB"
        location="jdbc/MYDBCoreDS"
        xa-location="jdbc/xa/MYDBXADS"
        ejb-location="jdbc/MYDBDS"
        connection-driver="com.inet.tds.TdsDriver"
        username="mydbuser"
        password=""
        url="jdbc:inetdae7:mydbserver:1433?database=mydatabase"
        inactivity-timeout="30"
        schema="database-schemas/ms-sql.xml"
    />

I have tested out both these JNDI (ejb-location) names in the following
code:

import java.sql.*;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import java.util.*;

class TestSQL
{

 public static void main (String args[])
 {
       try
      {
            // Obtain connection
            InitialContext ctx = new InitialContext();
            DataSource ds = (DataSource) ctx.lookup("jdbc/MYDBDS");
            Connection connection = null;

            // Close connection - important!
            connection.close();
         }
  catch(Exception e)
  {      System.out.println("Error: " + e.getMessage() );         }
 }

}


Neither one of the JNDI database names ("jdbc/MyDatabase" or "jdbc/MYDBDS")
work.  Whenever I try to execute the code for the datasource, I get an error
as follows:

Error: Need to specify class name in environment or system property, or as
an applet parameter, or in an application resource file:
java.naming.factory.initial


Can anyone tell me what is going on?    What is this problem and what can I
do to correct the problem?

Any help would be much appreciated!      Thanks.


                        Tom



Reply via email to