login button

DBReport mediator

Project : Realm :

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

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

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

AttachmentSize
synapse.xml4.78 KB

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

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.