Add the following as dependacies in your pom.xml
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.2.2</version>
</dependency>
<dependency>
<groupId>commons-pool</groupId>
<artifactId>commons-pool</artifactId>
<version>1.3</version>
</dependency>
No need to add anything to xbean configuration.
Regards,
Rabi Mishra,
http://rabisblog.blogspot.com/
c++; /* this makes c bigger but returns the old value */
-----Original Message-----
From: Erik Allais [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 24, 2007 3:07 PM
To: [email protected]
Subject: Insert jdbc logic into webmethod
Hi,
I try to insert the JDBC logic inside my webmethod (jsr-181)
i have the following package for my webservice
mc-jsr181-su
--lib/
--src/
--src.main.java.com.altervisions.connect.sample.ExampleService.java
This java class use another class JDBCConnector which initialise the
datasource and send query to the database.
I use the following jar :
commons-dbcp-1.2.2.jar
commons-pool-1.3.jar
mysql-connector-java-5.0.6-bin.jar
I try to add this classpath inside the xbean.xml of jsr-181 component :
<classpath>
<location>lib/commons-dbcp-1.2.2.jar</location>
<location>lib/commons-pool-1.3.jar</location>
<location>lib/mysql-connector-java-5.0.6-bin.jar</location>
</classpath>
I got this error when i try to compile :
[INFO] [compiler:compile]
[INFO] Compiling 2 source files to
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/target/
classes
[INFO]
------------------------------------------------------------------------
[ERROR] BUILD FAILURE
[INFO]
------------------------------------------------------------------------
[INFO] Compilation failure
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/utils/JDBCConnector.java:[25,31]
package org.apache.commons.pool does not exist
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/utils/JDBCConnector.java:[26,36]
package org.apache.commons.pool.impl does not exist
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/utils/JDBCConnector.java:[27,31]
package org.apache.commons.dbcp does not exist
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/utils/JDBCConnector.java:[28,31]
package org.apache.commons.dbcp does not exist
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/utils/JDBCConnector.java:[29,31]
package org.apache.commons.dbcp does not exist
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/utils/JDBCConnector.java:[30,31]
package org.apache.commons.dbcp does not exist
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/utils/JDBCConnector.java:[87,16]
cannot find symbol
symbol : class ObjectPool
location: class com.altervisions.connect.utils.JDBCConnector
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/utils/JDBCConnector.java:[87,48]
cannot find symbol
symbol : class GenericObjectPool
location: class com.altervisions.connect.utils.JDBCConnector
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/utils/JDBCConnector.java:[96,16]
cannot find symbol
symbol : class ConnectionFactory
location: class com.altervisions.connect.utils.JDBCConnector
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/utils/JDBCConnector.java:[96,58]
cannot find symbol
symbol : class DriverManagerConnectionFactory
location: class com.altervisions.connect.utils.JDBCConnector
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/utils/JDBCConnector.java:[104,16]
cannot find symbol
symbol : class PoolableConnectionFactory
location: class com.altervisions.connect.utils.JDBCConnector
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/utils/JDBCConnector.java:[104,74]
cannot find symbol
symbol : class PoolableConnectionFactory
location: class com.altervisions.connect.utils.JDBCConnector
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/utils/JDBCConnector.java:[111,16]
cannot find symbol
symbol : class PoolingDataSource
location: class com.altervisions.connect.utils.JDBCConnector
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/utils/JDBCConnector.java:[111,51]
cannot find symbol
symbol : class PoolingDataSource
location: class com.altervisions.connect.utils.JDBCConnector
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/sample/ExampleService.java:[49,38]
incompatible types
found : java.lang.StringBuffer
required: java.lang.String
/home/servicemix/modulo_connect/modulo_connect_v0.2/mc-jsr181-su/src/mai
n/java/com/altervisions/connect/sample/ExampleService.java:[54,38]
incompatible types
found : java.lang.StringBuffer
required: java.lang.String
--
View this message in context:
http://www.nabble.com/Insert-jdbc-logic-into-webmethod-tf4134742s12049.h
tml#a11759671
Sent from the ServiceMix - User mailing list archive at Nabble.com.
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not the
intended recipient, you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately and destroy all copies of this message and
any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The company
accepts no liability for any damage caused by any virus transmitted by this
email.
www.wipro.com
