Announcement Announcement Module
Collapse
No announcement yet.
Isue with Upload Files into Amazon S3 Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Isue with Upload Files into Amazon S3

    Hi All,


    To upload files into Amazon S3, I am using following two plug-ins,

    compile ":amazon-s3:0.8.2"
    compile ":quartz:1.0-RC9"


    When I start application, I am getting following error continously,

    2013-08-31 13:13:12,266 [quartzScheduler_Worker-1] ERROR util.JDBCExceptionReporter - Table 'schema.s3asset' doesn't exist
    2013-08-31 13:13:12,277 [quartzScheduler_Worker-1] ERROR listeners.ExceptionPrinterJobListener - Exception occurred in job: null
    org.quartz.JobExecutionException: org.hibernate.exception.SQLGrammarException: could not execute query [See nested exception: org.hibernate.exception.SQLGrammarException: could not execute query]
    at grails.plugins.quartz.GrailsJobFactory$GrailsJob.e xecute(GrailsJobFactory.java:96)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:2 13)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run (SimpleThreadPool.java:557)
    Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
    at grails.orm.PagedResultList.<init>(PagedResultList. java:55)
    at grails.orm.HibernateCriteriaBuilder.invokeMethod(H ibernateCriteriaBuilder.java:1612)
    at org.grails.s3.S3AssetService.syncRemoved(S3AssetSe rvice.groovy:349)
    at org.grails.s3.S3SyncRemovedJob.execute(S3SyncRemov edJob.groovy:44)
    at grails.plugins.quartz.GrailsJobFactory$GrailsJob.e xecute(GrailsJobFactory.java:89)
    ... 2 more
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Table 'schema.s3asset' doesn't exist
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:41 1)
    at com.mysql.jdbc.Util.getInstance(Util.java:386)
    at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1053)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4096)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4028)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 90)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2651)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2734)
    at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2155)
    at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:2322)
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:96 )
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:96 )
    ... 7 more

    I am not why it is coming, Can you any one please suggest why this problem is there and how I can resolve it ?



    Please also suggest, What is the best way( Plugins ) to upload files in Amazon S3 in Grails and I also want to read S3 Object details in another request like eTag,last modified,content type,file name,storage class.

    Can you any one please provide the blog or examples.



    Thanks

    Ravindar
Working...
X