Re: Newbie question

Hi Matthew,

everythings looks kind of alright, not sure about your driver ZIP,

<property name="database.driver.file"
 > value="${lib.dir}/mssqlserver.zip"/>

That usually isn't right, because the driver is in a JAR not a ZIP. The 
MS SQL Server driver consists of 3 JARs, msbase.jar, mssqlserver.jar and 
msutil.jar and all three need to be on your CLASSPATH. Try putting all 
JARs into the database.driver.file property separeted by ;

Hope that solves the problem.

Leander

Matthew Schleindl schrieb:
> Hi -
> 
> Looks like I can run the basic hsqldb stuff, as
> indicated in the 'Getting Started' section 'Create
> tables' ("7 of 7 SQL statements executed
> successfully").
> 
> Now for my stuff...
> 
> I've got an Oracle DB with 5000+ tables, so I'm
> warming up on MS Sequel Server 2000's 'Northwind'
> sample running locally (I am able to connect to it via
> JDBC).
> 
> When I modify the corresponding mssql.xml and try the
> same thing, I get:
> 
> Class Not Found: JDBC driver
> com.microsoft.jdbc.sqlserver.SQLServerDriver could not
> be loaded
> 
> My mssql.xml looks like this:
> 
> <property name="database.script.file"          
> value=""/>
>    <property name="database.driver.file"          
> value="${lib.dir}/mssqlserver.zip"/>
>    <property name="database.driver"               
> value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
>    <property name="database.url"                  
> value="jdbc:Microsoft:sqlserver://mfsmobile:1433;DatabaseName=Northwind"/>
>    <property name="database.userid"               
> value="sa"/>
>    <property name="database.password"             
> value="password"/>
>    <property name="database.schema"               
> value=""/>
>    <property name="database.catalog"              
> value=""/>
> 
>    <!--poperty name="jboss.datasource.mapping"      
> value="MS SQLSERVER"/-->
>    <property name="jboss.datasource.mapping"      
> value="MS SQLSERVER2000"/>
> 
> 
> Any ideas?
> 
> Thanks in advance...
> 
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> middlegen-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/middlegen-user



-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285