You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ant.apache.org by Harshal Chavda <h_...@rediffmail.com> on 2006/02/05 20:04:57 UTC
problem with sql task
Hello fellow users,
I have been stuck in a problem regarding sql
task.The problem is that I am unable to connect to the oracle database as whenever I perform the build using the sql task the error message is "Class Not Found: JDBC driver JDBC Thin client-side driver could not be loaded".
My configuration is --Oracle 9i,Ant 1.6.3,jdk 1.3.1,windows XP.
Please suggest me some solution as to where and how should I found the appropriate driver for the sql task.
Also please specify whether my assumption about sql url is correct
url="jdbc:oracle:thin:@localhost:<global databse name>"
Has classes12.jar has anything to do with this driver attribute?Please specify.
Thanks Harshal
Re: problem with sql task
Posted by "Ivan \"Rambius\" Ivanov" <ra...@yahoo.com>.
Hello,
--- Andrew Goktepe <an...@gmail.com> wrote:
> <sql driver="oracle.jdbc.driver.OracleDriver" ...
>
> and do this before running the script so that Ant
> can find the driver class:
>
> set CLASSPATH=%CLASSPATH%;c:\path\to\classes12.jar
This is correct, but it is more appropriate to use
classpath attribute or nested classpath:
<sql driver="oracle.jdbc.driver.OracleDriver" ...>
<classpath>
<pathelement location="/path/to/classes12.jar"/>
</classpath>
</sql>
In this case the build script will not be dependent on
external envorinment variables.
Regards
Ivan
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org
Re: problem with sql task
Posted by Andrew Goktepe <an...@gmail.com>.
Yes, the problem is related to classes12.jar.
You need to specify the driver class name in the <sql> task, and you also
need the class to be found on your classpath. For example, in your Ant
script you might want to use
<sql driver="oracle.jdbc.driver.OracleDriver" ...
and do this before running the script so that Ant can find the driver class:
set CLASSPATH=%CLASSPATH%;c:\path\to\classes12.jar
-Andrew
On 5 Feb 2006 19:04:57 -0000, Harshal Chavda <h_...@rediffmail.com> wrote:
>
>
> Hello fellow users,
> I have been stuck in a problem regarding sql
> task.The problem is that I am unable to connect to the oracle database as
> whenever I perform the build using the sql task the error message is "Class
> Not Found: JDBC driver JDBC Thin client-side driver could not be loaded".
>
> My configuration is --Oracle 9i,Ant 1.6.3,jdk 1.3.1,windows XP.
>
> Please suggest me some solution as to where and how should I found the
> appropriate driver for the sql task.
>
> Also please specify whether my assumption about sql url is correct
> url="jdbc:oracle:thin:@localhost:<global databse name>"
>
> Has classes12.jar has anything to do with this driver attribute?Please
> specify.
>
> Thanks Harshal
>
RE: problem with sql task
Posted by Shweta Bodade <sh...@in.ness.com>.
Hello
I want to buils a build.xml file in which I can write how to deploy
my war project file in WebSphere
Could you please be of help to me reply even if u don't know or u are busy
Please.
Disclaimer
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. If you have received this communication in error, please immediately notify the MailAdmin@in.ness.com and destroy the original message. The recipient should check this email and any attachments for the presence of viruses. Ness has taken every reasonable precaution to minimize this risk, and accepts no liability for any damage caused by any virus transmitted in this email. Ness reserves the rights to monitor and review the content of all messages sent to or from this E-mail address, and store them on the Ness E-mail system.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org