-Re: Java to Sqoop commands
Venkat 2013-03-02, 21:55
It looks like your JDBC spec is wrong. Can you please make sure for
SQLServer your connect string is of the form
On Sat, Mar 2, 2013 at 1:33 PM, Cyril Bogus <[EMAIL PROTECTED]> wrote:
> Hi Jarek, thank you for your reply.
> The computer On which I run the job is not connected to the internet so
> all I can do is describe the output very briefly.
> And by the way I am running Sqoop 1.4.2
> Following your advice I have done the following
> javac Importer.java
> java -cp $CLASSPATH Importer
> CLASSPATH contains all libraries for sqoop, hive and Hadoop
> this is a brief description of the output:
> Using Hive Specific Import ....
> delimiters with --field-terminated by, etc.
> Got error creating database manager: java.io.IOException. No manager for
> connect string 'myserver:port/database;user;pass'
> Again the classpath contains all the jars AND when I just copy and paste
> the same command line that gave me an error in the program as a linux
> command everything runs smoothly to the end.
> On Sat, Mar 2, 2013 at 3:28 PM, Jarek Jarcec Cecho <[EMAIL PROTECTED]>wrote:
>> Hi Cyril,
>> when executing Sqoop from within your Java application, do you have all
>> the jars (connector, JDBC Driver) in the classpath? Also it would be
>> helpful if you could share exactly the error message that you're getting.
>> On Sat, Mar 02, 2013 at 03:11:40PM -0500, Cyril Bogus wrote:
>> > So, I am running a java program to import data from a sqlserver using
>> > I have the Microsoft SQL - Hadoop connector in the lib and whenever I
>> > commands from the command line the import runs fine.
>> > Problem is when my Java is the one trying to run the command then sqoop
>> > can't find the lib somehow so it does not connect to the DB.
>> > I try running the exact same query directly in command line and
>> > works fine.
>> > Is there a way where I can define both the driver and connection manager
>> > through Java as not to worry about it not finding the proper manager for
>> > import?
>> > Regards
>> > Cyril