# Cannot find prepareStatement in DBConnection Class

**URL:** <https://forum.cloverdx.com/t/cannot-find-preparestatement-in-dbconnection-class/706>\
**Category:** CloverDX Platform\
**Created:** [May 10, 2010, 12:00am UTC](https://forum.cloverdx.com/t/cannot-find-preparestatement-in-dbconnection-class/706 "2010-05-10T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashishkshirsagar](https://avatars.discourse-cdn.com/v4/letter/a/85f322/32.png) [@ashishkshirsagar](https://forum.cloverdx.com/u/ashishkshirsagar)\
**Post date:** [May 10, 2010, 12:00am UTC](https://forum.cloverdx.com/t/cannot-find-preparestatement-in-dbconnection-class/706/1 "2010-05-10T00:00:00Z")

</div>

Hi,

I am trying to compile a custom transformation written in older version of Clover 2.1.0 with the jar of the latest version 2.9.2.  
I found out that DBConnection has been moved to jdbc.DBConnection. I would like to know in which class is the prepareStatment method has been moved to ? or how can I create a Prepared Statement ?

error that I am getting while compiling is -

cannot find symbol  
[javac] symbol : method prepareStatement(java.lang.String)  
[javac] location: class org.jetel.connection.jdbc.DBConnection  
[javac] pstmt = dbConnection.prepareStatement ("insert into "

Thanks,  
Ashish

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [May 11, 2010, 8:57am UTC](https://forum.cloverdx.com/t/cannot-find-preparestatement-in-dbconnection-class/706/2 "2010-05-11T08:57:29Z")

</div>

Hello Ashish,  
CloverETL 2.1 version is very old and it isn’t supported any more. Please download the java doc from [http://sourceforge.net/projects/clovere … -2-9-2.zip](http://sourceforge.net/projects/cloveretl/files/cloveretl.engine/rel-2-9-2/cloverETL.javadoc.rel-2-9-2.zip) and rewrite your transformation according to it. Now the main plug-in that works with databases is cloveretl.jdbc.jar

---

<div class="post-metadata">

**Author:** ![ashishkshirsagar](https://avatars.discourse-cdn.com/v4/letter/a/85f322/32.png) [@ashishkshirsagar](https://forum.cloverdx.com/u/ashishkshirsagar)\
**Post date:** [May 11, 2010, 3:01pm UTC](https://forum.cloverdx.com/t/cannot-find-preparestatement-in-dbconnection-class/706/3 "2010-05-11T15:01:44Z")

</div>

> Hello Ashish,  
> CloverETL 2.1 version is very old and it isn’t supported any more. Please download the java doc from [http://sourceforge.net/projects/clovere … -2-9-2.zip](http://sourceforge.net/projects/cloveretl/files/cloveretl.engine/rel-2-9-2/cloverETL.javadoc.rel-2-9-2.zip) and rewrite your transformation according to it. Now the main plug-in that works with databases is cloveretl.jdbc.jar
> 
> “avackova”

Thank you avackova