OK i was able to get it to fire up using hibernate with mssql 2019 but
it'll probably work with older versions
So add the microsoft jdbc driver to either the container's lib folder or in
juddiv3/WEB-INF/lib
in webapps/juddiv3/WEB-INF/classes/META-INF/persistence.xml
make sure hibernate.dialect is set to SQLServer2008Dialect , example:
<property name="hibernate.dialect"
value="org.hibernate.dialect.SQLServer2008Dialect"/>
in webapps/juddiv3/META-INF/context.xml
replace what ever is there for the Juddi Datasource with something similar
to this. Obviously, update it to meet your environment
<Resource name="jdbc/JuddiDS" auth="Container"
type="javax.sql.DataSource" username="juddi"
password="yourpasswordhere"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost:1433;databaseName=juddi"
maxActive="8"
/>
And for simplicity, i've updated the drop box download link to have a newer
build that is set to hibernate (several of the jar's are different from the
previous download link). I also added a simple tomcat build, following the
instructions above, it should be possible to get it up and running with
mssql.
https://www.dropbox.com/sh/k2ojoye8y2916bf/AACRJoqqI5X4zlTKBlhASjCma?dl=0
On Wed, Jul 15, 2020 at 6:42 PM Alex O'Ree <alexo...@apache.org> wrote:
> Yes, as i stated earlier, not all of the reported issues have been
> resolved. This includes the mssql configuration.
>
> On Wed, Jul 15, 2020 at 10:29 AM Rakesh Shelar <
> rakesh.she...@northgateps.com> wrote:
>
>> Alex,
>>
>> we have tested JUDDI (test) version provided by you. And we are still
>> getting the following error
>>
>> org.springframework.beans.factory.BeanCreationException: Error creating bean
>> with name 'inquiry': Cannot create inner bean '(inner bean)#46d9c49' of type
>> [org.apache.juddi.api.impl.UDDIInquiryImpl] while setting constructor
>> argument; nested exception is
>> org.springframework.beans.factory.BeanCreationException: Error creating bean
>> with name '(inner bean)#46d9c49': Instantiation of bean failed; nested
>> exception is org.springframework.beans.BeanInstantiationException: Failed to
>> instantiate [org.apache.juddi.api.impl.UDDIInquiryImpl]: Constructor threw
>> exception; nested exception is <openjpa-2.3.0-r422266:1540826 nonfatal
>> general error> org.apache.openjpa.persistence.PersistenceException:
>> ORA-00910: specified length too long for its datatype
>> {stmnt 1231222158 CREATE TABLE j3_binding_template (entity_key
>> VARCHAR2(255) NOT NULL, access_point_type VARCHAR2(255), access_point_url
>> VARCHAR2(4096), hosting_redirector VARCHAR2(255), service_key VARCHAR2(255)
>> NOT NULL, PRIMARY KEY (entity_key))} [code=910, state=42000]
>>
>> Regards,
>>
>> Rakesh
>>
>>
>> On Wed, 15 Jul 2020 at 04:26, Alex O'Ree <alexo...@apache.org> wrote:
>>
>>> https://www.dropbox.com/sh/k2ojoye8y2916bf/AACRJoqqI5X4zlTKBlhASjCma?dl=0
>>>
>>> Give this a shot
>>>
>>> On Tue, Jul 14, 2020 at 12:53 PM Baldip Purewal <
>>> baldip.pure...@northgateps.com> wrote:
>>>
>>>> Great thanks. If you could send a test build and I will ask the team to
>>>> try it out.
>>>>
>>>> Thanks
>>>>
>>>> On Tue, 14 Jul 2020 at 16:37, Alex O'Ree <alexo...@apache.org> wrote:
>>>>
>>>>> I can get a test build out tonight however keep in mind that not all
>>>>> of the issues that were reported have been resolved yet. The release
>>>>> process takes general takes a few days for committe vote + global
>>>>> distribution.
>>>>>
>>>>> On Tue, Jul 14, 2020 at 10:40 AM Baldip Purewal <
>>>>> baldip.pure...@northgateps.com> wrote:
>>>>>
>>>>>> Hi Alex
>>>>>>
>>>>>> Sorry to bother you again but it has become quite a serious issue and
>>>>>> if possible could you provide any dates on when we can get a test build
>>>>>> and
>>>>>> also when this would be released in the stable version (3.3.9)?
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>> On Tue, 14 Jul 2020 at 10:48, Baldip Purewal <
>>>>>> baldip.pure...@northgateps.com> wrote:
>>>>>>
>>>>>>> Will this test build contain other changes as well because ideally
>>>>>>> we would just like that change. Do you know when we can get a test build
>>>>>>> please?
>>>>>>>
>>>>>>> Thanks
>>>>>>>
>>>>>>> On Tue, 14 Jul 2020 at 10:40, Baldip Purewal <
>>>>>>> baldip.pure...@northgateps.com> wrote:
>>>>>>>
>>>>>>>> Hi
>>>>>>>>
>>>>>>>> Could you provide a test build as soon as possible please?
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>>
>>>>>>>> On Sat, 11 Jul 2020 at 02:14, Alex O'Ree <alexo...@apache.org>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> JUDDI-999 similar problem, similar fix. Testing it now. Will be
>>>>>>>>> fixed in the next version. I can provide a test build if you like or
>>>>>>>>> you
>>>>>>>>> can also compile from source if you all are so equiped
>>>>>>>>>
>>>>>>>>> On Wed, Jul 8, 2020 at 10:12 PM Alex O'Ree <alexo...@apache.org>
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> Strange, I thought this was fixed. I'll take a look at this
>>>>>>>>>> shortly. I think the fix is to use a blob data type for the this
>>>>>>>>>> field
>>>>>>>>>>
>>>>>>>>>> On Wed, Jul 8, 2020 at 6:14 AM Rakesh Shelar <
>>>>>>>>>> rakesh.she...@northgateps.com> wrote:
>>>>>>>>>>
>>>>>>>>>>> HI,
>>>>>>>>>>>
>>>>>>>>>>> We are looking for support on the following juddiv3 issue we are
>>>>>>>>>>> facing on the startup of juddiv3 Tomcat.
>>>>>>>>>>>
>>>>>>>>>>> Oracle Version of Juddi Due to string limit for a column CREATE
>>>>>>>>>>> TABLE j3_binding_template (entity_key VARCHAR2(255) NOT NULL,
>>>>>>>>>>> access_point_type VARCHAR2(255), access_point_url VARCHAR2(4096),
>>>>>>>>>>> hosting_redirector VARCHAR2(255), service_key VARCHAR2(255) NOT
>>>>>>>>>>> NULL,
>>>>>>>>>>> PRIMARY KEY (entity_key)) *Oracle max varchar limit: 4000*
>>>>>>>>>>>
>>>>>>>>>>> We have installed JUDDI 3.3.8 with Oracle 12c ,
>>>>>>>>>>> OpenJDK11Hotspot, & Tomcat 9.0.24
>>>>>>>>>>>
>>>>>>>>>>> Refer -
>>>>>>>>>>>
>>>>>>>>>>> http://juddi.apache.org/jacoco/juddi-core-openjpa/jacoco-ut/org.apache.juddi.model/BindingTemplate.java.html
>>>>>>>>>>>
>>>>>>>>>>> [image: image.png]
>>>>>>>>>>>
>>>>>>>>>>> Any suggestions?
>>>>>>>>>>>
>>>>>>>>>>> Regards,
>>>>>>>>>>> Rakesh Shelar
>>>>>>>>>>> Sr. Technical Architect - CONNECT (DevOps)
>>>>>>>>>>> Mobile: +91 (0) 8657549870
>>>>>>>>>>> +44 7435826126
>>>>>>>>>>> www.northgateps.com
>>>>>>>>>>>
>>>>>>>>>>> Follow us on: Twitter <https://twitter.com/NorthgatePS> /
>>>>>>>>>>> LinkedIn
>>>>>>>>>>> <https://www.linkedin.com/company/northgate-public-services> /
>>>>>>>>>>> YouTube
>>>>>>>>>>> <https://www.youtube.com/channel/UCugGoGM2tNBGBWi_VDWUBpQ> /
>>>>>>>>>>> Google+
>>>>>>>>>>> <https://plus.google.com/+Northgateps?_ga=1.144512117.1518730136.1448468474>
>>>>>>>>>>>
>>>>>>>>>>> Northgate Public Services (UK) Ltd
>>>>>>>>>>>
>>>>>>>>>>> This email is sent on behalf of Northgate Public Services (UK)
>>>>>>>>>>> Limited and its associated companies including Rave Technologies
>>>>>>>>>>> (India)
>>>>>>>>>>> Pvt Limited (together "Northgate Public Services") and is strictly
>>>>>>>>>>> confidential and intended solely for the addressee(s).
>>>>>>>>>>> If you are not the intended recipient of this email you must:
>>>>>>>>>>> (i) not disclose, copy or distribute its contents to any other
>>>>>>>>>>> person nor
>>>>>>>>>>> use its contents in any way or you may be acting unlawfully; (ii)
>>>>>>>>>>> contact
>>>>>>>>>>> Northgate Public Services immediately on +44(0)1442 768445 quoting
>>>>>>>>>>> the name of the sender and the addressee then delete it from your
>>>>>>>>>>> system.
>>>>>>>>>>> Northgate Public Services has taken reasonable precautions to
>>>>>>>>>>> ensure that no viruses are contained in this email, but does not
>>>>>>>>>>> accept any
>>>>>>>>>>> responsibility once this email has been transmitted. You should
>>>>>>>>>>> scan
>>>>>>>>>>> attachments (if any) for viruses.
>>>>>>>>>>>
>>>>>>>>>>> Northgate Public Services (UK) Limited, registered in England
>>>>>>>>>>> and Wales under number 00968498 with a registered address of
>>>>>>>>>>> Peoplebuilding
>>>>>>>>>>> 2, Peoplebuilding Estate, Maylands Avenue, Hemel Hempstead,
>>>>>>>>>>> Hertfordshire,
>>>>>>>>>>> HP2 4NW. Rave Technologies (India) Pvt Limited, registered in
>>>>>>>>>>> India under number U31900MH1998PTC117068 with a registered
>>>>>>>>>>> address of PLOT CS 445, 3 rd Floor, A-wing Madhu Corporate Park
>>>>>>>>>>> Ltd, Pandurang Budhkar Marg, Mumbai -400013
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>>
>>>>>>>> *Bal Purewal*
>>>>>>>> Lead DevOps Architect
>>>>>>>> Northgate Public Services
>>>>>>>> 2 Peoplebuilding Estate
>>>>>>>> Hemel Hempstead Industrial Estate
>>>>>>>> Hemel Hempstead
>>>>>>>> Hertfordshire HP2 4NW
>>>>>>>> Mobile: 07876038577
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> *Bal Purewal*
>>>>>>> Lead DevOps Architect
>>>>>>> Northgate Public Services
>>>>>>> 2 Peoplebuilding Estate
>>>>>>> Hemel Hempstead Industrial Estate
>>>>>>> Hemel Hempstead
>>>>>>> Hertfordshire HP2 4NW
>>>>>>> Mobile: 07876038577
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>>
>>>>>> *Bal Purewal*
>>>>>> Lead DevOps Architect
>>>>>> Northgate Public Services
>>>>>> 2 Peoplebuilding Estate
>>>>>> Hemel Hempstead Industrial Estate
>>>>>> Hemel Hempstead
>>>>>> Hertfordshire HP2 4NW
>>>>>> Mobile: 07876038577
>>>>>>
>>>>>> This email is sent on behalf of Northgate Public Services (UK)
>>>>>> Limited and its associated companies including Rave Technologies (India)
>>>>>> Pvt Limited (together "Northgate Public Services") and is strictly
>>>>>> confidential and intended solely for the addressee(s).
>>>>>> If you are not the intended recipient of this email you must: (i) not
>>>>>> disclose, copy or distribute its contents to any other person nor use its
>>>>>> contents in any way or you may be acting unlawfully; (ii) contact
>>>>>> Northgate Public Services immediately on +44(0)1442 768445 quoting
>>>>>> the name of the sender and the addressee then delete it from your system.
>>>>>> Northgate Public Services has taken reasonable precautions to ensure
>>>>>> that no viruses are contained in this email, but does not accept any
>>>>>> responsibility once this email has been transmitted. You should scan
>>>>>> attachments (if any) for viruses.
>>>>>>
>>>>>> Northgate Public Services (UK) Limited, registered in England and
>>>>>> Wales under number 00968498 with a registered address of Peoplebuilding
>>>>>> 2,
>>>>>> Peoplebuilding Estate, Maylands Avenue, Hemel Hempstead, Hertfordshire,
>>>>>> HP2
>>>>>> 4NW. Rave Technologies (India) Pvt Limited, registered in India
>>>>>> under number U31900MH1998PTC117068 with a registered address of PLOT
>>>>>> CS 445, 3 rd Floor, A-wing Madhu Corporate Park Ltd, Pandurang Budhkar
>>>>>> Marg, Mumbai -400013
>>>>>>
>>>>>
>>>>
>>>> --
>>>>
>>>> *Bal Purewal*
>>>> Lead DevOps Architect
>>>> Northgate Public Services
>>>> 2 Peoplebuilding Estate
>>>> Hemel Hempstead Industrial Estate
>>>> Hemel Hempstead
>>>> Hertfordshire HP2 4NW
>>>> Mobile: 07876038577
>>>>
>>>> This email is sent on behalf of Northgate Public Services (UK) Limited
>>>> and its associated companies including Rave Technologies (India) Pvt
>>>> Limited (together "Northgate Public Services") and is strictly confidential
>>>> and intended solely for the addressee(s).
>>>> If you are not the intended recipient of this email you must: (i) not
>>>> disclose, copy or distribute its contents to any other person nor use its
>>>> contents in any way or you may be acting unlawfully; (ii) contact
>>>> Northgate Public Services immediately on +44(0)1442 768445 quoting the
>>>> name of the sender and the addressee then delete it from your system.
>>>> Northgate Public Services has taken reasonable precautions to ensure
>>>> that no viruses are contained in this email, but does not accept any
>>>> responsibility once this email has been transmitted. You should scan
>>>> attachments (if any) for viruses.
>>>>
>>>> Northgate Public Services (UK) Limited, registered in England and Wales
>>>> under number 00968498 with a registered address of Peoplebuilding 2,
>>>> Peoplebuilding Estate, Maylands Avenue, Hemel Hempstead, Hertfordshire, HP2
>>>> 4NW. Rave Technologies (India) Pvt Limited, registered in India under
>>>> number U31900MH1998PTC117068 with a registered address of PLOT CS 445,
>>>> 3 rd Floor, A-wing Madhu Corporate Park Ltd, Pandurang Budhkar Marg, Mumbai
>>>> -400013
>>>>
>>>
>>
>> --
>> Rakesh Shelar
>> Sr. Technical Architect - CONNECT (DevOps)
>> Mobile: +91 (0) 8657549870
>> +44 7435826126
>> www.northgateps.com
>>
>> Follow us on: Twitter <https://twitter.com/NorthgatePS> / LinkedIn
>> <https://www.linkedin.com/company/northgate-public-services> / YouTube
>> <https://www.youtube.com/channel/UCugGoGM2tNBGBWi_VDWUBpQ> / Google+
>> <https://plus.google.com/+Northgateps?_ga=1.144512117.1518730136.1448468474>
>>
>> Northgate Public Services (UK) Ltd
>>
>> This email is sent on behalf of Northgate Public Services (UK) Limited
>> and its associated companies including Rave Technologies (India) Pvt
>> Limited (together "Northgate Public Services") and is strictly confidential
>> and intended solely for the addressee(s).
>> If you are not the intended recipient of this email you must: (i) not
>> disclose, copy or distribute its contents to any other person nor use its
>> contents in any way or you may be acting unlawfully; (ii) contact
>> Northgate Public Services immediately on +44(0)1442 768445 quoting the
>> name of the sender and the addressee then delete it from your system.
>> Northgate Public Services has taken reasonable precautions to ensure that
>> no viruses are contained in this email, but does not accept any
>> responsibility once this email has been transmitted. You should scan
>> attachments (if any) for viruses.
>>
>> Northgate Public Services (UK) Limited, registered in England and Wales
>> under number 00968498 with a registered address of Peoplebuilding 2,
>> Peoplebuilding Estate, Maylands Avenue, Hemel Hempstead, Hertfordshire, HP2
>> 4NW. Rave Technologies (India) Pvt Limited, registered in India under
>> number U31900MH1998PTC117068 with a registered address of PLOT CS 445, 3
>> rd Floor, A-wing Madhu Corporate Park Ltd, Pandurang Budhkar Marg, Mumbai
>> -400013
>>
>
