Announcement Announcement Module
No announcement yet.
Isue with Upload Files into Amazon S3 Page Title Module
Move Remove Collapse
Conversation Detail Module
  • 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(
    at 13)
    at org.quartz.simpl.SimpleThreadPool$ (
    Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
    at grails.orm.PagedResultList.<init>(PagedResultList. java:55)
    at grails.orm.HibernateCriteriaBuilder.invokeMethod(H
    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(
    ... 2 more
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Table 'schema.s3asset' doesn't exist
    at com.mysql.jdbc.Util.handleNewInstance( 1)
    at com.mysql.jdbc.Util.getInstance(
    at com.mysql.jdbc.SQLError.createSQLException(SQLErro
    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( 90)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect( :2651)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm
    at com.mysql.jdbc.PreparedStatement.executeInternal(P
    at com.mysql.jdbc.PreparedStatement.executeQuery(Prep
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery( )
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery( )
    ... 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.