Re: [Scaffoldhunter-users] query

[Prateek G. <pra...@gm...>]

hi,
regarding to the problems in bit operations, I did not intend to solve the
impedance mismatch problem.This is already solved by hibernate. What I
intend to say is that out of the current databases that are used in the
software (hsqldb , mysql).
There is a problem in the *dialect.java files in the
hibernate-core/src/main/java/org/hibernate/dialect.
 I found that "bit" suffers problem in mysql but with hsql it functions
proper if "bit" is mapped to boolean.
Hence one method of solving such problem for mysql or any database would be
creation of either native sql procedures or changing the queries in the
hibernate/jpa folder and implementing bit datatype in the dialect of that
database in hibernate

Could you help me figure out?
regards,
Prateek


On Sun, Apr 28, 2013 at 4:55 PM, Prateek Gupta
<pra...@gm...>wrote:

> hi,
> regarding to the changes in the jchempaint algo
> 1)instead of using the shell calls , I can implement process builder and
> provide the class path within the directory of this process builder and
> initiate it. This would run the jchempaint.
> 2)Regarding the saving the file issue. I can call the getMolFile()
> function in the jchempaint and receive an object of the current query
> structure in the editor. The filter rules as you said can be stored in the
> user profile as you said.
>
> Is this fine enough?
> Regards,
> Prateek
>
>
> On Sun, Apr 28, 2013 at 4:41 PM, <nl...@us...> wrote:
>
>> Hi Prateek,
>>
>> please see my reply to your previous mail regarding the filtering based on
>> bit-operations. Native MySQL queries should work, but we would like not
>> to be
>> restricted to a MySQL database if possible.
>>
>>
>> Regards,
>>   Nils
>>
>> On Sunday 28 April 2013 02:47:40 Prateek Gupta wrote:
>> > Hi,
>> > I have figured out another method to debug the mysql specific query
>> problem
>> > in hibernate.
>> > This method intends to identify the bit related operators and
>> operations.
>> > Then add sql functions in the mysql5dialect
>> >  java code in hibenate module that would map to these operators or
>> > operations. This would be able to solve the queries.
>> > But still if there arises some exceptional problems then working around
>> > with the development of native mysql queries
>> > in hibernate would also be a backup option. These queries can also be
>> named
>> > separately if required.
>> > So if you could help me review the methods and direct me to the right
>> path.
>> > Regards,
>> > Prateek
>>
>>
>