-
1. Re: Test JDBC Connection fails
shawkins Nov 25, 2014 8:36 AM (in response to tomaat)You can delete the entry from the application-users.properties for your user then use the add-user script to add it back with a new password.
-
2. Re: Test JDBC Connection fails
tomaat Nov 25, 2014 10:49 AM (in response to shawkins)Thanks Steven! I have created a connection to flat file. However, i get following error when i try to preview data:
select * from "ViewModel"."table"
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 SourceModel: TEIID30481 Failed to find the Connection Factory with JNDI name PREVIEW_417d2074-3a70-4094-b6cd-e2e77d355d0c_Test1_sources_SourceModel. Please check the name or deploy the Connection Factory with specified name.
What could be the issue?
Thanks
Ahmad
-
3. Re: Test JDBC Connection fails
shawkins Nov 25, 2014 11:00 AM (in response to tomaat)Sounds like Designer did not create the data source. It should create one automatically for you.
-
4. Re: Test JDBC Connection fails
tomaat Dec 1, 2014 4:59 AM (in response to shawkins)Hi Steven,
I have not been able to solve the issue yet. Can there be some issue with my installation? I am bit puzzled!
Thanks
Ahmad
-
5. Re: Test JDBC Connection fails
rareddy Dec 1, 2014 9:41 AM (in response to tomaat)Ahmad,
Typically when you create a source model (which represents your physical data source), Designer automatically creates a connection to the data source and maintains it automatically. However sometimes it gets out of sync, or in your case did not get created for some reason. Then when you create any views on this model and try to preview you will see the above error.
The simple solution is, right click on the source model in left navigation explorer, and choose modeling -> set data source, this will either assign a existing connection or let you create a new connection. One this is set then preview will work.
Ramesh..
-
-
7. Re: Test JDBC Connection fails
rareddy Dec 2, 2014 10:03 AM (in response to tomaat)Right Click on Model -> Modeling -> Set Connection Profile (if you already have connection)
Right Click on Model -> Modeling -> Create Data Source (if you trying to create a new connection)
-
8. Re: Test JDBC Connection fails
tomaat Dec 2, 2014 10:37 AM (in response to rareddy)Hi Ramesh,
Yes, i see the both options for set connection and create data source. However, i am still getting the exception on preview data despite following your recommendations. Can i setup a session to show you my screen?
Thanks
Ahmad
-
9. Re: Test JDBC Connection fails
rareddy Dec 2, 2014 11:02 AM (in response to tomaat)Try "project -> clean" or starting the browser once to avoid sync issues.
-
10. Re: Test JDBC Connection fails
tomaat Dec 2, 2014 11:31 AM (in response to rareddy)Ramesh, i am still stuck with the error listed above. Even i created new project, connection, etc. Is there a way i can share a session with you?
-
11. Re: Test JDBC Connection fails
rareddy Dec 2, 2014 11:53 AM (in response to tomaat)Unfortunately I will not able to provide that level of support!
In the Teiid Server window, click on VDB folder and select to show "preview" VDBs, then delete all of them. Then do a project->clean, then preview.
-
12. Re: Test JDBC Connection fails
blafond Dec 2, 2014 12:39 PM (in response to rareddy)There is also a "Clear Preview Artifacts" action in the Server view when selecting a Teiid object in the tree
-
13. Re: Test JDBC Connection fails
tomaat Dec 3, 2014 5:55 AM (in response to blafond)Thanks all for the help so far. I still need more guidance. I notice that the xmi files in the model explorer carry a 'yellow alert' sign.
after i complete the 'create source model for flat file source', the xmi files are generated with this yellow alert sign as shown in the attached figure.
I have now installed both Red Hat JBoss Developer Studio 7.1.1.GA and eclipse-standard-kepler-SR2-win32. Both installations are giving me the same error.
The eap version is jboss-eap-6.3.0.Alpha and teiid version is teiid-8.9.0.CR2-jboss-dist.
Do you guys see any issue with my installation? One point i notice is that i have to provide JDBC connection credentials each time i start the Teiid instance as these are not saved permanently as shown in the attachment.
Thanks
-
14. Re: Test JDBC Connection fails
blafond Dec 3, 2014 9:18 AM (in response to tomaat)1 of 1 people found this helpfulIf you are running JBDS 7.1.1 GA, then the compatible version for Teiid Designer is 8.6 Final which officially supports up to Teiid 8.7 runtime and EAP 6.1.
We're working on a 9.0 (Luna-based release) compatible with JBDS 8.0 and Teiid 8.8 and it should be out in a couple weeks. Teiid Designer 9.1 will follow in Jan/Feb and support Teiid 8.9