Re: Regarding Database not available in Current Project

[Florian Adler]

Hi Ashok,

Here is a little article to describes how-to deal with DB not part of the 'standard' delivery.
http://minuteproject.blogspot.be/2012/07/minuteproject-with-databases.html
Could you try, and feedback?

Best regards,

Florian.

2012/7/18 Ashok Jangir <jangi...@gmail.com>

Hello There,

 

Actually I am using MS SQL and want to use this tool for that. But because of limitations(Datatbase not available) I am not able to...

Kindly help me for the same.

 

Regards

Ashok

[Florian Adler]

Hi Ashok,

Have you set the ms-sql jdbc driver in <MP_HOME>/application/lib/extra?

        <maven-artifact
           mvn-artifact-id="mssql-

connector-java"
           mvn-group-id="mssql"
           mvn-version="5.0.5" >
        </maven-artifact>

Maven information in the catalog level is used when generating pom.xml file with the correct driver. It has no impact on the generation.

When you start the console with /bin/start-console.sh/cmd you have to

• choose MSSQL
• replace the default value with your current

Could you send me some stacktrace.

Best regards,

Florian.

2012/7/18 Ashok Jangir <jangi...@gmail.com>

Hi Florian,

 

Heartly thanks for your quick response.

I am adding MS SQL and as article suggests to add enteries as following I did

 

<database name="MSSQL"
        hibernate-dialect="org.hibernate.dialect.SQLServerDialect"
        use-schema="true"
        driverclassname="net.sourceforge.jtds.jdbc.Driver"
        default-url-structure="jdbc:jtds:sqlserver://{server-name}:${port-number}/{database-name}" >
  
        <maven-artifact
           mvn-artifact-id="mssql-connector-java"
           mvn-group-id="mssql"
           mvn-version="5.0.5" >
        </maven-artifact> 
        <primary-key-policy type="autoincrement"/>           
  </database>

 

 Its not working.

This maven-artifact I am not using so kindly suggest me how I should replace the same.

And if any other required attribute for this server.

I am not aware with maven, I am a fresher in IT development and doing some R&D work.

 

Regards

Ashok

 

--
Thanks and Regards
Ashok Kumar

[Florian Adler]

Hi Ashok,

Yes, it loads DB metadata and generated artifacts based on templates that are located under template.
When you choose a track, the track templates to use come from /catalog/technology-catalog.xml.
technology-catalog.xml indicates which what are the different sets of artifacts to use by reference mp-template-config*.xml
Eventually mp-template-config*.xml provides the template meta-datas.

Best regards,

Florian.

2012/7/19 Ashok Jangir <jangi...@gmail.com>

Hi Florian,

I am bit confused about console input and working of your code. Does it use any template to generate end ouput which depends on database???

Thanks... Heartly... :)

On Wed, Jul 18, 2012 at 6:16 PM, Florian Adler <minute...@gmail.com> wrote:

Hi Ashok,

If you have input the MSSQL Connection params in the consolef from what I see in the console log, there is generation, so there is an output.
You can change the place where it is generated. I suggest then C:/Minuteproject so that It will not be relative to your installation.

Best regards,

Florian.

2012/7/18 Ashok Jangir <jangi...@gmail.com>

Hi Florian,

 

I tried every way... But not getting success.

Now I will try to update my driver jar and then lets see if it works...

 

On Wed, Jul 18, 2012 at 5:38 PM, Florian Adler <minute...@gmail.com> wrote:

Hi Ashok,

Normally everything is fine.
The output in <MP_HOME>/output.

>>template: DomainEntityJPA2EmbeddedId in ../output/org/REST_SpringMVC/JPA2/src/main/java

 

Best regards,

Florian.

2012/7/18 Ashok Jangir <jangi...@gmail.com>

Hi Florian,

 

I have placed my db driver and tried as per the instructions provided in your blog. Here are the console output when I try to generate my files

 

C:\Documents and Settings\ashok.kumar\Desktop\minuteProject-0.8.1\bin>start-console.cmd
0    [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: JPA set in src/main/java
0    [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: DomainEntityJPA2Annotation in ../output/org/REST_Sprin
gMVC/JPA2/src/main/java
0    [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: DomainEntityJPA2Metamodel in ../output/org/REST_Spring
MVC/JPA2/src/main/java
0    [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: DomainEntityJPA2EmbeddedId in ../output/org/REST_Sprin
gMVC/JPA2/src/main/java
0    [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: EnumerationReferenceDataJPA2 in ../output/org/REST_Spr
ingMVC/JPA2/src/main/java
0    [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: web-inf config in src/main/resources
0    [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: Persistence.xml.JPA2 in ../output/org/REST_SpringMVC/J
PA2/src/main/resources
1782 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: EhCacheXml in ../output/org/REST_SpringMVC/JPA2/src/ma
in/resources
1782 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: web-inf config in src/test/resources
1782 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: Persistence.xml.JPA2 in ../output/org/REST_SpringMVC/J
PA2/src/test/resources
1829 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: null in src-overwritten/main/resources
1829 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: MavenOverwrittenReadMe in ../output/org/REST_SpringMVC
/JPA2/src-overwritten/main/resources
1829 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: null in
1829 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: PomXml.JPA2 in ../output/org/REST_SpringMVC/JPA2/
1860 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: null in src/test/java
1860 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: TestDaoInterface in ../output/org/REST_SpringMVC/bsla/
src/test/java
1860 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: BslaDaoTestAdapter in ../output/org/REST_SpringMVC/bsl
a/src/test/java
2079 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: meta-inf config in src/test/resources
2079 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: Persistence.xml.JPA2 in ../output/org/REST_SpringMVC/b
sla/src/test/resources
2110 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: DAO Spring JPA set in src/main/java
2110 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: SDDDaoInterface in ../output/org/REST_SpringMVC/bsla/s
rc/main/java
2110 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: SDDSpringJPADao in ../output/org/REST_SpringMVC/bsla/s
rc/main/java
2110 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: null in src/test/resources
2110 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: BslaSpringDatabase in ../output/org/REST_SpringMVC/bsl
a/src/test/resources
2204 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: BslaSpringProperties in ../output/org/REST_SpringMVC/b
sla/src/test/resources
2235 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: null in src/main/java
2235 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: BslaDaoInterfaceUML in ../output/org/REST_SpringMVC/bs
la/src/main/java
2235 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: BslaJPADaoImplUML in ../output/org/REST_SpringMVC/bsla
/src/main/java
2235 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: BslaDaoInterfaceExtendedUML in ../output/org/REST_Spri
ngMVC/bsla/src/main/java
2235 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: BslaJPAExtendedDaoImplUML in ../output/org/REST_Spring
MVC/bsla/src/main/java
2235 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: config in src/main/resources
2235 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: BslaSpringConfigDaoJPA in ../output/org/REST_SpringMVC
/bsla/src/main/resources
2235 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: BslaSpringConfigDaoExtJPA in ../output/org/REST_Spring
MVC/bsla/src/main/resources
2235 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: BslaSpringConfigDaoJPA2 in ../output/org/REST_SpringMV
C/bsla/src/main/resources
2313 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: BslaSpringConfigMainBackend in ../output/org/REST_Spri
ngMVC/bsla/src/main/resources
2360 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: BslaSpringDatabase in ../output/org/REST_SpringMVC/bsl
a/src/main/resources
2407 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: BslaSpringProperties in ../output/org/REST_SpringMVC/b
sla/src/main/resources
2422 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: null in src/main/script
2422 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: SequenceSQL in ../output/org/REST_SpringMVC/bsla/src/m
ain/script
2516 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: DBSchemaDeleteOrder in ../output/org/REST_SpringMVC/bs
la/src/main/script
2532 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: InsertEnumerationSQL in ../output/org/REST_SpringMVC/b
sla/src/main/script
2563 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: null in
2563 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: PomXml.BSLA in ../output/org/REST_SpringMVC/bsla/
2610 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: REST java set in src/main/java
2610 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: SpringMVCRestController in ../output/org/REST_SpringMV
C/REST-Spring/src/main/java
2610 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: REST java SDD set in src/main/java
2610 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: SpringMVCSDDRestController in ../output/org/REST_Sprin
gMVC/REST-Spring/src/main/java
2610 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: REST web.xml config in src/main/webapp/WEB-I
NF
2625 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: WebXml.REST.BSLA in ../output/org/REST_SpringMVC/REST-
Spring/src/main/webapp/WEB-INF
2704 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: SpringMVCRestServletXml in ../output/org/REST_SpringMV
C/REST-Spring/src/main/webapp/WEB-INF
2766 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: SpringMVCRestApplicationContextXml in ../output/org/RE
ST_SpringMVC/REST-Spring/src/main/webapp/WEB-INF
2844 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: null in
2860 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: PomXml.REST.BSLA in ../output/org/REST_SpringMVC/REST-
Spring/
2922 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: null in
2922 [AWT-EventQueue-0] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: MavenMasterPomXml in ../output/org/REST_SpringMVC//

 

 

 

Even I went for only JPA2 but there also I couldn't find output. Its working with MySQL ORACLE, everything you provided. My MS SQL server is a MS SQL 2005 server. I need to generate POJO using JPA2 annotation integrated with hibernate 4.x and no. of tables is above 600. So I hope you understand why I need this.

Any help is appreceiated heartly...

 

I am using jtds-1.2.2 version jar and enteries I have already shown you. Kindly assist....

 

Thanks...

On Wed, Jul 18, 2012 at 3:27 PM, Florian Adler <minute...@gmail.com> wrote:

Hi Ashok,

If you generate from the console, just choose JPA2 in the drop down list.

The integration with Spring MVC is done in the context of REST but I do not have Spring MVC web front-end.
If you want with REST choose REST-SpringMVC.

If you want front-end very fast with intuitive navigation between entity choose OpenXava. It is for the moment the most advanced track regarding Front-end. Check some link http://minuteproject.blogspot.be/2011/06/minuteproject-4-openxava-lazuly.html it has 2 videos with it and on the wiki at http://minuteproject.wikispaces.com/OpenXava.

MP 4 Primefaces is currently reactivated and a new version will be available in next release.

Best regards,

Florian.

2012/7/18 Ashok Jangir <jangi...@gmail.com>

Hi Florian,

 

Kindly help me in one more query regarding the output of "MinuteProject" console.

 

As it can generate different kind of outputs, but I need specific for hibernate annotations using JPA,

in Spring MVC. Kindly suggest me for any sort of task I need to do.

 

Thank you again...

:)

On Wed, Jul 18, 2012 at 2:16 PM, Ashok Jangir <jangi...@gmail.com> wrote:

Hi Florian,

 

Heartly thanks for your quick response.

I am adding MS SQL and as article suggests to add enteries as following I did

 

<database name="MSSQL"
        hibernate-dialect="org.hibernate.dialect.SQLServerDialect"
        use-schema="true"
        driverclassname="net.sourceforge.jtds.jdbc.Driver"
        default-url-structure="jdbc:jtds:sqlserver://{server-name}:${port-number}/{database-name}" >
  
        <maven-artifact
           mvn-artifact-id="mssql-connector-java"
           mvn-group-id="mssql"
           mvn-version="5.0.5" >
        </maven-artifact> 
        <primary-key-policy type="autoincrement"/>           
  </database>

 

 Its not working.

This maven-artifact I am not using so kindly suggest me how I should replace the same.

And if any other required attribute for this server.

I am not aware with maven, I am a fresher in IT development and doing some R&D work.

 

Regards

Ashok

 

On Wed, Jul 18, 2012 at 1:38 PM, Florian Adler <minute...@gmail.com> wrote:

--
Thanks and Regards
Ashok Kumar

--
Thanks and Regards
Ashok Kumar

--
Thanks and Regards
Ashok Kumar

--
Thanks and Regards
Ashok Kumar