*** jcater has quit IRC
*** ajmitch__ has joined #gnuenterprise
*** sjc has joined #gnuenterprise
*** sjc has quit IRC
*** SachaS has joined #gnuenterprise
<SachaS> good morning
*** ajmitch__ has quit IRC
*** bodhi has joined #gnuenterprise
<bodhi> sup all? any ops here?
<SachaS> hi bodhi
*** dimas has quit IRC
*** dcmwai has quit IRC
*** nickr has quit IRC
*** bodhi has quit IRC
*** ajmitch has quit IRC
*** Stoke has quit IRC
*** SachaS has quit IRC
*** wayneg has quit IRC
*** dneighbo has quit IRC
*** bodhi has joined #gnuenterprise
*** SachaS has joined #gnuenterprise
*** wayneg has joined #gnuenterprise
*** dneighbo has joined #gnuenterprise
*** nickr has joined #gnuenterprise
*** Stoke has joined #gnuenterprise
*** ajmitch has joined #gnuenterprise
*** bigbrother has joined #gnuenterprise
*** bigbrother^ has joined #gnuenterprise
*** mixi has quit IRC
*** havoc has quit IRC
*** chillywilly has quit IRC
*** bigbrother has quit IRC
*** Vee has quit IRC
*** Vee2d2 has quit IRC
*** nickr has quit IRC
*** bodhi has quit IRC
*** ajmitch has quit IRC
*** bodhi has joined #gnuenterprise
*** nickr has joined #gnuenterprise
*** ajmitch has joined #gnuenterprise
*** bigbrother has joined #gnuenterprise
*** havoc has joined #gnuenterprise
*** Vee has joined #gnuenterprise
*** chillywilly has joined #gnuenterprise
*** Vee2d2 has joined #gnuenterprise
*** mixi has joined #gnuenterprise
*** chillywi1ly has joined #gnuenterprise
*** bigbrother has quit IRC
*** chillywilly has quit IRC
*** dimas has joined #gnuenterprise
*** cedmo has joined #gnuenterprise
<cedmo> hello
<SachaS> hi cedmo
*** bodhi has quit IRC
*** bodhi has joined #gnuenterprise
<cedmo> SachaS: cool, i was just reading this days irc-log to see you answer. my xchat notification is off
<SachaS> ?
<cedmo> Can you give some hints about gnue
<SachaS> have to go to birthday party
<SachaS> some hints? gnue is cool ;)
<cedmo> hehe
<cedmo> 2 questions:
<SachaS> ok.
<SachaS> btw babyerp is broken for current appserver.
<SachaS> i will read the logs. have to run
<cedmo> are the erp packages usable right now, or for small businnes use with just accounting and invoicing making an own solution is the better way?
<SachaAtParty> in my opinion, no gnue erp packages useable atm
<cedmo> 2. is there a way to store binary data in datasource, for example received bills
<SachaAtParty> back later
<cedmo> ok
<cedmo> have fun
*** btami has joined #gnuenterprise
*** reinhard has joined #gnuenterprise
<reinhard> cedmo: i can try to answer your questions
<btami> hi reinhard
<btami> have you seen our last bugreport (at 2004.05.28) ?
<btami> <kilo> it works in isql, and in forms when useParameters != 1
<btami> <kilo> ie it is commented out in gnue.conf
<btami> <kilo> but it doesnt work using appserver, even if useParameters is commented out
<btami> <kilo> but it throws an other type of error, this time again boolean matters
<btami> <kilo> the sql statement is:
<btami> <kilo> UPDATE gnue_procedure SET gnue_code='try:
<btami> <kilo>     return self.__cache[kod][1]
<btami> <kilo> except:
<btami> <kilo>     return None
<btami> <kilo> #aaa',gnue_nullable=TRUE WHERE gnue_code='try:
<btami> <kilo>     return self.__cache[kod][1]
<btami> <kilo> except:
<btami> <kilo>     return None' AND gnue_id='60164400889888615052419736243989' AND gnue_nullable='1'
<btami> *** havoc has quit IRC
<btami> <kilo> gnue_nullable=TRUE, tha is problematic
<btami> just tried to save procedure modifications in classrepository.gfd
<btami> with appserver running on firebird server
<btami> the first problem was "blob in where clause"
<btami> it solved after not using useParameters=1
<btami> but this "TRUE" comes somewhere deep :)
<btami> anyhow, blobs in where clause not supportded in firebird with parametrised form :(
<btami> the traceback is:
<btami> ------------------------------------------------------------
<btami> Traceback (most recent call last):
<btami>   File "/home/tamas/svn/gnue/gnue-common/.cvsdevelbase/gnue/forms/GFForm.py", line 544, in commit
<btami>     block.processCommit()
<btami>   File "/home/tamas/svn/gnue/gnue-common/.cvsdevelbase/gnue/forms/GFObjects/GFBlock.py", line 513, in processCommit
<btami>     self._dataSourceLink._dataObject.commit()
<btami>   File "/home/tamas/svn/gnue/gnue-common/.cvsdevelbase/gnue/common/datasources/drivers/Base/DataObject.py", line 151, in commit
<btami>     self._connection.commit()
<btami>   File "/home/tamas/svn/gnue/gnue-common/.cvsdevelbase/gnue/common/datasources/drivers/appserver/appserver/Connection.py", line 100, in commit
<btami>     self._sm.commit (self._sess_id)
<btami>   File "/home/tamas/svn/gnue/gnue-common/.cvsdevelbase/gnue/common/rpc/drivers/Base.py", line 232, in __call__
<btami>     return self._adapter._runMethod (self._methodname, *args, **params)
<btami>   File "/home/tamas/svn/gnue/gnue-common/.cvsdevelbase/gnue/common/rpc/drivers/xmlrpc/pw_xmlrpc/ClientAdapter.py", line 96, in _runMethod
<btami>     raise client.DistantError, e.faultString
<btami> DistantError: (-206, 'isc_dsql_prepare: Dynamic SQL Error. SQL error code = -206. Column unknown. TRUE. At line 1, column 92.. ')
<btami> i produced this now (at home), so the column 92 doesn't match with kilo's sql, but
<reinhard> btami: hmmm. thought johannes fixed that
<reinhard> will ask him tomorrow
<btami> ok, thx
<reinhard> erm
<reinhard> does the TRUE problem also happen with useParameters=1 ?
<btami> with useParameters=1 we get "internal error" from firebird
<btami> this is another problem, look at
<btami> wait...
<btami> http://sourceforge.net/forum/forum.php?thread_id=1083782&forum_id=30917
<btami> but the last "TRUE" bug is appserver or common related, i mean
<reinhard> the question is
<btami> how the hell the UPDATE statement contains somefield=TRUE
<reinhard> if the "TRUE" bug is there when useParameters=1
<reinhard> i thought we use VARCHAR (1000) instead of blobs in interbase
<reinhard> to work around that blob problem
<reinhard> (or some other very high number)
<btami> hmm, i'v changed blob to varchar (32000) and used useParameters=1 and it's ok!
<reinhard> ok
<reinhard> useParameters=1 is expected to become the default in next release
<reinhard> and expected to phase out afterwards
<reinhard> because of exactly those problems
<reinhard> erm i mean
<reinhard> ! useParameters is expected to phase out
<btami> ok, i will change interbase scripter to use varchar (32000) if no length defined in .gsd
<reinhard> btami: thanks
<btami> reinhard: thanks
<btami> bbl
*** btami has quit IRC
*** jcater has joined #gnuenterprise
*** reinhard_ has joined #gnuenterprise
*** reinhard has quit IRC
<SachaS> cedmo, your still here?
<SachaS> hi reinhard_
<reinhard> hi SachaS
<SachaS> how are you?
<SachaS> getting better? no longer hoarsed?
<reinhard> yeah, getting better
<SachaS> thats good news.
*** dimas has quit IRC
*** dneighbo_ has joined #gnuenterprise
*** dneighbo has quit IRC
*** sjc has joined #gnuenterprise
<SachaS> a tool just made me very pale (of excitement)
<SachaS> http://www.brunswickwdi.com/what_is_bie
<SachaS> i installed the development version.
<SachaS> two tools: a business process engine (based on bpml (business process markup language) and a map builder (gnue message 2 ebxml message mapping made FUCKING easy)
<SachaS> business process runs ontop of jboss
<SachaS> message mapping software is a java application
<SachaS> dual licenced
<SachaS> with your project is under gpl or open source compatible then you can use the GPL licence
<SachaS> otherwise you need a commercial licence
<SachaS> you can download the code, it runs (out of the box) on my debian unstable
<SachaS> gnue-appserver needs an interface.
<SachaS> have to go to bed
*** sjc has quit IRC
*** reinhard has quit IRC
*** SachaZzz has quit IRC
*** bodhi has quit IRC
<chillywi1ly> hmmm, I was looking at BIE earlier
<chillywi1ly> it's a bit complicated though
<chillywi1ly> only supports mysql
*** SachaS has joined #gnuenterprise
*** mixi^_ has joined #gnuenterprise
*** mixi^ has quit IRC
*** dcmwai has joined #gnuenterprise
*** jcater has quit IRC
*** jcater has joined #gnuenterprise
*** nickr has quit IRC
*** nickr has joined #gnuenterprise
<SachaS> night
*** holycow has joined #gnuenterprise