VirtualJDBC Connection-hybris SQuirrel

[Former Member]

I'm trying to connect to hybris's datasource using SQuirrel and my local environment I have done the next steps: - Added the following jar's [hybris home]\ext-platform-optional\virtualjdbc\bin\virtualjdbcserver.jar [hybris home]\ext-platform-optional\virtualjdbc\lib\vjdbc.jar to the dir dir_squirrel/lib

• Added the driver with the following datos: name : VITUALJDBC example : URL: sql:http://localhost:9001/virtualjdbc/service

• Added a "Alias" with the following datos: Driver: VITUALJDBC URL: jdbc:hybris:sql:http://localhost:9001/virtualjdbc/service User Name: admin Password: nimda

When I try to test the connection, i get the error message: : java.sql.SQLException: java.io.IOException: Server returned HTTP response code: 400 for URL: http://localhost:9001/virtualjdbc/service at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1876) at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1474) at de.simplicit.vjdbc.servlet.ServletCommandSinkJdkHttpClient.connect(ServletCommandSinkJdkHttpClient.java:54) at de.hybris.vjdbc.VirtualConnectionBuilder.build(VirtualConnectionBuilder.java:87) at de.hybris.vjdbc.VirtualDriver.connect(VirtualDriver.java:70) at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133) at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167) at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45) at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:748)

 at de.simplicit.vjdbc.util.SQLExceptionHelper.wrapThrowable(SQLExceptionHelper.java:61)
 at de.simplicit.vjdbc.util.SQLExceptionHelper.wrap(SQLExceptionHelper.java:17)
 at de.simplicit.vjdbc.servlet.ServletCommandSinkJdkHttpClient.connect(ServletCommandSinkJdkHttpClient.java:66)
 at de.hybris.vjdbc.VirtualConnectionBuilder.build(VirtualConnectionBuilder.java:87)
 at de.hybris.vjdbc.VirtualDriver.connect(VirtualDriver.java:70)
 at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
 at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
 at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
 at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
 at java.lang.Thread.run(Thread.java:748)

This same error occur when I try to configure a Data Adapter with Jasper Studio 6.5.1 I'm using Hybris: 6.2 and SQuirrel: 3.8.1

Which is cause of the error?

[Former Member]

Problem solved, the port was being occupied by another program