Scaffold Spring CRUD Application Error Log

MyEclipse IDE

Spring Development

This topic has 13 replies, 3 voices, and was last updated 13 years, 5 months ago by rgirona.

Viewing 14 posts - 1 through 14 (of 14 total)

Author

Posts
November 8, 2010 at 11:06 am #312538 Reply

skassam
Member

I have 1 table that nothing gets created no domain, service, or dao. Is there an error log for the Scaffold Spring CRUD wizard where I can see what is failing.

I have other tables that work fine. Something else is wrong and I am trying to narrow it down.

Thanks.

November 8, 2010 at 12:11 pm #312539 Reply

davemeurer
Member

Hi,

If any errors occur, it will be in the Error Log View (Window > Show View… > Error Log).

If no errors occur, please feel free to send the schema or a sample schema plus the database type and we can take a look.

Kind regards,
Dave

November 8, 2010 at 12:56 pm #312541 Reply
skassam
Member
Thanks Dave. There are no errors. This is a SQLAnywhere 12 database. The schema is below:
```
CREATE TABLE "MyTable" (
    "id" INTEGER NOT NULL,
    "LastXTime" TIMESTAMP NULL,
    "LastYTime" TIMESTAMP NULL,
    "LastZTime" TIMESTAMP NULL,
    PRIMARY KEY ( "id" ASC )
) IN "SYSTEM";
```
Thanks for any help.
November 8, 2010 at 12:59 pm #312542 Reply

skassam
Member

More information: The files in src/main/resources are created but no src/main/java files are created

November 8, 2010 at 1:10 pm #312543 Reply

rgirona
Member

Regarding the problem reported by skassam, I have just experienced the same problem. On a windows 7 platform, using:

mysql 5.1
mysql-connector-java-5.1.13-bin.jar
myeclipse for spring 8.6

I am able to connect with the DB browser, and to browse the mysql tables, but when using the CRUD scaffolding it generates no code under source folder generated or classes. Even the file ????-dao.properties is empty.

The process show no error message, neither the error log . Meanwhile, the example CustomerApp in MyEclipse tutorial with Derby ClassicCars table works pretty well.

Pls if you have any hint let us know, maybe both issues are interconnected. I can provide a very simple mysql database (backup) with a couple of records, if anyone wants to make a try.

Thank you very much

RamÃ³n Girona

November 8, 2010 at 1:12 pm #312544 Reply

skassam
Member

I am also on Windows 7 32-bit and using myeclipse for spring 8.6.1

November 8, 2010 at 2:44 pm #312551 Reply

davemeurer
Member

Hi RamÃ³n,

Please do post one of the table schemas you are trying to scaffold.

One issue that we’ve seen with MS SQL Server with the same symptom is that the DB connection string has a different schema then what is chosen in the Scaffolding wizard.

Also, we’ve seen issues with dates in oracle.

skassam,
Do the other tables that work have timestamps? Also, please let me know which SQLAnywhere driver you are using.

Kind regards,
Dave

November 8, 2010 at 2:55 pm #312552 Reply

skassam
Member

Yes, I have other tables with timestamps. I am using a type 1 driver from Sybase jodbc4.jar

November 8, 2010 at 3:04 pm #312553 Reply

davemeurer
Member

Thanks – I’ll try to reproduce and let you know what I find out.

November 8, 2010 at 4:08 pm #312555 Reply

rgirona
Member

Hi Dave,

Herewith find attached the schema of the table components of sunkitty:

CREATE TABLE IF NOT EXISTS `sunkitty`.`componentes` (
`idComponente` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`strTipoComponente` VARCHAR(45) CHARACTER SET ‘latin1’ COLLATE ‘latin1_spanish_ci’ NOT NULL ,
`strBrand` VARCHAR(45) CHARACTER SET ‘latin1’ COLLATE ‘latin1_spanish_ci’ NULL DEFAULT NULL ,
`strModel` VARCHAR(45) CHARACTER SET ‘latin1’ COLLATE ‘latin1_spanish_ci’ NOT NULL ,
`strFabricante` VARCHAR(100) CHARACTER SET ‘latin1’ COLLATE ‘latin1_spanish_ci’ NOT NULL ,
`intPhases` INT(11) NOT NULL ,
`intMaxStrings` INT(11) NOT NULL ,
`flPAC` FLOAT NOT NULL ,
`flPDCmax` FLOAT NOT NULL ,
`flVMPPMin` FLOAT NOT NULL ,
`bTransformador` TINYINT(1) NOT NULL ,
PRIMARY KEY (`idComponente`) )

The database is mysql.

Thanks very much,

RamÃ³n[/img]

November 9, 2010 at 10:18 am #312570 Reply

davemeurer
Member

skassam,
I’m still getting my SQLAnywhere setup right, and hope to have a reply on it by the end of the day.

RamÃ³n,
I was able to create the table in MySQL and scaffold Spring MVC successfully. I am using MyEclipse for Spring 8.6.1. Would you be able to elaborate which front end you are choosing? Does any other table scaffold in that schema successfully?

Kind regards,
Dave

November 9, 2010 at 11:57 am #312573 Reply

rgirona
Member

Hi Dave,

If you mean by frontend web client type, this is the MVC, as in your case.
I checked with 3 different tables, 2 like the one I sent to you (components and proposal) and another one (proposal line), with foreign keys pointing to components and proposal. I don’t know if the relationship may cause the issue. I may try with the database with only one table. By the way, what version of mysql are you using?

In the meantime I may provide you also screenshots or whatever other media material that may help to fix the problem.

Thanks very much,

RamÃ³n

November 9, 2010 at 1:31 pm #312578 Reply

davemeurer
Member

Hi skassam,

I wasn’t able to reproduce your issue either. I want to make sure we are doing the same things. I did install a SQLAnywhere 12 db server. Created a database called “skyway”, and executed the create table you sent above.

My connection in the MyEclipse DB browser looks like the following, where I’m using the iAnywhere JDBC driver (via creating an ODBC driver). Is this how you are configuring your connection?

Kind regards,
Dave

November 9, 2010 at 5:26 pm #312584 Reply

rgirona
Member

Hi Dave,

I have tried creating a couple of new schemas/databases more, using first one table, then 2, 3 and relationships b/w them and it works perfectly well. My mistake was in the Connection URL: jdbc:mysql://localhost:3306/sunkitty, where sunkitty is the dbname and I missed it in the connection string.

Thanks very much and good luck skassam[/img]
Author

Posts

Viewing 14 posts - 1 through 14 (of 14 total)