Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # dev >> Re: [jira] [Commented] (SQOOP-1164) sqoop picks up hsqldb driver jar when connect to mysql db, and failed


Copy link to this message
-
Re: [jira] [Commented] (SQOOP-1164) sqoop picks up hsqldb driver jar when connect to mysql db, and failed
Can you please do the following

Add --verbose to the command line and attach the full log.
Thanks
Venkat
On Tue, Aug 6, 2013 at 11:59 PM, sam liu (JIRA) <[EMAIL PROTECTED]> wrote:

>
>     [
> https://issues.apache.org/jira/browse/SQOOP-1164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13731711#comment-13731711]
>
> sam liu commented on SQOOP-1164:
> --------------------------------
>
> I tried with --driver param, but it does not work for me, and returned the
> same exception.
>
> My command is 'bin/sqoop import --driver com.mysql.jdbc.Driver --connect
> jdbc:mysql://hostname:3306/test  --username user --password pwd --table
> testtbl -m 1 --target-dir /tmp/test6'.
>
> > sqoop picks up hsqldb driver jar when connect to mysql db, and failed
> > ---------------------------------------------------------------------
> >
> >                 Key: SQOOP-1164
> >                 URL: https://issues.apache.org/jira/browse/SQOOP-1164
> >             Project: Sqoop
> >          Issue Type: Bug
> >          Components: tools
> >    Affects Versions: 1.4.3
> >         Environment: RHEL 5.4 x86_64
> >            Reporter: sam liu
> >            Priority: Minor
> >
> > Under SQOOP/lib, I have both hsqldb driver jar file and mysql driver jar
> file:
> > - lib/hsqldb-1.8.0.10.jar
> > - lib/mysql-connector-java-5.1.20-bin.jar
> > But, when I try to connect to mysql db using sqoop import tool, sqoop
> will pick up hsqldb driver jar and returned following exception. Even if I
> add '--connection-manager org.apache.sqoop.manager.MySQLManager' into the
> command, this issue still exists. But, after I removed the hsqldb jar file
> from lib folder, this issue does not exist any more.
> > > bin/sqoop import --connect jdbc:mysql://hostname:3306/test
> --connection-manager org.apache.sqoop.manager.MySQLManager --username user
> --password pwd --table testtbl -m 1 --target-dir /tmp/test5
> > 13/08/05 18:44:03 WARN tool.BaseSqoopTool: Setting your password on the
> command-line is insecure. Consider using -P instead.
> > 13/08/05 18:44:03 INFO manager.MySQLManager: Preparing to use a MySQL
> streaming resultset.
> > 13/08/05 18:44:03 INFO tool.CodeGenTool: Beginning code generation
> > Exception in thread "main" java.lang.NoSuchMethodError:
> org/hsqldb/DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
> >         at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
> >         at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
> >         at java.sql.DriverManager.getConnection(DriverManager.java:402)
> >         at java.sql.DriverManager.getConnection(DriverManager.java:450)
> >         at
> org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:745)
> >         at
> org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
> >         at
> org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:605)
> >         at
> org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:628)
> >         at
> org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:235)
> >         at
> org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:219)
> >         at
> org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:283)
> >         at
> org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1255)
> >         at
> org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1072)
> >         at
> org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> >         at
> org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:390)
> >         at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
> >         at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> >         at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
> >         at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> >         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> >         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB