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/03/17 18:19:00 UTC
SQL task

  

Hello to all users
My configuration is 
--pentium 4,CPU  3GHz,512 MB RAM,windows XP professional
--JDK 1.5,Ant 1.6.3,Tomcat 4.1,Cruisecontrol 2.2.1


I have a problem regarding the sql task. I use the following code to which I get The following error:

	<target name="sqltesting">
	<sql 
	driver="oracle.jdbc.driver.OracleDriver" 	
	url="jdbc:oracle:thin:@localhost:harshal"
   	userid="scott" 	password="tiger" >

	insert
    into table trainees
    values(naam,pataa);

	<classpath>
    	<pathelement location="G:\BE_Project\Ant\RG\RG\lib\classes12.jar"/>
 	 </classpath>
 	 </sql>
---------------------------------------------------------------------------------------------------------------------------
ERROR
BUILD FAILED
G:\BE_Project\Ant\RG\RG\Practice\prac.xml:48: java.sql.SQLException: Io exception: Invalid 

connection string format, a valid format is: "host:port:sid"
---------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------
Line 48 is --------->   	userid="scott" 	password="tiger" >
---------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------

Assuming the above code to be the original one I made the following changes
All the changes are relative to the original code given above:::::::::::

CHANGE 1-----------------------------------------------------------------------------------------------------------

	url="localhost:1521:harshal"
ERROR
-------------
-------------

BUILD FAILED
G:\BE_Project\Ant\RG\RG\Practice\prac.xml:48: java.sql.SQLException: No suitable
 Driver for localhost:1521:harshal



CHANGE   2----------------------------------------------------------------------------------------------------

     url    =" jdbc:oracle:thin:@localhosthost:1521:harshal"
    


ERROR
---------------
---------------
BUILD FAILED
G:\BE_Project\Ant\RG\RG\Practice\prac.xml:48: java.sql.SQLException: Io exception: The Network 

Adapter could not establish the connection



How can I get around this problem?



Thanks Harshal