OK, forget the stuff with the ; separated JARs. Put all three JARs into the samples/lib/ directory. Then put ${lib.dir}/mssqlserver.jar as the value for the database.driver.file property.

If you want to put everything into one file, you have to put the contents of all 3 JARs into one big JAR and use this instead, but I have never done that.

If that doesn't solve it, I don't know anymore :-)

Regards,
Leander

Matthew Schleindl schrieb:

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

Reply via email to