Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> Java to Sqoop commands


+
Cyril Bogus 2013-03-02, 20:11
+
Jarek Jarcec Cecho 2013-03-02, 20:28
+
Cyril Bogus 2013-03-02, 21:33
Copy link to this message
-
Re: Java to Sqoop commands
It looks like your JDBC spec is wrong.   Can you  please make sure for
SQLServer your connect string is of the form
jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

See http://msdn.microsoft.com/en-us/library/ms378428(v=sql.90).aspx
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.
>>
>> Jarcec
>>
>> 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
>> sqoop.
>> >
>> > I have the Microsoft SQL - Hadoop connector in the lib and whenever I
>> run
>> > 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
>> everything
>> > 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
>>
>
>
--
Regards

Venkat
+
Jarek Jarcec Cecho 2013-03-04, 16:07
+
Cyril Bogus 2013-03-05, 17:21
+
Jarek Jarcec Cecho 2013-03-06, 19:42