Another reason this would not have worked in 3.0-M1 and ought to work on trunk is that you need to convert the driver jar into an osgi bundle.    There's code in recent trunk builds that is supposed to do this when you install a jar using the console.  However it's not well tested yet so please let us know how this works.

thanks
david jencks

On Jun 20, 2011, at 10:41 PM, chi runhua wrote:



On Tue, Jun 21, 2011 at 10:42 AM, chi runhua <chirunhua@gmail.com> wrote:
Datasource portlet is not enabled on 3.0-M1.  You may try the datasource wizard on 3.0 and use @resource annotation in your sample code.

3.0-SNAPSHOT in trunk. 

HTH.

Jeff


On Tue, Jun 21, 2011 at 12:32 AM, Tyson P. Patterson <tpatterson@carnes.com> wrote:
I am getting the ClassNotFound exception trying to use the Microsoft SQL
Driver with Geronimo 3.0 M1.

Here is the setup:
I am running Windows XP Professional 32 bit.
I have Eclipse Helios SR 2 with the Geronimo Eclipse Plugin 3.0 M1 for
my development environment.  I am using 6.0.23 for the JRE version.
I installed Microsoft SQL Server Express 2008 R2.  I installed Microsoft
JDBC Driver 3.0.

From inside Eclipse I was able to establish a database connection to the
SQL Express database using the sqljdbc4.jar file from the Microsoft JDBC
Driver installation.

I loaded the sqljdbc4.jar file into Geronimo 3.0's Repository using the
console.  I specified com.microsoft.sqlserver.jdbc as the group,
SQLServerDriver as the artifact, 3.0 as the version and jar as the type.

I started a new JSF project in Eclipse.  In the Geronimo Deployment
Plan, I selected the SQLServerDriver I loaded in the repository from the
drop down list of Server Dependencies.  Eclipse generated the dependency
in geronimo-web.xml as follows:

           <dep:dependency>
               <dep:groupId>com.microsoft.sqlserver.jdbc</dep:groupId>
               <dep:artifactId>SQLServerDriver</dep:artifactId>
               <dep:version>3.0</dep:version>
               <dep:type>jar</dep:type>
           </dep:dependency>

I created a session bean and put the connection information in the
constructor for the class:

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String connectionUrl = "jdbc:sqlserver://localhost:1433;" +
       "databaseName=XXXXXXXX;user=XXXX;password=XXXXXXXX;";
conn = DriverManager.getConnection(connectionUrl);

After publishing the application and starting it, I got the exception:
java.lang.ClassNotFoundException:
com.microsoft.sqlserver.jdbc.SQLServerDriver

I was unable to find how to set the SQL Server connection information on
the Geronimo 3.0 server as a database pool using the console.

Any ideas on where I went wrong or what step I forget?

Tyson Patterson
Carnes Company

##################################################################################
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. It may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and his/her authorized agent
is prohibited.

If you have received this email in error please notify the originator of the message and delete the
material from your computer.
##################################################################################