Hello again!
After my previous misadventure and thanks to Mengwei I have a functioning
connection to my SQL Server; at least Sqoop doesn't complain when setting up
the connection.
How do I specify which database on the server to use? I tried putting it in the
connection string 'jdbc:sqlserver://myserver\myInstance;database=mydatabase;'
but when submitting a job to import a table on that database I get
: Exception: java.lang.Throwable Message: Invalid object name 'dbo.tblFaelle'.
The table exists and is accessible to the user I use for credentials. The most
obvious cause to me, is that Sqoop is looking for the table outside the
database, or am I missing something?
Thanks!
Chris
------------------------------BEGIN TRACE -------------------------------
Exception has occurred during processing command
Server has returned exception: Exception: java.lang.Throwable Message:
GENERIC_JDBC_CONNECTOR_0002:Unable to execute the SQL statement
Stack trace:
at org.apache.sqoop.connector.jdbc.GenericJdbcExecutor
(GenericJdbcExecutor.java:59)
at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer
(GenericJdbcImportInitializer.java:155)
at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer
(GenericJdbcImportInitializer.java:48)
at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer
(GenericJdbcImportInitializer.java:37)
at org.apache.sqoop.framework.FrameworkManager
(FrameworkManager.java:447)
at org.apache.sqoop.handler.SubmissionRequestHandler
(SubmissionRequestHandler.java:112)
at org.apache.sqoop.handler.SubmissionRequestHandler
(SubmissionRequestHandler.java:98)
at org.apache.sqoop.handler.SubmissionRequestHandler
(SubmissionRequestHandler.java:68)
at org.apache.sqoop.server.v1.SubmissionServlet
(SubmissionServlet.java:44)
at org.apache.sqoop.server.SqoopProtocolServlet
(SqoopProtocolServlet.java:63)
at javax.servlet.http.HttpServlet (HttpServlet.java:637)
at javax.servlet.http.HttpServlet (HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain
(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain
(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve
(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve
(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve
(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve
(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve
(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter
(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor (Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler
(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker
(JIoEndpoint.java:489)
at java.lang.Thread (Thread.java:662)
Caused by: Exception: java.lang.Throwable Message: Invalid object name
'dbo.tblFaelle'.
Stack trace:
at com.microsoft.sqlserver.jdbc.SQLServerException
(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement
(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerStatement
(SQLServerStatement.java:792)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd
(SQLServerStatement.java:689)
at com.microsoft.sqlserver.jdbc.TDSCommand (IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection
(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement
(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement
(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerStatement
(SQLServerStatement.java:616)
at org.apache.sqoop.connector.jdbc.GenericJdbcExecutor
(GenericJdbcExecutor.java:56)
at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer
(GenericJdbcImportInitializer.java:155)
at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer
(GenericJdbcImportInitializer.java:48)
at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer
(GenericJdbcImportInitializer.java:37)
at org.apache.sqoop.framework.FrameworkManager
(FrameworkManager.java:447)
at org.apache.sqoop.handler.SubmissionRequestHandler
(SubmissionRequestHandler.java:112)
at org.apache.sqoop.handler.SubmissionRequestHandler
(SubmissionRequestHandler.java:98)
at org.apache.sqoop.handler.SubmissionRequestHandler
(SubmissionRequestHandler.java:68)
at org.apache.sqoop.server.v1.SubmissionServlet
(SubmissionServlet.java:44)
at org.apache.sqoop.server.SqoopProtocolServlet
(SqoopProtocolServlet.java:63)
at javax.servlet.http.HttpServlet (HttpServlet.java:637)
at javax.servlet.http.HttpServlet (HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain
(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain
(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve
(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve
(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve
(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve
(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve
(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter
(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor (Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler
(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker
(JIoEndpoint.java:489)
at java.lang.Thread (Thread.java:662)
--
initions AG
Christos Kallinteris
Weidestraße 120a
D-22083 Hamburg
t: +49 (0) 40 / 41 49 60-79
f: +49 (0) 40 / 41 49 60-11
e: [email protected]<mailto:[email protected]>
w: www.initions.com<http://www.initions.com/>
Vollständiger Name der Gesellschaft: initions innovative IT solutions AG
Sitz der Gesellschaft: Hamburg
Handelsregister Hamburg B 83929
Aufsichtsratsvorsitzender: Dr. Michael Leue
Vorstand: Dr. Stefan Anschütz, André Paul Henkel, Dr. Helge Plehn
