derby 也有啊

Exception in thread "main" org.hibernate.InvalidMappingException: Could not parse mapping document from resource kt/com/User.hbm.xml

Caused by: org.hibernate.InvalidMappingException: Could not parse mapping document from invalid mapping
at org.hibernate.cfg.Configuration.addInputStream(Configuration.java:502)
at org.hibernate.cfg.Configuration.addResource(Configuration.java:566)
... 7 more
Caused by: org.xml.sax.SAXParseException: The content of element type "class" must match "(meta*,subselect?,cache?,synchronize*,comment?,tuplizer*,(id|composite-id),discriminator?,natural-id?,(version|timestamp)?,(property|many-to-one|one-to-one|component|dynamic-component|properties|any|map|set|list|bag|idbag|array|primitive-array)*,((join*,subclass*)|joined-subclass*|union-subclass*),loader?,sql-insert?,sql-update?,sql-delete?,filter*,resultset*,(query|sql-query)*)".


//CREATE TABLE user1 (
// id INT NOT NULL PRIMARY KEY,
// name VARCHAR(100) NOT NULL default '',
// age INT
//);

derby 的流水號欄位，怪，找不到

一直節外生枝

Hibernate 滿是挫折中…

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not get or update next value
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.engine.TransactionHelper$1Work.doWork(TransactionHelper.java:41)
at org.hibernate.engine.transaction.Isolater$JdbcDelegate.delegateWork(Isolater.java:187)
at org.hibernate.engine.transaction.Isolater.doIsolatedWork(Isolater.java:43)
at org.hibernate.engine.TransactionHelper.doWorkInNewTransaction(TransactionHelper.java:51)
at org.hibernate.id.TableGenerator.generate(TableGenerator.java:94)
at org.hibernate.id.TableHiLoGenerator.generate(TableHiLoGenerator.java:61)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at kt.com.FirstHibernate.main(FirstHibernate.java:29)
Caused by: java.sql.SQLException: Table/View 'HIBERNATE_UNIQUE_KEY' does not exist.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
at org.hibernate.id.TableGenerator.doWorkInCurrentTransaction(TableGenerator.java:131)
at org.hibernate.engine.TransactionHelper$1Work.doWork(TransactionHelper.java:38)
... 15 more
Caused by: org.apache.derby.client.am.SqlException: Table/View 'HIBERNATE_UNIQUE_KEY' does not exist.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
... 18 more

真是累

預計，在
年假回來後的那週。

就這兩枝報表
及出貨達成率的
一些待討論的地方，
開一跨部門的協調會(希望以生管單位為召開單位，將此計算公式，值得討論的地方跟業務單位協調，讓執行單位，能正確無誤的計算出合理的數字，
之前執行單因統計數字難判定的緣故，先以問卷試行過，也可以此問卷為基礎，現在面臨的狀況是執行單位自行對目標的kpi值進行設計及計算，而計算完後的結果，還需向使用單位進行討論及解釋，結果就是目前的狀況，報表做好了很久，仍覺得不合理)。


現在也正在了解預出貨金額統計表中，好像也是蠻多小細節待了解。

有點不一樣了，真得要更新，徒生挫折!切

root@mis01:~# apt-get install proftpd
Reading package lists... Done
Building dependency tree
Reading state information... Done
proftpd is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 27 not upgraded.

果然要更新來源的source檔，意思是我根本沒更新過來源!!

root@mis01:~# apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following extra packages will be installed:
libpq4 ucf
Recommended packages:
debconf-utils
The following NEW packages will be installed:
libpq4 ucf
0 upgraded, 2 newly installed, 0 to remove and 27 not upgraded.
1 not fully installed or removed.
Need to get 263kB of archives.
After unpacking 1016kB of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get:1 http://archive.ubuntu.com edgy/main ucf 2.0012 [55.2kB]
Get:2 http://security.ubuntu.com edgy-security/main libpq4 8.1.4-7ubuntu0.3 [207kB]
Fetched 263kB in 4s (52.8kB/s)
Preconfiguring packages ...
Selecting previously deselected package libpq4.
(Reading database ... 16645 files and directories currently installed.)
Unpacking libpq4 (from .../libpq4_8.1.4-7ubuntu0.3_amd64.deb) ...
Selecting previously deselected package ucf.
Unpacking ucf (from .../archives/ucf_2.0012_all.deb) ...
Moving old data out of the way
Setting up libpq4 (8.1.4-7ubuntu0.3) ...

Setting up ucf (2.0012) ...

Setting up proftpd (1.3.0-9ubuntu0.1) ...
Adding system user `proftpd' with uid 105...
Adding new user `proftpd' (105) with group `nogroup'.
Not creating home directory `/var/run/proftpd'.
Adding system user `ftp' with uid 106...
Adding new user `ftp' (106) with group `nogroup'.
Creating home directory `/home/ftp'.
`/usr/share/proftpd/templates/welcome.msg' -> `/home/ftp/welcome.msg.proftpd-new'
ProFTPd warning: cannot start neither in standalone nor in inetd/xinetd mode. Check your configuration.

還是要修改設定檔。

用tw 的來源

Get:75 http://apt.ubuntu.org.tw edgy-security/multiverse Sources [14B]
Get:76 http://apt.ubuntu.org.tw ubtw/ Packages [4807B]
Get:77 http://apt.ubuntu.org.tw ubtw-edgy/ Packages [979B]
Get:78 http://apt.ubuntu.org.tw ubtw-testing/ Packages [8034B]
Fetched 11.4MB in 22s (516kB/s)
Reading package lists... Done

Get:51 http://archive.ubuntu.com edgy-backports/universe Sources [5295B]
Get:52 http://archive.ubuntu.com edgy-backports/multiverse Sources [1466B]
Fetched 6468kB in 31s (204kB/s)
Reading package lists... Done
W: GPG error: http://medibuntu.sos-sts.com edgy Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 2EBC26B60C5A2783
W: You may want to run apt-get update to correct these problems


換來源應該是要更新一下。