On Tue, Jun 21, 2011 at 10:42 AM, chi runhua <chirun...@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 < > tpatter...@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. >> >> ################################################################################## >> > >