DO NOT REPLY [Bug 9532] New: - can not find database drivers

[bugzilla]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=9532>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=9532

<sql> can not find database drivers

           Summary: <sql> can not find database drivers
           Product: Ant
           Version: 1.5Beta1
          Platform: Sun
        OS/Version: Solaris
            Status: NEW
          Severity: Critical
          Priority: Other
         Component: Core tasks
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


I am developing a build script to build a Sybase database. <sql> fails to find
the JDBC driver. I have added the driver jar file as an attribute and the <sql>
continues to fail with the error:

Class Not Found: JDBC driver "com.sybase.jdbc2.jdbc.SybDriver" could not be 
loaded


The build file is

<project name="SQL exec" default="doSql">
    <property name="userName" value="sa"/>
    <property name="userPass" value="******"/>
    <property name="dbName" value="contentDepot"/>

    <target name="doSql">

        <loadproperties srcFile="build.cfg">
                <filterchain>
                        <striplinecomments>
                                <comment value="#"/>
                                <comment value="--"/>
                                <comment value="REM "/>
                                <comment value="rem "/>
                                <comment value="//"/>
                        </striplinecomments>

                        <linecontains>
                                <contains value="dbprops."/>
                        </linecontains>
                </filterchain>
        </loadproperties>

        <sql
                driver="${dbprops.driver}"
                url="${dbprops.url}"
                userid="${userName}"
                password="${userPass}"
                classpath="/export/home/sybase/jConnect-5_5/classes/jconn2.jar"
                delimiter=" "
        >
                select * from sysobjects
        </sql>

    </target>

</project>

The contents of the properties file is:

// Define universal properties required in the build
dbprops.driver="com.sybase.jdbc2.jdbc.SybDriver"
dbprops.url="sybase:Tds:theo.entradasoftware.com"

This is the driver and url definitions that I use in my servlets so I know that
the values are valid. My class path points to the  the jar file containing the
database driver so I should not need the class attribute, but I have tried it
with and without this attribute.

I have tried <sql> under both ant-1.4.1 and and-1.5Beta1 with the same failure.

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>