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 _______________________________________________ middlegen-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/middlegen-user
