Re: Newbie question

Hi Leander -

Thanks for the quick response!

Actually, the first time I tried it I set the
driver.file property to the three jars, separated by
semicolons like a classpath, and I had the same
problem...

Since I wasn't sure about how to Middlegen was
expecting three separate jars, and I couldn't find an
example, I just dumped the contents of the three jars
into a single zip and used that, after testing the zip
by making sure I could establish a JDBC connection.

I'll dispense with the zip and go back to the three
jars, but unless you hear from me again you can assume
I'm getting the same result.

Thanks again,
Matt
--- "M.-Leander Reimer" <[email protected]>
wrote:

> 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
> 



-------------------------------------------------------
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