sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sathish (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-458) Sqoop connectivity issue with Sybase JZ0C0: Connection is already closed error
Date Fri, 09 Mar 2012 00:51:57 GMT
Sqoop connectivity issue with Sybase  JZ0C0: Connection is already closed error
-------------------------------------------------------------------------------

                 Key: SQOOP-458
                 URL: https://issues.apache.org/jira/browse/SQOOP-458
             Project: Sqoop
          Issue Type: Bug
          Components: connectors
    Affects Versions: 1.4.1-incubating
         Environment: Linux
            Reporter: sathish


Having problem in connecting sqoop with Sybase using com.sybase.jdbc3.jdbc.SybDriver

I am using the following command to connect to db. 

sqoop import --connect jdbc:sybase:Tds:mydbhost:3000/MyTestDB --table Test_Table -m 1  --username
scott --password tiger --driver com.sybase.jdbc3.jdbc.SybDriver

Please find the Exception below

12/03/08 16:46:06 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure.
Consider using -P instead.
12/03/08 16:46:06 INFO manager.SqlManager: Using default fetchSize of 1000
12/03/08 16:46:06 INFO tool.CodeGenTool: Beginning code generation
12/03/08 16:46:07 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException:
JZ0C0: Connection is already closed.

java.sql.SQLException: JZ0C0: Connection is already closed.
        at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.checkConnection(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.close(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.close(Unknown Source)
        at com.sybase.jdbc3.jdbc.MdaManager.a(Unknown Source)
        at com.sybase.jdbc3.jdbc.MdaManager.<init>(Unknown Source)
        at com.sybase.jdbc3.jdbc.MdaManager.<init>(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.getMDA(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.setOption(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.setTransactionIsolation(Unknown Source)
        at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:692)
        at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
        at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:473)
        at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:496)
        at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:194)
        at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:178)
        at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:114)
        at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1235)
        at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1060)
        at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
        at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
        at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        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)
        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57)
12/03/08 16:46:07 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException:
JZ0C0: Connection is already closed.
java.sql.SQLException: JZ0C0: Connection is already closed.
        at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.checkConnection(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.close(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.close(Unknown Source)
        at com.sybase.jdbc3.jdbc.MdaManager.a(Unknown Source)
        at com.sybase.jdbc3.jdbc.MdaManager.<init>(Unknown Source)
        at com.sybase.jdbc3.jdbc.MdaManager.<init>(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.getMDA(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.setOption(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.setTransactionIsolation(Unknown Source)
        at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:692)
        at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
        at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:473)
        at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:496)
        at org.apache.sqoop.manager.SqlManager.getColumnNamesForRawQuery(SqlManager.java:129)
        at org.apache.sqoop.manager.SqlManager.getColumnNames(SqlManager.java:113)
        at org.apache.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:1207)
        at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1062)
        at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
        at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
        at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        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)
        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57)




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message