j-trac-users — JTrac users

[jtrac-users] Problems getting Dev environment working

[Francisco R. <fra...@gm...>]

Hello good morning,

I am using GNU/Debian Squeeze in a Virtual Machine. I need to modify a
couple of thing of Jtrac and I downloaded the source code of version 2.1.0.
Then installed netbeans 7 but I am facing lots of problems with the mvn
antprops:generate, the response is http://pastebin.com/GwyuA30p.

I was googling a lot then configured the proxy server in
/usr/share/maven2/conf/settings.xml this is my settings.xml
http://pastebin.com/S9LWxDC4 as you can see it is almost the stock one.

I do not know what more to do because I tried even installing manually the
dependencies but it does not work either, maven is trying to download some
plugins but I receive the same errors previously pointed.

Thanks in advanced and best regards, thanks for the comments and
suggestions.

[jtrac-users] Missing data

[KevShih <kev...@se...>]

Has anyone ever experienced where j-trac is suddenly missing all of the data
tables? The indeces are there, but there is only a txt file called
jtrac.script in the data folder. When I open it, it contains an incomplete
sql file to restore the jtrac data, but from nearly a year ago.

Any ideas? Any suggestions on recovering the data? Ive checked my anti-virus
blocked files, the recycle bin, etc., but cannot find the missing data.

Thanks for any help!

Kevin
-- 
View this message in context: http://old.nabble.com/Missing-data-tp31029535p31029535.html
Sent from the j-trac-users mailing list archive at Nabble.com.

[jtrac-users] David Finch/London/GB/BAT@BAT is out of the office.

[<Dav...@ba...>]

I will be out of the office starting  21/02/2011 and will not return until
28/02/2011.

I will respond to your message when I return. If the message is Anaqua
related, please forward it to an...@ba....


_____________________________________________________________________
Confidentiality Notice: The information in this document and attachments is confidential and may also be legally privileged. It is intended only for the use of the named recipient.
Internet communications are not secure and therefore British American Tobacco does not accept legal responsibility for the contents of this message.
If you are not the intended recipient, please notify us immediately and then delete this document. Do not disclose the contents of this document to any other person, nor take any copies.
Violation of this notice may be unlawful.
______________________________________________________________________

Re: [jtrac-users] Mysql migration problems

[chetan108 <che...@gm...>]

I'm running jtrac on Ubuntu 10.04 LTS.  Your script helped me migrate ...
thanks.

I had to make some changes to your script to get it working, though. I was
getting errors for "guest_allowed" and "locked" field : the data would come
in as a Boolean string ("false" or "true").  Whereas int MySQL tables the
fields were set as bit(1).

So I replaced the last else { } block in your script:
            } else {
                stmt2.setString(i, rs.getString(i));
            }
by
            } else {
                String name = md.getColumnName(i).toLowerCase();
                if (name.equals("guest_allowed") || name.equals("locked")) {
		    v = rs.getString(i);
		    stmt2.setInt(i, (v == "false" ? 0 : 1));
		} else {
	            stmt2.setString(i, rs.getString(i));
		}
            }

to get the script working.

Thanks again.
Chetan.


Tauren Mills wrote:
> 
> 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
>>
>>
> 
> -------------------------------------------------------------------------
> 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
> 
> 

-- 
View this message in context: http://old.nabble.com/Mysql-migration-problems-tp16443620p31014262.html
Sent from the j-trac-users mailing list archive at Nabble.com.

Re: [jtrac-users] Hidden fields

[Bartolomeo N. <bni...@si...>]

Hello, 

very interesting, could you tell me which versions of jtrac and calipso
to compare?

Many thanks

Best regards

Bartolomeo

Il giorno mer, 29/12/2010 alle 21.07 +0200, Manos Batsis ha scritto:
> On 12/29/2010 02:08 PM, Bartolomeo Nicolotti wrote:
> > Hello,
> >
> > jtrac is very nice, but it lacks hidden field for certain roles.
> >
> > I've seen that in the sourcer there's written in Metadata.java:
> >
> > // case State.MASK_HIDDEN: state.getFields().put(name,
> > State.MASK_READONLY); return; HIDDEN support in future
> >
> > Could you please tell us when this feature will be implemented or give
> > us any hint to implement it?
> 
> You may be able to extract a patch from calipso since it's based on 
> jtrac and has additional field right types (including hidden and 
> mandatory-if-empty), see
> 
> http://calipso.abiss.gr
> 
> 
> hth,
> 
> Manos
> 
> ------------------------------------------------------------------------------
> Learn how Oracle Real Application Clusters (RAC) One Node allows customers
> to consolidate database storage, standardize their database environment, and, 
> should the need arise, upgrade to a full multi-node Oracle RAC database 
> without downtime or disruption
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> j-trac-users mailing list
> j-t...@li...
> https://lists.sourceforge.net/lists/listinfo/j-trac-users
-- 
____________________________________________________________
Bartolomeo Nicolotti - Reparto Sviluppo - SIAP s.r.l.
Via Sant'Albano, 13 - 12049 Trinità (CN) Italy
Tel. (+39) 0172 652511 - Fax (+39) 0172 652519
E-mail: bni...@si... - URL: www.siapcn.it
Codice Fiscale, Partita IVA, Iscr. Reg. Imprese di Cuneo: 01871320048
Capitale Sociale: € 99.000,00 i.v. - R.E.A. CN 141311
____________________________________________________________

Le informazioni contenute nella presente comunicazione e i relativi
allegati possono essere riservate e sono, comunque, destinate
esclusivamente alle persone o alla Società sopraindicati. La
comunicazione, diffusione, distribuzione e/o copiatura del documento
trasmesso nonché qualsiasi forma di trattamento dei dati ivi contenuti
da parte di qualsiasi soggetto diverso dal destinatario è proibita, sia
ai sensi dell'art. 616 c.p., che ai sensi del D. Lgs. n. 196/2003, ed in
ogni caso espressamente inibita. Se avete ricevuto questo messaggio per
errore, vi preghiamo di distruggerlo e di informarci immediatamente per
telefono allo 0172/652511 o inviando un messaggio all'indirizzo:
in...@si...
____________________________________________________________

This electronic mail transmission, including any accompanying documents
or attachments, may contain information that is confidential,
privileged, proprietary, or otherwise legally exempt from disclosure and
it's intended solely for the addressee(s).  Access to this Internet
electronic mail message by anyone else is unauthorized.  If you are not
the intended recipient, any disclosure, copying, distribution or any
action taken or omitted to be taken in reliance on it is prohibited and
may be unlawful. If you have received this electronic mail erroneously,
we ask you to to destroy it and let us know immediately by phone
at 0172/652511 or by sending an e-mail at in...@si... 
____________________________________________________________

Re: [jtrac-users] Hidden fields

[Manos B. <man...@ge...>]

On 12/29/2010 02:08 PM, Bartolomeo Nicolotti wrote:
> Hello,
>
> jtrac is very nice, but it lacks hidden field for certain roles.
>
> I've seen that in the sourcer there's written in Metadata.java:
>
> // case State.MASK_HIDDEN: state.getFields().put(name,
> State.MASK_READONLY); return; HIDDEN support in future
>
> Could you please tell us when this feature will be implemented or give
> us any hint to implement it?

You may be able to extract a patch from calipso since it's based on 
jtrac and has additional field right types (including hidden and 
mandatory-if-empty), see

http://calipso.abiss.gr


hth,

Manos

[jtrac-users] Hidden fields

[Bartolomeo N. <bni...@si...>]

Hello,

jtrac is very nice, but it lacks hidden field for certain roles.

I've seen that in the sourcer there's written in Metadata.java:

// case State.MASK_HIDDEN: state.getFields().put(name,
State.MASK_READONLY); return; HIDDEN support in future

Could you please tell us when this feature will be implemented or give
us any hint to implement it?  

Many thanks

Best regards

Bartolomeo

[jtrac-users] Urgent Question Regarding JTrac DB and Multiple File uploads (attachements)

[<mak...@pm...>]

Good Day All,

Will I have to alter the DB tables for Items & Attachments to implement Multiple File Upload functionality (the code I can do)? Or is there some "simple" other way?

Cheers,
george

[jtrac-users] Fwd: jtrac + oracle

[Иван С. <ene...@gm...>]

actually , I think i must show all test output:
-------------------------------------------------------------------------------
Test set: info.jtrac.JtracTest
-------------------------------------------------------------------------------
Tests run: 18, Failures: 8, Errors: 5, Skipped: 0, Time elapsed: 5.14 sec
<<< FAILURE!
testUserInsertAndLoad(info.jtrac.JtracTest)  Time elapsed: 0.078 sec  <<<
FAILURE!
junit.framework.AssertionFailedError
 at junit.framework.Assert.fail(Assert.java:47)
at junit.framework.Assert.assertTrue(Assert.java:20)
 at junit.framework.Assert.assertTrue(Assert.java:27)
at info.jtrac.JtracTest.testUserInsertAndLoad(JtracTest.java:92)

testUserSpaceRolesInsert(info.jtrac.JtracTest)  Time elapsed: 0.171 sec  <<<
FAILURE!
junit.framework.ComparisonFailure: expected:<ROLE_TES...> but
was:<DEFAUL...>
 at junit.framework.Assert.assertEquals(Assert.java:81)
at junit.framework.Assert.assertEquals(Assert.java:87)
 at info.jtrac.JtracTest.testUserSpaceRolesInsert(JtracTest.java:114)

testStoreAndLoadUserWithAdminRole(info.jtrac.JtracTest)  Time elapsed: 0.172
sec  <<< FAILURE!
junit.framework.AssertionFailedError
at junit.framework.Assert.fail(Assert.java:47)
at junit.framework.Assert.assertTrue(Assert.java:20)
 at junit.framework.Assert.assertTrue(Assert.java:27)
at
info.jtrac.JtracTest.testStoreAndLoadUserWithAdminRole(JtracTest.java:151)

testItemInsertAndCounts(info.jtrac.JtracTest)  Time elapsed: 0.234 sec  <<<
ERROR!
org.springframework.dao.DataIntegrityViolationException: Could not execute
JDBC batch update; nested exception is
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC
batch update
 at
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:622)
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.execute(HibernateTemplate.java:338)
 at
info.jtrac.hibernate.HibernateJtracDao.loadNextSequenceNum(HibernateJtracDao.java:220)
at info.jtrac.JtracImpl.storeItem(JtracImpl.java:259)
 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.storeItem(Unknown Source)
at info.jtrac.JtracTest.testItemInsertAndCounts(JtracTest.java:177)
Caused by: org.hibernate.exception.ConstraintViolationException: Could not
execute JDBC batch update
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
 at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
 at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
 at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224)
 at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
 at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
 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.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1238)
at $Proxy3.flush(Unknown Source)
 at
info.jtrac.hibernate.HibernateJtracDao$5.doInHibernate(HibernateJtracDao.java:222)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373)
 ... 42 more
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint
(JTRAC.SYS_C00296270) violated

at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:459)
 at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3907)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
 at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
 ... 62 more

testRemoveSpaceRoleDoesNotOrphanDatabaseRecord(info.jtrac.JtracTest)  Time
elapsed: 0.11 sec  <<< ERROR!
org.springframework.dao.EmptyResultDataAccessException: Incorrect result
size: expected 1, actual 0
at
org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessUtils.java:71)
 at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:450)
at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:454)
 at
org.springframework.jdbc.core.JdbcTemplate.queryForLong(JdbcTemplate.java:458)
at
info.jtrac.JtracTest.testRemoveSpaceRoleDoesNotOrphanDatabaseRecord(JtracTest.java:199)

testFindSpacesWhereGuestAllowed(info.jtrac.JtracTest)  Time elapsed: 0.062
sec  <<< FAILURE!
junit.framework.AssertionFailedError: expected:<1> but was:<0>
at junit.framework.Assert.fail(Assert.java:47)
 at junit.framework.Assert.failNotEquals(Assert.java:282)
at junit.framework.Assert.assertEquals(Assert.java:64)
 at junit.framework.Assert.assertEquals(Assert.java:201)
at junit.framework.Assert.assertEquals(Assert.java:207)
 at info.jtrac.JtracTest.testFindSpacesWhereGuestAllowed(JtracTest.java:213)

testRenameSpaceRole(info.jtrac.JtracTest)  Time elapsed: 0.141 sec  <<<
FAILURE!
junit.framework.AssertionFailedError: expected:<0> but was:<1>
at junit.framework.Assert.fail(Assert.java:47)
at junit.framework.Assert.failNotEquals(Assert.java:282)
 at junit.framework.Assert.assertEquals(Assert.java:64)
at junit.framework.Assert.assertEquals(Assert.java:201)
 at junit.framework.Assert.assertEquals(Assert.java:207)
at info.jtrac.JtracTest.testRenameSpaceRole(JtracTest.java:225)

testGetItemAsHtmlDoesNotThrowException(info.jtrac.JtracTest)  Time elapsed:
0.14 sec  <<< ERROR!
org.springframework.dao.DataIntegrityViolationException: Could not execute
JDBC batch update; nested exception is
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC
batch update
 at
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:622)
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.execute(HibernateTemplate.java:338)
 at
info.jtrac.hibernate.HibernateJtracDao.loadNextSequenceNum(HibernateJtracDao.java:220)
at info.jtrac.JtracImpl.storeItem(JtracImpl.java:259)
 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.storeItem(Unknown Source)
at
info.jtrac.JtracTest.testGetItemAsHtmlDoesNotThrowException(JtracTest.java:247)
Caused by: org.hibernate.exception.ConstraintViolationException: Could not
execute JDBC batch update
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
 at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
 at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
 at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224)
 at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
 at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
 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.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1238)
at $Proxy3.flush(Unknown Source)
 at
info.jtrac.hibernate.HibernateJtracDao$5.doInHibernate(HibernateJtracDao.java:222)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373)
 ... 42 more
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint
(JTRAC.SYS_C00296270) violated

at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:459)
 at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3907)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
 at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
 ... 62 more

testDeleteItemThatHasRelatedItems(info.jtrac.JtracTest)  Time elapsed: 0.094
sec  <<< ERROR!
org.springframework.dao.DataIntegrityViolationException: Could not execute
JDBC batch update; nested exception is
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC
batch update
 at
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:622)
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.execute(HibernateTemplate.java:338)
 at
info.jtrac.hibernate.HibernateJtracDao.loadNextSequenceNum(HibernateJtracDao.java:220)
at info.jtrac.JtracImpl.storeItem(JtracImpl.java:259)
 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.storeItem(Unknown Source)
at
info.jtrac.JtracTest.testDeleteItemThatHasRelatedItems(JtracTest.java:266)
Caused by: org.hibernate.exception.ConstraintViolationException: Could not
execute JDBC batch update
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
 at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
 at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
 at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224)
 at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
 at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
 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.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1238)
at $Proxy3.flush(Unknown Source)
 at
info.jtrac.hibernate.HibernateJtracDao$5.doInHibernate(HibernateJtracDao.java:222)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373)
 ... 42 more
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint
(JTRAC.SYS_C00296270) violated

at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:459)
 at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3907)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
 at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
 ... 62 more

testDeletingUserDeletesItemUsersAlso(info.jtrac.JtracTest)  Time elapsed:
0.14 sec  <<< ERROR!
org.springframework.dao.DataIntegrityViolationException: Could not execute
JDBC batch update; nested exception is
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC
batch update
 at
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:622)
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.execute(HibernateTemplate.java:338)
 at
info.jtrac.hibernate.HibernateJtracDao.loadNextSequenceNum(HibernateJtracDao.java:220)
at info.jtrac.JtracImpl.storeItem(JtracImpl.java:259)
 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.storeItem(Unknown Source)
at
info.jtrac.JtracTest.testDeletingUserDeletesItemUsersAlso(JtracTest.java:315)
Caused by: org.hibernate.exception.ConstraintViolationException: Could not
execute JDBC batch update
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
 at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
 at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
 at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224)
 at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
 at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
 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.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1238)
at $Proxy3.flush(Unknown Source)
 at
info.jtrac.hibernate.HibernateJtracDao$5.doInHibernate(HibernateJtracDao.java:222)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373)
 ... 42 more
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint
(JTRAC.SYS_C00296270) violated

at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:459)
 at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3907)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
 at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
 ... 62 more

testLogicToFindNotUsersAndSpacesNotAllocated(info.jtrac.JtracTest)  Time
elapsed: 0.266 sec  <<< FAILURE!
junit.framework.AssertionFailedError: expected:<2> but was:<0>
at junit.framework.Assert.fail(Assert.java:47)
at junit.framework.Assert.failNotEquals(Assert.java:282)
 at junit.framework.Assert.assertEquals(Assert.java:64)
at junit.framework.Assert.assertEquals(Assert.java:201)
 at junit.framework.Assert.assertEquals(Assert.java:207)
at
info.jtrac.JtracTest.testLogicToFindNotUsersAndSpacesNotAllocated(JtracTest.java:356)

testFindSuperUsers(info.jtrac.JtracTest)  Time elapsed: 0.078 sec  <<<
FAILURE!
junit.framework.AssertionFailedError: expected:<2> but was:<1>
at junit.framework.Assert.fail(Assert.java:47)
 at junit.framework.Assert.failNotEquals(Assert.java:282)
at junit.framework.Assert.assertEquals(Assert.java:64)
 at junit.framework.Assert.assertEquals(Assert.java:201)
at junit.framework.Assert.assertEquals(Assert.java:207)
 at info.jtrac.JtracTest.testFindSuperUsers(JtracTest.java:398)

testLoadSpaceRolesMapForUser(info.jtrac.JtracTest)  Time elapsed: 0.063 sec
 <<< FAILURE!
junit.framework.AssertionFailedError: expected:<1> but was:<0>
at junit.framework.Assert.fail(Assert.java:47)
at junit.framework.Assert.failNotEquals(Assert.java:282)
 at junit.framework.Assert.assertEquals(Assert.java:64)
at junit.framework.Assert.assertEquals(Assert.java:201)
 at junit.framework.Assert.assertEquals(Assert.java:207)
at info.jtrac.JtracTest.testLoadSpaceRolesMapForUser(JtracTest.java:411)

end of target\surefire-reports\info.jtrac.JtracTest.txt

---------- Forwarded message ----------
From: Иван Сердюков <ene...@gm...>
Date: 2010/9/20
Subject: jtrac + oracle
To: JTrac users mailing-list <j-t...@li...>


hi all !
have anyone configure jtrac with oracle db ; could you plese advise me ?
i tried this way :
1 ) hard code HB properties
in src\main\java\info\jtrac\config\JtracConfigurer.java - i can't find how
to set it through outer config file.. :(
2 ) tune MVN and POM for ORACLE JDBC - works good
3 ) prepare new schema for jtrac with grants and use it in 1)
4 ) during `mvn install`  task I got TEST fail for Test set:
info.jtrac.JtracTest (other test set passed).
Errors start from

testLoadSpaceRolesMapForUser(info.jtrac.JtracTest)  Time elapsed: 0.063 sec
 <<< FAILURE!
junit.framework.AssertionFailedError: expected:<1> but was:<0>
at junit.framework.Assert.assertEquals...
at info.jtrac.JtracTest.testLoadSpaceRolesMapForUser(JtracTest.java:411)


Do you know whats wrong ?

thanks,
Ivan S.

P.S. with HSQLDB tests works fine.

[jtrac-users] jtrac + oracle

[Иван С. <ene...@gm...>]

hi all !
have anyone configure jtrac with oracle db ; could you plese advise me ?
i tried this way :
1 ) hard code HB properties
in src\main\java\info\jtrac\config\JtracConfigurer.java - i can't find how
to set it through outer config file.. :(
2 ) tune MVN and POM for ORACLE JDBC - works good
3 ) prepare new schema for jtrac with grants and use it in 1)
4 ) during `mvn install`  task I got TEST fail for Test set:
info.jtrac.JtracTest (other test set passed).
Errors start from

testLoadSpaceRolesMapForUser(info.jtrac.JtracTest)  Time elapsed: 0.063 sec
 <<< FAILURE!
junit.framework.AssertionFailedError: expected:<1> but was:<0>
at junit.framework.Assert.assertEquals...
at info.jtrac.JtracTest.testLoadSpaceRolesMapForUser(JtracTest.java:411)


Do you know whats wrong ?

thanks,
Ivan S.

P.S. with HSQLDB tests works fine.

Re: [jtrac-users] Remove

[Francis De B. <fra...@gm...>]

try this: https://lists.sourceforge.net/lists/listinfo/j-trac-users

<https://lists.sourceforge.net/lists/listinfo/j-trac-users>(as indicated
under each group post)

On Fri, Sep 17, 2010 at 7:27 AM, Luke McLean <luk...@bo...>wrote:

>  Remove
>
>
> ------------------------------------------------------------------------------
> Start uncovering the many advantages of virtual appliances
> and start using them to simplify application deployment and
> accelerate your shift to cloud computing.
> http://p.sf.net/sfu/novell-sfdev2dev
> _______________________________________________
> j-trac-users mailing list
> j-t...@li...
> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>



-- 
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.

[jtrac-users] Remove

[Luke M. <luk...@bo...>]

  Remove

[jtrac-users] Please remove me from the mailing list. Thanks!

[BalaKishore P. <bpa...@ya...>]

"Peace is found not in what surrounds us, but in what we hold within."


      

[jtrac-users] Wolfgang Toepfer ist außer Haus.

[<wol...@pt...>]

Ich werde ab dem 06.09.2010 nicht im Büro sein. Ich kehre zurück am
27.09.2010.
I will be out of the office from 06.09.2010. I will be returning on
27.09.2010.

Ich werde Ihre Nachricht nach meiner Rückkehr beantworten.



**********************************************************************
http://www.pta.de
Mit 1957 Erfahrungsberichten aus 41 Jahren erfolgreicher Projektarbeit!
**********************************************************************


PTA Programmier-Technische Arbeiten GmbH
Seckenheimer Str. 65-67, 68165 Mannheim
Amtsgericht Mannheim, HRB 1139
USt-IdNr.: DE 143 839 368
Geschaeftsfuehrer:
Dipl.-Ing. Peter Fischer
Dr. Harald W. Busch
Dipl.-Kfm. Knut Fischer

Re: [jtrac-users] run jtrac v2.2.0 (my)fail

[Иван С. <ene...@gm...>]

I test it ,
looks like all works fine now in "out from box" mode !

Ivan S.

16 сентября 2010 г. 15:54 пользователь Иван Сердюков
<ene...@gm...>написал:

> Peter ,
> now it possible to build the target/jtrac.zip with start.bat and start.jar
> i think it have to work ...
> but I cant test it because my sart.jar is just a message "Direct access to
> Internet not allowed..."
> I'll test it just fix this my problem... (I've proxy settings for mvn and I
> dont know why such problem appears, well... forget)
>
> best regards !
> Ivan S.
>
> 16 сентября 2010 г. 15:02 пользователь Peter Thomas <ptr...@gm...>написал:
>
> sorry, one more change, to the "war-exploded" macro:
>>
>> ====
>>
>>    <macrodef name="war-exploded">
>>        <attribute name="deployDir" default="target/${war.name}"/>
>>        <sequential>
>>            <copy todir="@{deployDir}">
>>                <fileset dir="src/main/webapp"/>
>>            </copy>
>>            <copy todir="@{deployDir}/WEB-INF/classes">
>>                <fileset dir="target/classes"/>
>>            </copy>
>>            <copy todir="@{deployDir}/WEB-INF/lib" flatten="true">
>>                <fileset refid="runtime.fileset"/>
>>            </copy>
>>        </sequential>
>>    </macrodef>
>>
>> ====
>>
>> 2010/9/16 Peter Thomas <ptr...@gm...>:
>> > you are right, there is a typo in build.xml after we "maven-ized" it.
>> > please replace the existing "jetty-setup" target with the following:
>> >
>> > (@Manfred if you are seeing this message, please go ahead and commit
>> > this change to SVN, it may take me a while to set up my new env)
>> >
>> > ====
>> >
>> >    <target name="jetty-setup" depends="war-exploded"
>> > xmlns:artifact="urn:maven-artifact-ant">
>> >        <artifact:dependencies filesetId="jetty-fileset">
>> >            <dependency groupId="org.mortbay.jetty" artifactId="jetty"
>> > version="6.1.1"/>
>> >        </artifact:dependencies>
>> >        <artifact:dependencies filesetId="jetty-start">
>> >            <dependency groupId="org.mortbay.jetty" artifactId="start"
>> > version="6.1.1"/>
>> >        </artifact:dependencies>
>> >        <copy todir="target/jetty/lib" flatten="true">
>> >            <fileset refid="jetty-fileset"/>
>> >        </copy>
>> >        <copy todir="target/jetty" flatten="true">
>> >            <fileset refid="jetty-start"/>
>> >            <mapper type="merge" to="start.jar"/>
>> >        </copy>
>> >        <copy todir="target/jetty/etc">
>> >            <fileset dir="etc">
>> >                <include name="jetty.xml"/>
>> >                <include name="wrapper.conf"/>
>> >                <include name="webdefault.xml"/>
>> >            </fileset>
>> >        </copy>
>> >        <mkdir dir="target/jetty/logs"/>
>> >        <mkdir dir="target/jetty/work"/>
>> >        <antcall target="jetty-setup-dev"/>
>> >    </target>
>> >
>> > ====
>> >
>> > let me know how it goes.
>> >
>> > On Thu, Sep 16, 2010 at 3:51 PM, Иван Сердюков <ene...@gm...>
>> wrote:
>> >> Peter ,
>> >> ant dist-jtrac :
>> >> . . .
>> >>
>> >> BUILD FAILED
>> >> C:\home\dev\jtrac\dnl4\jtrac\build.xml:76: The following error occurred
>> >> while executing this line:
>> >> C:\home\dev\jtrac\dnl4\jtrac\build.xml:93:
>> >> C:\home\dev\jtrac\dnl4\jtrac\${m2.repo} does not exist.
>> >>
>> >> looks like we shoud fix ${m2.repo} by ${maven.repo.local} in build.xml
>> >> or something wrong , have no idea yet
>> >> Iv
>> >>
>> >> 2010/9/16 Peter Thomas <ptr...@gm...>
>> >>>
>> >>> On Thu, Sep 16, 2010 at 2:39 PM, Иван Сердюков <ene...@gm...>
>> >>> wrote:
>> >>> > Hi all !
>> >>> > I've just build (mvn install -> target/jtrac.war) jtrac from svn
>> trunc (
>> >>> > v.2.2.0 ) .
>> >>> > tried run it myself:
>> >>> > 1-st way :
>> >>> >
>> >>> > deploy jtrac.war in autodeploy of glassfish 2.2.1 (is almost the
>> >>> > tomcat);
>> >>> > when connect to http://myhos:portnum/jtrac I get error
>> >>> > HTTP Status 503
>> >>> > The requested service () is not currently available.
>> >>> > should I run hsqldb before use jtrac ?
>> >>> >
>> >>> > 2-nd way
>> >>> >
>> >>> > How to run jtrac (just builded) "out from box" ( use jetty and other
>> >>> > defauld
>> >>> > settings ) ?
>> >>> > I've note that /etc/start.bat won't work and there is no start.jar
>> at
>> >>> > all
>> >>> >
>> >>> > could you please help me run it ? any advise are welcome )
>> >>>
>> >>> try running the "dist-jtrac" ant target.  this will create
>> >>> target/jtrac.zip - which includes start.bat in the right place and
>> >>> HSQLDB configured correctly
>> >>>
>> >>> Refer the install guide for how to just use the WAR:
>> >>>
>> >>> http://www.jtrac.info/doc/html/installation.html
>> >>>
>> >>> by default it will try to use your "user home" directory and you could
>> >>> have problems if the folder does not exist or you don't have
>> >>> permissions to write to the file system or something like that.
>> >>>
>> >>> > thank you !
>> >>> > Ivan S.
>> >>> >
>> >>> >
>> ------------------------------------------------------------------------------
>> >>> > Start uncovering the many advantages of virtual appliances
>> >>> > and start using them to simplify application deployment and
>> >>> > accelerate your shift to cloud computing.
>> >>> > http://p.sf.net/sfu/novell-sfdev2dev
>> >>> > _______________________________________________
>> >>> > j-trac-users mailing list
>> >>> > j-t...@li...
>> >>> > https://lists.sourceforge.net/lists/listinfo/j-trac-users
>> >>> >
>> >>> >
>> >>>
>> >>>
>> >>>
>> ------------------------------------------------------------------------------
>> >>> Start uncovering the many advantages of virtual appliances
>> >>> and start using them to simplify application deployment and
>> >>> accelerate your shift to cloud computing.
>> >>> http://p.sf.net/sfu/novell-sfdev2dev
>> >>> _______________________________________________
>> >>> j-trac-users mailing list
>> >>> j-t...@li...
>> >>> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>> >>
>> >>
>> >>
>> ------------------------------------------------------------------------------
>> >> Start uncovering the many advantages of virtual appliances
>> >> and start using them to simplify application deployment and
>> >> accelerate your shift to cloud computing.
>> >> http://p.sf.net/sfu/novell-sfdev2dev
>> >> _______________________________________________
>> >> j-trac-users mailing list
>> >> j-t...@li...
>> >> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>> >>
>> >>
>> >
>>
>>
>> ------------------------------------------------------------------------------
>> Start uncovering the many advantages of virtual appliances
>> and start using them to simplify application deployment and
>> accelerate your shift to cloud computing.
>> http://p.sf.net/sfu/novell-sfdev2dev
>> _______________________________________________
>> j-trac-users mailing list
>> j-t...@li...
>> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>>
>
>

Re: [jtrac-users] run jtrac v2.2.0 (my)fail

[Manfred W. <wo...@ma...>]

Hi Peter. Hi all.

I will check it in and test it tomorrow, no problem. In additional I will offer a 2.2.0-Beta in the download section this weekend.

Ragards

Manfred

----- original Nachricht --------

Betreff: Re: [jtrac-users] run jtrac v2.2.0 (my)fail
Gesendet: Do, 16. Sep 2010
Von: Peter Thomas<ptr...@gm...>

> you are right, there is a typo in build.xml after we "maven-ized" it.
> please replace the existing "jetty-setup" target with the following:
> 
> (@Manfred if you are seeing this message, please go ahead and commit
> this change to SVN, it may take me a while to set up my new env)
> 
> ====
> 
>     <target name="jetty-setup" depends="war-exploded"
> xmlns:artifact="urn:maven-artifact-ant">
>         <artifact:dependencies filesetId="jetty-fileset">
>             <dependency groupId="org.mortbay.jetty" artifactId="jetty"
> version="6.1.1"/>
>         </artifact:dependencies>
>         <artifact:dependencies filesetId="jetty-start">
>             <dependency groupId="org.mortbay.jetty" artifactId="start"
> version="6.1.1"/>
>         </artifact:dependencies>
>         <copy todir="target/jetty/lib" flatten="true">
>             <fileset refid="jetty-fileset"/>
>         </copy>
>         <copy todir="target/jetty" flatten="true">
>             <fileset refid="jetty-start"/>
>             <mapper type="merge" to="start.jar"/>
>         </copy>
>         <copy todir="target/jetty/etc">
>             <fileset dir="etc">
>                 <include name="jetty.xml"/>
>                 <include name="wrapper.conf"/>
>                 <include name="webdefault.xml"/>
>             </fileset>
>         </copy>
>         <mkdir dir="target/jetty/logs"/>
>         <mkdir dir="target/jetty/work"/>
>         <antcall target="jetty-setup-dev"/>
>     </target>
> 
> ====
> 
> let me know how it goes.
> 
> On Thu, Sep 16, 2010 at 3:51 PM, é×ÁÎ óÅÒÄÀËÏ× <ene...@gm...> wrote:
> > Peter ,
> > ant dist-jtrac :
> > . . .
> >
> > BUILD FAILED
> > C:\home\dev\jtrac\dnl4\jtrac\build.xml:76: The following error occurred
> > while executing this line:
> > C:\home\dev\jtrac\dnl4\jtrac\build.xml:93:
> > C:\home\dev\jtrac\dnl4\jtrac\${m2.repo} does not exist.
> >
> > looks like we shoud fix ${m2.repo} by ${maven.repo.local} in build.xml
> > or something wrong , have no idea yet
> > Iv
> >
> > 2010/9/16 Peter Thomas <ptr...@gm...>
> >>
> >> On Thu, Sep 16, 2010 at 2:39 PM, é×ÁÎ óÅÒÄÀËÏ× <ene...@gm...>
> >> wrote:
> >> > Hi all !
> >> > I've just build (mvn install -> target/jtrac.war) jtrac from svn trunc
> (
> >> > v.2.2.0 ) .
> >> > tried run it myself:
> >> > 1-st way :
> >> >
> >> > deploy jtrac.war in autodeploy ofšglassfish 2.2.1 (is almost the
> >> > tomcat);
> >> > when connect to http://myhos:portnum/jtrac I get error
> >> > HTTP Status 503
> >> > The requested service () is not currently available.
> >> > should I run hsqldb before use jtrac ?
> >> >
> >> > 2-nd way
> >> >
> >> > How to run jtrac (just builded) "out from box" ( use jetty and other
> >> > defauld
> >> > settings ) ?
> >> > I've note thatš/etc/start.bat won't work andšthere is no start.jar at
> >> > all
> >> >
> >> > could you please help me run it ? any advise are welcome )
> >>
> >> try running the "dist-jtrac" ant target. šthis will create
> >> target/jtrac.zip - which includes start.bat in the right place and
> >> HSQLDB configured correctly
> >>
> >> Refer the install guide for how to just use the WAR:
> >>
> >> http://www.jtrac.info/doc/html/installation.html
> >>
> >> by default it will try to use your "user home" directory and you could
> >> have problems if the folder does not exist or you don't have
> >> permissions to write to the file system or something like that.
> >>
> >> > thank you !
> >> > Ivan S.
> >> >
> >> >
> ----------------------------------------------------------------------------
> --
> >> > Start uncovering the many advantages of virtual appliances
> >> > and start using them to simplify application deployment and
> >> > accelerate your shift to cloud computing.
> >> > http://p.sf.net/sfu/novell-sfdev2dev
> >> > _______________________________________________
> >> > j-trac-users mailing list
> >> > j-t...@li...
> >> > https://lists.sourceforge.net/lists/listinfo/j-trac-users
> >> >
> >> >
> >>
> >>
> >>
> ----------------------------------------------------------------------------
> --
> >> Start uncovering the many advantages of virtual appliances
> >> and start using them to simplify application deployment and
> >> accelerate your shift to cloud computing.
> >> http://p.sf.net/sfu/novell-sfdev2dev
> >> _______________________________________________
> >> j-trac-users mailing list
> >> j-t...@li...
> >> https://lists.sourceforge.net/lists/listinfo/j-trac-users
> >
> >
> >
> ----------------------------------------------------------------------------
> --
> > Start uncovering the many advantages of virtual appliances
> > and start using them to simplify application deployment and
> > accelerate your shift to cloud computing.
> > http://p.sf.net/sfu/novell-sfdev2dev
> > _______________________________________________
> > j-trac-users mailing list
> > j-t...@li...
> > https://lists.sourceforge.net/lists/listinfo/j-trac-users
> >
> >
> 
> ----------------------------------------------------------------------------
> --
> Start uncovering the many advantages of virtual appliances
> and start using them to simplify application deployment and
> accelerate your shift to cloud computing.
> http://p.sf.net/sfu/novell-sfdev2dev
> _______________________________________________
> j-trac-users mailing list
> j-t...@li...
> https://lists.sourceforge.net/lists/listinfo/j-trac-users
> 

--- original Nachricht Ende ----

Re: [jtrac-users] run jtrac v2.2.0 (my)fail

[Иван С. <ene...@gm...>]

Peter ,
now it possible to build the target/jtrac.zip with start.bat and start.jar
i think it have to work ...
but I cant test it because my sart.jar is just a message "Direct access to
Internet not allowed..."
I'll test it just fix this my problem... (I've proxy settings for mvn and I
dont know why such problem appears, well... forget)

best regards !
Ivan S.

16 сентября 2010 г. 15:02 пользователь Peter Thomas
<ptr...@gm...>написал:

> sorry, one more change, to the "war-exploded" macro:
>
> ====
>
>    <macrodef name="war-exploded">
>        <attribute name="deployDir" default="target/${war.name}"/>
>        <sequential>
>            <copy todir="@{deployDir}">
>                <fileset dir="src/main/webapp"/>
>            </copy>
>            <copy todir="@{deployDir}/WEB-INF/classes">
>                <fileset dir="target/classes"/>
>            </copy>
>            <copy todir="@{deployDir}/WEB-INF/lib" flatten="true">
>                <fileset refid="runtime.fileset"/>
>            </copy>
>        </sequential>
>    </macrodef>
>
> ====
>
> 2010/9/16 Peter Thomas <ptr...@gm...>:
> > you are right, there is a typo in build.xml after we "maven-ized" it.
> > please replace the existing "jetty-setup" target with the following:
> >
> > (@Manfred if you are seeing this message, please go ahead and commit
> > this change to SVN, it may take me a while to set up my new env)
> >
> > ====
> >
> >    <target name="jetty-setup" depends="war-exploded"
> > xmlns:artifact="urn:maven-artifact-ant">
> >        <artifact:dependencies filesetId="jetty-fileset">
> >            <dependency groupId="org.mortbay.jetty" artifactId="jetty"
> > version="6.1.1"/>
> >        </artifact:dependencies>
> >        <artifact:dependencies filesetId="jetty-start">
> >            <dependency groupId="org.mortbay.jetty" artifactId="start"
> > version="6.1.1"/>
> >        </artifact:dependencies>
> >        <copy todir="target/jetty/lib" flatten="true">
> >            <fileset refid="jetty-fileset"/>
> >        </copy>
> >        <copy todir="target/jetty" flatten="true">
> >            <fileset refid="jetty-start"/>
> >            <mapper type="merge" to="start.jar"/>
> >        </copy>
> >        <copy todir="target/jetty/etc">
> >            <fileset dir="etc">
> >                <include name="jetty.xml"/>
> >                <include name="wrapper.conf"/>
> >                <include name="webdefault.xml"/>
> >            </fileset>
> >        </copy>
> >        <mkdir dir="target/jetty/logs"/>
> >        <mkdir dir="target/jetty/work"/>
> >        <antcall target="jetty-setup-dev"/>
> >    </target>
> >
> > ====
> >
> > let me know how it goes.
> >
> > On Thu, Sep 16, 2010 at 3:51 PM, Иван Сердюков <ene...@gm...>
> wrote:
> >> Peter ,
> >> ant dist-jtrac :
> >> . . .
> >>
> >> BUILD FAILED
> >> C:\home\dev\jtrac\dnl4\jtrac\build.xml:76: The following error occurred
> >> while executing this line:
> >> C:\home\dev\jtrac\dnl4\jtrac\build.xml:93:
> >> C:\home\dev\jtrac\dnl4\jtrac\${m2.repo} does not exist.
> >>
> >> looks like we shoud fix ${m2.repo} by ${maven.repo.local} in build.xml
> >> or something wrong , have no idea yet
> >> Iv
> >>
> >> 2010/9/16 Peter Thomas <ptr...@gm...>
> >>>
> >>> On Thu, Sep 16, 2010 at 2:39 PM, Иван Сердюков <ene...@gm...>
> >>> wrote:
> >>> > Hi all !
> >>> > I've just build (mvn install -> target/jtrac.war) jtrac from svn
> trunc (
> >>> > v.2.2.0 ) .
> >>> > tried run it myself:
> >>> > 1-st way :
> >>> >
> >>> > deploy jtrac.war in autodeploy of glassfish 2.2.1 (is almost the
> >>> > tomcat);
> >>> > when connect to http://myhos:portnum/jtrac I get error
> >>> > HTTP Status 503
> >>> > The requested service () is not currently available.
> >>> > should I run hsqldb before use jtrac ?
> >>> >
> >>> > 2-nd way
> >>> >
> >>> > How to run jtrac (just builded) "out from box" ( use jetty and other
> >>> > defauld
> >>> > settings ) ?
> >>> > I've note that /etc/start.bat won't work and there is no start.jar at
> >>> > all
> >>> >
> >>> > could you please help me run it ? any advise are welcome )
> >>>
> >>> try running the "dist-jtrac" ant target.  this will create
> >>> target/jtrac.zip - which includes start.bat in the right place and
> >>> HSQLDB configured correctly
> >>>
> >>> Refer the install guide for how to just use the WAR:
> >>>
> >>> http://www.jtrac.info/doc/html/installation.html
> >>>
> >>> by default it will try to use your "user home" directory and you could
> >>> have problems if the folder does not exist or you don't have
> >>> permissions to write to the file system or something like that.
> >>>
> >>> > thank you !
> >>> > Ivan S.
> >>> >
> >>> >
> ------------------------------------------------------------------------------
> >>> > Start uncovering the many advantages of virtual appliances
> >>> > and start using them to simplify application deployment and
> >>> > accelerate your shift to cloud computing.
> >>> > http://p.sf.net/sfu/novell-sfdev2dev
> >>> > _______________________________________________
> >>> > j-trac-users mailing list
> >>> > j-t...@li...
> >>> > https://lists.sourceforge.net/lists/listinfo/j-trac-users
> >>> >
> >>> >
> >>>
> >>>
> >>>
> ------------------------------------------------------------------------------
> >>> Start uncovering the many advantages of virtual appliances
> >>> and start using them to simplify application deployment and
> >>> accelerate your shift to cloud computing.
> >>> http://p.sf.net/sfu/novell-sfdev2dev
> >>> _______________________________________________
> >>> j-trac-users mailing list
> >>> j-t...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/j-trac-users
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> Start uncovering the many advantages of virtual appliances
> >> and start using them to simplify application deployment and
> >> accelerate your shift to cloud computing.
> >> http://p.sf.net/sfu/novell-sfdev2dev
> >> _______________________________________________
> >> j-trac-users mailing list
> >> j-t...@li...
> >> https://lists.sourceforge.net/lists/listinfo/j-trac-users
> >>
> >>
> >
>
>
> ------------------------------------------------------------------------------
> Start uncovering the many advantages of virtual appliances
> and start using them to simplify application deployment and
> accelerate your shift to cloud computing.
> http://p.sf.net/sfu/novell-sfdev2dev
> _______________________________________________
> j-trac-users mailing list
> j-t...@li...
> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>

Re: [jtrac-users] run jtrac v2.2.0 (my)fail

[Peter T. <ptr...@gm...>]

sorry, one more change, to the "war-exploded" macro:

====

    <macrodef name="war-exploded">
        <attribute name="deployDir" default="target/${war.name}"/>
        <sequential>
            <copy todir="@{deployDir}">
                <fileset dir="src/main/webapp"/>
            </copy>
            <copy todir="@{deployDir}/WEB-INF/classes">
                <fileset dir="target/classes"/>
            </copy>
            <copy todir="@{deployDir}/WEB-INF/lib" flatten="true">
                <fileset refid="runtime.fileset"/>
            </copy>
        </sequential>
    </macrodef>

====

2010/9/16 Peter Thomas <ptr...@gm...>:
> you are right, there is a typo in build.xml after we "maven-ized" it.
> please replace the existing "jetty-setup" target with the following:
>
> (@Manfred if you are seeing this message, please go ahead and commit
> this change to SVN, it may take me a while to set up my new env)
>
> ====
>
>    <target name="jetty-setup" depends="war-exploded"
> xmlns:artifact="urn:maven-artifact-ant">
>        <artifact:dependencies filesetId="jetty-fileset">
>            <dependency groupId="org.mortbay.jetty" artifactId="jetty"
> version="6.1.1"/>
>        </artifact:dependencies>
>        <artifact:dependencies filesetId="jetty-start">
>            <dependency groupId="org.mortbay.jetty" artifactId="start"
> version="6.1.1"/>
>        </artifact:dependencies>
>        <copy todir="target/jetty/lib" flatten="true">
>            <fileset refid="jetty-fileset"/>
>        </copy>
>        <copy todir="target/jetty" flatten="true">
>            <fileset refid="jetty-start"/>
>            <mapper type="merge" to="start.jar"/>
>        </copy>
>        <copy todir="target/jetty/etc">
>            <fileset dir="etc">
>                <include name="jetty.xml"/>
>                <include name="wrapper.conf"/>
>                <include name="webdefault.xml"/>
>            </fileset>
>        </copy>
>        <mkdir dir="target/jetty/logs"/>
>        <mkdir dir="target/jetty/work"/>
>        <antcall target="jetty-setup-dev"/>
>    </target>
>
> ====
>
> let me know how it goes.
>
> On Thu, Sep 16, 2010 at 3:51 PM, Иван Сердюков <ene...@gm...> wrote:
>> Peter ,
>> ant dist-jtrac :
>> . . .
>>
>> BUILD FAILED
>> C:\home\dev\jtrac\dnl4\jtrac\build.xml:76: The following error occurred
>> while executing this line:
>> C:\home\dev\jtrac\dnl4\jtrac\build.xml:93:
>> C:\home\dev\jtrac\dnl4\jtrac\${m2.repo} does not exist.
>>
>> looks like we shoud fix ${m2.repo} by ${maven.repo.local} in build.xml
>> or something wrong , have no idea yet
>> Iv
>>
>> 2010/9/16 Peter Thomas <ptr...@gm...>
>>>
>>> On Thu, Sep 16, 2010 at 2:39 PM, Иван Сердюков <ene...@gm...>
>>> wrote:
>>> > Hi all !
>>> > I've just build (mvn install -> target/jtrac.war) jtrac from svn trunc (
>>> > v.2.2.0 ) .
>>> > tried run it myself:
>>> > 1-st way :
>>> >
>>> > deploy jtrac.war in autodeploy of glassfish 2.2.1 (is almost the
>>> > tomcat);
>>> > when connect to http://myhos:portnum/jtrac I get error
>>> > HTTP Status 503
>>> > The requested service () is not currently available.
>>> > should I run hsqldb before use jtrac ?
>>> >
>>> > 2-nd way
>>> >
>>> > How to run jtrac (just builded) "out from box" ( use jetty and other
>>> > defauld
>>> > settings ) ?
>>> > I've note that /etc/start.bat won't work and there is no start.jar at
>>> > all
>>> >
>>> > could you please help me run it ? any advise are welcome )
>>>
>>> try running the "dist-jtrac" ant target.  this will create
>>> target/jtrac.zip - which includes start.bat in the right place and
>>> HSQLDB configured correctly
>>>
>>> Refer the install guide for how to just use the WAR:
>>>
>>> http://www.jtrac.info/doc/html/installation.html
>>>
>>> by default it will try to use your "user home" directory and you could
>>> have problems if the folder does not exist or you don't have
>>> permissions to write to the file system or something like that.
>>>
>>> > thank you !
>>> > Ivan S.
>>> >
>>> > ------------------------------------------------------------------------------
>>> > Start uncovering the many advantages of virtual appliances
>>> > and start using them to simplify application deployment and
>>> > accelerate your shift to cloud computing.
>>> > http://p.sf.net/sfu/novell-sfdev2dev
>>> > _______________________________________________
>>> > j-trac-users mailing list
>>> > j-t...@li...
>>> > https://lists.sourceforge.net/lists/listinfo/j-trac-users
>>> >
>>> >
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Start uncovering the many advantages of virtual appliances
>>> and start using them to simplify application deployment and
>>> accelerate your shift to cloud computing.
>>> http://p.sf.net/sfu/novell-sfdev2dev
>>> _______________________________________________
>>> j-trac-users mailing list
>>> j-t...@li...
>>> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>>
>>
>> ------------------------------------------------------------------------------
>> Start uncovering the many advantages of virtual appliances
>> and start using them to simplify application deployment and
>> accelerate your shift to cloud computing.
>> http://p.sf.net/sfu/novell-sfdev2dev
>> _______________________________________________
>> j-trac-users mailing list
>> j-t...@li...
>> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>>
>>
>

Re: [jtrac-users] run jtrac v2.2.0 (my)fail

[Peter T. <ptr...@gm...>]

you are right, there is a typo in build.xml after we "maven-ized" it.
please replace the existing "jetty-setup" target with the following:

(@Manfred if you are seeing this message, please go ahead and commit
this change to SVN, it may take me a while to set up my new env)

====

    <target name="jetty-setup" depends="war-exploded"
xmlns:artifact="urn:maven-artifact-ant">
        <artifact:dependencies filesetId="jetty-fileset">
            <dependency groupId="org.mortbay.jetty" artifactId="jetty"
version="6.1.1"/>
        </artifact:dependencies>
        <artifact:dependencies filesetId="jetty-start">
            <dependency groupId="org.mortbay.jetty" artifactId="start"
version="6.1.1"/>
        </artifact:dependencies>
        <copy todir="target/jetty/lib" flatten="true">
            <fileset refid="jetty-fileset"/>
        </copy>
        <copy todir="target/jetty" flatten="true">
            <fileset refid="jetty-start"/>
            <mapper type="merge" to="start.jar"/>
        </copy>
        <copy todir="target/jetty/etc">
            <fileset dir="etc">
                <include name="jetty.xml"/>
                <include name="wrapper.conf"/>
                <include name="webdefault.xml"/>
            </fileset>
        </copy>
        <mkdir dir="target/jetty/logs"/>
        <mkdir dir="target/jetty/work"/>
        <antcall target="jetty-setup-dev"/>
    </target>

====

let me know how it goes.

On Thu, Sep 16, 2010 at 3:51 PM, Иван Сердюков <ene...@gm...> wrote:
> Peter ,
> ant dist-jtrac :
> . . .
>
> BUILD FAILED
> C:\home\dev\jtrac\dnl4\jtrac\build.xml:76: The following error occurred
> while executing this line:
> C:\home\dev\jtrac\dnl4\jtrac\build.xml:93:
> C:\home\dev\jtrac\dnl4\jtrac\${m2.repo} does not exist.
>
> looks like we shoud fix ${m2.repo} by ${maven.repo.local} in build.xml
> or something wrong , have no idea yet
> Iv
>
> 2010/9/16 Peter Thomas <ptr...@gm...>
>>
>> On Thu, Sep 16, 2010 at 2:39 PM, Иван Сердюков <ene...@gm...>
>> wrote:
>> > Hi all !
>> > I've just build (mvn install -> target/jtrac.war) jtrac from svn trunc (
>> > v.2.2.0 ) .
>> > tried run it myself:
>> > 1-st way :
>> >
>> > deploy jtrac.war in autodeploy of glassfish 2.2.1 (is almost the
>> > tomcat);
>> > when connect to http://myhos:portnum/jtrac I get error
>> > HTTP Status 503
>> > The requested service () is not currently available.
>> > should I run hsqldb before use jtrac ?
>> >
>> > 2-nd way
>> >
>> > How to run jtrac (just builded) "out from box" ( use jetty and other
>> > defauld
>> > settings ) ?
>> > I've note that /etc/start.bat won't work and there is no start.jar at
>> > all
>> >
>> > could you please help me run it ? any advise are welcome )
>>
>> try running the "dist-jtrac" ant target.  this will create
>> target/jtrac.zip - which includes start.bat in the right place and
>> HSQLDB configured correctly
>>
>> Refer the install guide for how to just use the WAR:
>>
>> http://www.jtrac.info/doc/html/installation.html
>>
>> by default it will try to use your "user home" directory and you could
>> have problems if the folder does not exist or you don't have
>> permissions to write to the file system or something like that.
>>
>> > thank you !
>> > Ivan S.
>> >
>> > ------------------------------------------------------------------------------
>> > Start uncovering the many advantages of virtual appliances
>> > and start using them to simplify application deployment and
>> > accelerate your shift to cloud computing.
>> > http://p.sf.net/sfu/novell-sfdev2dev
>> > _______________________________________________
>> > j-trac-users mailing list
>> > j-t...@li...
>> > https://lists.sourceforge.net/lists/listinfo/j-trac-users
>> >
>> >
>>
>>
>> ------------------------------------------------------------------------------
>> Start uncovering the many advantages of virtual appliances
>> and start using them to simplify application deployment and
>> accelerate your shift to cloud computing.
>> http://p.sf.net/sfu/novell-sfdev2dev
>> _______________________________________________
>> j-trac-users mailing list
>> j-t...@li...
>> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>
>
> ------------------------------------------------------------------------------
> Start uncovering the many advantages of virtual appliances
> and start using them to simplify application deployment and
> accelerate your shift to cloud computing.
> http://p.sf.net/sfu/novell-sfdev2dev
> _______________________________________________
> j-trac-users mailing list
> j-t...@li...
> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>
>

Re: [jtrac-users] run jtrac v2.2.0 (my)fail

[Иван С. <ene...@gm...>]

Peter ,

ant dist-jtrac :
. . .

BUILD FAILED
C:\home\dev\jtrac\dnl4\jtrac\build.xml:76: The following error occurred
while executing this line:
C:\home\dev\jtrac\dnl4\jtrac\build.xml:93:
C:\home\dev\jtrac\dnl4\jtrac\${m2.repo} does not exist.


looks like we shoud fix ${m2.repo} by ${maven.repo.local} in build.xml
or something wrong , have no idea yet

Iv


2010/9/16 Peter Thomas <ptr...@gm...>

> On Thu, Sep 16, 2010 at 2:39 PM, Иван Сердюков <ene...@gm...>
> wrote:
> > Hi all !
> > I've just build (mvn install -> target/jtrac.war) jtrac from svn trunc (
> > v.2.2.0 ) .
> > tried run it myself:
> > 1-st way :
> >
> > deploy jtrac.war in autodeploy of glassfish 2.2.1 (is almost the tomcat);
> > when connect to http://myhos:portnum/jtrac I get error
> > HTTP Status 503
> > The requested service () is not currently available.
> > should I run hsqldb before use jtrac ?
> >
> > 2-nd way
> >
> > How to run jtrac (just builded) "out from box" ( use jetty and other
> defauld
> > settings ) ?
> > I've note that /etc/start.bat won't work and there is no start.jar at all
> >
> > could you please help me run it ? any advise are welcome )
>
> try running the "dist-jtrac" ant target.  this will create
> target/jtrac.zip - which includes start.bat in the right place and
> HSQLDB configured correctly
>
> Refer the install guide for how to just use the WAR:
>
> http://www.jtrac.info/doc/html/installation.html
>
> by default it will try to use your "user home" directory and you could
> have problems if the folder does not exist or you don't have
> permissions to write to the file system or something like that.
>
> > thank you !
> > Ivan S.
> >
> ------------------------------------------------------------------------------
> > Start uncovering the many advantages of virtual appliances
> > and start using them to simplify application deployment and
> > accelerate your shift to cloud computing.
> > http://p.sf.net/sfu/novell-sfdev2dev
> > _______________________________________________
> > j-trac-users mailing list
> > j-t...@li...
> > https://lists.sourceforge.net/lists/listinfo/j-trac-users
> >
> >
>
>
> ------------------------------------------------------------------------------
> Start uncovering the many advantages of virtual appliances
> and start using them to simplify application deployment and
> accelerate your shift to cloud computing.
> http://p.sf.net/sfu/novell-sfdev2dev
> _______________________________________________
> j-trac-users mailing list
> j-t...@li...
> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>

Re: [jtrac-users] run jtrac v2.2.0 (my)fail

[Peter T. <ptr...@gm...>]

On Thu, Sep 16, 2010 at 2:39 PM, Иван Сердюков <ene...@gm...> wrote:
> Hi all !
> I've just build (mvn install -> target/jtrac.war) jtrac from svn trunc (
> v.2.2.0 ) .
> tried run it myself:
> 1-st way :
>
> deploy jtrac.war in autodeploy of glassfish 2.2.1 (is almost the tomcat);
> when connect to http://myhos:portnum/jtrac I get error
> HTTP Status 503
> The requested service () is not currently available.
> should I run hsqldb before use jtrac ?
>
> 2-nd way
>
> How to run jtrac (just builded) "out from box" ( use jetty and other defauld
> settings ) ?
> I've note that /etc/start.bat won't work and there is no start.jar at all
>
> could you please help me run it ? any advise are welcome )

try running the "dist-jtrac" ant target.  this will create
target/jtrac.zip - which includes start.bat in the right place and
HSQLDB configured correctly

Refer the install guide for how to just use the WAR:

http://www.jtrac.info/doc/html/installation.html

by default it will try to use your "user home" directory and you could
have problems if the folder does not exist or you don't have
permissions to write to the file system or something like that.

> thank you !
> Ivan S.
> ------------------------------------------------------------------------------
> Start uncovering the many advantages of virtual appliances
> and start using them to simplify application deployment and
> accelerate your shift to cloud computing.
> http://p.sf.net/sfu/novell-sfdev2dev
> _______________________________________________
> j-trac-users mailing list
> j-t...@li...
> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>
>

[jtrac-users] run jtrac v2.2.0 (my)fail

[Иван С. <ene...@gm...>]

Hi all !

I've just build (mvn install -> target/jtrac.war) jtrac from svn trunc (
v.2.2.0 ) .
tried run it myself:
1-st way :

deploy jtrac.war in autodeploy of glassfish 2.2.1 (is almost the tomcat);
when connect to http://myhos:portnum/jtrac I get error
HTTP Status 503
The requested service () is not currently available.

should I run hsqldb before use jtrac ?


2-nd way

How to run jtrac (just builded) "out from box" ( use jetty and other defauld
settings ) ?
I've note that /etc/start.bat won't work and there is no start.jar at all


could you please help me run it ? any advise are welcome )

thank you !
Ivan S.

Re: [jtrac-users] Remote API write mode

[Manfred W. <wo...@ma...>]

Hi.

Sounds great ! I will have a look and test on it and commit it then into
the main branch.

Thanks
Manfred

JC schrieb:
> I extended Remote API to add or adjust an item.
>
> The new methods are:
> item.put
> item.put.history
>
> Method's descriptions:
> ---------------------------------------------------------------------------------------------------------------------------------------- 
>
> * http://<myserver>/jtrac/api?method=item.put&prefixCode=<space prefix 
> code>&summary=<Summary field content>&detail=<Detail field 
> content>&cusTim01=<Custom field content>&cusInt02=<Custom field 
> content>...&toUser=<Username to assign the item>&isTest=<Test indicator 
> to test the operation or to apply it, possible values are: y- it is 
> test, n- it is not test, create the item)
>
> * examples:
> * 
> http://<myserver>/jtrac/api?method=item.put&prefixCode=MYSPACE&summary=Remote+test+creation&detail=Remote+test+creation&cusTim01=2010-03-31&cusInt02=3&toUser=prthomas&isTest=y 
>
> - test if an item can be created and assigned to prthomas user in the 
> space with prefix code MYSPACE
>
> *http://<myserver>/jtrac/api?method=item.put&prefixCode=MYSPACE&summary=Remote+test+creation&detail=Remote+test+creation&cusTim01=2010-03-31&cusInt02=3&toUser=prthomas&isTest=n 
>
> - create an item and assign it to prthomas user in the space with prefix 
> code MYSPACE 
> ---------------------------------------------------------------------------------------------------------------------------------------- 
>
> * http://<myserver>/jtrac/api?method=item.put.history&refId=<item 
> id>&cusTim01=<Custom field content>&cusInt02=<Custom field 
> content>...&toStatus=<new status code>&toUser=<Username to assign the 
> item>&comment=<comment field content>&isTest=<Test indicator to test the 
> operation or to apply it, possible values are: y- it is test, n- it is 
> not test, create the item)
>
> * example:
> * 
> http://<myserver>/jtrac/api?method=item.put.history&refId=MYSPACE-1&cusTim01=2010-03-31&cusInt02=3&toStatus=2&toUser=prthomas&comment=Test+comment&isTest=y 
>
> - test if a new comment can be created for MYSPACE-1 item and if this 
> can change to status code 2 and be assigned to prthomas user
>
> *http://<myserver>/jtrac/api?method=item.put.history&refId=MYSPACE-1&cusTim01=2010-03-31&cusInt02=3&toStatus=2&toUser=prthomas&comment=Test+comment&isTest=n 
> - create a new comment for MYSPACE-1 item and change it to status code 2 
> and assigned it to prthomas user 
> *http://<myserver>/jtrac/api?method=item.put.history&refId=MYSPACE-1&comment=Test+comment&isTest=n 
>
> - create a new comment for MYSPACE-1 item
> ---------------------------------------------------------------------------------------------------------------------------------------- 
>
>
> We have to consider the following remarks in the parameters' values:
> - Date values must be in the pattern yyyy-MM-dd
> - Spaces between words must be as '+' (plus sign)
> - use the 'isTest' parameter for verifying first if the operation can be 
> done.
> - Returns XML data to show the result of the operation
>
> I attach the files modified and added in 
> https://sourceforge.net/tracker/?func=detail&aid=3054447&group_id=162983&atid=825943 
> <https://sourceforge.net/tracker/?func=detail&aid=3054447&group_id=162983&atid=825943>: 
>
> - info/jtrac/exception/JtracGenericException.java
> - info/jtrac/web/RestMultiActionController.java
>
> Juan Carlos
>
> ------------------------------------------------------------------------------
> Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
> Be part of this innovative community and reach millions of netbook users 
> worldwide. Take advantage of special opportunities to increase revenue and 
> speed time-to-market. Join now, and jumpstart your future.
> http://p.sf.net/sfu/intel-atom-d2d
> _______________________________________________
> j-trac-users mailing list
> j-t...@li...
> https://lists.sourceforge.net/lists/listinfo/j-trac-users
>
>   


-- 
===========================================
Dipl.-Inf. Manfred Wolff
Software Engineer
Fon  : +49 421 534522
Fax  : +49 421 4314578
Mobil: +49 173 2494181
-------------------------------------------
http://www.manfred-wolff.de
-------------------------------------------

[jtrac-users] Remote API write mode

[JC <jc...@gm...>]

I extended Remote API to add or adjust an item.

The new methods are:
item.put
item.put.history

Method's descriptions:
---------------------------------------------------------------------------------------------------------------------------------------- 

* http://<myserver>/jtrac/api?method=item.put&prefixCode=<space prefix 
code>&summary=<Summary field content>&detail=<Detail field 
content>&cusTim01=<Custom field content>&cusInt02=<Custom field 
content>...&toUser=<Username to assign the item>&isTest=<Test indicator 
to test the operation or to apply it, possible values are: y- it is 
test, n- it is not test, create the item)

* examples:
* 
http://<myserver>/jtrac/api?method=item.put&prefixCode=MYSPACE&summary=Remote+test+creation&detail=Remote+test+creation&cusTim01=2010-03-31&cusInt02=3&toUser=prthomas&isTest=y 

- test if an item can be created and assigned to prthomas user in the 
space with prefix code MYSPACE

*http://<myserver>/jtrac/api?method=item.put&prefixCode=MYSPACE&summary=Remote+test+creation&detail=Remote+test+creation&cusTim01=2010-03-31&cusInt02=3&toUser=prthomas&isTest=n 

- create an item and assign it to prthomas user in the space with prefix 
code MYSPACE 
---------------------------------------------------------------------------------------------------------------------------------------- 

* http://<myserver>/jtrac/api?method=item.put.history&refId=<item 
id>&cusTim01=<Custom field content>&cusInt02=<Custom field 
content>...&toStatus=<new status code>&toUser=<Username to assign the 
item>&comment=<comment field content>&isTest=<Test indicator to test the 
operation or to apply it, possible values are: y- it is test, n- it is 
not test, create the item)

* example:
* 
http://<myserver>/jtrac/api?method=item.put.history&refId=MYSPACE-1&cusTim01=2010-03-31&cusInt02=3&toStatus=2&toUser=prthomas&comment=Test+comment&isTest=y 

- test if a new comment can be created for MYSPACE-1 item and if this 
can change to status code 2 and be assigned to prthomas user

*http://<myserver>/jtrac/api?method=item.put.history&refId=MYSPACE-1&cusTim01=2010-03-31&cusInt02=3&toStatus=2&toUser=prthomas&comment=Test+comment&isTest=n 
- create a new comment for MYSPACE-1 item and change it to status code 2 
and assigned it to prthomas user 
*http://<myserver>/jtrac/api?method=item.put.history&refId=MYSPACE-1&comment=Test+comment&isTest=n 

- create a new comment for MYSPACE-1 item
---------------------------------------------------------------------------------------------------------------------------------------- 


We have to consider the following remarks in the parameters' values:
- Date values must be in the pattern yyyy-MM-dd
- Spaces between words must be as '+' (plus sign)
- use the 'isTest' parameter for verifying first if the operation can be 
done.
- Returns XML data to show the result of the operation

I attach the files modified and added in 
https://sourceforge.net/tracker/?func=detail&aid=3054447&group_id=162983&atid=825943 
<https://sourceforge.net/tracker/?func=detail&aid=3054447&group_id=162983&atid=825943>: 

- info/jtrac/exception/JtracGenericException.java
- info/jtrac/web/RestMultiActionController.java

Juan Carlos

[jtrac-users] JTrac Bug: Incorrect user being recorded for a post

[Tony H. <a.h...@du...>]

Hi Folks

I'm not sure who subscribes to what; so I wanted to alert you about a bug and
patch I have just submitted.

Summary: A user may submit a post (a new issue or update to an existing issue)
and that post may be recorded as being posted by a different user.

Bug id = 3054238
https://sourceforge.net/tracker/?func=detail&atid=825941&aid=3054238&group_
id=162983

Patch id = 3054239
https://sourceforge.net/tracker/?func=detail&atid=825943&aid=3054239&group_
id=162983

[I also created a forum post:
https://sourceforge.net/projects/j-trac/forums/forum/552477/topic/3827942 
On reflection, I should probably have just emailed this list.  Would an admin please confirm?]

Cheers
Tony

************************************************************
Please consider the environment.  Do you really need to print this email?



The University of Dundee is a registered Scottish charity, No: SC015096