Re: Newbie question

Hi Leander -

Ok, went back to the original jars, and the failure is
different (I've tried using forward and backward
slashes for separators - result is the same):

BUILD FAILED
C:\jars\Middlegen\middlegen-2.0-vo\samples\build.xml:161:
The JDBC driver you have specified by including one of
the files in C:\jars\Middle
gen\middlegen-2.0-vo\samples/config/database
      doesn't exist. You have to download this driver
separately and put it in
C:\jars\Middlegen\middlegen-2.0-vo\samples/lib\msbase.jar;C:\
jars\Middlegen\middlegen-2.0-vo\samples/lib\mssqlserver.jar;C:\jars\Middlegen\middlegen-2.0-vo\samples/lib\msutil.jar
      Please make sure you're using a version that is
equal or superior to the one we looked for.
      If you name the driver jar file differently,
please update the database.driver.file property
      in the
C:\jars\Middlegen\middlegen-2.0-vo\samples/config/database/xxx.xml
file accordingly.

Total time: 1 second
--- "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