[skassam]

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.

[davemeurer]

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

[skassam]

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.

[skassam]

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

[rgirona]

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

[skassam]

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

[davemeurer]

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

[skassam]

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

[davemeurer]

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

[rgirona]

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]

[davemeurer]

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

[rgirona]

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

[davemeurer]

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

[rgirona]

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