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/main/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/main/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/main/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/main/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/main/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/main/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/main/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/main/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/main/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/main/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/main/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/main/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/main/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/main/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/main/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/main/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.html#a11759671
Sent from the ServiceMix - User mailing list archive at Nabble.com.

Reply via email to