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 Plain View
Sqoop >> mail # dev >> Re: [jira] [Commented] (SQOOP-1164) sqoop picks up hsqldb driver jar when connect to mysql db, and failed


+
Venkat Ranganathan 2013-08-07, 15:54
Copy link to this message
-
Re: [jira] [Commented] (SQOOP-1164) sqoop picks up hsqldb driver jar when connect to mysql db, and failed
Yes. I added --verbose and the command is 'bin/sqoop import --connect
jdbc:mysql://hostname:3306/test --username user --password pwd --table
testtbl -m 1 --target-dir /tmp/test10 --verbose'. The output is:
13/08/07 18:35:16 DEBUG tool.BaseSqoopTool: Enabled debug logging.
13/08/07 18:35:16 WARN tool.BaseSqoopTool: Setting your password on the
command-line is insecure. Consider using -P instead.
13/08/07 18:35:16 DEBUG sqoop.ConnFactory: Loaded manager factory:
com.cloudera.sqoop.manager.DefaultManagerFactory
13/08/07 18:35:16 DEBUG sqoop.ConnFactory: Trying ManagerFactory:
com.cloudera.sqoop.manager.DefaultManagerFactory
13/08/07 18:35:16 DEBUG manager.DefaultManagerFactory: Trying with scheme:
jdbc:mysql:
13/08/07 18:35:16 INFO manager.MySQLManager: Preparing to use a MySQL
streaming resultset.
13/08/07 18:35:16 DEBUG sqoop.ConnFactory: Instantiated ConnManager
org.apache.sqoop.manager.MySQLManager@5fa55fa5
13/08/07 18:35:16 INFO tool.CodeGenTool: Beginning code generation
13/08/07 18:35:16 DEBUG manager.SqlManager: No connection paramenters
specified. Using regular API for making connection.
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)
        at org.apache.sqoop.Sqoop.main(Sqoop.java:238)

2013/8/7 Venkat Ranganathan <[EMAIL PROTECTED]>

> 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
> >

Sam Liu
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