我用的是书上的源码,书上说明是:
1、用imp PERSONNEL_MANAGE/MWQ@DBSQL file=C:\personnel_manage.dmp fromuser=PERSONNEL_MANAGE ignore=y commit=y grants=y;导入,但是用不了,只能去掉]@DBSQL导入。
2、修改如下代码中用来连接数据库的URL,以及连接数据库的用户名和密码。
<property name="connection.url"><!-- 配置数据库的连接路径 -->
jdbc:oracle:thin:@127.0.0.1:1521:DBSQL
</property>
<property name="connection.username">PERSONNEL_MANAGE</property><!-- 配置数据库的连接用户名 -->
<property name="connection.password">MWQ</property><!-- 配置数据库的连接密码,这里密码为空,在这种情况下也可以省略该行配置代码 -->
但是我不知道怎么修改?结果运行后出现下面的错误提示:
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "AWT-EventQueue-0" java.lang.ExceptionInInitializerError
at org.hibernate.cfg.Configuration.reset(Configuration.java:174)
at org.hibernate.cfg.Configuration.<init>(Configuration.java:193)
at org.hibernate.cfg.Configuration.<init>(Configuration.java:197)
at com.mwq.hibernate.HibernateSessionFactory.<clinit>(HibernateSessionFactory.java:16)
at com.mwq.hibernate.BaseDao.queryList(BaseDao.java:29)
at com.mwq.hibernate.Dao.queryManagerOfNatural(Dao.java:141)
at com.mwq.frame.LandFrame.<init>(LandFrame.java:100)
at com.mwq.PersonnelManage.land(PersonnelManage.java:32)
at com.mwq.PersonnelManage$1.run(PersonnelManage.java:26)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Caused by: java.lang.NullPointerException
at org.hibernate.util.ConfigHelper.getResourceAsStream(ConfigHelper.java:144)
at org.hibernate.cfg.Environment.<clinit>(Environment.java:529)
... 17 more望高手指点,谢谢!!
1、用imp PERSONNEL_MANAGE/MWQ@DBSQL file=C:\personnel_manage.dmp fromuser=PERSONNEL_MANAGE ignore=y commit=y grants=y;导入,但是用不了,只能去掉]@DBSQL导入。
2、修改如下代码中用来连接数据库的URL,以及连接数据库的用户名和密码。
<property name="connection.url"><!-- 配置数据库的连接路径 -->
jdbc:oracle:thin:@127.0.0.1:1521:DBSQL
</property>
<property name="connection.username">PERSONNEL_MANAGE</property><!-- 配置数据库的连接用户名 -->
<property name="connection.password">MWQ</property><!-- 配置数据库的连接密码,这里密码为空,在这种情况下也可以省略该行配置代码 -->
但是我不知道怎么修改?结果运行后出现下面的错误提示:
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "AWT-EventQueue-0" java.lang.ExceptionInInitializerError
at org.hibernate.cfg.Configuration.reset(Configuration.java:174)
at org.hibernate.cfg.Configuration.<init>(Configuration.java:193)
at org.hibernate.cfg.Configuration.<init>(Configuration.java:197)
at com.mwq.hibernate.HibernateSessionFactory.<clinit>(HibernateSessionFactory.java:16)
at com.mwq.hibernate.BaseDao.queryList(BaseDao.java:29)
at com.mwq.hibernate.Dao.queryManagerOfNatural(Dao.java:141)
at com.mwq.frame.LandFrame.<init>(LandFrame.java:100)
at com.mwq.PersonnelManage.land(PersonnelManage.java:32)
at com.mwq.PersonnelManage$1.run(PersonnelManage.java:26)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Caused by: java.lang.NullPointerException
at org.hibernate.util.ConfigHelper.getResourceAsStream(ConfigHelper.java:144)
at org.hibernate.cfg.Environment.<clinit>(Environment.java:529)
... 17 more望高手指点,谢谢!!
/u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
这个文件里配置的参考我的ora1配置:ORA1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora1)
)
)
c:\>tnsping dbsql能通了,你的imp才能执行
错误提示:
TNS-03505:无法解析名称
提示:
已使用的参数文件:
E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\sqlnet.ora
已使用tnsnames适配器来解析别名.....
这样算不算解析成功?
其实是打开net configuration assistant后,本地服务名配置,测试成功后,将服务名重命名为dbsql1即可。
conn 用户名/密码@dbsql1 或如:
imp PERSONNEL_MANAGE/MWQ@DBSQL1...来引用。