Menu
▾
▴
j-trac-users — JTrac users
You can subscribe to this list here.
| 2006 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
(3) |
Nov
(20) |
Dec
(3) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2007 |
Jan
(6) |
Feb
(7) |
Mar
(45) |
Apr
(9) |
May
(9) |
Jun
(11) |
Jul
(13) |
Aug
(2) |
Sep
(33) |
Oct
(10) |
Nov
(5) |
Dec
(6) |
| 2008 |
Jan
(4) |
Feb
(46) |
Mar
(18) |
Apr
(14) |
May
(7) |
Jun
(34) |
Jul
(16) |
Aug
(7) |
Sep
(5) |
Oct
|
Nov
(4) |
Dec
|
| 2009 |
Jan
|
Feb
(2) |
Mar
|
Apr
(3) |
May
(10) |
Jun
|
Jul
(16) |
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
(1) |
| 2010 |
Jan
(9) |
Feb
(3) |
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
|
Aug
(9) |
Sep
(14) |
Oct
|
Nov
|
Dec
(4) |
| 2011 |
Jan
|
Feb
(3) |
Mar
|
Apr
|
May
|
Jun
|
Jul
(4) |
Aug
|
Sep
|
Oct
(4) |
Nov
(2) |
Dec
|
| 2012 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2017 |
Jan
|
Feb
|
Mar
(4) |
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
(1) |
Nov
(1) |
Dec
(1) |
| 2022 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2023 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
(1) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2024 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Mihails A. <_m...@in...> - 2008-06-06 11:40:43
|
Sure, you can! Check out the code and modify the layout as you wish. Quoting Erba Pablo-ape004 : /**/ Hi again, is possible to include a top section (with the company logo ) or a botton section? thanks! pablo. Ar cieņu, Mihails Links: ------ [1] mailto:ap...@mo... |
|
From: Erba Pablo-a. <ap...@mo...> - 2008-06-05 19:51:32
|
Hi again, is possible to include a top section (with the company logo ) or a botton section? thanks! pablo. |
|
From: Peter T. <ptr...@gm...> - 2008-06-05 18:17:00
|
Hi, As far as I know, the *.log file is rolled into the *.script file when the app / database is shut down. It is normal to have the *.log file grow when JTrac has been running for a while. I am using it at work with no issues. You mean is HSQLDB safe in production? Purely from my experience, I would say yes. Of course, do have a regular backup of the jtrac.home (data and attachments) done. Thanks, Peter. 2008/6/5 Erba Pablo-ape004 <ap...@mo...>: > Thanks a lot Thomas, I finally found the db at c:\Documents and > Settings\Default User and accessed it using RazrSQL, thanks again. > > I ´ve another doubt, i´m monitoring the db folder and i could see only the > .log files is being updated when i m working on Jtrack, do you know when > finally if goes to DB instead of having the modifications "in memory"? > > is JTrac safe to use on production environment? > > I´m new with JTrac > > > thanks in advance, Pablo. > > ------------------------------ > *From:* j-t...@li... [mailto: > j-t...@li...] *On Behalf Of *Peter Thomas > *Sent:* Jueves, 05 de Junio de 2008 02:46 p.m. > > *To:* JTrac users mailing-list > *Subject:* Re: [jtrac-users] Jtrac Admin > > Hi, > > I just added instructions on how to access the HSQLDB database and run SQL > statements at this forum thread: > > http://sourceforge.net/forum/forum.php?thread_id=1820234&forum_id=552477 > > Thanks, > > Peter. > > 2008/6/5 Erba Pablo-ape004 <ap...@mo...>: > >> How can i access the DB directly? It uses HSQLDB and i cant find this on >> the /track root folder , there is not db folder >> >> thanks a lot for your help! >> >> ------------------------------ >> *From:* j-t...@li... [mailto: >> j-t...@li...] *On Behalf Of *Mihails >> Agafonovs >> *Sent:* Jueves, 05 de Junio de 2008 01:46 p.m. >> *To:* JTrac users mailing-list >> *Subject:* Re: [jtrac-users] Jtrac Admin >> >> Change it in the database. >> >> Quoting *Erba Pablo-ape004 <ap...@mo...>*: >> >> Hi , How can I recover admin password? >> >> I have direct access to the server where its hosted. >> >> Thanks! >> >> ------------------------------------------------------------------------- >> Check out the new SourceForge.net Marketplace. >> It's the best place to buy or sell services for >> just about anything Open Source. >> http://sourceforge.net/services/buy/index.php >> _______________________________________________ >> j-trac-users mailing list >> j-t...@li... >> https://lists.sourceforge.net/lists/listinfo/j-trac-users >> >> >> >> >> Ar cieņu, Mihails >> >> ------------------------------------------------------------------------- >> Check out the new SourceForge.net Marketplace. >> It's the best place to buy or sell services for >> just about anything Open Source. >> http://sourceforge.net/services/buy/index.php >> _______________________________________________ >> j-trac-users mailing list >> j-t...@li... >> https://lists.sourceforge.net/lists/listinfo/j-trac-users >> >> > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > j-trac-users mailing list > j-t...@li... > https://lists.sourceforge.net/lists/listinfo/j-trac-users > > |
|
From: Erba Pablo-a. <ap...@mo...> - 2008-06-05 17:49:27
|
Thanks a lot Thomas, I finally found the db at c:\Documents and Settings\Default User and accessed it using RazrSQL, thanks again. I ´ve another doubt, i´m monitoring the db folder and i could see only the .log files is being updated when i m working on Jtrack, do you know when finally if goes to DB instead of having the modifications "in memory"? is JTrac safe to use on production environment? I´m new with JTrac thanks in advance, Pablo. ________________________________ From: j-t...@li... [mailto:j-t...@li...] On Behalf Of Peter Thomas Sent: Jueves, 05 de Junio de 2008 02:46 p.m. To: JTrac users mailing-list Subject: Re: [jtrac-users] Jtrac Admin Hi, I just added instructions on how to access the HSQLDB database and run SQL statements at this forum thread: http://sourceforge.net/forum/forum.php?thread_id=1820234&forum_id=552477 Thanks, Peter. 2008/6/5 Erba Pablo-ape004 <ap...@mo...>: How can i access the DB directly? It uses HSQLDB and i cant find this on the /track root folder , there is not db folder thanks a lot for your help! ________________________________ From: j-t...@li... [mailto:j-t...@li...] On Behalf Of Mihails Agafonovs Sent: Jueves, 05 de Junio de 2008 01:46 p.m. To: JTrac users mailing-list Subject: Re: [jtrac-users] Jtrac Admin Change it in the database. Quoting Erba Pablo-ape004 <ap...@mo...>: Hi , How can I recover admin password? I have direct access to the server where its hosted. Thanks! ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ j-trac-users mailing list j-t...@li... https://lists.sourceforge.net/lists/listinfo/j-trac-users Ar cieņu, Mihails ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ j-trac-users mailing list j-t...@li... https://lists.sourceforge.net/lists/listinfo/j-trac-users |
|
From: Peter T. <ptr...@gm...> - 2008-06-05 17:45:38
|
Hi, I just added instructions on how to access the HSQLDB database and run SQL statements at this forum thread: http://sourceforge.net/forum/forum.php?thread_id=1820234&forum_id=552477 Thanks, Peter. 2008/6/5 Erba Pablo-ape004 <ap...@mo...>: > How can i access the DB directly? It uses HSQLDB and i cant find this on > the /track root folder , there is not db folder > > thanks a lot for your help! > > ------------------------------ > *From:* j-t...@li... [mailto: > j-t...@li...] *On Behalf Of *Mihails > Agafonovs > *Sent:* Jueves, 05 de Junio de 2008 01:46 p.m. > *To:* JTrac users mailing-list > *Subject:* Re: [jtrac-users] Jtrac Admin > > Change it in the database. > > Quoting *Erba Pablo-ape004 <ap...@mo...>*: > > Hi , How can I recover admin password? > > I have direct access to the server where its hosted. > > Thanks! > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > j-trac-users mailing list > j-t...@li... > https://lists.sourceforge.net/lists/listinfo/j-trac-users > > > > > Ar cieņu, Mihails > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > j-trac-users mailing list > j-t...@li... > https://lists.sourceforge.net/lists/listinfo/j-trac-users > > |
|
From: Erba Pablo-a. <ap...@mo...> - 2008-06-05 16:48:42
|
How can i access the DB directly? It uses HSQLDB and i cant find this on the /track root folder , there is not db folder thanks a lot for your help! ________________________________ From: j-t...@li... [mailto:j-t...@li...] On Behalf Of Mihails Agafonovs Sent: Jueves, 05 de Junio de 2008 01:46 p.m. To: JTrac users mailing-list Subject: Re: [jtrac-users] Jtrac Admin Change it in the database. Quoting Erba Pablo-ape004 <ap...@mo...>: Hi , How can I recover admin password? I have direct access to the server where its hosted. Thanks! ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ j-trac-users mailing list j-t...@li... https://lists.sourceforge.net/lists/listinfo/j-trac-users Ar cieņu, Mihails |
|
From: Peter T. <ptr...@gm...> - 2008-06-05 16:48:02
|
You can find instructions here: http://sourceforge.net/forum/forum.php?thread_id=1820234&forum_id=552477 2008/6/5 Mihails Agafonovs <_m...@in...>: > Change it in the database. > > > Quoting *Erba Pablo-ape004 <ap...@mo...>*: > > Hi , How can I recover admin password? > > I have direct access to the server where its hosted. > > Thanks! > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > j-trac-users mailing list > j-t...@li... > https://lists.sourceforge.net/lists/listinfo/j-trac-users > > > > > Ar cieņu, Mihails > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > j-trac-users mailing list > j-t...@li... > https://lists.sourceforge.net/lists/listinfo/j-trac-users > > |
|
From: Mihails A. <_m...@in...> - 2008-06-05 16:46:54
|
Change it in the database. Quoting Erba Pablo-ape004 : Hi , How can I recover admin password? I have direct access to the server where its hosted. Thanks! ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ j-trac-users mailing list j-t...@li... https://lists.sourceforge.net/lists/listinfo/j-trac-users Ar cieņu, Mihails Links: ------ [1] mailto:ap...@mo... |
|
From: Erba Pablo-a. <ap...@mo...> - 2008-06-05 16:25:46
|
Hi , How can I recover admin password? I have direct access to the server where its hosted. Thanks! |
|
From: Bartolomeo N. <bni...@si...> - 2008-05-23 07:46:17
|
Hi,
I was evaluating jtrac inserting some issue in a space. From the browser
it seem flawless, but looking at catalina.out of tomcat:
ERROR [org.hibernate.util.JDBCExceptionReporter] - Termine
inaspettato: ) in statement [select top ? this_.id as id0_2_,
this_.version as version0_2_, this_.type as type0_2_, this_.parent_id as
parent4_0_2_, this_.space_id as space5_0_2_, this_.sequence_num as
sequence6_0_2_, this_.time_stamp as time7_0_2_, this_.planned_effort as
planned8_0_2_, this_.logged_by as logged9_0_2_, this_.assigned_to as
assigned10_0_2_, this_.summary as summary0_2_, this_.detail as
detail0_2_, this_.status as status0_2_, this_.severity as severity0_2_,
this_.priority as priority0_2_, this_.cus_dbl_01 as cus16_0_2_,
this_.cus_dbl_02 as cus17_0_2_, this_.cus_dbl_03 as cus18_0_2_,
this_.cus_int_01 as cus19_0_2_, this_.cus_int_02 as cus20_0_2_,
this_.cus_int_03 as cus21_0_2_, this_.cus_int_04 as cus22_0_2_,
this_.cus_int_05 as cus23_0_2_, this_.cus_int_06 as cus24_0_2_,
this_.cus_int_07 as cus25_0_2_, this_.cus_int_08 as cus26_0_2_,
this_.cus_int_09 as cus27_0_2_, this_.cus_int_10 as cus28_0_2_,
this_.cus_str_01 as cus29_0_2_, this_.cus_str_02 as cus30_0_2_,
this_.cus_str_03 as cus31_0_2_, this_.cus_str_04 as cus32_0_2_,
this_.cus_str_05 as cus33_0_2_, this_.cus_tim_01 as cus34_0_2_,
this_.cus_tim_02 as cus35_0_2_, this_.cus_tim_03 as cus36_0_2_,
space1_.id as id8_0_, space1_.version as version8_0_, space1_.type as
type8_0_, space1_.prefix_code as prefix4_8_0_, space1_.name as name8_0_,
space1_.description as descript6_8_0_, space1_.guest_allowed as
guest7_8_0_, space1_.metadata_id as metadata8_8_0_, spaceseque4_.id as
id9_1_, spaceseque4_.next_seq_num as next2_9_1_ from items this_ inner
join spaces space1_ on this_.space_id=space1_.id left outer join
space_sequence spaceseque4_ on space1_.id=spaceseque4_.id where
this_.space_id in () order by space1_.name desc, this_.id desc]
2008-05-23 09:34:06,745 [http-8080-Processor23] ERROR
[org.apache.wicket.RequestCycle] - could not execute query; nested
exception is org.hibernate.exception.SQLGrammarException: could not
execute query
org.springframework.dao.InvalidDataAccessResourceUsageException: could
not execute query; nested exception is
org.hibernate.exception.SQLGrammarException: could not execute query
at
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:613)
at
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:378)
at
org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1000)
at
info.jtrac.hibernate.HibernateJtracDao.findItems(HibernateJtracDao.java:97)
at info.jtrac.JtracImpl.findItems(JtracImpl.java:342)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy1.findItems(Unknown Source)
at info.jtrac.wicket.ItemListPanel$1.load(ItemListPanel.java:68)
at
org.apache.wicket.model.LoadableDetachableModel.getObject(LoadableDetachableModel.java:114)
at info.jtrac.wicket.ItemListPanel.<init>(ItemListPanel.java:74)
at info.jtrac.wicket.ItemListPage.<init>(ItemListPage.java:25)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at java.lang.Class.newInstance0(Class.java:355)
at java.lang.Class.newInstance(Class.java:308)
at
org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:58)
at
org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.newPage(BookmarkablePageRequestTarget.java:262)
at
org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.getPage(BookmarkablePageRequestTarget.java:283)
at
org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.processEvents(BookmarkablePageRequestTarget.java:210)
at
org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:90)
at
org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1166)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1241)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:493)
at
org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:354)
at
org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:194)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.hibernate.exception.SQLGrammarException: could not
execute query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at org.springframework.orm.hibernate3.HibernateTemplate
$36.doInHibernate(HibernateTemplate.java:1010)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373)
... 53 more
Caused by: java.sql.SQLException: Termine inaspettato: ) in statement
[select top ? this_.id as id0_2_, this_.version as version0_2_,
this_.type as type0_2_, this_.parent_id as parent4_0_2_, this_.space_id
as space5_0_2_, this_.sequence_num as sequence6_0_2_, this_.time_stamp
as time7_0_2_, this_.planned_effort as planned8_0_2_, this_.logged_by as
logged9_0_2_, this_.assigned_to as assigned10_0_2_, this_.summary as
summary0_2_, this_.detail as detail0_2_, this_.status as status0_2_,
this_.severity as severity0_2_, this_.priority as priority0_2_,
this_.cus_dbl_01 as cus16_0_2_, this_.cus_dbl_02 as cus17_0_2_,
this_.cus_dbl_03 as cus18_0_2_, this_.cus_int_01 as cus19_0_2_,
this_.cus_int_02 as cus20_0_2_, this_.cus_int_03 as cus21_0_2_,
this_.cus_int_04 as cus22_0_2_, this_.cus_int_05 as cus23_0_2_,
this_.cus_int_06 as cus24_0_2_, this_.cus_int_07 as cus25_0_2_,
this_.cus_int_08 as cus26_0_2_, this_.cus_int_09 as cus27_0_2_,
this_.cus_int_10 as cus28_0_2_, this_.cus_str_01 as cus29_0_2_,
this_.cus_str_02 as cus30_0_2_, this_.cus_str_03 as cus31_0_2_,
this_.cus_str_04 as cus32_0_2_, this_.cus_str_05 as cus33_0_2_,
this_.cus_tim_01 as cus34_0_2_, this_.cus_tim_02 as cus35_0_2_,
this_.cus_tim_03 as cus36_0_2_, space1_.id as id8_0_, space1_.version as
version8_0_, space1_.type as type8_0_, space1_.prefix_code as
prefix4_8_0_, space1_.name as name8_0_, space1_.description as
descript6_8_0_, space1_.guest_allowed as guest7_8_0_,
space1_.metadata_id as metadata8_8_0_, spaceseque4_.id as id9_1_,
spaceseque4_.next_seq_num as next2_9_1_ from items this_ inner join
spaces space1_ on this_.space_id=space1_.id left outer join
space_sequence spaceseque4_ on space1_.id=spaceseque4_.id where
this_.space_id in () order by space1_.name desc, this_.id desc]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown
Source)
at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.jdbc.datasource.SingleConnectionDataSource
$CloseSuppressingInvocationHandler.invoke(SingleConnectionDataSource.java:338)
at $Proxy0.prepareStatement(Unknown Source)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
at
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
at org.hibernate.loader.Loader.doQuery(Loader.java:673)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 60 more
|
|
From: Steven J. <Ste...@th...> - 2008-05-21 08:09:29
|
I am on vacation until Tuesday, May 27. If you require immediate
assistance, please contact Patrick Wong at x5891.
Thank you.
>>> j-trac-users 05/21/08 04:08 >>>
Hi,
I'm trying to use jtrac on tomcat 5.5.23, jdk6.0 and ubuntu 7.04. I've
downloaded jtrac2.1.0.zip and exctracted jtrac.war to tomcat/webapps.
Then I've restarted tomcat and logged in as admin/admin. I can create
new users, but when I try to create a new Space I got 'Internal Error'.
The log from catalina.out follows.
Your help is much appreciated. Best Regards.
INFO: Deploying web application archive jtrac.war
log4j:WARN No appenders could be found for logger
(org.apache.commons.digester.Digester.sax).
log4j:WARN Please initialize the log4j system properly.
2008-05-21 09:32:25,598 [main] INFO [info.jtrac.config.JtracConfigurer]
- found 'jtrac-init.properties' on classpath, processing...
2008-05-21 09:32:25,600 [main] INFO [info.jtrac.config.JtracConfigurer]
- locales available configured are
'en,de,el,es,es_AR,es_MX,fr,it,ja,nl,pl,pt_BR,ru,zh_CN,zh_TW'
2008-05-21 09:32:25,601 [main] INFO [info.jtrac.config.JtracConfigurer]
- valid 'jtrac.home' property not available in 'jtrac-init.properties',
trying system properties.
2008-05-21 09:32:25,601 [main] INFO [info.jtrac.config.JtracConfigurer]
- valid 'jtrac.home' property not available in system properties, trying
servlet init paramters.
2008-05-21 09:32:25,601 [main] WARN [info.jtrac.config.JtracConfigurer]
- Servlet init paramter 'jtrac.home' does not exist. Will use
'user.home' directory '/home/user/.jtrac'
2008-05-21 09:32:25,601 [main] INFO [info.jtrac.config.JtracConfigurer]
- directory does not exist, created '/home/user/.jtrac'
2008-05-21 09:32:25,601 [main] INFO [info.jtrac.config.JtracConfigurer]
- directory does not exist, created '/home/user/.jtrac/attachments'
2008-05-21 09:32:25,602 [main] INFO [info.jtrac.config.JtracConfigurer]
- directory does not exist, created '/home/user/.jtrac/indexes'
2008-05-21 09:32:25,602 [main] INFO [info.jtrac.config.JtracConfigurer]
- properties file does not exist, created
'/home/user/.jtrac/jtrac.properties'
2008-05-21 09:32:25,602 [main] INFO [info.jtrac.config.JtracConfigurer]
- HSQLDB will be used. Finished creating
'/home/user/.jtrac/jtrac.properties'
2008-05-21 09:32:25,603 [main] INFO [info.jtrac.config.JtracConfigurer]
- found 'jtrac-version.properties' on classpath, processing...
2008-05-21 09:32:25,603 [main] INFO [info.jtrac.config.JtracConfigurer]
- jtrac.version = '2.1.0'
2008-05-21 09:32:25,603 [main] INFO [info.jtrac.config.JtracConfigurer]
- jtrac.timestamp = '200803022120'
2008-05-21 09:32:25,604 [main] INFO [info.jtrac.config.JtracConfigurer]
- Loading properties file from file [/home/user/.jtrac/jtrac.properties]
2008-05-21 09:32:25,775 [main] INFO
[info.jtrac.config.DataSourceFactoryBean] - embedded HSQLDB mode
detected, switching on spring single connection data source
2008-05-21 09:32:28,679 [main] WARN
[org.hibernate.util.JDBCExceptionReporter] - SQL Error: -22, SQLState:
S0002
2008-05-21 09:32:28,679 [main] ERROR
[org.hibernate.util.JDBCExceptionReporter] - Tabella non trovata in
statement [select item0_.id as id0_, item0_.version as version0_,
item0_.type as type0_, item0_.parent_id as parent4_0_, item0_.space_id
as space5_0_, item0_.sequence_num as sequence6_0_, item0_.time_stamp as
time7_0_, item0_.planned_effort as planned8_0_, item0_.logged_by as
logged9_0_, item0_.assigned_to as assigned10_0_, item0_.summary as
summary0_, item0_.detail as detail0_, item0_.status as status0_,
item0_.severity as severity0_, item0_.priority as priority0_,
item0_.cus_dbl_01 as cus16_0_, item0_.cus_dbl_02 as cus17_0_,
item0_.cus_dbl_03 as cus18_0_, item0_.cus_int_01 as cus19_0_,
item0_.cus_int_02 as cus20_0_, item0_.cus_int_03 as cus21_0_,
item0_.cus_int_04 as cus22_0_, item0_.cus_int_05 as cus23_0_,
item0_.cus_int_06 as cus24_0_, item0_.cus_int_07 as cus25_0_,
item0_.cus_int_08 as cus26_0_, item0_.cus_int_09 as cus27_0_,
item0_.cus_int_10 as cus28_0_, item0_.cus_str_01 as cus29_0_,
item0_.cus_str_02 as cus30_0_, item0_.cus_str_03 as cus31_0_,
item0_.cus_str_04 as cus32_0_, item0_.cus_str_05 as cus33_0_,
item0_.cus_tim_01 as cus34_0_, item0_.cus_tim_02 as cus35_0_,
item0_.cus_tim_03 as cus36_0_ from items item0_ where item0_.id=1]
2008-05-21 09:32:28,684 [main] WARN
[info.jtrac.hibernate.HibernateJtracDao] - expected database schema does
not exist, will create. Error is: could not execute query; nested
exception is org.hibernate.exception.SQLGrammarException: could not
execute query
2008-05-21 09:32:28,738 [main] INFO [info.jtrac.hibernate.SchemaHelper]
- begin database schema creation =========================
create table attachments (id bigint generated by default as identity
(start with 1), previous_id bigint, file_name varchar(255), file_prefix
bigint, item_id bigint, primary key (id))
create table config (param varchar(255) not null, value varchar(255),
primary key (param))
create table history (id bigint generated by default as identity (start
with 1), version integer not null, type integer, item_id bigint not
null, actual_effort double, attachment_id bigint, comment longvarchar,
time_stamp timestamp, logged_by bigint not null, assigned_to bigint,
summary varchar(255), detail longvarchar, status integer, severity
integer, priority integer, cus_dbl_01 double, cus_dbl_02 double,
cus_dbl_03 double, cus_int_01 integer, cus_int_02 integer, cus_int_03
integer, cus_int_04 integer, cus_int_05 integer, cus_int_06 integer,
cus_int_07 integer, cus_int_08 integer, cus_int_09 integer, cus_int_10
integer, cus_str_01 varchar(255), cus_str_02 varchar(255), cus_str_03
varchar(255), cus_str_04 varchar(255), cus_str_05 varchar(255),
cus_tim_01 timestamp, cus_tim_02 timestamp, cus_tim_03 timestamp,
primary key (id))
create table item_items (id bigint generated by default as identity
(start with 1), item_id bigint not null, related_item_id bigint not
null, type integer, primary key (id))
create table item_tags (id bigint generated by default as identity
(start with 1), tag_id bigint not null, type integer, item_id bigint,
primary key (id))
create table item_users (id bigint generated by default as identity
(start with 1), user_id bigint not null, type integer, item_id bigint,
primary key (id))
create table items (id bigint generated by default as identity (start
with 1), version integer not null, type integer, parent_id bigint,
space_id bigint not null, sequence_num bigint, time_stamp timestamp,
planned_effort double, logged_by bigint not null, assigned_to bigint,
summary varchar(255), detail longvarchar, status integer, severity
integer, priority integer, cus_dbl_01 double, cus_dbl_02 double,
cus_dbl_03 double, cus_int_01 integer, cus_int_02 integer, cus_int_03
integer, cus_int_04 integer, cus_int_05 integer, cus_int_06 integer,
cus_int_07 integer, cus_int_08 integer, cus_int_09 integer, cus_int_10
integer, cus_str_01 varchar(255), cus_str_02 varchar(255), cus_str_03
varchar(255), cus_str_04 varchar(255), cus_str_05 varchar(255),
cus_tim_01 timestamp, cus_tim_02 timestamp, cus_tim_03 timestamp,
primary key (id))
create table metadata (id bigint generated by default as identity (start
with 1), version integer not null, type integer, name varchar(50),
description longvarchar, parent_id bigint, xml_string longvarchar,
primary key (id))
create table space_sequence (id bigint not null, next_seq_num bigint,
primary key (id))
create table spaces (id bigint generated by default as identity (start
with 1), version integer not null, type integer, prefix_code
varchar(10), name varchar(50), description longvarchar, guest_allowed
bit, metadata_id bigint, primary key (id), unique (prefix_code))
create table tags (id bigint generated by default as identity (start
with 1), type integer, name varchar(255) not null, description
longvarchar, primary key (id), unique (name))
create table user_space_roles (id bigint generated by default as
identity (start with 1), user_id bigint, space_id bigint, role_key
varchar(255) not null, primary key (id))
create table users (id bigint generated by default as identity (start
with 1), type integer, parent bigint, login_name varchar(50) not null,
name varchar(50), password varchar(255), email varchar(50), locale
varchar(20), locked bit, metadata_id bigint, primary key (id), unique
(login_name))
alter table attachments add constraint FKD3F3CBB0B57E4540 foreign key
(item_id) references items
alter table attachments add constraint FKD3F3CBB0761CC46C foreign key
(previous_id) references attachments
alter table history add constraint FK373FE4949F34E6BD foreign key
(assigned_to) references users
alter table history add constraint FK373FE494CD057065 foreign key
(logged_by) references users
alter table history add constraint FK373FE494B57E4540 foreign key
(item_id) references items
alter table history add constraint FK373FE494584066C0 foreign key
(attachment_id) references attachments
alter table item_items add constraint FK8B19EB94B57E4540 foreign key
(item_id) references items
alter table item_items add constraint FK8B19EB94AF302D2C foreign key
(related_item_id) references items
alter table item_tags add constraint FK806065C5B57E4540 foreign key
(item_id) references items
alter table item_tags add constraint FK806065C5AC3A5E54 foreign key
(tag_id) references tags
alter table item_users add constraint FK8BC291DCB57E4540 foreign key
(item_id) references items
alter table item_users add constraint FK8BC291DC2E9BEA40 foreign key
(user_id) references users
alter table items add constraint FK5FDE7C09F34E6BD foreign key
(assigned_to) references users
alter table items add constraint FK5FDE7C0CD057065 foreign key
(logged_by) references users
alter table items add constraint FK5FDE7C02EAA8854 foreign key
(space_id) references spaces
alter table items add constraint FK5FDE7C0B2C23C49 foreign key
(parent_id) references items
alter table metadata add constraint FKE52D7B2FD9D39965 foreign key
(parent_id) references metadata
alter table space_sequence add constraint FK5847EDAB4A0FA7B foreign key
(id) references spaces
alter table spaces add constraint FKCA95302D6205CC0 foreign key
(metadata_id) references metadata
alter table user_space_roles add constraint FK474D77D02EAA8854 foreign
key (space_id) references spaces
alter table user_space_roles add constraint FK474D77D02E9BEA40 foreign
key (user_id) references users
alter table users add constraint FK6A68E086205CC0 foreign key
(metadata_id) references metadata
alter table users add constraint FK6A68E08FC0C04DB foreign key (parent)
references users
2008-05-21 09:32:28,857 [main] INFO [info.jtrac.hibernate.SchemaHelper]
- end database schema creation ===========================
2008-05-21 09:32:28,857 [main] INFO
[info.jtrac.hibernate.HibernateJtracDao] - inserting default admin user
into database
2008-05-21 09:32:28,933 [main] INFO
[info.jtrac.hibernate.HibernateJtracDao] - schema creation complete
2008-05-21 09:32:29,039 [main] INFO [info.jtrac.JtracImpl] - available
locales configured {en=en - inglese, de=de - tedesco, el=el - greco,
es=es - spagnolo, es_AR=es_AR - spagnolo (Argentina), es_MX=es_MX -
spagnolo (Messico), fr=fr - francese, it=it - italiano, ja=ja -
giapponese, nl=nl - neerlandese, pl=pl - polacco, pt_BR=pt_BR -
portoghese (Brasile), ru=ru - russo, zh_CN=zh_CN - cinese (Cina),
zh_TW=zh_TW - cinese (Taiwan)}
2008-05-21 09:32:29,061 [main] WARN [info.jtrac.mail.MailSender] -
'mail.server.host' config is null, mail sender not initialized
2008-05-21 09:32:29,061 [main] WARN [info.jtrac.JtracImpl] - invalid
default locale configured = 'null', using en
2008-05-21 09:32:29,061 [main] INFO [info.jtrac.JtracImpl] - default
locale set to 'en'
2008-05-21 09:32:29,063 [main] WARN [info.jtrac.JtracImpl] - invalid
attachment max size 'null', using 5
2008-05-21 09:32:29,063 [main] INFO [info.jtrac.JtracImpl] - attachment
max size set to 5 MB
2008-05-21 09:32:29,063 [main] WARN [info.jtrac.JtracImpl] - invalid
session timeout 'null', using 30
2008-05-21 09:32:29,063 [main] INFO [info.jtrac.JtracImpl] - session
timeout set to 30 minutes
2008-05-21 09:32:29,686 [main] INFO [info.jtrac.wicket.JtracApplication]
- casProxyTicketValidator not found in application context, CAS
single-sign-on is not being used
21-mag-2008 9.32.30 org.apache.catalina.core.ApplicationContext log
INFO: org.apache.webapp.balancer.BalancerFilter: init(): ruleChain:
[org.apache.webapp.balancer.RuleChain:
[org.apache.webapp.balancer.rules.URLStringMatchRule: Target string:
News / Redirect URL: http://www.cnn.com],
[org.apache.webapp.balancer.rules.RequestParameterRule: Target param
name: paramName / Target param value: paramValue / Redirect URL:
http://www.yahoo.com],
[org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL:
http://jakarta.apache.org]]
21-mag-2008 9.32.30 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
21-mag-2008 9.32.30 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
21-mag-2008 9.32.30 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
21-mag-2008 9.32.30 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
21-mag-2008 9.32.30 org.apache.catalina.loader.WebappClassLoader
validateJarFile
INFO:
validateJarFile(/usr/java/apache-tomcat-5.5.23/webapps/standard-statistiche-web/WEB-INF/lib/servlet-api.jar)
- jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class:
javax/servlet/Servlet.class
- Unable to find config file. Creating new servlet engine config
file: /WEB-INF/server-config.wsdd
- Unable to find required classes (javax.activation.DataHandler and
javax.mail.internet.MimeMultipart). Attachment support is disabled.
21-mag-2008 9.32.31 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
21-mag-2008 9.32.31 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
21-mag-2008 9.32.31 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/18 config=null
21-mag-2008 9.32.31 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
21-mag-2008 9.32.31 org.apache.catalina.startup.Catalina start
INFO: Server startup in 13166 ms
2008-05-21 09:33:28,735 [http-8080-Processor24] INFO
[info.jtrac.config.ProviderManagerFactoryBean] - not using ldap
authentication
2008-05-21 09:33:51,334 [http-8080-Processor24] ERROR
[org.apache.wicket.RequestCycle] - Method onFormSubmitted of interface
org.apache.wicket.markup.html.form.IFormSubmitListener targeted at
component [MarkupContainer [Component id = form, page =
info.jtrac.wicket.SpaceFieldListPage, path = 8:form.SpaceFieldListPage
$SpaceFieldsForm, isVisible = true, isVersioned = true]] threw an
exception
org.apache.wicket.WicketRuntimeException: Method onFormSubmitted of
interface org.apache.wicket.markup.html.form.IFormSubmitListener
targeted at component [MarkupContainer [Component id = form, page =
info.jtrac.wicket.SpaceFieldListPage, path = 8:form.SpaceFieldListPage
$SpaceFieldsForm, isVisible = true, isVersioned = true]] threw an
exception
at
org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:194)
at
org.apache.wicket.request.target.component.listener.ListenerInterfaceRequestTarget.processEvents(ListenerInterfaceRequestTarget.java:73)
at
org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:90)
at
org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1166)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1241)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:493)
at
org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:354)
at
org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:194)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:183)
... 26 more
Caused by: java.lang.NoClassDefFoundError: org/jaxen/JaxenException
at org.dom4j.xpath.DefaultXPath.parse(DefaultXPath.java:358)
at org.dom4j.xpath.DefaultXPath.<init>(DefaultXPath.java:59)
at
org.dom4j.DocumentFactory.createXPath(DocumentFactory.java:230)
at
org.dom4j.tree.AbstractNode.createXPath(AbstractNode.java:207)
at
org.dom4j.tree.AbstractNode.selectNodes(AbstractNode.java:164)
at
info.jtrac.domain.WorkflowRenderer.stateExists(WorkflowRenderer.java:83)
at
info.jtrac.domain.WorkflowRenderer.addTransitions(WorkflowRenderer.java:93)
at
info.jtrac.domain.WorkflowRenderer.init(WorkflowRenderer.java:78)
at
info.jtrac.domain.WorkflowRenderer.<init>(WorkflowRenderer.java:46)
at info.jtrac.wicket.SpacePermissionsPage
$SpacePermissionsForm.<init>(SpacePermissionsPage.java:239)
at
info.jtrac.wicket.SpacePermissionsPage.<init>(SpacePermissionsPage.java:48)
at info.jtrac.wicket.SpaceFieldListPage$SpaceFieldsForm
$5.onSubmit(SpaceFieldListPage.java:192)
at
org.apache.wicket.markup.html.form.Form.delegateSubmit(Form.java:1322)
at
org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:776)
... 31 more
[ERROR] The service cannot be found for the endpoint reference (EPR)
http://192.168.0.64:8080/axis2/services/DynPkgOTAService
org.apache.axis2.AxisFault: The service cannot be found for the endpoint
reference (EPR) http://192.168.0.64:8080/axis2/services/DynPkgOTAService
at
org.apache.axis2.engine.DispatchPhase.checkPostConditions(DispatchPhase.java:64)
at org.apache.axis2.engine.Phase.invoke(Phase.java:333)
at
org.apache.axis2.engine.AxisEngine.invoke(AxisEngine.java:264)
at
org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:163)
at
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
at
org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:619)
[ERROR] The service cannot be found for the endpoint reference (EPR)
http://192.168.0.64:8080/axis2/services/DynPkgOTAService
org.apache.axis2.AxisFault: The service cannot be found for the endpoint
reference (EPR) http://192.168.0.64:8080/axis2/services/DynPkgOTAService
at
org.apache.axis2.engine.DispatchPhase.checkPostConditions(DispatchPhase.java:64)
at org.apache.axis2.engine.Phase.invoke(Phase.java:333)
at
org.apache.axis2.engine.AxisEngine.invoke(AxisEngine.java:264)
at
org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:163)
at
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
at
org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:619)
[ERROR] The service cannot be found for the endpoint reference (EPR)
http://192.168.0.64:8080/axis2/services/DynPkgOTAService
org.apache.axis2.AxisFault: The service cannot be found for the endpoint
reference (EPR) http://192.168.0.64:8080/axis2/services/DynPkgOTAService
at
org.apache.axis2.engine.DispatchPhase.checkPostConditions(DispatchPhase.java:64)
at org.apache.axis2.engine.Phase.invoke(Phase.java:333)
at
org.apache.axis2.engine.AxisEngine.invoke(AxisEngine.java:264)
at
org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:163)
at
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
at
org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:619)
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
j-trac-users mailing list
j-t...@li...
https://lists.sourceforge.net/lists/listinfo/j-trac-users
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments.
|
|
From: Bartolomeo N. <bni...@si...> - 2008-05-21 08:08:22
|
Hi,
I'm trying to use jtrac on tomcat 5.5.23, jdk6.0 and ubuntu 7.04. I've
downloaded jtrac2.1.0.zip and exctracted jtrac.war to tomcat/webapps.
Then I've restarted tomcat and logged in as admin/admin. I can create
new users, but when I try to create a new Space I got 'Internal Error'.
The log from catalina.out follows.
Your help is much appreciated. Best Regards.
INFO: Deploying web application archive jtrac.war
log4j:WARN No appenders could be found for logger
(org.apache.commons.digester.Digester.sax).
log4j:WARN Please initialize the log4j system properly.
2008-05-21 09:32:25,598 [main] INFO [info.jtrac.config.JtracConfigurer]
- found 'jtrac-init.properties' on classpath, processing...
2008-05-21 09:32:25,600 [main] INFO [info.jtrac.config.JtracConfigurer]
- locales available configured are
'en,de,el,es,es_AR,es_MX,fr,it,ja,nl,pl,pt_BR,ru,zh_CN,zh_TW'
2008-05-21 09:32:25,601 [main] INFO [info.jtrac.config.JtracConfigurer]
- valid 'jtrac.home' property not available in 'jtrac-init.properties',
trying system properties.
2008-05-21 09:32:25,601 [main] INFO [info.jtrac.config.JtracConfigurer]
- valid 'jtrac.home' property not available in system properties, trying
servlet init paramters.
2008-05-21 09:32:25,601 [main] WARN [info.jtrac.config.JtracConfigurer]
- Servlet init paramter 'jtrac.home' does not exist. Will use
'user.home' directory '/home/user/.jtrac'
2008-05-21 09:32:25,601 [main] INFO [info.jtrac.config.JtracConfigurer]
- directory does not exist, created '/home/user/.jtrac'
2008-05-21 09:32:25,601 [main] INFO [info.jtrac.config.JtracConfigurer]
- directory does not exist, created '/home/user/.jtrac/attachments'
2008-05-21 09:32:25,602 [main] INFO [info.jtrac.config.JtracConfigurer]
- directory does not exist, created '/home/user/.jtrac/indexes'
2008-05-21 09:32:25,602 [main] INFO [info.jtrac.config.JtracConfigurer]
- properties file does not exist, created
'/home/user/.jtrac/jtrac.properties'
2008-05-21 09:32:25,602 [main] INFO [info.jtrac.config.JtracConfigurer]
- HSQLDB will be used. Finished creating
'/home/user/.jtrac/jtrac.properties'
2008-05-21 09:32:25,603 [main] INFO [info.jtrac.config.JtracConfigurer]
- found 'jtrac-version.properties' on classpath, processing...
2008-05-21 09:32:25,603 [main] INFO [info.jtrac.config.JtracConfigurer]
- jtrac.version = '2.1.0'
2008-05-21 09:32:25,603 [main] INFO [info.jtrac.config.JtracConfigurer]
- jtrac.timestamp = '200803022120'
2008-05-21 09:32:25,604 [main] INFO [info.jtrac.config.JtracConfigurer]
- Loading properties file from file [/home/user/.jtrac/jtrac.properties]
2008-05-21 09:32:25,775 [main] INFO
[info.jtrac.config.DataSourceFactoryBean] - embedded HSQLDB mode
detected, switching on spring single connection data source
2008-05-21 09:32:28,679 [main] WARN
[org.hibernate.util.JDBCExceptionReporter] - SQL Error: -22, SQLState:
S0002
2008-05-21 09:32:28,679 [main] ERROR
[org.hibernate.util.JDBCExceptionReporter] - Tabella non trovata in
statement [select item0_.id as id0_, item0_.version as version0_,
item0_.type as type0_, item0_.parent_id as parent4_0_, item0_.space_id
as space5_0_, item0_.sequence_num as sequence6_0_, item0_.time_stamp as
time7_0_, item0_.planned_effort as planned8_0_, item0_.logged_by as
logged9_0_, item0_.assigned_to as assigned10_0_, item0_.summary as
summary0_, item0_.detail as detail0_, item0_.status as status0_,
item0_.severity as severity0_, item0_.priority as priority0_,
item0_.cus_dbl_01 as cus16_0_, item0_.cus_dbl_02 as cus17_0_,
item0_.cus_dbl_03 as cus18_0_, item0_.cus_int_01 as cus19_0_,
item0_.cus_int_02 as cus20_0_, item0_.cus_int_03 as cus21_0_,
item0_.cus_int_04 as cus22_0_, item0_.cus_int_05 as cus23_0_,
item0_.cus_int_06 as cus24_0_, item0_.cus_int_07 as cus25_0_,
item0_.cus_int_08 as cus26_0_, item0_.cus_int_09 as cus27_0_,
item0_.cus_int_10 as cus28_0_, item0_.cus_str_01 as cus29_0_,
item0_.cus_str_02 as cus30_0_, item0_.cus_str_03 as cus31_0_,
item0_.cus_str_04 as cus32_0_, item0_.cus_str_05 as cus33_0_,
item0_.cus_tim_01 as cus34_0_, item0_.cus_tim_02 as cus35_0_,
item0_.cus_tim_03 as cus36_0_ from items item0_ where item0_.id=1]
2008-05-21 09:32:28,684 [main] WARN
[info.jtrac.hibernate.HibernateJtracDao] - expected database schema does
not exist, will create. Error is: could not execute query; nested
exception is org.hibernate.exception.SQLGrammarException: could not
execute query
2008-05-21 09:32:28,738 [main] INFO [info.jtrac.hibernate.SchemaHelper]
- begin database schema creation =========================
create table attachments (id bigint generated by default as identity
(start with 1), previous_id bigint, file_name varchar(255), file_prefix
bigint, item_id bigint, primary key (id))
create table config (param varchar(255) not null, value varchar(255),
primary key (param))
create table history (id bigint generated by default as identity (start
with 1), version integer not null, type integer, item_id bigint not
null, actual_effort double, attachment_id bigint, comment longvarchar,
time_stamp timestamp, logged_by bigint not null, assigned_to bigint,
summary varchar(255), detail longvarchar, status integer, severity
integer, priority integer, cus_dbl_01 double, cus_dbl_02 double,
cus_dbl_03 double, cus_int_01 integer, cus_int_02 integer, cus_int_03
integer, cus_int_04 integer, cus_int_05 integer, cus_int_06 integer,
cus_int_07 integer, cus_int_08 integer, cus_int_09 integer, cus_int_10
integer, cus_str_01 varchar(255), cus_str_02 varchar(255), cus_str_03
varchar(255), cus_str_04 varchar(255), cus_str_05 varchar(255),
cus_tim_01 timestamp, cus_tim_02 timestamp, cus_tim_03 timestamp,
primary key (id))
create table item_items (id bigint generated by default as identity
(start with 1), item_id bigint not null, related_item_id bigint not
null, type integer, primary key (id))
create table item_tags (id bigint generated by default as identity
(start with 1), tag_id bigint not null, type integer, item_id bigint,
primary key (id))
create table item_users (id bigint generated by default as identity
(start with 1), user_id bigint not null, type integer, item_id bigint,
primary key (id))
create table items (id bigint generated by default as identity (start
with 1), version integer not null, type integer, parent_id bigint,
space_id bigint not null, sequence_num bigint, time_stamp timestamp,
planned_effort double, logged_by bigint not null, assigned_to bigint,
summary varchar(255), detail longvarchar, status integer, severity
integer, priority integer, cus_dbl_01 double, cus_dbl_02 double,
cus_dbl_03 double, cus_int_01 integer, cus_int_02 integer, cus_int_03
integer, cus_int_04 integer, cus_int_05 integer, cus_int_06 integer,
cus_int_07 integer, cus_int_08 integer, cus_int_09 integer, cus_int_10
integer, cus_str_01 varchar(255), cus_str_02 varchar(255), cus_str_03
varchar(255), cus_str_04 varchar(255), cus_str_05 varchar(255),
cus_tim_01 timestamp, cus_tim_02 timestamp, cus_tim_03 timestamp,
primary key (id))
create table metadata (id bigint generated by default as identity (start
with 1), version integer not null, type integer, name varchar(50),
description longvarchar, parent_id bigint, xml_string longvarchar,
primary key (id))
create table space_sequence (id bigint not null, next_seq_num bigint,
primary key (id))
create table spaces (id bigint generated by default as identity (start
with 1), version integer not null, type integer, prefix_code
varchar(10), name varchar(50), description longvarchar, guest_allowed
bit, metadata_id bigint, primary key (id), unique (prefix_code))
create table tags (id bigint generated by default as identity (start
with 1), type integer, name varchar(255) not null, description
longvarchar, primary key (id), unique (name))
create table user_space_roles (id bigint generated by default as
identity (start with 1), user_id bigint, space_id bigint, role_key
varchar(255) not null, primary key (id))
create table users (id bigint generated by default as identity (start
with 1), type integer, parent bigint, login_name varchar(50) not null,
name varchar(50), password varchar(255), email varchar(50), locale
varchar(20), locked bit, metadata_id bigint, primary key (id), unique
(login_name))
alter table attachments add constraint FKD3F3CBB0B57E4540 foreign key
(item_id) references items
alter table attachments add constraint FKD3F3CBB0761CC46C foreign key
(previous_id) references attachments
alter table history add constraint FK373FE4949F34E6BD foreign key
(assigned_to) references users
alter table history add constraint FK373FE494CD057065 foreign key
(logged_by) references users
alter table history add constraint FK373FE494B57E4540 foreign key
(item_id) references items
alter table history add constraint FK373FE494584066C0 foreign key
(attachment_id) references attachments
alter table item_items add constraint FK8B19EB94B57E4540 foreign key
(item_id) references items
alter table item_items add constraint FK8B19EB94AF302D2C foreign key
(related_item_id) references items
alter table item_tags add constraint FK806065C5B57E4540 foreign key
(item_id) references items
alter table item_tags add constraint FK806065C5AC3A5E54 foreign key
(tag_id) references tags
alter table item_users add constraint FK8BC291DCB57E4540 foreign key
(item_id) references items
alter table item_users add constraint FK8BC291DC2E9BEA40 foreign key
(user_id) references users
alter table items add constraint FK5FDE7C09F34E6BD foreign key
(assigned_to) references users
alter table items add constraint FK5FDE7C0CD057065 foreign key
(logged_by) references users
alter table items add constraint FK5FDE7C02EAA8854 foreign key
(space_id) references spaces
alter table items add constraint FK5FDE7C0B2C23C49 foreign key
(parent_id) references items
alter table metadata add constraint FKE52D7B2FD9D39965 foreign key
(parent_id) references metadata
alter table space_sequence add constraint FK5847EDAB4A0FA7B foreign key
(id) references spaces
alter table spaces add constraint FKCA95302D6205CC0 foreign key
(metadata_id) references metadata
alter table user_space_roles add constraint FK474D77D02EAA8854 foreign
key (space_id) references spaces
alter table user_space_roles add constraint FK474D77D02E9BEA40 foreign
key (user_id) references users
alter table users add constraint FK6A68E086205CC0 foreign key
(metadata_id) references metadata
alter table users add constraint FK6A68E08FC0C04DB foreign key (parent)
references users
2008-05-21 09:32:28,857 [main] INFO [info.jtrac.hibernate.SchemaHelper]
- end database schema creation ===========================
2008-05-21 09:32:28,857 [main] INFO
[info.jtrac.hibernate.HibernateJtracDao] - inserting default admin user
into database
2008-05-21 09:32:28,933 [main] INFO
[info.jtrac.hibernate.HibernateJtracDao] - schema creation complete
2008-05-21 09:32:29,039 [main] INFO [info.jtrac.JtracImpl] - available
locales configured {en=en - inglese, de=de - tedesco, el=el - greco,
es=es - spagnolo, es_AR=es_AR - spagnolo (Argentina), es_MX=es_MX -
spagnolo (Messico), fr=fr - francese, it=it - italiano, ja=ja -
giapponese, nl=nl - neerlandese, pl=pl - polacco, pt_BR=pt_BR -
portoghese (Brasile), ru=ru - russo, zh_CN=zh_CN - cinese (Cina),
zh_TW=zh_TW - cinese (Taiwan)}
2008-05-21 09:32:29,061 [main] WARN [info.jtrac.mail.MailSender] -
'mail.server.host' config is null, mail sender not initialized
2008-05-21 09:32:29,061 [main] WARN [info.jtrac.JtracImpl] - invalid
default locale configured = 'null', using en
2008-05-21 09:32:29,061 [main] INFO [info.jtrac.JtracImpl] - default
locale set to 'en'
2008-05-21 09:32:29,063 [main] WARN [info.jtrac.JtracImpl] - invalid
attachment max size 'null', using 5
2008-05-21 09:32:29,063 [main] INFO [info.jtrac.JtracImpl] - attachment
max size set to 5 MB
2008-05-21 09:32:29,063 [main] WARN [info.jtrac.JtracImpl] - invalid
session timeout 'null', using 30
2008-05-21 09:32:29,063 [main] INFO [info.jtrac.JtracImpl] - session
timeout set to 30 minutes
2008-05-21 09:32:29,686 [main] INFO [info.jtrac.wicket.JtracApplication]
- casProxyTicketValidator not found in application context, CAS
single-sign-on is not being used
21-mag-2008 9.32.30 org.apache.catalina.core.ApplicationContext log
INFO: org.apache.webapp.balancer.BalancerFilter: init(): ruleChain:
[org.apache.webapp.balancer.RuleChain:
[org.apache.webapp.balancer.rules.URLStringMatchRule: Target string:
News / Redirect URL: http://www.cnn.com],
[org.apache.webapp.balancer.rules.RequestParameterRule: Target param
name: paramName / Target param value: paramValue / Redirect URL:
http://www.yahoo.com],
[org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL:
http://jakarta.apache.org]]
21-mag-2008 9.32.30 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
21-mag-2008 9.32.30 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
21-mag-2008 9.32.30 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
21-mag-2008 9.32.30 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
21-mag-2008 9.32.30 org.apache.catalina.loader.WebappClassLoader
validateJarFile
INFO:
validateJarFile(/usr/java/apache-tomcat-5.5.23/webapps/standard-statistiche-web/WEB-INF/lib/servlet-api.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
- Unable to find config file. Creating new servlet engine config
file: /WEB-INF/server-config.wsdd
- Unable to find required classes (javax.activation.DataHandler and
javax.mail.internet.MimeMultipart). Attachment support is disabled.
21-mag-2008 9.32.31 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
21-mag-2008 9.32.31 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
21-mag-2008 9.32.31 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/18 config=null
21-mag-2008 9.32.31 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
21-mag-2008 9.32.31 org.apache.catalina.startup.Catalina start
INFO: Server startup in 13166 ms
2008-05-21 09:33:28,735 [http-8080-Processor24] INFO
[info.jtrac.config.ProviderManagerFactoryBean] - not using ldap
authentication
2008-05-21 09:33:51,334 [http-8080-Processor24] ERROR
[org.apache.wicket.RequestCycle] - Method onFormSubmitted of interface
org.apache.wicket.markup.html.form.IFormSubmitListener targeted at
component [MarkupContainer [Component id = form, page =
info.jtrac.wicket.SpaceFieldListPage, path = 8:form.SpaceFieldListPage
$SpaceFieldsForm, isVisible = true, isVersioned = true]] threw an
exception
org.apache.wicket.WicketRuntimeException: Method onFormSubmitted of
interface org.apache.wicket.markup.html.form.IFormSubmitListener
targeted at component [MarkupContainer [Component id = form, page =
info.jtrac.wicket.SpaceFieldListPage, path = 8:form.SpaceFieldListPage
$SpaceFieldsForm, isVisible = true, isVersioned = true]] threw an
exception
at
org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:194)
at
org.apache.wicket.request.target.component.listener.ListenerInterfaceRequestTarget.processEvents(ListenerInterfaceRequestTarget.java:73)
at
org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:90)
at
org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1166)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1241)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:493)
at
org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:354)
at
org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:194)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:183)
... 26 more
Caused by: java.lang.NoClassDefFoundError: org/jaxen/JaxenException
at org.dom4j.xpath.DefaultXPath.parse(DefaultXPath.java:358)
at org.dom4j.xpath.DefaultXPath.<init>(DefaultXPath.java:59)
at org.dom4j.DocumentFactory.createXPath(DocumentFactory.java:230)
at org.dom4j.tree.AbstractNode.createXPath(AbstractNode.java:207)
at org.dom4j.tree.AbstractNode.selectNodes(AbstractNode.java:164)
at
info.jtrac.domain.WorkflowRenderer.stateExists(WorkflowRenderer.java:83)
at
info.jtrac.domain.WorkflowRenderer.addTransitions(WorkflowRenderer.java:93)
at info.jtrac.domain.WorkflowRenderer.init(WorkflowRenderer.java:78)
at info.jtrac.domain.WorkflowRenderer.<init>(WorkflowRenderer.java:46)
at info.jtrac.wicket.SpacePermissionsPage
$SpacePermissionsForm.<init>(SpacePermissionsPage.java:239)
at
info.jtrac.wicket.SpacePermissionsPage.<init>(SpacePermissionsPage.java:48)
at info.jtrac.wicket.SpaceFieldListPage$SpaceFieldsForm
$5.onSubmit(SpaceFieldListPage.java:192)
at
org.apache.wicket.markup.html.form.Form.delegateSubmit(Form.java:1322)
at
org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:776)
... 31 more
[ERROR] The service cannot be found for the endpoint reference (EPR)
http://192.168.0.64:8080/axis2/services/DynPkgOTAService
org.apache.axis2.AxisFault: The service cannot be found for the endpoint
reference (EPR) http://192.168.0.64:8080/axis2/services/DynPkgOTAService
at
org.apache.axis2.engine.DispatchPhase.checkPostConditions(DispatchPhase.java:64)
at org.apache.axis2.engine.Phase.invoke(Phase.java:333)
at org.apache.axis2.engine.AxisEngine.invoke(AxisEngine.java:264)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:163)
at
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
at
org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:619)
[ERROR] The service cannot be found for the endpoint reference (EPR)
http://192.168.0.64:8080/axis2/services/DynPkgOTAService
org.apache.axis2.AxisFault: The service cannot be found for the endpoint
reference (EPR) http://192.168.0.64:8080/axis2/services/DynPkgOTAService
at
org.apache.axis2.engine.DispatchPhase.checkPostConditions(DispatchPhase.java:64)
at org.apache.axis2.engine.Phase.invoke(Phase.java:333)
at org.apache.axis2.engine.AxisEngine.invoke(AxisEngine.java:264)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:163)
at
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
at
org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:619)
[ERROR] The service cannot be found for the endpoint reference (EPR)
http://192.168.0.64:8080/axis2/services/DynPkgOTAService
org.apache.axis2.AxisFault: The service cannot be found for the endpoint
reference (EPR) http://192.168.0.64:8080/axis2/services/DynPkgOTAService
at
org.apache.axis2.engine.DispatchPhase.checkPostConditions(DispatchPhase.java:64)
at org.apache.axis2.engine.Phase.invoke(Phase.java:333)
at org.apache.axis2.engine.AxisEngine.invoke(AxisEngine.java:264)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:163)
at
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
at
org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:619)
|
|
From: Tauren M. <ta...@gr...> - 2008-04-07 06:59:06
|
Saurabh, Thanks for the feedback. Now that I think about it, you are right. In most cases, everyone shouldn't get notified of every change for every issue. In my case, I have a situation where that is needed, but I suppose it is not a typical use case. It would be nice to have more notification options. I agree that allowing users to subscribe to issues would be great, so they get to choose what issues they are notified on, rather than whoever is making a change. But, a global per space setting for "notify all users of changes" would be really useful as well. Tauren On Sun, Apr 6, 2008 at 10:57 PM, Saurabh Banerjee <sau...@ac...> wrote: > Tauren, > > Yes, you indeed have to check the notify check box for each user you wish to > notify! > > If have setup a group notification list and created a dummy user with the > group email id. When I need to notify my group, I click the check box for > this dummy user. It works fine for us. > > > I personally hate to spam every user for every change in JTrac. I think we > need a feature to allow users to watch certain jTrac items without getting > spammed. Here is what I think is needed: > > 1. Users can add/remove a watch to any item. > 2. Users can watch multiple items at a time. > 3. Users should get notified only if their watched item is updated. > > Hope this helps! > > Saurabh > > > > > -----Original Message----- > From: j-t...@li... > [mailto:j-t...@li...] On Behalf Of Tauren > Mills > Sent: Monday, April 07, 2008 10:24 AM > To: JTrac users mailing-list > Subject: [jtrac-users] Email notifications > > I'm unclear on how the email notifications work. Sometimes I get > notifications and sometimes I don't. I've watched the mail logs and > it seems like it is only sending out email to the person who an issue > is assigned to when I comment on an issue. So when I am assigned the > issue, I get the email, but nobody else does. Is that the expected > behavior? > > For all the users of a space to get notifications of all changes to > all issues, do all of the Notify by Email names need to be checked? > Is there some way to default all of the names to be checked so I don't > have to manually do it for every new issue? It seems cumbersome to > use for larger numbers of users. It would be better to email all > users by default, and allow a way to turn off users instead. > > Or is this not the way it works? If not, could someone please explain it? > > Thanks! > Tauren > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Register now and save $200. Hurry, offer ends at 11:59 p.m., > Monday, April 7! Use priority code J8TLD2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao > ne > _______________________________________________ > j-trac-users mailing list > j-t...@li... > https://lists.sourceforge.net/lists/listinfo/j-trac-users > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Register now and save $200. Hurry, offer ends at 11:59 p.m., > Monday, April 7! Use priority code J8TLD2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > _______________________________________________ > j-trac-users mailing list > j-t...@li... > https://lists.sourceforge.net/lists/listinfo/j-trac-users > |
|
From: Saurabh B. <sau...@ac...> - 2008-04-07 05:57:50
|
Tauren, Yes, you indeed have to check the notify check box for each user you wish to notify! If have setup a group notification list and created a dummy user with the group email id. When I need to notify my group, I click the check box for this dummy user. It works fine for us. I personally hate to spam every user for every change in JTrac. I think we need a feature to allow users to watch certain jTrac items without getting spammed. Here is what I think is needed: 1. Users can add/remove a watch to any item. 2. Users can watch multiple items at a time. 3. Users should get notified only if their watched item is updated. Hope this helps! Saurabh -----Original Message----- From: j-t...@li... [mailto:j-t...@li...] On Behalf Of Tauren Mills Sent: Monday, April 07, 2008 10:24 AM To: JTrac users mailing-list Subject: [jtrac-users] Email notifications I'm unclear on how the email notifications work. Sometimes I get notifications and sometimes I don't. I've watched the mail logs and it seems like it is only sending out email to the person who an issue is assigned to when I comment on an issue. So when I am assigned the issue, I get the email, but nobody else does. Is that the expected behavior? For all the users of a space to get notifications of all changes to all issues, do all of the Notify by Email names need to be checked? Is there some way to default all of the names to be checked so I don't have to manually do it for every new issue? It seems cumbersome to use for larger numbers of users. It would be better to email all users by default, and allow a way to turn off users instead. Or is this not the way it works? If not, could someone please explain it? Thanks! Tauren ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Register now and save $200. Hurry, offer ends at 11:59 p.m., Monday, April 7! Use priority code J8TLD2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao ne _______________________________________________ j-trac-users mailing list j-t...@li... https://lists.sourceforge.net/lists/listinfo/j-trac-users |
|
From: Tauren M. <ta...@gr...> - 2008-04-07 04:54:05
|
I'm unclear on how the email notifications work. Sometimes I get notifications and sometimes I don't. I've watched the mail logs and it seems like it is only sending out email to the person who an issue is assigned to when I comment on an issue. So when I am assigned the issue, I get the email, but nobody else does. Is that the expected behavior? For all the users of a space to get notifications of all changes to all issues, do all of the Notify by Email names need to be checked? Is there some way to default all of the names to be checked so I don't have to manually do it for every new issue? It seems cumbersome to use for larger numbers of users. It would be better to email all users by default, and allow a way to turn off users instead. Or is this not the way it works? If not, could someone please explain it? Thanks! Tauren |
|
From: Stephen E. <se...@ga...> - 2008-04-04 01:36:18
|
Why I needed to mysql was for JDBC access for some reporting tools, I guess I could run HQDB in server mode, but I'm familiar and happy with mysql. Stephen... -----Original Message----- From: j-t...@li... [mailto:j-t...@li...] On Behalf Of TimP Sent: Friday, 4 April 2008 4:17 AM To: JTrac users mailing-list Subject: Re: [jtrac-users] Mysql migration problems On Wednesday 02 April 2008 07:59, Stephen Eaton wrote: > I'm trying to migrate my existing JTRAC installation, the current > stable release of jtrac using HQDB on a win2003 server, to mysql > running on a seperate linux server. Did you consider using hsqldb on Linux with save to disk set? Thats how I am running, with no problems. TimP ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ j-trac-users mailing list j-t...@li... https://lists.sourceforge.net/lists/listinfo/j-trac-users __________ NOD32 2996 (20080403) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com |
|
From: TimP <tim...@pa...> - 2008-04-03 20:19:09
|
On Wednesday 02 April 2008 07:59, Stephen Eaton wrote: > I'm trying to migrate my existing JTRAC installation, the current stable > release of jtrac using HQDB on a win2003 server, to mysql running on a > seperate linux server. Did you consider using hsqldb on Linux with save to disk set? Thats how I am running, with no problems. TimP |
|
From: Tauren M. <ta...@gr...> - 2008-04-03 07:48:54
|
That's weird. Your script does essentially the same thing, doesn't
it? You just split the test into two if/else clauses instead of using
an or operator. Hmm. Well, at least you got it going!
On Wed, Apr 2, 2008 at 11:41 PM, Stephen Eaton <se...@ga...> wrote:
> thanks for that, while it worked on the spaces, it bombed out on the users
> where you said so I modified your script and this worked for me!
>
>
> Stephen...
>
> ----------------
>
> import java.sql.*;
>
> Class.forName("org.hsqldb.jdbcDriver");
> Class.forName("com.mysql.jdbc.Driver");
>
> conn1 = DriverManager.getConnection("jdbc:hsqldb:file:jtrac", "sa", "");
> conn2 = DriverManager.getConnection("jdbc:mysql://mysql/jtrac", "jtrac",
> "jtrac");
>
>
>
> md1 = conn1.getMetaData();
> rs = md1.getTables(null, null, null, new String[] { "TABLE" });
>
> tableNames = new ArrayList();
>
> while (rs.next()) {
> tableNames.add(rs.getString("TABLE_NAME"));
> }
>
> stmt1 = conn1.createStatement();
>
> stmt2 = conn2.createStatement();
> stmt2.executeUpdate("delete from user_space_roles");
> stmt2.executeUpdate("delete from users");
>
> for (tableName : tableNames) {
> tableName = tableName.toLowerCase();
> rs = stmt1.executeQuery("select * from " + tableName);
> md = rs.getMetaData();
> cols = "";
> vals = "";
> for (int i = 1; i <= md.getColumnCount(); i++) {
> cols = cols + md.getColumnName(i);
> vals = vals + "?";
> if (i != md.getColumnCount()) {
> cols = cols + ", ";
> vals = vals + ", ";
> }
> }
> ins = "insert into " + tableName + " (" + cols + ") values (" + vals +
> ")";
> print(ins);
> stmt2 = conn2.prepareStatement(ins);
> while (rs.next()) {
> for (int i = 1; i <= md.getColumnCount(); i++) {
> if (md.getColumnType(i) == Types.TIMESTAMP) {
> stmt2.setTimestamp(i, rs.getTimestamp(i));
> } else {
>
> String name = md.getColumnName(i).toLowerCase();
> if (name.equals("locked")) {
>
> stmt2.setBoolean(i, rs.getInt(i) == 1);
> } else if (name.equals("guest_allowed")) {
>
> stmt2.setBoolean(i, rs.getInt(i) == 1);
> } else {
> stmt2.setString(i, rs.getString(i));
> }
> }
> }
>
> stmt2.execute();
> }
> }
>
> conn1.close();
> conn2.close();
>
>
>
> -----Original Message-----
> From: j-t...@li...
>
>
> [mailto:j-t...@li...] On Behalf Of Tauren
> Mills
> Sent: Thursday, 3 April 2008 1:34 PM
> To: JTrac users mailing-list
> Subject: Re: [jtrac-users] Mysql migration problems
>
> I ran into these exact same problems, but I didn't want to set my database
> to be case insensitive. So I hacked the jtrac-hsqldb-to-mysql.bsh file.
> See below for the full file.
>
> To get past the first problem (the case sensitive table names), I added this
> line:
>
> tableName = tableName.toLowerCase();
>
> The data truncation error happens for MySQL fields that are of type BIT(1),
> which is used for storing boolean values. To get past this error, which is
> a problem for both spaces.guest_allowed and users.locked, I added these
> lines:
>
> } else if (md.getColumnType(i) == Types.INTEGER) {
> String name = md.getColumnName(i).toLowerCase();
> if (name.equals("guest_allowed") || name.equals("locked")) {
> stmt2.setBoolean(i, rs.getInt(i) == 1);
> } else {
> stmt2.setString(i, rs.getString(i));
> }
>
> This is because in hsqldb, the column type is integer, but the bsh script
> was attempting to convert it to a string. And the string wouldn't fit into
> a bit(1).
>
> I hope this helps! Below is the full script.
>
> Tauren
>
>
> ----------
>
> import java.sql.*;
>
> Class.forName("org.hsqldb.jdbcDriver");
> Class.forName("com.mysql.jdbc.Driver");
>
> conn1 = DriverManager.getConnection("jdbc:hsqldb:file:jtrac", "sa", "");
> conn2 = DriverManager.getConnection("jdbc:mysql://localhost/jtrac", "root",
> "");
>
> md1 = conn1.getMetaData();
> rs = md1.getTables(null, null, null, new String[] { "TABLE" });
>
> tableNames = new ArrayList();
>
> while (rs.next()) {
> tableNames.add(rs.getString("TABLE_NAME"));
> }
>
> stmt1 = conn1.createStatement();
>
> stmt2 = conn2.createStatement();
> stmt2.executeUpdate("delete from user_space_roles");
> stmt2.executeUpdate("delete from users");
>
> for (tableName : tableNames) {
> tableName = tableName.toLowerCase();
> rs = stmt1.executeQuery("select * from " + tableName);
> md = rs.getMetaData();
> cols = "";
> vals = "";
> for (int i = 1; i <= md.getColumnCount(); i++) {
> cols = cols + md.getColumnName(i);
> vals = vals + "?";
> if (i != md.getColumnCount()) {
> cols = cols + ", ";
> vals = vals + ", ";
> }
> }
> ins = "insert into " + tableName + " (" + cols + ") values (" + vals +
> ")";
> print(ins);
> stmt2 = conn2.prepareStatement(ins);
> while (rs.next()) {
> for (int i = 1; i <= md.getColumnCount(); i++) {
> if (md.getColumnType(i) == Types.TIMESTAMP) {
> stmt2.setTimestamp(i, rs.getTimestamp(i));
> } else if (md.getColumnType(i) == Types.INTEGER) {
> String name = md.getColumnName(i).toLowerCase();
> if (name.equals("guest_allowed") || name.equals("locked")) {
> stmt2.setBoolean(i, rs.getInt(i) == 1);
> } else {
> stmt2.setString(i, rs.getString(i));
> }
> } else {
> stmt2.setString(i, rs.getString(i));
> }
> }
> stmt2.execute();
> }
> }
>
> conn1.close();
> conn2.close();
>
>
> On Wed, Apr 2, 2008 at 8:35 PM, Stephen Eaton <se...@ga...> wrote:
> >
> >
> > lol good timing on my part, that definately fixed the problem thatnks
> > foir that Peter, but has raised another during the migration process
> >
> > D:\jtrac\data\db>java -cp
> > bsh-2.0b4.jar;hsqldb-1.8.0.1.jar;mysql-connector-java-
> > 5.1.6-bin.jar bsh.Interpreter jtrac-hsqldb-to-mysql.bsh insert into
> > ATTACHMENTS (ID, PREVIOUS_ID, FILE_NAME, FILE_PREFIX, ITEM_ID) values
> > (?, ?, ?, ?, ?) insert into CONFIG (PARAM, VALUE) values (?, ?) insert
> > into HISTORY (ID, ITEM_ID, VERSION, TYPE, ACTUAL_EFFORT,
> > ATTACHMENT_ID, COMMENT, TIME_STAMP, LOGGED_BY, ASSIGNED_TO, SUMMARY,
> > DETAIL, STATUS, SEVERITY, PRIORITY, CUS_DBL_01, CUS_DBL_02,
> > CUS_DBL_03, CUS_INT_01, CUS_INT_02, CUS_INT_03, CUS_INT_04,
> > CUS_INT_05, CUS_INT_06, CUS_INT_07, CUS_INT_08, CUS_INT_09,
> > CUS_INT_10, CUS_STR_01, CUS_STR_02, CUS_STR_03, CUS_STR_04,
> > CUS_STR_05, CUS_TIM_01, CUS_TIM_02, CUS_TIM_03) values (?, ?, ?, ?, ?,
> > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> > ?, ?, ?, ?, ?, ?, ?) insert into ITEMS (ID, VERSION, TYPE, PARENT_ID,
> > SPACE_ID, SEQUENCE_NUM, TIME_STAMP, PLANNED_EFFORT, LOGGED_BY,
> > ASSIGNED_TO, SUMMARY, DETAIL, STATUS, SEVERITY,PRIORITY, CUS_DBL_01,
> > CUS_DBL_02, US_DBL_03, CUS_INT_01, CUS_INT_02, CUS_INT_03, CUS_INT_04,
> > CUS_INT_05, CUS_INT_06, CUS_INT_07, CUS_INT_08, CUS_INT_09,
> > CUS_INT_10, CUS_STR_01, CUS_STR_02, CUS_STR_03, CUS_STR_04,
> > CUS_STR_05, CUS_TIM_01, CUS_TIM_02, CUS_TIM_03) values (?, ?, ?, ?, ?,
> > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> > ?, ?, ?, ?, ?, ?, ?, ?) insert into ITEM_ITEMS (ID, ITEM_ID,
> > RELATED_ITEM_ID, TYPE) values (?, ?, ?,
> > ?)
> > insert into ITEM_TAGS (ID, TAG_ID, TYPE, ITEM_ID) values (?, ?, ?, ?)
> > insert into ITEM_USERS (ID, USER_ID, TYPE, ITEM_ID) values (?, ?, ?,
> > ?) insert into METADATA (ID, VERSION, TYPE, NAME, DESCRIPTION,
> > PARENT_ID,
> > XML_STRING) values (?, ?, ?, ?, ?, ?, ?) insert into SPACES (ID,
> > VERSION, TYPE, PREFIX_CODE, NAME, DESCRIPTION, METADATA_ID,
> > GUEST_ALLOWED) values (?, ?, ?, ?, ?, ?, ?, ?) Script threw exception:
> > Sourced file: jtrac-hsqldb-to-mysql.bsh : Method Invocation
> > stmt2.execute : at Line: 48 : in file: jtrac-hsqldb-to-mysql.bsh
> > : stmt2 .execute ( )
> >
> > Target exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation:
> > Data too long for column 'guest_allowed' at row 1
> >
> > com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for
> > column 'guest_allowed' at row 1
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3489)
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
> > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
> > at
> >
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734
> )
> > at
> > com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995)
> > at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
> > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> > at java.lang.reflect.Method.invoke(Unknown Source)
> > at bsh.Reflect.invokeMethod(Unknown Source)
> > at bsh.Reflect.invokeObjectMethod(Unknown Source)
> > at bsh.Name.invokeMethod(Unknown Source)
> > at bsh.BSHMethodInvocation.eval(Unknown Source)
> > at bsh.BSHPrimaryExpression.eval(Unknown Source)
> > at bsh.BSHPrimaryExpression.eval(Unknown Source)
> > at bsh.BSHBlock.evalBlock(Unknown Source)
> > at bsh.BSHBlock.eval(Unknown Source)
> > at bsh.BSHBlock.eval(Unknown Source)
> > at bsh.BSHWhileStatement.eval(Unknown Source)
> > at bsh.BSHBlock.evalBlock(Unknown Source)
> > at bsh.BSHBlock.eval(Unknown Source)
> > at bsh.BSHBlock.eval(Unknown Source)
> > at bsh.BSHEnhancedForStatement.eval(Unknown Source)
> > at bsh.Interpreter.eval(Unknown Source)
> > at bsh.Interpreter.source(Unknown Source)
> > at bsh.Interpreter.main(Unknown Source)
> >
> > ________________________________
> > From: j-t...@li...
> > [mailto:j-t...@li...] On Behalf Of Peter
> > Thomas
> > Sent: Wednesday, 2 April 2008 11:33 PM
> > To: JTrac users mailing-list
> > Subject: Re: [jtrac-users] Mysql migration problems
> >
> >
> >
> > Hi,
> >
> > I ran into this exact same problem today (coincidence!) when migrating
> > another Java app from windows to linux at work. We found this link
> > which saved the day:
> >
> > http://confluence.atlassian.com/display/KB/CSP-13667+-+java.sql.SQLExc
> > eption++Table+%27confluence.BANDANA%27+doesn%27t+exist
> >
> > I think the simplest solution is to switch your MySQL database to
> > case-insensitive, here is the link the above knowledge-base article
> > points
> > to:
> >
> > http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.htm
> > l
> >
> > Thanks,
> >
> > Peter.
> >
> >
> > On 4/2/08, Stephen Eaton <se...@ga...> wrote:
> > >
> > >
> > > I'm trying to migrate my existing JTRAC installation, the current
> > > stable
> > release of jtrac using HQDB on a win2003 server, to mysql running on a
> > seperate linux server.
> > >
> > > I have made the changes the jtrac.properties connector and restarted
> > jtrac, jtrac successfully connects to mysql and creates the missing
> > tables, however the migration script bombs out with the following errors:
> > >
> > > D:\jtrac\data\db>java -cp
> > bsh-2.0b4.jar;hsqldb-1.8.0.1.jar;mysql-connector-java-
> > > 5.1.6-bin.jar bsh.Interpreter jtrac-hsqldb-to-mysql.bsh insert into
> > > ATTACHMENTS (ID, PREVIOUS_ID, FILE_NAME, FILE_PREFIX, ITEM_ID)
> > value
> > > s (?, ?, ?, ?, ?)
> > > Script threw exception: Sourced file: jtrac-hsqldb-to-mysql.bsh :
> > > Method
> > Invocat
> > > ion stmt2.execute : at Line: 48 : in file: jtrac-hsqldb-to-mysql.bsh :
> > stmt2 .ex
> > > ecute ( )
> > >
> > > Target exception:
> > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab
> > > le 'jtrac.ATTACHMENTS' doesn't exist
> > >
> > > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> > 'jtrac.ATTACHME
> > > NTS' doesn't exist
> > > at
> > > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> > Method)
> > >
> > > at
> > > sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
> > Source)
> > >
> > > at
> > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
> > > rce)
> > > at java.lang.reflect.Constructor.newInstance(Unknown Source)
> > > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> > > at com.mysql.jdbc.Util.getInstance(Util.java:381)
> > > at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
> > > at
> > > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> > >
> > >
> > > What looks like the problem are the table names that jtrac created
> > > within
> > mysql are all in lowercase, not uppercase that the script seems to
> > show and so does not see them.
> > >
> > >
> > > Stephen...
> > > --------------------------------------------------------------------
> > > ----- Check out the new SourceForge.net Marketplace.
> > > It's the best place to buy or sell services for just about anything
> > > Open Source.
> > >
> > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marke
> > tplace
> > > _______________________________________________
> > > j-trac-users mailing list
> > > j-t...@li...
> > > https://lists.sourceforge.net/lists/listinfo/j-trac-users
> > >
> > >
> >
> >
> > ----------------------------------------------------------------------
> > --- Check out the new SourceForge.net Marketplace.
> > It's the best place to buy or sell services for just about anything
> > Open Source.
> >
> > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marke
> > tplace _______________________________________________
> > j-trac-users mailing list
> > j-t...@li...
> > https://lists.sourceforge.net/lists/listinfo/j-trac-users
> >
> >
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for just about anything Open
> Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> j-trac-users mailing list
> j-t...@li...
> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>
> __________ NOD32 2996 (20080403) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>
>
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> j-trac-users mailing list
> j-t...@li...
> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>
|
|
From: Tauren M. <ta...@ta...> - 2008-04-03 07:48:27
|
That's weird. Your script does essentially the same thing, doesn't
it? You just split the test into two if/else clauses instead of using
an or operator. Hmm. Well, at least you got it going!
Tauren
On Wed, Apr 2, 2008 at 11:41 PM, Stephen Eaton <se...@ga...> wrote:
> thanks for that, while it worked on the spaces, it bombed out on the users
> where you said so I modified your script and this worked for me!
>
>
> Stephen...
>
> ----------------
>
> import java.sql.*;
>
> Class.forName("org.hsqldb.jdbcDriver");
> Class.forName("com.mysql.jdbc.Driver");
>
> conn1 = DriverManager.getConnection("jdbc:hsqldb:file:jtrac", "sa", "");
> conn2 = DriverManager.getConnection("jdbc:mysql://mysql/jtrac", "jtrac",
> "jtrac");
>
>
>
> md1 = conn1.getMetaData();
> rs = md1.getTables(null, null, null, new String[] { "TABLE" });
>
> tableNames = new ArrayList();
>
> while (rs.next()) {
> tableNames.add(rs.getString("TABLE_NAME"));
> }
>
> stmt1 = conn1.createStatement();
>
> stmt2 = conn2.createStatement();
> stmt2.executeUpdate("delete from user_space_roles");
> stmt2.executeUpdate("delete from users");
>
> for (tableName : tableNames) {
> tableName = tableName.toLowerCase();
> rs = stmt1.executeQuery("select * from " + tableName);
> md = rs.getMetaData();
> cols = "";
> vals = "";
> for (int i = 1; i <= md.getColumnCount(); i++) {
> cols = cols + md.getColumnName(i);
> vals = vals + "?";
> if (i != md.getColumnCount()) {
> cols = cols + ", ";
> vals = vals + ", ";
> }
> }
> ins = "insert into " + tableName + " (" + cols + ") values (" + vals +
> ")";
> print(ins);
> stmt2 = conn2.prepareStatement(ins);
> while (rs.next()) {
> for (int i = 1; i <= md.getColumnCount(); i++) {
> if (md.getColumnType(i) == Types.TIMESTAMP) {
> stmt2.setTimestamp(i, rs.getTimestamp(i));
> } else {
>
> String name = md.getColumnName(i).toLowerCase();
> if (name.equals("locked")) {
>
> stmt2.setBoolean(i, rs.getInt(i) == 1);
> } else if (name.equals("guest_allowed")) {
>
> stmt2.setBoolean(i, rs.getInt(i) == 1);
> } else {
> stmt2.setString(i, rs.getString(i));
> }
> }
> }
>
> stmt2.execute();
> }
> }
>
> conn1.close();
> conn2.close();
>
>
>
> -----Original Message-----
> From: j-t...@li...
>
>
> [mailto:j-t...@li...] On Behalf Of Tauren
> Mills
> Sent: Thursday, 3 April 2008 1:34 PM
> To: JTrac users mailing-list
> Subject: Re: [jtrac-users] Mysql migration problems
>
> I ran into these exact same problems, but I didn't want to set my database
> to be case insensitive. So I hacked the jtrac-hsqldb-to-mysql.bsh file.
> See below for the full file.
>
> To get past the first problem (the case sensitive table names), I added this
> line:
>
> tableName = tableName.toLowerCase();
>
> The data truncation error happens for MySQL fields that are of type BIT(1),
> which is used for storing boolean values. To get past this error, which is
> a problem for both spaces.guest_allowed and users.locked, I added these
> lines:
>
> } else if (md.getColumnType(i) == Types.INTEGER) {
> String name = md.getColumnName(i).toLowerCase();
> if (name.equals("guest_allowed") || name.equals("locked")) {
> stmt2.setBoolean(i, rs.getInt(i) == 1);
> } else {
> stmt2.setString(i, rs.getString(i));
> }
>
> This is because in hsqldb, the column type is integer, but the bsh script
> was attempting to convert it to a string. And the string wouldn't fit into
> a bit(1).
>
> I hope this helps! Below is the full script.
>
> Tauren
>
>
> ----------
>
> import java.sql.*;
>
> Class.forName("org.hsqldb.jdbcDriver");
> Class.forName("com.mysql.jdbc.Driver");
>
> conn1 = DriverManager.getConnection("jdbc:hsqldb:file:jtrac", "sa", "");
> conn2 = DriverManager.getConnection("jdbc:mysql://localhost/jtrac", "root",
> "");
>
> md1 = conn1.getMetaData();
> rs = md1.getTables(null, null, null, new String[] { "TABLE" });
>
> tableNames = new ArrayList();
>
> while (rs.next()) {
> tableNames.add(rs.getString("TABLE_NAME"));
> }
>
> stmt1 = conn1.createStatement();
>
> stmt2 = conn2.createStatement();
> stmt2.executeUpdate("delete from user_space_roles");
> stmt2.executeUpdate("delete from users");
>
> for (tableName : tableNames) {
> tableName = tableName.toLowerCase();
> rs = stmt1.executeQuery("select * from " + tableName);
> md = rs.getMetaData();
> cols = "";
> vals = "";
> for (int i = 1; i <= md.getColumnCount(); i++) {
> cols = cols + md.getColumnName(i);
> vals = vals + "?";
> if (i != md.getColumnCount()) {
> cols = cols + ", ";
> vals = vals + ", ";
> }
> }
> ins = "insert into " + tableName + " (" + cols + ") values (" + vals +
> ")";
> print(ins);
> stmt2 = conn2.prepareStatement(ins);
> while (rs.next()) {
> for (int i = 1; i <= md.getColumnCount(); i++) {
> if (md.getColumnType(i) == Types.TIMESTAMP) {
> stmt2.setTimestamp(i, rs.getTimestamp(i));
> } else if (md.getColumnType(i) == Types.INTEGER) {
> String name = md.getColumnName(i).toLowerCase();
> if (name.equals("guest_allowed") || name.equals("locked")) {
> stmt2.setBoolean(i, rs.getInt(i) == 1);
> } else {
> stmt2.setString(i, rs.getString(i));
> }
> } else {
> stmt2.setString(i, rs.getString(i));
> }
> }
> stmt2.execute();
> }
> }
>
> conn1.close();
> conn2.close();
>
>
> On Wed, Apr 2, 2008 at 8:35 PM, Stephen Eaton <se...@ga...> wrote:
> >
> >
> > lol good timing on my part, that definately fixed the problem thatnks
> > foir that Peter, but has raised another during the migration process
> >
> > D:\jtrac\data\db>java -cp
> > bsh-2.0b4.jar;hsqldb-1.8.0.1.jar;mysql-connector-java-
> > 5.1.6-bin.jar bsh.Interpreter jtrac-hsqldb-to-mysql.bsh insert into
> > ATTACHMENTS (ID, PREVIOUS_ID, FILE_NAME, FILE_PREFIX, ITEM_ID) values
> > (?, ?, ?, ?, ?) insert into CONFIG (PARAM, VALUE) values (?, ?) insert
> > into HISTORY (ID, ITEM_ID, VERSION, TYPE, ACTUAL_EFFORT,
> > ATTACHMENT_ID, COMMENT, TIME_STAMP, LOGGED_BY, ASSIGNED_TO, SUMMARY,
> > DETAIL, STATUS, SEVERITY, PRIORITY, CUS_DBL_01, CUS_DBL_02,
> > CUS_DBL_03, CUS_INT_01, CUS_INT_02, CUS_INT_03, CUS_INT_04,
> > CUS_INT_05, CUS_INT_06, CUS_INT_07, CUS_INT_08, CUS_INT_09,
> > CUS_INT_10, CUS_STR_01, CUS_STR_02, CUS_STR_03, CUS_STR_04,
> > CUS_STR_05, CUS_TIM_01, CUS_TIM_02, CUS_TIM_03) values (?, ?, ?, ?, ?,
> > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> > ?, ?, ?, ?, ?, ?, ?) insert into ITEMS (ID, VERSION, TYPE, PARENT_ID,
> > SPACE_ID, SEQUENCE_NUM, TIME_STAMP, PLANNED_EFFORT, LOGGED_BY,
> > ASSIGNED_TO, SUMMARY, DETAIL, STATUS, SEVERITY,PRIORITY, CUS_DBL_01,
> > CUS_DBL_02, US_DBL_03, CUS_INT_01, CUS_INT_02, CUS_INT_03, CUS_INT_04,
> > CUS_INT_05, CUS_INT_06, CUS_INT_07, CUS_INT_08, CUS_INT_09,
> > CUS_INT_10, CUS_STR_01, CUS_STR_02, CUS_STR_03, CUS_STR_04,
> > CUS_STR_05, CUS_TIM_01, CUS_TIM_02, CUS_TIM_03) values (?, ?, ?, ?, ?,
> > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> > ?, ?, ?, ?, ?, ?, ?, ?) insert into ITEM_ITEMS (ID, ITEM_ID,
> > RELATED_ITEM_ID, TYPE) values (?, ?, ?,
> > ?)
> > insert into ITEM_TAGS (ID, TAG_ID, TYPE, ITEM_ID) values (?, ?, ?, ?)
> > insert into ITEM_USERS (ID, USER_ID, TYPE, ITEM_ID) values (?, ?, ?,
> > ?) insert into METADATA (ID, VERSION, TYPE, NAME, DESCRIPTION,
> > PARENT_ID,
> > XML_STRING) values (?, ?, ?, ?, ?, ?, ?) insert into SPACES (ID,
> > VERSION, TYPE, PREFIX_CODE, NAME, DESCRIPTION, METADATA_ID,
> > GUEST_ALLOWED) values (?, ?, ?, ?, ?, ?, ?, ?) Script threw exception:
> > Sourced file: jtrac-hsqldb-to-mysql.bsh : Method Invocation
> > stmt2.execute : at Line: 48 : in file: jtrac-hsqldb-to-mysql.bsh
> > : stmt2 .execute ( )
> >
> > Target exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation:
> > Data too long for column 'guest_allowed' at row 1
> >
> > com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for
> > column 'guest_allowed' at row 1
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3489)
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
> > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
> > at
> >
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734
> )
> > at
> > com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995)
> > at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
> > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> > at java.lang.reflect.Method.invoke(Unknown Source)
> > at bsh.Reflect.invokeMethod(Unknown Source)
> > at bsh.Reflect.invokeObjectMethod(Unknown Source)
> > at bsh.Name.invokeMethod(Unknown Source)
> > at bsh.BSHMethodInvocation.eval(Unknown Source)
> > at bsh.BSHPrimaryExpression.eval(Unknown Source)
> > at bsh.BSHPrimaryExpression.eval(Unknown Source)
> > at bsh.BSHBlock.evalBlock(Unknown Source)
> > at bsh.BSHBlock.eval(Unknown Source)
> > at bsh.BSHBlock.eval(Unknown Source)
> > at bsh.BSHWhileStatement.eval(Unknown Source)
> > at bsh.BSHBlock.evalBlock(Unknown Source)
> > at bsh.BSHBlock.eval(Unknown Source)
> > at bsh.BSHBlock.eval(Unknown Source)
> > at bsh.BSHEnhancedForStatement.eval(Unknown Source)
> > at bsh.Interpreter.eval(Unknown Source)
> > at bsh.Interpreter.source(Unknown Source)
> > at bsh.Interpreter.main(Unknown Source)
> >
> > ________________________________
> > From: j-t...@li...
> > [mailto:j-t...@li...] On Behalf Of Peter
> > Thomas
> > Sent: Wednesday, 2 April 2008 11:33 PM
> > To: JTrac users mailing-list
> > Subject: Re: [jtrac-users] Mysql migration problems
> >
> >
> >
> > Hi,
> >
> > I ran into this exact same problem today (coincidence!) when migrating
> > another Java app from windows to linux at work. We found this link
> > which saved the day:
> >
> > http://confluence.atlassian.com/display/KB/CSP-13667+-+java.sql.SQLExc
> > eption++Table+%27confluence.BANDANA%27+doesn%27t+exist
> >
> > I think the simplest solution is to switch your MySQL database to
> > case-insensitive, here is the link the above knowledge-base article
> > points
> > to:
> >
> > http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.htm
> > l
> >
> > Thanks,
> >
> > Peter.
> >
> >
> > On 4/2/08, Stephen Eaton <se...@ga...> wrote:
> > >
> > >
> > > I'm trying to migrate my existing JTRAC installation, the current
> > > stable
> > release of jtrac using HQDB on a win2003 server, to mysql running on a
> > seperate linux server.
> > >
> > > I have made the changes the jtrac.properties connector and restarted
> > jtrac, jtrac successfully connects to mysql and creates the missing
> > tables, however the migration script bombs out with the following errors:
> > >
> > > D:\jtrac\data\db>java -cp
> > bsh-2.0b4.jar;hsqldb-1.8.0.1.jar;mysql-connector-java-
> > > 5.1.6-bin.jar bsh.Interpreter jtrac-hsqldb-to-mysql.bsh insert into
> > > ATTACHMENTS (ID, PREVIOUS_ID, FILE_NAME, FILE_PREFIX, ITEM_ID)
> > value
> > > s (?, ?, ?, ?, ?)
> > > Script threw exception: Sourced file: jtrac-hsqldb-to-mysql.bsh :
> > > Method
> > Invocat
> > > ion stmt2.execute : at Line: 48 : in file: jtrac-hsqldb-to-mysql.bsh :
> > stmt2 .ex
> > > ecute ( )
> > >
> > > Target exception:
> > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab
> > > le 'jtrac.ATTACHMENTS' doesn't exist
> > >
> > > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> > 'jtrac.ATTACHME
> > > NTS' doesn't exist
> > > at
> > > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> > Method)
> > >
> > > at
> > > sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
> > Source)
> > >
> > > at
> > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
> > > rce)
> > > at java.lang.reflect.Constructor.newInstance(Unknown Source)
> > > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> > > at com.mysql.jdbc.Util.getInstance(Util.java:381)
> > > at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
> > > at
> > > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> > >
> > >
> > > What looks like the problem are the table names that jtrac created
> > > within
> > mysql are all in lowercase, not uppercase that the script seems to
> > show and so does not see them.
> > >
> > >
> > > Stephen...
> > > --------------------------------------------------------------------
> > > ----- Check out the new SourceForge.net Marketplace.
> > > It's the best place to buy or sell services for just about anything
> > > Open Source.
> > >
> > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marke
> > tplace
> > > _______________________________________________
> > > j-trac-users mailing list
> > > j-t...@li...
> > > https://lists.sourceforge.net/lists/listinfo/j-trac-users
> > >
> > >
> >
> >
> > ----------------------------------------------------------------------
> > --- Check out the new SourceForge.net Marketplace.
> > It's the best place to buy or sell services for just about anything
> > Open Source.
> >
> > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marke
> > tplace _______________________________________________
> > j-trac-users mailing list
> > j-t...@li...
> > https://lists.sourceforge.net/lists/listinfo/j-trac-users
> >
> >
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for just about anything Open
> Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> j-trac-users mailing list
> j-t...@li...
> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>
> __________ NOD32 2996 (20080403) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>
>
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> j-trac-users mailing list
> j-t...@li...
> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>
|
|
From: Stephen E. <se...@ga...> - 2008-04-03 06:42:33
|
thanks for that, while it worked on the spaces, it bombed out on the users
where you said so I modified your script and this worked for me!
Stephen...
----------------
import java.sql.*;
Class.forName("org.hsqldb.jdbcDriver");
Class.forName("com.mysql.jdbc.Driver");
conn1 = DriverManager.getConnection("jdbc:hsqldb:file:jtrac", "sa", "");
conn2 = DriverManager.getConnection("jdbc:mysql://mysql/jtrac", "jtrac",
"jtrac");
md1 = conn1.getMetaData();
rs = md1.getTables(null, null, null, new String[] { "TABLE" });
tableNames = new ArrayList();
while (rs.next()) {
tableNames.add(rs.getString("TABLE_NAME"));
}
stmt1 = conn1.createStatement();
stmt2 = conn2.createStatement();
stmt2.executeUpdate("delete from user_space_roles");
stmt2.executeUpdate("delete from users");
for (tableName : tableNames) {
tableName = tableName.toLowerCase();
rs = stmt1.executeQuery("select * from " + tableName);
md = rs.getMetaData();
cols = "";
vals = "";
for (int i = 1; i <= md.getColumnCount(); i++) {
cols = cols + md.getColumnName(i);
vals = vals + "?";
if (i != md.getColumnCount()) {
cols = cols + ", ";
vals = vals + ", ";
}
}
ins = "insert into " + tableName + " (" + cols + ") values (" + vals +
")";
print(ins);
stmt2 = conn2.prepareStatement(ins);
while (rs.next()) {
for (int i = 1; i <= md.getColumnCount(); i++) {
if (md.getColumnType(i) == Types.TIMESTAMP) {
stmt2.setTimestamp(i, rs.getTimestamp(i));
} else {
String name = md.getColumnName(i).toLowerCase();
if (name.equals("locked")) {
stmt2.setBoolean(i, rs.getInt(i) == 1);
} else if (name.equals("guest_allowed")) {
stmt2.setBoolean(i, rs.getInt(i) == 1);
} else {
stmt2.setString(i, rs.getString(i));
}
}
}
stmt2.execute();
}
}
conn1.close();
conn2.close();
-----Original Message-----
From: j-t...@li...
[mailto:j-t...@li...] On Behalf Of Tauren
Mills
Sent: Thursday, 3 April 2008 1:34 PM
To: JTrac users mailing-list
Subject: Re: [jtrac-users] Mysql migration problems
I ran into these exact same problems, but I didn't want to set my database
to be case insensitive. So I hacked the jtrac-hsqldb-to-mysql.bsh file.
See below for the full file.
To get past the first problem (the case sensitive table names), I added this
line:
tableName = tableName.toLowerCase();
The data truncation error happens for MySQL fields that are of type BIT(1),
which is used for storing boolean values. To get past this error, which is
a problem for both spaces.guest_allowed and users.locked, I added these
lines:
} else if (md.getColumnType(i) == Types.INTEGER) {
String name = md.getColumnName(i).toLowerCase();
if (name.equals("guest_allowed") || name.equals("locked")) {
stmt2.setBoolean(i, rs.getInt(i) == 1);
} else {
stmt2.setString(i, rs.getString(i));
}
This is because in hsqldb, the column type is integer, but the bsh script
was attempting to convert it to a string. And the string wouldn't fit into
a bit(1).
I hope this helps! Below is the full script.
Tauren
----------
import java.sql.*;
Class.forName("org.hsqldb.jdbcDriver");
Class.forName("com.mysql.jdbc.Driver");
conn1 = DriverManager.getConnection("jdbc:hsqldb:file:jtrac", "sa", "");
conn2 = DriverManager.getConnection("jdbc:mysql://localhost/jtrac", "root",
"");
md1 = conn1.getMetaData();
rs = md1.getTables(null, null, null, new String[] { "TABLE" });
tableNames = new ArrayList();
while (rs.next()) {
tableNames.add(rs.getString("TABLE_NAME"));
}
stmt1 = conn1.createStatement();
stmt2 = conn2.createStatement();
stmt2.executeUpdate("delete from user_space_roles");
stmt2.executeUpdate("delete from users");
for (tableName : tableNames) {
tableName = tableName.toLowerCase();
rs = stmt1.executeQuery("select * from " + tableName);
md = rs.getMetaData();
cols = "";
vals = "";
for (int i = 1; i <= md.getColumnCount(); i++) {
cols = cols + md.getColumnName(i);
vals = vals + "?";
if (i != md.getColumnCount()) {
cols = cols + ", ";
vals = vals + ", ";
}
}
ins = "insert into " + tableName + " (" + cols + ") values (" + vals +
")";
print(ins);
stmt2 = conn2.prepareStatement(ins);
while (rs.next()) {
for (int i = 1; i <= md.getColumnCount(); i++) {
if (md.getColumnType(i) == Types.TIMESTAMP) {
stmt2.setTimestamp(i, rs.getTimestamp(i));
} else if (md.getColumnType(i) == Types.INTEGER) {
String name = md.getColumnName(i).toLowerCase();
if (name.equals("guest_allowed") || name.equals("locked")) {
stmt2.setBoolean(i, rs.getInt(i) == 1);
} else {
stmt2.setString(i, rs.getString(i));
}
} else {
stmt2.setString(i, rs.getString(i));
}
}
stmt2.execute();
}
}
conn1.close();
conn2.close();
On Wed, Apr 2, 2008 at 8:35 PM, Stephen Eaton <se...@ga...> wrote:
>
>
> lol good timing on my part, that definately fixed the problem thatnks
> foir that Peter, but has raised another during the migration process
>
> D:\jtrac\data\db>java -cp
> bsh-2.0b4.jar;hsqldb-1.8.0.1.jar;mysql-connector-java-
> 5.1.6-bin.jar bsh.Interpreter jtrac-hsqldb-to-mysql.bsh insert into
> ATTACHMENTS (ID, PREVIOUS_ID, FILE_NAME, FILE_PREFIX, ITEM_ID) values
> (?, ?, ?, ?, ?) insert into CONFIG (PARAM, VALUE) values (?, ?) insert
> into HISTORY (ID, ITEM_ID, VERSION, TYPE, ACTUAL_EFFORT,
> ATTACHMENT_ID, COMMENT, TIME_STAMP, LOGGED_BY, ASSIGNED_TO, SUMMARY,
> DETAIL, STATUS, SEVERITY, PRIORITY, CUS_DBL_01, CUS_DBL_02,
> CUS_DBL_03, CUS_INT_01, CUS_INT_02, CUS_INT_03, CUS_INT_04,
> CUS_INT_05, CUS_INT_06, CUS_INT_07, CUS_INT_08, CUS_INT_09,
> CUS_INT_10, CUS_STR_01, CUS_STR_02, CUS_STR_03, CUS_STR_04,
> CUS_STR_05, CUS_TIM_01, CUS_TIM_02, CUS_TIM_03) values (?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?) insert into ITEMS (ID, VERSION, TYPE, PARENT_ID,
> SPACE_ID, SEQUENCE_NUM, TIME_STAMP, PLANNED_EFFORT, LOGGED_BY,
> ASSIGNED_TO, SUMMARY, DETAIL, STATUS, SEVERITY,PRIORITY, CUS_DBL_01,
> CUS_DBL_02, US_DBL_03, CUS_INT_01, CUS_INT_02, CUS_INT_03, CUS_INT_04,
> CUS_INT_05, CUS_INT_06, CUS_INT_07, CUS_INT_08, CUS_INT_09,
> CUS_INT_10, CUS_STR_01, CUS_STR_02, CUS_STR_03, CUS_STR_04,
> CUS_STR_05, CUS_TIM_01, CUS_TIM_02, CUS_TIM_03) values (?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?) insert into ITEM_ITEMS (ID, ITEM_ID,
> RELATED_ITEM_ID, TYPE) values (?, ?, ?,
> ?)
> insert into ITEM_TAGS (ID, TAG_ID, TYPE, ITEM_ID) values (?, ?, ?, ?)
> insert into ITEM_USERS (ID, USER_ID, TYPE, ITEM_ID) values (?, ?, ?,
> ?) insert into METADATA (ID, VERSION, TYPE, NAME, DESCRIPTION,
> PARENT_ID,
> XML_STRING) values (?, ?, ?, ?, ?, ?, ?) insert into SPACES (ID,
> VERSION, TYPE, PREFIX_CODE, NAME, DESCRIPTION, METADATA_ID,
> GUEST_ALLOWED) values (?, ?, ?, ?, ?, ?, ?, ?) Script threw exception:
> Sourced file: jtrac-hsqldb-to-mysql.bsh : Method Invocation
> stmt2.execute : at Line: 48 : in file: jtrac-hsqldb-to-mysql.bsh
> : stmt2 .execute ( )
>
> Target exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation:
> Data too long for column 'guest_allowed' at row 1
>
> com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for
> column 'guest_allowed' at row 1
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3489)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
> at
>
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734
)
> at
> com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995)
> at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at bsh.Reflect.invokeMethod(Unknown Source)
> at bsh.Reflect.invokeObjectMethod(Unknown Source)
> at bsh.Name.invokeMethod(Unknown Source)
> at bsh.BSHMethodInvocation.eval(Unknown Source)
> at bsh.BSHPrimaryExpression.eval(Unknown Source)
> at bsh.BSHPrimaryExpression.eval(Unknown Source)
> at bsh.BSHBlock.evalBlock(Unknown Source)
> at bsh.BSHBlock.eval(Unknown Source)
> at bsh.BSHBlock.eval(Unknown Source)
> at bsh.BSHWhileStatement.eval(Unknown Source)
> at bsh.BSHBlock.evalBlock(Unknown Source)
> at bsh.BSHBlock.eval(Unknown Source)
> at bsh.BSHBlock.eval(Unknown Source)
> at bsh.BSHEnhancedForStatement.eval(Unknown Source)
> at bsh.Interpreter.eval(Unknown Source)
> at bsh.Interpreter.source(Unknown Source)
> at bsh.Interpreter.main(Unknown Source)
>
> ________________________________
> From: j-t...@li...
> [mailto:j-t...@li...] On Behalf Of Peter
> Thomas
> Sent: Wednesday, 2 April 2008 11:33 PM
> To: JTrac users mailing-list
> Subject: Re: [jtrac-users] Mysql migration problems
>
>
>
> Hi,
>
> I ran into this exact same problem today (coincidence!) when migrating
> another Java app from windows to linux at work. We found this link
> which saved the day:
>
> http://confluence.atlassian.com/display/KB/CSP-13667+-+java.sql.SQLExc
> eption++Table+%27confluence.BANDANA%27+doesn%27t+exist
>
> I think the simplest solution is to switch your MySQL database to
> case-insensitive, here is the link the above knowledge-base article
> points
> to:
>
> http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.htm
> l
>
> Thanks,
>
> Peter.
>
>
> On 4/2/08, Stephen Eaton <se...@ga...> wrote:
> >
> >
> > I'm trying to migrate my existing JTRAC installation, the current
> > stable
> release of jtrac using HQDB on a win2003 server, to mysql running on a
> seperate linux server.
> >
> > I have made the changes the jtrac.properties connector and restarted
> jtrac, jtrac successfully connects to mysql and creates the missing
> tables, however the migration script bombs out with the following errors:
> >
> > D:\jtrac\data\db>java -cp
> bsh-2.0b4.jar;hsqldb-1.8.0.1.jar;mysql-connector-java-
> > 5.1.6-bin.jar bsh.Interpreter jtrac-hsqldb-to-mysql.bsh insert into
> > ATTACHMENTS (ID, PREVIOUS_ID, FILE_NAME, FILE_PREFIX, ITEM_ID)
> value
> > s (?, ?, ?, ?, ?)
> > Script threw exception: Sourced file: jtrac-hsqldb-to-mysql.bsh :
> > Method
> Invocat
> > ion stmt2.execute : at Line: 48 : in file: jtrac-hsqldb-to-mysql.bsh :
> stmt2 .ex
> > ecute ( )
> >
> > Target exception:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab
> > le 'jtrac.ATTACHMENTS' doesn't exist
> >
> > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'jtrac.ATTACHME
> > NTS' doesn't exist
> > at
> > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> >
> > at
> > sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
> Source)
> >
> > at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
> > rce)
> > at java.lang.reflect.Constructor.newInstance(Unknown Source)
> > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> > at com.mysql.jdbc.Util.getInstance(Util.java:381)
> > at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
> > at
> > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> >
> >
> > What looks like the problem are the table names that jtrac created
> > within
> mysql are all in lowercase, not uppercase that the script seems to
> show and so does not see them.
> >
> >
> > Stephen...
> > --------------------------------------------------------------------
> > ----- Check out the new SourceForge.net Marketplace.
> > It's the best place to buy or sell services for just about anything
> > Open Source.
> >
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marke
> tplace
> > _______________________________________________
> > j-trac-users mailing list
> > j-t...@li...
> > https://lists.sourceforge.net/lists/listinfo/j-trac-users
> >
> >
>
>
> ----------------------------------------------------------------------
> --- Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for just about anything
> Open Source.
>
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marke
> tplace _______________________________________________
> j-trac-users mailing list
> j-t...@li...
> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>
>
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for just about anything Open
Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
j-trac-users mailing list
j-t...@li...
https://lists.sourceforge.net/lists/listinfo/j-trac-users
__________ NOD32 2996 (20080403) Information __________
This message was checked by NOD32 antivirus system.
http://www.eset.com
|
|
From: Tauren M. <ta...@gr...> - 2008-04-03 05:33:56
|
I ran into these exact same problems, but I didn't want to set my
database to be case insensitive. So I hacked the
jtrac-hsqldb-to-mysql.bsh file. See below for the full file.
To get past the first problem (the case sensitive table names), I
added this line:
tableName = tableName.toLowerCase();
The data truncation error happens for MySQL fields that are of type
BIT(1), which is used for storing boolean values. To get past this
error, which is a problem for both spaces.guest_allowed and
users.locked, I added these lines:
} else if (md.getColumnType(i) == Types.INTEGER) {
String name = md.getColumnName(i).toLowerCase();
if (name.equals("guest_allowed") || name.equals("locked")) {
stmt2.setBoolean(i, rs.getInt(i) == 1);
} else {
stmt2.setString(i, rs.getString(i));
}
This is because in hsqldb, the column type is integer, but the bsh
script was attempting to convert it to a string. And the string
wouldn't fit into a bit(1).
I hope this helps! Below is the full script.
Tauren
----------
import java.sql.*;
Class.forName("org.hsqldb.jdbcDriver");
Class.forName("com.mysql.jdbc.Driver");
conn1 = DriverManager.getConnection("jdbc:hsqldb:file:jtrac", "sa", "");
conn2 = DriverManager.getConnection("jdbc:mysql://localhost/jtrac", "root", "");
md1 = conn1.getMetaData();
rs = md1.getTables(null, null, null, new String[] { "TABLE" });
tableNames = new ArrayList();
while (rs.next()) {
tableNames.add(rs.getString("TABLE_NAME"));
}
stmt1 = conn1.createStatement();
stmt2 = conn2.createStatement();
stmt2.executeUpdate("delete from user_space_roles");
stmt2.executeUpdate("delete from users");
for (tableName : tableNames) {
tableName = tableName.toLowerCase();
rs = stmt1.executeQuery("select * from " + tableName);
md = rs.getMetaData();
cols = "";
vals = "";
for (int i = 1; i <= md.getColumnCount(); i++) {
cols = cols + md.getColumnName(i);
vals = vals + "?";
if (i != md.getColumnCount()) {
cols = cols + ", ";
vals = vals + ", ";
}
}
ins = "insert into " + tableName + " (" + cols + ") values (" + vals + ")";
print(ins);
stmt2 = conn2.prepareStatement(ins);
while (rs.next()) {
for (int i = 1; i <= md.getColumnCount(); i++) {
if (md.getColumnType(i) == Types.TIMESTAMP) {
stmt2.setTimestamp(i, rs.getTimestamp(i));
} else if (md.getColumnType(i) == Types.INTEGER) {
String name = md.getColumnName(i).toLowerCase();
if (name.equals("guest_allowed") || name.equals("locked")) {
stmt2.setBoolean(i, rs.getInt(i) == 1);
} else {
stmt2.setString(i, rs.getString(i));
}
} else {
stmt2.setString(i, rs.getString(i));
}
}
stmt2.execute();
}
}
conn1.close();
conn2.close();
On Wed, Apr 2, 2008 at 8:35 PM, Stephen Eaton <se...@ga...> wrote:
>
>
> lol good timing on my part, that definately fixed the problem thatnks foir
> that Peter, but has raised another during the migration process
>
> D:\jtrac\data\db>java -cp
> bsh-2.0b4.jar;hsqldb-1.8.0.1.jar;mysql-connector-java-
> 5.1.6-bin.jar bsh.Interpreter jtrac-hsqldb-to-mysql.bsh
> insert into ATTACHMENTS (ID, PREVIOUS_ID, FILE_NAME, FILE_PREFIX, ITEM_ID)
> values (?, ?, ?, ?, ?)
> insert into CONFIG (PARAM, VALUE) values (?, ?)
> insert into HISTORY (ID, ITEM_ID, VERSION, TYPE, ACTUAL_EFFORT,
> ATTACHMENT_ID, COMMENT, TIME_STAMP, LOGGED_BY, ASSIGNED_TO, SUMMARY, DETAIL,
> STATUS, SEVERITY, PRIORITY, CUS_DBL_01, CUS_DBL_02, CUS_DBL_03, CUS_INT_01,
> CUS_INT_02, CUS_INT_03, CUS_INT_04, CUS_INT_05, CUS_INT_06, CUS_INT_07,
> CUS_INT_08, CUS_INT_09, CUS_INT_10, CUS_STR_01, CUS_STR_02, CUS_STR_03,
> CUS_STR_04, CUS_STR_05, CUS_TIM_01, CUS_TIM_02, CUS_TIM_03) values (?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?)
> insert into ITEMS (ID, VERSION, TYPE, PARENT_ID, SPACE_ID, SEQUENCE_NUM,
> TIME_STAMP, PLANNED_EFFORT, LOGGED_BY, ASSIGNED_TO, SUMMARY, DETAIL, STATUS,
> SEVERITY,PRIORITY, CUS_DBL_01, CUS_DBL_02, US_DBL_03, CUS_INT_01,
> CUS_INT_02, CUS_INT_03, CUS_INT_04, CUS_INT_05, CUS_INT_06, CUS_INT_07,
> CUS_INT_08, CUS_INT_09, CUS_INT_10, CUS_STR_01, CUS_STR_02, CUS_STR_03,
> CUS_STR_04, CUS_STR_05, CUS_TIM_01, CUS_TIM_02, CUS_TIM_03) values (?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?)
> insert into ITEM_ITEMS (ID, ITEM_ID, RELATED_ITEM_ID, TYPE) values (?, ?, ?,
> ?)
> insert into ITEM_TAGS (ID, TAG_ID, TYPE, ITEM_ID) values (?, ?, ?, ?)
> insert into ITEM_USERS (ID, USER_ID, TYPE, ITEM_ID) values (?, ?, ?, ?)
> insert into METADATA (ID, VERSION, TYPE, NAME, DESCRIPTION, PARENT_ID,
> XML_STRING) values (?, ?, ?, ?, ?, ?, ?)
> insert into SPACES (ID, VERSION, TYPE, PREFIX_CODE, NAME, DESCRIPTION,
> METADATA_ID, GUEST_ALLOWED) values (?, ?, ?, ?, ?, ?, ?, ?)
> Script threw exception: Sourced file: jtrac-hsqldb-to-mysql.bsh : Method
> Invocation stmt2.execute : at Line: 48 : in file: jtrac-hsqldb-to-mysql.bsh
> : stmt2 .execute ( )
>
> Target exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data
> too long for column 'guest_allowed' at row 1
>
> com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for
> column 'guest_allowed' at row 1
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3489)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
> at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
> at
> com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995)
> at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at bsh.Reflect.invokeMethod(Unknown Source)
> at bsh.Reflect.invokeObjectMethod(Unknown Source)
> at bsh.Name.invokeMethod(Unknown Source)
> at bsh.BSHMethodInvocation.eval(Unknown Source)
> at bsh.BSHPrimaryExpression.eval(Unknown Source)
> at bsh.BSHPrimaryExpression.eval(Unknown Source)
> at bsh.BSHBlock.evalBlock(Unknown Source)
> at bsh.BSHBlock.eval(Unknown Source)
> at bsh.BSHBlock.eval(Unknown Source)
> at bsh.BSHWhileStatement.eval(Unknown Source)
> at bsh.BSHBlock.evalBlock(Unknown Source)
> at bsh.BSHBlock.eval(Unknown Source)
> at bsh.BSHBlock.eval(Unknown Source)
> at bsh.BSHEnhancedForStatement.eval(Unknown Source)
> at bsh.Interpreter.eval(Unknown Source)
> at bsh.Interpreter.source(Unknown Source)
> at bsh.Interpreter.main(Unknown Source)
>
> ________________________________
> From: j-t...@li...
> [mailto:j-t...@li...] On Behalf Of Peter
> Thomas
> Sent: Wednesday, 2 April 2008 11:33 PM
> To: JTrac users mailing-list
> Subject: Re: [jtrac-users] Mysql migration problems
>
>
>
> Hi,
>
> I ran into this exact same problem today (coincidence!) when migrating
> another Java app from windows to linux at work. We found this link which
> saved the day:
>
> http://confluence.atlassian.com/display/KB/CSP-13667+-+java.sql.SQLException++Table+%27confluence.BANDANA%27+doesn%27t+exist
>
> I think the simplest solution is to switch your MySQL database to
> case-insensitive, here is the link the above knowledge-base article points
> to:
>
> http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
>
> Thanks,
>
> Peter.
>
>
> On 4/2/08, Stephen Eaton <se...@ga...> wrote:
> >
> >
> > I'm trying to migrate my existing JTRAC installation, the current stable
> release of jtrac using HQDB on a win2003 server, to mysql running on a
> seperate linux server.
> >
> > I have made the changes the jtrac.properties connector and restarted
> jtrac, jtrac successfully connects to mysql and creates the missing tables,
> however the migration script bombs out with the following errors:
> >
> > D:\jtrac\data\db>java -cp
> bsh-2.0b4.jar;hsqldb-1.8.0.1.jar;mysql-connector-java-
> > 5.1.6-bin.jar bsh.Interpreter jtrac-hsqldb-to-mysql.bsh
> > insert into ATTACHMENTS (ID, PREVIOUS_ID, FILE_NAME, FILE_PREFIX, ITEM_ID)
> value
> > s (?, ?, ?, ?, ?)
> > Script threw exception: Sourced file: jtrac-hsqldb-to-mysql.bsh : Method
> Invocat
> > ion stmt2.execute : at Line: 48 : in file: jtrac-hsqldb-to-mysql.bsh :
> stmt2 .ex
> > ecute ( )
> >
> > Target exception:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab
> > le 'jtrac.ATTACHMENTS' doesn't exist
> >
> > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'jtrac.ATTACHME
> > NTS' doesn't exist
> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> >
> > at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
> Source)
> >
> > at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
> > rce)
> > at java.lang.reflect.Constructor.newInstance(Unknown Source)
> > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> > at com.mysql.jdbc.Util.getInstance(Util.java:381)
> > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
> > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> >
> >
> > What looks like the problem are the table names that jtrac created within
> mysql are all in lowercase, not uppercase that the script seems to show and
> so does not see them.
> >
> >
> > Stephen...
> > -------------------------------------------------------------------------
> > Check out the new SourceForge.net Marketplace.
> > It's the best place to buy or sell services for
> > just about anything Open Source.
> >
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> > _______________________________________________
> > j-trac-users mailing list
> > j-t...@li...
> > https://lists.sourceforge.net/lists/listinfo/j-trac-users
> >
> >
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
>
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> j-trac-users mailing list
> j-t...@li...
> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>
>
|
|
From: Stephen E. <se...@ga...> - 2008-04-03 03:37:12
|
lol good timing on my part, that definately fixed the problem thatnks foir
that Peter, but has raised another during the migration process
D:\jtrac\data\db>java -cp
bsh-2.0b4.jar;hsqldb-1.8.0.1.jar;mysql-connector-java-
5.1.6-bin.jar bsh.Interpreter jtrac-hsqldb-to-mysql.bsh
insert into ATTACHMENTS (ID, PREVIOUS_ID, FILE_NAME, FILE_PREFIX, ITEM_ID)
values (?, ?, ?, ?, ?)
insert into CONFIG (PARAM, VALUE) values (?, ?)
insert into HISTORY (ID, ITEM_ID, VERSION, TYPE, ACTUAL_EFFORT,
ATTACHMENT_ID, COMMENT, TIME_STAMP, LOGGED_BY, ASSIGNED_TO, SUMMARY, DETAIL,
STATUS, SEVERITY, PRIORITY, CUS_DBL_01, CUS_DBL_02, CUS_DBL_03, CUS_INT_01,
CUS_INT_02, CUS_INT_03, CUS_INT_04, CUS_INT_05, CUS_INT_06, CUS_INT_07,
CUS_INT_08, CUS_INT_09, CUS_INT_10, CUS_STR_01, CUS_STR_02, CUS_STR_03,
CUS_STR_04, CUS_STR_05, CUS_TIM_01, CUS_TIM_02, CUS_TIM_03) values (?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?)
insert into ITEMS (ID, VERSION, TYPE, PARENT_ID, SPACE_ID, SEQUENCE_NUM,
TIME_STAMP, PLANNED_EFFORT, LOGGED_BY, ASSIGNED_TO, SUMMARY, DETAIL, STATUS,
SEVERITY,PRIORITY, CUS_DBL_01, CUS_DBL_02, US_DBL_03, CUS_INT_01,
CUS_INT_02, CUS_INT_03, CUS_INT_04, CUS_INT_05, CUS_INT_06, CUS_INT_07,
CUS_INT_08, CUS_INT_09, CUS_INT_10, CUS_STR_01, CUS_STR_02, CUS_STR_03,
CUS_STR_04, CUS_STR_05, CUS_TIM_01, CUS_TIM_02, CUS_TIM_03) values (?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?)
insert into ITEM_ITEMS (ID, ITEM_ID, RELATED_ITEM_ID, TYPE) values (?, ?, ?,
?)
insert into ITEM_TAGS (ID, TAG_ID, TYPE, ITEM_ID) values (?, ?, ?, ?)
insert into ITEM_USERS (ID, USER_ID, TYPE, ITEM_ID) values (?, ?, ?, ?)
insert into METADATA (ID, VERSION, TYPE, NAME, DESCRIPTION, PARENT_ID,
XML_STRING) values (?, ?, ?, ?, ?, ?, ?)
insert into SPACES (ID, VERSION, TYPE, PREFIX_CODE, NAME, DESCRIPTION,
METADATA_ID, GUEST_ALLOWED) values (?, ?, ?, ?, ?, ?, ?, ?)
Script threw exception: Sourced file: jtrac-hsqldb-to-mysql.bsh : Method
Invocation stmt2.execute : at Line: 48 : in file: jtrac-hsqldb-to-mysql.bsh
: stmt2 .execute ( )
Target exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data
too long for column 'guest_allowed' at row 1
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for
column 'guest_allowed' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3489)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734
)
at
com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at bsh.Reflect.invokeMethod(Unknown Source)
at bsh.Reflect.invokeObjectMethod(Unknown Source)
at bsh.Name.invokeMethod(Unknown Source)
at bsh.BSHMethodInvocation.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHBlock.evalBlock(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHWhileStatement.eval(Unknown Source)
at bsh.BSHBlock.evalBlock(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHEnhancedForStatement.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at bsh.Interpreter.source(Unknown Source)
at bsh.Interpreter.main(Unknown Source)
_____
From: j-t...@li...
[mailto:j-t...@li...] On Behalf Of Peter
Thomas
Sent: Wednesday, 2 April 2008 11:33 PM
To: JTrac users mailing-list
Subject: Re: [jtrac-users] Mysql migration problems
Hi,
I ran into this exact same problem today (coincidence!) when migrating
another Java app from windows to linux at work. We found this link which
saved the day:
http://confluence.atlassian.com/display/KB/CSP-13667+-+java.sql.SQLException
++Table+%27confluence.BANDANA%27+doesn%27t+exist
I think the simplest solution is to switch your MySQL database to
case-insensitive, here is the link the above knowledge-base article points
to:
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
Thanks,
Peter.
On 4/2/08, Stephen Eaton <se...@ga...> wrote:
I'm trying to migrate my existing JTRAC installation, the current stable
release of jtrac using HQDB on a win2003 server, to mysql running on a
seperate linux server.
I have made the changes the jtrac.properties connector and restarted jtrac,
jtrac successfully connects to mysql and creates the missing tables, however
the migration script bombs out with the following errors:
D:\jtrac\data\db>java -cp
bsh-2.0b4.jar;hsqldb-1.8.0.1.jar;mysql-connector-java-
5.1.6-bin.jar bsh.Interpreter jtrac-hsqldb-to-mysql.bsh
insert into ATTACHMENTS (ID, PREVIOUS_ID, FILE_NAME, FILE_PREFIX, ITEM_ID)
value
s (?, ?, ?, ?, ?)
Script threw exception: Sourced file: jtrac-hsqldb-to-mysql.bsh : Method
Invocat
ion stmt2.execute : at Line: 48 : in file: jtrac-hsqldb-to-mysql.bsh : stmt2
.ex
ecute ( )
Target exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Tab
le 'jtrac.ATTACHMENTS' doesn't exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'jtrac.ATTACHME
NTS' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
What looks like the problem are the table names that jtrac created within
mysql are all in lowercase, not uppercase that the script seems to show and
so does not see them.
Stephen...
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
j-trac-users mailing list
j-t...@li...
https://lists.sourceforge.net/lists/listinfo/j-trac-users
|
|
From: Peter T. <ptr...@gm...> - 2008-04-02 15:32:48
|
Hi, I ran into this exact same problem today (coincidence!) when migrating another Java app from windows to linux at work. We found this link which saved the day: http://confluence.atlassian.com/display/KB/CSP-13667+-+java.sql.SQLException++Table+%27confluence.BANDANA%27+doesn%27t+exist I think the simplest solution is to switch your MySQL database to case-insensitive, here is the link the above knowledge-base article points to: http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html Thanks, Peter. On 4/2/08, Stephen Eaton <se...@ga...> wrote: > > I'm trying to migrate my existing JTRAC installation, the current stable > release of jtrac using HQDB on a win2003 server, to mysql running on a > seperate linux server. > > I have made the changes the jtrac.properties connector and restarted > jtrac, jtrac successfully connects to mysql and creates the missing tables, > however the migration script bombs out with the following errors: > > D:\jtrac\data\db>java -cp > bsh-2.0b4.jar;hsqldb-1.8.0.1.jar;mysql-connector-java- > 5.1.6-bin.jar bsh.Interpreter jtrac-hsqldb-to-mysql.bsh > insert into ATTACHMENTS (ID, PREVIOUS_ID, FILE_NAME, FILE_PREFIX, ITEM_ID) > value > s (?, ?, ?, ?, ?) > Script threw exception: Sourced file: jtrac-hsqldb-to-mysql.bsh : Method > Invocat > ion stmt2.execute : at Line: 48 : in file: jtrac-hsqldb-to-mysql.bsh : > stmt2 .ex > ecute ( ) > > Target exception: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab > le 'jtrac.ATTACHMENTS' doesn't exist > > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'jtrac.ATTACHME > NTS' doesn't exist > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > > at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown > Source) > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou > rce) > at java.lang.reflect.Constructor.newInstance(Unknown Source) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) > at com.mysql.jdbc.Util.getInstance(Util.java:381) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) > > > What looks like the problem are the table names that jtrac created within > mysql are all in lowercase, not uppercase that the script seems to show and > so does not see them. > > > Stephen... > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > j-trac-users mailing list > j-t...@li... > https://lists.sourceforge.net/lists/listinfo/j-trac-users > > |
|
From: Stephen E. <se...@ga...> - 2008-04-02 07:00:57
|
I'm trying to migrate my existing JTRAC installation, the current stable
release of jtrac using HQDB on a win2003 server, to mysql running on a
seperate linux server.
I have made the changes the jtrac.properties connector and restarted jtrac,
jtrac successfully connects to mysql and creates the missing tables, however
the migration script bombs out with the following errors:
D:\jtrac\data\db>java -cp
bsh-2.0b4.jar;hsqldb-1.8.0.1.jar;mysql-connector-java-
5.1.6-bin.jar bsh.Interpreter jtrac-hsqldb-to-mysql.bsh
insert into ATTACHMENTS (ID, PREVIOUS_ID, FILE_NAME, FILE_PREFIX, ITEM_ID)
value
s (?, ?, ?, ?, ?)
Script threw exception: Sourced file: jtrac-hsqldb-to-mysql.bsh : Method
Invocat
ion stmt2.execute : at Line: 48 : in file: jtrac-hsqldb-to-mysql.bsh : stmt2
.ex
ecute ( )
Target exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Tab
le 'jtrac.ATTACHMENTS' doesn't exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'jtrac.ATTACHME
NTS' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
What looks like the problem are the table names that jtrac created within
mysql are all in lowercase, not uppercase that the script seems to show and
so does not see them.
Stephen...
|
|
From: Peter T. <ptr...@gm...> - 2008-03-19 18:17:28
|
Done as r1241. In the URL it should be "svnroot" instead of "viewvc" but thanks a lot for the help. That was easy :) On Wed, Mar 19, 2008 at 11:21 PM, Jeremy Thomerson < je...@th...> wrote: > Peter, > Okay, I've been looking through Fisheye, and found that revision 1216 > was the last revision before you made the 2.1.0 release. So, could you > possibly run the following command on SVN to create the 2.1.0 tag? This > will make it easier for folks like me, who are deploying a custom version of > 2.1.0 into production. We can check out that tag, and apply our patches > to it, build from it, etc. > > svn copy -r 1216 http://j-trac.svn.sourceforge.net/viewvc/j-trac/trunk/jtrac http://j-trac.svn.sourceforge.net/viewvc/j-trac/tags/jtrac-2.1.0 -m "Forgot to tag at 2.1.0 release" > > Let me know what you think. > > Thanks! > Jeremy Thomerson > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > j-trac-users mailing list > j-t...@li... > https://lists.sourceforge.net/lists/listinfo/j-trac-users > > |
21 messages has been excluded from this view by a project administrator.
