DBReport mediator
Hi,
i would like to use DBRepor mediator with my local database SQLServer named MEDUSA.
following the configuration:
Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver
Url : jdbc:sqlserver://127.0.0.1/MEDUSA
User : sa
Password : sa
Statements
SQL Statement : insert into BusMesaages (?, ?, ?)
Parameters
Parameter Type Property Type Value / Expression
CHAR Value order
CHAR Value SYN12345
CHAR Value IBM
i get this error when it is executed
2008-09-10 10:58:17,187 [192.168.82.52-WAILUP0001] [SynapseWorker-1] ERROR DBReportMediator Error execuring insert statement : insert into BusMesaages (?, ?, ?) against DataSource : jdbc:sqlserver://127.0.0.1/MEDUSA
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host has failed. java.net.UnknownHostException: )
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at org.apache.synapse.mediators.db.AbstractDBMediator.getPreparedStatement(AbstractDBMediator.java:171)
at org.apache.synapse.mediators.db.DBReportMediator.processStatement(DBReportMediator.java:40)
at org.apache.synapse.mediators.db.AbstractDBMediator.mediate(AbstractDBMediator.java:96)
at org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:58)
at org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:125)
at org.apache.synapse.mediators.MediatorWorker.run(MediatorWorker.java:70)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.UnknownHostException:
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
... 10 more
do you have an idea to help me?
Ciao
Gianni
- cislagg's blog
- Login or register to post comments
- Printer friendly version
- 279 reads











Your configuration (some
Your configuration (some hostname) is wrong..
2008-09-10 10:58:17,187 [192.168.82.52-WAILUP0001] [SynapseWorker-1] ERROR DBReportMediator Error execuring insert statement : insert into BusMesaages (?, ?, ?) against DataSource : jdbc:sqlserver://127.0.0.1/MEDUSA
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host has failed. java.net.UnknownHostException: )
share your synapse.xml or the configuration snippet..
asankha
This is may synapse
This is may synapse configuration file
Check
Check "jdbc:sqlserver://127.0.0.1/MEDUSA".. and if you can use it to connect to a JDBC database locally from your machine.. I don't think it will usually complain of an error for 127.0.0.1 which is the local loopback.. but this is not a bug with the ESB, but your JDBC url, driver and connections..
asankha