org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Tomcat.class]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceInitializer': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #12 of URL [file:/Users/xxxx/IdeaProjects/dataman/build/resources/main/schema.sql]: begin select 1 into v_temp from dual; nested exception is java.sql.SQLException: ORA-06550: line 1, column 36: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ;

GitHub | jhvhs | 6 months ago
  1. 0

    GitHub comment 6217#228619559

    GitHub | 6 months ago | jhvhs
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Tomcat.class]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceInitializer': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #12 of URL [file:/Users/xxxx/IdeaProjects/dataman/build/resources/main/schema.sql]: begin select 1 into v_temp from dual; nested exception is java.sql.SQLException: ORA-06550: line 1, column 36: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ;
  2. 0

    Upgrade to 2.3.2 to 2.5.6 fails in Oracle

    GitHub | 2 years ago | joseorsini
    com.dotmarketing.exception.DotRuntimeException: ORA-02289: sequence does not exist
  3. 0

    Error loading fresh starter Oracle

    GitHub | 5 years ago | dotjorgeu
    java.sql.SQLException: ORA-00907: missing right parenthesis
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Java Sql Exception - No more data to read from socket

    Stack Overflow | 3 years ago | Ashish
    java.sql.SQLException: No more data to read from socket
  6. 0

    Debugging Basic JDBC Issues « WebLogic

    middlewaremagic.com | 1 week ago
    java.sql.SQLException: No more data to read from socket

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-06550: line 1, column 36: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ;

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      OracleStatementWrapper.execute
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)[ojdbc7.jar:12.1.0.2.0]
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)[ojdbc7.jar:12.1.0.2.0]
      3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)[ojdbc7.jar:12.1.0.2.0]
      4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)[ojdbc7.jar:12.1.0.2.0]
      5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)[ojdbc7.jar:12.1.0.2.0]
      6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)[ojdbc7.jar:12.1.0.2.0]
      7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)[ojdbc7.jar:12.1.0.2.0]
      8. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)[ojdbc7.jar:12.1.0.2.0]
      9. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:931)[ojdbc7.jar:12.1.0.2.0]
      10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)[ojdbc7.jar:12.1.0.2.0]
      11. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1792)[ojdbc7.jar:12.1.0.2.0]
      12. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1745)[ojdbc7.jar:12.1.0.2.0]
      13. oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:334)[ojdbc7.jar:12.1.0.2.0]
      13 frames
    3. org.springframework.jdbc
      DatabasePopulatorUtils.execute
      1. org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:473)[spring-jdbc-4.3.0.RC2.jar:4.3.0.RC2]
      2. org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.populate(ResourceDatabasePopulator.java:231)[spring-jdbc-4.3.0.RC2.jar:4.3.0.RC2]
      3. org.springframework.jdbc.datasource.init.DatabasePopulatorUtils.execute(DatabasePopulatorUtils.java:48)[spring-jdbc-4.3.0.RC2.jar:4.3.0.RC2]
      3 frames
    4. Spring Boot AutoConfigure
      DataSourceInitializer.init
      1. org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.runScripts(DataSourceInitializer.java:169)[spring-boot-autoconfigure-1.4.0.M3.jar:1.4.0.M3]
      2. org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.runSchemaScripts(DataSourceInitializer.java:84)[spring-boot-autoconfigure-1.4.0.M3.jar:1.4.0.M3]
      3. org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.init(DataSourceInitializer.java:76)[spring-boot-autoconfigure-1.4.0.M3.jar:1.4.0.M3]
      3 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.8.0_74]
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)[na:1.8.0_74]
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.8.0_74]
      4. java.lang.reflect.Method.invoke(Method.java:498)[na:1.8.0_74]
      4 frames
    6. Spring Beans
      DefaultListableBeanFactory.getBean
      1. org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:365)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      2. org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:310)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      3. org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      4. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:408)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      5. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1570)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      6. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      7. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      8. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      9. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      10. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      11. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:220)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      12. org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:352)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      13. org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:333)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      13 frames
    7. Spring Boot AutoConfigure
      DataSourceInitializerPostProcessor.postProcessAfterInitialization
      1. org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerPostProcessor.postProcessAfterInitialization(DataSourceInitializerPostProcessor.java:62)[spring-boot-autoconfigure-1.4.0.M3.jar:1.4.0.M3]
      1 frame
    8. Spring Beans
      DefaultListableBeanFactory.preInstantiateSingletons
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:422)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1583)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      3. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      4. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      5. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      6. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      7. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      8. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      9. org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:187)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      10. org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1208)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      11. org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1048)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      12. org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1018)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      13. org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:834)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      14. org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      15. org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      16. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1143)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      17. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1046)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      18. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:510)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      19. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      20. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      21. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      22. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      23. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      24. org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:775)[spring-beans-4.3.0.RC2.jar:4.3.0.RC2]
      24 frames
    9. Spring Context
      AbstractApplicationContext.refresh
      1. org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:861)[spring-context-4.3.0.RC2.jar:4.3.0.RC2]
      2. org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:541)[spring-context-4.3.0.RC2.jar:4.3.0.RC2]
      2 frames
    10. Spring Boot
      SpringApplication.run
      1. org.springframework.boot.SpringApplication.refresh(SpringApplication.java:765)[spring-boot-1.4.0.M3.jar:1.4.0.M3]
      2. org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:370)[spring-boot-1.4.0.M3.jar:1.4.0.M3]
      3. org.springframework.boot.SpringApplication.run(SpringApplication.java:314)[spring-boot-1.4.0.M3.jar:1.4.0.M3]
      4. org.springframework.boot.SpringApplication.run(SpringApplication.java:1182)[spring-boot-1.4.0.M3.jar:1.4.0.M3]
      5. org.springframework.boot.SpringApplication.run(SpringApplication.java:1171)[spring-boot-1.4.0.M3.jar:1.4.0.M3]
      5 frames
    11. io.pivotal.dataman
      MyApplication.main
      1. io.pivotal.dataman.MyApplication$Companion.main(MyApplication.kt:10)[main/:na]
      2. io.pivotal.dataman.MyApplication.main(MyApplication.kt)[main/:na]
      2 frames