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 | 10 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    GitHub comment 6217#228619559

    GitHub | 10 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 | 3 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

    Debug « Middleware Magic

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

  1. osvzs 4 times, last 2 weeks ago
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