Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

是否支持oracle，我看oracle建表的sql语句都是错误的 #6

Open
martinko2009 opened this issue Apr 27, 2017 · 3 comments
Open

是否支持oracle，我看oracle建表的sql语句都是错误的 #6

martinko2009 opened this issue Apr 27, 2017 · 3 comments

Comments

@martinko2009
Copy link

您好，请问这个程序是否支持oracle，我发现建表的oracle语句，在执行的时候都是错误的。
另外，我将application-dev.properties中的，
datasource.druid.url=jdbc:oracle:thin:@172.31.68.69:1521:oracledb
datasource.druid.username=username
datasource.druid.password=11111
datasource.druid.driverClassName=oracle.jdbc.driver.OracleDriver

启动后就报错如下：

2017-04-27 14:03:08 ERROR com.alibaba.druid.pool.DruidDataSource - dataSource in
it error
java.sql.SQLException: oracle.jdbc.driver.OracleDriver
        at com.alibaba.druid.util.JdbcUtils.createDriver(JdbcUtils.java:527)
        at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:597)

        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.
java:934)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.
java:930)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.
java:102)
        at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionPr
oviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139)
        at org.hibernate.engine.jdbc.internal.JdbcServicesImpl$ConnectionProvide
rJdbcConnectionAccess.obtainConnection(JdbcServicesImpl.java:279)
        at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcSer
vicesImpl.java:124)
        at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.conf
igureService(StandardServiceRegistryImpl.java:111)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initialize
Service(AbstractServiceRegistryImpl.java:234)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService
(AbstractServiceRegistryImpl.java:206)
        at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.
java:1887)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav
a:1845)
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.per
form(EntityManagerFactoryBuilderImpl.java:857)
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.per
form(EntityManagerFactoryBuilderImpl.java:850)
        at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceI
mpl.withTccl(ClassLoaderServiceImpl.java:425)
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build
(EntityManagerFactoryBuilderImpl.java:849)
        at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvi
der.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.ja
va:60)
        at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.cr
eateNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:343)
        at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPro
pertiesSet(AbstractEntityManagerFactoryBean.java:318)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:482)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:306)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:230)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:302)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:197)
        at org.springframework.context.support.AbstractApplicationContext.getBea
n(AbstractApplicationContext.java:1051)
        at org.springframework.context.support.AbstractApplicationContext.finish
BeanFactoryInitialization(AbstractApplicationContext.java:828)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:537)
        at org.springframework.boot.context.embedded.EmbeddedWebApplicationConte
xt.refresh(EmbeddedWebApplicationContext.java:118)
        at org.springframework.boot.SpringApplication.refresh(SpringApplication.
java:752)
        at org.springframework.boot.SpringApplication.doRun(SpringApplication.ja
va:347)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java
:295)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java
:1112)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java
:1101)
        at com.songwie.RootApplication.main(RootApplication.java:17)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner
.java:53)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at org.springframework.boot.loader.LaunchedURLClassLoader.doLoadClass(La
unchedURLClassLoader.java:166)
        at org.springframework.boot.loader.LaunchedURLClassLoader.loadClass(Laun
chedURLClassLoader.java:130)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Unknown Source)
        at com.alibaba.druid.util.JdbcUtils.createDriver(JdbcUtils.java:525)
        ... 43 more
2017-04-27 14:03:08 INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1
} inited
2017-04-27 14:03:08 WARN  org.hibernate.engine.jdbc.internal.JdbcServicesImpl -
HHH000342: Could not obtain connection to query metadata : oracle.jdbc.driver.Or
acleDriver
2017-04-27 14:03:10 INFO  org.apache.tiles.access.TilesAccess - Publishing Tiles
Context for context: org.springframework.web.servlet.view.tiles2.SpringWildcardS
ervletTilesApplicationContext
2017-04-27 14:03:11 INFO  org.quartz.impl.StdSchedulerFactory - Using default im
plementation for ThreadExecutor
2017-04-27 14:03:11 INFO  org.quartz.simpl.SimpleThreadPool - Job execution thre
ads will use class loader of thread: main
2017-04-27 14:03:11 INFO  org.quartz.core.SchedulerSignalerImpl - Initialized Sc
heduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
2017-04-27 14:03:11 INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2
.1.7 created.
2017-04-27 14:04:11 INFO  org.quartz.core.QuartzScheduler - Scheduler schedulerC
luster_$_NON_CLUSTERED shutting down.
2017-04-27 14:04:11 INFO  org.quartz.core.QuartzScheduler - Scheduler schedulerC
luster_$_NON_CLUSTERED paused.
2017-04-27 14:04:11 INFO  org.quartz.core.QuartzScheduler - Scheduler schedulerC
luster_$_NON_CLUSTERED shutdown complete.
2017-04-27 14:04:11 WARN  org.springframework.boot.context.embedded.AnnotationCo
nfigEmbeddedWebApplicationContext - Exception encountered during context initial
ization - cancelling refresh attempt: org.springframework.beans.factory.BeanCrea
tionException: Error creating bean with name 'schedulerCluster' defined in class
 path resource [applicationContext-quartz.xml]: Invocation of init method failed
; nested exception is java.lang.NullPointerException
2017-04-27 14:04:11 INFO  org.apache.tiles.access.TilesAccess - Removing TilesCo
ntext for context: org.springframework.web.servlet.view.tiles2.SpringWildcardSer
vletTilesApplicationContext
2017-04-27 14:04:11 INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1
} closed
2017-04-27 14:04:11 INFO  org.apache.catalina.core.StandardService - Stopping se
rvice Tomcat
2017-04-27 14:04:11 ERROR org.springframework.boot.SpringApplication - Applicati
on startup failed
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'schedulerCluster' defined in class path resource [applicationContext-qua
rtz.xml]: Invocation of init method failed; nested exception is java.lang.NullPo
interException
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:482)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:306)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:230)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:302)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:197)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:753)
        at org.springframework.context.support.AbstractApplicationContext.finish
BeanFactoryInitialization(AbstractApplicationContext.java:838)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:537)
        at org.springframework.boot.context.embedded.EmbeddedWebApplicationConte
xt.refresh(EmbeddedWebApplicationContext.java:118)
        at org.springframework.boot.SpringApplication.refresh(SpringApplication.
java:752)
        at org.springframework.boot.SpringApplication.doRun(SpringApplication.ja
va:347)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java
:295)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java
:1112)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java
:1101)
        at com.songwie.RootApplication.main(RootApplication.java:17)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner
.java:53)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
        at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDat
aSource.java:1120)
        at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataS
ource.java:960)
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterCha
inImpl.java:4544)
        at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(Sta
tFilter.java:661)
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterCha
inImpl.java:4540)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.
java:938)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.
java:930)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.
java:102)
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(D
ataSourceUtils.java:111)
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(Dat
aSourceUtils.java:77)
        at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(Jd
bcUtils.java:289)
        at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(Jd
bcUtils.java:329)
        at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initial
ize(LocalDataSourceJobStore.java:150)
        at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.j
ava:1318)
        at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.
java:1502)
        at org.springframework.scheduling.quartz.SchedulerFactoryBean.createSche
duler(SchedulerFactoryBean.java:597)
        at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPrope
rtiesSet(SchedulerFactoryBean.java:480)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)
        ... 22 more
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner
.java:53)
        at java.lang.Thread.run(Unknown Source)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'schedulerCluster' defined in class path resource [application
Context-quartz.xml]: Invocation of init method failed; nested exception is java.
lang.NullPointerException
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:482)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:306)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:230)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:302)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:197)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:753)
        at org.springframework.context.support.AbstractApplicationContext.finish
BeanFactoryInitialization(AbstractApplicationContext.java:838)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:537)
        at org.springframework.boot.context.embedded.EmbeddedWebApplicationConte
xt.refresh(EmbeddedWebApplicationContext.java:118)
        at org.springframework.boot.SpringApplication.refresh(SpringApplication.
java:752)
        at org.springframework.boot.SpringApplication.doRun(SpringApplication.ja
va:347)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java
:295)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java
:1112)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java
:1101)
        at com.songwie.RootApplication.main(RootApplication.java:17)
        ... 6 more
Caused by: java.lang.NullPointerException
        at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDat
aSource.java:1120)
        at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataS
ource.java:960)
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterCha
inImpl.java:4544)
        at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(Sta
tFilter.java:661)
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterCha
inImpl.java:4540)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.
java:938)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.
java:930)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.
java:102)
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(D
ataSourceUtils.java:111)
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(Dat
aSourceUtils.java:77)
        at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(Jd
bcUtils.java:289)
        at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(Jd
bcUtils.java:329)
        at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initial
ize(LocalDataSourceJobStore.java:150)
        at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.j
ava:1318)
        at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.
java:1502)
        at org.springframework.scheduling.quartz.SchedulerFactoryBean.createSche
duler(SchedulerFactoryBean.java:597)
        at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPrope
rtiesSet(SchedulerFactoryBean.java:480)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)
        ... 22 more
@songwie
Copy link
Owner

songwie commented Apr 27, 2017 via email

@martinko2009
Copy link
Author

但是oracle里是没有自增量的，插入主键需要用到sequence的，这样估计是不是需要修改java代码的

@songwie
Copy link
Owner

songwie commented Apr 27, 2017 via email

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@martinko2009 @songwie