[tofranklu]

Dear all,
I am getting the exception when using CRUD on SQL Server,
I am using jdbc4 driver from microsoft,
(Microsoft JDBC Driver 4.0 for SQL Server)

Sql Server is : 10.50.1600

MyEclipse Info:
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=zh_TW
Command-line arguments: -os win32 -ws win32 -arch x86

The detail message looks following,

Any advise would be highly appreciated,

Thanks,
F.

==================================================
java.lang.RuntimeException: Error invoking function: initializeCrud with parameters: [Ljava.lang.Object;@1daee00
at org.skyway.core.generate.snippet.function.FunctionInvoker.invoke(FunctionInvoker.java:102)
at org.skyway.core.generate.snippet.function.FunctionSnippetExpression.evaluate(FunctionSnippetExpression.java:26)
at org.skyway.core.generate.snippet.SnippetRegistry.evaluate(SnippetRegistry.java:88)
at org.skyway.core.generate.snippet.SnippetRegistry.getObjectAttribute(SnippetRegistry.java:99)
at org.skyway.core.generate.generator.invoke.InvokeSnippetGenerator.generate(InvokeSnippetGenerator.java:24)
at org.skyway.core.generate.generator.DescendantGenerator.generateChild(DescendantGenerator.java:28)
at org.skyway.core.generate.generator.DescendantGenerator.generateChildren(DescendantGenerator.java:21)
at org.skyway.core.generate.generator.DescendantGenerator.generate(DescendantGenerator.java:14)
at org.skyway.core.generate.generator.control.ResourceGenerator.generate(ResourceGenerator.java:19)
at org.skyway.core.generate.execute.GenerationJob.generate(GenerationJob.java:115)
at org.skyway.core.generate.execute.GenerationJob$1.run(GenerationJob.java:59)
at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2344)
at org.skyway.core.generate.execute.GenerationJob.run(GenerationJob.java:55)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: org.eclipse.core.runtime.OperationCanceledException: Unable to scaffold because no data type inputs were provided. See the error log for more details.
at com.skyway.scaffolding.crud.util.ContextAwareCrudFunctions.getDataTypes(ContextAwareCrudFunctions.java:184)
at com.skyway.scaffolding.crud.util.ContextAwareCrudFunctions.initializeCrud(ContextAwareCrudFunctions.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.skyway.core.generate.snippet.function.FunctionInvoker.invoke(FunctionInvoker.java:94)
… 13 more

[support-pradeep]

tofranklu,

Sorry that you are seeing this issue. It looks like the error is due to a particular data type that may be causing an error during the generation.

1) Can you please share your MyEclipse installation details from MyEclipse (menu) > Installation summary > Installation details ?

2) To help us replicate the issue at our end, can you please copy paste the schema of the tables you are working on ?

[tofranklu]

Hello Support,
Thanks for your feedback,
Pls find the following for installation details,
(* Not sure if it matters about the PK/INDEX/Data Constraint as shown in attached.)

PLS advise,

Tks,
FRank

==========================
MyEclipse for Spring 10 (Profile) 2.0.0.0000000001 com.poweredbypulse.profile-0-rb-5665752-1381159974954 null
Desktop Utilities for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.desktop.feature.group Genuitec, LLC
Eclipse CVS Client 1.3.100.v20110520-0800-7B78FHl9VF7BD7KBM4GP9C org.eclipse.cvs.feature.group Eclipse.org
Eclipse Java Development Tools 3.7.2.v20120120-1414-7z8gFcuFMP7BW5XTz0jLTnz0l9B1 org.eclipse.jdt.feature.group Eclipse.org
Eclipse Platform 3.7.2.v20120207-1839-9gF7UHPDFxGjd-PqDr2jX_4yKaumkoHTz04_q-q org.eclipse.platform.feature.group Eclipse.org
Eclipse Plug-in Development Environment 3.7.2.v20120120-1420-7b7rFUOFEx2Xnqafnpz0E–0 org.eclipse.pde.feature.group Eclipse.org
Eclipse RCP 3.7.2.v20120120-1424-9DB5FmnFq5JCf1UA38R-kz0S0272 org.eclipse.rcp.feature.group Eclipse.org
Geronimo Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.geronimo.feature.group Genuitec, LLC
Glassfish Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.glassfish.feature.group Genuitec, LLC
Hibernate / JPA Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.persistence.feature.group Genuitec, LLC
ICEfaces AJAX and Java EE Tooling for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.icefaces.feature.feature.group Genuitec, LLC / ICEsoft Technologies, Inc.
Image Editor for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.imageeditor.feature.group Genuitec, LLC
JavaServer Faces Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.jsf.feature.group Genuitec, LLC
JBoss Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.jboss.feature.group Genuitec, LLC
Jetty Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.jetty.feature.group Genuitec, LLC
JOnAS Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.jonas.feature.group Genuitec, LLC
JRun Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.jrun.feature.group Genuitec, LLC
Maven Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.maven.feature.group Genuitec, LLC
MyEclipse Database Tools 10.6.0.me201207261914 com.genuitec.myeclipse.database.feature.group Genuitec, LLC
MyEclipse Enterprise Workbench 10.6.0.me201207261914 com.genuitec.myeclipse.enterprise.workbench.feature.group Genuitec, LLC
MyEclipse for Spring 10.6.0.201208211643 com.skyway.myeclipseforspring.feature.feature.group Skyway Software, Inc.
MyEclipse for Spring 10.0.0.20111114175256 pulse.com.skyway.myeclipseforspring.product.group null
MyEclipse IE JavaScript Debugger 10.6.0.me201207261914 com.genuitec.myeclipse.iedebugger.feature.group Genuitec, LLC
MyEclipse Reports 10.6.0.me201207261914 com.genuitec.myeclipse.reports.feature.group Genuitec, LLC
MyEclipse Required Components 10.6.0.me201207261914 com.genuitec.myeclipse.editor.feature.group Genuitec, LLC
MyEclipse UML 1 / 2 Visual Design Tools 10.6.0.me201207261914 com.genuitec.myeclipse.uml2.feature.group Genuitec, LLC
MyEclipse Visual Swing Designer 10.6.0.me201207261914 com.genuitec.myeclipse.matisse.feature.group Genuitec, LLC
MyEclipse VisualVM Profiler 10.6.0.me201207261914 com.genuitec.myeclipse.visualvm.feature.group Genuitec, LLC
MyEclipse VisualVM Profiler Server Support 10.6.0.me201207261914 com.genuitec.myeclipse.visualvm.server.feature.group Genuitec, LLC
Oracle Server Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.oracle.feature.group Genuitec, LLC
Orion Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.orion.feature.group Genuitec, LLC
Pulse Client Services with Drop-ins Support (Eclipse 3.7) 4.4.0.v201209051340 com.genuitec.pulse2.client.targetcfg.dropins.e37.feature.group Genuitec, LLC
Resin Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.resin.feature.group Genuitec, LLC
Spring Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.spring.feature.group Genuitec, LLC
Struts Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.struts.feature.group Genuitec, LLC
Sun App Server Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.sun.feature.group Genuitec, LLC
tc Server Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.tcserver.feature.group Genuitec, LLC
Tomcat Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.tomcat.feature.group Genuitec, LLC
Web Services Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.ws.feature.group Genuitec, LLC
WebLogic Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.weblogic.feature.group Genuitec, LLC
WebSphere Support for MyEclipse 10.6.0.me201207261914 com.genuitec.myeclipse.websphere.feature.group Genuitec, LLC

=====================================================

Attachments:

You must be logged in to view attached files.

[support-pradeep]

FRank,

Sorry, the details you sent doesn’t help us much. Can you please answer the below queries :

1) Please share your MyEclipse installation details from MyEclipse (menu) > Installation summary > Installation details ?

2) Instead of attaching the image of your DB table, can you please copy paste the schema of the tables you are working on ?

[tofranklu]

*** Date:
2013年11月26 04時10分18秒 CST

*** System properties:
OS=WindowsVista
OS version=6.1.0
OS arch=x86
Profile arch=x86
Window system=win32
Java version=1.6.0_13
Workspace=file:/C:/Users/Frank/Documents/EclipseProjects/
VM Args=-Xmx512m
-XX:MaxPermSize=256m
-XX:ReservedCodeCacheSize=64m
-Dosgi.nls.warnings=ignore
-Djava.class.path=F:\MYESLI~1\MYECLI~1\../Common/plugins/ORB7B5~1.JAR

*** Subscription information
Product Id: E3MS (MyEclipse for Spring Subscription)
License version: 3.0
Full Maintenance Included
Subscription expiration date (YYYYMMDD): 20131208
Number of users: 1

*** Eclipse details:
MyEclipse for Spring

Version: 10.6.0

Build ID: 10.6.0-20120831

Blueprint: MyEclipse for Spring 10

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-showsplash
-launcher
F:\Myeslipse4Spring\MyEclipse for Spring 10\myeclipseforspring.exe
-name
Myeclipseforspring
–launcher.library
F:\Myeslipse4Spring\MyEclipse for Spring 10\../Common/plugins/org.eclipse.equinox.launcher.i18n.win32.win32.x86_4.2.0.v201201111650\eclipse_4201.dll
-startup
F:\Myeslipse4Spring\MyEclipse for Spring 10\../Common/plugins/org.eclipse.equinox.launcher_1.2.0.v20110502.jar
-install
F:\Myeslipse4Spring\MyEclipse for Spring 10
-configuration
F:\Myeslipse4Spring\MyEclipse for Spring 10\configuration
-vm
F:\Myeslipse4Spring\Common\binary\com.sun.java.jdk.win32.x86_1.6.0.013\jre\bin\client\jvm.dll
=============================

USE [Ticketing_Ack]
GO

/****** Object: Table [dbo].[Ticket] Script Date: 11/26/2013 16:31:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Ticket](
[Validation_Code] [varchar](72) NOT NULL,
[Print_Date] [datetime] NOT NULL,
[Active_Date] [datetime] NOT NULL,
[Ticket_State] [int] NOT NULL,
[Ticket_Type] [int] NOT NULL,
[Validation_Type] [int] NULL,
[Validation_by] [int] NULL,
[Paid_Date] [datetime] NULL,
[Audit_Paid] [int] NOT NULL,
[Validation_Id] [int] NOT NULL,
[Ticket_Amt] [numeric](14, 2) NOT NULL,
[Mch_Id] [int] NOT NULL,
[Last_State_Change] [datetime] NULL,
[Mch_TKT_Seq] [int] NOT NULL,
[Original_TKT_State] [int] NOT NULL,
[ExpireDate] [datetime] NOT NULL,
[PrintFlag] [int] NULL,
[LastFourValicationCode] [char](4) NOT NULL,
[TKTPrintTime] [datetime] NULL,
[LastModifyTime] [datetime] NOT NULL,
[DuplicateTicketIndex] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED
(
[Validation_Code] ASC,
[DuplicateTicketIndex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BIGTABLE]
) ON [BIGTABLE]

GO

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The ticket transaction validation code.(AES Crypt)’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Validation_Code’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The date time of print ticket.’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Print_Date’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The datetime of the ticket change to validation.()’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Active_Date’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The ticket state.’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Ticket_State’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The type of printed ticket. 0 : Normal Ticket; 1 : Restrict Ticket; 2 : Later ticket.’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Ticket_Type’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’It shows the previous ticket state after validing ticket.’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Validation_Type’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The machine or workstation which valids ticket.’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Validation_by’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The date time of paid ticket.’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Paid_Date’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’1:supervisor paid; 0 no.’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Audit_Paid’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The Validation Id of machine or workstation which vailds ticket.()’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Validation_Id’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The amount of ticket.’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Ticket_Amt’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The workstation Id or machine number which vailds ticket.’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Mch_Id’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The date time of last change ticket state.’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Last_State_Change’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The sequence number of ticket of certain workstation or machine.’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Mch_TKT_Seq’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The previous ticket state.’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’Original_TKT_State’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The ticket expire date.’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’ExpireDate’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N'(No use by James)’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’PrintFlag’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’XXXX’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’LastFourValicationCode’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N'(No use by James)’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’TKTPrintTime’
GO

EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’The last modify time.’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’Ticket’, @level2type=N’COLUMN’,@level2name=N’LastModifyTime’
GO

ALTER TABLE [dbo].[Ticket] ADD CONSTRAINT [DF_Ticket_Active_Date] DEFAULT (‘1990/1/1’) FOR [Active_Date]
GO

ALTER TABLE [dbo].[Ticket] ADD CONSTRAINT [DF_Ticket_Ticket_Type] DEFAULT ((0)) FOR [Ticket_Type]
GO

ALTER TABLE [dbo].[Ticket] ADD CONSTRAINT [DF_Ticket_Audit_Paid] DEFAULT ((0)) FOR [Audit_Paid]
GO

ALTER TABLE [dbo].[Ticket] ADD CONSTRAINT [DF_Ticket_LastFourValicationCode] DEFAULT (‘0000’) FOR [LastFourValicationCode]
GO

ALTER TABLE [dbo].[Ticket] ADD CONSTRAINT [DF_Ticket_LastModifyTime] DEFAULT (getdate()) FOR [LastModifyTime]
GO

ALTER TABLE [dbo].[Ticket] ADD DEFAULT ((0)) FOR [DuplicateTicketIndex]
GO

[support-pradeep]

FRank,

Thanks for the details provided.

We could replicate the issue at our end with Microsoft JDBC driver. There seems to be a problem with Microsoft’s driver.

As an alternative, try spring CRUD scaffolding with the JTDS driver instead of JDBC driver. we have tested CRUD for SqlServer with JDTS driver, and is working without any issues.

Take a look at this thread which discusses the same problem –
http://www.sqlpower.ca/forum/posts/list/2561.page

Let us know how it works for you.

[Author]

Posts